diff options
| author | Blaymoira <none@none> | 2009-01-19 17:38:03 +0100 |
|---|---|---|
| committer | Blaymoira <none@none> | 2009-01-19 17:38:03 +0100 |
| commit | a07f3af045d1aaa2152168c42739dd23705b6b2f (patch) | |
| tree | a461ea560392d67c0421fe6d81996641a80cf222 /sql | |
| parent | f62a24b2fdb75e65468305735ac88500c5d305d1 (diff) | |
*Merged db_version and script_db_version table in one table - by Zor
--HG--
branch : trunk
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/917_world.sql | 8 |
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 |