[platal.git] / upgrade / newdirectory-0.0.1 / 14_watchnames.sql

ALTER TABLE  watch_profile
     MODIFY  field ENUM('search_names', 'nom', 'freetext', 'mobile', 'nationality1', 'nationality2', 'nationality3',
                        'nick', 'networking', 'edus', 'addresses', 'section', 'binets', 'medals',
                        'cv', 'jobs', 'photo', 'corps');

UPDATE watch_profile SET field = 'search_names' WHERE field = 'nom' OR field = 'nick';

ALTER TABLE  watch_profile
     MODIFY  field ENUM('search_names', 'freetext', 'mobile', 'nationality1', 'nationality2', 'nationality3',
                        'nick', 'networking', 'edus', 'addresses', 'section', 'binets', 'medals',
                        'cv', 'jobs', 'photo', 'corps');

# vim:set syntax=mysql:
Commit	Line	Data
86c104d1 SJ	1	ALTER TABLE watch_profile
	2	MODIFY field ENUM('search_names', 'nom', 'freetext', 'mobile', 'nationality1', 'nationality2', 'nationality3',
	3	'nick', 'networking', 'edus', 'addresses', 'section', 'binets', 'medals',
	4	'cv', 'jobs', 'photo', 'corps');
981d6bb2 SJ	5
	6	UPDATE watch_profile SET field = 'search_names' WHERE field = 'nom' OR field = 'nick';
	7
86c104d1 SJ	8	ALTER TABLE watch_profile
	9	MODIFY field ENUM('search_names', 'freetext', 'mobile', 'nationality1', 'nationality2', 'nationality3',
	10	'nick', 'networking', 'edus', 'addresses', 'section', 'binets', 'medals',
	11	'cv', 'jobs', 'photo', 'corps');
981d6bb2 SJ	12
981d6bb2 SJ	13	# vim:set syntax=mysql: