diff options
| -rw-r--r-- | src/sql/mysql/createTables.sql | 8 |
1 files 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 |