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.2.3 -r1.63.2.4 --- openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql 11 Feb 2016 08:07:03 -0000 1.63.2.3 +++ openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql 12 Feb 2016 07:56:48 -0000 1.63.2.4 @@ -392,12 +392,12 @@ constraint cr_child_rels_parent_id_nn not null CONSTRAINT cr_child_rels_parent_id_fk - FOREIGN KEY (parent_id) REFERENCES acs_objects(object_id) ON DELETE CASCADE, + REFERENCES acs_objects(object_id) ON DELETE CASCADE, child_id integer constraint cr_child_rels_child_id_nn not null CONSTRAINT cr_child_rels_child_id_fk - FOREIGN KEY (child_id) REFERENCES cr_items(item_id) ON DELETE CASCADE, + REFERENCES cr_items(item_id) ON DELETE CASCADE, relation_tag varchar(100), order_n integer ); @@ -420,9 +420,8 @@ constraint cr_item_rels_rel_id_fk references acs_objects, item_id integer - constraint cr_item_rels_item_id_fk CONSTRAINT cr_item_rels_item_id_fk - FOREIGN KEY (item_id) REFERENCES cr_items(item_id) ON DELETE CASCADE, + REFERENCES cr_items(item_id) ON DELETE CASCADE, related_object_id integer constraint cr_item_rels_rel_obj_fk references acs_objects, @@ -956,7 +955,7 @@ primary key, target_id integer CONSTRAINT cr_symlinks_target_id_fk - FOREIGN KEY (target_id) REFERENCES cr_items(item_id) ON DELETE CASCADE + REFERENCES cr_items(item_id) ON DELETE CASCADE constraint cr_symlinks_target_id_nn not null, label varchar(1000)