source.dussan.org Git - sonarqube.git/blob

   1 CREATE TABLE "ISSUE_CHANGES"(
   2     "ID" BIGINT NOT NULL AUTO_INCREMENT (1,1),
   3     "UUID" VARCHAR(40),
   4     "KEE" VARCHAR(50),
   5     "ISSUE_KEY" VARCHAR(50) NOT NULL,
   6     "USER_LOGIN" VARCHAR(255),
   7     "CHANGE_TYPE" VARCHAR(20),
   8     "CHANGE_DATA" CLOB(2147483647),
   9     "CREATED_AT" BIGINT,
  10     "UPDATED_AT" BIGINT,
  11     "ISSUE_CHANGE_CREATION_DATE" BIGINT
  12 );
  13 ALTER TABLE "ISSUE_CHANGES" ADD CONSTRAINT "PK_ISSUE_CHANGES" PRIMARY KEY("ID");
  14 CREATE INDEX "ISSUE_CHANGES_ISSUE_KEY" ON "ISSUE_CHANGES"("ISSUE_KEY");
  15 CREATE INDEX "ISSUE_CHANGES_KEE" ON "ISSUE_CHANGES"("KEE");