Changeset 41071 for trunk/dbconfig/changes.txt

Timestamp:

Nov 7, 2019, 3:51:47 PM (7 years ago)

Author:

cclin33

Message:

let astrometry statistic results added into mysql database from smf file, add two extperl packages, modify dbconfig, add localhosttest reductionclasses for localhost test

File:

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

trunk/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;
+ALTER TABLE minidvodbProcessed ADD COLUMN hostname varchar(64) after fault;
+
+--
+UPDATE dbversion set schema_version = '1.1.81', updated= CURRENT_TIMESTAMP();
+--
+