blob: b2e4834d9ed264cf69a27fda9d53bb9457dcff1a (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
-- add table tmw_online_list to store online users
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';
|