Changeset 23881

Timestamp:

Apr 15, 2009, 5:49:37 PM (17 years ago)

Author:

Paul Price

Message:

Adding new tables.

File:

• trunk/dbconfig/changes.txt (modified) (1 diff)

trunk/dbconfig/changes.txt

@@ -1032 +1032 @@
 ALTER TABLE diffSkyfile ADD COLUMN data_state VARCHAR(64) AFTER path_base;
 UPDATE diffSkyfile SET data_state = 'full' WHERE data_state IS NULL;
+
+
+-- 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;