serverctl/services/db/migrations/006_add_application.sql

19 lines
521 B
MySQL
Raw Permalink Normal View History

2022-02-16 15:30:38 +01:00
-- Write your migrate up statements here
create table sctl_application
(
id int GENERATED BY DEFAULT AS IDENTITY primary key,
name varchar(30) not null,
project_id int not null,
constraint fk_project
foreign key (project_id)
REFERENCES sctl_project (id) ON DELETE CASCADE
);
---- create above / drop below ----
drop table sctl_application;
-- Write your migrate down statements here. If this migration is irreversible
-- Then delete the separator line above.