5e5593f05a194b56425a388e585f1068491c642e
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')
5 COMMENT "Extra permissions for the account in addition to those specified by the account type"
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
);
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;
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);
29 -- vim:set syntax=mysql: