aboutsummaryrefslogtreecommitdiffstats
path: root/db/schema.sql
diff options
context:
space:
mode:
authorStruan Donald <struan@exo.org.uk>2011-08-16 10:38:49 +0100
committerStruan Donald <struan@exo.org.uk>2011-08-16 10:38:49 +0100
commitc104ae8c1d72eb25ba60686b58f01da148dc081f (patch)
tree83bbf971b4d4ca305452bdfaacf50cd30ae5317c /db/schema.sql
parent213948dcc9c281b1873da98e381b25231c376165 (diff)
parentf6ddc9d4db2e272d725e7ed44fb4d828d99d3b61 (diff)
Merge branch 'master' of ssh://git.mysociety.org/data/git/public/fixmystreet into open311-consumer
Conflicts: db/schema.sql perllib/FixMyStreet/DB/Result/Problem.pm
Diffstat (limited to 'db/schema.sql')
-rw-r--r--db/schema.sql4
1 files changed, 3 insertions, 1 deletions
diff --git a/db/schema.sql b/db/schema.sql
index e9dff0f84..d7bbf1127 100644
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -133,7 +133,8 @@ create table users (
email text not null unique,
name text,
phone text,
- password text not null default ''
+ password text not null default '',
+ flagged boolean not null default 'f'
);
-- Problems reported by users of site
@@ -180,6 +181,7 @@ 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'
);
create index problem_state_latitude_longitude_idx on problem(state, latitude, longitude);
create index problem_user_id_idx on problem ( user_id );