SONAR-2425 Add index on CHARACTERISTIC_PROPERTIES.CHARACTERISTIC_ID

1 files changed, 22 insertions, 21 deletions

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)
 );