Commit | Line | Data |
---|---|---|
f0cd7e4c SJ |
1 | CREATE TABLE IF NOT EXISTS alumni_data ( |
2 | uid INT(11) NOT NULL, | |
0b37833b | 3 | matricule_ax CHAR(8) UNSIGNED NOT NULL, |
f0cd7e4c SJ |
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, | |
12 | PRIMARY KEY (uid) | |
13 | ) CHARSET=utf8; | |
14 | ||
15 | ||
16 | INSERT INTO alumni_data (uid, matricule_ax, login_ax, passwd_ax, promo_type, membership_type, | |
17 | salutation, last_dues_paid_year, represents, checked) | |
0b37833b | 18 | SELECT u.user_id, u.matricule_ax, f.Login, f.Password, f.Groupe_promo, |
f0cd7e4c SJ |
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); | |
22 | ||
23 | -- vim:set syntax=mysql: |