From 51ff98ce18366e0e7f44520bb41696ba0c0beb46 Mon Sep 17 00:00:00 2001 From: Vincent-Michael Date: Sun, 2 Oct 2016 00:55:15 +0200 Subject: SQL: Rename 2016_10_00_00_world.sql -> 2016_10_01_00_world.sql --- sql/updates/world/6.x/2016_10_00_00_world.sql | 59 --------------------------- sql/updates/world/6.x/2016_10_01_00_world.sql | 59 +++++++++++++++++++++++++++ 2 files changed, 59 insertions(+), 59 deletions(-) delete mode 100644 sql/updates/world/6.x/2016_10_00_00_world.sql create mode 100644 sql/updates/world/6.x/2016_10_01_00_world.sql (limited to 'sql') diff --git a/sql/updates/world/6.x/2016_10_00_00_world.sql b/sql/updates/world/6.x/2016_10_00_00_world.sql deleted file mode 100644 index 2a51293f498..00000000000 --- a/sql/updates/world/6.x/2016_10_00_00_world.sql +++ /dev/null @@ -1,59 +0,0 @@ -DROP TABLE IF EXISTS `mount_definitions`; -CREATE TABLE `mount_definitions`( - `spellId` int(10) unsigned NOT NULL, - `otherFactionSpellId` int(10) unsigned NOT NULL, - PRIMARY KEY (`spellId`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -DELETE FROM `mount_definitions`; -INSERT INTO `mount_definitions` (`spellId`,`otherFactionSpellId`) VALUES -(17229,64658), -(23509,23510), -(23510,23509), -(55531,60424), -(59785,59788), -(59788,59785), -(59797,59799), -(59799,59797), -(60114,60116), -(60116,60114), -(60118,60119), -(60119,60118), -(60424,55531), -(61229,61230), -(61230,61229), -(61425,61447), -(61447,61425), -(61465,61467), -(61467,61465), -(61469,61470), -(61470,61469), -(61996,61997), -(61997,61996), -(64658,17229), -(66087,66088), -(66088,66087), -(66090,66091), -(66091,66090), -(90621,93644), -(92231,92232), -(92232,92231), -(93644,90621), -(107516,107517), -(107517,107516), -(118737,130985), -(130985,118737), -(135416,135418), -(135418,135416), -(136163,136164), -(136164,136163), -(140249,140250), -(140250,140249), -(142266,142478), -(142478,142266), -(171625,171842), -(171626,171839), -(171839,171626), -(171842,171625), -(179244,179245), -(179245,179244); diff --git a/sql/updates/world/6.x/2016_10_01_00_world.sql b/sql/updates/world/6.x/2016_10_01_00_world.sql new file mode 100644 index 00000000000..2a51293f498 --- /dev/null +++ b/sql/updates/world/6.x/2016_10_01_00_world.sql @@ -0,0 +1,59 @@ +DROP TABLE IF EXISTS `mount_definitions`; +CREATE TABLE `mount_definitions`( + `spellId` int(10) unsigned NOT NULL, + `otherFactionSpellId` int(10) unsigned NOT NULL, + PRIMARY KEY (`spellId`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +DELETE FROM `mount_definitions`; +INSERT INTO `mount_definitions` (`spellId`,`otherFactionSpellId`) VALUES +(17229,64658), +(23509,23510), +(23510,23509), +(55531,60424), +(59785,59788), +(59788,59785), +(59797,59799), +(59799,59797), +(60114,60116), +(60116,60114), +(60118,60119), +(60119,60118), +(60424,55531), +(61229,61230), +(61230,61229), +(61425,61447), +(61447,61425), +(61465,61467), +(61467,61465), +(61469,61470), +(61470,61469), +(61996,61997), +(61997,61996), +(64658,17229), +(66087,66088), +(66088,66087), +(66090,66091), +(66091,66090), +(90621,93644), +(92231,92232), +(92232,92231), +(93644,90621), +(107516,107517), +(107517,107516), +(118737,130985), +(130985,118737), +(135416,135418), +(135418,135416), +(136163,136164), +(136164,136163), +(140249,140250), +(140250,140249), +(142266,142478), +(142478,142266), +(171625,171842), +(171626,171839), +(171839,171626), +(171842,171625), +(179244,179245), +(179245,179244); -- cgit v1.2.3