DROP TABLE IF EXISTS `irc_inchan`;
CREATE TABLE `irc_inchan` (
  `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
  `name` varchar(12) NOT NULL default '',
  `team` smallint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (`guid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='IRC Module system';



DROP TABLE IF EXISTS `irc_logedin`;
CREATE TABLE `irc_logedin` (
  `account` int(11) unsigned NOT NULL default '0' COMMENT 'Account Identifier',
  `nick` varchar(50) NOT NULL default '',
  `gmlevel` tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (`account`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='IRC Module system';