rendered paste body
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';