From 04ebe945e98e397192272d1e3f5e6b91ebd3d795 Mon Sep 17 00:00:00 2001 From: Andreas Habel Date: Mon, 17 Aug 2009 19:18:36 +0200 Subject: Update table tmw_accounts. Added columns to store secret key and expiration time for password recovery via tmwweb/email. --- src/sql/sqlite/createTables.sql | 20 +++++++++++--------- 1 file changed, 11 insertions(+), 9 deletions(-) (limited to 'src/sql/sqlite/createTables.sql') diff --git a/src/sql/sqlite/createTables.sql b/src/sql/sqlite/createTables.sql index 1831c45..682a94d 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 ( -- cgit