upgrade/1.1.4/11_groups.sql

   1 ALTER TABLE group_members ADD COLUMN flags SET('notify') NOT NULL DEFAULT '';
   2 ALTER TABLE groups MODIFY COLUMN flags SET('wiki_desc','notif_unsub','has_ml', 'notify_all') NOT NULL DEFAULT 'notify_all';
   3 UPDATE groups SET flags = CONCAT(flags, ',', 'notify_all') WHERE NOT FIND_IN_SET('notify_all', flags);
   4
   5 -- vim:set syntax=mysql: