diff options
| author | Pierre <pierre.guillot@sonarsource.com> | 2020-09-24 14:21:10 +0200 |
|---|---|---|
| committer | sonartech <sonartech@sonarsource.com> | 2020-10-05 20:07:42 +0000 |
| commit | 13d76f2a2c2e5b42b3d74bf1ad0c4dbbeca14608 (patch) | |
| tree | ce8c16540053ae25ed9ad8b31072ba204a4a34fc /server/sonar-db-dao/src/schema/schema-sq.ddl | |
| parent | 68c364f416ced3893457300257c1c5df1eef8ce7 (diff) | |
| download | sonarqube-13d76f2a2c2e5b42b3d74bf1ad0c4dbbeca14608.tar.gz sonarqube-13d76f2a2c2e5b42b3d74bf1ad0c4dbbeca14608.zip | |
SONAR-13903 Remove use of organizations in Quality Profiles and Active Rules
Diffstat (limited to 'server/sonar-db-dao/src/schema/schema-sq.ddl')
| -rw-r--r-- | server/sonar-db-dao/src/schema/schema-sq.ddl | 8 |
1 files changed, 2 insertions, 6 deletions
diff --git a/server/sonar-db-dao/src/schema/schema-sq.ddl b/server/sonar-db-dao/src/schema/schema-sq.ddl index ae5bb2b7ca8..6f54915f01d 100644 --- a/server/sonar-db-dao/src/schema/schema-sq.ddl +++ b/server/sonar-db-dao/src/schema/schema-sq.ddl @@ -219,13 +219,12 @@ CREATE INDEX "PROJECTS_ROOT_UUID" ON "COMPONENTS"("ROOT_UUID"); CREATE INDEX "PROJECTS_UUID" ON "COMPONENTS"("UUID"); CREATE TABLE "DEFAULT_QPROFILES"( - "ORGANIZATION_UUID" VARCHAR(40) NOT NULL, "LANGUAGE" VARCHAR(20) NOT NULL, "QPROFILE_UUID" VARCHAR(255) NOT NULL, "CREATED_AT" BIGINT NOT NULL, "UPDATED_AT" BIGINT NOT NULL ); -ALTER TABLE "DEFAULT_QPROFILES" ADD CONSTRAINT "PK_DEFAULT_QPROFILES" PRIMARY KEY("ORGANIZATION_UUID", "LANGUAGE"); +ALTER TABLE "DEFAULT_QPROFILES" ADD CONSTRAINT "PK_DEFAULT_QPROFILES" PRIMARY KEY("LANGUAGE"); CREATE UNIQUE INDEX "UNIQ_DEFAULT_QPROFILES_UUID" ON "DEFAULT_QPROFILES"("QPROFILE_UUID"); CREATE TABLE "DEPRECATED_RULE_KEYS"( @@ -493,7 +492,6 @@ ALTER TABLE "NOTIFICATIONS" ADD CONSTRAINT "PK_NOTIFICATIONS" PRIMARY KEY("UUID" CREATE TABLE "ORG_QPROFILES"( "UUID" VARCHAR(255) NOT NULL, - "ORGANIZATION_UUID" VARCHAR(40) NOT NULL, "RULES_PROFILE_UUID" VARCHAR(255) NOT NULL, "PARENT_UUID" VARCHAR(255), "LAST_USED" BIGINT, @@ -502,7 +500,6 @@ CREATE TABLE "ORG_QPROFILES"( "UPDATED_AT" BIGINT NOT NULL ); ALTER TABLE "ORG_QPROFILES" ADD CONSTRAINT "PK_ORG_QPROFILES" PRIMARY KEY("UUID"); -CREATE INDEX "QPROFILES_ORG_UUID" ON "ORG_QPROFILES"("ORGANIZATION_UUID"); CREATE INDEX "QPROFILES_RP_UUID" ON "ORG_QPROFILES"("RULES_PROFILE_UUID"); CREATE INDEX "ORG_QPROFILES_PARENT_UUID" ON "ORG_QPROFILES"("PARENT_UUID"); @@ -816,7 +813,6 @@ ALTER TABLE "RULES" ADD CONSTRAINT "PK_RULES" PRIMARY KEY("UUID"); CREATE UNIQUE INDEX "RULES_REPO_KEY" ON "RULES"("PLUGIN_RULE_KEY", "PLUGIN_NAME"); CREATE TABLE "RULES_METADATA"( - "ORGANIZATION_UUID" VARCHAR(40) NOT NULL, "NOTE_DATA" CLOB, "NOTE_USER_UUID" VARCHAR(255), "NOTE_CREATED_AT" BIGINT, @@ -833,7 +829,7 @@ CREATE TABLE "RULES_METADATA"( "UPDATED_AT" BIGINT NOT NULL, "RULE_UUID" VARCHAR(40) NOT NULL ); -ALTER TABLE "RULES_METADATA" ADD CONSTRAINT "PK_RULES_METADATA" PRIMARY KEY("RULE_UUID", "ORGANIZATION_UUID"); +ALTER TABLE "RULES_METADATA" ADD CONSTRAINT "PK_RULES_METADATA" PRIMARY KEY("RULE_UUID"); CREATE TABLE "RULES_PARAMETERS"( "NAME" VARCHAR(128) NOT NULL, |