| 1 | ALTER TABLE auth_user_md5 ADD COLUMN nationalite2 CHAR(2) DEFAULT NULL, |
| 2 | ADD COLUMN nationalite3 CHAR(2) DEFAULT NULL, |
| 3 | ADD KEY nationalite2 (nationalite2), |
| 4 | ADD KEY nationalite3 (nationalite3), |
| 5 | MODIFY nationalite CHAR(2) DEFAULT NULL; |
| 6 | |
| 7 | UPDATE auth_user_md5 SET nationalite=NULL WHERE nationalite="00" OR nationalite=''; |
| 8 | |
| 9 | DELETE FROM geoloc_pays WHERE a2="00"; |
| 10 | |
| 11 | ALTER TABLE watch_profile MODIFY field enum('nom', 'freetext', 'mobile', 'nationalite', 'nationalite2', 'nationalite3', |
| 12 | 'nick', 'web', 'networking', 'appli1', 'appli2', 'addresses', |
| 13 | 'section', 'binets', 'medals', 'cv', 'jobs', 'photo'); |
| 14 | |
| 15 | # vim:set syntax=mysql: |