Changeset 42097 for trunk/ippTools/share

Timestamp:

Feb 28, 2022, 4:29:58 PM (4 years ago)

Author:

eugene

Message:

fix definition of a field in pxadmin_create_tables; add option to queue stacks with invalid input warps; add option to restrict stack query by spatial region

Location:

trunk/ippTools

Files:

• . (modified) (1 prop)
• share (modified) (1 prop)
• share/Makefile.am (modified) (1 diff)
• share/pxadmin_create_tables.sql (modified) (1 diff)
• share/stacktool_tosum_allstates.sql (copied) (copied from branches/eam_branches/ipp-20211108/ippTools/share/stacktool_tosum_allstates.sql )

trunk/ippTools/share/Makefile.am

@@ -421 +421 @@
         stacktool_sassskyfile.sql \
         stacktool_tosum.sql \
+        stacktool_tosum_allstates.sql \
         stacktool_tobkg.sql \
         stacktool_tosummary.sql \

trunk/ippTools/share/pxadmin_create_tables.sql

@@ -1453 +1453 @@
         username VARCHAR(255),
         proj_id BIGINT,
-        registered TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
+        registered datetime,
         timestamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
         fault SMALLINT,