X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2F1.0.1%2F02_accounts.sql;h=db6d59acd21edd3015b647b7fa1611d0cc6574f8;hb=7fd6dbb3c5864ff6160330ddf6571b774e15f602;hp=342e1743e71598547875c76951e543fc3cd0e56d;hpb=8dda254648e0ebf8ba0e6a7b2d58acff730ada2c;p=platal.git

diff --git a/upgrade/1.0.1/02_accounts.sql b/upgrade/1.0.1/02_accounts.sql
index 342e174..db6d59a 100644
--- a/upgrade/1.0.1/02_accounts.sql
+++ b/upgrade/1.0.1/02_accounts.sql
@@ -1,8 +1,26 @@
-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,
+                     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
                         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: