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

   1 CREATE TABLE "RULES_METADATA"(
   2     "ORGANIZATION_UUID" VARCHAR(40) NOT NULL,
   3     "NOTE_DATA" CLOB,
   4     "NOTE_USER_UUID" VARCHAR(255),
   5     "NOTE_CREATED_AT" BIGINT,
   6     "NOTE_UPDATED_AT" BIGINT,
   7     "REMEDIATION_FUNCTION" VARCHAR(20),
   8     "REMEDIATION_GAP_MULT" VARCHAR(20),
   9     "REMEDIATION_BASE_EFFORT" VARCHAR(20),
  10     "TAGS" VARCHAR(4000),
  11     "AD_HOC_NAME" VARCHAR(200),
  12     "AD_HOC_DESCRIPTION" CLOB,
  13     "AD_HOC_SEVERITY" VARCHAR(10),
  14     "AD_HOC_TYPE" TINYINT,
  15     "CREATED_AT" BIGINT NOT NULL,
  16     "UPDATED_AT" BIGINT NOT NULL,
  17     "RULE_UUID" VARCHAR(40) NOT NULL
  18 );
  19 ALTER TABLE "RULES_METADATA" ADD CONSTRAINT "PK_RULES_METADATA" PRIMARY KEY("RULE_UUID", "ORGANIZATION_UUID");