diff options
| author | Aokromes <jipr@hotmail.com> | 2013-04-27 05:02:48 -0700 |
|---|---|---|
| committer | Aokromes <jipr@hotmail.com> | 2013-04-27 05:02:48 -0700 |
| commit | 1087e5f5c98c11a16b92e7f2efcac6dbe2129b25 (patch) | |
| tree | f36fc979989fcd1172ee9df062a63300addb42c6 /sql | |
| parent | e486cd7623fb2a8f62db8520d0a242be3ff3baf0 (diff) | |
| parent | d7e9d1bafb288596f0057fcd5517ba95981579e4 (diff) | |
Merge pull request #9710 from xjose93/Autobroadcast
Core/World: Improvements in Autobroadcast system (dropped from world database and moved to auth database, added realmid and weight columns)
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/auth/2013_04_25_00_auth_misc.txt | 8 | ||||
| -rw-r--r-- | sql/updates/world/2013_04_25_00_world_misc.sql | 1 |
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`; |