Index: /tags/ipp-20130307/dbconfig/chip.md
===================================================================
--- /tags/ipp-20130307/dbconfig/chip.md	(revision 35787)
+++ /tags/ipp-20130307/dbconfig/chip.md	(revision 35788)
@@ -20,4 +20,5 @@
     maskfrac_magic  F32     0.0
     maskfrac_advisory F32   0.0
+    update_mode S16         0  
     note        STR         255
 END
Index: /tags/ipp-20130307/ippTools/share/chiptool_change_exp_state.sql
===================================================================
--- /tags/ipp-20130307/ippTools/share/chiptool_change_exp_state.sql	(revision 35787)
+++ /tags/ipp-20130307/ippTools/share/chiptool_change_exp_state.sql	(revision 35788)
@@ -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: /tags/ipp-20130307/ippTools/share/chiptool_completely_processed_exp.sql
===================================================================
--- /tags/ipp-20130307/ippTools/share/chiptool_completely_processed_exp.sql	(revision 35787)
+++ /tags/ipp-20130307/ippTools/share/chiptool_completely_processed_exp.sql	(revision 35788)
@@ -15,4 +15,5 @@
     end_stage,
     imfile_magicked as magicked,
+    0 as update_mode,
     note
 FROM
Index: /tags/ipp-20130307/ippTools/share/pxadmin_create_tables.sql
===================================================================
--- /tags/ipp-20130307/ippTools/share/pxadmin_create_tables.sql	(revision 35787)
+++ /tags/ipp-20130307/ippTools/share/pxadmin_create_tables.sql	(revision 35788)
@@ -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: /tags/ipp-20130307/ippTools/share/pxadmin_drop_tables.sql
===================================================================
--- /tags/ipp-20130307/ippTools/share/pxadmin_drop_tables.sql	(revision 35787)
+++ /tags/ipp-20130307/ippTools/share/pxadmin_drop_tables.sql	(revision 35788)
@@ -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: /tags/ipp-20130307/ippTools/src/chiptool.c
===================================================================
--- /tags/ipp-20130307/ippTools/src/chiptool.c	(revision 35787)
+++ /tags/ipp-20130307/ippTools/src/chiptool.c	(revision 35788)
@@ -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");
@@ -2028,4 +2029,7 @@
     if (label) {
         psStringAppend(&setHook, "\n , chipRun.label = '%s'", label);
+    }
+    if (update_mode) {
+        psStringAppend(&setHook, "\n, chipRun.update_mode = %d", update_mode);
     }
 
Index: /tags/ipp-20130307/ippTools/src/chiptoolConfig.c
===================================================================
--- /tags/ipp-20130307/ippTools/src/chiptoolConfig.c	(revision 35787)
+++ /tags/ipp-20130307/ippTools/src/chiptoolConfig.c	(revision 35788)
@@ -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: /tags/ipp-20130307/ippTools/src/pxchip.c
===================================================================
--- /tags/ipp-20130307/ippTools/src/pxchip.c	(revision 35787)
+++ /tags/ipp-20130307/ippTools/src/pxchip.c	(revision 35788)
@@ -283,4 +283,5 @@
 		       NAN,
 		       NAN,
+            0,         // update_mode
             note
             )