Index: trunk/dbconfig/changes.txt
===================================================================
--- trunk/dbconfig/changes.txt	(revision 28294)
+++ trunk/dbconfig/changes.txt	(revision 28343)
@@ -1757,2 +1757,36 @@
 
 ALTER TABLE pstampRequest ADD COLUMN timestamp TIMESTAMP AFTER outdir;
+
+
+-- Tables to support (re-)photometry of a diff
+CREATE TABLE diffPhotRun (
+    diff_phot_id BIGINT AUTO_INCREMENT, -- Identifier for diffPhotRun
+    diff_id BIGINT NOT NULL,            -- Identifier for diffRun
+    state VARCHAR(64) NOT NULL,         -- State of run
+    workdir VARCHAR(255) NOT NULL, -- working directory
+    label VARCHAR(64),             -- processing label
+    data_group VARCHAR(64),        -- group for data
+    reduction VARCHAR(64),         -- reduction class (for altering recipe)
+    registered TIMESTAMP DEFAULT CURRENT_TIMESTAMP, -- time run was registered
+    note VARCHAR(255),             -- note
+    PRIMARY KEY(diff_phot_id),
+    KEY(diff_id),
+    KEY(state),
+    KEY(label),
+    KEY(data_group),
+    FOREIGN KEY(diff_id) REFERENCES diffRun(diff_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+CREATE TABLE diffPhotSkyfile (
+    diff_phot_id BIGINT AUTO_INCREMENT, -- Identifier for diffPhotRun
+    skycell_id VARCHAR(64) NOT NULL,            -- Skycell identifier
+    path_base VARCHAR(255) NOT NULL, -- Base of path for output
+    dtime_script FLOAT,              -- elapsed time for script
+    hostname VARCHAR(64) NOT NULL,   -- host that executed script
+    fault SMALLINT NOT NULL,         -- fault code
+    quality SMALLINT NOT NULL,       -- bad quality flag
+    software_ver VARCHAR(16),                       -- software version for run
+    PRIMARY KEY(diff_phot_id, skycell_id),
+    KEY(fault),
+    KEY(quality),
+    FOREIGN KEY(diff_phot_id) REFERENCES diffPhotRun(diff_phot_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
Index: trunk/dbconfig/diffphot.md
===================================================================
--- trunk/dbconfig/diffphot.md	(revision 28343)
+++ trunk/dbconfig/diffphot.md	(revision 28343)
@@ -0,0 +1,23 @@
+			
+diffPhotRun METADATA
+    diff_phot_id    S64         0       # Primary Key AUTO_INCREMENT
+    diff_id	    S64		0	# Key
+    state           STR         64      # Key
+    workdir         STR         255
+    label           STR         64      # Key
+    data_group      STR         64      # Key
+    reduction       STR         64
+    registered      TAI         NULL
+    note            STR         255
+END
+
+diffPhotSkyfile METADATA
+    diff_phot_id     S64        0       # Primary Key
+    skycell_id       STR        64      # Primary Key
+    path_base        STR        255
+    dtime_script     F32        0.0
+    hostname         STR        64
+    fault            S16        0       # Key
+    quality          S16        0       # Key
+    software_ver     STR        16
+END
Index: trunk/dbconfig/ipp.m4
===================================================================
--- trunk/dbconfig/ipp.m4	(revision 28294)
+++ trunk/dbconfig/ipp.m4	(revision 28343)
@@ -33,2 +33,3 @@
 include(receive.md)
 include(publish.md)
+include(diffphot.md)