diff options
Diffstat (limited to 'src/sql/mysql/createTables.sql')
-rw-r--r-- | src/sql/mysql/createTables.sql | 17 |
1 files changed, 9 insertions, 8 deletions
diff --git a/src/sql/mysql/createTables.sql b/src/sql/mysql/createTables.sql index 7b533c7b..306e7c0a 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 |