b0b4273bd7ce8519a6bc4b89197ef37a1c86b3e7
[platal.git] / upgrade / 1.1.3 / 04_accounts.sql
1 ALTER TABLE account_types
2 CHANGE perms perms SET('groups','mail','directory_ax','directory_private','edit_directory','forums','lists','payment','api_user_readonly','gapps', 'user') NOT NULL DEFAULT '';
3
4 UPDATE account_types SET perms = CONCAT(perms, ',user') WHERE type IN ('ax', 'fx', 'master', 'phd', 'pi', 'school', 'x');