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

Timestamp:

Feb 5, 2009, 9:35:41 AM (17 years ago)

Author:

bills

Message:

Changed the way image ids are handled. For chip and warp new tables are
added the sole purpose of which are to create the image ids before
the images are created. For diff the id is added to diffInputSkyfile

File:

• trunk/ippTools/share/pxadmin_create_tables.sql (modified) (6 diffs)

trunk/ippTools/share/pxadmin_create_tables.sql

@@ -275 +275 @@
 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 +342 @@
     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 +853 @@
 ) 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 +882 @@
     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 +980 @@
         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 +1021 @@
         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;