| 1 | ALTER TABLE watch_profile |
| 2 | MODIFY field ENUM('search_names', 'nom', 'freetext', 'mobile', 'nationality1', 'nationality2', 'nationality3', |
| 3 | 'nick', 'networking', 'edus', 'addresses', 'section', 'binets', 'medals', |
| 4 | 'cv', 'jobs', 'photo', 'corps'); |
| 5 | |
| 6 | UPDATE watch_profile SET field = 'search_names' WHERE field = 'nom' OR field = 'nick'; |
| 7 | |
| 8 | ALTER TABLE watch_profile |
| 9 | MODIFY field ENUM('search_names', 'freetext', 'mobile', 'nationality1', 'nationality2', 'nationality3', |
| 10 | 'nick', 'networking', 'edus', 'addresses', 'section', 'binets', 'medals', |
| 11 | 'cv', 'jobs', 'photo', 'corps'); |
| 12 | |
| 13 | # vim:set syntax=mysql: |