diff options
| author | QAston <none@none> | 2009-07-18 23:41:42 +0200 |
|---|---|---|
| committer | QAston <none@none> | 2009-07-18 23:41:42 +0200 |
| commit | 53c62aceadc4d4359437a8bccbbe7993bda4e510 (patch) | |
| tree | 8cded2a08b84e1aeb6a5762018148109e93bbac9 /sql/updates | |
| parent | 5f3f62222670f70a0c278b76ce91601814da1f3f (diff) | |
| parent | c8342ca8ce3f49d1c53fa3bfb69f26197e032cc0 (diff) | |
*Merge.
--HG--
branch : trunk
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/4495_world_script.sql | 1 | ||||
| -rw-r--r-- | sql/updates/4498_characters_channels.sql | 14 |
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'; |
