4 files changed, 45 insertions, 0 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index 943be73b20f..05e680f94eb 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -126,6 +126,32 @@ CREATE TABLE `ip_banned` (
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Banned IPs';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
+/*Table structure for table `ip2nation` */
+
+DROP TABLE IF EXISTS `ip2nation`;
+
+CREATE TABLE `ip2nation` (
+  `ip` int(11) unsigned NOT NULL DEFAULT '0',
+  `country` char(2) NOT NULL DEFAULT '',
+  KEY `ip` (`ip`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+/*Table structure for table `ip2nationCountries` */
+
+DROP TABLE IF EXISTS `ip2nationCountries`;
+
+CREATE TABLE `ip2nationCountries` (
+  `code` varchar(4) NOT NULL DEFAULT '',
+  `iso_code_2` varchar(2) NOT NULL DEFAULT '',
+  `iso_code_3` varchar(3) DEFAULT '',
+  `iso_country` varchar(255) NOT NULL DEFAULT '',
+  `country` varchar(255) NOT NULL DEFAULT '',
+  `lat` float NOT NULL DEFAULT '0',
+  `lon` float NOT NULL DEFAULT '0',
+  PRIMARY KEY (`code`),
+  KEY `code` (`code`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
 --
 -- Dumping data for table `ip_banned`
 --
diff --git a/sql/updates/auth/2013_04_25_00_auth_misc.txt b/sql/updates/auth/2013_04_25_00_auth_misc.txt
new file mode 100644
index 00000000000..383b19ebd55
--- /dev/null
+++ b/sql/updates/auth/2013_04_25_00_auth_misc.txt
@@ -0,0 +1,8 @@
+DROP TABLE IF EXISTS `autobroadcast`;
+CREATE TABLE `autobroadcast` (
+  `realmid` int(10) NOT NULL,
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `weight` tinyint(3) DEFAULT 1,
+  `text` longtext NOT NULL,
+  PRIMARY KEY (`id`, `realmid`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
diff --git a/sql/updates/world/2013_04_16_01_world_misc.sql b/sql/updates/world/2013_04_16_01_world_misc.sql
new file mode 100644
index 00000000000..4c7561a0e69
--- /dev/null
+++ b/sql/updates/world/2013_04_16_01_world_misc.sql
@@ -0,0 +1,10 @@
+DELETE FROM `command` WHERE `name` = 'guild rename';
+INSERT INTO `command` (`name`, `security`, `help`) VALUES
+('guild rename', 3, 'Syntax: .guild rename "$GuildName" "$NewGuildName" \n\n Rename a guild named $GuildName with $NewGuildName. Guild name and new guild name must in quotes.');
+
+SET @ENTRY1 := 96;
+SET @ENTRY2 := 97;
+DELETE FROM `trinity_string` WHERE `entry` IN (@ENTRY1, @ENTRY2);
+INSERT INTO `trinity_string` (`entry`, `content_default`) VALUES
+(@ENTRY1, 'The guild name \'%s\' is already taken'),
+(@ENTRY2, 'Changed guild name \'%s\' to \'%s\'');
diff --git a/sql/updates/world/2013_04_25_00_world_misc.sql b/sql/updates/world/2013_04_25_00_world_misc.sql
new file mode 100644
index 00000000000..c07a3f76b5f
--- /dev/null
+++ b/sql/updates/world/2013_04_25_00_world_misc.sql
@@ -0,0 +1 @@
+DROP TABLE IF EXISTS `autobroadcast`;