Changeset 41071 for trunk/dbconfig

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

Location:

trunk/dbconfig

Files:

• cam.md (modified) (1 diff)
• changes.txt (modified) (1 diff)

trunk/dbconfig/cam.md

@@ -120 +120 @@
     background_model  S16   0
     astrom_chips   S64      0
+    ast_r0         F32      0.0 
+    ast_d0         F32      0.0 
+    ast_t0         F32      0.0 
+    ast_s0         F32      0.0 
+    ast_rs         F32      0.0 
+    ast_ds         F32      0.0 
 END
 

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();
+--
+