Index: /trunk/dbconfig/changes.txt
===================================================================
--- /trunk/dbconfig/changes.txt	(revision 34910)
+++ /trunk/dbconfig/changes.txt	(revision 34911)
@@ -2265,2 +2265,50 @@
 ALTER TABLE skycalResult ADD column n_forced INT after n_extended;
 UPDATE dbversion set schema_version = '1.1.73', updated= CURRENT_TIMESTAMP();
+
+
+-- new tables for managing the "release" of ipp data
+
+CREATE TABLE survey (
+    surveyID    INT(8),
+    surveyName  VARCHAR(16) NOT NULL,
+    description VARCHAR(255),
+    PRIMARY KEY(surveyID),
+    UNIQUE  KEY(surveyName)
+) ENGINE=InnoDB CHARSET=latin1;
+
+
+CREATE TABLE ippRelease (
+    rel_id      INT(8) AUTO_INCREMENT,
+    surveyID    INT(8),
+    releaseName VARCHAR(64),
+    state       VARCHAR(16),    -- active, pending archive drop 
+    dataRelease INT(8),         -- PSPS dataRelease
+    PRIMARY KEY(rel_id),
+    KEY(releaseName),
+    KEY(state),
+    FOREIGN KEY(surveyID) REFERENCES survey(surveyID)
+) ENGINE=Innodb DEFAULT CHARSET=latin1;
+
+CREATE TABLE relExp (
+    relexp_id   BIGINT AUTO_INCREMENT,
+    rel_id      INT(8),
+    exp_id      BIGINT,
+    chip_id     BIGINT,         -- links to the runs that supplied the data
+    cam_id      BIGINT,         -- for this release
+    state       VARCHAR(16),    -- released, pending, archive, drop  
+    flags       INT UNSIGNED,   -- flags for relphot, relastro, ??
+    zpt_obs     FLOAT,          -- calibrated zero point for this release of
+    zpt_stdev   FLOAT,          -- this exposure
+    path_base   VARCHAR(255),   -- path_base of any supporting files for this
+                                -- release of this exposure.
+    registered  DATETIME,       -- insertion time for this row
+    time_stamp  DATETIME,       -- time of last update for this row
+    PRIMARY KEY (relexp_id),
+    FOREIGN KEY(rel_id) REFERENCES ippRelease(rel_id),
+    KEY (state),
+    FOREIGN KEY(exp_id) REFERENCES rawExp(exp_id),
+    FOREIGN KEY(chip_id) REFERENCES chipRun(chip_id),
+    FOREIGN KEY(cam_id) REFERENCES camRun(cam_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
+UPDATE dbversion set schema_version = '1.1.74', updated= CURRENT_TIMESTAMP();
Index: /trunk/dbconfig/ipp.m4
===================================================================
--- /trunk/dbconfig/ipp.m4	(revision 34910)
+++ /trunk/dbconfig/ipp.m4	(revision 34911)
@@ -39,2 +39,3 @@
 include(vp.md)
 include(skycell.md)
+include(release.md)
Index: /trunk/dbconfig/release.md
===================================================================
--- /trunk/dbconfig/release.md	(revision 34911)
+++ /trunk/dbconfig/release.md	(revision 34911)
@@ -0,0 +1,28 @@
+survey METADATA
+    surveyID    S32      0   # Primary Key
+    surveyName  STR     16
+    description STR     255
+END
+
+ippRelease METADATA
+    rel_id      S32     0   # Primary Key AUTO_INCREMENT
+    surveyID    S32     0   # fkey(surveyID) ref survey(surveyID)
+    releaseName STR     64
+    state       STR     16
+    dataRelease S32     0
+END
+
+relExp  METADATA
+    relexp_id   S64     0   # Primary Key AUTO_INCREMENT
+    rel_id      S32     0   # fkey(rel_id) ref ippRelease(rel_id)
+    exp_id      S64     0
+    chip_id     S64     0
+    cam_id      S64     0
+    state       STR     16
+    flags       U32     0
+    zpt_obs     F32     0
+    zpt_stdev   F32     0
+    path_base   STR     255
+    registered  TAI     NULL
+    time_stamp  UTC     NULL
+END