diff options
| author | megamage <none@none> | 2009-01-19 20:26:49 -0600 |
|---|---|---|
| committer | megamage <none@none> | 2009-01-19 20:26:49 -0600 |
| commit | 1bbd8968615e4b89fe4549bd1cccd089f6ad38f0 (patch) | |
| tree | 03fac7e4fc28dd1ee822faf923dd7475003e13ae /sql | |
| parent | 40e7dcb599c1e596151356a4cc4d6f641bc1ec05 (diff) | |
| parent | d1f6472e2bb6c55d6e837eefdeb7efdd10018a81 (diff) | |
*Update to trinity 921.
--HG--
branch : trunk
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) |