upgrade/0.9.15/02_entreprises.sql

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