Commit | Line | Data |
---|---|---|
fb2c09c9 SJ |
1 | INSERT INTO profile_education (id, uid, grad_year, entry_year, eduid, degreeid, flags) |
2 | SELECT 100, user_id, promo_sortie, promo, 20, 2, 'primary' | |
3 | FROM auth_user_md5; | |
4 | ||
5 | CREATE TABLE profile_display ( | |
6 | uid INT(11) NOT NULL DEFAULT 0, | |
7 | promo_display VARCHAR(255) DEFAULT '' NOT NULL, | |
8 | PRIMARY KEY(uid) | |
9 | ) CHARSET=utf8; | |
10 | ||
11 | INSERT IGNORE INTO profile_display (uid, promo_display) | |
12 | SELECT uid, CONCAT("X", entry_year) | |
13 | FROM profile_education | |
14 | WHERE FIND_IN_SET('primary', flags); | |
15 | ||
16 | -- vim:set syntax=mysql: |