]> source.dussan.org Git - sonarqube.git/blob
6dea8cb971157a520982fd02111d6c0d61c7af91
[sonarqube.git] /
1 CREATE TABLE "ISSUE_CHANGES"(
2     "ID" BIGINT NOT NULL AUTO_INCREMENT (1,1),
3     "KEE" VARCHAR(50),
4     "ISSUE_KEY" VARCHAR(50) NOT NULL,
5     "USER_LOGIN" VARCHAR(255),
6     "CHANGE_TYPE" VARCHAR(20),
7     "CHANGE_DATA" CLOB(2147483647),
8     "CREATED_AT" BIGINT,
9     "UPDATED_AT" BIGINT,
10     "ISSUE_CHANGE_CREATION_DATE" BIGINT
11 );
12 ALTER TABLE "ISSUE_CHANGES" ADD CONSTRAINT "PK_ISSUE_CHANGES" PRIMARY KEY("ID");
13 CREATE INDEX "ISSUE_CHANGES_ISSUE_KEY" ON "ISSUE_CHANGES"("ISSUE_KEY");
14 CREATE INDEX "ISSUE_CHANGES_KEE" ON "ISSUE_CHANGES"("KEE");