src/sql/mysql/updates/update_13_to_14.sql


1
2
3
4
5
6
7
8
9
10
11

--
-- Modify the table `mana_characters` to add the slot field.
--

ALTER TABLE `mana_characters` ADD COLUMN `slot` smallint(5) unsigned NOT NULL;

-- Update database version.
UPDATE mana_world_states
SET value = '14',
moddate = UNIX_TIMESTAMP()
WHERE state_name = 'database_version';