sql: Remove PostgreSQL text limits, fixes hangs

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

diff --git a/src/core/SQL/PostgreSQL/setup_030_identity_nick.sql b/src/core/SQL/PostgreSQL/setup_030_identity_nick.sql
index 65fb5ec..ce2bb6a 100644 (file)
--- a/src/core/SQL/PostgreSQL/setup_030_identity_nick.sql
+++ b/src/core/SQL/PostgreSQL/setup_030_identity_nick.sql
@@ -1,6 +1,6 @@
 CREATE TABLE identity_nick (
        nickid serial PRIMARY KEY,
        identityid integer NOT NULL REFERENCES identity (identityid) ON DELETE CASCADE,
 CREATE TABLE identity_nick (
        nickid serial PRIMARY KEY,
        identityid integer NOT NULL REFERENCES identity (identityid) ON DELETE CASCADE,

-       nick varchar(64) NOT NULL,
+       nick TEXT NOT NULL,

        UNIQUE (identityid, nick)
 )
        UNIQUE (identityid, nick)
 )