sql: Remove PostgreSQL text limits, fixes hangs

[quassel.git] / src / core / SQL / PostgreSQL / setup_080_ircservers.sql

diff --git a/src/core/SQL/PostgreSQL/setup_080_ircservers.sql b/src/core/SQL/PostgreSQL/setup_080_ircservers.sql
index 98609d5..5d038f1 100644 (file)
--- 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,
     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,
     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,
     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,
     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
 )
     sslverify boolean NOT NULL DEFAULT FALSE -- bool, validate SSL cert
 )