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 # vim
:set syntax
=mysql
: