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

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