upgrade/1.1.12/08_add_directory_hidden_to_account_types.sql

   1 ALTER TABLE account_types CHANGE COLUMN perms perms
   2     SET('groups', 'mail', 'directory_ax', 'directory_private', 'directory_hidden',
   3         'edit_directory', 'forums', 'lists', 'payment', 'api_user_readonly', 'gapps', 'user') NOT NULL;
   4
   5 -- AX needs directory_ax to access some pages and directory_hidden for admin visibility level
   6 UPDATE account_types SET perms = 'groups,directory_ax,directory_hidden,edit_directory,user' WHERE type = 'ax';
   7
   8 -- vim:set syntax=mysql: