Changeset 27838 for branches/tap_branches/ippTools/share/pxadmin_create_tables.sql

Timestamp:

May 3, 2010, 8:41:49 AM (16 years ago)

Author:

eugene

Message:

updates from trunk

Location:

branches/tap_branches

Files:

• . (modified) (1 prop)
• ippTools/share/pxadmin_create_tables.sql (modified) (14 diffs)

branches/tap_branches/ippTools/share/pxadmin_create_tables.sql

@@ -117 +117 @@
     filelevel VARCHAR(64),
     workdir VARCHAR(255),
+    state VARCHAR(64),
     reduction VARCHAR(64),
     dvodb VARCHAR(255),
@@ -189 +190 @@
     class_id VARCHAR(64),
     uri VARCHAR(255),
+    data_state VARCHAR(64),
     exp_type VARCHAR(64),
     filelevel VARCHAR(64),
@@ -1015 +1017 @@
         exposure TINYINT DEFAULT 0,
         magicked BIGINT,
+        diff_mode SMALLINT NOT NULL,
         note VARCHAR(255),
         PRIMARY KEY(diff_id),
@@ -1172 +1175 @@
         KEY(label),
         KEY(fault),
+        KEY(stage),
+        KEY(stage_id),
         FOREIGN KEY(magic_id) REFERENCES magicRun(magic_id),
         FOREIGN KEY(inv_magic_id) REFERENCES magicRun(magic_id)
@@ -1181 +1186 @@
     backup_path_base VARCHAR(255),
     recovery_path_base VARCHAR(255),
+    streak_frac FLOAT,
+    nondiff_frac FLOAT,
+    run_time FLOAT,
     fault SMALLINT,
     data_state VARCHAR(64),
@@ -1217 +1225 @@
         filter VARCHAR(64),
         state VARCHAR(64),
+        make_corr TINYINT,
         workdir VARCHAR(255),
         label VARCHAR(64),
@@ -1263 +1272 @@
         state VARCHAR(64),
         lastFileset VARCHAR(64),
+        timestamp  DATETIME,
+        label VARCHAR(64),
         outProduct VARCHAR(64) UNIQUE,
         uri VARCHAR(255),
+        pollInterval INTEGER DEFAULT 60,
         PRIMARY KEY(ds_id),
         KEY(ds_id)
@@ -1317 +1329 @@
         stage      VARCHAR(64),
         stage_id   BIGINT,
+        component  VARCHAR(64),
         imagedb    VARCHAR(64),
         rlabel     VARCHAR(64),
-        no_magic   TINYINT,
-        PRIMARY KEY(dep_id)
+        need_magic TINYINT,
+        PRIMARY KEY(dep_id),
+        KEY(state),
+        KEY(stage),
+        KEY(stage_id)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
 
@@ -1332 +1348 @@
     comment     VARCHAR(255),
     PRIMARY KEY(target_id),
+    KEY(stage),
+    KEY(dist_group),
+    KEY(filter),
+    KEY(state),
     CONSTRAINT UNIQUE (dist_group, filter, stage, clean)
 )  ENGINE=innodb DEFAULT CHARSET=latin1;
@@ -1343 +1363 @@
     label       VARCHAR(64),
     outroot     VARCHAR(255),
+    outdir      VARCHAR(255),
     clean       TINYINT,
     no_magic    TINYINT,
+    alternate   TINYINT,
     state       VARCHAR(64),
     time_stamp  TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
     fault       SMALLINT,
+    data_group  VARCHAR(64),
     note        VARCHAR(255),
     PRIMARY KEY(dist_id),
     KEY(state),
     KEY(label),
+    KEY(stage),
+    KEY(stage_id),
+    KEY(magic_ds_id),
+    KEY(fault),
+    KEY(data_group),
     FOREIGN KEY(target_id) REFERENCES distTarget(target_id)
 )  ENGINE=innodb DEFAULT CHARSET=latin1;
@@ -1361 +1389 @@
     md5sum      VARCHAR(32),
     state       VARCHAR(64),
+    outdir      VARCHAR(255),
     name        VARCHAR(255),
     fault       SMALLINT,
@@ -1425 +1454 @@
     product VARCHAR(64) NOT NULL, -- product of interest
     workdir VARCHAR(255) NOT NULL, -- where to extract
+    state VARCHAR(64) NOT NULL, -- state 'enabled' or 'disabled'
     comment VARCHAR(255),       -- for human memory
     fileset_last VARCHAR(128),  -- last fileset seen
@@ -1484 +1514 @@
 CREATE TABLE publishClient (
     client_id BIGINT AUTO_INCREMENT, -- unique identifier
+    active TINYINT DEFAULT 0,        -- whether we should worry about this or not
     product VARCHAR(64),             -- product name
     stage VARCHAR(64) NOT NULL, -- stage of interest (chip, camera, diff, etc.)
+    magicked TINYINT DEFAULT 1, -- Require magicked data?
     workdir VARCHAR(255) NOT NULL, -- working directory
     comment VARCHAR(255),            -- for human memory
@@ -1519 +1551 @@
 
 
+-- Tables for static sky analysis
+
+-- A static sky analysis set
+CREATE TABLE staticskyRun (
+      ss_id BIGINT AUTO_INCREMENT, -- unique identifier
+      state VARCHAR(64) NOT NULL,  -- state of run (new, full, etc.)
+      workdir VARCHAR(255) NOT NULL, -- working directory
+      label VARCHAR(64),             -- processing label
+      data_group VARCHAR(64),        -- group for data
+      dist_group VARCHAR(64),        -- group for distribution
+      reduction VARCHAR(64),         -- reduction class (for altering recipe)
+      note VARCHAR(255),             -- note
+      registered TIMESTAMP DEFAULT CURRENT_TIMESTAMP, -- time run was registered
+      PRIMARY KEY(ss_id),
+      KEY(state),
+      KEY(label),
+      KEY(data_group),
+      KEY(dist_group)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
+-- Inputs for static sky analysis
+CREATE TABLE staticskyInput (
+      ss_id BIGINT,             -- static sky identifier
+      stack_id BIGINT,          -- stack identifier
+      PRIMARY KEY(ss_id,stack_id),
+      KEY(stack_id),
+      FOREIGN KEY(ss_id) REFERENCES staticskyRun(ss_id),
+      FOREIGN KEY(stack_id) REFERENCES stackSumSkyfile(stack_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
+-- Result of static sky analysis
+CREATE TABLE staticskyResult (
+      ss_id BIGINT,             -- static sky identifier
+      path_base VARCHAR(255) NOT NULL, -- root name for outputs
+      dtime_phot FLOAT,                -- elapsed time for photometry
+      dtime_script FLOAT,              -- elapsed time for script
+      sources INT,                     -- number of sources
+      hostname VARCHAR(64) NOT NULL,   -- host that executed script
+      good_frac FLOAT,                 -- good fraction of skycell
+      quality SMALLINT NOT NULL,       -- bad quality flag
+      fault SMALLINT NOT NULL,         -- fault code
+      PRIMARY KEY(ss_id),
+      KEY(good_frac),
+      KEY(fault),
+      KEY(quality),
+      FOREIGN KEY(ss_id) REFERENCES staticskyRun(ss_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
 -- This comment line is here to avoid empty query error.
 -- Another way to avoid that problem is to omit the semicolon above but I think that is untidy.