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

Timestamp:

Nov 9, 2008, 1:51:39 PM (18 years ago)

Author:

Paul Price

Message:

Change to run a subset of a camera seems to work, based on a simtest and a manual run through with one of two rawImfiles with ignored = 1. Merging pap_branch_20081109; no conflicts.

File:

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

trunk/ippTools/share/pxadmin_create_tables.sql

@@ -234 +234 @@
     moon_alt FLOAT,
     moon_phase FLOAT,
+    ignored TINYINT DEFAULT 0,
     hostname VARCHAR(64),
     fault SMALLINT NOT NULL,
@@ -1081 +1082 @@
         det_type VARCHAR(64),
         dvodb VARCHAR(64),
-        camera VARCHAR(64),
-        telescope VARCHAR(64),
-        epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
+        camera VARCHAR(64),
+        telescope VARCHAR(64),
+        epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
         filter VARCHAR(64),
         state VARCHAR(64),
@@ -1100 +1101 @@
         corr_id BIGINT,
         chip_id BIGINT,
-        include TINYINT,
+        include TINYINT,
         PRIMARY KEY(corr_id, chip_id),
         FOREIGN KEY (corr_id)  REFERENCES  flatcorrRun(corr_id),
@@ -1110 +1111 @@
         chip_id BIGINT,
         cam_id BIGINT,
-        include TINYINT,
+        include TINYINT,
         PRIMARY KEY(corr_id, cam_id),
         FOREIGN KEY (corr_id)  REFERENCES  flatcorrRun(corr_id),