cid int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  PRIMARY KEY (cid)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1

(debug) start@main.pl - $qh = $dbh->prepare(sprintf($query));
(debug) start@main.pl - DROP TABLE IF EXISTS channel_client_lookup
(debug) start@main.pl - $qh = $dbh->prepare(sprintf($query));
(debug) start@main.pl - CREATE TABLE IF NOT EXISTS channel_client_lookup (
  lid int(11) NOT NULL AUTO_INCREMENT,
  channel int(11) NOT NULL,
  `client` int(11) NOT NULL,
  PRIMARY KEY (lid)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

(debug) start@main.pl - $qh = $dbh->prepare(sprintf($query));
(debug) start@main.pl - DROP TABLE IF EXISTS channel_modes
(debug) start@main.pl - $qh = $dbh->prepare(sprintf($query));
(debug) start@main.pl - CREATE TABLE IF NOT EXISTS channel_modes (
  mid int(11) NOT NULL AUTO_INCREMENT,
  channelid int(11) NOT NULL,
  clientid int(11) NULL,
  mode varchar(1) NOT NULL,
  modeparam varchar(64) NULL,
    PRIMARY KEY (mid)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1

(debug) start@main.pl - $qh = $dbh->prepare(sprintf($query));
(debug) start@main.pl - CREATE TABLE IF NOT EXISTS registered_channels (
  cid int(11) NOT NULL AUTO_INCREMENT,
  channel varchar(64) NOT NULL,
  owner int(11) NOT NULL,
  topic varchar(512) NULL,
  modes varchar(64) NOT NULL,
  PRIMARY KEY (cid)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1

(debug) start@main.pl - $qh = $dbh->prepare(sprintf($query));
(debug) start@main.pl - CREATE TABLE IF NOT EXISTS registered_channel_flags (
  pid int(11) NOT NULL AUTO_INCREMENT,
  channel int(11) NOT NULL,
  user int(11) NOT NULL,
  flag varchar(64) NOT NULL,
  PRIMARY KEY (pid)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1

(debug) start@main.pl - $qh = $dbh->prepare(sprintf($query));
(debug) start@main.pl - UPDATE users SET online = 0, nick = NULL, ident = NULL, host = NULL
(debug) start@main.pl - $qh = $dbh->prepare(sprintf($query));