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

Timestamp:

Apr 15, 2009, 5:42:05 PM (17 years ago)

Author:

Paul Price

Message:

Adding receivetool, for the other end of the distribution.

File:

• trunk/ippTools/share/pxadmin_create_tables.sql (modified) (1 diff)

trunk/ippTools/share/pxadmin_create_tables.sql

@@ -1303 +1303 @@
 )  ENGINE=innodb DEFAULT CHARSET=latin1;
 
+-- Sources from which to receive files
+CREATE TABLE receiveSource (
+    source_id BIGINT AUTO_INCREMENT, -- unique identifier
+    source VARCHAR(128) NOT NULL, -- source URI
+    product VARCHAR(64) NOT NULL, -- product of interest
+    workdir VARCHAR(255),       -- where to extract (optional)
+    comment VARCHAR(255),       -- for human memory
+    fileset_last VARCHAR(128),  -- last fileset seen
+    PRIMARY KEY(source_id),
+    KEY(source),
+    KEY(product),
+    KEY(comment)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
+-- Run for receiving files
+CREATE TABLE receiveRun (
+    receive_id BIGINT AUTO_INCREMENT, -- unique identifier
+    source_id BIGINT NOT NULL,  -- link to receiveSource
+    fileset VARCHAR(128) NOT NULL, -- fileset to receive
+    PRIMARY KEY(receive_id),
+    KEY(source_id),
+    FOREIGN KEY(source_id) REFERENCES receiveSource(source_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
+-- Result of receiving files
+CREATE TABLE receiveResult (
+    receive_id BIGINT AUTO_INCREMENT, -- unique identifier, link to receiveRun
+    dtime_copy FLOAT,           -- Time to copy
+    dtime_extract FLOAT,        -- Time to extract
+    fault SMALLINT NOT NULL DEFAULT 0, -- Fault code
+    PRIMARY KEY(receive_id),
+    KEY(fault),
+    FOREIGN KEY(receive_id) REFERENCES receiveRun(receive_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;