Changes between Version 5 and Version 6 of fullforce_intro

Timestamp:

Dec 11, 2013, 12:06:11 PM (13 years ago)

Author:

bills

Comment:

--

fullforce_intro

@@ -47 +47 @@
     FOREIGN KEY(warp_id) REFERENCES warpRun(warp_id),
     FOREIGN KEY(skycal_id) REFERENCES skycalRun(skycal_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
+CREATE TABLE fullForceResult (
+    ff_id           BIGINT,
+    path_base       VARCHAR(255) NOT NULL,
+    dtime_script    FLOAT,
+    quality         SMALLINT NOT NULL,
+    hostname        VARCHAR(64) NOT NULL,
+    software_ver    VARCHAR(64),
+    fault           SMALLINT NOT NULL,
+    PRIMARY KEY(ff_id),
+    KEY(fault),
+    KEY(quality),
+    FOREIGN KEY(ff_id) REFERENCES fullForceRun(ff_id)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;