| 1 | INSERT INTO profile_education (id, uid, grad_year, entry_year, eduid, degreeid, flags) |
| 2 | SELECT 100, u.user_id, u.promo_sortie, u.promo, e.id, d.id, 'primary' |
| 3 | FROM auth_user_md5 AS u |
| 4 | LEFT JOIN profile_education_enum AS e ON (e.abbreviation = "X") |
| 5 | LEFT JOIN profile_education_degree_enum AS d ON (d.degree = "Ingénieur"); |
| 6 | |
| 7 | CREATE TABLE profile_display ( |
| 8 | uid INT(11) NOT NULL DEFAULT 0, |
| 9 | promo_display VARCHAR(255) DEFAULT '' NOT NULL, |
| 10 | PRIMARY KEY(uid) |
| 11 | ) CHARSET=utf8; |
| 12 | |
| 13 | INSERT IGNORE INTO profile_display (uid, promo_display) |
| 14 | SELECT uid, CONCAT("X", entry_year) |
| 15 | FROM profile_education |
| 16 | WHERE FIND_IN_SET('primary', flags); |
| 17 | |
| 18 | -- vim:set syntax=mysql: |