Changeset 21310 for trunk/dbconfig/changes.txt

Timestamp:

Feb 5, 2009, 9:37:44 AM (17 years ago)

Author:

bills

Message:

image id rework

File:

• trunk/dbconfig/changes.txt (modified) (1 diff)

trunk/dbconfig/changes.txt

@@ -795 +795 @@
 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;
+
+