d4abbb4de26f36c9dc6c27ee4d433a0167337195
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 column glat
float(9,6) not null default 0;
5 alter table entreprises
add column glng
float(9,6) not null default 0;
6 alter table entreprises
add key cityid (cityid
);
7 alter table entreprises
add key country (country
);
8 alter table entreprises
add key region (region
);
10 # vim
:set syntax
=mysql
: