Changeset 19372 for trunk/ippTools/share/pxadmin_create_tables.sql

Timestamp:

Sep 4, 2008, 2:24:22 PM (18 years ago)

Author:

eugene

Message:

adding label, reduction, data_state to diff, stack, warp tables, mods to the flatcorr tables

File:

• trunk/ippTools/share/pxadmin_create_tables.sql (modified) (7 diffs)

trunk/ippTools/share/pxadmin_create_tables.sql

@@ -769 +769 @@
     uri VARCHAR(255),
     path_base VARCHAR(255),
+    data_state VARCHAR(64),
     bg DOUBLE,
     bg_stdev DOUBLE,
@@ -796 +797 @@
         state VARCHAR(64),
         workdir VARCHAR(255),
+        label VARCHAR(64),
+        reduction VARCHAR(64),
         dvodb VARCHAR(255),
         registered DATETIME,
@@ -820 +823 @@
         uri VARCHAR(255),
         path_base VARCHAR(255),
+        data_state VARCHAR(64),
         bg DOUBLE,
         bg_stdev DOUBLE,
@@ -837 +841 @@
         state VARCHAR(64),
         workdir VARCHAR(255),
+        label VARCHAR(64),
+        reduction VARCHAR(64),
         dvodb VARCHAR(255),
         registered DATETIME,
@@ -871 +877 @@
         uri VARCHAR(255),
         path_base VARCHAR(255),
+        data_state VARCHAR(64),
         bg DOUBLE,
         bg_stdev DOUBLE,
@@ -972 +979 @@
         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 +998 @@
 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;