X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;ds=sidebyside;f=upgrade%2F1.0.1%2F02_accounts.sql;h=db6d59acd21edd3015b647b7fa1611d0cc6574f8;hb=c76545c351fae4e2298624ff9ee5bf854dc5a5b6;hp=cdba8e13d0d718a97d8341814465560af64c3bb1;hpb=f15087a3b60486f6fabe46ab5d15a2ef2750d231;p=platal.git

diff --git a/upgrade/1.0.1/02_accounts.sql b/upgrade/1.0.1/02_accounts.sql
index cdba8e1..db6d59a 100644
--- a/upgrade/1.0.1/02_accounts.sql
+++ b/upgrade/1.0.1/02_accounts.sql
@@ -1,4 +1,9 @@
-ALTER TABLE accounts ADD COLUMN directory_name VARCHAR(255) DEFAULT NULL AFTER full_name;
+ALTER TABLE accounts ADD COLUMN directory_name VARCHAR(255) DEFAULT NULL AFTER full_name,
+                     ADD COLUMN user_perms SET('groups', 'mail', 'directory_ax', 'directory_private',
+                                               'edit_directory', 'forums', 'lists', 'payment')
+                                           DEFAULT NULL
+                                           COMMENT "Extra permissions for the account in addition to those specified by the account type"
+                                           AFTER type;
 UPDATE  accounts AS a
    SET  a.directory_name = (SELECT  pd.directory_name
                               FROM  profile_display  AS pd