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

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

diff --git a/src/sql/sqlite/createTables.sql b/src/sql/sqlite/createTables.sql
index 26881fd..e3222da 100644
--- a/src/sql/sqlite/createTables.sql
+++ b/src/sql/sqlite/createTables.sql
@@ -97,6 +97,19 @@ CREATE INDEX mana_char_status_char on mana_char_status_effects ( char_id );
 
 -----------------------------------------------------------------------------
 
+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_char on mana_char_status_effects ( char_id );
+
+-----------------------------------------------------------------------------
+
 CREATE TABLE mana_items
 (
     id           INTEGER    PRIMARY KEY,
-- 
cgit 

