Changeset 40946

Timestamp:

Oct 17, 2019, 3:05:28 PM (7 years ago)

Author:

cclin33

Message:

update camProcessedExp and addRun tables

File:

• branches/ccl_branches/ipp-20190806/dbconfig/changes.txt (modified) (1 diff)

branches/ccl_branches/ipp-20190806/dbconfig/changes.txt

@@ -2532 +2532 @@
 
 --
+
 ALTER TABLE ippRelease ADD COLUMN accessLevelMin INT DEFAULT 0 AFTER ubercal_file 
+
+-- Update camProcessedExp to store astrometry results from smfs --
+
+ALTER TABLE camProcessedExp ADD COLUMN ast_r0 FLOAT after astrom_chips;
+ALTER TABLE camProcessedExp ADD COLUMN ast_d0 FLOAT after ast_r0;
+ALTER TABLE camProcessedExp ADD COLUMN ast_t0 FLOAT after ast_d0;
+ALTER TABLE camProcessedExp ADD COLUMN ast_s0 FLOAT after ast_t0;
+ALTER TABLE camProcessedExp ADD COLUMN ast_rs FLOAT after ast_s0;
+ALTER TABLE camProcessedExp ADD COLUMN ast_ds FLOAT after ast_rs;
+
+-- Update addRun to store hostname info --
+
+ALTER TABLE addRun ADD COLUMN hostname varchar(64) after minidvodb_name;
+
+--
+UPDATE dbversion set schema_version = '1.1.81', updated= CURRENT_TIMESTAMP();
+--
+