From de7d79c7f42636065ca5281fa3bec151e34a7c48 Mon Sep 17 00:00:00 2001
From: Philipp Sehmisch <mana@crushnet.org>
Date: Fri, 8 Jan 2010 22:01:45 +0100
Subject: Added tracing of kill count for each monster per character

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

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

diff --git a/src/sql/sqlite/updates/update_7_to_8.sql b/src/sql/sqlite/updates/update_7_to_8.sql
new file mode 100644
index 0000000..35593c6
--- /dev/null
+++ b/src/sql/sqlite/updates/update_7_to_8.sql
@@ -0,0 +1,20 @@
+
+-- create table mana_char_kill_stats
+
+CREATE TABLE mana_char_kill_stats
+(
+    char_id     INTEGER     NOT NULL,
+    monster_id  INTEGER     NOT NULL,
+    kills       INTEGER     NOT NULL,
+    --
+    FOREIGN KEY (char_id) REFERENCES mana_characters(id)
+);
+
+CREATE INDEX mana_char_kill_stats_chars on mana_char_kill_stats ( char_id );
+
+-- update the database version, and set date of update
+UPDATE mana_world_states
+   SET value      = '8',
+       moddate    = strftime('%s','now')
+ WHERE state_name = 'database_version';
+
-- 
cgit