19 lines
521 B
MySQL
19 lines
521 B
MySQL
|
-- 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.
|