upgrade/1.0.2/03_phones.sql

   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: