From d43f7f9521e4a4207fb0acda796011baacd3e97e Mon Sep 17 00:00:00 2001 From: =?utf8?q?Rapha=C3=ABl=20Barrois?= Date: Wed, 24 Aug 2011 00:58:42 +0200 Subject: [PATCH] Add the 'user' perm to all valid account types. MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit Signed-off-by: Raphaël Barrois --- upgrade/1.1.3/04_accounts.sql | 4 ++++ 1 file changed, 4 insertions(+) create mode 100644 upgrade/1.1.3/04_accounts.sql diff --git a/upgrade/1.1.3/04_accounts.sql b/upgrade/1.1.3/04_accounts.sql new file mode 100644 index 0000000..b0b4273 --- /dev/null +++ b/upgrade/1.1.3/04_accounts.sql @@ -0,0 +1,4 @@ +ALTER TABLE account_types +CHANGE perms perms SET('groups','mail','directory_ax','directory_private','edit_directory','forums','lists','payment','api_user_readonly','gapps', 'user') NOT NULL DEFAULT ''; + +UPDATE account_types SET perms = CONCAT(perms, ',user') WHERE type IN ('ax', 'fx', 'master', 'phd', 'pi', 'school', 'x'); -- 2.1.4