diff options
| author | Matthew Somerville <matthew@fury.ukcod.org.uk> | 2011-04-11 11:03:26 +0100 |
|---|---|---|
| committer | Matthew Somerville <matthew@fury.ukcod.org.uk> | 2011-04-11 11:03:26 +0100 |
| commit | 329a234c97dc7b8fa8280fee4ddb74a3e77f3a74 (patch) | |
| tree | fac0e2ebd4feefe9941b908ba903d7b6c4d35438 | |
| parent | 6b887cac626dfa0802051cc898a75c36e5c55b4f (diff) | |
Update contacts trigger, fix typo.
| -rw-r--r-- | db/schema.sql | 2 | ||||
| -rw-r--r-- | notes/INSTALL-catalyst.txt | 4 |
2 files changed, 3 insertions, 3 deletions
diff --git a/db/schema.sql b/db/schema.sql index a44b91ca7..297a13946 100644 --- a/db/schema.sql +++ b/db/schema.sql @@ -107,7 +107,7 @@ create table contacts_history ( create function contacts_updated() returns trigger as ' begin - insert into contacts_history (area_id, category, email, editor, whenedited, note, confirmed, deleted) values (new.area_id, new.category, new.email, new.editor, new.whenedited, new.note, new.confirmed, new.deleted); + insert into contacts_history (contact_id, area_id, category, email, editor, whenedited, note, confirmed, deleted) values (new.id, new.area_id, new.category, new.email, new.editor, new.whenedited, new.note, new.confirmed, new.deleted); return new; end; ' language 'plpgsql'; diff --git a/notes/INSTALL-catalyst.txt b/notes/INSTALL-catalyst.txt index c3dfd0256..821b5a432 100644 --- a/notes/INSTALL-catalyst.txt +++ b/notes/INSTALL-catalyst.txt @@ -89,7 +89,7 @@ The DBIx::Class code uses a separate DBI connection than the mySociety::DBHandle FixMyStreet::App is a fairly standard Catalyst app, there aren't any really big surprises. -Note that the FixMyStree.pm file is used though to abstract some config related things. Note the FixMyStreet->test_mode(1) which will do things like send all emails to a memory queue for the test scripts. test_mode should only be used in test scripts, and so is different from setting STAGING to true. +Note that the FixMyStreet.pm file is used though to abstract some config related things. Note the FixMyStreet->test_mode(1) which will do things like send all emails to a memory queue for the test scripts. test_mode should only be used in test scripts, and so is different from setting STAGING to true. ############## testing ################## @@ -104,4 +104,4 @@ or a specific test in verbose mode using: prove -lv t/app/controller/report_new.t -For all the lovely options do 'prove --help'. Note I've made no attempt to make the tests be able to run in parallel, the database fiddling would not be worth it.
\ No newline at end of file +For all the lovely options do 'prove --help'. Note I've made no attempt to make the tests be able to run in parallel, the database fiddling would not be worth it. |