Change sorting order on ML display to use sort_name.

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

diff --git a/upgrade/1.1.4/11_groups.sql b/upgrade/1.1.4/11_groups.sql
index 6910c8e..0b8f906 100644 (file)
--- a/upgrade/1.1.4/11_groups.sql
+++ b/upgrade/1.1.4/11_groups.sql
@@ -1,3 +1,5 @@
 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: