src/sql/mysql/updates/update_20_to_21.sql


1
2
3
4
5
6
7
8
9
10
11

BEGIN;

ALTER TABLE mana_char_specials ADD COLUMN special_current_mana int(10) unsigned NOT NULL;

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

END;