Changeset 41071 for trunk/ippTools/share

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/ippTools/share/pxadmin_create_tables.sql (modified) (4 diffs)

trunk/ippTools/share/pxadmin_create_tables.sql

@@ -524 +524 @@
     background_model SMALLINT,
     astrom_chips BIGINT,
+    ast_r0 FLOAT,
+    ast_d0 FLOAT,
+    ast_t0 FLOAT,
+    ast_s0 FLOAT,
+    ast_rs FLOAT,
+    ast_ds FLOAT,
     PRIMARY KEY(cam_id),
     KEY(fault),
@@ -539 +545 @@
     stage VARCHAR(64),
     stage_id BIGINT,
+    stage_extra1 INT,
     state VARCHAR(64),
     workdir VARCHAR(255),
@@ -1447 +1454 @@
         proj_id BIGINT,
         registered TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
-        timestamp TIMESTAMP,
+        timestamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
         fault SMALLINT,
         PRIMARY KEY(req_id),
@@ -2202 +2209 @@
     dvodb       VARCHAR(255),
     ubercal_file VARCHAR(255),
+    accessLevelMin INT DEFAULT 0,
     PRIMARY KEY(rel_id),
     UNIQUE KEY(surveyID, release_name),