Commit | Line | Data |
---|---|---|
981d6bb2 SJ |
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', | |
ef7d4b7b | 4 | 'jobs', 'photo', 'corps'); |
981d6bb2 SJ |
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', | |
ef7d4b7b | 11 | 'photo', 'corps'); |
981d6bb2 SJ |
12 | |
13 | # vim:set syntax=mysql: |