Changeset 35550 for branches/eam_branches/ipp-20130419/dbconfig

Timestamp:

May 9, 2013, 11:30:54 AM (13 years ago)

Author:

eugene

Message:

merge changes from trunk

Location:

branches/eam_branches/ipp-20130419/dbconfig

Files:

• cam.md (modified) (1 prop)
• changes.txt (modified) (2 diffs, 1 prop)

branches/eam_branches/ipp-20130419/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();