diff options
| author | Fabrice Bellingard <bellingard@gmail.com> | 2012-01-26 10:34:24 +0100 |
|---|---|---|
| committer | Fabrice Bellingard <bellingard@gmail.com> | 2012-01-26 10:34:24 +0100 |
| commit | b0579f77900e3853834b92fa57419e2ee5292141 (patch) | |
| tree | e6e8b050ed804864f21af0cb5f446119b6d0e502 /sonar-core/src | |
| parent | c0d6299259de839375a9653f0ff2b19cba2ce042 (diff) | |
| download | sonarqube-b0579f77900e3853834b92fa57419e2ee5292141.tar.gz sonarqube-b0579f77900e3853834b92fa57419e2ee5292141.zip | |
Add lines accidentally removed by Simon
Diffstat (limited to 'sonar-core/src')
| -rw-r--r-- | sonar-core/src/main/resources/org/sonar/core/persistence/schema-derby.ddl | 26 |
1 files changed, 26 insertions, 0 deletions
diff --git a/sonar-core/src/main/resources/org/sonar/core/persistence/schema-derby.ddl b/sonar-core/src/main/resources/org/sonar/core/persistence/schema-derby.ddl index 1dcd74b9e03..4c718b808b5 100644 --- a/sonar-core/src/main/resources/org/sonar/core/persistence/schema-derby.ddl +++ b/sonar-core/src/main/resources/org/sonar/core/persistence/schema-derby.ddl @@ -487,6 +487,24 @@ CREATE TABLE "ACTION_PLANS_REVIEWS" ( "REVIEW_ID" INTEGER ); +CREATE TABLE "ACTIVE_RULE_NOTES" ( + "ID" INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1), + "ACTIVE_RULE_ID" INTEGER, + "USER_LOGIN" VARCHAR(40), + "DATA" BLOB(2147483647), + "CREATED_AT" TIMESTAMP, + "UPDATED_AT" TIMESTAMP +); + +CREATE TABLE "RULE_NOTES" ( + "ID" INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1), + "RULE_ID" INTEGER, + "USER_LOGIN" VARCHAR(40), + "DATA" BLOB(2147483647), + "CREATED_AT" TIMESTAMP, + "UPDATED_AT" TIMESTAMP +); + -- ---------------------------------------------- -- DDL Statements for indexes @@ -580,6 +598,10 @@ CREATE INDEX "INDEX_ACTION_PLANS_REVIEWS_ON_ACTION_PLAN_ID" ON "ACTION_PLANS_REV CREATE INDEX "INDEX_ACTION_PLANS_REVIEWS_ON_REVIEW_ID" ON "ACTION_PLANS_REVIEWS" ("REVIEW_ID"); +CREATE INDEX "INDEX_ACTIVE_RULE_NOTES_ON_ACTIVE_RULE_ID" ON "ACTIVE_RULE_NOTES" ("ACTIVE_RULE_ID"); + +CREATE INDEX "INDEX_RULE_NOTES_ON_ACTIVE_RULE_ID" ON "RULE_NOTES" ("RULE_ID"); + -- ---------------------------------------------- -- DDL Statements for keys @@ -667,3 +689,7 @@ ALTER TABLE "ACTIVE_RULE_PARAMETERS" ADD CONSTRAINT "SQL110927104437560" PRIMARY ALTER TABLE "LOADED_TEMPLATES" ADD CONSTRAINT "SQL110927104437650" PRIMARY KEY ("ID"); ALTER TABLE "ACTION_PLANS" ADD CONSTRAINT "SQL110927104447650" PRIMARY KEY ("ID"); + +ALTER TABLE "ACTIVE_RULE_NOTES" ADD CONSTRAINT "SQL110927104847650" PRIMARY KEY ("ID"); + +ALTER TABLE "RULE_NOTES" ADD CONSTRAINT "SQL110927184847650" PRIMARY KEY ("ID"); |