From d1db9357b84d57dfa61d3c40a48915d24c50ee12 Mon Sep 17 00:00:00 2001 From: Evgeny Mandrikov Date: Tue, 24 May 2011 00:15:48 +0400 Subject: SONAR-2425 Add index on CHARACTERISTIC_PROPERTIES.CHARACTERISTIC_ID --- .../org/sonar/test/persistence/sonar-test.ddl | 43 +++++++++++----------- 1 file changed, 22 insertions(+), 21 deletions(-) (limited to 'sonar-testing-harness/src') 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 54f49a0953b..343aa3f9335 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,6 +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 table CRITERIA ( ID INTEGER not null, @@ -482,28 +483,28 @@ create table WIDGET_PROPERTIES ( CREATE INDEX WIDGET_PROPERTIES_WIDGETS ON WIDGET_PROPERTIES (WIDGET_ID); CREATE TABLE REVIEWS ( - ID INTEGER NOT NULL, - CREATED_AT TIMESTAMP, - UPDATED_AT TIMESTAMP, - USER_ID INTEGER, - ASSIGNEE_ID INTEGER, - TITLE VARCHAR(500), - REVIEW_TYPE VARCHAR(10), - STATUS VARCHAR(10), - SEVERITY VARCHAR(10), - RULE_FAILURE_PERMANENT_ID INTEGER, - PROJECT_ID INTEGER, - RESOURCE_ID INTEGER, - RESOURCE_LINE INTEGER, - primary key (id) + ID INTEGER NOT NULL, + CREATED_AT TIMESTAMP, + UPDATED_AT TIMESTAMP, + USER_ID INTEGER, + ASSIGNEE_ID INTEGER, + TITLE VARCHAR(500), + REVIEW_TYPE VARCHAR(10), + STATUS VARCHAR(10), + SEVERITY VARCHAR(10), + RULE_FAILURE_PERMANENT_ID INTEGER, + PROJECT_ID INTEGER, + RESOURCE_ID INTEGER, + RESOURCE_LINE INTEGER, + primary key (id) ); CREATE TABLE REVIEW_COMMENTS ( - ID INTEGER NOT NULL, - CREATED_AT TIMESTAMP, - UPDATED_AT TIMESTAMP, - REVIEW_ID INTEGER, - USER_ID INTEGER, - REVIEW_TEXT CLOB(2147483647), - primary key (id) + ID INTEGER NOT NULL, + CREATED_AT TIMESTAMP, + UPDATED_AT TIMESTAMP, + REVIEW_ID INTEGER, + USER_ID INTEGER, + REVIEW_TEXT CLOB(2147483647), + primary key (id) ); -- cgit v1.2.3