Index: openacs-4/packages/acs-kernel/sql/oracle/authentication-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/authentication-create.sql,v
diff -u -r1.6 -r1.7
--- openacs-4/packages/acs-kernel/sql/oracle/authentication-create.sql	29 Aug 2003 15:21:57 -0000	1.6
+++ openacs-4/packages/acs-kernel/sql/oracle/authentication-create.sql	9 Sep 2003 11:15:00 -0000	1.7
@@ -43,7 +43,23 @@
     register_impl_id         integer
                              constraint auth_authority_reg_impl_fk
                              references acs_objects(object_id),
-    register_url             varchar2(4000)
+    register_url             varchar2(4000),
+    -- batch sync
+    -- Id of service contract getting batch sync doc
+    get_doc_impl_id          integer references acs_objects(object_id),
+    -- Id of service contract processing batch sync doc
+    process_doc_impl_id      integer references acs_objects(object_id),
+    -- Are batch syncs snapshots or of incremental type
+    snapshot_p               char(1) default 'f' 
+                             constraint auth_authority_snapshot_p_nn
+                             not null 
+                             constraint auth_authority_snapshot_p_ck
+                             check (snapshot_p in ('t','f')),
+    batch_sync_enabled_p     char(1) default 'f' 
+                             constraint auth_authority_bs_enabled_p_nn
+                             not null 
+                             constraint auth_authority_bs_enabled_p_ck
+                             check (batch_sync_enabled_p in ('t','f'))
 );
 
 comment on column auth_authorities.help_contact_text is '