src/sql/mysql/updates/update_17_to_18.sql


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 = '18',
moddate = UNIX_TIMESTAMP()
WHERE state_name = 'database_version';