Index: trunk/ippTools/share/pxadmin_create_tables.sql
===================================================================
--- trunk/ippTools/share/pxadmin_create_tables.sql	(revision 35196)
+++ trunk/ippTools/share/pxadmin_create_tables.sql	(revision 35213)
@@ -2164,10 +2164,10 @@
     rel_id      INT(8) AUTO_INCREMENT,
     surveyID    INT(8),
-    releaseName VARCHAR(64),
+    release_name VARCHAR(64),
     relase_state VARCHAR(16),   -- active, pending, archive, drop 
     dataRelease INT(8),         -- PSPS dataRelease
     priority    INT(8),
     PRIMARY KEY(rel_id),
-    KEY(releaseName),
+    KEY(release_name),
     KEY(state),
     KEY(priority),
@@ -2181,4 +2181,5 @@
     chip_id     BIGINT,         -- links to the runs that supplied the data
     cam_id      BIGINT,         -- for this release
+    group_id    INT(8),         -- id of relGroup that this exposure is contained in
     state       VARCHAR(16),    -- released, pending, archive, drop  
     flags       INT UNSIGNED,   -- flags for relphot, relastro, ??
@@ -2229,4 +2230,26 @@
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
 
+CREATE TABLE relGroup (
+    group_id    INT(8) AUTO_INCREMENT,
+    rel_id      INT(8),
+    group_type  VARCHAR(16),
+    lap_id      BIGINT,
+    group_name  VARCHAR(16),
+    state       VARCHAR(16),    -- new full
+    label       VARCHAR(64),
+    exp_list_path   VARCHAR(255),
+    fault SMALLINT NOT NULL,
+    registered  DATETIME,
+    PRIMARY KEY (group_id),
+    KEY (rel_id, group_name),
+    KEY (group_type),
+    KEY (lap_id),
+    KEY (group_name),
+    KEY (state),
+    KEY (label),
+    KEY (fault),
+    FOREIGN KEY(rel_id) REFERENCES ippRelease(rel_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+