Index: openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-5.9.0d2-5.9.0d3.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-5.9.0d2-5.9.0d3.sql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-5.9.0d2-5.9.0d3.sql 3 May 2015 12:40:38 -0000 1.2 +++ openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-5.9.0d2-5.9.0d3.sql 7 Aug 2017 23:47:47 -0000 1.3 @@ -26,38 +26,38 @@ -- constraints from acs-content-repository/sql/postgresql/content-revision.sql -ALTER TABLE cr_item_publish_audit DROP CONSTRAINT cr_item_publish_audit_orev_fk; +ALTER TABLE cr_item_publish_audit DROP CONSTRAINT IF EXISTS cr_item_publish_audit_orev_fk; ALTER TABLE cr_item_publish_audit ADD CONSTRAINT cr_item_publish_audit_orev_fk FOREIGN KEY (old_revision) REFERENCES cr_revisions(revision_id) ON DELETE CASCADE; -ALTER TABLE cr_item_publish_audit DROP CONSTRAINT cr_item_publish_audit_nrev_fk; +ALTER TABLE cr_item_publish_audit DROP CONSTRAINT IF EXISTS cr_item_publish_audit_nrev_fk; ALTER TABLE cr_item_publish_audit ADD CONSTRAINT cr_item_publish_audit_nrev_fk FOREIGN KEY (new_revision) REFERENCES cr_revisions(revision_id) ON DELETE CASCADE; -- constraints from acs-content-repository/sql/postgresql/content-item.sql -ALTER TABLE cr_release_periods DROP CONSTRAINT cr_release_periods_item_id_fk; +ALTER TABLE cr_release_periods DROP CONSTRAINT IF EXISTS cr_release_periods_item_id_fk; ALTER TABLE cr_release_periods ADD CONSTRAINT cr_release_periods_item_id_fk FOREIGN KEY (item_id) REFERENCES cr_items(item_id) ON DELETE CASCADE; -ALTER TABLE cr_item_publish_audit DROP CONSTRAINT cr_item_publish_audit_item_fk; +ALTER TABLE cr_item_publish_audit DROP CONSTRAINT IF EXISTS cr_item_publish_audit_item_fk; ALTER TABLE cr_item_publish_audit ADD CONSTRAINT cr_item_publish_audit_item_fk FOREIGN KEY (item_id) REFERENCES cr_items(item_id) ON DELETE CASCADE; -ALTER TABLE cr_item_template_map DROP CONSTRAINT cr_item_template_map_item_fk; +ALTER TABLE cr_item_template_map DROP CONSTRAINT IF EXISTS cr_item_template_map_item_fk; ALTER TABLE cr_item_template_map ADD CONSTRAINT cr_item_template_map_item_fk FOREIGN KEY (item_id) REFERENCES cr_items(item_id) ON DELETE CASCADE; -ALTER TABLE cr_item_keyword_map DROP CONSTRAINT cr_item_keyword_map_item_id_fk; +ALTER TABLE cr_item_keyword_map DROP CONSTRAINT IF EXISTS cr_item_keyword_map_item_id_fk; ALTER TABLE cr_item_keyword_map ADD CONSTRAINT cr_item_keyword_map_item_id_fk FOREIGN KEY (item_id) REFERENCES cr_items(item_id) ON DELETE CASCADE; -ALTER TABLE cr_items DROP CONSTRAINT cr_items_latest_fk; +ALTER TABLE cr_items DROP CONSTRAINT IF EXISTS cr_items_latest_fk; ALTER TABLE cr_items ADD CONSTRAINT cr_items_latest_fk FOREIGN KEY (latest_revision) REFERENCES cr_revisions(revision_id) on delete set null; -ALTER TABLE cr_items DROP CONSTRAINT cr_items_live_fk; +ALTER TABLE cr_items DROP CONSTRAINT IF EXISTS cr_items_live_fk; ALTER TABLE cr_items ADD CONSTRAINT cr_items_live_fk FOREIGN KEY (live_revision) REFERENCES cr_revisions(revision_id) on delete set null; @@ -149,7 +149,7 @@ -- -- The following loop could be dropped / replaced by a cascade -- operation, when proper foreign keys are used along the - -- inheritence path. + -- inheritance path. -- for v_revision_val in select revision_id from cr_revisions