From a00473d79510f80ae1fd6b4ed882d0e696c22659 Mon Sep 17 00:00:00 2001
From: Anubisss <none@none>
Date: Tue, 21 Jul 2009 21:16:30 +0200
Subject: *Add table channels to characters.sql

--HG--
branch : trunk
---
 sql/characters.sql | 15 +++++++++++++++
 1 file changed, 15 insertions(+)

(limited to 'sql')

diff --git a/sql/characters.sql b/sql/characters.sql
index 793e42d2aea..f172df5b006 100644
--- a/sql/characters.sql
+++ b/sql/characters.sql
@@ -267,6 +267,21 @@ LOCK TABLES `bugreport` WRITE;
 /*!40000 ALTER TABLE `bugreport` ENABLE KEYS */;
 UNLOCK TABLES;
 
+-- ----------------------------
+-- 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='Channel System';
+
 --
 -- Table structure for table `characters`
 --
-- 
cgit v1.2.3