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

Timestamp:

Jun 2, 2008, 11:41:59 AM (18 years ago)

Author:

jhoblitt

Message:

add faketables

File:

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

trunk/ippTools/share/pxadmin_create_tables.sql

@@ -367 +367 @@
 ENGINE=innodb DEFAULT CHARSET=latin1;
 
+CREATE TABLE fakeRun (
+    fake_id BIGINT AUTO_INCREMENT, 
+    cam_id BIGINT, 
+    state VARCHAR(64), 
+    workdir VARCHAR(255), 
+    label VARCHAR(64), 
+    reduction VARCHAR(64), 
+    expgroup VARCHAR(64), 
+    dvodb VARCHAR(255), 
+    tess_id VARCHAR(64), 
+    end_stage VARCHAR(64), 
+    epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
+    PRIMARY KEY(fake_id), 
+    KEY(cam_id), 
+    KEY(state), 
+    KEY(label), 
+    KEY(expgroup), 
+    KEY(end_stage), 
+    INDEX(fake_id, cam_id), 
+    FOREIGN KEY (cam_id)  
+        REFERENCES camRun(cam_id)) 
+ENGINE=innodb DEFAULT CHARSET=latin1;
+
+CREATE TABLE fakeProcessedImfile (
+    fake_id BIGINT AUTO_INCREMENT, 
+    exp_id BIGINT, 
+    class_id VARCHAR(64), 
+    uri VARCHAR(255), 
+    dtime_fake FLOAT, 
+    hostname VARCHAR(64),
+    path_base VARCHAR(255), 
+    fault SMALLINT NOT NULL, 
+    epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
+    PRIMARY KEY(fake_id, exp_id, class_id), 
+    KEY(fault),
+    FOREIGN KEY (fake_id)  
+        REFERENCES fakeRun(fake_id)),
+    FOREIGN KEY (exp_id, class_id)  
+        REFERENCES rawExp(exp_id, class_id)) 
+ENGINE=innodb DEFAULT CHARSET=latin1;
+
+CREATE TABLE fakeMask (
+    label VARCHAR(64), 
+    PRIMARY KEY(label)) 
+ENGINE=innodb DEFAULT CHARSET=latin1;
+
 CREATE TABLE detRun (
     det_id BIGINT AUTO_INCREMENT,