aboutsummaryrefslogtreecommitdiffstats
path: root/db/schema.sql
diff options
context:
space:
mode:
authorEdmund von der Burg <evdb@mysociety.org>2011-04-11 11:43:13 +0100
committerEdmund von der Burg <evdb@mysociety.org>2011-04-11 11:43:13 +0100
commit1c70dcf732f3b6ced75c734703ccce237cfbd3ce (patch)
tree9ad3928d9ba84d8d8f68e7bcbc803e0e52d7d526 /db/schema.sql
parent57677197480e18bf2c917ba9fc444797b0db8bff (diff)
parenta37eb834665ea7a88e9d900577f3189a9094dee7 (diff)
Merge branch 'migrate_to_catalyst' of ssh://evdb@git.mysociety.org/data/git/public/fixmystreet into migrate_to_catalyst
Diffstat (limited to 'db/schema.sql')
-rw-r--r--db/schema.sql2
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';