Commit | Line | Data |
---|---|---|
7fd6dbb3 FB |
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; | |
d081acb2 SJ |
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 | ||
f15087a3 FB |
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 | ||
17 | REPLACE INTO account_types VALUES ('x', 'groups,mail,directory_private,forums,lists,payment'), | |
18 | ('master', 'groups,directory_private,forums,lists,payment'), | |
19 | ('phd', 'groups,directory_private,forums,lists,payment'), | |
20 | ('pi', 'groups,forums,lists'), | |
21 | ('ax', 'groups,directory_ax,edit_directory'), | |
22 | ('xnet', 'groups'), | |
23 | ('virtual', ''); | |
24 | ||
25 | ||
d081acb2 | 26 | -- vim:set syntax=mysql: |