diff options
| author | Struan Donald <struan@exo.org.uk> | 2011-10-10 14:50:30 +0100 |
|---|---|---|
| committer | Struan Donald <struan@exo.org.uk> | 2011-10-10 14:50:30 +0100 |
| commit | 6e7276b843fde5e0490c3859f4beb92538004c0e (patch) | |
| tree | 51bbf37602f6f3c6c83eae8a80e22a5a99c49194 /db/schema_0009-update_alerts_problem_state_queries.sql | |
| parent | a8b2d90c78103024b58b1760db72ab5c9397511b (diff) | |
| parent | 5eb4f4e746283b4e945b52745503baa4da4f345f (diff) | |
Merge remote branch 'origin/master' into open311-consumer
Diffstat (limited to 'db/schema_0009-update_alerts_problem_state_queries.sql')
| -rw-r--r-- | db/schema_0009-update_alerts_problem_state_queries.sql | 28 |
1 files changed, 28 insertions, 0 deletions
diff --git a/db/schema_0009-update_alerts_problem_state_queries.sql b/db/schema_0009-update_alerts_problem_state_queries.sql new file mode 100644 index 000000000..fc5de927a --- /dev/null +++ b/db/schema_0009-update_alerts_problem_state_queries.sql @@ -0,0 +1,28 @@ +begin; + + UPDATE alert_type set item_where = 'nearby.problem_id = problem.id and problem.state in + (''confirmed'', ''investigating'', ''planned'', ''in progress'', + ''fixed'', ''fixed - council'', ''fixed - user'', ''closed'')' WHERE ref = 'postcode_local_problems'; + UPDATE alert_type set item_where = 'problem.state in + (''confirmed'', ''investigating'', ''planned'', ''in progress'', + ''fixed'', ''fixed - council'', ''fixed - user'', ''closed'' )' WHERE ref = 'new_problems'; + UPDATE alert_type set item_where = 'problem.state in (''fixed'', ''fixed - user'', ''fixed - council'')' WHERE ref = 'new_fixed_problems'; + UPDATE alert_type set item_where = 'nearby.problem_id = problem.id and problem.state in + (''confirmed'', ''investigating'', ''planned'', ''in progress'', + ''fixed'', ''fixed - council'', ''fixed - user'', ''closed'')' WHERE ref = 'local_problems'; + UPDATE alert_type set item_where = 'problem.state in + (''confirmed'', ''investigating'', ''planned'', ''in progress'', + ''fixed'', ''fixed - council'', ''fixed - user'', ''closed'') and + (council like ''%''||?||''%'' or council is null) and + areas like ''%,''||?||'',%''' WHERE ref = 'council_problems'; + UPDATE alert_type set item_where = 'problem.state in + (''confirmed'', ''investigating'', ''planned'', ''in progress'', + ''fixed'', ''fixed - council'', ''fixed - user'', ''closed'') and + (council like ''%''||?||''%'' or council is null) and + areas like ''%,''||?||'',%''' WHERE ref = 'ward_problems'; + UPDATE alert_type set item_where = 'problem.state in + (''confirmed'', ''investigating'', ''planned'', ''in progress'', + ''fixed'', ''fixed - council'', ''fixed - user'', ''closed'') and + areas like ''%,''||?||'',%''' WHERE ref = 'area_problems'; + +commit; |