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 favorite_project (
id BIGINT AUTO_INCREMENT NOT NULL,
user_id BIGINT,
project_id BIGINT,
owner VARCHAR(255),
project_name VARCHAR(255),
CONSTRAINT pk_favorite_project PRIMARY KEY (id),
CONSTRAINT uq_favorite_project_user_id_project_id_1 UNIQUE (user_id, project_id),
CONSTRAINT fk_favorite_project_user FOREIGN KEY (user_id) REFERENCES n4user (id) on DELETE CASCADE,
CONSTRAINT fk_favorite_project_project FOREIGN KEY (project_id) REFERENCES project (id) on DELETE CASCADE
)
row_format=compressed, key_block_size=8
;
CREATE index ix_favorite_project_user_1 ON favorite_project (user_id);
CREATE index ix_favorite_project_project_2 ON favorite_project (project_id);
CREATE TABLE favorite_organization (
id BIGINT AUTO_INCREMENT NOT NULL,
user_id BIGINT,
organization_id BIGINT,
organization_name VARCHAR(255),
CONSTRAINT pk_favorite_organization PRIMARY KEY (id),
CONSTRAINT uq_favorite_organization_user_id_organization_id_1 UNIQUE (user_id, organization_id),
CONSTRAINT fk_favorite_organization_user FOREIGN KEY (user_id) REFERENCES n4user (id) on DELETE CASCADE,
CONSTRAINT fk_favorite_organization_organization FOREIGN KEY (organization_id) REFERENCES organization (id) on DELETE CASCADE
)
row_format=compressed, key_block_size=8
;
CREATE index ix_favorite_organization_user_1 ON favorite_organization (user_id);
CREATE index ix_favorite_organization_organization_2 ON favorite_organization (organization_id);
# --- !Downs
DROP TABLE favorite_project;
DROP TABLE favorite_organization;