# HG changeset patch
# User Pascal Volk <user@localhost.localdomain.org>
# Date 1334494456 0
# Node ID 5020c56f938834e40a27eef6bc72d026c294b3fb
# Parent  79f09cdd1a216fd9e9e7ab0890dc97e8f388570f
pgsql: Create column `note' as text.

diff -r 79f09cdd1a21 -r 5020c56f9388 pgsql/create_tables-dovecot-1.2.x.pgsql
--- a/pgsql/create_tables-dovecot-1.2.x.pgsql	Sun Apr 15 14:10:40 2012 +0200
+++ b/pgsql/create_tables-dovecot-1.2.x.pgsql	Sun Apr 15 12:54:16 2012 +0000
@@ -104,7 +104,7 @@
     ssid        bigint NOT NULL DEFAULT 1, -- default service set
     tid         bigint NOT NULL DEFAULT 1, -- default transport
     domaindir   varchar(40) NOT NULL, --/srv/mail/$RAND/4294967294
-    note        varchar NULL DEFAULT NULL,
+    note        text NULL DEFAULT NULL,
     CONSTRAINT  pkey_domain_data PRIMARY KEY (gid),
     CONSTRAINT  fkey_domain_data_qid_quotalimit FOREIGN KEY (qid)
         REFERENCES quotalimit (qid),
@@ -133,7 +133,7 @@
     qid         bigint NULL DEFAULT NULL,
     ssid        bigint NULL DEFAULT NULL,
     tid         bigint NULL DEFAULT NULL,
-    note        varchar NULL DEFAULT NULL,
+    note        text NULL DEFAULT NULL,
     CONSTRAINT  pkey_users PRIMARY KEY (local_part, gid),
     CONSTRAINT  ukey_users_uid UNIQUE (uid),
     CONSTRAINT  fkey_users_gid_domain_data FOREIGN KEY (gid)
diff -r 79f09cdd1a21 -r 5020c56f9388 pgsql/create_tables.pgsql
--- a/pgsql/create_tables.pgsql	Sun Apr 15 14:10:40 2012 +0200
+++ b/pgsql/create_tables.pgsql	Sun Apr 15 12:54:16 2012 +0000
@@ -104,7 +104,7 @@
     ssid        bigint NOT NULL DEFAULT 1, -- default service_set
     tid         bigint NOT NULL DEFAULT 1, -- default transport
     domaindir   varchar(40) NOT NULL, --/srv/mail/$RAND/4294967294
-    note        varchar NULL DEFAULT NULL,
+    note        text NULL DEFAULT NULL,
     CONSTRAINT  pkey_domain_data PRIMARY KEY (gid),
     CONSTRAINT  fkey_domain_data_qid_quotalimit FOREIGN KEY (qid)
         REFERENCES quotalimit (qid),
@@ -133,7 +133,7 @@
     qid         bigint NULL DEFAULT NULL,
     ssid        bigint NULL DEFAULT NULL,
     tid         bigint NULL DEFAULT NULL,
-    note        varchar NULL DEFAULT NULL,
+    note        text NULL DEFAULT NULL,
     CONSTRAINT  pkey_users PRIMARY KEY (local_part, gid),
     CONSTRAINT  ukey_users_uid UNIQUE (uid),
     CONSTRAINT  fkey_users_gid_domain_data FOREIGN KEY (gid)