Index: trunk/ippTools/share/pxadmin_create_tables.sql
===================================================================
--- trunk/ippTools/share/pxadmin_create_tables.sql	(revision 29495)
+++ trunk/ippTools/share/pxadmin_create_tables.sql	(revision 29902)
@@ -371,4 +371,5 @@
     maskfrac_magic FLOAT,
     maskfrac_advisory FLOAT,
+    deteff_magref FLOAT,
     PRIMARY KEY(chip_id, exp_id, class_id),
     KEY(data_state),
@@ -486,5 +487,4 @@
     n_astrom INT,
     path_base VARCHAR(255),
-    quality SMALLINT NOT NULL DEFAULT 0,
     fault SMALLINT NOT NULL,
     software_ver VARCHAR(16),
@@ -499,4 +499,9 @@
     maskfrac_max_magic FLOAT,
     maskfrac_max_advisory FLOAT,
+    deteff FLOAT,
+    deteff_err FLOAT,
+    deteff_lq FLOAT,
+    deteff_uq FLOAT,
+    quality SMALLINT NOT NULL DEFAULT 0,
     PRIMARY KEY(cam_id),
     KEY(fault),
@@ -1050,4 +1055,5 @@
         hostname VARCHAR(64),
         good_frac FLOAT,
+        mjd_obs DOUBLE,
         quality SMALLINT NOT NULL DEFAULT 0,
         fault SMALLINT,