Index: trunk/ippTools/share/pxadmin_create_tables.sql
===================================================================
--- trunk/ippTools/share/pxadmin_create_tables.sql	(revision 19334)
+++ trunk/ippTools/share/pxadmin_create_tables.sql	(revision 19372)
@@ -769,4 +769,5 @@
     uri VARCHAR(255),
     path_base VARCHAR(255),
+    data_state VARCHAR(64),
     bg DOUBLE,
     bg_stdev DOUBLE,
@@ -796,4 +797,6 @@
         state VARCHAR(64),
         workdir VARCHAR(255),
+        label VARCHAR(64),
+        reduction VARCHAR(64),
         dvodb VARCHAR(255),
         registered DATETIME,
@@ -820,4 +823,5 @@
         uri VARCHAR(255),
         path_base VARCHAR(255),
+	data_state VARCHAR(64),
         bg DOUBLE,
         bg_stdev DOUBLE,
@@ -837,4 +841,6 @@
         state VARCHAR(64),
         workdir VARCHAR(255),
+        label VARCHAR(64),
+        reduction VARCHAR(64),
         dvodb VARCHAR(255),
         registered DATETIME,
@@ -871,4 +877,5 @@
         uri VARCHAR(255),
         path_base VARCHAR(255),
+	data_state VARCHAR(64),
         bg DOUBLE,
         bg_stdev DOUBLE,
@@ -972,18 +979,11 @@
         workdir VARCHAR(255),
         label VARCHAR(64),
-        stats VARCHAR(255),
-        region VARCHAR(255),
+        reduction VARCHAR(64),
+        region VARCHAR(64),
+        hostname VARCHAR(64),
+        fault SMALLINT NOT NULL,
         PRIMARY KEY(corr_id),
         KEY(corr_id)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
-
--- XXX deprecate this table
--- CREATE TABLE flatcorrExp (
---         corr_id BIGINT,
---         chip_id BIGINT,
---         PRIMARY KEY(corr_id, chip_id),
---         FOREIGN KEY (corr_id)  REFERENCES  flatcorrRun(corr_id),
---         FOREIGN KEY (chip_id)  REFERENCES  chipRun(chip_id)
--- ) ENGINE=innodb DEFAULT CHARSET=latin1;
 
 -- these two tables link the flatcorrRun to the associated chip and camera runs
@@ -998,7 +998,9 @@
 CREATE TABLE flatcorrCamLink (
         corr_id BIGINT,
+        chip_id BIGINT,
         cam_id BIGINT,
         PRIMARY KEY(corr_id, cam_id),
         FOREIGN KEY (corr_id)  REFERENCES  flatcorrRun(corr_id),
+        FOREIGN KEY (chip_id)  REFERENCES  chipRun(chip_id)
         FOREIGN KEY (cam_id)  REFERENCES  camRun(cam_id)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;