Changeset 26191 for trunk/dbconfig

Timestamp:

Nov 19, 2009, 1:18:42 AM (17 years ago)

Author:

bills

Message:

use sql comments not #

File:

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

trunk/dbconfig/changes.txt

@@ -16 +16 @@
 -- 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'
+-- 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;
@@ -82 +82 @@
 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, 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;
@@ -1424 +1424 @@
 ALTER TABLE publishClient ADD COLUMN active TINYINT DEFAULT 0 AFTER client_id;
 
-# add outdir to allow spreading files over multiple hosts
+--  add outdir to allow spreading files over multiple hosts
 ALTER TABLE distRun ADD COLUMN outdir VARCHAR(255) AFTER outroot;
 ALTER TABLE distComponent ADD COLUMN outdir VARCHAR(255) AFTER state;
 
-# populate the existing runs (except for bills' test runs)
+-- populate the existing runs (except for bills' test runs)
 UPDATE distRun SET outdir = CONCAT_WS('.', outroot, dist_id) WHERE outroot not like '%@HOST@%';
 UPDATE distRun join distComponent using(dist_id) SET distComponent.outdir = CONCAT_WS('.', distRun.outroot, dist_id);