upgrade/1.0.1/02_accounts.sql

   1 ALTER TABLE accounts ADD COLUMN directory_name VARCHAR(255) DEFAULT NULL AFTER full_name;
   2 UPDATE  accounts AS a
   3    SET  a.directory_name = (SELECT  pd.directory_name
   4                               FROM  profile_display  AS pd
   5                         INNER JOIN  account_profiles AS ap ON (ap.uid = pd.pid AND FIND_IN_SET('owner', perms))
   6                              WHERE  a.uid = ap.uid);
   7
   8 ALTER TABLE account_types
   9 CHANGE COLUMN perms perms SET('groups', 'mail', 'directory_ax', 'directory_private',
  10                               'edit_directory', 'forums', 'lists', 'payment') NOT NULL;
  11
  12 REPLACE INTO account_types VALUES ('x', 'groups,mail,directory_private,forums,lists,payment'),
  13                                   ('master', 'groups,directory_private,forums,lists,payment'),
  14                                   ('phd', 'groups,directory_private,forums,lists,payment'),
  15                                   ('pi', 'groups,forums,lists'),
  16                                   ('ax', 'groups,directory_ax,edit_directory'),
  17                                   ('xnet', 'groups'),
  18                                   ('virtual', '');
  19
  20
  21 -- vim:set syntax=mysql: