Changeset 20397 for trunk/ippTools/share

Timestamp:

Oct 25, 2008, 9:12:41 AM (18 years ago)

Author:

eugene

Message:

adding include fields to flatcorrChipLink and flatcorrCamLink

Location:

trunk/ippTools/share

Files:

• Makefile.am (modified) (1 diff)
• flatcorr_chiprundone.sql (modified) (1 diff)
• flatcorr_dropcamera.sql (added)
• flatcorr_dropchip.sql (added)
• flatcorr_pendingprocess.sql (modified) (2 diffs)
• pxadmin_create_tables.sql (modified) (2 diffs)

trunk/ippTools/share/Makefile.am

@@ -95 +95 @@
      flatcorr_pendingprocess.sql \
      flatcorr_inputimfile.sql \
+     flatcorr_dropchip.sql \
+     flatcorr_dropcamera.sql \
      magictool_addmask.sql \
      magictool_create_tmp_warpcomplete.sql \

trunk/ippTools/share/flatcorr_chiprundone.sql

@@ -12 +12 @@
 WHERE
     flatcorrRun.state = 'new'
+    AND flatcorrChipLink.include = 1
     AND chipRun.state = 'full'
     AND camRun.cam_id is NULL;

trunk/ippTools/share/flatcorr_pendingprocess.sql

@@ -20 +20 @@
    JOIN flatcorrChipLink
      ON flatcorrChipLink.corr_id = flatcorrRun.corr_id
+  WHERE flatcorrChipLink.include = 1
    GROUP BY
      flatcorrChipLink.corr_id) AS t1
@@ -30 +31 @@
        ON flatcorrCamLink.cam_id = camRun.cam_id
    WHERE camRun.state = 'full'
+     AND flatcorrCamLink.include = 1
    GROUP BY
        flatcorrCamLink.corr_id) AS t2

trunk/ippTools/share/pxadmin_create_tables.sql

@@ -1100 +1100 @@
         corr_id BIGINT,
         chip_id BIGINT,
+        include TINYINT,
         PRIMARY KEY(corr_id, chip_id),
         FOREIGN KEY (corr_id)  REFERENCES  flatcorrRun(corr_id),
@@ -1109 +1110 @@
         chip_id BIGINT,
         cam_id BIGINT,
+        include TINYINT,
         PRIMARY KEY(corr_id, cam_id),
         FOREIGN KEY (corr_id)  REFERENCES  flatcorrRun(corr_id),