859e9ae90d065d9cf8d3832408a6fb6a36b2e157
[platal.git] / 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 key cityid (cityid);
4 alter table entreprises add key country (country);
5 alter table entreprises add key region (region);
6
7 # vim:set syntax=mysql: