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

time for password recovery via tmwweb/email.

1 files changed, 11 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
 (