From 32c274e7d74a040b2895c613724fb89e0fc704cf Mon Sep 17 00:00:00 2001 From: Duarte Meneses Date: Mon, 30 Mar 2020 12:28:32 -0500 Subject: SONAR-13193 Stop using legacy project ID and use project UUID instead --- server/sonar-db-dao/src/schema/schema-sq.ddl | 9 ++++----- 1 file changed, 4 insertions(+), 5 deletions(-) (limited to 'server/sonar-db-dao/src') 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"); -- cgit v1.2.3