diff options
| author | Blue Sans Douze <bluesansdouze@gmail.com> | 2010-01-23 16:09:04 +0100 |
|---|---|---|
| committer | Blue Sans Douze <bluesansdouze@gmail.com> | 2010-01-23 16:09:04 +0100 |
| commit | d4097807182cc40f53365b13ef61f4bbd51f473e (patch) | |
| tree | 953ad18d057225f5221693fbb0c31ec814f5bd26 /src/sql | |
| parent | 757e2a56e546d7e266660e9670a14d8043924cb2 (diff) | |
| download | manaserv-d4097807182cc40f53365b13ef61f4bbd51f473e.tar.gz manaserv-d4097807182cc40f53365b13ef61f4bbd51f473e.tar.xz manaserv-d4097807182cc40f53365b13ef61f4bbd51f473e.zip | |
Fix a syntax error in MYSQL createTable script
Introduced in commit bb7866f0
Diffstat (limited to 'src/sql')
| -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 cd50c18..1f9bce3 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 |