Uncomment foreign keys.

[platal.git] / upgrade / 1.0.1 / 02_accounts.sql

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,
   ADD COLUMN description TEXT DEFAULT NULL;

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: