3f48a67470d86538c27875f3fa9cbf8693a0c06a
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';
5 WHERE field
= 'mobile';
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';
9 -- vim:set syntax=mysql: