| 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: |