diff options
author | Matthew Somerville <matthew-github@dracos.co.uk> | 2015-08-13 12:21:20 +0100 |
---|---|---|
committer | Matthew Somerville <matthew@mysociety.org> | 2015-08-13 13:38:14 +0100 |
commit | ef3a3a789e8f91b62dc562ff69781dc0daa80871 (patch) | |
tree | 6045ce7399229bfcb2eca4090f1707d6fc79830b /perllib/FixMyStreet/DB/Result/Problem.pm | |
parent | 864fcb6a81b17ec6324598973ff29dd734a7baf8 (diff) |
Remove ms_current_timestamp() override function.
This override is not used anywhere, it dates from a very old long-gone
test script, and causes issues with database query planning.
Diffstat (limited to 'perllib/FixMyStreet/DB/Result/Problem.pm')
-rw-r--r-- | perllib/FixMyStreet/DB/Result/Problem.pm | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/perllib/FixMyStreet/DB/Result/Problem.pm b/perllib/FixMyStreet/DB/Result/Problem.pm index bed2f160a..caf748f1e 100644 --- a/perllib/FixMyStreet/DB/Result/Problem.pm +++ b/perllib/FixMyStreet/DB/Result/Problem.pm @@ -53,7 +53,7 @@ __PACKAGE__->add_columns( "created", { data_type => "timestamp", - default_value => \"ms_current_timestamp()", + default_value => \"current_timestamp", is_nullable => 0, }, "confirmed", @@ -71,7 +71,7 @@ __PACKAGE__->add_columns( "lastupdate", { data_type => "timestamp", - default_value => \"ms_current_timestamp()", + default_value => \"current_timestamp", is_nullable => 0, }, "whensent", @@ -441,7 +441,7 @@ sub confirm { return if $self->state eq 'confirmed'; $self->state('confirmed'); - $self->confirmed( \'ms_current_timestamp()' ); + $self->confirmed( \'current_timestamp' ); return 1; } @@ -735,8 +735,8 @@ sub update_from_open311_service_request { { problem_id => $self->id, state => 'confirmed', - created => $updated || \'ms_current_timestamp()', - confirmed => \'ms_current_timestamp()', + created => $updated || \'current_timestamp', + confirmed => \'current_timestamp', text => $status_notes, mark_open => 0, mark_fixed => 0, @@ -789,7 +789,7 @@ sub update_send_failed { $self->update( { send_fail_count => $self->send_fail_count + 1, - send_fail_timestamp => \'ms_current_timestamp()', + send_fail_timestamp => \'current_timestamp', send_fail_reason => $msg } ); } |