Add updated function to db alter sql

1 files changed, 8 insertions, 0 deletions

diff --git a/db/schema_0001-add_sessions_and_users_and_dbic_fields.sql b/db/schema_0001-add_sessions_and_users_and_dbic_fields.sql
index aadaa0993..992f3c685 100644
--- a/db/schema_0001-add_sessions_and_users_and_dbic_fields.sql
+++ b/db/schema_0001-add_sessions_and_users_and_dbic_fields.sql
@@ -35,5 +35,13 @@ update contacts_history
 
 AlTER TABLE contacts_history
     alter COLUMN contact_id SET NOT NULL;
+    
+create or replace function contacts_updated()
+    returns trigger as '
+    begin
+        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';
 
 commit;