From f15087a3b60486f6fabe46ab5d15a2ef2750d231 Mon Sep 17 00:00:00 2001 From: Florent Bruneau Date: Sun, 15 Aug 2010 16:30:28 +0200 Subject: [PATCH] Update de list of permissions. Signed-off-by: Florent Bruneau --- upgrade/1.0.1/02_accounts.sql | 15 ++++++++++++++- 1 file changed, 14 insertions(+), 1 deletion(-) diff --git a/upgrade/1.0.1/02_accounts.sql b/upgrade/1.0.1/02_accounts.sql index 342e174..cdba8e1 100644 --- a/upgrade/1.0.1/02_accounts.sql +++ b/upgrade/1.0.1/02_accounts.sql @@ -1,8 +1,21 @@ -ALTER TABLE accounts ADD COLUMN directory_name VARCHAR(255) DEFAULT NULL; +ALTER TABLE accounts ADD COLUMN directory_name VARCHAR(255) DEFAULT NULL AFTER full_name; UPDATE accounts AS a SET a.directory_name = (SELECT pd.directory_name FROM profile_display AS pd INNER JOIN account_profiles AS ap ON (ap.uid = pd.pid AND FIND_IN_SET('owner', perms)) WHERE a.uid = ap.uid); +ALTER TABLE account_types +CHANGE COLUMN perms perms SET('groups', 'mail', 'directory_ax', 'directory_private', + 'edit_directory', 'forums', 'lists', 'payment') NOT NULL; + +REPLACE INTO account_types VALUES ('x', 'groups,mail,directory_private,forums,lists,payment'), + ('master', 'groups,directory_private,forums,lists,payment'), + ('phd', 'groups,directory_private,forums,lists,payment'), + ('pi', 'groups,forums,lists'), + ('ax', 'groups,directory_ax,edit_directory'), + ('xnet', 'groups'), + ('virtual', ''); + + -- vim:set syntax=mysql: -- 2.1.4