src/sql/sqlite/updates/update_23_to_24.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34

BEGIN;

CREATE TABLE mana_char_abilities_backup
(
    char_id                 INTEGER     NOT NULL,
    ability_id              INTEGER     NOT NULL,
    PRIMARY KEY (char_id, ability_id),
    FOREIGN KEY (char_id) REFERENCES mana_characters(id)
);

INSERT INTO mana_char_abilities_backup SELECT char_id, ability_id FROM mana_char_abilities;

DROP TABLE mana_char_abilities;

CREATE TABLE mana_char_abilities
(
    char_id                 INTEGER     NOT NULL,
    ability_id              INTEGER     NOT NULL,
    PRIMARY KEY (char_id, ability_id),
    FOREIGN KEY (char_id) REFERENCES mana_characters(id)
);

INSERT INTO mana_char_abilities SELECT char_id, ability_id FROM mana_char_abilities_backup;

DROP TABLE mana_char_abilities_backup;

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

END;