path: root/src/sql/sqlite/updates/update_2_to_3.sql

-- 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';