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

   1 CREATE TABLE "RULES"(
   2     "UUID" CHARACTER VARYING(40) NOT NULL,
   3     "NAME" CHARACTER VARYING(200),
   4     "PLUGIN_RULE_KEY" CHARACTER VARYING(200) NOT NULL,
   5     "PLUGIN_KEY" CHARACTER VARYING(200),
   6     "PLUGIN_CONFIG_KEY" CHARACTER VARYING(200),
   7     "PLUGIN_NAME" CHARACTER VARYING(255) NOT NULL,
   8     "SCOPE" CHARACTER VARYING(20) NOT NULL,
   9     "PRIORITY" INTEGER,
  10     "STATUS" CHARACTER VARYING(40),
  11     "LANGUAGE" CHARACTER VARYING(20),
  12     "DEF_REMEDIATION_FUNCTION" CHARACTER VARYING(20),
  13     "DEF_REMEDIATION_GAP_MULT" CHARACTER VARYING(20),
  14     "DEF_REMEDIATION_BASE_EFFORT" CHARACTER VARYING(20),
  15     "GAP_DESCRIPTION" CHARACTER VARYING(4000),
  16     "SYSTEM_TAGS" CHARACTER VARYING(4000),
  17     "IS_TEMPLATE" BOOLEAN DEFAULT FALSE NOT NULL,
  18     "DESCRIPTION_FORMAT" CHARACTER VARYING(20),
  19     "RULE_TYPE" TINYINT,
  20     "SECURITY_STANDARDS" CHARACTER VARYING(4000),
  21     "IS_AD_HOC" BOOLEAN NOT NULL,
  22     "IS_EXTERNAL" BOOLEAN NOT NULL,
  23     "CREATED_AT" BIGINT,
  24     "UPDATED_AT" BIGINT,
  25     "TEMPLATE_UUID" CHARACTER VARYING(40),
  26     "NOTE_DATA" CHARACTER LARGE OBJECT,
  27     "NOTE_USER_UUID" CHARACTER VARYING(255),
  28     "NOTE_CREATED_AT" BIGINT,
  29     "NOTE_UPDATED_AT" BIGINT,
  30     "REMEDIATION_FUNCTION" CHARACTER VARYING(20),
  31     "REMEDIATION_GAP_MULT" CHARACTER VARYING(20),
  32     "REMEDIATION_BASE_EFFORT" CHARACTER VARYING(20),
  33     "TAGS" CHARACTER VARYING(4000),
  34     "AD_HOC_NAME" CHARACTER VARYING(200),
  35     "AD_HOC_DESCRIPTION" CHARACTER LARGE OBJECT,
  36     "AD_HOC_SEVERITY" CHARACTER VARYING(10),
  37     "AD_HOC_TYPE" TINYINT
  38 );
  39 ALTER TABLE "RULES" ADD CONSTRAINT "PK_RULES" PRIMARY KEY("UUID");
  40 CREATE UNIQUE INDEX "RULES_REPO_KEY" ON "RULES"("PLUGIN_RULE_KEY" NULLS FIRST, "PLUGIN_NAME" NULLS FIRST);