From 54217640c85a97341df7395a9acc39a0b819692d Mon Sep 17 00:00:00 2001
From: Chuck Miller <shadowmil@gmail.com>
Date: Wed, 30 Sep 2009 00:10:58 -0400
Subject: Adds tmw_char_status_effects tables to mySQL and SQLite

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

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

diff --git a/src/sql/sqlite/updates/update_5_to_6.sql b/src/sql/sqlite/updates/update_5_to_6.sql
new file mode 100644
index 0000000..8a1e552
--- /dev/null
+++ b/src/sql/sqlite/updates/update_5_to_6.sql
@@ -0,0 +1,20 @@
+
+-- create table tmw_char_status_effects
+
+CREATE TABLE tmw_char_status_effects
+(
+    char_id     INTEGER     NOT NULL,
+    status_id   INTEGER     NOT NULL,
+    status_time INTEGER     NOT NULL,
+    --
+    FOREIGN KEY (char_id) REFERENCES tmw_characters(id)
+);
+
+CREATE INDEX tmw_char_status_char on tmw_char_status_effects ( char_id );
+
+-- update the database version, and set date of update
+UPDATE tmw_world_states
+   SET value      = '6',
+       moddate    = strftime('%s','now')
+ WHERE state_name = 'database_version';
+
-- 
cgit