diff options
Diffstat (limited to 'server/sonar-db-dao')
| -rw-r--r-- | server/sonar-db-dao/src/schema/schema-sq.ddl | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/server/sonar-db-dao/src/schema/schema-sq.ddl b/server/sonar-db-dao/src/schema/schema-sq.ddl index a91a86418f5..b0893b96121 100644 --- a/server/sonar-db-dao/src/schema/schema-sq.ddl +++ b/server/sonar-db-dao/src/schema/schema-sq.ddl @@ -812,10 +812,12 @@ CREATE TABLE "RULE_DESC_SECTIONS"( "UUID" CHARACTER VARYING(40) NOT NULL, "RULE_UUID" CHARACTER VARYING(40) NOT NULL, "KEE" CHARACTER VARYING(50) NOT NULL, - "CONTENT" CHARACTER LARGE OBJECT NOT NULL + "CONTENT" CHARACTER LARGE OBJECT NOT NULL, + "CONTEXT_KEY" CHARACTER VARYING(50), + "CONTEXT_DISPLAY_NAME" CHARACTER VARYING(50) ); ALTER TABLE "RULE_DESC_SECTIONS" ADD CONSTRAINT "PK_RULE_DESC_SECTIONS" PRIMARY KEY("UUID"); -CREATE UNIQUE INDEX "UNIQ_RULE_DESC_SECTIONS_KEE" ON "RULE_DESC_SECTIONS"("RULE_UUID" NULLS FIRST, "KEE" NULLS FIRST); +CREATE UNIQUE INDEX "UNIQ_RULE_DESC_SECTIONS" ON "RULE_DESC_SECTIONS"("RULE_UUID" NULLS FIRST, "KEE" NULLS FIRST, "CONTEXT_KEY" NULLS FIRST); CREATE TABLE "RULE_REPOSITORIES"( "KEE" CHARACTER VARYING(200) NOT NULL, |