diff options
| author | matthew <matthew> | 2007-08-27 20:29:33 +0000 |
|---|---|---|
| committer | matthew <matthew> | 2007-08-27 20:29:33 +0000 |
| commit | c0808959a627c17af9f99b23e572392b63aac670 (patch) | |
| tree | cfe7c1821d6d14d52697266f0a031052c5eb4b3b /db | |
| parent | d5096b4f393d2f8a18515b7808bd064dc71567ac (diff) | |
Improve SQL; correct footer on email alert; layout tweak.
Diffstat (limited to 'db')
| -rw-r--r-- | db/alert_types.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/db/alert_types.sql b/db/alert_types.sql index d909450c1..356f339d1 100644 --- a/db/alert_types.sql +++ b/db/alert_types.sql @@ -40,7 +40,7 @@ insert into alert_type values ('council_problems', '', '', 'New problems to {{COUNCIL}} on FixMyStreet', '/reports', 'The latest problems for {{COUNCIL}} reported by users', 'problem', 'problem.state in (\'confirmed\', \'fixed\') and (council like \'%\'||?||\'%\' - or (council is null and areas like \'%,\'||?||\',%\'))', 'created desc', + or council is null) and areas like \'%,\'||?||\',%\'', 'created desc', '{{title}}, {{confirmed}}', '/?id={{id}}', '{{detail}}', 'alert-problem' ); |