aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/auth/2013_04_25_00_auth_misc.txt8
-rw-r--r--sql/updates/world/2013_04_25_00_world_misc.sql1
2 files changed, 9 insertions, 0 deletions
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_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`;