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 issue_sharer (
id BIGINT AUTO_INCREMENT NOT NULL,
created DATE,
login_id VARCHAR(255),
user_id BIGINT,
issue_id BIGINT,
CONSTRAINT pk_issue_sharer PRIMARY KEY (id),
CONSTRAINT fk_issue_sharer_user FOREIGN KEY (user_id) REFERENCES n4user (id) on DELETE CASCADE,
CONSTRAINT fk_issue_sharer_issue FOREIGN KEY (issue_id) REFERENCES issue (id) on DELETE CASCADE
)
row_format=compressed, key_block_size=8;
CREATE index ix_issue_sharer_login_id ON issue_sharer (login_id);
CREATE index ix_issue_sharer_user_id ON issue_sharer (user_id);
CREATE index ix_issue_sharer_issue_id ON issue_sharer (issue_id);
# --- !Downs
DROP TABLE issue_sharer;