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 TEXT 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 TEXT NOT NULL DEFAULT 'localhost',
13 proxyport integer NOT NULL DEFAULT 8080,
16 sslverify boolean NOT NULL DEFAULT FALSE -- bool, validate SSL cert