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

Timestamp:

Apr 2, 2009, 12:46:28 PM (17 years ago)

Author:

Paul Price

Message:

Ensure quality is non-NULL, defaulting to 0 (good quality).

File:

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

branches/pap/dbconfig/changes.txt

@@ -901 +901 @@
 -- 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;
+ALTER TABLE diffSkyfile ADD COLUMN quality SMALLINT NOT NULL DEFAULT 0 AFTER fault;
+ALTER TABLE stackSumSkyfile ADD COLUMN quality SMALLINT NOT NULL DEFAULT 0 AFTER fault;
+ALTER TABLE warpSkyfile ADD COLUMN quality SMALLINT NOT NULL DEFAULT 0 AFTER fault;
+ALTER TABLE camProcessedExp ADD COLUMN quality SMALLINT NOT NULL DEFAULT 0 AFTER fault;
+ALTER TABLE chipProcessedImfile ADD COLUMN quality SMALLINT NOT NULL DEFAULT 0 AFTER fault;
+ALTER TABLE rawImfile ADD COLUMN quality SMALLINT NOT NULL DEFAULT 0 AFTER fault;
 
 ALTER TABLE warpSkyfile DROP COLUMN ignored;