From 84ab289a40c0fcf40a6d9f5177e0328604fea8be Mon Sep 17 00:00:00 2001 From: maximius Date: Sat, 8 Aug 2009 21:51:55 -0700 Subject: *Cleaned up SQL, updated FULLs --HG-- branch : trunk --- sql/updates/4836_world_announce.sql | 15 +++++++++++++++ sql/updates/XXX_world_announce.sql | 14 -------------- 2 files changed, 15 insertions(+), 14 deletions(-) create mode 100644 sql/updates/4836_world_announce.sql delete mode 100644 sql/updates/XXX_world_announce.sql (limited to 'sql/updates') diff --git a/sql/updates/4836_world_announce.sql b/sql/updates/4836_world_announce.sql new file mode 100644 index 00000000000..1e8920baa7c --- /dev/null +++ b/sql/updates/4836_world_announce.sql @@ -0,0 +1,15 @@ +DROP TABLE IF EXISTS `autobroadcast`; +CREATE TABLE `autobroadcast` ( +`id` int(11) NOT NULL AUTO_INCREMENT, +`text` longtext NOT NULL, +PRIMARY KEY (`id`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +DELETE FROM `trinity_string` WHERE `entry` = 11000; +INSERT INTO `trinity_string` (entry, content_default, content_loc1, content_loc2, content_loc3, content_loc4, content_loc5, content_loc6, content_loc7, content_loc8) +VALUES (11000, '|cffffff00[|c00077766Autobroadcast|cffffff00]: |cFFF222FF%s|r', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); + +-- optional examples +-- insert into `autobroadcast` (`id`, `text`) values('1','All Battlegrounds and Arena's work on this server.'); +-- insert into `autobroadcast` (`id`, `text`) values('2','This server has 2 realms, The other realm is a PVP instant level 70 realm. Try it!'); +-- insert into `autobroadcast` (`id`, `text`) values('3','The Auction House on this server is always full, because we use an AH Bot.'); diff --git a/sql/updates/XXX_world_announce.sql b/sql/updates/XXX_world_announce.sql deleted file mode 100644 index 59accbfc9bb..00000000000 --- a/sql/updates/XXX_world_announce.sql +++ /dev/null @@ -1,14 +0,0 @@ -CREATE TABLE `autobroadcast` ( -`id` int(11) NOT NULL AUTO_INCREMENT, -`text` longtext NOT NULL, -PRIMARY KEY (`id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -DELETE FROM `trinity_string` WHERE `entry` = 11000; -INSERT INTO `trinity_string` (entry, content_default, content_loc1, content_loc2, content_loc3, content_loc4, content_loc5, content_loc6, content_loc7, content_loc8) -VALUES (11000, '|cffffff00[|c00077766Autobroadcast|cffffff00]: |cFFF222FF%s|r', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); - --- optional examples --- insert into `autobroadcast` (`id`, `text`) values('1','All Battlegrounds and Arena's work on this server.'); --- insert into `autobroadcast` (`id`, `text`) values('2','This server has 2 realms, The other realm is a PVP instant level 70 realm. Try it!'); --- insert into `autobroadcast` (`id`, `text`) values('3','The Auction House on this server is always full, because we use an AH Bot.'); -- cgit v1.2.3