diff options
| author | Julien Lancelot <julien.lancelot@sonarsource.com> | 2017-09-25 14:17:32 +0200 |
|---|---|---|
| committer | Stas Vilchik <stas.vilchik@sonarsource.com> | 2017-10-02 17:18:15 +0200 |
| commit | 1b443053cd473188c17606ea48318ceadd19720b (patch) | |
| tree | c056e388c374aac2ae9d1641769a4fa4a8efa25f /server/sonar-db-core | |
| parent | f96f99021d99319b935e8c620396743f7ce197a7 (diff) | |
| download | sonarqube-1b443053cd473188c17606ea48318ceadd19720b.tar.gz sonarqube-1b443053cd473188c17606ea48318ceadd19720b.zip | |
SONAR-1330 Create table QPROFILE_EDIT_GROUPS
Diffstat (limited to 'server/sonar-db-core')
| -rw-r--r-- | server/sonar-db-core/src/main/resources/org/sonar/db/version/schema-h2.ddl | 11 |
1 files changed, 11 insertions, 0 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 4b66621e4d0..f4ea81d864e 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 @@ -100,6 +100,17 @@ CREATE INDEX "QPROFILE_EDIT_USERS_QPROFILE" ON "QPROFILE_EDIT_USERS" ("QPROFILE_ CREATE UNIQUE INDEX "QPROFILE_EDIT_USERS_UNIQUE" ON "QPROFILE_EDIT_USERS" ("USER_ID", "QPROFILE_UUID"); +CREATE TABLE "QPROFILE_EDIT_GROUPS" ( + "UUID" VARCHAR(40) NOT NULL PRIMARY KEY, + "GROUP_ID" INTEGER NOT NULL, + "QPROFILE_UUID" VARCHAR(255) NOT NULL, + "CREATED_AT" BIGINT, +); +CREATE UNIQUE INDEX "PK_QPROFILE_EDIT_GROUPS" ON "QPROFILE_EDIT_GROUPS" ("UUID"); +CREATE INDEX "QPROFILE_EDIT_GROUPS_QPROFILE" ON "QPROFILE_EDIT_GROUPS" ("QPROFILE_UUID"); +CREATE UNIQUE INDEX "QPROFILE_EDIT_GROUPS_UNIQUE" ON "QPROFILE_EDIT_GROUPS" ("GROUP_ID", "QPROFILE_UUID"); + + CREATE TABLE "GROUPS" ( "ID" INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1), "ORGANIZATION_UUID" VARCHAR(40) NOT NULL, |