diff options
| author | Stephane Gamard <stephane.gamard@searchbox.com> | 2014-06-20 11:44:21 +0200 |
|---|---|---|
| committer | Stephane Gamard <stephane.gamard@searchbox.com> | 2014-06-20 11:44:39 +0200 |
| commit | 40530d8ea9162517f8f9e1330e836c9189135013 (patch) | |
| tree | e0dc41839e42d249d85e5c8ce30553403e1eb166 /sonar-core/src | |
| parent | 05e41d4442f4933983f066a75d69c0bba0ba42c2 (diff) | |
| download | sonarqube-40530d8ea9162517f8f9e1330e836c9189135013.tar.gz sonarqube-40530d8ea9162517f8f9e1330e836c9189135013.zip | |
SONAR-5329 - Updated migration (Added unique key)
Diffstat (limited to 'sonar-core/src')
| -rw-r--r-- | sonar-core/src/main/resources/org/sonar/core/persistence/schema-h2.ddl | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/sonar-core/src/main/resources/org/sonar/core/persistence/schema-h2.ddl b/sonar-core/src/main/resources/org/sonar/core/persistence/schema-h2.ddl index 87f4b2af284..0f46f3092c6 100644 --- a/sonar-core/src/main/resources/org/sonar/core/persistence/schema-h2.ddl +++ b/sonar-core/src/main/resources/org/sonar/core/persistence/schema-h2.ddl @@ -555,6 +555,7 @@ CREATE TABLE "PERM_TEMPLATES_GROUPS" ( CREATE TABLE "ACTIVITIES" ( + "LOG_KEY" VARCHAR(250), "CREATED_AT" TIMESTAMP, "USER_LOGIN" VARCHAR(30), "LOG_TYPE" VARCHAR(250), @@ -567,6 +568,8 @@ CREATE TABLE "ACTIVITIES" ( -- DDL Statements for indexes -- ---------------------------------------------- +CREATE UNIQUE INDEX "LOG_KEY_INDEX" ON "ACTIVITIES" ("LOG_KEY"); + CREATE INDEX "GROUP_ROLES_RESOURCE" ON "GROUP_ROLES" ("RESOURCE_ID"); CREATE INDEX "GROUP_ROLES_GROUP" ON "GROUP_ROLES" ("GROUP_ID"); |