diff options
| author | Aurelien Poscia <aurelien.poscia@sonarsource.com> | 2023-03-28 16:21:58 +0200 |
|---|---|---|
| committer | sonartech <sonartech@sonarsource.com> | 2023-03-31 20:03:26 +0000 |
| commit | 7f182cc29f9484dc6ac0000404e3b287b6fa3b99 (patch) | |
| tree | 9e7d3341ff852ffd4dccf7cb5070dbb381359e42 /server/sonar-db-dao/src/schema/schema-sq.ddl | |
| parent | 7e47c81f79f0cd31d533a90e19264ff60afe75de (diff) | |
| download | sonarqube-7f182cc29f9484dc6ac0000404e3b287b6fa3b99.tar.gz sonarqube-7f182cc29f9484dc6ac0000404e3b287b6fa3b99.zip | |
SONAR-18728 use DB calls to replace UserIndex.getAtMostThreeActiveUsersForScmAccount
Diffstat (limited to 'server/sonar-db-dao/src/schema/schema-sq.ddl')
| -rw-r--r-- | server/sonar-db-dao/src/schema/schema-sq.ddl | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/server/sonar-db-dao/src/schema/schema-sq.ddl b/server/sonar-db-dao/src/schema/schema-sq.ddl index b07d5318d37..1d4b4ae594c 100644 --- a/server/sonar-db-dao/src/schema/schema-sq.ddl +++ b/server/sonar-db-dao/src/schema/schema-sq.ddl @@ -934,6 +934,7 @@ CREATE TABLE "SCM_ACCOUNTS"( "SCM_ACCOUNT" CHARACTER VARYING(255) NOT NULL ); ALTER TABLE "SCM_ACCOUNTS" ADD CONSTRAINT "PK_SCM_ACCOUNTS" PRIMARY KEY("USER_UUID", "SCM_ACCOUNT"); +CREATE INDEX "SCM_ACCOUNTS_SCM_ACCOUNT" ON "SCM_ACCOUNTS"("SCM_ACCOUNT" NULLS FIRST); CREATE TABLE "SESSION_TOKENS"( "UUID" CHARACTER VARYING(40) NOT NULL, @@ -1027,6 +1028,7 @@ CREATE UNIQUE INDEX "USERS_LOGIN" ON "USERS"("LOGIN" NULLS FIRST); CREATE INDEX "USERS_UPDATED_AT" ON "USERS"("UPDATED_AT" NULLS FIRST); CREATE UNIQUE INDEX "UNIQ_EXTERNAL_ID" ON "USERS"("EXTERNAL_IDENTITY_PROVIDER" NULLS FIRST, "EXTERNAL_ID" NULLS FIRST); CREATE UNIQUE INDEX "UNIQ_EXTERNAL_LOGIN" ON "USERS"("EXTERNAL_IDENTITY_PROVIDER" NULLS FIRST, "EXTERNAL_LOGIN" NULLS FIRST); +CREATE INDEX "USERS_EMAIL" ON "USERS"("EMAIL" NULLS FIRST); CREATE TABLE "WEBHOOK_DELIVERIES"( "UUID" CHARACTER VARYING(40) NOT NULL, |