diff options
| author | Evgeny Mandrikov <mandrikov@gmail.com> | 2011-05-24 19:19:21 +0400 |
|---|---|---|
| committer | Evgeny Mandrikov <mandrikov@gmail.com> | 2011-05-24 19:27:16 +0400 |
| commit | 3e32f3cd621a9c751d8355dda697e9fb224b3957 (patch) | |
| tree | 3e19a0c9e9d70f826bf0f215e6079e8c3ec58d06 | |
| parent | b6d05fa45566092791e0b2bdc16ed0312d93c613 (diff) | |
| download | sonarqube-3e32f3cd621a9c751d8355dda697e9fb224b3957.tar.gz sonarqube-3e32f3cd621a9c751d8355dda697e9fb224b3957.zip | |
SONAR-2425 Add index on CHARACTERISTIC_PROPERTIES.CHARACTERISTIC_ID
Index name limited to 30 characters in Oracle DB.
| -rw-r--r-- | sonar-server/src/main/webapp/WEB-INF/db/migrate/200_add_index_to_characteristic_property.rb | 2 | ||||
| -rw-r--r-- | sonar-testing-harness/src/main/resources/org/sonar/test/persistence/sonar-test.ddl | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/sonar-server/src/main/webapp/WEB-INF/db/migrate/200_add_index_to_characteristic_property.rb b/sonar-server/src/main/webapp/WEB-INF/db/migrate/200_add_index_to_characteristic_property.rb index 87e31a1ae76..6d345d34c31 100644 --- a/sonar-server/src/main/webapp/WEB-INF/db/migrate/200_add_index_to_characteristic_property.rb +++ b/sonar-server/src/main/webapp/WEB-INF/db/migrate/200_add_index_to_characteristic_property.rb @@ -24,7 +24,7 @@ class AddIndexToCharacteristicProperty < ActiveRecord::Migration def self.up - add_index :characteristic_properties, :characteristic_id, :name => 'characteristic_properties_characteristic_id' + add_index :characteristic_properties, :characteristic_id, :name => 'characteristic_properties_cid' end end diff --git a/sonar-testing-harness/src/main/resources/org/sonar/test/persistence/sonar-test.ddl b/sonar-testing-harness/src/main/resources/org/sonar/test/persistence/sonar-test.ddl index 343aa3f9335..d7e6a848481 100644 --- a/sonar-testing-harness/src/main/resources/org/sonar/test/persistence/sonar-test.ddl +++ b/sonar-testing-harness/src/main/resources/org/sonar/test/persistence/sonar-test.ddl @@ -83,7 +83,7 @@ create table CHARACTERISTIC_PROPERTIES ( TEXT_VALUE VARCHAR(4000), primary key (id) ); -CREATE INDEX CHARACTERISTIC_PROPERTIES_CHARACTERISTIC_ID ON CHARACTERISTIC_PROPERTIES (CHARACTERISTIC_ID); +CREATE INDEX CHARACTERISTIC_PROPERTIES_CID ON CHARACTERISTIC_PROPERTIES (CHARACTERISTIC_ID); create table CRITERIA ( ID INTEGER not null, |