Changeset 35472 for trunk/dbconfig/changes.txt

Timestamp:

May 2, 2013, 10:38:28 AM (13 years ago)

Author:

bills

Message:

add some keys to release tables to guarentee uniqueuness

File:

• trunk/dbconfig/changes.txt (modified) (2 diffs)

trunk/dbconfig/changes.txt

@@ -2400 +2400 @@
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
 
-UPDATE dbversion set schema_version = '1.1.75', updated= CURRENT_TIMESTAMP();
-
-
 -- new Postage Stamp Request columns
 -- Note: These do not aply to the gpc1 database because the pstamp tables were
@@ -2412 +2409 @@
 -- default to the gpc1 project
 UPDATE pstampRequest SET proj_id = 1;
+
+-- unique keys for the release tables
+
+alter table relStack  add unique key (rel_id, tess_id, skycell_id, filter, stack_type, mjd_obs)
+alter table relExp add UNIQUE KEY(rel_id, exp_id);
+alter table ippRelease add unique key (surveyID, release_name);
+
+UPDATE dbversion set schema_version = '1.1.75', updated= CURRENT_TIMESTAMP();