aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/917_world.sql8
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/917_world.sql b/sql/updates/917_world.sql
new file mode 100644
index 00000000000..084091ec0af
--- /dev/null
+++ b/sql/updates/917_world.sql
@@ -0,0 +1,8 @@
+CREATE TABLE `version` (
+ `core_version` varchar(120) default NULL COMMENT 'Core revision dumped at startup.',
+ `db_version` varchar(120) default NULL COMMENT 'Version of world DB.',
+ `script_version` varchar(120) default NULL COMMENT 'Version of scripts DB.'
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Version Notes';
+INSERT INTO version (core_version, db_version, script_version) VALUES ("",(SELECT version FROM db_version),(SELECT version FROM script_db_version));
+DROP TABLE IF EXISTS db_version;
+DROP TABLE IF EXISTS script_db_version; \ No newline at end of file