summaryrefslogblamecommitdiff
path: root/src/sql/mysql/updates/update_20_to_21.sql
blob: 0bf9b3476fac6f8933cd7fef52e7e4dba662775a (plain) (tree)
1
2
3
4
5
6
7
8
9
10
                  








                                                                                         
       
START TRANSACTION;

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';

COMMIT;