CREATE TABLE `ts2_channels` (
  `i_channel_id` int(8) NOT NULL auto_increment,
  `i_channel_server_id` int(8) default NULL,
  `i_channel_parent_id` int(8) default NULL,
  `b_channel_flag_moderated` tinyint(1) default NULL,
  `b_channel_flag_hierarchical` tinyint(1) default NULL,
  `b_channel_flag_default` tinyint(1) default NULL,
  `i_channel_codec` int(8) default NULL,
  `i_channel_order` int(8) default NULL,
  `i_channel_maxusers` int(8) default NULL,
  `s_channel_name` varchar(32) default NULL,
  `s_channel_topic` varchar(32) default NULL,
  `s_channel_description` text,
  `s_channel_password` varchar(32) default NULL,
  `dt_channel_created` varchar(24) default NULL,
  PRIMARY KEY  (`i_channel_id`),
  KEY `i_channel_server_id` (`i_channel_server_id`),
  KEY `i_channel_parent_id` (`i_channel_parent_id`)
) ENGINE=MyISAM ;
