X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2F1.0.1%2F02_accounts.sql;h=5e5593f05a194b56425a388e585f1068491c642e;hb=69d311a9e667ba071af1070cfe9a6906a4f0ed32;hp=db6d59acd21edd3015b647b7fa1611d0cc6574f8;hpb=ed92ea696e042eb9b2d0efcc4731fdf89fb17924;p=platal.git

diff --git a/upgrade/1.0.1/02_accounts.sql b/upgrade/1.0.1/02_accounts.sql
index db6d59a..5e5593f 100644
--- a/upgrade/1.0.1/02_accounts.sql
+++ b/upgrade/1.0.1/02_accounts.sql
@@ -10,17 +10,20 @@ UPDATE  accounts AS a
                         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
+  ALTER TABLE account_types
 CHANGE COLUMN perms perms SET('groups', 'mail', 'directory_ax', 'directory_private',
-                              'edit_directory', 'forums', 'lists', 'payment') NOT NULL;
+                              'edit_directory', 'forums', 'lists', 'payment') NOT NULL,
+   ADD COLUMN description TEXT DEFAULT 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', '');
+REPLACE INTO account_types VALUES ('x', 'groups,mail,directory_private,forums,lists,payment', 'Polytechnicien'),
+                                  ('master', 'groups,directory_private,forums,lists,payment', 'Master de l\'X'),
+                                  ('phd', 'groups,directory_private,forums,lists,payment',    'Docteur de l\'X'),
+                                  ('pi', 'groups,forums,lists', 'Elève du programme international'),
+                                  ('ax', 'groups,directory_ax,edit_directory', 'Secrétariat de l\'AX'),
+                                  ('xnet', 'groups', NULL),
+                                  ('school', 'groups,directory_ax', 'Personnel de l\'X'),
+                                  ('fx', 'groups,directory_ax', 'Personnel de la FX'),
+                                  ('virtual', '', NULL);
 
 
 -- vim:set syntax=mysql: