From be548ff54b8fa60a8a778714cd8fa5326722c0aa Mon Sep 17 00:00:00 2001
From: David Athay <ko2fan@gmail.com>
Date: Thu, 5 Mar 2009 14:30:19 +0000
Subject: Added transactional history

---
 src/sql/sqlite/updates/update_2_to_3.sql | 17 +++++++++++++++++
 1 file changed, 17 insertions(+)
 create mode 100644 src/sql/sqlite/updates/update_2_to_3.sql

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

diff --git a/src/sql/sqlite/updates/update_2_to_3.sql b/src/sql/sqlite/updates/update_2_to_3.sql
new file mode 100644
index 0000000..b2e4834
--- /dev/null
+++ b/src/sql/sqlite/updates/update_2_to_3.sql
@@ -0,0 +1,17 @@
+
+-- add table tmw_online_list to store online users
+CREATE TABLE tmw_transactions
+(
+    id          INTEGER     PRIMARY KEY,
+    char_id     INTEGER     NOT NULL,
+    action      INTEGER     NOT NULL,
+    message     TEXT,
+    time        INTEGER     NOT NULL,
+);
+ 
+-- update the database version, and set date of update
+UPDATE tmw_world_states
+   SET value      = '3',
+       moddate    = strftime('%s','now')
+ WHERE state_name = 'database_version';
+
-- 
cgit