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 'infobot',
7 `timeadded` INT UNSIGNED DEFAULT '0',
8 PRIMARY KEY (server,port,nick)