aboutsummaryrefslogtreecommitdiffstats
path: root/sonar-testing-harness/src
diff options
context:
space:
mode:
authorFabrice Bellingard <bellingard@gmail.com>2011-04-20 17:07:07 +0200
committerFabrice Bellingard <bellingard@gmail.com>2011-04-20 17:15:30 +0200
commit3c653a2018b745f32b2c6ed9a7ecea9edb153d08 (patch)
tree1c77a2963e058ba2c258a8bd9aeeba4d5cdb93ba /sonar-testing-harness/src
parentb77474c58f3056fc8291c639fb1e66921605f4cb (diff)
downloadsonarqube-3c653a2018b745f32b2c6ed9a7ecea9edb153d08.tar.gz
sonarqube-3c653a2018b745f32b2c6ed9a7ecea9edb153d08.zip
SONAR-2347 Add unit test to ReviewsDecorator
Diffstat (limited to 'sonar-testing-harness/src')
-rw-r--r--sonar-testing-harness/src/main/resources/org/sonar/test/persistence/sonar-test.ddl25
1 files changed, 25 insertions, 0 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 eab1ca343af..c5125179cbf 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
@@ -481,3 +481,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,
+ 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)
+);