Index: trunk/dbconfig/changes.txt =================================================================== --- trunk/dbconfig/changes.txt (revision 17839) +++ trunk/dbconfig/changes.txt (revision 17872) @@ -1,8 +1,8 @@ -How to manually change the database between versions via mySQL commands. - -This file is generated manually, and may not be complete. +-- 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: +-- Version 1.1.20 --> 1.1.21: alter table camProcessedExp drop nastro; @@ -14,6 +14,6 @@ -Version 1.1.22 --> 1.1.23 -# Adding support for reduction classes (which are used to specify recipes for parts of the pipeline). +-- 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' @@ -25,11 +25,11 @@ alter table camProcessedExp change column recipe reduction varchar(64); -Version ??? --> 1.1.29 +-- Version ??? --> 1.1.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 -# +-- +-- 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); @@ -38,6 +38,6 @@ alter table camProcessedExp change column fwhm_range fwhm_minor float; -# 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) ); +-- 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 camProcessedExp add column bias float after bg_mean_stdev; @@ -57,6 +57,6 @@ alter table chipProcessedImfile change column fwhm_range fwhm_minor float; -# 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) ); +-- 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 chipProcessedImfile add column zp_mean float after ap_resid_stdev; @@ -68,6 +68,6 @@ -# In order to keep the column order correct this is split up below -#alter table diffSkyfile add column ( dtime_diff float, hostname 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; @@ -78,5 +78,5 @@ 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, 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; @@ -112,9 +112,9 @@ alter table pzDoneImfile add column fault smallint(6); -######## end of changes to 1.1.29 +-- end of changes to 1.1.29 alter table newExp add column label varchar(64) after end_stage; -### 1.1.30 +-- 1.1.30 drop table pzDoneExp; @@ -124,5 +124,5 @@ alter table flatcorrRun add column region VARCHAR(255) after stats; -### 1.1.31 +-- 1.1.31 ALTER TABLE warpRun ADD COLUMN cam_id BIGINT AFTER warp_id; @@ -139,22 +139,35 @@ DROP TABLE warpInputExp; -### 1.1.32 +-- 1.1.32 ALTER TABLE warpRun ADD COLUMN label VARCHAR(64) AFTER workdir_state; ALTER TABLE warpRun ADD KEY(label); CREATE TABLE warpMask (label VARCHAR(64), PRIMARY KEY(label)) ENGINE=innodb; -### 1.1.33 +-- 1.1.33 ALTER TABLE summitExp ADD COLUMN fault smallint(6) NOT NULL AFTER imfiles; ALTER TABLE summitExp ADD KEY(fault); -### 1.1.34 +-- 1.1.34 ALTER TABLE rawImfile ADD KEY(exp_name); -### 1.1.35 +-- 1.1.35 ALTER TABLE rawImfile ADD INDEX UNQIUE(exp_id, tmp_class_id); -### 1.1.36 +-- 1.1.36 ALTER TABLE warpSkyfile ADD COLUMN (xmin INT, xmax INT, ymin INT, ymax INT); ALTER TABLE diffSkyfile ADD COLUMN (stamps_num INT, stamps_rms FLOAT, sources INT); ALTER TABLE rawImfile ADD COLUMN hostname VARCHAR(64) AFTER solang; ALTER TABLE rawExp ADD COLUMN hostname VARCHAR(64) AFTER object; + +-- 1.1.37 +ALTER TABLE pzDataStore ADD COLUMN epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP AFTER uri; +ALTER TABLE summitExp ADD COLUMN epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP AFTER fault; +ALTER TABLE summitImfile ADD COLUMN epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP AFTER uri; +ALTER TABLE pzDownloadExp ADD COLUMN epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP AFTER state; +ALTER TABLE pzDownloadImfile ADD COLUMN epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP AFTER fault; +ALTER TABLE newExp ADD COLUMN epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP AFTER label; +ALTER TABLE newImfile ADD COLUMN epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP AFTER uri; +ALTER TABLE rawExp ADD COLUMN epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP AFTER fault; +ALTER TABLE rawImfile ADD COLUMN epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP AFTER fault; + + Index: trunk/dbconfig/config.md =================================================================== --- trunk/dbconfig/config.md (revision 17839) +++ trunk/dbconfig/config.md (revision 17872) @@ -2,4 +2,4 @@ pkg_name STR ippdb pkg_namespace STR ippdb - pkg_version STR 1.1.36 + pkg_version STR 1.1.37 END Index: trunk/dbconfig/tasks.md =================================================================== --- trunk/dbconfig/tasks.md (revision 17839) +++ trunk/dbconfig/tasks.md (revision 17872) @@ -1,3 +1,3 @@ -# $Id: tasks.md,v 1.153 2008-05-29 02:36:29 jhoblitt Exp $ +# $Id: tasks.md,v 1.154 2008-05-31 02:19:17 jhoblitt Exp $ # this table records all exposure ID ever seen from the summit @@ -24,4 +24,5 @@ telescope STR 64 # Primary Key uri STR 255 + epoch UTC 0001-01-01T00:00:00Z END @@ -38,4 +39,5 @@ imfiles S32 0 fault S16 0 # Key NOT NULL + epoch UTC 0001-01-01T00:00:00Z END @@ -53,4 +55,5 @@ class_id STR 64 # Primary Key uri STR 255 + epoch UTC 0001-01-01T00:00:00Z END @@ -62,4 +65,5 @@ telescope STR 64 # Primary Key state STR 64 # Key + epoch UTC 0001-01-01T00:00:00Z END @@ -72,4 +76,5 @@ uri STR 255 fault S16 0 # Key NOT NULL + epoch UTC 0001-01-01T00:00:00Z END @@ -87,4 +92,5 @@ end_stage STR 64 # Key label STR 64 # Key + epoch UTC 0001-01-01T00:00:00Z END @@ -95,4 +101,5 @@ tmp_class_id STR 64 # Primary Key uri STR 255 + epoch UTC 0001-01-01T00:00:00Z END @@ -156,4 +163,5 @@ hostname STR 64 fault S16 0 # Key NOT NULL + epoch UTC 0001-01-01T00:00:00Z END @@ -215,3 +223,4 @@ hostname STR 64 fault S16 0 # Key NOT NULL -END + epoch UTC 0001-01-01T00:00:00Z +END