From 084ba501e5879a03c74853b6b566841e5c152726 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Felix=20D=C3=B6rre?= Date: Tue, 28 Jun 2016 12:08:47 +0200 Subject: [PATCH] add columns for additional test-information adresses #52 Change-Id: Ie80ff6b6f9caf9ebcec9ddce002a94b16fe48b71 --- src/org/cacert/gigi/database/DatabaseConnection.java | 2 +- src/org/cacert/gigi/database/tableStructure.sql | 4 +++- src/org/cacert/gigi/database/upgrade/from_14.sql | 2 ++ 3 files changed, 6 insertions(+), 2 deletions(-) create mode 100644 src/org/cacert/gigi/database/upgrade/from_14.sql diff --git a/src/org/cacert/gigi/database/DatabaseConnection.java b/src/org/cacert/gigi/database/DatabaseConnection.java index 23131900..b4f2f0bb 100644 --- a/src/org/cacert/gigi/database/DatabaseConnection.java +++ b/src/org/cacert/gigi/database/DatabaseConnection.java @@ -122,7 +122,7 @@ public class DatabaseConnection { } - public static final int CURRENT_SCHEMA_VERSION = 14; + public static final int CURRENT_SCHEMA_VERSION = 15; public static final int CONNECTION_TIMEOUT = 24 * 60 * 60; diff --git a/src/org/cacert/gigi/database/tableStructure.sql b/src/org/cacert/gigi/database/tableStructure.sql index 1adb2057..8cd29110 100644 --- a/src/org/cacert/gigi/database/tableStructure.sql +++ b/src/org/cacert/gigi/database/tableStructure.sql @@ -299,6 +299,8 @@ CREATE TABLE "cats_passed" ( "user_id" int NOT NULL, "variant_id" int NOT NULL, "pass_date" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, + "language" varchar(5) NOT NULL DEFAULT '', + "version" varchar(10) NOT NULL DEFAULT '', PRIMARY KEY ("id"), UNIQUE ("user_id","variant_id","pass_date") ); @@ -374,7 +376,7 @@ CREATE TABLE "schemeVersion" ( "version" smallint NOT NULL, PRIMARY KEY ("version") ); -INSERT INTO "schemeVersion" (version) VALUES(14); +INSERT INTO "schemeVersion" (version) VALUES(15); DROP TABLE IF EXISTS `passwordResetTickets`; CREATE TABLE `passwordResetTickets` ( diff --git a/src/org/cacert/gigi/database/upgrade/from_14.sql b/src/org/cacert/gigi/database/upgrade/from_14.sql new file mode 100644 index 00000000..dc4ab812 --- /dev/null +++ b/src/org/cacert/gigi/database/upgrade/from_14.sql @@ -0,0 +1,2 @@ +ALTER TABLE "cats_passed" ADD COLUMN "language" varchar(5) NOT NULL DEFAULT ''; +ALTER TABLE "cats_passed" ADD COLUMN "version" varchar(10) NOT NULL DEFAULT ''; -- 2.39.2