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.17 -r1.18 --- openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql 12 May 2001 05:09:48 -0000 1.17 +++ openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql 19 Jun 2001 04:36:18 -0000 1.18 @@ -469,15 +469,9 @@ -------------------------------------------------------------- create table cr_item_publish_audit ( - item_id integer - constraint cr_item_publish_audit_fk - references cr_items on delete cascade, - old_revision integer - constraint cr_item_pub_audit_old_rev_fk - references cr_revisions, - new_revision integer - constraint cr_item_pub_audit_new_rev_fk - references cr_revisions, + item_id integer, + old_revision integer, + new_revision integer, old_status varchar(40), new_status varchar(40), publish_date timestamp