From a201df8720aab627050b9f14f0b35c75780e3a92 Mon Sep 17 00:00:00 2001 From: Eric Hartmann Date: Mon, 29 Jan 2018 18:03:46 +0100 Subject: SONAR-10311 Add migration for DEPRECATED_RULE_KEYS table --- .../src/main/resources/org/sonar/db/version/schema-h2.ddl | 9 +++++++++ 1 file changed, 9 insertions(+) (limited to 'server/sonar-db-core') 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 175424d028c..5c287cea0ec 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 @@ -171,6 +171,15 @@ CREATE TABLE "RULE_REPOSITORIES" ( "CREATED_AT" BIGINT ); +CREATE TABLE "DEPRECATED_RULE_KEYS" ( + "UUID" VARCHAR(40) NOT NULL PRIMARY KEY, + "RULE_ID" INTEGER NOT NULL, + "OLD_REPOSITORY_KEY" VARCHAR(200) NOT NULL, + "OLD_RULE_KEY" VARCHAR(255) NOT NULL, + "CREATED_AT" BIGINT +); +CREATE UNIQUE INDEX "UNIQ_DEPRECATED_RULE_KEYS" ON "DEPRECATED_RULE_KEYS" ("OLD_REPOSITORY_KEY", "OLD_RULE_KEY"); +CREATE INDEX "RULE_ID_DEPRECATED_RULE_KEYS" ON "DEPRECATED_RULE_KEYS" ("RULE_ID"); CREATE TABLE "RULES" ( "ID" INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1), -- cgit v1.2.3