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 +++++++++++--------- src/sql/sqlite/updates/update_3_to_4.sql | 13 +++++++++++++ 2 files changed, 24 insertions(+), 9 deletions(-) create mode 100644 src/sql/sqlite/updates/update_3_to_4.sql (limited to 'src/sql') 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'; + -- cgit v1.2.3-70-g09d2