From 7166e8d26fe1bdf0f5765dd3e9b110b395d412e7 Mon Sep 17 00:00:00 2001
From: Rat <none@none>
Date: Sat, 18 Jul 2009 22:15:56 +0200
Subject: *implemented basic Chat Channel saving *includes owner,
 banlist,announce,password, saving *todo:  -make it cacheble  -add a filter to
 not save some addon spec channels  -find someone who does these for me :)

--HG--
branch : trunk
---
 sql/updates/4498_characters_channels.sql | 14 ++++++++++++++
 1 file changed, 14 insertions(+)
 create mode 100644 sql/updates/4498_characters_channels.sql

(limited to 'sql/updates')

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