summaryrefslogblamecommitdiff
path: root/src/sql/sqlite/updates/update_13_to_14.sql
blob: 506681472311a35fe10c45e1c11f57d8734cd605 (plain) (tree)
1
2
3
4
5
6
7
8
9
10

                                               
                                                                  






                                                      
-- Add the slot column to table mana_characters
ALTER TABLE mana_characters ADD slot INTEGER NOT NULL DEFAULT (0);

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