aboutsummaryrefslogtreecommitdiffstats
path: root/db/schema.sql
diff options
context:
space:
mode:
authorStruan Donald <struan@exo.org.uk>2011-11-30 22:04:33 +0000
committerStruan Donald <struan@exo.org.uk>2011-11-30 22:04:33 +0000
commit0f43cd3b8fbe82256c052aaad65c6a16e3668cbe (patch)
treee80405918a85cb8847d4a4ef3e602ff400cba4f0 /db/schema.sql
parentd69c8404b6ca7cc3b92f3fd1d175b000f2f82e08 (diff)
parent783601d101ad0ff356921c2f3af0e8b3b9d6e24e (diff)
Merge branch 'rss-addresses'
Conflicts: db/schema.sql perllib/FixMyStreet/DB/Result/Problem.pm
Diffstat (limited to 'db/schema.sql')
-rw-r--r--db/schema.sql3
1 files changed, 2 insertions, 1 deletions
diff --git a/db/schema.sql b/db/schema.sql
index fcd137919..395d1c07b 100644
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -188,7 +188,8 @@ create table problem (
whensent timestamp,
send_questionnaire boolean not null default 't',
extra text, -- extra fields required for open311
- 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 );