Changeset 21434

Timestamp:

Feb 10, 2009, 11:03:02 AM (17 years ago)

Author:

bills

Message:

add sql to populate chipImfile and warpImfile tables to changes.txt

File:

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

trunk/dbconfig/changes.txt

@@ -823 +823 @@
 ENGINE=innodb DEFAULT CHARSET=latin1;
 
-
+INSERT INTO chipImfile
+   SELECT chip_id, class_id, 0
+   FROM rawImfile JOIN chipRun USING(exp_id)
+   LEFT JOIN chipImfile USING(chip_id, class_id)
+   WHERE chipImfile.class_id IS NULL;
+
+INSERT INTO warpImfile 
+    SELECT DISTINCT warp_id, skycell_id, 0 
+    FROM warpSkyCellMap LEFT JOIN warpImfile USING(warp_id, skycell_id)
+    WHERE warpImfile.skycell_id IS NULL;
+
+
+