1 CREATE TABLE ircserver (
2 serverid serial PRIMARY KEY,
3 userid integer NOT NULL REFERENCES quasseluser (userid) ON DELETE CASCADE,
4 networkid integer NOT NULL REFERENCES network (networkid) ON DELETE CASCADE,
5 hostname varchar(128) NOT NULL,
6 port integer NOT NULL DEFAULT 6667,
8 ssl boolean NOT NULL DEFAULT FALSE, -- bool
9 sslversion integer NOT NULL DEFAULT 0,
10 useproxy boolean NOT NULL DEFAULT FALSE, -- bool
11 proxytype integer NOT NULL DEFAULT 0,
12 proxyhost varchar(128) NOT NULL DEFAULT 'localhost',
13 proxyport integer NOT NULL DEFAULT 8080,
14 proxyuser varchar(64),