Commit | Line | Data |
---|---|---|
d058a285 SJ |
1 | ALTER TABLE account_types MODIFY COLUMN perms SET('groups','mail','directory_ax','directory_private','edit_directory','forums','lists','payment','api_user_readonly','gapps') NOT NULL DEFAULT ''; |
2 | ||
3 | UPDATE account_types | |
4 | SET perms = 'groups,mail,directory_private,forums,lists,payment,gapps' | |
5 | WHERE type = 'x'; | |
6 | UPDATE account_types | |
7 | SET perms = 'groups,mail,directory_private,forums,lists,payment' | |
8 | WHERE type = 'master' OR type = 'phd'; | |
9 | ||
10 | -- vim:set syntax=mysql: |