Changeset 28043 for trunk/dbconfig/changes.txt

Timestamp:

May 19, 2010, 5:13:52 PM (16 years ago)

Author:

watersc1

Message:

Merging czw_branch (maskstats and software versions) back into the trunk

Location:

trunk

Files:

• . (modified) (1 prop)
• dbconfig/changes.txt (modified) (2 diffs)

trunk/dbconfig/changes.txt

@@ -1605 +1605 @@
 ALTER TABLE distTarget ADD KEY(stage), ADD KEY(dist_group), ADD KEY(filter), ADD KEY(state);
 
+-- Version 1.1.67
+
 CREATE TABLE Label (
     label       VARCHAR(64),
@@ -1616 +1618 @@
 
 ALTER TABLE pstampRequest ADD COLUMN outdir VARCHAR(64) after uri;
+
+-- Version 1.1.68
+ALTER TABLE chipRun ADD COLUMN software_ver VARCHAR(16) after magicked;
+ALTER TABLE chipRun ADD COLUMN maskfrac_npix INT after software_ver;
+ALTER TABLE chipRun ADD COLUMN maskfrac_static FLOAT after maskfrac_npix;
+ALTER TABLE chipRun ADD COLUMN maskfrac_dynamic FLOAT after maskfrac_static;
+ALTER TABLE chipRun ADD COLUMN maskfrac_magic FLOAT after maskfrac_dynamic;
+ALTER TABLE chipRun ADD COLUMN maskfrac_advisory FLOAT after maskfrac_magic;
+
+ALTER TABLE chipProcessedImfile ADD COLUMN software_ver VARCHAR(16) after magicked;
+ALTER TABLE chipProcessedImfile ADD COLUMN maskfrac_npix INT after software_ver;
+ALTER TABLE chipProcessedImfile ADD COLUMN maskfrac_static FLOAT after maskfrac_npix;
+ALTER TABLE chipProcessedImfile ADD COLUMN maskfrac_dynamic FLOAT after maskfrac_static;
+ALTER TABLE chipProcessedImfile ADD COLUMN maskfrac_magic FLOAT after maskfrac_dynamic;
+ALTER TABLE chipProcessedImfile ADD COLUMN maskfrac_advisory FLOAT after maskfrac_magic;
+
+ALTER TABLE camRun ADD COLUMN software_ver VARCHAR(16) after magicked;
+ALTER TABLE camRun ADD COLUMN maskfrac_npix INT after software_ver;
+ALTER TABLE camRun ADD COLUMN maskfrac_static FLOAT after maskfrac_npix;
+ALTER TABLE camRun ADD COLUMN maskfrac_dynamic FLOAT after maskfrac_static;
+ALTER TABLE camRun ADD COLUMN maskfrac_magic FLOAT after maskfrac_dynamic;
+ALTER TABLE camRun ADD COLUMN maskfrac_advisory FLOAT after maskfrac_magic;
+
+ALTER TABLE camProcessedExp ADD COLUMN software_ver VARCHAR(16) after fault;
+ALTER TABLE camProcessedExp ADD COLUMN maskfrac_npix INT after software_ver;
+ALTER TABLE camProcessedExp ADD COLUMN maskfrac_static FLOAT after maskfrac_npix;
+ALTER TABLE camProcessedExp ADD COLUMN maskfrac_dynamic FLOAT after maskfrac_static;
+ALTER TABLE camProcessedExp ADD COLUMN maskfrac_magic FLOAT after maskfrac_dynamic;
+ALTER TABLE camProcessedExp ADD COLUMN maskfrac_advisory FLOAT after maskfrac_magic;
+
+ALTER TABLE warpRun ADD COLUMN software_ver VARCHAR(16) after magicked;
+ALTER TABLE warpRun ADD COLUMN maskfrac_npix INT after software_ver;
+ALTER TABLE warpRun ADD COLUMN maskfrac_static FLOAT after maskfrac_npix;
+ALTER TABLE warpRun ADD COLUMN maskfrac_dynamic FLOAT after maskfrac_static;
+ALTER TABLE warpRun ADD COLUMN maskfrac_magic FLOAT after maskfrac_dynamic;
+ALTER TABLE warpRun ADD COLUMN maskfrac_advisory FLOAT after maskfrac_magic;
+
+ALTER TABLE warpSkyfile ADD COLUMN software_ver VARCHAR(16) after magicked;
+ALTER TABLE warpSkyfile ADD COLUMN maskfrac_npix INT after software_ver;
+ALTER TABLE warpSkyfile ADD COLUMN maskfrac_static FLOAT after maskfrac_npix;
+ALTER TABLE warpSkyfile ADD COLUMN maskfrac_dynamic FLOAT after maskfrac_static;
+ALTER TABLE warpSkyfile ADD COLUMN maskfrac_magic FLOAT after maskfrac_dynamic;
+ALTER TABLE warpSkyfile ADD COLUMN maskfrac_advisory FLOAT after maskfrac_magic;
+
+ALTER TABLE stackRun ADD COLUMN software_ver VARCHAR(16) after filter;
+
+ALTER TABLE stackSumSkyfile ADD COLUMN software_ver VARCHAR(16) after fault;
+
+ALTER TABLE diffRun ADD COLUMN software_ver VARCHAR(16) after magicked;
+ALTER TABLE diffRun ADD COLUMN maskfrac_npix INT after software_ver;
+ALTER TABLE diffRun ADD COLUMN maskfrac_static FLOAT after maskfrac_npix;
+ALTER TABLE diffRun ADD COLUMN maskfrac_dynamic FLOAT after maskfrac_static;
+ALTER TABLE diffRun ADD COLUMN maskfrac_magic FLOAT after maskfrac_dynamic;
+ALTER TABLE diffRun ADD COLUMN maskfrac_advisory FLOAT after maskfrac_magic;
+
+ALTER TABLE diffSkyfile ADD COLUMN software_ver VARCHAR(16) after magicked;
+ALTER TABLE diffSkyfile ADD COLUMN maskfrac_npix INT after software_ver;
+ALTER TABLE diffSkyfile ADD COLUMN maskfrac_static FLOAT after maskfrac_npix;
+ALTER TABLE diffSkyfile ADD COLUMN maskfrac_dynamic FLOAT after maskfrac_static;
+ALTER TABLE diffSkyfile ADD COLUMN maskfrac_magic FLOAT after maskfrac_dynamic;
+ALTER TABLE diffSkyfile ADD COLUMN maskfrac_advisory FLOAT after maskfrac_magic;
+