From 04ebe945e98e397192272d1e3f5e6b91ebd3d795 Mon Sep 17 00:00:00 2001
From: Andreas Habel <mail@exceptionfault.de>
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/updates/update_3_to_4.sql | 13 +++++++++++++
 1 file changed, 13 insertions(+)
 create mode 100644 src/sql/sqlite/updates/update_3_to_4.sql

(limited to 'src/sql/sqlite/updates')

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 0000000..94d2edd
--- /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