Index: openacs-4/packages/ecommerce/sql/postgresql/ecds-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/sql/postgresql/ecds-create.sql,v
diff -u -N -r1.2 -r1.3
--- openacs-4/packages/ecommerce/sql/postgresql/ecds-create.sql	12 Feb 2009 06:26:14 -0000	1.2
+++ openacs-4/packages/ecommerce/sql/postgresql/ecds-create.sql	9 May 2009 18:38:44 -0000	1.3
@@ -120,3 +120,14 @@
 create index ecds_product_id_site_url_map_site_url_idx on ecds_product_id_site_url_map (site_url);
 create index ecds_product_id_site_url_map_product_idx on ecds_product_id_site_url_map (product_id);
 
+-- process_control allows near realtime control of procedures programmed to use it.
+-- Processes check if okay_to_start before beginning. Extended processes check before each iteration
+-- thereby providing a clean way to stop a batch process without having to shutdown the server.
+
+ CREATE TABLE ecds_process_control (
+   process_ref varchar(48) unique,
+   okay_to_start varchar(1) default 'f',
+   status text
+ );
+
+create index ecds_process_control_proc_ref_idx on ecds_process_control (process_ref);
Index: openacs-4/packages/ecommerce/sql/postgresql/ecds-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/sql/postgresql/ecds-drop.sql,v
diff -u -N -r1.2 -r1.3
--- openacs-4/packages/ecommerce/sql/postgresql/ecds-drop.sql	12 Feb 2009 06:26:14 -0000	1.2
+++ openacs-4/packages/ecommerce/sql/postgresql/ecds-drop.sql	9 May 2009 18:38:44 -0000	1.3
@@ -1,3 +1,5 @@
+drop index ecds_process_control_proc_ref_idx;
+drop table ecds_process_control;
 drop index ecds_product_id_site_url_map_site_url_idx;
 drop index ecds_product_id_site_url_map_product_idx;
 drop table ecds_product_id_site_url_map;