Index: branches/eam_branches/ipp-20100823/dbconfig/background.md
===================================================================
--- branches/eam_branches/ipp-20100823/dbconfig/background.md	(revision 29016)
+++ branches/eam_branches/ipp-20100823/dbconfig/background.md	(revision 29515)
@@ -21,4 +21,5 @@
     class_id            STR     64
     path_base           STR     255
+    data_state          STR     64
     magicked            S64     0
     dtime_script        F32     0.0
@@ -57,4 +58,5 @@
     skycell_id          STR     64
     path_base           STR     255
+    data_state          STR     64
     magicked            S64     0
     dtime_script        F32     0.0
Index: branches/eam_branches/ipp-20100823/dbconfig/changes.txt
===================================================================
--- branches/eam_branches/ipp-20100823/dbconfig/changes.txt	(revision 29016)
+++ branches/eam_branches/ipp-20100823/dbconfig/changes.txt	(revision 29515)
@@ -1945,2 +1945,22 @@
 ALTER TABLE diffSummary DROP PRIMARY KEY, ADD PRIMARY KEY (diff_id, projection_cell);
 ALTER TABLE stackSummary DROP PRIMARY KEY, ADD PRIMARY KEY (sass_id, projection_cell);
+
+ALTER TABLE stackSumSkyfile ADD COLUMN mjd_obs double AFTER good_frac;
+
+-- Version 1.1.65
+-- changes to support cleanup of the background preserved images
+ALTER TABLE chipBackgroundImfile ADD COLUMN data_state VARCHAR(64) AFTER path_base;
+ALTER TABLE chipBackgroundImfile ADD KEY(data_state);
+ALTER TABLE warpBackgroundSkyfile ADD COLUMN data_state VARCHAR(64) AFTER path_base;
+ALTER TABLE warpBackgroundSkyfile  ADD KEY(data_state);
+
+ALTER TABLE magicMask ADD COLUMN path_base VARCHAR(255) AFTER uri;
+
+-- diff_id was removed from magicInputSkyfile ages ago, but
+-- pxadmin_create_tables.sql still had it this command didn't work due to
+-- a mysql error.
+-- ALTER TABLE magicInputSkyfile DROP COLUMN diff_id;
+UPDATE dbversion set schema_version = '1.1.65',  updated= CURRENT_TIMESTAMP();
+
+-- Version 1.1.66
+
Index: branches/eam_branches/ipp-20100823/dbconfig/config.md
===================================================================
--- branches/eam_branches/ipp-20100823/dbconfig/config.md	(revision 29016)
+++ branches/eam_branches/ipp-20100823/dbconfig/config.md	(revision 29515)
@@ -2,4 +2,4 @@
     pkg_name        STR     ippdb
     pkg_namespace   STR     ippdb
-    pkg_version     STR     1.1.63
+    pkg_version     STR     1.1.65
 END
Index: branches/eam_branches/ipp-20100823/dbconfig/magic.md
===================================================================
--- branches/eam_branches/ipp-20100823/dbconfig/magic.md	(revision 29016)
+++ branches/eam_branches/ipp-20100823/dbconfig/magic.md	(revision 29515)
@@ -42,4 +42,5 @@
     magic_id    S64         0       # Primary Key fkey(magic_id) ref magicRun(magic_id)
     uri         STR         255
+    path_base   STR         255
     streaks     S32         0
     fault       S16         0       # Key
Index: branches/eam_branches/ipp-20100823/dbconfig/pstamp.md
===================================================================
--- branches/eam_branches/ipp-20100823/dbconfig/pstamp.md	(revision 29016)
+++ branches/eam_branches/ipp-20100823/dbconfig/pstamp.md	(revision 29515)
@@ -46,4 +46,5 @@
     options     S64         64
     dep_id      S64         0
+    fault_count S32         0
 END
 
@@ -59,4 +60,5 @@
     outdir      STR         255
     fault       S16         0
+    fault_count S32         0
 END
 
Index: branches/eam_branches/ipp-20100823/dbconfig/stack.md
===================================================================
--- branches/eam_branches/ipp-20100823/dbconfig/stack.md	(revision 29016)
+++ branches/eam_branches/ipp-20100823/dbconfig/stack.md	(revision 29515)
@@ -49,4 +49,5 @@
     hostname           STR    64
     good_frac          F32    0.0     # Key
+    mjd_obs            F64    0.0
     fault              S16    0       # Key
     software_ver    STR         16