| 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); |
| 9 | |
| 10 | # vim:set syntax=mysql: |