Changeset 24376

Timestamp:

Jun 10, 2009, 4:54:52 PM (17 years ago)

Author:

Paul Price

Message:

Adding new tables.

File:

• branches/pap_mops/dbconfig/changes.txt (modified) (1 diff)

branches/pap_mops/dbconfig/changes.txt

@@ -1126 +1126 @@
 
 -- Version 1.1.53
+
+-- Tables to support publishing of detections to a Science Client
+-- Clients to which we send stuff
+CREATE TABLE publishClient (
+    client_id BIGINT AUTO_INCREMENT, -- unique identifier
+    comment VARCHAR(255),            -- for human memory
+    stage VARCHAR(64),               -- stage of interest (chip, camera, diff, etc.)
+    format VARCHAR(64),              -- format of data
+    destination VARCHAR(255),        -- where to send data
+    PRIMARY KEY(client_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+-- Publishing a set of data (e.g., a specific diffRun)
+CREATE TABLE publishRun (
+    pub_id BIGINT AUTO_INCREMENT, -- unique identifier
+    client_id BIGINT,             -- link to publishClient
+    stage_id BIGINT,              -- link to various stage tables
+    PRIMARY KEY(pub_id),
+    KEY(client_id),
+    KEY(stage_id),
+    FOREIGN KEY(client_id) REFERENCES publishClient(client_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+-- Publishing a file within a set
+CREATE TABLE publishFile (
+    pub_id BIGINT AUTO_INCREMENT, -- link to publishRun
+    component VARCHAR(64),        -- analagous to class_id or skycell_id
+    fault SMALLINT NOT NULL DEFAULT 0, -- Fault code
+    PRIMARY KEY(pub_id, component),
+    KEY(component),
+    KEY(fault),
+    FOREIGN KEY(pub_id) REFERENCES publishRun(pub_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;