| 1 | CREATE TABLE IF NOT EXISTS alumni_data ( |
| 2 | uid INT(11) NOT NULL, |
| 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, |
| 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) |
| 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); |
| 22 | |
| 23 | -- vim:set syntax=mysql: |