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