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

Timestamp:

Mar 25, 2009, 12:48:19 PM (17 years ago)

Author:

Paul Price

Message:

Adding quality flag to raw, chip, cam, warp, stack, diff product tables. Renaming '-code' flag in the ippTools to '-fault' (clearer meaning, reduces confusion between fault code and quality code).

File:

• branches/pap/dbconfig/changes.txt (modified) (1 diff)

branches/pap/dbconfig/changes.txt

@@ -896 +896 @@
 update chipRun SET magicked = 1 where chip_id = 11955;
 
+
+-- Version 1.1.51: Adding data quality flags
+DROP TABLE guidePendingExp;
+ALTER TABLE diffSkyfile ADD COLUMN quality SMALLINT AFTER fault;
+ALTER TABLE stackSumSkyfile ADD COLUMN quality SMALLINT AFTER fault;
+ALTER TABLE warpSkyfile ADD COLUMN quality SMALLINT AFTER fault;
+ALTER TABLE camProcessedExp ADD COLUMN quality SMALLINT AFTER fault;
+ALTER TABLE chipProcessedImfile ADD COLUMN quality SMALLINT AFTER fault;
+ALTER TABLE rawImfile ADD COLUMN quality SMALLINT AFTER fault;