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

Timestamp:

Jun 10, 2009, 4:53:44 PM (17 years ago)

Author:

Paul Price

Message:

Fixing up publish tables.

File:

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

branches/pap_mops/ippTools/share/pxadmin_create_tables.sql

@@ -1381 +1381 @@
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
 
--- Publishing a set
+-- Publishing a set of data (e.g., a specific diffRun)
 CREATE TABLE publishRun (
     pub_id BIGINT AUTO_INCREMENT, -- unique identifier
@@ -1392 +1392 @@
 ) 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),        --
-
-
-
-publishClient   METADATA
-    client_id   S64         0       # Primary Key AUTO_INCREMENT
-    comment     STR         255
-    stage       STR         64
-    format      STR         64
-    destination STR         255
-END
-
-publishRun      METADATA
-    pub_id      S64         0       # Primary Key AUTO_INCREMENT
-    client_id   S64         0
-    stage_id    S64         0
-    state       STR         64
-END
-
-publishFile     METADATA
-    pub_id      S64         0       # Primary Key
-    component   STR         64      # Primary Key
-    fault       S16         0
-END
-
-
+    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;