From 948c93586af197c482c96c34899f578b2de56702 Mon Sep 17 00:00:00 2001
From: Struan Donald <struan@exo.org.uk>
Date: Mon, 19 Sep 2011 14:59:23 +0100
Subject: geocode column to bytea type

---
 db/schema.sql | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'db/schema.sql')

diff --git a/db/schema.sql b/db/schema.sql
index 99cf2832d..c0f225aa1 100644
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -184,7 +184,8 @@ create table problem (
     lastupdate timestamp not null default ms_current_timestamp(),
     whensent timestamp,
     send_questionnaire boolean not null default 't',
-    flagged boolean not null default 'f'
+    flagged boolean not null default 'f',
+    geocode bytea
 );
 create index problem_state_latitude_longitude_idx on problem(state, latitude, longitude);
 create index problem_user_id_idx on problem ( user_id );
-- 
cgit v1.2.3