src/sql/sqlite/updates/update_2_to_3.sql


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

-- add table tmw_transactions to store transactional history
CREATE TABLE tmw_transactions
(
    id          INTEGER     PRIMARY KEY,
    char_id     INTEGER     NOT NULL,
    action      INTEGER     NOT NULL,
    message     TEXT,
    time        INTEGER     NOT NULL
);
 
-- update the database version, and set date of update
UPDATE tmw_world_states
   SET value      = '3',
       moddate    = strftime('%s','now')
 WHERE state_name = 'database_version';