sql: Remove PostgreSQL text limits, fixes hangs

[quassel.git] / src / core / SQL / PostgreSQL / version / 30 / upgrade_020_alter_identity.sql

diff --git a/src/core/SQL/PostgreSQL/version/30/upgrade_020_alter_identity.sql b/src/core/SQL/PostgreSQL/version/30/upgrade_020_alter_identity.sql
new file mode 100644 (file)
index 0000000..a8708b0
--- /dev/null
+++ b/src/core/SQL/PostgreSQL/version/30/upgrade_020_alter_identity.sql
@@ -0,0 +1,11 @@
+ALTER TABLE identity
+ALTER COLUMN identityname TYPE TEXT,
+ALTER COLUMN realname TYPE TEXT,
+ALTER COLUMN awaynick TYPE TEXT,
+ALTER COLUMN awayreason TYPE TEXT,
+ALTER COLUMN autoawayreason TYPE TEXT,
+ALTER COLUMN detachawayreason TYPE TEXT,
+ALTER COLUMN ident TYPE TEXT,
+ALTER COLUMN kickreason TYPE TEXT,
+ALTER COLUMN partreason TYPE TEXT,
+ALTER COLUMN quitreason TYPE TEXT