Changeset 25027 for branches/pap/dbconfig/changes.txt

Timestamp:

Aug 7, 2009, 4:08:25 PM (17 years ago)

Author:

Paul Price

Message:

Merging trunk (r25026) to get up-to-date on old branch.

Location:

branches/pap

Files:

• . (modified) (1 prop)
• dbconfig/changes.txt (modified) (1 diff)

branches/pap/dbconfig/changes.txt

@@ -1085 +1085 @@
 
 ALTER TABLE diffSkyfile ADD COLUMN deconv_max FLOAT AFTER kernel_yy;
+
+-- This key makes it faster to find the ccd_temp for XY24
+ALTER TABLE rawImfile ADD KEY(dateobs);
+
+ALTER TABLE receiveSource ADD COLUMN status_product VARCHAR(64);
+ALTER TABLE receiveSource ADD COLUMN ds_dbname VARCHAR(64);
+ALTER TABLE receiveSource ADD COLUMN ds_dbhost VARCHAR(64);
+
+ALTER TABLE receiveFileset ADD COLUMN state VARCHAR(64);
+ALTER TABLE receiveFileset ADD COLUMN dbinfo_uri VARCHAR(255);
+ALTER TABLE receiveFileset ADD COLUMN fault SMALLINT NOT NULL DEFAULT 0;
+
+ALTER TABLE receiveFile ADD COLUMN bytes BIGINT;
+ALTER TABLE receiveFile ADD COLUMN md5sum VARCHAR(255);
+ALTER TABLE receiveFile ADD COLUMN file_type VARCHAR(64);
+ALTER TABLE receiveFile ADD COLUMN component VARCHAR(64);
+
+ALTER TABLE receiveFileset CHANGE COLUMN dbinfo_uri dbinfo VARCHAR(255);
+ALTER TABLE receiveFileset ADD COLUMN dirinfo VARCHAR(255) AFTER state;
+
+-- Playing with the diffs for warp-warp
+ALTER TABLE diffRun ADD COLUMN bothways TINYINT DEFAULT 0 AFTER tess_id;
+UPDATE diffRun SET bothways = 1 WHERE reduction = 'WARPWARP';
+ALTER TABLE diffRun DROP FOREIGN KEY diffRun_ibfk_1;
+ALTER TABLE diffRun DROP COLUMN exp_id;
+ALTER TABLE diffRun ADD KEY(label);
+ALTER TABLE diffRun ADD COLUMN exposure TINYINT DEFAULT 0 AFTER bothways;
+UPDATE diffRun, diffInputSkyfile SET diffRun.exposure = 1 WHERE diffRun.diff_id = diffInputSkyfile.diff_id and diffInputSkyfile.warp1 IS NOT NULL;
+ALTER TABLE stackRun ADD KEY(label);
+
+ALTER TABLE magicRun ADD COLUMN inverse TINYINT NOT NULL DEFAULT 0 AFTER diff_id;
+ALTER TABLE diffSkyfile DROP COLUMN uri;
+
+DROP TABLE IF EXISTS magicSkyfileMask;
+ALTER TABLE magicInputSkyfile DROP FOREIGN KEY magicInputSkyfile_ibfk_2;
+ALTER TABLE magicInputSkyfile DROP KEY diff_id;
+ALTER TABLE magicInputSkyfile DROP PRIMARY KEY, ADD PRIMARY KEY(magic_id,node);
+ALTER TABLE magicInputSkyfile DROP COLUMN diff_id;
+ALTER TABLE magicNodeResult CHANGE COLUMN uri path_base VARCHAR(255);
+
+-- Version 1.1.53
+
+ALTER TABLE warpRun ADD COLUMN reduction VARCHAR(64) AFTER tess_id;
+
+-- Tables to support publishing of detections to a Science Client
+-- Clients to which we send stuff
+CREATE TABLE publishClient (
+    client_id BIGINT AUTO_INCREMENT, -- unique identifier
+    product VARCHAR(64),             -- product name
+    stage VARCHAR(64) NOT NULL, -- stage of interest (chip, camera, diff, etc.)
+    workdir VARCHAR(255) NOT NULL, -- working directory
+    comment VARCHAR(255),            -- for human memory
+    PRIMARY KEY(client_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+-- Publishing a set of data (e.g., a specific diffRun)
+CREATE TABLE publishRun (
+    pub_id BIGINT AUTO_INCREMENT, -- unique identifier
+    client_id BIGINT NOT NULL,  -- link to publishClient
+    stage_id BIGINT NOT NULL,   -- link to various stage tables
+    label VARCHAR(64),          -- label for run
+    state VARCHAR(64),          -- state of run (new, full, etc.)
+    PRIMARY KEY(pub_id),
+    KEY(client_id),
+    KEY(stage_id),
+    KEY(label),
+    KEY(state),
+    FOREIGN KEY(client_id) REFERENCES publishClient(client_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+-- Publishing a file within a set
+CREATE TABLE publishDone (
+    pub_id BIGINT AUTO_INCREMENT, -- link to publishRun
+    path_base VARCHAR(255),     -- base path of output
+    fault SMALLINT NOT NULL DEFAULT 0, -- Fault code
+    PRIMARY KEY(pub_id),
+    KEY(fault),
+    FOREIGN KEY(pub_id) REFERENCES publishRun(pub_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
+-- Version 1.1.54
+
+-- changed magicked from a flag to a BIGINT
+-- The value is the magic_ds_id of the magicDSRun that destreaked the file/run
+
+ALTER TABLE magicDSFile ADD COLUMN data_state VARCHAR(64);
+ALTER TABLE magicDSFile ADD KEY(data_state);
+UPDATE magicDSFile SET data_state = 'full' WHERE data_state IS NULL;
+
+ALTER TABLE rawImfile CHANGE COLUMN magicked  magicked BIGINT;
+ALTER TABLE rawExp CHANGE COLUMN magicked  magicked BIGINT;
+
+ALTER TABLE chipProcessedImfile CHANGE COLUMN magicked  magicked BIGINT;
+ALTER TABLE chipRun CHANGE COLUMN magicked  magicked BIGINT;
+
+-- so far only chipRuns have been magicked in product
+UPDATE chipProcessedImfile JOIN magicDSRun ON stage = 'chip' AND chip_id = stage_id
+    SET chipProcessedImfile.magicked = magic_ds_id 
+    WHERE magicDSRun.re_place
+    AND chipProcessedImfile.magicked > 0;
+
+UPDATE chipRun JOIN magicDSRun ON stage = 'chip' AND chip_id = stage_id
+    SET chipRun.magicked = magic_ds_id 
+    WHERE magicDSRun.re_place
+    AND chipRun.magicked > 0;
+
+ALTER TABLE warpSkyfile CHANGE COLUMN magicked  magicked BIGINT;
+ALTER TABLE warpRun CHANGE COLUMN magicked  magicked BIGINT;
+
+ALTER TABLE diffSkyfile CHANGE COLUMN magicked  magicked BIGINT;
+ALTER TABLE diffRun CHANGE COLUMN magicked  magicked BIGINT;
+
+ALTER TABLE camRun ADD COLUMN magicked BIGINT;
+
+ALTER TABLE distTarget CHANGE COLUMN obs_mode label VARCHAR(64);
+ALTER TABLE distTarget ADD COLUMN filter VARCHAR(64) AFTER label;
+ALTER TABLE distTarget DROP KEY clean;
+ALTER TABLE distTarget ADD CONSTRAINT UNIQUE(label, filter, stage, clean);
+
+ALTER TABLE pstampJob DROP COLUMN args;
+ALTER TABLE pstampJob DROP COLUMN uri;
+ALTER TABLE magicDSRun ADD COLUMN inv_magic_id BIGINT AFTER magic_id;
+ALTER TABLE magicDSRun ADD FOREIGN KEY (inv_magic_id) REFERENCES magicRun(magic_id);