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

Timestamp:

Oct 8, 2009, 5:09:53 PM (17 years ago)

Author:

eugene

Message:

updates to the addstar stage; modify flatcorr to interact correctly with the addstar stage

File:

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

trunk/ippTools/share/pxadmin_create_tables.sql

@@ -464 +464 @@
     workdir VARCHAR(255),
     workdir_state VARCHAR(64),
+    reduction VARCHAR(64),
     label VARCHAR(64),
     dvodb VARCHAR(255),
-    magicked BIGINT,
+    image_only TINYINT,
     PRIMARY KEY(add_id),
     KEY(add_id),
@@ -480 +481 @@
     add_id BIGINT AUTO_INCREMENT,
     dtime_addstar FLOAT,
-    n_stars INT,
     path_base VARCHAR(255),
     fault SMALLINT NOT NULL,
@@ -1182 +1182 @@
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
 
--- these two tables link the flatcorrRun to the associated chip and camera runs
+-- these three tables link the flatcorrRun to the associated chip, camera, and addstar runs
 CREATE TABLE flatcorrChipLink (
         corr_id BIGINT,
@@ -1201 +1201 @@
         FOREIGN KEY(chip_id) REFERENCES chipRun(chip_id),
         FOREIGN KEY(cam_id) REFERENCES camRun(cam_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
+CREATE TABLE flatcorrAddstarLink (
+        corr_id BIGINT,
+        cam_id BIGINT,
+        add_id BIGINT,
+        include TINYINT,
+        PRIMARY KEY(corr_id, cam_id, add_id),
+        FOREIGN KEY (corr_id)  REFERENCES  flatcorrRun(corr_id),
+        FOREIGN KEY (cam_id)  REFERENCES  camRun(cam_id),
+        FOREIGN KEY (add_id)  REFERENCES  addRun(add_id)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;