diff options
| author | Julien HENRY <julien.henry@sonarsource.com> | 2018-03-30 10:13:33 +0200 |
|---|---|---|
| committer | SonarTech <sonartech@sonarsource.com> | 2018-05-16 20:20:45 +0200 |
| commit | 5073eb0f98e99ab0efbdd3f34b07a97f11e1d26c (patch) | |
| tree | 418dbeb6b1c0b512b9d06ab542dec9887431c05f /server/sonar-db-core | |
| parent | ac3c3089d82cc78390f761776a848be77306538d (diff) | |
| download | sonarqube-5073eb0f98e99ab0efbdd3f34b07a97f11e1d26c.tar.gz sonarqube-5073eb0f98e99ab0efbdd3f34b07a97f11e1d26c.zip | |
SONAR-10517 Create table project_mappings
* Migration
* Add DAO
* Purge on project deletion
Diffstat (limited to 'server/sonar-db-core')
| -rw-r--r-- | server/sonar-db-core/src/main/java/org/sonar/db/version/SqTables.java | 1 | ||||
| -rw-r--r-- | server/sonar-db-core/src/main/resources/org/sonar/db/version/schema-h2.ddl | 12 |
2 files changed, 13 insertions, 0 deletions
diff --git a/server/sonar-db-core/src/main/java/org/sonar/db/version/SqTables.java b/server/sonar-db-core/src/main/java/org/sonar/db/version/SqTables.java index cf7e5586769..f33d7f5f575 100644 --- a/server/sonar-db-core/src/main/java/org/sonar/db/version/SqTables.java +++ b/server/sonar-db-core/src/main/java/org/sonar/db/version/SqTables.java @@ -87,6 +87,7 @@ public final class SqTables { "projects", "project_branches", "project_links", + "project_mappings", "project_measures", "project_qprofiles", "properties", 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 2ebc5a39f71..dd2e3a3317e 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 @@ -797,3 +797,15 @@ CREATE TABLE "ALM_APP_INSTALLS" ( ); CREATE UNIQUE INDEX "ALM_APP_INSTALLS_OWNER" ON "ALM_APP_INSTALLS" ("ALM_ID", "OWNER_ID"); CREATE UNIQUE INDEX "ALM_APP_INSTALLS_INSTALL" ON "ALM_APP_INSTALLS" ("ALM_ID", "INSTALL_ID"); + +CREATE TABLE "PROJECT_MAPPINGS" ( + "UUID" VARCHAR(40) NOT NULL PRIMARY KEY, + "KEY_TYPE" VARCHAR(200) NOT NULL, + "KEE" VARCHAR(4000) NOT NULL, + "PROJECT_UUID" VARCHAR(40) NOT NULL, + "CREATED_AT" BIGINT NOT NULL, + CONSTRAINT "PK_PROJECT_MAPPINGS" PRIMARY KEY ("UUID") +); +CREATE UNIQUE INDEX "KEY_TYPE_KEE" ON "PROJECT_MAPPINGS" ("KEY_TYPE", "KEE"); +CREATE INDEX "PROJECT_UUID" ON "PROJECT_MAPPINGS" ("PROJECT_UUID"); + |