From 23c8ac63e9d9326bf61b352255d060fd25ffc69e Mon Sep 17 00:00:00 2001 From: Lukasz Jarocki Date: Tue, 20 Jun 2023 10:42:14 +0200 Subject: [PATCH] SONAR-19556 updated schema files --- server/sonar-db-dao/src/schema/schema-sq.ddl | 1 + 1 file changed, 1 insertion(+) diff --git a/server/sonar-db-dao/src/schema/schema-sq.ddl b/server/sonar-db-dao/src/schema/schema-sq.ddl index da1ce6e4ef4..450896f70ec 100644 --- a/server/sonar-db-dao/src/schema/schema-sq.ddl +++ b/server/sonar-db-dao/src/schema/schema-sq.ddl @@ -1001,6 +1001,7 @@ CREATE TABLE "USER_ROLES"( ); ALTER TABLE "USER_ROLES" ADD CONSTRAINT "PK_USER_ROLES" PRIMARY KEY("UUID"); CREATE INDEX "USER_ROLES_USER" ON "USER_ROLES"("USER_UUID" NULLS FIRST); +CREATE INDEX "USER_ROLES_ENTITY_UUID" ON "USER_ROLES"("ENTITY_UUID" NULLS FIRST); CREATE TABLE "USER_TOKENS"( "UUID" CHARACTER VARYING(40) NOT NULL, -- 2.39.5