
#
# Table structure for table 'chantext'
#

CREATE TABLE `chantext` (
  `chan` varchar(32) NOT NULL default '',
  `type` tinyint(3) unsigned NOT NULL default 0,
  `key` varchar(32) default NULL,
  `data` text default NULL,
  PRIMARY KEY (`chan`, `type`, `key`)
) TYPE=MyISAM;

INSERT INTO chantext SELECT chan, 1, NULL, topic FROM chanreg;
ALTER TABLE chanreg DROP COLUMN topic;
