Changeset 23953

Timestamp:

Apr 23, 2009, 9:47:13 AM (17 years ago)

Author:

Paul Price

Message:

Adding key for dateobs to make it easier to get ccd_temp for XY24.

Location:

trunk

Files:

• dbconfig/changes.txt (modified) (1 diff)
• ippTools/share/pxadmin_create_tables.sql (modified) (1 diff)

trunk/dbconfig/changes.txt

@@ -1085 +1085 @@
 
 ALTER TABLE diffSkyfile ADD COLUMN deconv_max FLOAT AFTER kernel_yy;
+
+-- This key makes it faster to find the ccd_temp for XY24
+ALTER TABLE rawImfile ADD KEY(dateobs);

trunk/ippTools/share/pxadmin_create_tables.sql

@@ -242 +242 @@
     KEY(raw_image_id),
     KEY(quality),
+    KEY(dateobs),
     UNIQUE KEY(exp_id, tmp_class_id),
     FOREIGN KEY(exp_id, tmp_class_id) REFERENCES newImfile(exp_id, tmp_class_id)