aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorQAston <none@none>2009-07-18 23:41:42 +0200
committerQAston <none@none>2009-07-18 23:41:42 +0200
commit53c62aceadc4d4359437a8bccbbe7993bda4e510 (patch)
tree8cded2a08b84e1aeb6a5762018148109e93bbac9 /sql/updates
parent5f3f62222670f70a0c278b76ce91601814da1f3f (diff)
parentc8342ca8ce3f49d1c53fa3bfb69f26197e032cc0 (diff)
*Merge.
--HG-- branch : trunk
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/4495_world_script.sql1
-rw-r--r--sql/updates/4498_characters_channels.sql14
2 files changed, 15 insertions, 0 deletions
diff --git a/sql/updates/4495_world_script.sql b/sql/updates/4495_world_script.sql
new file mode 100644
index 00000000000..8e37e081e23
--- /dev/null
+++ b/sql/updates/4495_world_script.sql
@@ -0,0 +1 @@
+UPDATE `creature_template` SET `ScriptName`='mob_mojo' WHERE `entry`='24480'; \ No newline at end of file
diff --git a/sql/updates/4498_characters_channels.sql b/sql/updates/4498_characters_channels.sql
new file mode 100644
index 00000000000..f4e8162b4e9
--- /dev/null
+++ b/sql/updates/4498_characters_channels.sql
@@ -0,0 +1,14 @@
+-- ----------------------------
+-- Table structure for channels
+-- ----------------------------
+DROP TABLE IF EXISTS `channels`;
+CREATE TABLE `channels` (
+ `m_name` text NOT NULL,
+ `m_team` int(10) unsigned NOT NULL,
+ `m_ownerGUID` int(11) unsigned NOT NULL default '0',
+ `m_announce` tinyint(1) unsigned NOT NULL default '0',
+ `m_moderate` tinyint(1) unsigned NOT NULL default '0',
+ `m_password` text,
+ `BannedList` longtext,
+ PRIMARY KEY (`m_name`(10),`m_team`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Access Requirements';