src/sql/mysql/updates/update_23_to_24.sql


1
2
3
4
5
6
7
8
9
10
11
12

START TRANSACTION;

ALTER TABLE mana_char_abilities DROP COLUMN ability_current_points;

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

COMMIT;