diff options
| author | Yohann Ferreira <yohann_dot_ferreira_at_orange_dot_efer> | 2011-08-25 23:35:25 +0200 |
|---|---|---|
| committer | Yohann Ferreira <yohann_dot_ferreira_at_orange_dot_efer> | 2011-08-25 23:35:25 +0200 |
| commit | ec99e999a918f6680d38704d9408933090d0386a (patch) | |
| tree | 89e2361ccc9da7d88c10cc0967e9898d9cdab0a6 /src/sql/mysql/createTables.sql | |
| parent | f2368c9887e8b97b76e459a5088ed52bb5ee4512 (diff) | |
| parent | a4d0b4d6e0360f09b1f01ec59f548cdb297ebd4c (diff) | |
| download | manaserv-ec99e999a918f6680d38704d9408933090d0386a.tar.gz manaserv-ec99e999a918f6680d38704d9408933090d0386a.tar.bz2 manaserv-ec99e999a918f6680d38704d9408933090d0386a.tar.xz manaserv-ec99e999a918f6680d38704d9408933090d0386a.zip | |
Merge branch 'equipment-fix' of github.com:Bertram25/manaserv
Diffstat (limited to 'src/sql/mysql/createTables.sql')
| -rw-r--r-- | src/sql/mysql/createTables.sql | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/src/sql/mysql/createTables.sql b/src/sql/mysql/createTables.sql index 9e1e31a6..d017ceee 100644 --- a/src/sql/mysql/createTables.sql +++ b/src/sql/mysql/createTables.sql @@ -184,11 +184,11 @@ AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS `mana_char_equips` ( `id` int(10) unsigned NOT NULL auto_increment, `owner_id` int(10) unsigned NOT NULL, - `slot_type` tinyint(3) unsigned NOT NULL, - `inventory_slot` tinyint(3) unsigned NOT NULL, + `slot_type` int(10) unsigned NOT NULL, + `item_id` int(10) unsigned NOT NULL, + `item_instance` int(10) unsigned NOT NULL, -- PRIMARY KEY (`id`), - UNIQUE KEY `owner_id` (`owner_id`, `inventory_slot`), FOREIGN KEY (`owner_id`) REFERENCES `mana_characters` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |