From a894af35f20a6f7c0b1d86e3f9b35863cea75d2d Mon Sep 17 00:00:00 2001 From: Blue112 Date: Sun, 19 Apr 2009 19:01:28 +0200 Subject: Mysql Backend Update mysql database to version 3 Fixed compile error with mysql backend --- src/sql/mysql/createTables.sql | 12 ++++++++++-- 1 file changed, 10 insertions(+), 2 deletions(-) (limited to 'src/sql') diff --git a/src/sql/mysql/createTables.sql b/src/sql/mysql/createTables.sql index 5d412095..7b533c7b 100644 --- a/src/sql/mysql/createTables.sql +++ b/src/sql/mysql/createTables.sql @@ -158,7 +158,7 @@ DEFAULT CHARSET=utf8; INSERT INTO tmw_world_states VALUES('accountserver_startup',NULL,NULL,UNIX_TIMESTAMP()); INSERT INTO tmw_world_states VALUES('accountserver_version',NULL,NULL,UNIX_TIMESTAMP()); -INSERT INTO tmw_world_states VALUES('database_version', NULL,'2', UNIX_TIMESTAMP()); +INSERT INTO tmw_world_states VALUES('database_version', NULL,'3', UNIX_TIMESTAMP()); -- -- table: `tmw_guilds` @@ -335,4 +335,12 @@ AS JOIN tmw_characters c ON l.char_id = c.id; - \ No newline at end of file + +CREATE TABLE tmw_transactions +( + id INTEGER PRIMARY KEY, + char_id INTEGER NOT NULL, + action INTEGER NOT NULL, + message TEXT, + time INTEGER NOT NULL +); \ No newline at end of file -- cgit v1.2.3-70-g09d2