1 CREATE TABLE ircserver (
2 serverid INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
3 userid INTEGER NOT NULL,
4 networkid INTEGER NOT NULL,
5 hostname TEXT NOT NULL,
6 port INTEGER NOT NULL DEFAULT 6667,
8 ssl INTEGER NOT NULL DEFAULT 0, -- bool
9 sslversion INTEGER NOT NULL DEFAULT 0,
10 useproxy INTEGER NOT NULL DEFAULT 0, -- bool
11 proxytype INTEGER NOT NULL DEFAULT 0,
12 proxyhost TEXT NOT NULL DEFAULT 'localhost',
13 proxyport INTEGER NOT NULL DEFAULT 8080,
16 sslverify INTEGER NOT NULL DEFAULT 0 -- bool, validate SSL cert