diff options
author | Simon Brandhof <simon.brandhof@gmail.com> | 2012-10-22 11:02:23 +0200 |
---|---|---|
committer | Simon Brandhof <simon.brandhof@gmail.com> | 2012-10-22 11:02:23 +0200 |
commit | 84b672373f32aafcd8b79769722100e6e4ad0683 (patch) | |
tree | 8f6ef6cc1c978656ed248a6f45339c3f173b56f7 /sonar-core | |
parent | 0aaf2941ee812b63c7f84b357586ecfba9853b15 (diff) | |
download | sonarqube-84b672373f32aafcd8b79769722100e6e4ad0683.tar.gz sonarqube-84b672373f32aafcd8b79769722100e6e4ad0683.zip |
SONAR-3887 fix compatibility with MySQL
Diffstat (limited to 'sonar-core')
-rw-r--r-- | sonar-core/src/main/resources/org/sonar/core/persistence/schema-h2.ddl | 6 |
1 files changed, 4 insertions, 2 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 152c74226cb..55d37119219 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 @@ -614,6 +614,8 @@ CREATE INDEX "INDEX_RULE_NOTES_ON_ACTIVE_RULE_ID" ON "RULE_NOTES" ("RULE_ID"); CREATE INDEX "REVIEWS_RID" ON "REVIEWS" ("RESOURCE_ID"); -CREATE UNIQUE INDEX "uniq_semaphore_names" ON "SEMAPHORES" ("CHECKSUM"); +CREATE UNIQUE INDEX "UNIQ_SEMAPHORE_CHECKSUMS" ON "SEMAPHORES" ("CHECKSUM"); -CREATE UNIQUE INDEX "uniq_author_logins" ON "AUTHORS" ("LOGIN"); +CREATE INDEX "SEMAPHORE_NAMES" ON "SEMAPHORES" ("NAME"); + +CREATE UNIQUE INDEX "UNIQ_AUTHOR_LOGINS" ON "AUTHORS" ("LOGIN"); |