diff options
| author | Struan Donald <struan@exo.org.uk> | 2012-08-23 12:45:18 +0100 |
|---|---|---|
| committer | Struan Donald <struan@exo.org.uk> | 2012-08-23 12:45:18 +0100 |
| commit | ee7770bb0130e2e0483af203c7410dad8269bdd7 (patch) | |
| tree | 72d03e41f0749111390d37bef2cc726d9bdce5e7 /db/schema.sql | |
| parent | 70850bf8a35a5a40b6d4a52b9d342468956797c9 (diff) | |
initial crude add support option for a problem
Diffstat (limited to 'db/schema.sql')
| -rw-r--r-- | db/schema.sql | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/db/schema.sql b/db/schema.sql index 690b7080f..571c71bcd 100644 --- a/db/schema.sql +++ b/db/schema.sql @@ -202,7 +202,10 @@ create table problem ( -- record details about messages from external sources, eg. message manager external_source text, - external_source_id text + external_source_id text, + + -- number of me toos + interest_count integer ); create index problem_state_latitude_longitude_idx on problem(state, latitude, longitude); create index problem_user_id_idx on problem ( user_id ); |