1 ALTER TABLE auth_user_md5
ADD COLUMN nationalite2
CHAR(2) DEFAULT NULL,
2 ADD COLUMN nationalite3
CHAR(2) DEFAULT NULL,
3 ADD KEY nationalite2 (nationalite2
),
4 ADD KEY nationalite3 (nationalite3
),
5 MODIFY nationalite
CHAR(2) DEFAULT NULL;
7 UPDATE auth_user_md5
SET nationalite
=NULL WHERE nationalite
="00" OR nationalite
='';
9 DELETE FROM geoloc_pays
WHERE a2
="00";
11 ALTER TABLE watch_profile
MODIFY field
enum('nom', 'freetext', 'mobile', 'nationalite', 'nationalite2', 'nationalite3',
12 'nick', 'web', 'networking', 'appli1', 'appli2', 'addresses',
13 'section', 'binets', 'medals', 'cv', 'jobs', 'photo');
15 # vim
:set syntax
=mysql
: