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/createTables.sql | 15 ++++++++++++++-
 1 file changed, 14 insertions(+), 1 deletion(-)

(limited to 'src/sql/sqlite/createTables.sql')

diff --git a/src/sql/sqlite/createTables.sql b/src/sql/sqlite/createTables.sql
index 5cd439d..d71858f 100644
--- a/src/sql/sqlite/createTables.sql
+++ b/src/sql/sqlite/createTables.sql
@@ -84,6 +84,19 @@ CREATE INDEX tmw_char_skills_char ON tmw_char_skills ( char_id );
 
 -----------------------------------------------------------------------------
 
+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 );
+
+-----------------------------------------------------------------------------
+
 CREATE TABLE tmw_items
 (
     id           INTEGER    PRIMARY KEY,
@@ -348,7 +361,7 @@ AS
 
 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,'5',  strftime('%s','now'));
+INSERT INTO tmw_world_states VALUES('database_version',     NULL,'6',  strftime('%s','now'));
 
 -- all known transaction codes
 
-- 
cgit 

