pgsql/update_tables_0.5.x-0.6-dovecot-1.2.x.pgsql
branchv0.6.x
changeset 548 92ef34f07da3
parent 538 1f9ea5658627
child 549 44a808af6cf4
equal deleted inserted replaced
547:5020c56f9388 548:92ef34f07da3
   177 );
   177 );
   178 
   178 
   179 -- ---
   179 -- ---
   180 -- Quota/Service/Transport inheritance
   180 -- Quota/Service/Transport inheritance
   181 -- ---
   181 -- ---
   182 ALTER TABLE users ALTER COLUMN tid DROP NULL;
   182 ALTER TABLE users ALTER COLUMN tid DROP NOT NULL;
   183 ALTER TABLE users ALTER COLUMN tid SET DEFAULT NULL;
   183 ALTER TABLE users ALTER COLUMN tid SET DEFAULT NULL;
   184 -- The qid and ssid columns have already been defined accordingly above.
   184 -- The qid and ssid columns have already been defined accordingly above.
   185 -- The rest of the logic will take place in the functions.
   185 -- The rest of the logic will take place in the functions.
   186 
   186 
   187 -- While qid and ssid are new and it's perfectly okay for existing users to
   187 -- While qid and ssid are new and it's perfectly okay for existing users to