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

Timestamp:

Apr 16, 2009, 12:39:27 PM (17 years ago)

Author:

Paul Price

Message:

Modifying distribution client workflow (currently composed of receivetool and associated tables) since Bill points out that a fileset is composed of files, and we don't want to download them all serially.

File:

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

trunk/ippTools/share/pxadmin_create_tables.sql

@@ -1317 +1317 @@
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
 
--- Run for receiving files
-CREATE TABLE receiveRun (
-    receive_id BIGINT AUTO_INCREMENT, -- unique identifier
+-- Filesets to receive
+CREATE TABLE receiveFileset (
+    fileset_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),
+    PRIMARY KEY(fileset_id),
     KEY(source_id),
     FOREIGN KEY(source_id) REFERENCES receiveSource(source_id)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
 
+-- Files to receive
+CREATE TABLE receiveFile (
+    file_id BIGINT AUTO_INCREMENT, -- unique identifier
+    fileset_id BIGINT NOT NULL,  -- link to receiveFileset
+    file VARCHAR(128) NOT NULL, -- file to receive
+    PRIMARY KEY(file_id),
+    KEY(fileset_id),
+    FOREIGN KEY(fileset_id) REFERENCES receiveFileset(fileset_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
 -- Result of receiving files
 CREATE TABLE receiveResult (
-    receive_id BIGINT AUTO_INCREMENT, -- unique identifier, link to receiveRun
+    file_id BIGINT AUTO_INCREMENT, -- link to receiveFile
     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)
+    PRIMARY KEY(file_id),
+    KEY(fault),
+    FOREIGN KEY(file_id) REFERENCES receiveFile(file_id)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;