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,
 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,
        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,
        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,
        autoawayreasonenabled boolean NOT NULL DEFAULT FALSE,
        detachawayenabled boolean NOT NULL DEFAULT FALSE,

-       detachawayreason varchar(256),
+       detachawayreason TEXT,

        detachawayreasonenabled boolean NOT NULL DEFAULT FALSE,
        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)
        sslcert bytea,
        sslkey bytea,
        UNIQUE (userid, identityname)