Index: /branches/pap/dbconfig/changes.txt
===================================================================
--- /branches/pap/dbconfig/changes.txt	(revision 23682)
+++ /branches/pap/dbconfig/changes.txt	(revision 23683)
@@ -901,10 +901,10 @@
 -- 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;
Index: /branches/pap/ippTools/share/pxadmin_create_tables.sql
===================================================================
--- /branches/pap/ippTools/share/pxadmin_create_tables.sql	(revision 23682)
+++ /branches/pap/ippTools/share/pxadmin_create_tables.sql	(revision 23683)
@@ -232,5 +232,5 @@
     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,5 +336,5 @@
     n_cr INT,
     path_base VARCHAR(255),
-    quality SMALLINT NOT NULL,
+    quality SMALLINT NOT NULL DEFAULT 0,
     fault SMALLINT NOT NULL,
     magicked BIGINT,
@@ -436,5 +436,5 @@
     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,5 +846,5 @@
     ymin INT,
     ymax INT,
-    quality SMALLINT NOT NULL,
+    quality SMALLINT NOT NULL DEFAULT 0,
     fault SMALLINT,
     magicked TINYINT,
@@ -913,5 +913,5 @@
         hostname VARCHAR(64),
         good_frac FLOAT,
-        quality SMALLINT NOT NULL,
+        quality SMALLINT NOT NULL DEFAULT 0,
         fault SMALLINT,
         PRIMARY KEY(stack_id),
@@ -989,5 +989,5 @@
         hostname VARCHAR(64),
         good_frac FLOAT,
-        quality SMALLINT NOT NULL,
+        quality SMALLINT NOT NULL DEFAULT 0,
         fault SMALLINT,
         magicked TINYINT,