diff options
| author | xjose93 <xjose93@hotmail.com> | 2013-04-25 19:10:10 +0200 |
|---|---|---|
| committer | xjose93 <xjose93@hotmail.com> | 2013-04-25 22:54:20 +0200 |
| commit | d7e9d1bafb288596f0057fcd5517ba95981579e4 (patch) | |
| tree | 991eeb4c1ad1cd35abf4e6bd565e408247419bfc /sql | |
| parent | 6dbd574a69071697788632db0d1a2dc662854a18 (diff) | |
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`; |