[platal.git] / upgrade / 0.9.15 / 02_entreprises.sql

alter table entreprises add column cityid int(11) default null after city;
alter table entreprises add column regiontxt varchar(80) not null after region;
alter table entreprises add column flags set('geoloc') not null;
alter table entreprises add column glat float(9,6) not null default 0;
alter table entreprises add column glng float(9,6) not null default 0;
alter table entreprises add key cityid (cityid);
alter table entreprises add key country (country);
alter table entreprises add key region (region);

# vim:set syntax=mysql:
Commit	Line	Data
37d44b3b FB	1	alter table entreprises add column cityid int(11) default null after city;
37d44b3b FB	2	alter table entreprises add column regiontxt varchar(80) not null after region;
f93fb300	3	alter table entreprises add column flags set('geoloc') not null;
de0485fd FB	4	alter table entreprises add column glat float(9,6) not null default 0;
de0485fd FB	5	alter table entreprises add column glng float(9,6) not null default 0;
37d44b3b FB	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: