Changeset 35789 for trunk/ippTools/share

Timestamp:

Jul 10, 2013, 12:08:57 PM (13 years ago)

Author:

bills

Message:

add chipRun.update_mode. If set do not use the config dump
file when regenerating images using update

Location:

trunk/ippTools/share

Files:

• chiptool_change_exp_state.sql (modified) (1 diff)
• chiptool_completely_processed_exp.sql (modified) (1 diff)
• pxadmin_create_tables.sql (modified) (2 diffs)
• pxadmin_drop_tables.sql (modified) (1 diff)

trunk/ippTools/share/chiptool_change_exp_state.sql

@@ -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

trunk/ippTools/share/chiptool_completely_processed_exp.sql

@@ -15 +15 @@
     end_stage,
     imfile_magicked as magicked,
+    0 as update_mode,
     note
 FROM

trunk/ippTools/share/pxadmin_create_tables.sql

@@ -1 @@
-eREATE TABLE dbversion (
+CREATE TABLE dbversion (
     schema_version VARCHAR(64),
     updated TIMESTAMP DEFAULT CURRENT_TIMESTAMP
@@ -299 +299 @@
     maskfrac_magic FLOAT,
     maskfrac_advisory FLOAT,
+    update_mode SMALLINT DEFAULT 0,
     note VARCHAR(255),
     PRIMARY KEY(chip_id),

trunk/ippTools/share/pxadmin_drop_tables.sql

@@ -115 +115 @@
 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