1 CREATE TABLE connections (
2 server VARCHAR(30) NOT NULL,
3 port INT NOT NULL DEFAULT '6667',
4 nick VARCHAR(20) NOT NULL,
5 nickservpass VARCHAR(8) NOT NULL,
6 ircname VARCHAR (20) NOT NULL DEFAULT 'blootbot experimental bot',
7 timeadded INT UNSIGNED DEFAULT 'UNIX_TIMESTAMP()',
8 PRIMARY KEY (server,port,nick)
10 INSERT INTO connections (server, port, nick, nickservpass, ircname) VALUES ('localhost','6667','abot','0password', 'abot blootbot');
11 INSERT INTO connections (server, port, nick, nickservpass, ircname) VALUES ('localhost','6667','bbot','0password', 'bbot blootbot');
12 INSERT INTO connections (server, port, nick, nickservpass, ircname) VALUES ('localhost','6667','cbot','0password', 'cbot blootbot');