From 0856ba6fb98c2f32b1a10f47c40a9c5eabbc4a90 Mon Sep 17 00:00:00 2001 From: Sébastien Lesaint Date: Fri, 10 Mar 2017 16:40:25 +0100 Subject: SONAR-8931 extend size of LOADED_TEMPLATES.TEMPLATE_TYPE --- .../sonar-db-core/src/main/resources/org/sonar/db/version/rows-h2.sql | 4 ++++ .../src/main/resources/org/sonar/db/version/schema-h2.ddl | 3 ++- 2 files changed, 6 insertions(+), 1 deletion(-) (limited to 'server/sonar-db-core/src') diff --git a/server/sonar-db-core/src/main/resources/org/sonar/db/version/rows-h2.sql b/server/sonar-db-core/src/main/resources/org/sonar/db/version/rows-h2.sql index 51b6f812af3..300a33d2194 100644 --- a/server/sonar-db-core/src/main/resources/org/sonar/db/version/rows-h2.sql +++ b/server/sonar-db-core/src/main/resources/org/sonar/db/version/rows-h2.sql @@ -543,6 +543,10 @@ INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1607'); INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1608'); INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1609'); INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1610'); +INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1611'); +INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1612'); +INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1613'); +INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1614'); INSERT INTO USERS(ID, LOGIN, NAME, EMAIL, EXTERNAL_IDENTITY, EXTERNAL_IDENTITY_PROVIDER, USER_LOCAL, CRYPTED_PASSWORD, SALT, IS_ROOT, CREATED_AT, UPDATED_AT) VALUES (1, 'admin', 'Administrator', '', 'admin', 'sonarqube', true, 'a373a0e667abb2604c1fd571eb4ad47fe8cc0878', '48bc4b0d93179b5103fd3885ea9119498e9d161b', false, '1418215735482', '1418215735482'); ALTER TABLE USERS ALTER COLUMN ID RESTART WITH 2; 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 028846ad102..96468bb9352 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 @@ -406,8 +406,9 @@ CREATE UNIQUE INDEX "METRICS_UNIQUE_NAME" ON "METRICS" ("NAME"); CREATE TABLE "LOADED_TEMPLATES" ( "ID" INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1), "KEE" VARCHAR(200), - "TEMPLATE_TYPE" VARCHAR(15) + "TEMPLATE_TYPE" VARCHAR(64) NOT NULL ); +CREATE INDEX "IX_LOADED_TEMPLATES_TYPE" ON "LOADED_TEMPLATES" ("TEMPLATE_TYPE"); CREATE TABLE "AUTHORS" ( -- cgit v1.2.3