Changeset 32609 for trunk/dbconfig/changes.txt

Timestamp:

Nov 3, 2011, 2:50:40 PM (15 years ago)

Author:

bills

Message:

Change PRIMARY KEY for diffInputSkyfile from (diff_id, skycell_id) to diff_skyfile_id.
This allows skycell_id to be NULL which we use in diftool -definewarpwarp to handle
the case where a pair of warps gets selected when there are actually no overlapping skycells.
We insert a diffInputSkyfile with the two warp_ids and skycell_id NULL. Then we set the
run to 'full'.
Change pubtool -definerun to not attempt to queue publishRuns for diffs in this state and
also fix the bug where publishRuns get queued even if all skycells for a diff have bad
quality

File:

• trunk/dbconfig/changes.txt (modified) (1 diff)

trunk/dbconfig/changes.txt

@@ -2172 +2172 @@
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
 
-
+-- changes to prevent repeatedly queueing diffRuns for warps with no overlaps
+ALTER TABLE diffInputSkyfile DROP PRIMARY KEY, ADD PRIMARY KEY(diff_skyfile_id);
+ALTER TABLE diffInputSkyfile CHANGE COLUMN skycell_id  skycell_id VARCHAR(64) DEFAULT NULL;
+
+UPDATE dbversion set schema_version = '1.1.71', updated= CURRENT_TIMESTAMP();