diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/917_world.sql | 8 | ||||
| -rw-r--r-- | sql/updates/919_world.sql | 2 | ||||
| -rw-r--r-- | sql/updates/CMakeLists.txt | 4 |
3 files changed, 14 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 diff --git a/sql/updates/919_world.sql b/sql/updates/919_world.sql new file mode 100644 index 00000000000..24267d49223 --- /dev/null +++ b/sql/updates/919_world.sql @@ -0,0 +1,2 @@ +ALTER TABLE version + ADD `core_revision` BIGINT UNSIGNED AFTER `core_version`;
\ No newline at end of file diff --git a/sql/updates/CMakeLists.txt b/sql/updates/CMakeLists.txt index ef9a6927e30..dc983f8c14d 100644 --- a/sql/updates/CMakeLists.txt +++ b/sql/updates/CMakeLists.txt @@ -138,4 +138,8 @@ INSTALL(FILES 857_world_scripts.sql 863_world_scripts.sql 871_world.sql +884_world.sql +905_world_scripts.sql +917_world.sql +919_world.sql DESTINATION share/trinity/sql/updates) |