forked from Lesin/reposync
16 lines
531 B
SQL
16 lines
531 B
SQL
CREATE TABLE IF NOT EXISTS sync_comment (
|
|
id INTEGER NOT NULL AUTO_INCREMENT,
|
|
issue_config_id BIGINT UNSIGNED NOT NULL,
|
|
github_comment_id VARCHAR(255),
|
|
gitee_comment_id VARCHAR(255),
|
|
gitlink_comment_id VARCHAR(255),
|
|
body_snapshot TEXT,
|
|
create_time DATETIME,
|
|
update_time DATETIME,
|
|
PRIMARY KEY (id),
|
|
UNIQUE (github_comment_id),
|
|
UNIQUE (gitee_comment_id),
|
|
UNIQUE (gitlink_comment_id),
|
|
FOREIGN KEY(issue_config_id) REFERENCES issue_config (issue_id) ON DELETE CASCADE
|
|
);
|