1 files changed, 10 insertions, 2 deletions
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