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 assignee (
id bigint auto_increment not null,
user_id bigint,
project_id bigint,
constraint pk_assignee primary key (id))
;
create table attachment (
id bigint auto_increment not null,
name varchar(255),
hash varchar(255),
container_type varchar(20),
mime_type varchar(255),
size bigint,
container_id varchar(255),
created_date datetime,
constraint ck_attachment_container_type check (container_type in ('ISSUE_POST','ISSUE_ASSIGNEE','ISSUE_STATE','ISSUE_CATEGORY','ISSUE_MILESTONE','ISSUE_LABEL','BOARD_POST','BOARD_CATEGORY','BOARD_NOTICE','CODE','MILESTONE','WIKI_PAGE','PROJECT_SETTING','SITE_SETTING','USER','USER_AVATAR','PROJECT','ATTACHMENT','ISSUE_COMMENT','NONISSUE_COMMENT','LABEL','PROJECT_LABELS','FORK','COMMIT_COMMENT','PULL_REQUEST','COMMIT','COMMENT_THREAD','REVIEW_COMMENT','ORGANIZATION','PROJECT_TRANSFER','ISSUE_LABEL_CATEGORY','WEBHOOK','NOT_A_RESOURCE')),
constraint pk_attachment primary key (id))
row_format=compressed, key_block_size=8
;
create table comment_thread (
dtype varchar(10) not null,
id bigint auto_increment not null,
author_id bigint,
author_login_id varchar(255),
author_name varchar(255),
state varchar(6),
created_date datetime,
pull_request_id bigint,
project_id bigint,
prev_commit_id varchar(255),
commit_id varchar(255),
path varchar(255),
start_side varchar(1),
start_line integer,
start_column integer,
end_side varchar(1),
end_line integer,
end_column integer,
constraint ck_comment_thread_state check (state in ('OPEN','CLOSED')),
constraint ck_comment_thread_start_side check (start_side in ('A','B')),
constraint ck_comment_thread_end_side check (end_side in ('A','B')),
constraint pk_comment_thread primary key (id))
row_format=compressed, key_block_size=8
;
create table commit_comment (
id bigint auto_increment not null,
project_id bigint,
path varchar(255),
line integer,
side varchar(1),
contents longtext,
created_date datetime,
author_id bigint,
author_login_id varchar(255),
author_name varchar(255),
commit_id varchar(255),
constraint ck_commit_comment_side check (side in ('A','B')),
constraint pk_commit_comment primary key (id))
row_format=compressed, key_block_size=8
;
create table email (
id bigint auto_increment not null,
user_id bigint,
email varchar(255),
valid tinyint(1) default 0,
token varchar(255),
constraint pk_email primary key (id))
row_format=compressed, key_block_size=8
;
create table issue (
id bigint auto_increment not null,
title varchar(255),
body longtext,
created_date datetime,
updated_date datetime,
author_id bigint,
author_login_id varchar(255),
author_name varchar(255),
project_id bigint,
number bigint,
num_of_comments integer,
state integer,
due_date datetime,
milestone_id bigint,
assignee_id bigint,
constraint ck_issue_state check (state in (0,1,2,3,4,5,6)),
constraint uq_issue_1 unique (project_id,number),
constraint pk_issue primary key (id))
row_format=compressed, key_block_size=8
;
create table issue_comment (
id bigint auto_increment not null,
contents longtext,
created_date datetime,
author_id bigint,
author_login_id varchar(255),
author_name varchar(255),
issue_id bigint,
constraint pk_issue_comment primary key (id))
row_format=compressed, key_block_size=8
;
create table issue_event (
id bigint auto_increment not null,
created datetime,
sender_login_id varchar(255),
sender_email varchar(255),
issue_id bigint,
event_type varchar(34),
old_value longtext,
new_value longtext,
constraint ck_issue_event_event_type check (event_type in ('NEW_ISSUE','NEW_POSTING','NEW_PULL_REQUEST','ISSUE_STATE_CHANGED','ISSUE_ASSIGNEE_CHANGED','PULL_REQUEST_STATE_CHANGED','NEW_COMMENT','NEW_REVIEW_COMMENT','MEMBER_ENROLL_REQUEST','PULL_REQUEST_MERGED','ISSUE_REFERRED_FROM_COMMIT','PULL_REQUEST_COMMIT_CHANGED','NEW_COMMIT','PULL_REQUEST_REVIEW_STATE_CHANGED','ISSUE_BODY_CHANGED','ISSUE_REFERRED_FROM_PULL_REQUEST','REVIEW_THREAD_STATE_CHANGED','ORGANIZATION_MEMBER_ENROLL_REQUEST','COMMENT_UPDATED')),
constraint pk_issue_event primary key (id))
row_format=compressed, key_block_size=8
;
create table issue_label (
id bigint auto_increment not null,
category_id bigint,
color varchar(255),
name varchar(255),
project_id bigint,
constraint pk_issue_label primary key (id))
row_format=compressed, key_block_size=8
;
create table issue_label_category (
id bigint auto_increment not null,
project_id bigint,
name varchar(255),
is_exclusive tinyint(1) default 0,
constraint pk_issue_label_category primary key (id))
row_format=compressed, key_block_size=8
;
create table label (
id bigint auto_increment not null,
category varchar(255),
name varchar(255),
constraint uq_label_1 unique (category,name),
constraint pk_label primary key (id))
row_format=compressed, key_block_size=8
;
create table mention (
id bigint auto_increment not null,
resource_type varchar(20),
resource_id varchar(255),
user_id bigint,
constraint ck_mention_resource_type check (resource_type in ('ISSUE_POST','ISSUE_ASSIGNEE','ISSUE_STATE','ISSUE_CATEGORY','ISSUE_MILESTONE','ISSUE_LABEL','BOARD_POST','BOARD_CATEGORY','BOARD_NOTICE','CODE','MILESTONE','WIKI_PAGE','PROJECT_SETTING','SITE_SETTING','USER','USER_AVATAR','PROJECT','ATTACHMENT','ISSUE_COMMENT','NONISSUE_COMMENT','LABEL','PROJECT_LABELS','FORK','COMMIT_COMMENT','PULL_REQUEST','COMMIT','COMMENT_THREAD','REVIEW_COMMENT','ORGANIZATION','PROJECT_TRANSFER','ISSUE_LABEL_CATEGORY','WEBHOOK','NOT_A_RESOURCE')),
constraint pk_mention primary key (id))
row_format=compressed, key_block_size=8
;
create table milestone (
id bigint auto_increment not null,
title varchar(255),
due_date datetime,
contents longtext,
state integer,
project_id bigint,
constraint ck_milestone_state check (state in (0,1,2,3,4,5,6)),
constraint uq_milestone_1 unique (project_id,title),
constraint pk_milestone primary key (id))
row_format=compressed, key_block_size=8
;
create table notification_event (
id bigint auto_increment not null,
title varchar(255),
sender_id bigint,
created datetime,
resource_type varchar(20),
resource_id varchar(255),
event_type varchar(34),
old_value longtext,
new_value longtext,
constraint ck_notification_event_resource_type check (resource_type in ('ISSUE_POST','ISSUE_ASSIGNEE','ISSUE_STATE','ISSUE_CATEGORY','ISSUE_MILESTONE','ISSUE_LABEL','BOARD_POST','BOARD_CATEGORY','BOARD_NOTICE','CODE','MILESTONE','WIKI_PAGE','PROJECT_SETTING','SITE_SETTING','USER','USER_AVATAR','PROJECT','ATTACHMENT','ISSUE_COMMENT','NONISSUE_COMMENT','LABEL','PROJECT_LABELS','FORK','COMMIT_COMMENT','PULL_REQUEST','COMMIT','COMMENT_THREAD','REVIEW_COMMENT','ORGANIZATION','PROJECT_TRANSFER','ISSUE_LABEL_CATEGORY','WEBHOOK','NOT_A_RESOURCE')),
constraint ck_notification_event_event_type check (event_type in ('NEW_ISSUE','NEW_POSTING','NEW_PULL_REQUEST','ISSUE_STATE_CHANGED','ISSUE_ASSIGNEE_CHANGED','PULL_REQUEST_STATE_CHANGED','NEW_COMMENT','NEW_REVIEW_COMMENT','MEMBER_ENROLL_REQUEST','PULL_REQUEST_MERGED','ISSUE_REFERRED_FROM_COMMIT','PULL_REQUEST_COMMIT_CHANGED','NEW_COMMIT','PULL_REQUEST_REVIEW_STATE_CHANGED','ISSUE_BODY_CHANGED','ISSUE_REFERRED_FROM_PULL_REQUEST','REVIEW_THREAD_STATE_CHANGED','ORGANIZATION_MEMBER_ENROLL_REQUEST','COMMENT_UPDATED')),
constraint pk_notification_event primary key (id))
row_format=compressed, key_block_size=8
;
create table notification_mail (
id bigint auto_increment not null,
notification_event_id bigint,
constraint pk_notification_mail primary key (id))
;
create table organization (
id bigint auto_increment not null,
name varchar(255),
created datetime,
descr varchar(255),
constraint pk_organization primary key (id))
row_format=compressed, key_block_size=8
;
create table organization_user (
id bigint auto_increment not null,
user_id bigint,
organization_id bigint,
role_id bigint,
constraint pk_organization_user primary key (id))
row_format=compressed, key_block_size=8
;
create table original_email (
id bigint auto_increment not null,
message_id varchar(255),
resource_type varchar(20),
resource_id varchar(255),
handled_date datetime,
constraint ck_original_email_resource_type check (resource_type in ('ISSUE_POST','ISSUE_ASSIGNEE','ISSUE_STATE','ISSUE_CATEGORY','ISSUE_MILESTONE','ISSUE_LABEL','BOARD_POST','BOARD_CATEGORY','BOARD_NOTICE','CODE','MILESTONE','WIKI_PAGE','PROJECT_SETTING','SITE_SETTING','USER','USER_AVATAR','PROJECT','ATTACHMENT','ISSUE_COMMENT','NONISSUE_COMMENT','LABEL','PROJECT_LABELS','FORK','COMMIT_COMMENT','PULL_REQUEST','COMMIT','COMMENT_THREAD','REVIEW_COMMENT','ORGANIZATION','PROJECT_TRANSFER','ISSUE_LABEL_CATEGORY','WEBHOOK','NOT_A_RESOURCE')),
constraint uq_original_email_message_id unique (message_id),
constraint uq_original_email_1 unique (resource_type,resource_id),
constraint pk_original_email primary key (id))
row_format=compressed, key_block_size=8
;
create table posting (
id bigint auto_increment not null,
title varchar(255),
body longtext,
created_date datetime,
updated_date datetime,
author_id bigint,
author_login_id varchar(255),
author_name varchar(255),
project_id bigint,
number bigint,
num_of_comments integer,
notice tinyint(1) default 0,
readme tinyint(1) default 0,
constraint uq_posting_1 unique (project_id,number),
constraint pk_posting primary key (id))
row_format=compressed, key_block_size=8
;
create table posting_comment (
id bigint auto_increment not null,
contents longtext,
created_date datetime,
author_id bigint,
author_login_id varchar(255),
author_name varchar(255),
posting_id bigint,
constraint pk_posting_comment primary key (id))
row_format=compressed, key_block_size=8
;
create table project (
id bigint auto_increment not null,
name varchar(255),
overview varchar(255),
vcs varchar(255),
siteurl varchar(255),
owner varchar(255),
created_date datetime,
last_issue_number bigint,
last_posting_number bigint,
original_project_id bigint,
last_pushed_date datetime,
default_reviewer_count integer,
is_using_reviewer_count tinyint(1) default 0,
organization_id bigint,
project_scope varchar(9),
previous_owner_login_id varchar(255),
previous_name varchar(255),
previous_name_changed_time bigint,
constraint ck_project_project_scope check (project_scope in ('PRIVATE','PROTECTED','PUBLIC')),
constraint pk_project primary key (id))
row_format=compressed, key_block_size=8
;
create table project_menu_setting (
id bigint auto_increment not null,
project_id bigint,
code tinyint(1) default 0,
issue tinyint(1) default 0,
pull_request tinyint(1) default 0,
review tinyint(1) default 0,
milestone tinyint(1) default 0,
board tinyint(1) default 0,
constraint pk_project_menu_setting primary key (id))
;
create table project_transfer (
id bigint auto_increment not null,
sender_id bigint,
destination varchar(255),
project_id bigint,
requested datetime,
confirm_key varchar(255),
accepted tinyint(1) default 0,
new_project_name varchar(255),
constraint pk_project_transfer primary key (id))
row_format=compressed, key_block_size=8
;
create table project_user (
id bigint auto_increment not null,
user_id bigint,
project_id bigint,
role_id bigint,
constraint pk_project_user primary key (id))
;
create table project_visitation (
id bigint auto_increment not null,
project_id bigint,
recently_visited_projects_id bigint,
visited datetime,
constraint uq_project_visitation_1 unique (project_id,recently_visited_projects_id),
constraint pk_project_visitation primary key (id))
;
create table property (
id bigint auto_increment not null,
name varchar(25),
value varchar(255),
constraint ck_property_name check (name in ('MAILBOX_LAST_SEEN_UID','MAILBOX_LAST_UID_VALIDITY')),
constraint pk_property primary key (id))
row_format=compressed, key_block_size=8
;
create table pull_request (
id bigint auto_increment not null,
title varchar(255),
body longtext,
to_project_id bigint,
from_project_id bigint,
to_branch varchar(255),
from_branch varchar(255),
contributor_id bigint,
receiver_id bigint,
created datetime,
updated datetime,
received datetime,
state integer,
is_conflict tinyint(1) default 0,
is_merging tinyint(1) default 0,
last_commit_id varchar(255),
merged_commit_id_from varchar(255),
merged_commit_id_to varchar(255),
number bigint,
constraint ck_pull_request_state check (state in (0,1,2,3,4,5,6)),
constraint pk_pull_request primary key (id))
row_format=compressed, key_block_size=8
;
create table pull_request_commit (
id bigint auto_increment not null,
pull_request_id bigint,
commit_id varchar(255),
author_date datetime,
created datetime,
commit_message longtext,
commit_short_id varchar(255),
author_email varchar(255),
state varchar(7),
constraint ck_pull_request_commit_state check (state in ('PRIOR','CURRENT')),
constraint pk_pull_request_commit primary key (id))
row_format=compressed, key_block_size=8
;
create table pull_request_event (
id bigint auto_increment not null,
sender_login_id varchar(255),
pull_request_id bigint,
event_type varchar(34),
created datetime,
old_value longtext,
new_value longtext,
constraint ck_pull_request_event_event_type check (event_type in ('NEW_ISSUE','NEW_POSTING','NEW_PULL_REQUEST','ISSUE_STATE_CHANGED','ISSUE_ASSIGNEE_CHANGED','PULL_REQUEST_STATE_CHANGED','NEW_COMMENT','NEW_REVIEW_COMMENT','MEMBER_ENROLL_REQUEST','PULL_REQUEST_MERGED','ISSUE_REFERRED_FROM_COMMIT','PULL_REQUEST_COMMIT_CHANGED','NEW_COMMIT','PULL_REQUEST_REVIEW_STATE_CHANGED','ISSUE_BODY_CHANGED','ISSUE_REFERRED_FROM_PULL_REQUEST','REVIEW_THREAD_STATE_CHANGED','ORGANIZATION_MEMBER_ENROLL_REQUEST','COMMENT_UPDATED')),
constraint pk_pull_request_event primary key (id))
row_format=compressed, key_block_size=8
;
create table project_pushed_branch (
id bigint auto_increment not null,
pushed_date datetime,
name varchar(255),
project_id bigint,
constraint pk_project_pushed_branch primary key (id))
row_format=compressed, key_block_size=8
;
create table recently_visited_projects (
id bigint auto_increment not null,
user_id bigint,
constraint pk_recently_visited_projects primary key (id))
;
create table review_comment (
id bigint auto_increment not null,
contents longtext,
created_date datetime,
author_id bigint,
author_login_id varchar(255),
author_name varchar(255),
thread_id bigint,
constraint pk_review_comment primary key (id))
row_format=compressed, key_block_size=8
;
create table role (
id bigint auto_increment not null,
name varchar(255),
active tinyint(1) default 0,
constraint pk_role primary key (id))
row_format=compressed, key_block_size=8
;
create table site_admin (
id bigint auto_increment not null,
admin_id bigint,
constraint pk_site_admin primary key (id))
;
create table unwatch (
id bigint auto_increment not null,
user_id bigint,
resource_type varchar(20),
resource_id varchar(255),
constraint ck_unwatch_resource_type check (resource_type in ('ISSUE_POST','ISSUE_ASSIGNEE','ISSUE_STATE','ISSUE_CATEGORY','ISSUE_MILESTONE','ISSUE_LABEL','BOARD_POST','BOARD_CATEGORY','BOARD_NOTICE','CODE','MILESTONE','WIKI_PAGE','PROJECT_SETTING','SITE_SETTING','USER','USER_AVATAR','PROJECT','ATTACHMENT','ISSUE_COMMENT','NONISSUE_COMMENT','LABEL','PROJECT_LABELS','FORK','COMMIT_COMMENT','PULL_REQUEST','COMMIT','COMMENT_THREAD','REVIEW_COMMENT','ORGANIZATION','PROJECT_TRANSFER','ISSUE_LABEL_CATEGORY','WEBHOOK','NOT_A_RESOURCE')),
constraint pk_unwatch primary key (id))
row_format=compressed, key_block_size=8
;
create table n4user (
id bigint auto_increment not null,
name varchar(255),
login_id varchar(255),
password varchar(255),
password_salt varchar(255),
email varchar(255),
remember_me tinyint(1) default 0,
state varchar(7),
last_state_modified_date datetime,
created_date datetime,
lang varchar(255),
constraint ck_n4user_state check (state in ('ACTIVE','LOCKED','DELETED')),
constraint pk_n4user primary key (id))
row_format=compressed, key_block_size=8
;
create table user_project_notification (
id bigint auto_increment not null,
user_id bigint,
project_id bigint,
notification_type varchar(34),
allowed tinyint(1) default 0,
constraint ck_user_project_notification_notification_type check (notification_type in ('NEW_ISSUE','NEW_POSTING','NEW_PULL_REQUEST','ISSUE_STATE_CHANGED','ISSUE_ASSIGNEE_CHANGED','PULL_REQUEST_STATE_CHANGED','NEW_COMMENT','NEW_REVIEW_COMMENT','MEMBER_ENROLL_REQUEST','PULL_REQUEST_MERGED','ISSUE_REFERRED_FROM_COMMIT','PULL_REQUEST_COMMIT_CHANGED','NEW_COMMIT','PULL_REQUEST_REVIEW_STATE_CHANGED','ISSUE_BODY_CHANGED','ISSUE_REFERRED_FROM_PULL_REQUEST','REVIEW_THREAD_STATE_CHANGED','ORGANIZATION_MEMBER_ENROLL_REQUEST','COMMENT_UPDATED')),
constraint uq_user_project_notification_1 unique (project_id,user_id,notification_type),
constraint pk_user_project_notification primary key (id))
row_format=compressed, key_block_size=8
;
create table watch (
id bigint auto_increment not null,
user_id bigint,
resource_type varchar(20),
resource_id varchar(255),
constraint ck_watch_resource_type check (resource_type in ('ISSUE_POST','ISSUE_ASSIGNEE','ISSUE_STATE','ISSUE_CATEGORY','ISSUE_MILESTONE','ISSUE_LABEL','BOARD_POST','BOARD_CATEGORY','BOARD_NOTICE','CODE','MILESTONE','WIKI_PAGE','PROJECT_SETTING','SITE_SETTING','USER','USER_AVATAR','PROJECT','ATTACHMENT','ISSUE_COMMENT','NONISSUE_COMMENT','LABEL','PROJECT_LABELS','FORK','COMMIT_COMMENT','PULL_REQUEST','COMMIT','COMMENT_THREAD','REVIEW_COMMENT','ORGANIZATION','PROJECT_TRANSFER','ISSUE_LABEL_CATEGORY','WEBHOOK','NOT_A_RESOURCE')),
constraint pk_watch primary key (id))
row_format=compressed, key_block_size=8
;
create table webhook (
id bigint auto_increment not null,
project_id bigint,
payload_url varchar(2000),
secret varchar(250),
created_at datetime,
constraint pk_webhook primary key (id))
row_format=compressed, key_block_size=8
;
create table comment_thread_n4user (
comment_thread_id bigint not null,
n4user_id bigint not null,
constraint pk_comment_thread_n4user primary key (comment_thread_id, n4user_id))
;
create table issue_issue_label (
issue_id bigint not null,
issue_label_id bigint not null,
constraint pk_issue_issue_label primary key (issue_id, issue_label_id))
;
create table issue_voter (
issue_id bigint not null,
user_id bigint not null,
constraint pk_issue_voter primary key (issue_id, user_id))
;
create table issue_comment_voter (
issue_comment_id bigint not null,
user_id bigint not null,
constraint pk_issue_comment_voter primary key (issue_comment_id, user_id))
;
create table notification_event_n4user (
notification_event_id bigint not null,
n4user_id bigint not null,
constraint pk_notification_event_n4user primary key (notification_event_id, n4user_id))
;
create table posting_issue_label (
posting_id bigint not null,
issue_label_id bigint not null,
constraint pk_posting_issue_label primary key (posting_id, issue_label_id))
;
create table project_label (
project_id bigint not null,
label_id bigint not null,
constraint pk_project_label primary key (project_id, label_id))
;
create table pull_request_reviewers (
pull_request_id bigint not null,
user_id bigint not null,
constraint pk_pull_request_reviewers primary key (pull_request_id, user_id))
;
create table user_enrolled_project (
user_id bigint not null,
project_id bigint not null,
constraint pk_user_enrolled_project primary key (user_id, project_id))
;
create table user_enrolled_organization (
user_id bigint not null,
organization_id bigint not null,
constraint pk_user_enrolled_organization primary key (user_id, organization_id))
;
alter table assignee add constraint fk_assignee_user_1 foreign key (user_id) references n4user (id) on delete restrict on update restrict;
create index ix_assignee_user_1 on assignee (user_id);
alter table assignee add constraint fk_assignee_project_2 foreign key (project_id) references project (id) on delete restrict on update restrict;
create index ix_assignee_project_2 on assignee (project_id);
alter table comment_thread add constraint fk_comment_thread_pullRequest_3 foreign key (pull_request_id) references pull_request (id) on delete restrict on update restrict;
create index ix_comment_thread_pullRequest_3 on comment_thread (pull_request_id);
alter table comment_thread add constraint fk_comment_thread_project_4 foreign key (project_id) references project (id) on delete restrict on update restrict;
create index ix_comment_thread_project_4 on comment_thread (project_id);
alter table commit_comment add constraint fk_commit_comment_project_5 foreign key (project_id) references project (id) on delete restrict on update restrict;
create index ix_commit_comment_project_5 on commit_comment (project_id);
alter table email add constraint fk_email_user_6 foreign key (user_id) references n4user (id) on delete restrict on update restrict;
create index ix_email_user_6 on email (user_id);
alter table issue add constraint fk_issue_project_7 foreign key (project_id) references project (id) on delete restrict on update restrict;
create index ix_issue_project_7 on issue (project_id);
alter table issue add constraint fk_issue_milestone_8 foreign key (milestone_id) references milestone (id) on delete restrict on update restrict;
create index ix_issue_milestone_8 on issue (milestone_id);
alter table issue add constraint fk_issue_assignee_9 foreign key (assignee_id) references assignee (id) on delete restrict on update restrict;
create index ix_issue_assignee_9 on issue (assignee_id);
alter table issue_comment add constraint fk_issue_comment_issue_10 foreign key (issue_id) references issue (id) on delete restrict on update restrict;
create index ix_issue_comment_issue_10 on issue_comment (issue_id);
alter table issue_event add constraint fk_issue_event_issue_11 foreign key (issue_id) references issue (id) on delete restrict on update restrict;
create index ix_issue_event_issue_11 on issue_event (issue_id);
alter table issue_label add constraint fk_issue_label_category_12 foreign key (category_id) references issue_label_category (id) on delete restrict on update restrict;
create index ix_issue_label_category_12 on issue_label (category_id);
alter table issue_label add constraint fk_issue_label_project_13 foreign key (project_id) references project (id) on delete restrict on update restrict;
create index ix_issue_label_project_13 on issue_label (project_id);
alter table issue_label_category add constraint fk_issue_label_category_project_14 foreign key (project_id) references project (id) on delete restrict on update restrict;
create index ix_issue_label_category_project_14 on issue_label_category (project_id);
alter table mention add constraint fk_mention_user_15 foreign key (user_id) references n4user (id) on delete restrict on update restrict;
create index ix_mention_user_15 on mention (user_id);
alter table milestone add constraint fk_milestone_project_16 foreign key (project_id) references project (id) on delete restrict on update restrict;
create index ix_milestone_project_16 on milestone (project_id);
alter table notification_mail add constraint fk_notification_mail_notificationEvent_17 foreign key (notification_event_id) references notification_event (id) on delete restrict on update restrict;
create index ix_notification_mail_notificationEvent_17 on notification_mail (notification_event_id);
alter table organization_user add constraint fk_organization_user_user_18 foreign key (user_id) references n4user (id) on delete restrict on update restrict;
create index ix_organization_user_user_18 on organization_user (user_id);
alter table organization_user add constraint fk_organization_user_organization_19 foreign key (organization_id) references organization (id) on delete restrict on update restrict;
create index ix_organization_user_organization_19 on organization_user (organization_id);
alter table organization_user add constraint fk_organization_user_role_20 foreign key (role_id) references role (id) on delete restrict on update restrict;
create index ix_organization_user_role_20 on organization_user (role_id);
alter table posting add constraint fk_posting_project_21 foreign key (project_id) references project (id) on delete restrict on update restrict;
create index ix_posting_project_21 on posting (project_id);
alter table posting_comment add constraint fk_posting_comment_posting_22 foreign key (posting_id) references posting (id) on delete restrict on update restrict;
create index ix_posting_comment_posting_22 on posting_comment (posting_id);
alter table project add constraint fk_project_originalProject_23 foreign key (original_project_id) references project (id) on delete restrict on update restrict;
create index ix_project_originalProject_23 on project (original_project_id);
alter table project add constraint fk_project_organization_24 foreign key (organization_id) references organization (id) on delete restrict on update restrict;
create index ix_project_organization_24 on project (organization_id);
alter table project_menu_setting add constraint fk_project_menu_setting_project_25 foreign key (project_id) references project (id) on delete restrict on update restrict;
create index ix_project_menu_setting_project_25 on project_menu_setting (project_id);
alter table project_transfer add constraint fk_project_transfer_sender_26 foreign key (sender_id) references n4user (id) on delete restrict on update restrict;
create index ix_project_transfer_sender_26 on project_transfer (sender_id);
alter table project_transfer add constraint fk_project_transfer_project_27 foreign key (project_id) references project (id) on delete restrict on update restrict;
create index ix_project_transfer_project_27 on project_transfer (project_id);
alter table project_user add constraint fk_project_user_user_28 foreign key (user_id) references n4user (id) on delete restrict on update restrict;
create index ix_project_user_user_28 on project_user (user_id);
alter table project_user add constraint fk_project_user_project_29 foreign key (project_id) references project (id) on delete restrict on update restrict;
create index ix_project_user_project_29 on project_user (project_id);
alter table project_user add constraint fk_project_user_role_30 foreign key (role_id) references role (id) on delete restrict on update restrict;
create index ix_project_user_role_30 on project_user (role_id);
alter table project_visitation add constraint fk_project_visitation_project_31 foreign key (project_id) references project (id) on delete restrict on update restrict;
create index ix_project_visitation_project_31 on project_visitation (project_id);
alter table project_visitation add constraint fk_project_visitation_recentlyVisitedProjects_32 foreign key (recently_visited_projects_id) references recently_visited_projects (id) on delete restrict on update restrict;
create index ix_project_visitation_recentlyVisitedProjects_32 on project_visitation (recently_visited_projects_id);
alter table pull_request add constraint fk_pull_request_toProject_33 foreign key (to_project_id) references project (id) on delete restrict on update restrict;
create index ix_pull_request_toProject_33 on pull_request (to_project_id);
alter table pull_request add constraint fk_pull_request_fromProject_34 foreign key (from_project_id) references project (id) on delete restrict on update restrict;
create index ix_pull_request_fromProject_34 on pull_request (from_project_id);
alter table pull_request add constraint fk_pull_request_contributor_35 foreign key (contributor_id) references n4user (id) on delete restrict on update restrict;
create index ix_pull_request_contributor_35 on pull_request (contributor_id);
alter table pull_request add constraint fk_pull_request_receiver_36 foreign key (receiver_id) references n4user (id) on delete restrict on update restrict;
create index ix_pull_request_receiver_36 on pull_request (receiver_id);
alter table pull_request_commit add constraint fk_pull_request_commit_pullRequest_37 foreign key (pull_request_id) references pull_request (id) on delete restrict on update restrict;
create index ix_pull_request_commit_pullRequest_37 on pull_request_commit (pull_request_id);
alter table pull_request_event add constraint fk_pull_request_event_pullRequest_38 foreign key (pull_request_id) references pull_request (id) on delete restrict on update restrict;
create index ix_pull_request_event_pullRequest_38 on pull_request_event (pull_request_id);
alter table project_pushed_branch add constraint fk_project_pushed_branch_project_39 foreign key (project_id) references project (id) on delete restrict on update restrict;
create index ix_project_pushed_branch_project_39 on project_pushed_branch (project_id);
alter table recently_visited_projects add constraint fk_recently_visited_projects_user_40 foreign key (user_id) references n4user (id) on delete restrict on update restrict;
create index ix_recently_visited_projects_user_40 on recently_visited_projects (user_id);
alter table review_comment add constraint fk_review_comment_thread_41 foreign key (thread_id) references comment_thread (id) on delete restrict on update restrict;
create index ix_review_comment_thread_41 on review_comment (thread_id);
alter table site_admin add constraint fk_site_admin_admin_42 foreign key (admin_id) references n4user (id) on delete restrict on update restrict;
create index ix_site_admin_admin_42 on site_admin (admin_id);
alter table unwatch add constraint fk_unwatch_user_43 foreign key (user_id) references n4user (id) on delete restrict on update restrict;
create index ix_unwatch_user_43 on unwatch (user_id);
alter table user_project_notification add constraint fk_user_project_notification_user_44 foreign key (user_id) references n4user (id) on delete restrict on update restrict;
create index ix_user_project_notification_user_44 on user_project_notification (user_id);
alter table user_project_notification add constraint fk_user_project_notification_project_45 foreign key (project_id) references project (id) on delete restrict on update restrict;
create index ix_user_project_notification_project_45 on user_project_notification (project_id);
alter table watch add constraint fk_watch_user_46 foreign key (user_id) references n4user (id) on delete restrict on update restrict;
create index ix_watch_user_46 on watch (user_id);
alter table webhook add constraint fk_webhook_project_47 foreign key (project_id) references project (id) on delete restrict on update restrict;
create index ix_webhook_project_47 on webhook (project_id);
alter table comment_thread_n4user add constraint fk_comment_thread_n4user_comment_thread_01 foreign key (comment_thread_id) references comment_thread (id) on delete restrict on update restrict;
alter table comment_thread_n4user add constraint fk_comment_thread_n4user_n4user_02 foreign key (n4user_id) references n4user (id) on delete restrict on update restrict;
alter table issue_issue_label add constraint fk_issue_issue_label_issue_01 foreign key (issue_id) references issue (id) on delete restrict on update restrict;
alter table issue_issue_label add constraint fk_issue_issue_label_issue_label_02 foreign key (issue_label_id) references issue_label (id) on delete restrict on update restrict;
alter table issue_voter add constraint fk_issue_voter_issue_01 foreign key (issue_id) references issue (id) on delete restrict on update restrict;
alter table issue_voter add constraint fk_issue_voter_n4user_02 foreign key (user_id) references n4user (id) on delete restrict on update restrict;
alter table issue_comment_voter add constraint fk_issue_comment_voter_issue_comment_01 foreign key (issue_comment_id) references issue_comment (id) on delete restrict on update restrict;
alter table issue_comment_voter add constraint fk_issue_comment_voter_n4user_02 foreign key (user_id) references n4user (id) on delete restrict on update restrict;
alter table notification_event_n4user add constraint fk_notification_event_n4user_notification_event_01 foreign key (notification_event_id) references notification_event (id) on delete restrict on update restrict;
alter table notification_event_n4user add constraint fk_notification_event_n4user_n4user_02 foreign key (n4user_id) references n4user (id) on delete restrict on update restrict;
alter table posting_issue_label add constraint fk_posting_issue_label_posting_01 foreign key (posting_id) references posting (id) on delete restrict on update restrict;
alter table posting_issue_label add constraint fk_posting_issue_label_issue_label_02 foreign key (issue_label_id) references issue_label (id) on delete restrict on update restrict;
alter table project_label add constraint fk_project_label_project_01 foreign key (project_id) references project (id) on delete restrict on update restrict;
alter table project_label add constraint fk_project_label_label_02 foreign key (label_id) references label (id) on delete restrict on update restrict;
alter table pull_request_reviewers add constraint fk_pull_request_reviewers_pull_request_01 foreign key (pull_request_id) references pull_request (id) on delete restrict on update restrict;
alter table pull_request_reviewers add constraint fk_pull_request_reviewers_n4user_02 foreign key (user_id) references n4user (id) on delete restrict on update restrict;
alter table user_enrolled_project add constraint fk_user_enrolled_project_n4user_01 foreign key (user_id) references n4user (id) on delete restrict on update restrict;
alter table user_enrolled_project add constraint fk_user_enrolled_project_project_02 foreign key (project_id) references project (id) on delete restrict on update restrict;
alter table user_enrolled_organization add constraint fk_user_enrolled_organization_n4user_01 foreign key (user_id) references n4user (id) on delete restrict on update restrict;
alter table user_enrolled_organization add constraint fk_user_enrolled_organization_organization_02 foreign key (organization_id) references organization (id) on delete restrict on update restrict;
# --- !Downs
SET FOREIGN_KEY_CHECKS=0;
drop table assignee;
drop table attachment;
drop table comment_thread;
drop table commit_comment;
drop table email;
drop table issue;
drop table issue_issue_label;
drop table issue_voter;
drop table issue_comment;
drop table issue_comment_voter;
drop table issue_event;
drop table issue_label;
drop table posting_issue_label;
drop table issue_label_category;
drop table label;
drop table project_label;
drop table mention;
drop table milestone;
drop table notification_event;
drop table notification_event_n4user;
drop table notification_mail;
drop table organization;
drop table user_enrolled_organization;
drop table organization_user;
drop table original_email;
drop table posting;
drop table posting_comment;
drop table project;
drop table user_enrolled_project;
drop table project_menu_setting;
drop table project_transfer;
drop table project_user;
drop table project_visitation;
drop table property;
drop table pull_request;
drop table pull_request_reviewers;
drop table pull_request_commit;
drop table pull_request_event;
drop table project_pushed_branch;
drop table recently_visited_projects;
drop table review_comment;
drop table role;
drop table site_admin;
drop table unwatch;
drop table n4user;
drop table user_project_notification;
drop table watch;
drop table webhook;
SET FOREIGN_KEY_CHECKS=1;