pgsql/update_tables_0.5.x-0.6.pgsql
branchv0.6.x
changeset 548 92ef34f07da3
parent 538 1f9ea5658627
child 549 44a808af6cf4
equal deleted inserted replaced
547:5020c56f9388 548:92ef34f07da3
   145 -- ---
   145 -- ---
   146 -- Catchall
   146 -- Catchall
   147 -- ---
   147 -- ---
   148 -- Quota/Service/Transport inheritance
   148 -- Quota/Service/Transport inheritance
   149 -- ---
   149 -- ---
   150 ALTER TABLE users ALTER COLUMN tid DROP NULL;
   150 ALTER TABLE users ALTER COLUMN tid DROP NOT NULL;
   151 ALTER TABLE users ALTER COLUMN tid SET DEFAULT NULL;
   151 ALTER TABLE users ALTER COLUMN tid SET DEFAULT NULL;
   152 -- The qid and ssid columns have already been defined accordingly above.
   152 -- The qid and ssid columns have already been defined accordingly above.
   153 -- The rest of the logic will take place in the functions.
   153 -- The rest of the logic will take place in the functions.
   154 
   154 
   155 -- While qid and ssid are new and it's perfectly okay for existing users to
   155 -- While qid and ssid are new and it's perfectly okay for existing users to