Newer
Older
gitbucket_jkp / src / main / resources / update / 1_6.sql
@takezoe takezoe on 2 Sep 2013 377 bytes (refs #74)Add WEB_HOOK table.
CREATE TABLE WEB_HOOK (
		USER_NAME VARCHAR(100) NOT NULL,
		REPOSITORY_NAME VARCHAR(100) NOT NULL,
		URL VARCHAR(200) NOT NULL
);

ALTER TABLE WEB_HOOK ADD CONSTRAINT IDX_WEB_HOOK_PK PRIMARY KEY (USER_NAME, REPOSITORY_NAME, URL);
ALTER TABLE WEB_HOOK ADD CONSTRAINT IDX_WEB_HOOK_FK0 FOREIGN KEY (USER_NAME, REPOSITORY_NAME) REFERENCES REPOSITORY (USER_NAME, REPOSITORY_NAME);