Update table tmw_accounts. Added columns to store secret key and expiration

time for password recovery via tmwweb/email.

2 files changed, 24 insertions, 9 deletions

diff --git a/src/sql/sqlite/createTables.sql b/src/sql/sqlite/createTables.sql
index 1831c45a..682a94d4 100644
--- a/src/sql/sqlite/createTables.sql
+++ b/src/sql/sqlite/createTables.sql
@@ -1,13 +1,15 @@
 CREATE TABLE tmw_accounts
 (
-   id           INTEGER     PRIMARY KEY,
-   username     TEXT        NOT NULL UNIQUE,
-   password     TEXT        NOT NULL,
-   email        TEXT        NOT NULL,
-   level        INTEGER     NOT NULL,
-   banned       INTEGER     NOT NULL,
-   registration INTEGER     NOT NULL,
-   lastlogin    INTEGER     NOT NULL
+   id            INTEGER     PRIMARY KEY,
+   username      TEXT        NOT NULL UNIQUE,
+   password      TEXT        NOT NULL,
+   email         TEXT        NOT NULL,
+   level         INTEGER     NOT NULL,
+   banned        INTEGER     NOT NULL,
+   registration  INTEGER     NOT NULL,
+   lastlogin     INTEGER     NOT NULL,
+   authorization TEXT            NULL,
+   expiration    INTEGER         NULL
 );
 
 CREATE UNIQUE INDEX tmw_accounts_username ON tmw_accounts ( username );
@@ -142,7 +144,7 @@ CREATE TABLE tmw_world_states
 
 INSERT INTO tmw_world_states VALUES('accountserver_startup',NULL,NULL, strftime('%s','now'));
 INSERT INTO tmw_world_states VALUES('accountserver_version',NULL,NULL, strftime('%s','now'));
-INSERT INTO tmw_world_states VALUES('database_version',     NULL,'3',  strftime('%s','now'));
+INSERT INTO tmw_world_states VALUES('database_version',     NULL,'4',  strftime('%s','now'));
 
 CREATE TABLE tmw_auctions
 (
diff --git a/src/sql/sqlite/updates/update_3_to_4.sql b/src/sql/sqlite/updates/update_3_to_4.sql
new file mode 100644
index 00000000..94d2edd4
--- /dev/null
+++ b/src/sql/sqlite/updates/update_3_to_4.sql
@@ -0,0 +1,13 @@
+
+-- add two columns to table tmw_accounts
+ALTER TABLE tmw_accounts ADD
+    authorization TEXT            NULL,
+    expiration    INTEGER         NULL
+;
+
+-- update the database version, and set date of update
+UPDATE tmw_world_states
+   SET value      = '4',
+       moddate    = strftime('%s','now')
+ WHERE state_name = 'database_version';
+