Index: openacs-4/packages/attachments/sql/oracle/attachments-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/attachments/sql/oracle/attachments-create.sql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/attachments/sql/oracle/attachments-create.sql	9 Aug 2002 20:51:49 -0000	1.3
+++ openacs-4/packages/attachments/sql/oracle/attachments-create.sql	30 Aug 2002 14:44:06 -0000	1.4
@@ -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)
 );