Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql,v diff -u -r1.63 -r1.63.2.1 --- openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql 3 May 2015 12:32:28 -0000 1.63 +++ openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql 16 Aug 2015 22:47:36 -0000 1.63.2.1 @@ -507,10 +507,10 @@ for multi-lingual searching in Intermedia. '; -alter table cr_items add constraint cr_items_live_fk +alter table cr_items add constraint cr_items_live_revision_fk foreign key (live_revision) references cr_revisions(revision_id) on delete set null; -alter table cr_items add constraint cr_items_latest_fk +alter table cr_items add constraint cr_items_latest_revision_fk foreign key (latest_revision) references cr_revisions(revision_id) on delete set null;