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

ALTER TABLE watch_profile MODIFY field enum('search_names', 'nom', 'freetext', 'mobile', 'nationalite',
                                            'nationalite2', 'nationalite3', 'nick', 'web', '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', 'nationalite',
                                            'nationalite2', 'nationalite3', 'web', 'networking','edus',
                                            'addresses', 'section', 'binets', 'medals', 'cv', 'jobs',
                                            'photo', 'corps');

# vim:set syntax=mysql:
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
981d6bb2 SJ	13	# vim:set syntax=mysql: