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

Timestamp:

Apr 29, 2013, 2:11:53 PM (13 years ago)

Author:

bills

Message:

Add key to relStack UNIQUE KEY (rel_id, tess_id, skycell_id, filter, stack_type, mjd_obs)
to insure that we only have 1 stack for each skycell per stack type per mjd_obs. Note that
only nightly stacks have relStack.mjd_obs != 0 deep and reference stacks have it set to zero

File:

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

trunk/ippTools/share/pxadmin_create_tables.sql

@@ -1 @@
-CREATE TABLE dbversion (
+eREATE TABLE dbversion (
     schema_version VARCHAR(64),
     updated TIMESTAMP DEFAULT CURRENT_TIMESTAMP
@@ -2204 +2204 @@
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
 
-CREATE TABLE relStack (
+CREATE TABLE relStackTest (
     relstack_id BIGINT AUTO_INCREMENT,
     rel_id      INT,
@@ -2224 +2224 @@
     time_stamp  DATETIME,
     PRIMARY KEY (relstack_id),
+    UNIQUE KEY (rel_id, tess_id, skycell_id, filter, stack_type, mjd_obs),
     KEY (tess_id, skycell_id),
-    KEY (rel_id, tess_id, skycell_id, filter, mjd_obs),
     KEY (stack_type),
     KEY (mjd_obs),