# HG changeset patch
# User Pascal Volk <user@localhost.localdomain.org>
# Date 1334503816 0
# Node ID 92ef34f07da3862592a608dc2583de7dcf32988b
# Parent  5020c56f938834e40a27eef6bc72d026c294b3fb
pgsql: update_tables_*: Added missing `NOT' to `… tid DROP NOT NULL;'.

diff -r 5020c56f9388 -r 92ef34f07da3 pgsql/update_tables_0.5.x-0.6-dovecot-1.2.x.pgsql
--- a/pgsql/update_tables_0.5.x-0.6-dovecot-1.2.x.pgsql	Sun Apr 15 12:54:16 2012 +0000
+++ b/pgsql/update_tables_0.5.x-0.6-dovecot-1.2.x.pgsql	Sun Apr 15 15:30:16 2012 +0000
@@ -179,7 +179,7 @@
 -- ---
 -- Quota/Service/Transport inheritance
 -- ---
-ALTER TABLE users ALTER COLUMN tid DROP NULL;
+ALTER TABLE users ALTER COLUMN tid DROP NOT NULL;
 ALTER TABLE users ALTER COLUMN tid SET DEFAULT NULL;
 -- The qid and ssid columns have already been defined accordingly above.
 -- The rest of the logic will take place in the functions.
diff -r 5020c56f9388 -r 92ef34f07da3 pgsql/update_tables_0.5.x-0.6.pgsql
--- a/pgsql/update_tables_0.5.x-0.6.pgsql	Sun Apr 15 12:54:16 2012 +0000
+++ b/pgsql/update_tables_0.5.x-0.6.pgsql	Sun Apr 15 15:30:16 2012 +0000
@@ -147,7 +147,7 @@
 -- ---
 -- Quota/Service/Transport inheritance
 -- ---
-ALTER TABLE users ALTER COLUMN tid DROP NULL;
+ALTER TABLE users ALTER COLUMN tid DROP NOT NULL;
 ALTER TABLE users ALTER COLUMN tid SET DEFAULT NULL;
 -- The qid and ssid columns have already been defined accordingly above.
 -- The rest of the logic will take place in the functions.