From bb7866f0f5046c82f73cf625adbdeaf101920cbb Mon Sep 17 00:00:00 2001
From: Chuck Miller <shadowmil@gmail.com>
Date: Sat, 16 Jan 2010 15:37:27 -0500
Subject: Updates mysql to database version 8

---
 src/sql/mysql/createTables.sql | 16 ++++++++++++++--
 1 file changed, 14 insertions(+), 2 deletions(-)

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

diff --git a/src/sql/mysql/createTables.sql b/src/sql/mysql/createTables.sql
index 0b75710e..cd50c187 100644
--- a/src/sql/mysql/createTables.sql
+++ b/src/sql/mysql/createTables.sql
@@ -89,7 +89,19 @@ CREATE TABLE IF NOT EXISTS `mana_char_status_effects` (
 ) ENGINE=InnoDB
 DEFAULT CHARSET=utf8;
 
+-- Create table 'mana_char_kill_stats'
 
+CREATE TABLE IF NOT EXISTS `mana_char_kill_stats`
+(
+    `char_id` int(11) NOT NULL,
+    `monster_id` int(11) NOT NULL,
+    `kills` int(11),
+    PRIMANY KEY (`char_id`, `monster_id`),
+    FOREIGN KEY (`char_id`)
+        REFERENCES `mana_characters` (`id`)
+        ON DELETE CASCADE
+) ENGINE=InnoDB
+DEFAULT CHARSET=utf8;
 
 
 --
@@ -371,7 +383,7 @@ AUTO_INCREMENT=0 ;
 
 INSERT INTO mana_world_states VALUES('accountserver_startup',NULL,NULL, NOW());
 INSERT INTO mana_world_states VALUES('accountserver_version',NULL,NULL, NOW());
-INSERT INTO mana_world_states VALUES('database_version',     NULL,'7',  NOW());
+INSERT INTO mana_world_states VALUES('database_version',     NULL,'8',  NOW());
 
 -- all known transaction codes
 
@@ -406,4 +418,4 @@ INSERT INTO mana_transaction_codes VALUES ( 28, 'Trade ended',              'Act
 INSERT INTO mana_transaction_codes VALUES ( 29, 'Trade money',              'Actions' );
 INSERT INTO mana_transaction_codes VALUES ( 30, 'Trade items',              'Actions' );
 INSERT INTO mana_transaction_codes VALUES ( 31, 'Attribute increased',      'Character' );
-INSERT INTO mana_transaction_codes VALUES ( 32, 'Attribute decreased',      'Character' );
\ No newline at end of file
+INSERT INTO mana_transaction_codes VALUES ( 32, 'Attribute decreased',      'Character' );
-- 
cgit v1.2.3-70-g09d2

