diff options
Diffstat (limited to 'db')
| -rw-r--r-- | db/alert_types.sql | 6 | ||||
| -rw-r--r-- | db/schema.sql | 4 |
2 files changed, 5 insertions, 5 deletions
diff --git a/db/alert_types.sql b/db/alert_types.sql index 63322f986..7f157c453 100644 --- a/db/alert_types.sql +++ b/db/alert_types.sql @@ -14,7 +14,7 @@ insert into alert_type item_table, item_where, item_order, item_title, item_link, item_description, template) values ('new_problems', '', '', - 'New problems on Neighbourhood Fix-It', '/', 'The latest problems reported by users', + 'New problems on FixMyStreet', '/', 'The latest problems reported by users', 'problem', 'problem.state in (\'confirmed\', \'fixed\')', 'created desc', '{{title}}', '/?id={{id}}', '{{detail}}', 'alert-problem'); @@ -24,7 +24,7 @@ insert into alert_type item_table, item_where, item_order, item_title, item_link, item_description, template) values ('local_problems', '', '', - 'New local problems on Neighbourhood Fix-It', '/', 'The latest local problems reported by users', + 'New local problems on FixMyStreet', '/', 'The latest local problems reported by users', 'problem_find_nearby(?, ?, ?) as nearby,problem', 'nearby.problem_id = problem.id and problem.state in (\'confirmed\', \'fixed\')', 'created desc', '{{title}}', '/?id={{id}}', '{{detail}}', 'alert-problem'); @@ -34,7 +34,7 @@ insert into alert_type item_table, item_where, item_order, item_title, item_link, item_description, template) values ('council_problems', '', '', - 'New local problems on Neighbourhood Fix-It', '/report', 'The latest local problems reported by users', + 'New local problems on FixMyStreet', '/report', 'The latest local problems reported by users', 'problem', 'problem.state in (\'confirmed\', \'fixed\') and council like \'%\'||?||\'%\'', 'created desc', '{{title}}', '/?id={{id}}', '{{detail}}', 'alert-problem' ); diff --git a/db/schema.sql b/db/schema.sql index 0b8169b79..38b0a61e0 100644 --- a/db/schema.sql +++ b/db/schema.sql @@ -1,10 +1,10 @@ -- schema.sql: --- Schema for Neighbourhood Fix-It database. +-- Schema for FixMyStreet database. -- -- Copyright (c) 2006 UK Citizens Online Democracy. All rights reserved. -- Email: matthew@mysociety.org; WWW: http://www.mysociety.org/ -- --- $Id: schema.sql,v 1.31 2007-05-15 13:43:20 matthew Exp $ +-- $Id: schema.sql,v 1.32 2007-06-15 14:57:51 matthew Exp $ -- -- secret |