X-Git-Url: https://git.quassel-irc.org/?a=blobdiff_plain;f=src%2Fcore%2FSQL%2FPostgreSQL%2F18%2Fsetup_080_ircservers.sql;fp=src%2Fcore%2FSQL%2FPostgreSQL%2F18%2Fsetup_080_ircservers.sql;h=0000000000000000000000000000000000000000;hb=7d30b18136eecbdf2089e5d5877c7e41c6f4bcb6;hp=98609d5f83c0abb2d75b544756454d2da7c84299;hpb=3a5df5589e3cbefcaad966ba23643d58d4ec9768;p=quassel.git diff --git a/src/core/SQL/PostgreSQL/18/setup_080_ircservers.sql b/src/core/SQL/PostgreSQL/18/setup_080_ircservers.sql deleted file mode 100644 index 98609d5f..00000000 --- a/src/core/SQL/PostgreSQL/18/setup_080_ircservers.sql +++ /dev/null @@ -1,17 +0,0 @@ -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), - sslverify boolean NOT NULL DEFAULT FALSE -- bool, validate SSL cert -)