How to manually change the database between versions via mySQL commands.

This file is generated manually, and may not be complete.


Version 1.1.20 --> 1.1.21:

alter table camProcessedExp drop nastro;
alter table camProcessedExp add (fwhm double, fwhm_range double, n_stars int(11), n_extended int(11), n_cr int(11), n_astrom int(11));
alter table chipProcessedImfile add column (bias double, bias_stdev double, fringe_0 double, fringe_1 double, fringe_2 double, sigma_ra double, sigma_dec double, ap_resid double, ap_resid_stdev double, fwhm double, fwhm_range double, n_stars int(11), n_extended int(11), n_cr int(11), n_astrom int(11));
alter table warpSkyfile add column path_base varchar(255) NULL DEFAULT NULL after uri;
alter table diffSkyfile add column path_base varchar(255) NULL DEFAULT NULL after uri;
alter table stackSumSkyfile add column path_base varchar(255) NULL DEFAULT NULL after uri;


Version 1.1.22 --> 1.1.23
# Adding support for reduction classes (which are used to specify recipes for parts of the pipeline).
# Adding 'reduction' to detRun
# Renaming 'recipe' in {chip,cam}{Pending,Processed}Exp to 'reduction'

alter table detRun add column reduction varchar(64) NULL DEFAULT NULL after exp_type;
alter table chipPendingExp change column recipe reduction varchar(64);
alter table chipProcessedExp change column recipe reduction varchar(64);
alter table camPendingExp change column recipe reduction varchar(64);
alter table camProcessedExp change column recipe reduction varchar(64);

Version ??? --> 1.1.29

alter table warpSkyfile add column ignored tinyint after good_frac;

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 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;

alter table diffSkyfile add column ( dtime_diff double, hostname varchar(64) );

alter table flatcorrRun add column filter varchar(64);

alter table stackSumSkyfile add column ( dtime_stack double, hostname varchar(64) );

alter table warpSkyfile add column ( dtime_warp double, 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);
