sql: Remove PostgreSQL text limits, fixes hangs

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

diff --git a/src/core/SQL/PostgreSQL/setup_040_network.sql b/src/core/SQL/PostgreSQL/setup_040_network.sql
index bc6815b..f1f3dbf 100644 (file)
--- a/src/core/SQL/PostgreSQL/setup_040_network.sql
+++ b/src/core/SQL/PostgreSQL/setup_040_network.sql
@@ -1,27 +1,27 @@
 CREATE TABLE network (
        networkid serial NOT NULL PRIMARY KEY,
        userid integer NOT NULL REFERENCES quasseluser (userid) ON DELETE CASCADE,
-       networkname varchar(32) NOT NULL,
+       networkname TEXT NOT NULL,
        identityid integer REFERENCES identity (identityid) ON DELETE SET NULL,
-       encodingcodec varchar(32) NOT NULL DEFAULT 'ISO-8859-15',
-       decodingcodec varchar(32) NOT NULL DEFAULT 'ISO-8859-15',
-       servercodec varchar(32),
+       encodingcodec TEXT NOT NULL DEFAULT 'ISO-8859-15',
+       decodingcodec TEXT NOT NULL DEFAULT 'ISO-8859-15',
+       servercodec TEXT,
        userandomserver boolean NOT NULL DEFAULT FALSE,
        perform TEXT,
        useautoidentify boolean NOT NULL DEFAULT FALSE,
-       autoidentifyservice varchar(128),
-       autoidentifypassword varchar(128),
+       autoidentifyservice TEXT,
+       autoidentifypassword TEXT,
        usesasl boolean NOT NULL DEFAULT FALSE,
-       saslaccount varchar(128),
-       saslpassword varchar(128),
+       saslaccount TEXT,
+       saslpassword TEXT,
        useautoreconnect boolean NOT NULL DEFAULT TRUE,
        autoreconnectinterval integer NOT NULL DEFAULT 0,
        autoreconnectretries integer NOT NULL DEFAULT 0,
        unlimitedconnectretries boolean NOT NULL DEFAULT FALSE,
        rejoinchannels boolean NOT NULL DEFAULT FALSE,
        connected boolean NOT NULL DEFAULT FALSE,
-       usermode varchar(32), -- user mode to restore
-       awaymessage varchar(256), -- away message to restore (empty if not away)
+       usermode TEXT, -- user mode to restore
+       awaymessage TEXT, -- away message to restore (empty if not away)
        attachperform text, -- perform list for on attach
        detachperform text, -- perform list for on detach
        usecustomessagerate boolean NOT NULL DEFAULT FALSE,  -- Custom rate limiting