From a894af35f20a6f7c0b1d86e3f9b35863cea75d2d Mon Sep 17 00:00:00 2001
From: Blue112 <bluesansdouze@gmail.com>
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/mysql/createTables.sql')

diff --git a/src/sql/mysql/createTables.sql b/src/sql/mysql/createTables.sql
index 5d41209..7b533c7 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 

