1 CREATE TABLE IF NOT EXISTS alumni_data (
3 matricule_ax
CHAR(8) UNSIGNED
NOT NULL,
4 login_ax
VARCHAR(15) NOT NULL,
5 passwd_ax
INT(11) UNSIGNED
DEFAULT NULL,
6 promo_type
ENUM('', 'A', 'B', 'C', 'N', 'S') NOT NULL,
7 membership_type
ENUM('', '*', 'F', 'FB', 'P', 'PB', 'T', 'TB', 'TA') NOT NULL,
8 salutation
ENUM('', '.', 'M', 'MME', 'MLLE') NOT NULL,
9 last_dues_paid_year
INT(4) UNSIGNED
NOT NULL,
10 represents
ENUM('', 'K', 'DE') NOT NULL,
11 checked TINYINT(1) UNSIGNED
NOT NULL DEFAULT 0,
16 INSERT INTO alumni_data (uid
, matricule_ax
, login_ax
, passwd_ax
, promo_type
, membership_type
,
17 salutation
, last_dues_paid_year
, represents
, checked)
18 SELECT u.user_id
, u.matricule_ax
, f.
Login, f.
Password, f.Groupe_promo
,
19 f.Type_membre
, f.Civilite
, f.annee_dernCot
, f.Representant
, 0
20 FROM fusionax_anciens
AS f
21 INNER JOIN auth_user_md5
AS u
ON (f.id_ancien
= u.matricule_ax
);
23 -- vim:set syntax=mysql: