1 files changed, 18 insertions, 0 deletions
diff --git a/src/sql/mysql/updates/update_2_to_3.sql b/src/sql/mysql/updates/update_2_to_3.sql
new file mode 100644
index 00000000..feb8ee2a
--- /dev/null
+++ b/src/sql/mysql/updates/update_2_to_3.sql
@@ -0,0 +1,18 @@
+
+-- add table tmw_transactions to store transactional history
+CREATE TABLE IF NOT EXISTS `tmw_transactions` (
+  `id` int(11) NOT NULL,
+  `char_id` int(11) NOT NULL,
+  `action` int(11) NOT NULL,
+  `message` text,
+  `time` int(11) NOT NULL,
+  PRIMARY KEY  (`id`)
+);
+
+ALTER TABLE `tmw_transactions` CHANGE `id` `id` INT( 11 ) NOT NULL AUTO_INCREMENT;
+ 
+-- update the database version, and set date of update
+UPDATE tmw_world_states
+   SET value      = '3',
+       moddate    = UNIX_TIMESTAMP()
+ WHERE state_name = 'database_version';
+\ No newline at end of file