From d7e9d1bafb288596f0057fcd5517ba95981579e4 Mon Sep 17 00:00:00 2001
From: xjose93 <xjose93@hotmail.com>
Date: Thu, 25 Apr 2013 19:10:10 +0200
Subject: Core/World: Improvements in Autobroadcast system (dropped from world
 database and moved to auth database, added realmid and weight columns)

---
 sql/updates/auth/2013_04_25_00_auth_misc.txt   | 8 ++++++++
 sql/updates/world/2013_04_25_00_world_misc.sql | 1 +
 2 files changed, 9 insertions(+)
 create mode 100644 sql/updates/auth/2013_04_25_00_auth_misc.txt
 create mode 100644 sql/updates/world/2013_04_25_00_world_misc.sql

(limited to 'sql')

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`;
-- 
cgit v1.2.3