upgrade/1.1.0/xx_03_types.sql

   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: