Changeset 24427 for branches/pap_mops/ippTools/share/pxadmin_create_tables.sql

Timestamp:

Jun 15, 2009, 5:28:09 PM (17 years ago)

Author:

Paul Price

Message:

Adding script to do the actual publishing to DataStore. Decided to bundle all components into the same script (we're working with detections, it's serial, should be fast) to simply things (can remove the 'advance' mode for pubtool). Everything compiles, not tested yet.

File:

• branches/pap_mops/ippTools/share/pxadmin_create_tables.sql (modified) (3 diffs)

branches/pap_mops/ippTools/share/pxadmin_create_tables.sql

@@ -1374 +1374 @@
 CREATE TABLE publishClient (
     client_id BIGINT AUTO_INCREMENT, -- unique identifier
+    product VARCHAR(64),             -- product name
+    stage VARCHAR(64) NOT NULL, -- stage of interest (chip, camera, diff, etc.)
     comment VARCHAR(255),            -- for human memory
-    stage VARCHAR(64) NOT NULL, -- stage of interest (chip, camera, diff, etc.)
-    format VARCHAR(64),              -- format of data
-    destination VARCHAR(255) NOT NULL, -- where to send data
     PRIMARY KEY(client_id)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
@@ -1386 +1385 @@
     client_id BIGINT NOT NULL,  -- link to publishClient
     stage_id BIGINT NOT NULL,   -- link to various stage tables
+    workdir VARCHAR(255) NOT NULL, -- working directory
     label VARCHAR(64),          -- label for run
     state VARCHAR(64),          -- state of run (new, full, etc.)
@@ -1397 +1397 @@
 
 -- Publishing a file within a set
-CREATE TABLE publishFile (
+CREATE TABLE publishDone (
     pub_id BIGINT AUTO_INCREMENT, -- link to publishRun
-    component VARCHAR(64),        -- analagous to class_id or skycell_id
+    path_base VARCHAR(255),     -- base path of output
     fault SMALLINT NOT NULL DEFAULT 0, -- Fault code
-    PRIMARY KEY(pub_id, component),
-    KEY(component),
+    PRIMARY KEY(pub_id),
     KEY(fault),
     FOREIGN KEY(pub_id) REFERENCES publishRun(pub_id)