upgrade/merge-0.0.1/02_ax_data.sql

   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: