1 alter table entreprises
add column cityid
int(11) default null after city
;
2 alter table entreprises
add column regiontxt
varchar(80) not null after region
;
3 alter table entreprises
add column flags
set('geoloc') not null;
4 alter table entreprises
add key cityid (cityid
);
5 alter table entreprises
add key country (country
);
6 alter table entreprises
add key region (region
);
8 # vim
:set syntax
=mysql
: