Index: openacs.org-dev/packages/attachments/sql/oracle/attachments-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs.org-dev/packages/attachments/sql/oracle/attachments-create.sql,v
diff -u -r1.1.1.1 -r1.1.1.2
--- openacs.org-dev/packages/attachments/sql/oracle/attachments-create.sql	9 Jul 2002 17:35:01 -0000	1.1.1.1
+++ openacs.org-dev/packages/attachments/sql/oracle/attachments-create.sql	8 Oct 2002 15:46:55 -0000	1.1.1.2
@@ -1,5 +1,5 @@
 --
---  Copyright (C) 2001, 2002 OpenForce, Inc.
+--  Copyright (C) 2001, 2002 MIT
 --
 --  this is free software; you can redistribute it and/or modify it under the
 --  terms of the GNU General Public License as published by the Free Software
@@ -32,11 +32,17 @@
 
 create table attachments (
     object_id                   constraint attachments_object_id_fk
-                                references acs_objects(object_id)
+                                references acs_objects (object_id)
                                 on delete cascade,
     item_id                     constraint attachments_item_id_fk
-                                references acs_objects(object_id)
+                                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)
 );
