From e26e524ad739dafd99954add3c2f35842e9fb6ec Mon Sep 17 00:00:00 2001
From: blue112 <bluesansdouze@gmail.com>
Date: Mon, 20 Apr 2009 15:40:38 +0200
Subject: Mysql update file

Update file... updated ^^'
You can execute it a second time, there's no problem.
---
 src/sql/mysql/createTables.sql | 17 +++++++++--------
 1 file changed, 9 insertions(+), 8 deletions(-)

(limited to 'src/sql/mysql/createTables.sql')

diff --git a/src/sql/mysql/createTables.sql b/src/sql/mysql/createTables.sql
index 7b533c7..306e7c0 100644
--- a/src/sql/mysql/createTables.sql
+++ b/src/sql/mysql/createTables.sql
@@ -336,11 +336,12 @@ AS
        ON l.char_id = c.id;
 
  
-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
+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
-- 
cgit 

