From 3c653a2018b745f32b2c6ed9a7ecea9edb153d08 Mon Sep 17 00:00:00 2001 From: Fabrice Bellingard Date: Wed, 20 Apr 2011 17:07:07 +0200 Subject: SONAR-2347 Add unit test to ReviewsDecorator --- .../org/sonar/test/persistence/sonar-test.ddl | 25 ++++++++++++++++++++++ 1 file changed, 25 insertions(+) (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 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) +); -- cgit v1.2.3