aboutsummaryrefslogtreecommitdiffstats
path: root/db/schema_0060-add-convert_latlong.sql
diff options
context:
space:
mode:
authorStruan Donald <struan@exo.org.uk>2018-03-29 11:45:37 +0100
committerDave Arter <davea@mysociety.org>2018-03-29 16:04:33 +0100
commit90cf72fd66099bde47557c4eadf10856b8afffb2 (patch)
tree0e4016d8691ea6dd382d3ac9962b048ddee623b3 /db/schema_0060-add-convert_latlong.sql
parent9e806177d239f20ce3b11bf220800b0623ebc075 (diff)
add convert_latlong option to body table
For controlling if reports pulled in via Open311 should have the position converted from Easting/Northing to lat/long.
Diffstat (limited to 'db/schema_0060-add-convert_latlong.sql')
-rw-r--r--db/schema_0060-add-convert_latlong.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/db/schema_0060-add-convert_latlong.sql b/db/schema_0060-add-convert_latlong.sql
new file mode 100644
index 000000000..50c617e2c
--- /dev/null
+++ b/db/schema_0060-add-convert_latlong.sql
@@ -0,0 +1,5 @@
+BEGIN;
+
+ALTER TABLE body ADD convert_latlong boolean default 'f' not null;
+
+COMMIT;