Index: trunk/dbconfig/changes.txt
===================================================================
--- trunk/dbconfig/changes.txt	(revision 21008)
+++ trunk/dbconfig/changes.txt	(revision 21310)
@@ -795,2 +795,31 @@
 ALTER TABLE magicInputSkyfile DROP PRIMARY KEY, ADD PRIMARY KEY(magic_id, diff_id, node);
 
+
+
+-- Version: 1.1.48
+
+ALTER TABLE chipProcessedImfile DROP COLUMN chip_image_id;
+ALTER TABLE diffSkyfile DROP COLUMN diff_image_id;
+ALTER TABLE warpSkyfile DROP COLUMN warp_image_id;
+
+ALTER TABLE diffInputSkyfile ADD COLUMN diff_skyfile_id BIGINT AUTO_INCREMENT, ADD KEY(diff_id, skycell_id), ADD KEY(diff_skyfile_id);
+
+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 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;
+
+
