X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2F0.9.15%2F02_entreprises.sql;fp=upgrade%2F0.9.15%2F02_entreprises.sql;h=859e9ae90d065d9cf8d3832408a6fb6a36b2e157;hb=37d44b3b542764eda8d4f9c3febc814ae37f8157;hp=0000000000000000000000000000000000000000;hpb=2dcac0f527e8207d754af8974d81b2bce3f433d9;p=platal.git

diff --git a/upgrade/0.9.15/02_entreprises.sql b/upgrade/0.9.15/02_entreprises.sql
new file mode 100644
index 0000000..859e9ae
--- /dev/null
+++ b/upgrade/0.9.15/02_entreprises.sql
@@ -0,0 +1,7 @@
+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 key cityid (cityid);
+alter table entreprises add key country (country);
+alter table entreprises add key region (region);
+
+# vim:set syntax=mysql: