[platal.git] / upgrade / 1.1.4 / 11_groups.sql

ALTER TABLE group_members ADD COLUMN flags SET('notify') NOT NULL DEFAULT '';
ALTER TABLE groups MODIFY COLUMN flags SET('wiki_desc','notif_unsub','has_ml', 'notify_all') NOT NULL DEFAULT 'notify_all';
UPDATE groups SET flags = CONCAT(flags, ',', 'notify_all') WHERE NOT FIND_IN_SET('notify_all', flags);

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