Index: openacs-4/packages/attachments/sql/postgresql/attachments-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/attachments/sql/postgresql/attachments-create.sql,v diff -u -N -r1.2 -r1.3 --- openacs-4/packages/attachments/sql/postgresql/attachments-create.sql 9 Aug 2002 20:51:49 -0000 1.2 +++ openacs-4/packages/attachments/sql/postgresql/attachments-create.sql 30 Aug 2002 14:44:08 -0000 1.3 @@ -41,6 +41,12 @@ constraint attachments_item_id_fk references acs_objects(object_id) on delete cascade, + approved_p char(1) + default 't' + constraint attachments_approved_p_ck + check (approved_p in ('t', 'f')) + constraint attachments_approved_p_nn + not null, constraint attachments_pk primary key (object_id, item_id) );