Index: trunk/dbconfig/changes.txt
===================================================================
--- trunk/dbconfig/changes.txt	(revision 28343)
+++ trunk/dbconfig/changes.txt	(revision 28375)
@@ -1634,4 +1634,5 @@
 ALTER TABLE diffSkyfile ADD COLUMN maskfrac_advisory FLOAT after maskfrac_magic;
 
+
 ALTER TABLE chipRun CHANGE maskfrac_npix  maskfrac_npix FLOAT;
 ALTER TABLE camRun CHANGE maskfrac_npix  maskfrac_npix FLOAT;
@@ -1730,5 +1731,4 @@
 -- this adds the new tables 
 
-
 CREATE TABLE minidvodbRun (
 minidvodb_id BIGINT AUTO_INCREMENT,
@@ -1741,6 +1741,4 @@
        PRIMARY KEY(minidvodb_id), KEY(minidvodb_name), INDEX(minidvodb_id)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
-
-
 
 CREATE TABLE minidvodbProcessed (
@@ -1791,2 +1789,52 @@
     FOREIGN KEY(diff_phot_id) REFERENCES diffPhotRun(diff_phot_id)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
+
+
+-- Version 1.1.69 warp/stack/diff summary and stack associations.
+
+CREATE TABLE warpSummary (
+    warp_id     BIGINT,
+    projection_cell VARCHAR(64) NOT NULL,
+    path_base   VARCHAR(255) NOT NULL,
+    PRIMARY KEY(warp_id),
+    KEY(projection_cell),
+    FOREIGN KEY(warp_id) REFERENCES warpRun(warp_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
+CREATE TABLE diffSummary (
+    diff_id     BIGINT,
+    projection_cell VARCHAR(64) NOT NULL,
+    path_base   VARCHAR(255) NOT NULL,
+    PRIMARY KEY(diff_id),
+    KEY(projection_cell),
+    FOREIGN KEY(diff_id) REFERENCES diffRun(diff_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
+CREATE TABLE stackAssociation (
+    sass_id      BIGINT AUTO_INCREMENT,
+    data_group   VARCHAR(64) NOT NULL,
+    projection_cell VARCHAR(64) NOT NULL,
+    tess_id       VARCHAR(64) NOT NULL,
+    filter        VARCHAR(64) NOT NULL,
+    PRIMARY KEY(sass_id),
+    KEY(data_group),
+    KEY(projection_cell),
+    KEY(tess_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
+CREATE TABLE stackAssociationMap (
+    sass_id      BIGINT,
+    stack_id     BIGINT,
+    PRIMARY KEY(sass_id, stack_id),
+    FOREIGN KEY(sass_id) REFERENCES stackAssociation(sass_id),
+    FOREIGN KEY(stack_id) REFERENCES stackRun(stack_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
+CREATE TABLE stackSummary (
+    sass_id     BIGINT,
+    projection_cell VARCHAR(64) NOT NULL,
+    path_base   VARCHAR(255) NOT NULL,
+    PRIMARY KEY(sass_id),
+    KEY(projection_cell),
+    FOREIGN KEY(sass_id) REFERENCES stackAssociation(sass_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
Index: trunk/dbconfig/diff.md
===================================================================
--- trunk/dbconfig/diff.md	(revision 28343)
+++ trunk/dbconfig/diff.md	(revision 28375)
@@ -75,2 +75,8 @@
     maskfrac_advisory F32   0.0
 END
+
+diffSummary METADATA
+    diff_id	    S64      0       # Primary Key fkey(diff_id) ref diffRun(diff_id)
+    projection_cell STR	    32	    # Primary Key
+    path_base 	    STR	    255
+END
Index: trunk/dbconfig/stack.md
===================================================================
--- trunk/dbconfig/stack.md	(revision 28343)
+++ trunk/dbconfig/stack.md	(revision 28375)
@@ -53,2 +53,21 @@
     quality            S16    0
 END
+
+stackSummary METADATA
+    sass_id	   S64      0       # Primary Key fkey(sass_id) ref stackAssociation(sass_id)
+    projection_cell  STR	    32	    # Primary Key
+    path_base 	   STR	    255
+END
+
+stackAssociation METADATA
+    sass_id        S64      0       # Primary Key AUTO_INCREMENT
+    data_group     STR      64      # Key
+    projection_cell  STR      64      # Key
+    tess_id        STR      64      # Key
+    filter         STR      64
+END
+
+stackAssociationMap METADATA
+    sass_id        S64      0       # Primary Key fkey(sass_id) ref stackAssociation(sass_id)
+    stack_id       S64      0       # Primary Key fkey(stack_id) ref stackRun(stack_id)
+END
Index: trunk/dbconfig/warp.md
===================================================================
--- trunk/dbconfig/warp.md	(revision 28343)
+++ trunk/dbconfig/warp.md	(revision 28375)
@@ -79,2 +79,8 @@
     label       STR         64      # Primary Key
 END
+
+warpSummary METADATA
+    warp_id	   S64      0       # Primary Key fkey(warp_id) ref warpRun(warp_id)
+    projection_cell  STR	    32	    # Primary Key
+    path_base 	   STR	    255
+END