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