diff options
| author | Eric Hartmann <hartmann.eric@gmail.com> | 2017-09-29 18:07:31 +0200 |
|---|---|---|
| committer | Sébastien Lesaint <sebastien.lesaint@sonarsource.com> | 2017-10-17 15:13:58 +0200 |
| commit | c1f4d7c77fcf0e9b8d385167a7f34a68ac6c6550 (patch) | |
| tree | 0615811c23f9434bc33289e8ecbd05365a6f1e51 /server/sonar-db-core/src | |
| parent | 80645fca839ea97ee472f01ebb81f40af0f179f5 (diff) | |
| download | sonarqube-c1f4d7c77fcf0e9b8d385167a7f34a68ac6c6550.tar.gz sonarqube-c1f4d7c77fcf0e9b8d385167a7f34a68ac6c6550.zip | |
SONAR-9882 Implements storage of sonar.analysis.* properties
Diffstat (limited to 'server/sonar-db-core/src')
| -rw-r--r-- | server/sonar-db-core/src/main/resources/org/sonar/db/version/schema-h2.ddl | 19 |
1 files changed, 15 insertions, 4 deletions
diff --git a/server/sonar-db-core/src/main/resources/org/sonar/db/version/schema-h2.ddl b/server/sonar-db-core/src/main/resources/org/sonar/db/version/schema-h2.ddl index 6afd58a258b..f3bedc4ba6b 100644 --- a/server/sonar-db-core/src/main/resources/org/sonar/db/version/schema-h2.ddl +++ b/server/sonar-db-core/src/main/resources/org/sonar/db/version/schema-h2.ddl @@ -197,7 +197,7 @@ CREATE UNIQUE INDEX "RULES_REPO_KEY" ON "RULES" ("PLUGIN_NAME", "PLUGIN_RULE_KEY CREATE TABLE "RULES_METADATA" ( "RULE_ID" INTEGER NOT NULL, "ORGANIZATION_UUID" VARCHAR(40) NOT NULL, - "NOTE_DATA" CLOB(2147483647), + "NOTE_DATA" CLOB, "NOTE_USER_LOGIN" VARCHAR(255), "NOTE_CREATED_AT" BIGINT, "NOTE_UPDATED_AT" BIGINT, @@ -255,7 +255,7 @@ CREATE TABLE "PROPERTIES" ( "USER_ID" INTEGER, "IS_EMPTY" BOOLEAN NOT NULL, "TEXT_VALUE" VARCHAR(4000), - "CLOB_VALUE" CLOB(2147483647), + "CLOB_VALUE" CLOB, "CREATED_AT" BIGINT ); CREATE INDEX "PROPERTIES_KEY" ON "PROPERTIES" ("PROP_KEY"); @@ -579,7 +579,7 @@ CREATE TABLE "FILE_SOURCES" ( "ID" INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1), "PROJECT_UUID" VARCHAR(50) NOT NULL, "FILE_UUID" VARCHAR(50) NOT NULL, - "LINE_HASHES" CLOB(2147483647), + "LINE_HASHES" CLOB, "BINARY_DATA" BLOB, "DATA_TYPE" VARCHAR(20), "DATA_HASH" VARCHAR(50), @@ -630,7 +630,7 @@ CREATE TABLE "CE_ACTIVITY" ( "UPDATED_AT" BIGINT NOT NULL, "EXECUTION_TIME_MS" BIGINT NULL, "ERROR_MESSAGE" VARCHAR(1000), - "ERROR_STACKTRACE" CLOB(2147483647), + "ERROR_STACKTRACE" CLOB, "ERROR_TYPE" VARCHAR(20) ); @@ -727,3 +727,14 @@ CREATE TABLE "PROJECT_BRANCHES" ( ); CREATE UNIQUE INDEX "PK_PROJECT_BRANCHES" ON "PROJECT_BRANCHES" ("UUID"); CREATE UNIQUE INDEX "PROJECT_BRANCHES_KEE" ON "PROJECT_BRANCHES" ("PROJECT_UUID", "KEE"); + +CREATE TABLE "ANALYSIS_PROPERTIES" ( + "UUID" VARCHAR(40) NOT NULL PRIMARY KEY, + "SNAPSHOT_UUID" VARCHAR(40) NOT NULL, + "KEE" VARCHAR(512) NOT NULL, + "TEXT_VALUE" VARCHAR(4000), + "CLOB_VALUE" CLOB, + "IS_EMPTY" BOOLEAN NOT NULL, + "CREATED_AT" BIGINT NOT NULL +); +CREATE INDEX "SNAPSHOT_UUID" ON "ANALYSIS_PROPERTIES" ("SNAPSHOT_UUID"); |