blob: 1036817b81b662c94481c34c44e9a08d6a4fdfad (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
|
-- Dropping the table will only unequip characters, so it's not an issue.
DROP TABLE mana_char_equips;
-- Recreate the table using the latest definition.
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` int(10) unsigned NOT NULL,
`item_id` int(10) unsigned NOT NULL,
`item_instance` int(10) unsigned NOT NULL,
--
PRIMARY KEY (`id`),
FOREIGN KEY (`owner_id`) REFERENCES `mana_characters` (`id`)
) ENGINE=InnoDB
DEFAULT CHARSET=utf8;
-- Update database version.
UPDATE mana_world_states
SET value = '15',
moddate = UNIX_TIMESTAMP()
WHERE state_name = 'database_version';
|