6RzYzTjc

1 cid int(11) NOT NULL AUTO_INCREMENT,
2  `name` varchar(64) NOT NULL,
3  PRIMARY KEY (cid)
4) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1
5
6(debug) start@main.pl - $qh = $dbh->prepare(sprintf($query));
7(debug) start@main.pl - DROP TABLE IF EXISTS channel_client_lookup
8(debug) start@main.pl - $qh = $dbh->prepare(sprintf($query));
9(debug) start@main.pl - CREATE TABLE IF NOT EXISTS channel_client_lookup (
10  lid int(11) NOT NULL AUTO_INCREMENT,
11  channel int(11) NOT NULL,
12  `client` int(11) NOT NULL,
13  PRIMARY KEY (lid)
14) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
15
16(debug) start@main.pl - $qh = $dbh->prepare(sprintf($query));
17(debug) start@main.pl - DROP TABLE IF EXISTS channel_modes
18(debug) start@main.pl - $qh = $dbh->prepare(sprintf($query));
19(debug) start@main.pl - CREATE TABLE IF NOT EXISTS channel_modes (
20  mid int(11) NOT NULL AUTO_INCREMENT,
21  channelid int(11) NOT NULL,
22  clientid int(11) NULL,
23  mode varchar(1) NOT NULL,
24  modeparam varchar(64) NULL,
25    PRIMARY KEY (mid)
26) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1
27
28(debug) start@main.pl - $qh = $dbh->prepare(sprintf($query));
29(debug) start@main.pl - CREATE TABLE IF NOT EXISTS registered_channels (
30  cid int(11) NOT NULL AUTO_INCREMENT,
31  channel varchar(64) NOT NULL,
32  owner int(11) NOT NULL,
33  topic varchar(512) NULL,
34  modes varchar(64) NOT NULL,
35  PRIMARY KEY (cid)
36) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1
37
38(debug) start@main.pl - $qh = $dbh->prepare(sprintf($query));
39(debug) start@main.pl - CREATE TABLE IF NOT EXISTS registered_channel_flags (
40  pid int(11) NOT NULL AUTO_INCREMENT,
41  channel int(11) NOT NULL,
42  user int(11) NOT NULL,
43  flag varchar(64) NOT NULL,
44  PRIMARY KEY (pid)
45) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1
46
47(debug) start@main.pl - $qh = $dbh->prepare(sprintf($query));
48(debug) start@main.pl - UPDATE users SET online = 0, nick = NULL, ident = NULL, host = NULL
49(debug) start@main.pl - $qh = $dbh->prepare(sprintf($query));