X-Git-Url: https://git.quassel-irc.org/?p=quassel.git;a=blobdiff_plain;f=src%2Fcore%2FSQL%2FPostgreSQL%2Fsetup_080_ircservers.sql;fp=src%2Fcore%2FSQL%2FPostgreSQL%2Fsetup_080_ircservers.sql;h=5d038f15c6ff46e80e79828957cdb4a8515df018;hp=98609d5f83c0abb2d75b544756454d2da7c84299;hb=9fa6f42009ada45e4787972b5e137ba19876c8dd;hpb=f09a86ab1cc01a80aa6fd52a875920e18d1d3a5b diff --git a/src/core/SQL/PostgreSQL/setup_080_ircservers.sql b/src/core/SQL/PostgreSQL/setup_080_ircservers.sql index 98609d5f..5d038f15 100644 --- a/src/core/SQL/PostgreSQL/setup_080_ircservers.sql +++ b/src/core/SQL/PostgreSQL/setup_080_ircservers.sql @@ -2,16 +2,16 @@ 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, + hostname TEXT NOT NULL, port integer NOT NULL DEFAULT 6667, - password varchar(64), + password TEXT, 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', + proxyhost TEXT NOT NULL DEFAULT 'localhost', proxyport integer NOT NULL DEFAULT 8080, - proxyuser varchar(64), - proxypass varchar(64), + proxyuser TEXT, + proxypass TEXT, sslverify boolean NOT NULL DEFAULT FALSE -- bool, validate SSL cert )