sql: Remove PostgreSQL text limits, fixes hangs

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

diff --git a/src/core/SQL/PostgreSQL/setup_020_identity.sql b/src/core/SQL/PostgreSQL/setup_020_identity.sql
index 35ffe72..d60eb1a 100644 (file)
--- a/src/core/SQL/PostgreSQL/setup_020_identity.sql
+++ b/src/core/SQL/PostgreSQL/setup_020_identity.sql
@@ -1,23 +1,23 @@
 CREATE TABLE identity (
        identityid serial PRIMARY KEY,
        userid integer NOT NULL REFERENCES quasseluser (userid) ON DELETE CASCADE,
-       identityname varchar(64) NOT NULL,
-       realname varchar(128) NOT NULL,
-       awaynick varchar(64),
+       identityname TEXT NOT NULL,
+       realname TEXT NOT NULL,
+       awaynick TEXT,
        awaynickenabled boolean NOT NULL DEFAULT FALSE,
-       awayreason varchar(256),
+       awayreason TEXT,
        awayreasonenabled boolean NOT NULL DEFAULT FALSE,
        autoawayenabled boolean NOT NULL DEFAULT FALSE,
        autoawaytime integer NOT NULL,
-       autoawayreason varchar(256),
+       autoawayreason TEXT,
        autoawayreasonenabled boolean NOT NULL DEFAULT FALSE,
        detachawayenabled boolean NOT NULL DEFAULT FALSE,
-       detachawayreason varchar(256),
+       detachawayreason TEXT,
        detachawayreasonenabled boolean NOT NULL DEFAULT FALSE,
-       ident varchar(64),
-       kickreason varchar(256),
-       partreason varchar(256),
-       quitreason varchar(256),
+       ident TEXT,
+       kickreason TEXT,
+       partreason TEXT,
+       quitreason TEXT,
        sslcert bytea,
        sslkey bytea,
        UNIQUE (userid, identityname)