diff options
| author | Duarte Meneses <duarte.meneses@sonarsource.com> | 2023-06-15 11:00:37 -0500 |
|---|---|---|
| committer | sonartech <sonartech@sonarsource.com> | 2023-06-20 13:10:19 +0000 |
| commit | 02f3b4f569001b840bebdefc28dac44f8d52a973 (patch) | |
| tree | 498352485b3eadb5d7408fdcaf424f1f29caa729 /server/sonar-db-dao/src/schema/schema-sq.ddl | |
| parent | 4142434c9e6d89edde1bdeef643768557803d437 (diff) | |
| download | sonarqube-02f3b4f569001b840bebdefc28dac44f8d52a973.tar.gz sonarqube-02f3b4f569001b840bebdefc28dac44f8d52a973.zip | |
SONAR-19556 Add DB migration tests and fix drop of index
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, 1 insertions, 1 deletions
diff --git a/server/sonar-db-dao/src/schema/schema-sq.ddl b/server/sonar-db-dao/src/schema/schema-sq.ddl index 6efa0698926..3b55498b1f6 100644 --- a/server/sonar-db-dao/src/schema/schema-sq.ddl +++ b/server/sonar-db-dao/src/schema/schema-sq.ddl @@ -140,9 +140,9 @@ CREATE TABLE "CE_ACTIVITY"( "NODE_NAME" CHARACTER VARYING(100) ); ALTER TABLE "CE_ACTIVITY" ADD CONSTRAINT "PK_CE_ACTIVITY" PRIMARY KEY("UUID"); +CREATE INDEX "CE_ACTIVITY_COMPONENT" ON "CE_ACTIVITY"("COMPONENT_UUID" NULLS FIRST); CREATE INDEX "CE_ACTIVITY_ISLAST" ON "CE_ACTIVITY"("IS_LAST" NULLS FIRST, "STATUS" NULLS FIRST); CREATE INDEX "CE_ACTIVITY_ISLAST_KEY" ON "CE_ACTIVITY"("IS_LAST_KEY" NULLS FIRST); -CREATE INDEX "CE_ACTIVITY_MAIN_COMPONENT" ON "CE_ACTIVITY"("ENTITY_UUID" NULLS FIRST); CREATE INDEX "CE_ACTIVITY_MAIN_ISLAST" ON "CE_ACTIVITY"("MAIN_IS_LAST" NULLS FIRST, "STATUS" NULLS FIRST); CREATE INDEX "CE_ACTIVITY_MAIN_ISLAST_KEY" ON "CE_ACTIVITY"("MAIN_IS_LAST_KEY" NULLS FIRST); CREATE INDEX "CE_ACTIVITY_ENTITY_UUID" ON "CE_ACTIVITY"("ENTITY_UUID" NULLS FIRST); |