From 3e32f3cd621a9c751d8355dda697e9fb224b3957 Mon Sep 17 00:00:00 2001 From: Evgeny Mandrikov Date: Tue, 24 May 2011 19:19:21 +0400 Subject: [PATCH] SONAR-2425 Add index on CHARACTERISTIC_PROPERTIES.CHARACTERISTIC_ID Index name limited to 30 characters in Oracle DB. --- .../db/migrate/200_add_index_to_characteristic_property.rb | 2 +- .../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, -- 2.39.5