Job page should work

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

diff --git a/upgrade/0.9.15/02_entreprises.sql b/upgrade/0.9.15/02_entreprises.sql
new file mode 100644 (file)
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: