adresses #52
Change-Id: Ie80ff6b6f9caf9ebcec9ddce002a94b16fe48b71
- 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;
public static final int CONNECTION_TIMEOUT = 24 * 60 * 60;
"user_id" int NOT NULL,
"variant_id" int NOT NULL,
"pass_date" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
"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")
);
PRIMARY KEY ("id"),
UNIQUE ("user_id","variant_id","pass_date")
);
"version" smallint NOT NULL,
PRIMARY KEY ("version")
);
"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` (
DROP TABLE IF EXISTS `passwordResetTickets`;
CREATE TABLE `passwordResetTickets` (
--- /dev/null
+ALTER TABLE "cats_passed" ADD COLUMN "language" varchar(5) NOT NULL DEFAULT '';
+ALTER TABLE "cats_passed" ADD COLUMN "version" varchar(10) NOT NULL DEFAULT '';