Index: trunk/ippTools/share/pxadmin_create_tables.sql
===================================================================
--- trunk/ippTools/share/pxadmin_create_tables.sql	(revision 27874)
+++ trunk/ippTools/share/pxadmin_create_tables.sql	(revision 28043)
@@ -276,4 +276,10 @@
     end_stage VARCHAR(64),
     magicked BIGINT,
+    software_ver VARCHAR(16),
+    maskfrac_npix INT,
+    maskfrac_static FLOAT,
+    maskfrac_dynamic FLOAT,
+    maskfrac_magic FLOAT,
+    maskfrac_advisory FLOAT,
     note VARCHAR(255),
     PRIMARY KEY(chip_id),
@@ -359,4 +365,10 @@
     fault SMALLINT NOT NULL,
     magicked BIGINT,
+    software_ver VARCHAR(16),
+    maskfrac_npix INT,
+    maskfrac_static FLOAT,
+    maskfrac_dynamic FLOAT,
+    maskfrac_magic FLOAT,
+    maskfrac_advisory FLOAT,
     PRIMARY KEY(chip_id, exp_id, class_id),
     KEY(data_state),
@@ -387,4 +399,10 @@
     end_stage VARCHAR(64),
     magicked BIGINT,
+    software_ver VARCHAR(16),
+    maskfrac_npix INT,
+    maskfrac_static FLOAT,
+    maskfrac_dynamic FLOAT,
+    maskfrac_magic FLOAT,
+    maskfrac_advisory FLOAT,
     note VARCHAR(255),
     PRIMARY KEY(cam_id),
@@ -464,4 +482,10 @@
     quality SMALLINT NOT NULL DEFAULT 0,
     fault SMALLINT NOT NULL,
+    software_ver VARCHAR(16),
+    maskfrac_npix INT,
+    maskfrac_static FLOAT,
+    maskfrac_dynamic FLOAT,
+    maskfrac_magic FLOAT,
+    maskfrac_advisory FLOAT,
     PRIMARY KEY(cam_id),
     KEY(fault),
@@ -867,4 +891,10 @@
     registered DATETIME,
     magicked BIGINT,
+    software_ver VARCHAR(16),
+    maskfrac_npix INT,
+    maskfrac_static FLOAT,
+    maskfrac_dynamic FLOAT,
+    maskfrac_magic FLOAT,
+    maskfrac_advisory FLOAT,
     note VARCHAR(255),
     PRIMARY KEY(warp_id),
@@ -923,4 +953,10 @@
     fault SMALLINT,
     magicked BIGINT,
+    software_ver VARCHAR(16),
+    maskfrac_npix INT,
+    maskfrac_static FLOAT,
+    maskfrac_dynamic FLOAT,
+    maskfrac_magic FLOAT,
+    maskfrac_advisory FLOAT,
     PRIMARY KEY(warp_id, skycell_id, tess_id),
     KEY(good_frac),
@@ -948,4 +984,5 @@
         tess_id VARCHAR(64),
         filter VARCHAR(64),
+	software_ver VARCHAR(16),
         note VARCHAR(255),
         PRIMARY KEY(stack_id),
@@ -995,4 +1032,5 @@
         quality SMALLINT NOT NULL DEFAULT 0,
         fault SMALLINT,
+	software_ver VARCHAR(16),
         PRIMARY KEY(stack_id),
         KEY(dtime_stack),
@@ -1017,4 +1055,10 @@
         exposure TINYINT DEFAULT 0,
         magicked BIGINT,
+	software_ver VARCHAR(16),
+        maskfrac_npix INT,
+        maskfrac_static FLOAT,
+        maskfrac_dynamic FLOAT,
+        maskfrac_magic FLOAT,
+        maskfrac_advisory FLOAT,
         diff_mode SMALLINT NOT NULL,
         note VARCHAR(255),
@@ -1080,4 +1124,10 @@
         fault SMALLINT,
         magicked BIGINT,
+	software_ver VARCHAR(16),
+	maskfrac_npix INT,
+	maskfrac_static FLOAT,
+	maskfrac_dynamic FLOAT,
+	maskfrac_magic FLOAT,
+        maskfrac_advisory FLOAT,
         PRIMARY KEY(diff_id, skycell_id),
         KEY(good_frac),
