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),