diff options
| author | Duarte Meneses <duarte.meneses@sonarsource.com> | 2020-03-30 12:28:32 -0500 |
|---|---|---|
| committer | sonartech <sonartech@sonarsource.com> | 2020-04-14 20:04:05 +0000 |
| commit | 32c274e7d74a040b2895c613724fb89e0fc704cf (patch) | |
| tree | 80bd867890719a5df26c4c2ef620b584389c9102 /server/sonar-db-dao/src | |
| parent | df3c515c32549db6be2ded722a6c217d25fa1122 (diff) | |
| download | sonarqube-32c274e7d74a040b2895c613724fb89e0fc704cf.tar.gz sonarqube-32c274e7d74a040b2895c613724fb89e0fc704cf.zip | |
SONAR-13193 Stop using legacy project ID and use project UUID instead
Diffstat (limited to 'server/sonar-db-dao/src')
| -rw-r--r-- | server/sonar-db-dao/src/schema/schema-sq.ddl | 9 |
1 files changed, 4 insertions, 5 deletions
diff --git a/server/sonar-db-dao/src/schema/schema-sq.ddl b/server/sonar-db-dao/src/schema/schema-sq.ddl index dd428bb2980..986e1367bdd 100644 --- a/server/sonar-db-dao/src/schema/schema-sq.ddl +++ b/server/sonar-db-dao/src/schema/schema-sq.ddl @@ -320,11 +320,11 @@ CREATE TABLE "GROUP_ROLES"( "ORGANIZATION_UUID" VARCHAR(40) NOT NULL, "GROUP_ID" INTEGER, "ROLE" VARCHAR(64) NOT NULL, - "COMPONENT_UUID" VARCHAR(50) + "COMPONENT_UUID" VARCHAR(40) ); ALTER TABLE "GROUP_ROLES" ADD CONSTRAINT "PK_GROUP_ROLES" PRIMARY KEY("ID"); CREATE INDEX "GROUP_ROLES_COMPONENT_UUID" ON "GROUP_ROLES"("COMPONENT_UUID"); -CREATE UNIQUE INDEX "GROUP_ROLES_UNIQ" ON "GROUP_ROLES"("ORGANIZATION_UUID", "GROUP_ID", "COMPONENT_UUID", "ROLE"); +CREATE UNIQUE INDEX "UNIQ_GROUP_ROLES" ON "GROUP_ROLES"("ORGANIZATION_UUID", "GROUP_ID", "COMPONENT_UUID", "ROLE"); CREATE TABLE "GROUPS"( "ID" INTEGER NOT NULL AUTO_INCREMENT (1,1), @@ -737,11 +737,10 @@ CREATE TABLE "PROPERTIES"( "TEXT_VALUE" VARCHAR(4000), "CLOB_VALUE" CLOB(2147483647), "CREATED_AT" BIGINT NOT NULL, - "COMPONENT_UUID" VARCHAR(50) + "COMPONENT_UUID" VARCHAR(40) ); ALTER TABLE "PROPERTIES" ADD CONSTRAINT "PK_PROPERTIES" PRIMARY KEY("ID"); CREATE INDEX "PROPERTIES_KEY" ON "PROPERTIES"("PROP_KEY"); -CREATE INDEX "PROPERTIES_COMPONENT_UUID" ON "PROPERTIES"("COMPONENT_UUID"); CREATE TABLE "QPROFILE_CHANGES"( "KEE" VARCHAR(40) NOT NULL, @@ -929,7 +928,7 @@ CREATE TABLE "USER_ROLES"( "ORGANIZATION_UUID" VARCHAR(40) NOT NULL, "USER_ID" INTEGER, "ROLE" VARCHAR(64) NOT NULL, - "COMPONENT_UUID" VARCHAR(50) + "COMPONENT_UUID" VARCHAR(40) ); ALTER TABLE "USER_ROLES" ADD CONSTRAINT "PK_USER_ROLES" PRIMARY KEY("ID"); CREATE INDEX "USER_ROLES_USER" ON "USER_ROLES"("USER_ID"); |