Changeset 17951 for branches/faketool/ippTools/share/pxadmin_create_tables.sql

Timestamp:

Jun 5, 2008, 2:19:30 PM (18 years ago)

Author:

jhoblitt

Message:

fake* SQL updates

File:

• branches/faketool/ippTools/share/pxadmin_create_tables.sql (modified) (3 diffs)

branches/faketool/ippTools/share/pxadmin_create_tables.sql

@@ -328 +328 @@
 CREATE TABLE camProcessedExp (
     cam_id BIGINT,
-    chip_id BIGINT, 
     uri VARCHAR(255), 
     bg FLOAT, 
@@ -356 +355 @@
     path_base VARCHAR(255), 
     fault SMALLINT NOT NULL, 
-    PRIMARY KEY(cam_id, chip_id), 
-    KEY(fault), 
-    FOREIGN KEY (cam_id, chip_id)  
-    REFERENCES camRun(cam_id, chip_id)) 
+    PRIMARY KEY(cam_id), 
+    KEY(fault), 
+    FOREIGN KEY (cam_id)  
+        REFERENCES camRun(cam_id)) 
 ENGINE=innodb DEFAULT CHARSET=latin1;
 
@@ -677 +676 @@
     skycell_id VARCHAR(64),
     tess_id VARCHAR(64),
-    fake_id BIGINT,
     class_id VARCHAR(64),
     fault SMALLINT,
-    PRIMARY KEY(warp_id, skycell_id, tess_id, fake_id, class_id),
+    PRIMARY KEY(warp_id, skycell_id, tess_id, class_id),
     KEY(fault),
-    FOREIGN KEY (warp_id, fake_id)
-        REFERENCES  warpRun(warp_id, fake_id)
+    FOREIGN KEY (warp_id)
+        REFERENCES warpRun(warp_id)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;