Merge branch 'master' into fusionax
[platal.git] / upgrade / merge-0.0.1 / 000_1920.sql
1 set @n = 19200001;
2
3 INSERT INTO auth_user_md5 (matricule, matricule_ax, promo, promo_sortie, nom_ini, prenom_ini, perms, nom, prenom)
4 SELECT @n := @n + 1, id_ancien, promotion_etude, promotion_etude + 3, CONCAT(partic_patro, Nom_patronymique), prenom,
5 'pending', CONCAT(partic_patro, Nom_patronymique), prenom
6 FROM fusionax_anciens
7 WHERE promotion_etude = 1920;
8
9 -- vim:set syntax=mysql: