1 files changed, 11 insertions, 2 deletions
diff --git a/src/sql/mysql/createTables.sql b/src/sql/mysql/createTables.sql
index 5d412095..306e7c0a 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,13 @@ AS
      JOIN tmw_characters c
        ON l.char_id = c.id;
 
- 
-\ No newline at end of file
+ 
+CREATE TABLE IF NOT EXISTS `tmw_transactions` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `char_id` int(11) NOT NULL,
+  `action` int(11) NOT NULL,
+  `message` text,
+  `time` int(11) NOT NULL,
+  PRIMARY KEY  (`id`)
+)
+AUTO_INCREMENT=0 ;
+\ No newline at end of file