From d4097807182cc40f53365b13ef61f4bbd51f473e Mon Sep 17 00:00:00 2001 From: Blue Sans Douze Date: Sat, 23 Jan 2010 16:09:04 +0100 Subject: Fix a syntax error in MYSQL createTable script Introduced in commit bb7866f0 --- src/sql/mysql/createTables.sql | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/src/sql/mysql/createTables.sql b/src/sql/mysql/createTables.sql index cd50c187..1f9bce3c 100644 --- a/src/sql/mysql/createTables.sql +++ b/src/sql/mysql/createTables.sql @@ -93,10 +93,10 @@ DEFAULT CHARSET=utf8; 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`), + `char_id` int(10) unsigned NOT NULL, + `monster_id` int(10) unsigned NOT NULL, + `kills` int(10) NULL, + PRIMARY KEY (`char_id`, `monster_id`), FOREIGN KEY (`char_id`) REFERENCES `mana_characters` (`id`) ON DELETE CASCADE -- cgit v1.2.3-70-g09d2