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 /db | |
parent | 6b887cac626dfa0802051cc898a75c36e5c55b4f (diff) |
Update contacts trigger, fix typo.
Diffstat (limited to 'db')
-rw-r--r-- | db/schema.sql | 2 |
1 files changed, 1 insertions, 1 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'; |