Index: trunk/ippTools/share/pxadmin_create_tables.sql
===================================================================
--- trunk/ippTools/share/pxadmin_create_tables.sql	(revision 20973)
+++ trunk/ippTools/share/pxadmin_create_tables.sql	(revision 21308)
@@ -275,4 +275,13 @@
 ENGINE=innodb DEFAULT CHARSET=latin1;
 
+CREATE TABLE chipImfile (
+    chip_id BIGINT,
+    class_id VARCHAR(64),
+    chip_imfile_id BIGINT AUTO_INCREMENT,
+    PRIMARY KEY(chip_id, class_id),
+    KEY(chip_imfile_id),
+    FOREIGN KEY (chip_id) REFERENCES  chipRun(chip_id))
+ENGINE=innodb DEFAULT CHARSET=latin1;
+
 CREATE TABLE chipProcessedImfile (
     chip_id BIGINT,
@@ -333,10 +342,8 @@
     path_base VARCHAR(255),
     fault SMALLINT NOT NULL,
-    chip_image_id BIGINT AUTO_INCREMENT,
     magicked BIGINT,
     PRIMARY KEY(chip_id, exp_id, class_id),
     KEY(data_state),
     KEY(fault),
-    KEY(chip_image_id),
     FOREIGN KEY (chip_id, exp_id)
         REFERENCES  chipRun(chip_id, exp_id),
@@ -846,4 +853,14 @@
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
 
+CREATE TABLE warpImfile (
+    warp_id BIGINT,
+    skycell_id VARCHAR(64),
+    warp_skyfile_id BIGINT AUTO_INCREMENT,
+    PRIMARY KEY(warp_id, skycell_id),
+    KEY(warp_skyfile_id),
+    FOREIGN KEY (warp_id) REFERENCES  warpRun(warp_id))
+ENGINE=innodb DEFAULT CHARSET=latin1;
+
+
 CREATE TABLE warpSkyfile (
     warp_id BIGINT,
@@ -865,10 +882,8 @@
     ignored TINYINT,
     fault SMALLINT,
-    warp_image_id BIGINT AUTO_INCREMENT,
     magicked TINYINT,
     PRIMARY KEY(warp_id, skycell_id, tess_id),
     KEY(good_frac),
     KEY(ignored), KEY(fault),
-    KEY(warp_image_id),
     FOREIGN KEY (warp_id, skycell_id, tess_id)
         REFERENCES warpSkyCellMap(warp_id, skycell_id, tess_id)
@@ -965,5 +980,7 @@
         stack2 BIGINT,
         tess_id VARCHAR(64),
-        PRIMARY KEY(diff_id, skycell_id),
+        diff_skyfile_id BIGINT AUTO_INCREMENT,
+        KEY(diff_id, skycell_id),
+        KEY(diff_skyfile_id),
         KEY(warp1),
         KEY(warp2),
@@ -1004,10 +1021,8 @@
         good_frac FLOAT,
         fault SMALLINT,
-        diff_image_id BIGINT AUTO_INCREMENT,
         magicked TINYINT,
         PRIMARY KEY(diff_id, skycell_id),
         KEY(good_frac),
         KEY(fault),
-        KEY(diff_image_id),
         FOREIGN KEY (diff_id)  REFERENCES  diffRun(diff_id)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;