Commit | Line | Data |
---|---|---|
b4326b9e SJ |
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: |