Changeset 35156

Timestamp:

Feb 12, 2013, 4:27:42 PM (13 years ago)

Author:

bills

Message:

schema version 1.1.75

drop warpBackgroundRun.alt_cam_label
add chipBackgroundRun.cam_id
change relStack to add stack_id and not require skycal_id so that nightly stacks can be released without calibration

File:

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

trunk/dbconfig/changes.txt

@@ -2320 +2320 @@
     relstack_id BIGINT AUTO_INCREMENT,
     rel_id      INT(8),
+    stack_id    BIGINT,         -- id of the stackRun
     skycal_id   BIGINT,         -- id of the sky calibration run that supplied the calibration
-                                -- for this release. We get back to stack from here
+                                -- for this release of this skycell.
     skycell_id  varchar(64),
     tess_id     varchar(64),
@@ -2337 +2338 @@
     KEY (rel_id, tess_id, skycell_id),
     FOREIGN KEY(rel_id) REFERENCES ippRelease(rel_id),
-    FOREIGN KEY(skycal_id) REFERENCES skycalRun(skycal_id)
-) ENGINE=innodb DEFAULT CHARSET=latin1;
-
-ALTER TABLE warpBackgroundRun ADD COLUMN alt_cam_label VARCHAR(255) AFTER reduction;
+    FOREIGN KEY(stack_id) REFERENCES stackRun(stack_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
+-- Add cam_id to chipBackgroundRun
+ALTER TABLE chipBackgroundRun ADD COLUMN cam_id BIGINT DEFAULT 0 AFTER chip_id;
 
 UPDATE dbversion set schema_version = '1.1.75', updated= CURRENT_TIMESTAMP();