diff options
Diffstat (limited to 'server/sonar-db-dao/src/schema/schema-sq.ddl')
| -rw-r--r-- | server/sonar-db-dao/src/schema/schema-sq.ddl | 12 |
1 files changed, 6 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 fc2acf81abc..1bc82047b1e 100644 --- a/server/sonar-db-dao/src/schema/schema-sq.ddl +++ b/server/sonar-db-dao/src/schema/schema-sq.ddl @@ -334,7 +334,7 @@ ALTER TABLE "GROUPS" ADD CONSTRAINT "PK_GROUPS" PRIMARY KEY("UUID"); CREATE TABLE "GROUPS_USERS"( "GROUP_UUID" VARCHAR(40) NOT NULL, - "USER_UUID" VARCHAR(40) NOT NULL + "USER_UUID" VARCHAR(255) NOT NULL ); CREATE INDEX "INDEX_GROUPS_USERS_GROUP_UUID" ON "GROUPS_USERS"("GROUP_UUID"); CREATE INDEX "INDEX_GROUPS_USERS_USER_UUID" ON "GROUPS_USERS"("USER_UUID"); @@ -524,7 +524,7 @@ CREATE UNIQUE INDEX "ORG_ALM_BINDINGS_INSTALL" ON "ORGANIZATION_ALM_BINDINGS"("A CREATE TABLE "ORGANIZATION_MEMBERS"( "ORGANIZATION_UUID" VARCHAR(40) NOT NULL, - "USER_UUID" VARCHAR(40) NOT NULL + "USER_UUID" VARCHAR(255) NOT NULL ); ALTER TABLE "ORGANIZATION_MEMBERS" ADD CONSTRAINT "PK_ORGANIZATION_MEMBERS" PRIMARY KEY("USER_UUID", "ORGANIZATION_UUID"); CREATE INDEX "ORG_MEMBERS_USER_UUID" ON "ORGANIZATION_MEMBERS"("USER_UUID"); @@ -566,7 +566,7 @@ CREATE TABLE "PERM_TEMPLATES_USERS"( "UPDATED_AT" TIMESTAMP, "UUID" VARCHAR(40) NOT NULL, "TEMPLATE_UUID" VARCHAR(40) NOT NULL, - "USER_UUID" VARCHAR(40) NOT NULL + "USER_UUID" VARCHAR(255) NOT NULL ); ALTER TABLE "PERM_TEMPLATES_USERS" ADD CONSTRAINT "PK_PERM_TEMPLATES_USERS" PRIMARY KEY("UUID"); @@ -732,7 +732,7 @@ CREATE TABLE "PROPERTIES"( "CREATED_AT" BIGINT NOT NULL, "COMPONENT_UUID" VARCHAR(40), "UUID" VARCHAR(40) NOT NULL, - "USER_UUID" VARCHAR(40) + "USER_UUID" VARCHAR(255) ); ALTER TABLE "PROPERTIES" ADD CONSTRAINT "PK_PROPERTIES" PRIMARY KEY("UUID"); CREATE INDEX "PROPERTIES_KEY" ON "PROPERTIES"("PROP_KEY"); @@ -762,7 +762,7 @@ CREATE TABLE "QPROFILE_EDIT_USERS"( "UUID" VARCHAR(40) NOT NULL, "QPROFILE_UUID" VARCHAR(255) NOT NULL, "CREATED_AT" BIGINT NOT NULL, - "USER_UUID" VARCHAR(40) NOT NULL + "USER_UUID" VARCHAR(255) NOT NULL ); ALTER TABLE "QPROFILE_EDIT_USERS" ADD CONSTRAINT "PK_QPROFILE_EDIT_USERS" PRIMARY KEY("UUID"); CREATE INDEX "QPROFILE_EDIT_USERS_QPROFILE" ON "QPROFILE_EDIT_USERS"("QPROFILE_UUID"); @@ -928,7 +928,7 @@ CREATE TABLE "USER_ROLES"( "ROLE" VARCHAR(64) NOT NULL, "COMPONENT_UUID" VARCHAR(40), "UUID" VARCHAR(40) NOT NULL, - "USER_UUID" VARCHAR(40) + "USER_UUID" VARCHAR(255) ); ALTER TABLE "USER_ROLES" ADD CONSTRAINT "PK_USER_ROLES" PRIMARY KEY("UUID"); CREATE INDEX "USER_ROLES_COMPONENT_UUID" ON "USER_ROLES"("COMPONENT_UUID"); |