Changeset 17872 for trunk/dbconfig/changes.txt
- Timestamp:
- May 30, 2008, 4:19:52 PM (18 years ago)
- File:
-
- 1 edited
-
trunk/dbconfig/changes.txt (modified) (10 diffs)
Legend:
- Unmodified
- Added
- Removed
-
trunk/dbconfig/changes.txt
r17804 r17872 1 How to manually change the database between versions via mySQL commands.2 3 This file is generated manually, and may not be complete.1 -- How to manually change the database between versions via mySQL commands. 2 -- 3 -- This file is generated manually, and may not be complete. 4 4 5 5 6 Version 1.1.20 --> 1.1.21:6 -- Version 1.1.20 --> 1.1.21: 7 7 8 8 alter table camProcessedExp drop nastro; … … 14 14 15 15 16 Version 1.1.22 --> 1.1.2317 #Adding support for reduction classes (which are used to specify recipes for parts of the pipeline).16 -- Version 1.1.22 --> 1.1.23 17 -- Adding support for reduction classes (which are used to specify recipes for parts of the pipeline). 18 18 # Adding 'reduction' to detRun 19 19 # Renaming 'recipe' in {chip,cam}{Pending,Processed}Exp to 'reduction' … … 25 25 alter table camProcessedExp change column recipe reduction varchar(64); 26 26 27 Version ??? --> 1.1.2927 -- Version ??? --> 1.1.29 28 28 29 29 alter table warpSkyfile add column ignored tinyint after good_frac; 30 30 31 # 32 #The following set of changes were applied to update the gpc1 database on 2008/02/0733 # 31 -- 32 -- The following set of changes were applied to update the gpc1 database on 2008/02/07 33 -- 34 34 35 35 alter table calDB change column catdir dvodb varchar(64); … … 38 38 alter table camProcessedExp change column fwhm_range fwhm_minor float; 39 39 40 #In order to keep the column order correct this is split up below41 #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) );40 -- In order to keep the column order correct this is split up below 41 --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) ); 42 42 43 43 alter table camProcessedExp add column bias float after bg_mean_stdev; … … 57 57 alter table chipProcessedImfile change column fwhm_range fwhm_minor float; 58 58 59 #In order to keep the column order correct this is split up below60 #alter table chipProcessedImfile add column ( zp_mean float, zp_stdev float, dtime_detrend float, dtime_photom float, dtime_astrom float, hostname varchar(64) );59 -- In order to keep the column order correct this is split up below 60 -- alter table chipProcessedImfile add column ( zp_mean float, zp_stdev float, dtime_detrend float, dtime_photom float, dtime_astrom float, hostname varchar(64) ); 61 61 62 62 alter table chipProcessedImfile add column zp_mean float after ap_resid_stdev; … … 68 68 69 69 70 #In order to keep the column order correct this is split up below71 #alter table diffSkyfile add column ( dtime_diff float, hostname varchar(64) );70 -- In order to keep the column order correct this is split up below 71 -- alter table diffSkyfile add column ( dtime_diff float, hostname varchar(64) ); 72 72 alter table diffSkyfile add column dtime_diff float after bg_stdev; 73 73 alter table diffSkyfile add column hostname varchar(64) after dtime_diff; … … 78 78 alter table stackSumSkyfile change column good_frac good_frac float; 79 79 80 #alter table stackSumSkyfile add column ( dtime_stack float, hostname varchar(64) );80 -- alter table stackSumSkyfile add column ( dtime_stack float, hostname varchar(64) ); 81 81 alter table stackSumSkyfile add column dtime_stack float after bg_stdev; 82 82 alter table stackSumSkyfile add column hostname varchar(64) after dtime_stack; … … 112 112 alter table pzDoneImfile add column fault smallint(6); 113 113 114 ########end of changes to 1.1.29114 -- end of changes to 1.1.29 115 115 116 116 alter table newExp add column label varchar(64) after end_stage; 117 117 118 ###1.1.30118 -- 1.1.30 119 119 120 120 drop table pzDoneExp; … … 124 124 alter table flatcorrRun add column region VARCHAR(255) after stats; 125 125 126 ###1.1.31126 -- 1.1.31 127 127 128 128 ALTER TABLE warpRun ADD COLUMN cam_id BIGINT AFTER warp_id; … … 139 139 DROP TABLE warpInputExp; 140 140 141 ###1.1.32141 -- 1.1.32 142 142 ALTER TABLE warpRun ADD COLUMN label VARCHAR(64) AFTER workdir_state; 143 143 ALTER TABLE warpRun ADD KEY(label); 144 144 CREATE TABLE warpMask (label VARCHAR(64), PRIMARY KEY(label)) ENGINE=innodb; 145 145 146 ###1.1.33146 -- 1.1.33 147 147 ALTER TABLE summitExp ADD COLUMN fault smallint(6) NOT NULL AFTER imfiles; 148 148 ALTER TABLE summitExp ADD KEY(fault); 149 149 150 ###1.1.34150 -- 1.1.34 151 151 ALTER TABLE rawImfile ADD KEY(exp_name); 152 152 153 ###1.1.35153 -- 1.1.35 154 154 ALTER TABLE rawImfile ADD INDEX UNQIUE(exp_id, tmp_class_id); 155 155 156 ###1.1.36156 -- 1.1.36 157 157 ALTER TABLE warpSkyfile ADD COLUMN (xmin INT, xmax INT, ymin INT, ymax INT); 158 158 ALTER TABLE diffSkyfile ADD COLUMN (stamps_num INT, stamps_rms FLOAT, sources INT); 159 159 ALTER TABLE rawImfile ADD COLUMN hostname VARCHAR(64) AFTER solang; 160 160 ALTER TABLE rawExp ADD COLUMN hostname VARCHAR(64) AFTER object; 161 162 -- 1.1.37 163 ALTER TABLE pzDataStore ADD COLUMN epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP AFTER uri; 164 ALTER TABLE summitExp ADD COLUMN epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP AFTER fault; 165 ALTER TABLE summitImfile ADD COLUMN epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP AFTER uri; 166 ALTER TABLE pzDownloadExp ADD COLUMN epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP AFTER state; 167 ALTER TABLE pzDownloadImfile ADD COLUMN epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP AFTER fault; 168 ALTER TABLE newExp ADD COLUMN epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP AFTER label; 169 ALTER TABLE newImfile ADD COLUMN epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP AFTER uri; 170 ALTER TABLE rawExp ADD COLUMN epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP AFTER fault; 171 ALTER TABLE rawImfile ADD COLUMN epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP AFTER fault; 172 173
Note:
See TracChangeset
for help on using the changeset viewer.
