X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2F0.9.15%2F02_entreprises.sql;h=d4abbb4de26f36c9dc6c27ee4d433a0167337195;hb=4f35a3ca07b72943c53395ffc7ea49d493031940;hp=79cd796b6136f2278e469fc1b2ef863c41dde9db;hpb=f93fb300b28961f8a7dd0b6403a85eed3d1c0c6e;p=platal.git

diff --git a/upgrade/0.9.15/02_entreprises.sql b/upgrade/0.9.15/02_entreprises.sql
index 79cd796..d4abbb4 100644
--- a/upgrade/0.9.15/02_entreprises.sql
+++ b/upgrade/0.9.15/02_entreprises.sql
@@ -1,6 +1,8 @@
 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);