Changeset 35213 for trunk/ippTools/share/pxadmin_create_tables.sql

Timestamp:

Feb 28, 2013, 3:29:26 PM (13 years ago)

Author:

bills

Message:

Add tables relGroup and lapGroup
Add group_id to relExp
Rename releaseName release_name because I kept typing it wrong.

File:

• trunk/ippTools/share/pxadmin_create_tables.sql (modified) (3 diffs)

trunk/ippTools/share/pxadmin_create_tables.sql

@@ -2164 +2164 @@
     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 +2181 @@
     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 +2230 @@
 ) 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;
+