Changeset 16353

Timestamp:

Feb 7, 2008, 11:20:44 AM (18 years ago)

Author:

bills

Message:

Reviewed the database changes since 2007/12/15 and corrected and augmented
the sql commands needed to update a database to this schema.

File:

• trunk/dbconfig/changes.txt (modified) (2 diffs)

trunk/dbconfig/changes.txt

@@ -29 +29 @@
 alter table warpSkyfile add column ignored tinyint after good_frac;
 
+#
+# The following set of changes were applied to update the gpc1 database on 2008/02/07
+#
+
 alter table calDB change column catdir dvodb varchar(64);
 
-alter table camProcessedExp add column ( bias double, bias_stdev double, fringe_0 double, fringe_1 double, fringe_2 double, ap_resid double, ap_resid_stdev double, fwhm_major double, fwhm_minor double, dtime_detrend double, dtime_photom double, dtime_astrom double, hostname varchar(64) );
-alter table camProcessedExp drop column fwhm;
-alter table camProcessedExp drop column fwhm_range;
+alter table camProcessedExp change column fwhm fwhm_major float;
+alter table camProcessedExp change column fwhm_range fwhm_minor float;
 
-alter table chipProcessedImfile add column ( zp_mean double, zp_stdev double, fwhm_major double, fwhm_minor double, dtime_detrend double, dtime_photom double, dtime_astrom double, hostname varchar(64) );
-alter table chipProcessedImfile drop column fwhm;
-alter table chipProcessedImfile drop column fwhm_range;
+# In order to keep the column order correct this is split up below
+#alter table camProcessedExp add column ( bias float, bias_stdev float, fringe_0 float, fringe_1 float, fringe_2 float, ap_resid float, ap_resid_stdev float, dtime_detrend float, dtime_photom float, dtime_astrom float, hostname varchar(64) );
 
-alter table diffSkyfile add column ( dtime_diff double, hostname varchar(64) );
+alter table camProcessedExp add column bias float after bg_mean_stdev;
+alter table camProcessedExp add column bias_stdev float after bias;
+alter table camProcessedExp add column fringe_0 float after bias_stdev;
+alter table camProcessedExp add column fringe_1 float after fringe_0;
+alter table camProcessedExp add column fringe_2 float after fringe_1;
+alter table camProcessedExp add column ap_resid float after sigma_dec;
+alter table camProcessedExp add column ap_resid_stdev float after ap_resid;
+alter table camProcessedExp add column dtime_detrend float after fwhm_minor;
+alter table camProcessedExp add column dtime_photom float after dtime_detrend;
+alter table camProcessedExp add column dtime_astrom float after dtime_photom;
+alter table camProcessedExp add column hostname varchar(64) after dtime_astrom;
 
-alter table flatcorrRun add column filter varchar(64);
 
-alter table stackSumSkyfile add column ( dtime_stack double, hostname varchar(64) );
+alter table chipProcessedImfile change column fwhm fwhm_major float;
+alter table chipProcessedImfile change column fwhm_range fwhm_minor float;
 
-alter table warpSkyfile add column ( dtime_warp double, hostname varchar(64) );
+# In order to keep the column order correct this is split up below
+#alter table chipProcessedImfile add column ( zp_mean float, zp_stdev float, dtime_detrend float, dtime_photom float, dtime_astrom float, hostname varchar(64) );
 
-alter table newExp add column tess_id varchar(64);
-alter table rawExp add column tess_id varchar(64);
-alter table chipRun add column tess_id varchar(64);
-alter table camRun add column tess_id varchar(64);
-alter table warpRun add column tess_id varchar(64);
+alter table chipProcessedImfile add column zp_mean float after ap_resid_stdev;
+alter table chipProcessedImfile add column zp_stdev float after zp_mean;
+alter table chipProcessedImfile add column dtime_detrend float after fwhm_minor;
+alter table chipProcessedImfile add column dtime_photom float after dtime_detrend;
+alter table chipProcessedImfile add column dtime_astrom float after dtime_photom;
+alter table chipProcessedImfile add column hostname varchar(64) after dtime_astrom;
 
-alter table camRun add column end_stage varchar(64);
-alter table chipRun add column end_stage varchar(64);
-alter table warpRun add column end_stage varchar(64);
-alter table newExp add column end_stage varchar(64);
-alter table rawExp add column end_stage varchar(64);
+
+# In order to keep the column order correct this is split up below
+#alter table diffSkyfile add column ( dtime_diff float, hostname varchar(64) );
+alter table diffSkyfile add column dtime_diff float after bg_stdev;
+alter table diffSkyfile add column hostname varchar(64) after dtime_diff;
+alter table diffSkyfile change column good_frac good_frac float;
+
+alter table flatcorrRun add column filter varchar(64) after dvodb;
+
+alter table stackSumSkyfile change column good_frac good_frac float;
+
+#alter table stackSumSkyfile add column ( dtime_stack float, hostname varchar(64) );
+alter table stackSumSkyfile add column dtime_stack float after bg_stdev;
+alter table stackSumSkyfile add column hostname varchar(64) after dtime_stack;
+
+#alter table warpSkyfile add column ( dtime_warp float, hostname varchar(64) );
+alter table warpSkyfile add column dtime_warp float after bg_stdev;
+alter table warpSkyfile add column hostname varchar(64) after dtime_warp;
+
+alter table warpSkyfile change column good_frac good_frac float;
+
+alter table newExp add column dvodb varchar(255) after reduction;
+alter table newExp add column tess_id varchar(64) after dvodb;
+alter table rawExp add column dvodb varchar(255) after reduction;
+alter table rawExp add column tess_id varchar(64) after dvodb;
+alter table chipRun add column tess_id varchar(64) after dvodb;
+alter table camRun add column tess_id varchar(64) after dvodb;
+alter table warpRun add column tess_id varchar(64) after dvodb;
+
+alter table camRun add column end_stage varchar(64) after tess_id;
+alter table chipRun add column end_stage varchar(64) after tess_id;
+alter table warpRun add column end_stage varchar(64) after tess_id;
+alter table newExp add column end_stage varchar(64) after tess_id;
+alter table rawExp add column end_stage varchar(64) after tess_id;
 alter table camRun add key (end_stage);
 alter table chipRun add key (end_stage);
@@ -64 +107 @@
 alter table rawExp add key (end_stage);
 
-alter table warpRun add column workdir_state varchar(64);
+alter table warpRun add column workdir_state varchar(64) after workdir;
 alter table warpRun add key (workdir_state);
 
+alter table pzDoneImfile add column fault smallint(6);
+
+
+######## end of changes to 1.1.29