Changeset 36417 for branches/bills_branches/bills_201312/dbconfig/changes.txt

Timestamp:

Jan 3, 2014, 1:54:29 PM (13 years ago)

Author:

bills

Message:

add code for managing summarizing fullForceRuns and managing the
associated table

File:

• branches/bills_branches/bills_201312/dbconfig/changes.txt (modified) (3 diffs)

branches/bills_branches/bills_201312/dbconfig/changes.txt

@@ -2436 +2436 @@
 CREATE TABLE fullForceRun (
     ff_id           BIGINT NOT NULL AUTO_INCREMENT,
-    warp_id         BIGINT,
     skycal_id       BIGINT,
     sources_path_base VARCHAR(255),
@@ -2451 +2450 @@
     KEY(label),
     KEY(data_group),
-    KEY(warp_id),
     KEY(skycal_id),
-    FOREIGN KEY(warp_id) REFERENCES warpRun(warp_id),
     FOREIGN KEY(skycal_id) REFERENCES skycalRun(skycal_id)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
 
+CREATE TABLE fullForceInput (
+    ff_id           BIGINT,
+    warp_id         BIGINT,
+    PRIMARY KEY(ff_id, warp_id),
+    FOREIGN KEY(ff_id) REFERENCES fullForceRun(ff_id),
+    FOREIGN KEY(warp_id) REFERENCES warpRun(warp_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
 CREATE TABLE fullForceResult (
+    ff_id           BIGINT,
+    warp_id         BIGINT,
+    path_base       VARCHAR(255) NOT NULL,
+    dtime_script    FLOAT,
+    quality         SMALLINT NOT NULL,
+    hostname        VARCHAR(64) NOT NULL,
+    software_ver    VARCHAR(16),
+    fault           SMALLINT NOT NULL,
+    PRIMARY KEY(ff_id, warp_id),
+    KEY(fault),
+    KEY(quality),
+    FOREIGN KEY(ff_id) REFERENCES fullForceRun(ff_id),
+    FOREIGN KEY(warp_id) REFERENCES warpRun(warp_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
+CREATE TABLE fullForceSummary (
     ff_id           BIGINT,
     path_base       VARCHAR(255) NOT NULL,
@@ -2463 +2484 @@
     quality         SMALLINT NOT NULL,
     hostname        VARCHAR(64) NOT NULL,
-    software_ver    VARCHAR(64),
+    software_ver    VARCHAR(16),
     fault           SMALLINT NOT NULL,
     PRIMARY KEY(ff_id),