Changeset 40953

Timestamp:

Oct 20, 2019, 10:19:11 PM (7 years ago)

Author:

cclin33

Message:

update camProcessedExp, addRun, minidvodbProcessed, ippRelease tables

File:

• branches/ccl_branches/ipp-20190806/ippTools/share/pxadmin_create_tables.sql (modified) (4 diffs)

branches/ccl_branches/ipp-20190806/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),
@@ -551 +557 @@
     minidvodb_group VARCHAR(64),
     minidvodb_name VARCHAR(64),
+    hostname VARCHAR(64),
     PRIMARY KEY(add_id),
     KEY(add_id),
@@ -2027 +2034 @@
       epoch timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
       fault SMALLINT NOT NULL,
+      hostname varchar(64),
       UNIQUE KEY (minidvodb_id),
       KEY(minidvodb_id),
@@ -2202 +2210 @@
     dvodb       VARCHAR(255),
     ubercal_file VARCHAR(255),
+    accessLevelMin INT DEFAULT 0,
     PRIMARY KEY(rel_id),
     UNIQUE KEY(surveyID, release_name),