From 5bcb1ae9ef1d237f312c7a64a96757843b9e3f20 Mon Sep 17 00:00:00 2001 From: Simon Brandhof Date: Mon, 7 Nov 2016 14:31:51 +0100 Subject: [PATCH] SONAR-8359 Increase size of LOB columns on embedded database Use maximum supported size on H2 (2GB) --- .../resources/org/sonar/db/version/schema-h2.ddl | 12 ++++++------ 1 file 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 ); -- 2.39.5