Commit | Line | Data |
---|---|---|
2f594bef SJ |
1 | ALTER TABLE watch_profile MODIFY COLUMN field ENUM('search_names','freetext','mobile','nationality1','nationality2','nationality3','nick','networking','edus','addresses','section','binets','medals','cv','jobs','photo','corps','tels') NOT NULL DEFAULT 'search_names'; |
2 | ||
3 | UPDATE watch_profile | |
4 | SET field = 'tels' | |
5 | WHERE field = 'mobile'; | |
6 | ||
7 | ALTER TABLE watch_profile MODIFY COLUMN field ENUM('search_names','freetext','nationality1','nationality2','nationality3','nick','networking','edus','addresses','section','binets','medals','cv','jobs','photo','corps','tels') NOT NULL DEFAULT 'search_names'; | |
8 | ||
9 | -- vim:set syntax=mysql: |