Index: trunk/ippTools/share/chiptool_change_exp_state.sql
===================================================================
--- trunk/ippTools/share/chiptool_change_exp_state.sql	(revision 35770)
+++ trunk/ippTools/share/chiptool_change_exp_state.sql	(revision 35789)
@@ -5,5 +5,5 @@
 UPDATE chipRun
 JOIN rawExp using(exp_id)
-    SET chipRun.state = '%s'
+    SET chipRun.state = '%s', chipRun.update_mode = 0
     -- set magicked hook %s
     WHERE
Index: trunk/ippTools/share/chiptool_completely_processed_exp.sql
===================================================================
--- trunk/ippTools/share/chiptool_completely_processed_exp.sql	(revision 35770)
+++ trunk/ippTools/share/chiptool_completely_processed_exp.sql	(revision 35789)
@@ -15,4 +15,5 @@
     end_stage,
     imfile_magicked as magicked,
+    0 as update_mode,
     note
 FROM
Index: trunk/ippTools/share/pxadmin_create_tables.sql
===================================================================
--- trunk/ippTools/share/pxadmin_create_tables.sql	(revision 35770)
+++ trunk/ippTools/share/pxadmin_create_tables.sql	(revision 35789)
@@ -1,3 +1,3 @@
-eREATE TABLE dbversion (
+CREATE TABLE dbversion (
     schema_version VARCHAR(64),
     updated TIMESTAMP DEFAULT CURRENT_TIMESTAMP
@@ -299,4 +299,5 @@
     maskfrac_magic FLOAT,
     maskfrac_advisory FLOAT,
+    update_mode SMALLINT DEFAULT 0,
     note VARCHAR(255),
     PRIMARY KEY(chip_id),
Index: trunk/ippTools/share/pxadmin_drop_tables.sql
===================================================================
--- trunk/ippTools/share/pxadmin_drop_tables.sql	(revision 35770)
+++ trunk/ippTools/share/pxadmin_drop_tables.sql	(revision 35789)
@@ -115,4 +115,7 @@
 DROP TABLE IF EXISTS survey;
 DROP TABLE IF EXISTS lapGroup;
+DROP TABLE IF EXISTS mergedvodbCopy;
+DROP TABLE IF EXISTS mergedvodbProcessed;
+DROP TABLE IF EXISTS mergedvodbRun;
 
 SET FOREIGN_KEY_CHECKS=1
Index: trunk/ippTools/src/chiptool.c
===================================================================
--- trunk/ippTools/src/chiptool.c	(revision 35770)
+++ trunk/ippTools/src/chiptool.c	(revision 35789)
@@ -2018,4 +2018,5 @@
     PXOPT_LOOKUP_STR(class_id, config->args, "-class_id", false, false);
     PXOPT_LOOKUP_STR(label, config->args, "-set_label", false, false);
+    PXOPT_LOOKUP_S16(update_mode, config->args, "-set_update_mode", false, false);
 
     psString query = pxDataGet("chiptool_setimfiletoupdate.sql");
@@ -2029,4 +2030,6 @@
         psStringAppend(&setHook, "\n , chipRun.label = '%s'", label);
     }
+    // always set update_mode. If user has not supplied it zero is the right answer.
+    psStringAppend(&setHook, "\n, chipRun.update_mode = %d", update_mode);
 
     if (class_id) {
Index: trunk/ippTools/src/chiptoolConfig.c
===================================================================
--- trunk/ippTools/src/chiptoolConfig.c	(revision 35770)
+++ trunk/ippTools/src/chiptoolConfig.c	(revision 35789)
@@ -52,5 +52,5 @@
 
     psMetadataAddStr(definebyqueryArgs, PS_LIST_TAIL, "-set_workdir",  0,            "define workdir (required)", NULL);
-    psMetadataAddStr(definebyqueryArgs, PS_LIST_TAIL, "-set_label",  0,            "define label (required)", NULL);
+    psMetadataAddStr(definebyqueryArgs, PS_LIST_TAIL, "-set_label",  0,            "define label", NULL);
     psMetadataAddStr(definebyqueryArgs, PS_LIST_TAIL, "-set_reduction",  0,            "define reduction class", NULL);
     psMetadataAddStr(definebyqueryArgs, PS_LIST_TAIL, "-set_expgroup",  0,            "define exposure group", NULL);
@@ -107,4 +107,5 @@
     psMetadataAddStr(setimfiletoupdateArgs, PS_LIST_TAIL, "-class_id", 0,  "search by class_id", NULL);
     psMetadataAddStr(setimfiletoupdateArgs, PS_LIST_TAIL, "-set_label",  0,"new value for label", NULL);
+    psMetadataAddS16(setimfiletoupdateArgs, PS_LIST_TAIL, "-set_update_mode",  0,"new value for update_mode", 0);
 
     // -pendingimfile
Index: trunk/ippTools/src/pxchip.c
===================================================================
--- trunk/ippTools/src/pxchip.c	(revision 35770)
+++ trunk/ippTools/src/pxchip.c	(revision 35789)
@@ -283,4 +283,5 @@
 		       NAN,
 		       NAN,
+            0,         // update_mode
             note
             )