upgrade/1.0.1/02_accounts.sql

   1 ALTER TABLE accounts ADD COLUMN directory_name VARCHAR(255) DEFAULT NULL AFTER full_name,
   2                      ADD COLUMN user_perms SET('groups', 'mail', 'directory_ax', 'directory_private',
   3                                                'edit_directory', 'forums', 'lists', 'payment')
   4                                            DEFAULT NULL
   5                                            COMMENT "Extra permissions for the account in addition to those specified by the account type"
   6                                            AFTER type;
   7 UPDATE  accounts AS a
   8    SET  a.directory_name = (SELECT  pd.directory_name
   9                               FROM  profile_display  AS pd
  10                         INNER JOIN  account_profiles AS ap ON (ap.uid = pd.pid AND FIND_IN_SET('owner', perms))
  11                              WHERE  a.uid = ap.uid);
  12
  13   ALTER TABLE account_types
  14 CHANGE COLUMN perms perms SET('groups', 'mail', 'directory_ax', 'directory_private',
  15                               'edit_directory', 'forums', 'lists', 'payment') NOT NULL,
  16    ADD COLUMN description TEXT DEFAULT NULL;
  17
  18 REPLACE INTO account_types VALUES ('x', 'groups,mail,directory_private,forums,lists,payment', 'Polytechnicien'),
  19                                   ('master', 'groups,directory_private,forums,lists,payment', 'Master de l\'X'),
  20                                   ('phd', 'groups,directory_private,forums,lists,payment',    'Docteur de l\'X'),
  21                                   ('pi', 'groups,forums,lists', 'Elève du programme international'),
  22                                   ('ax', 'groups,directory_ax,edit_directory', 'Secrétariat de l\'AX'),
  23                                   ('xnet', 'groups', NULL),
  24                                   ('school', 'groups,directory_ax', 'Personnel de l\'X'),
  25                                   ('fx', 'groups,directory_ax', 'Personnel de la FX'),
  26                                   ('virtual', '', NULL);
  27
  28
  29 -- vim:set syntax=mysql: