src/sql/sqlite/updates/update_7_to_8.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20

-- create table mana_char_kill_stats

CREATE TABLE mana_char_kill_stats
(
    char_id     INTEGER     NOT NULL,
    monster_id  INTEGER     NOT NULL,
    kills       INTEGER     NOT NULL,
    --
    FOREIGN KEY (char_id) REFERENCES mana_characters(id)
);

CREATE INDEX mana_char_kill_stats_chars on mana_char_kill_stats ( char_id );

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