Commit | Line | Data |
---|---|---|
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: |