X-Git-Url: https://code.wpia.club/?a=blobdiff_plain;f=src%2Forg%2Fcacert%2Fgigi%2Fdatabase%2FtableStructure.sql;h=947b09edac5f4c4378f47a1a522593c760855537;hb=a39d4f72c5da6c1066ff8529f65af9f908c86c93;hp=a8d92f57dca3879a8c39aa2ddd5bb51c5b956598;hpb=b59c37e88149d0463ab4b802cacb6f0ea883acfb;p=gigi.git

diff --git a/src/org/cacert/gigi/database/tableStructure.sql b/src/org/cacert/gigi/database/tableStructure.sql
index a8d92f57..947b09ed 100644
--- a/src/org/cacert/gigi/database/tableStructure.sql
+++ b/src/org/cacert/gigi/database/tableStructure.sql
@@ -16,6 +16,7 @@ CREATE TABLE "users" (
   "dob" date NOT NULL,
   "verified" boolean NOT NULL DEFAULT 'false',
   "language" varchar(5) NOT NULL DEFAULT '',
+  "country" varchar(2) NULL,
   PRIMARY KEY ("id")
 );
 CREATE INDEX ON "users" ("email");
@@ -373,7 +374,7 @@ CREATE TABLE "schemeVersion" (
   "version" smallint NOT NULL,
   PRIMARY KEY ("version")
 );
-INSERT INTO "schemeVersion" (version)  VALUES(22);
+INSERT INTO "schemeVersion" (version)  VALUES(23);
 
 DROP TABLE IF EXISTS `passwordResetTickets`;
 CREATE TABLE `passwordResetTickets` (