Update contacts trigger, fix typo.

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';