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

   1 CREATE TABLE "ISSUES"(
   2     "ID" BIGINT NOT NULL,
   3     "KEE" VARCHAR(50) NOT NULL,
   4     "RULE_ID" INTEGER,
   5     "SEVERITY" VARCHAR(10),
   6     "MANUAL_SEVERITY" BOOLEAN NOT NULL,
   7     "MESSAGE" VARCHAR(4000),
   8     "LINE" INTEGER,
   9     "GAP" DOUBLE,
  10     "STATUS" VARCHAR(20),
  11     "RESOLUTION" VARCHAR(20),
  12     "CHECKSUM" VARCHAR(1000),
  13     "REPORTER" VARCHAR(255),
  14     "ASSIGNEE" VARCHAR(255),
  15     "AUTHOR_LOGIN" VARCHAR(255),
  16     "ACTION_PLAN_KEY" VARCHAR(50),
  17     "ISSUE_ATTRIBUTES" VARCHAR(4000),
  18     "EFFORT" INTEGER,
  19     "CREATED_AT" BIGINT,
  20     "UPDATED_AT" BIGINT,
  21     "ISSUE_CREATION_DATE" BIGINT,
  22     "ISSUE_UPDATE_DATE" BIGINT,
  23     "ISSUE_CLOSE_DATE" BIGINT,
  24     "TAGS" VARCHAR(4000),
  25     "COMPONENT_UUID" VARCHAR(50),
  26     "PROJECT_UUID" VARCHAR(50),
  27     "LOCATIONS" BLOB,
  28     "ISSUE_TYPE" TINYINT,
  29     "FROM_HOTSPOT" BOOLEAN
  30 );
  31 ALTER TABLE "ISSUES" ADD CONSTRAINT "PK_ISSUES" PRIMARY KEY("KEE");
  32 CREATE INDEX "ISSUES_ASSIGNEE" ON "ISSUES"("ASSIGNEE");
  33 CREATE INDEX "ISSUES_COMPONENT_UUID" ON "ISSUES"("COMPONENT_UUID");
  34 CREATE INDEX "ISSUES_CREATION_DATE" ON "ISSUES"("ISSUE_CREATION_DATE");
  35 CREATE UNIQUE INDEX "ISSUES_KEE" ON "ISSUES"("KEE");
  36 CREATE INDEX "ISSUES_PROJECT_UUID" ON "ISSUES"("PROJECT_UUID");
  37 CREATE INDEX "ISSUES_RESOLUTION" ON "ISSUES"("RESOLUTION");
  38 CREATE INDEX "ISSUES_RULE_ID" ON "ISSUES"("RULE_ID");
  39 CREATE INDEX "ISSUES_UPDATED_AT" ON "ISSUES"("UPDATED_AT");