diff options
| author | Sébastien Lesaint <sebastien.lesaint@sonarsource.com> | 2018-10-01 18:26:32 +0200 |
|---|---|---|
| committer | sonartech <sonartech@sonarsource.com> | 2018-10-10 09:23:00 +0200 |
| commit | a1fa6643d0f43003dc3edce42961032774a7e3db (patch) | |
| tree | 8f41d0d08630e6c472bf23a1b028ab5c31633302 /server/sonar-db-core | |
| parent | 62a465c3e954105b359a0046dc0bf893ccaa324a (diff) | |
| download | sonarqube-a1fa6643d0f43003dc3edce42961032774a7e3db.tar.gz sonarqube-a1fa6643d0f43003dc3edce42961032774a7e3db.zip | |
SONAR-11310 drop tmp columns on CE_QUEUE and CE_ACTIVITY
and make columns not nullable
Diffstat (limited to 'server/sonar-db-core')
| -rw-r--r-- | server/sonar-db-core/src/main/resources/org/sonar/db/version/schema-h2.ddl | 16 |
1 files changed, 0 insertions, 16 deletions
diff --git a/server/sonar-db-core/src/main/resources/org/sonar/db/version/schema-h2.ddl b/server/sonar-db-core/src/main/resources/org/sonar/db/version/schema-h2.ddl index b7fa9b36bc7..a792c2be6b1 100644 --- a/server/sonar-db-core/src/main/resources/org/sonar/db/version/schema-h2.ddl +++ b/server/sonar-db-core/src/main/resources/org/sonar/db/version/schema-h2.ddl @@ -670,8 +670,6 @@ CREATE TABLE "CE_QUEUE" ( "TASK_TYPE" VARCHAR(15) NOT NULL, "COMPONENT_UUID" VARCHAR(40) NULL, "MAIN_COMPONENT_UUID" VARCHAR(40) NULL, - "TMP_COMPONENT_UUID" VARCHAR(40) NULL, - "TMP_MAIN_COMPONENT_UUID" VARCHAR(40) NULL, "STATUS" VARCHAR(15) NOT NULL, "SUBMITTER_UUID" VARCHAR(255) NULL, "WORKER_UUID" VARCHAR(40) NULL, @@ -683,8 +681,6 @@ CREATE TABLE "CE_QUEUE" ( CREATE UNIQUE INDEX "CE_QUEUE_UUID" ON "CE_QUEUE" ("UUID"); CREATE INDEX "CE_QUEUE_COMPONENT" ON "CE_QUEUE" ("COMPONENT_UUID"); CREATE INDEX "CE_QUEUE_MAIN_COMPONENT" ON "CE_QUEUE" ("MAIN_COMPONENT_UUID"); -CREATE INDEX "CE_QUEUE_TMP_CPNT_UUID" ON "CE_QUEUE" ("TMP_COMPONENT_UUID"); -CREATE INDEX "CE_QUEUE_TMP_MAIN_CPNT_UUID" ON "CE_QUEUE" ("TMP_MAIN_COMPONENT_UUID"); CREATE INDEX "CE_QUEUE_STATUS" ON "CE_QUEUE" ("STATUS"); @@ -694,18 +690,12 @@ CREATE TABLE "CE_ACTIVITY" ( "TASK_TYPE" VARCHAR(15) NOT NULL, "COMPONENT_UUID" VARCHAR(40) NULL, "MAIN_COMPONENT_UUID" VARCHAR(40) NULL, - "TMP_COMPONENT_UUID" VARCHAR(40) NULL, - "TMP_MAIN_COMPONENT_UUID" VARCHAR(40) NULL, "ANALYSIS_UUID" VARCHAR(50) NULL, "STATUS" VARCHAR(15) NOT NULL, "IS_LAST" BOOLEAN, "IS_LAST_KEY" VARCHAR(55), "MAIN_IS_LAST" BOOLEAN, "MAIN_IS_LAST_KEY" VARCHAR(55), - "TMP_IS_LAST" BOOLEAN, - "TMP_IS_LAST_KEY" VARCHAR(55), - "TMP_MAIN_IS_LAST" BOOLEAN, - "TMP_MAIN_IS_LAST_KEY" VARCHAR(55), "SUBMITTER_UUID" VARCHAR(255) NULL, "WORKER_UUID" VARCHAR(40) NULL, "EXECUTION_COUNT" INTEGER NOT NULL, @@ -722,16 +712,10 @@ CREATE TABLE "CE_ACTIVITY" ( CREATE UNIQUE INDEX "CE_ACTIVITY_UUID" ON "CE_ACTIVITY" ("UUID"); CREATE INDEX "CE_ACTIVITY_COMPONENT" ON "CE_ACTIVITY" ("COMPONENT_UUID"); CREATE INDEX "CE_ACTIVITY_MAIN_COMPONENT" ON "CE_ACTIVITY" ("COMPONENT_UUID"); -CREATE INDEX "CE_ACTIVITY_COMPONENT_UUID" ON "CE_ACTIVITY" ("COMPONENT_UUID"); -CREATE INDEX "CE_ACTIVITY_TMP_CPNT_UUID" ON "CE_ACTIVITY" ("TMP_COMPONENT_UUID"); CREATE INDEX "CE_ACTIVITY_ISLAST_KEY" ON "CE_ACTIVITY" ("IS_LAST_KEY"); CREATE INDEX "CE_ACTIVITY_ISLAST" ON "CE_ACTIVITY" ("IS_LAST", "STATUS"); CREATE INDEX "CE_ACTIVITY_MAIN_ISLAST_KEY" ON "CE_ACTIVITY" ("MAIN_IS_LAST_KEY"); CREATE INDEX "CE_ACTIVITY_MAIN_ISLAST" ON "CE_ACTIVITY" ("MAIN_IS_LAST", "STATUS"); -CREATE INDEX "CE_ACTIVITY_T_ISLAST_KEY" ON "CE_ACTIVITY" ("TMP_IS_LAST_KEY"); -CREATE INDEX "CE_ACTIVITY_T_ISLAST" ON "CE_ACTIVITY" ("TMP_IS_LAST", "STATUS"); -CREATE INDEX "CE_ACTIVITY_T_MAIN_ISLAST_KEY" ON "CE_ACTIVITY" ("TMP_MAIN_IS_LAST_KEY"); -CREATE INDEX "CE_ACTIVITY_T_MAIN_ISLAST" ON "CE_ACTIVITY" ("TMP_MAIN_IS_LAST", "STATUS"); CREATE TABLE "CE_TASK_CHARACTERISTICS" ( |