From a07f3af045d1aaa2152168c42739dd23705b6b2f Mon Sep 17 00:00:00 2001
From: Blaymoira <none@none>
Date: Mon, 19 Jan 2009 17:38:03 +0100
Subject: *Merged db_version and script_db_version table in one table - by Zor

--HG--
branch : trunk
---
 sql/updates/917_world.sql | 8 ++++++++
 1 file changed, 8 insertions(+)
 create mode 100644 sql/updates/917_world.sql

(limited to 'sql/updates/917_world.sql')

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
-- 
cgit v1.2.3

