Changeset 23683

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).

Location:

branches/pap

Files:

• dbconfig/changes.txt (modified) (1 diff)
• ippTools/share/pxadmin_create_tables.sql (modified) (6 diffs)

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;

branches/pap/ippTools/share/pxadmin_create_tables.sql

@@ -232 +232 @@
     ignored TINYINT DEFAULT 0,
     hostname VARCHAR(64),
-    quality SMALLINT NOT NULL,
+    quality SMALLINT NOT NULL DEFAULT 0,
     fault SMALLINT NOT NULL,
     epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
@@ -336 +336 @@
     n_cr INT,
     path_base VARCHAR(255),
-    quality SMALLINT NOT NULL,
+    quality SMALLINT NOT NULL DEFAULT 0,
     fault SMALLINT NOT NULL,
     magicked BIGINT,
@@ -436 +436 @@
     n_astrom INT,
     path_base VARCHAR(255),
-    quality SMALLINT NOT NULL,
+    quality SMALLINT NOT NULL DEFAULT 0,
     fault SMALLINT NOT NULL,
     PRIMARY KEY(cam_id),
@@ -846 +846 @@
     ymin INT,
     ymax INT,
-    quality SMALLINT NOT NULL,
+    quality SMALLINT NOT NULL DEFAULT 0,
     fault SMALLINT,
     magicked TINYINT,
@@ -913 +913 @@
         hostname VARCHAR(64),
         good_frac FLOAT,
-        quality SMALLINT NOT NULL,
+        quality SMALLINT NOT NULL DEFAULT 0,
         fault SMALLINT,
         PRIMARY KEY(stack_id),
@@ -989 +989 @@
         hostname VARCHAR(64),
         good_frac FLOAT,
-        quality SMALLINT NOT NULL,
+        quality SMALLINT NOT NULL DEFAULT 0,
         fault SMALLINT,
         magicked TINYINT,