diff --git a/src/main/resources/update/1_0.sql b/src/main/resources/update/1_0.sql index 2594584..d655cd1 100644 --- a/src/main/resources/update/1_0.sql +++ b/src/main/resources/update/1_0.sql @@ -20,9 +20,10 @@ LAST_ACTIVITY_DATE TIMESTAMP NOT NULL ); -CREATE TABLE REPOSITORY_ACCOUNT( +CREATE TABLE COLLABORATOR( REPOSITORY_NAME VARCHAR(100) NOT NULL, - USER_NAME VARCHAR(100) NOT NULL + USER_NAME VARCHAR(100) NOT NULL, + COLLABORATOR_NAME VARCHRA(100) NOT NULL ); CREATE TABLE ISSUE( @@ -58,7 +59,7 @@ USER_NAME VARCHAR(100) NOT NULL, REPOSITORY_NAME VARCHAR(100) NOT NULL, LABEL_ID INT AUTO_INCREMENT, - LABEL VARCHAR(100) NOT NULL, + LABEL_NAME VARCHAR(100) NOT NULL, COLOR CHAR(6) NOT NULL ); @@ -82,9 +83,9 @@ ALTER TABLE REPOSITORY ADD CONSTRAINT IDX_REPOSITORY_PK PRIMARY KEY (REPOSITORY_NAME, USER_NAME); ALTER TABLE REPOSITORY ADD CONSTRAINT IDX_REPOSITORY_FK0 FOREIGN KEY (USER_NAME) REFERENCES ACCOUNT (USER_NAME); -ALTER TABLE REPOSITORY_ACCOUNT ADD CONSTRAINT IDX_REPOSITORY_ACCOUNT_PK PRIMARY KEY (REPOSITORY_NAME, USER_NAME); -ALTER TABLE REPOSITORY_ACCOUNT ADD CONSTRAINT IDX_REPOSITORY_ACCOUNT_FK0 FOREIGN KEY (REPOSITORY_NAME) REFERENCES REPOSITORY (REPOSITORY_NAME); -ALTER TABLE REPOSITORY_ACCOUNT ADD CONSTRAINT IDX_REPOSITORY_ACCOUNT_FK1 FOREIGN KEY (USER_NAME) REFERENCES ACCOUNT (USER_NAME); +ALTER TABLE COLLABORATOR ADD CONSTRAINT IDX_COLLABORATOR_PK PRIMARY KEY (REPOSITORY_NAME, USER_NAME); +ALTER TABLE COLLABORATOR ADD CONSTRAINT IDX_COLLABORATOR_FK0 FOREIGN KEY (REPOSITORY_NAME, USER_NAME) REFERENCES REPOSITORY (REPOSITORY_NAME, USER_NAME); +ALTER TABLE COLLABORATOR ADD CONSTRAINT IDX_COLLABORATOR_FK1 FOREIGN KEY (COLLABORATOR_NAME) REFERENCES ACCOUNT (USER_NAME); ALTER TABLE ISSUE ADD CONSTRAINT IDX_ISSUE_PK PRIMARY KEY (ISSUE_ID, USER_NAME, REPOSITORY_NAME); ALTER TABLE ISSUE ADD CONSTRAINT IDX_ISSUE_FK0 FOREIGN KEY (USER_NAME, REPOSITORY_NAME) REFERENCES REPOSITORY (USER_NAME, REPOSITORY_NAME);