summaryrefslogtreecommitdiff
path: root/src/sql/sqlite/updates/update_20_to_21.sql
blob: 8456532683cf2ac45b6ca95d25badea504a14d25 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
BEGIN;

ALTER TABLE mana_char_specials ADD COLUMN special_current_mana INTEGER DEFAULT 0 NOT NULL;

-- Update the database version, and set date of update
UPDATE mana_world_states
   SET value      = '21',
       moddate    = strftime('%s','now')
   WHERE state_name = 'database_version';

END;