+++ /dev/null
-CREATE TABLE ircserver (
- serverid serial PRIMARY KEY,
- userid integer NOT NULL REFERENCES quasseluser (userid) ON DELETE CASCADE,
- networkid integer NOT NULL REFERENCES network (networkid) ON DELETE CASCADE,
- hostname varchar(128) NOT NULL,
- port integer NOT NULL DEFAULT 6667,
- password varchar(64),
- ssl boolean NOT NULL DEFAULT FALSE, -- bool
- sslversion integer NOT NULL DEFAULT 0,
- useproxy boolean NOT NULL DEFAULT FALSE, -- bool
- proxytype integer NOT NULL DEFAULT 0,
- proxyhost varchar(128) NOT NULL DEFAULT 'localhost',
- proxyport integer NOT NULL DEFAULT 8080,
- proxyuser varchar(64),
- proxypass varchar(64)
-)