aboutsummaryrefslogtreecommitdiffstats
path: root/sonar-db
diff options
context:
space:
mode:
authorSimon Brandhof <simon.brandhof@sonarsource.com>2016-11-07 14:31:51 +0100
committerGitHub <noreply@github.com>2016-11-07 14:31:51 +0100
commit5bcb1ae9ef1d237f312c7a64a96757843b9e3f20 (patch)
tree220118c1500ec02323f24fb9c8febe9b303b52d6 /sonar-db
parenteefb2a20f63723c1b6dca34bc9cd71893f66f9e0 (diff)
downloadsonarqube-5bcb1ae9ef1d237f312c7a64a96757843b9e3f20.tar.gz
sonarqube-5bcb1ae9ef1d237f312c7a64a96757843b9e3f20.zip
SONAR-8359 Increase size of LOB columns on embedded database
Use maximum supported size on H2 (2GB)
Diffstat (limited to 'sonar-db')
-rw-r--r--sonar-db/src/main/resources/org/sonar/db/version/schema-h2.ddl12
1 files changed, 6 insertions, 6 deletions
diff --git a/sonar-db/src/main/resources/org/sonar/db/version/schema-h2.ddl b/sonar-db/src/main/resources/org/sonar/db/version/schema-h2.ddl
index 683d55b6a74..e1c7c789984 100644
--- a/sonar-db/src/main/resources/org/sonar/db/version/schema-h2.ddl
+++ b/sonar-db/src/main/resources/org/sonar/db/version/schema-h2.ddl
@@ -268,7 +268,7 @@ CREATE TABLE "PROJECT_MEASURES" (
"VARIATION_VALUE_3" DOUBLE,
"VARIATION_VALUE_4" DOUBLE,
"VARIATION_VALUE_5" DOUBLE,
- "MEASURE_DATA" BINARY(167772150)
+ "MEASURE_DATA" BINARY
);
CREATE INDEX "MEASURES_COMPONENT_UUID" ON "PROJECT_MEASURES" ("COMPONENT_UUID");
CREATE INDEX "MEASURES_ANALYSIS_METRIC" ON "PROJECT_MEASURES" ("ANALYSIS_UUID", "METRIC_ID");
@@ -356,7 +356,7 @@ CREATE UNIQUE INDEX "ACTIVE_RULES_UNIQUE" ON "ACTIVE_RULES" ("PROFILE_ID","RULE_
CREATE TABLE "NOTIFICATIONS" (
"ID" INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1),
- "DATA" BLOB(167772150)
+ "DATA" BLOB
);
@@ -521,7 +521,7 @@ CREATE TABLE "ISSUES" (
"ISSUE_UPDATE_DATE" BIGINT,
"CREATED_AT" BIGINT,
"UPDATED_AT" BIGINT,
- "LOCATIONS" BLOB(167772150),
+ "LOCATIONS" BLOB,
"ISSUE_TYPE" TINYINT
);
CREATE UNIQUE INDEX "ISSUES_KEE" ON "ISSUES" ("KEE");
@@ -630,7 +630,7 @@ CREATE TABLE "FILE_SOURCES" (
"PROJECT_UUID" VARCHAR(50) NOT NULL,
"FILE_UUID" VARCHAR(50) NOT NULL,
"LINE_HASHES" CLOB(2147483647),
- "BINARY_DATA" BLOB(167772150),
+ "BINARY_DATA" BLOB,
"DATA_TYPE" VARCHAR(20),
"DATA_HASH" VARCHAR(50),
"SRC_HASH" VARCHAR(50),
@@ -686,7 +686,7 @@ CREATE INDEX "CE_ACTIVITY_ISLAST_STATUS" ON "CE_ACTIVITY" ("IS_LAST", "STATUS");
CREATE TABLE "CE_TASK_INPUT" (
"TASK_UUID" VARCHAR(40) NOT NULL PRIMARY KEY,
- "INPUT_DATA" BLOB(167772150),
+ "INPUT_DATA" BLOB,
"CREATED_AT" BIGINT NOT NULL,
"UPDATED_AT" BIGINT NOT NULL
);
@@ -694,7 +694,7 @@ CREATE TABLE "CE_TASK_INPUT" (
CREATE TABLE "CE_SCANNER_CONTEXT" (
"TASK_UUID" VARCHAR(40) NOT NULL PRIMARY KEY,
- "CONTEXT_DATA" BLOB(167772150) NOT NULL,
+ "CONTEXT_DATA" BLOB NOT NULL,
"CREATED_AT" BIGINT NOT NULL,
"UPDATED_AT" BIGINT NOT NULL
);