File name
Commit message
Commit date
File name
Commit message
Commit date
File name
Commit message
Commit date
File name
Commit message
Commit date
# --- !Ups
create table recent_project (
id bigint auto_increment not null,
user_id bigint,
owner varchar(255),
project_id bigint,
project_name varchar(255),
constraint pk_recent_project primary key (id),
constraint uq_recent_project_1 unique (user_id, project_id))
row_format=compressed, key_block_size=8
;
alter table recent_project add constraint fk_recent_project_project_2 foreign key (project_id) references project (id) on delete CASCADE on update CASCADE;
# --- !Downs
drop table recent_project;