Metacat

additional db indexes for pathquery performance
http://bugzilla.ecoinformatics.org/show_bug.cgi?id=5696

shorten the systemmetadata* table names for Oracle's 30 character limit. move version to 2.0.5. http://bugzilla.ecoinformatics.org/show_bug.cgi?id=5717

increase amount of text the 'xml_path_index.path' column can accommodate. I was seeing errors like this during indexing:
knb 20120312-11:42:05: [ERROR]: DocumentImpl.buildIndex - SQL Exception while indexing document knb-lter-and.3147 : ERROR: value too long for type character varying(1000) [edu.ucsb.nceas.metacat.DocumentImpl]

Added DOI generation to the 2.0.0 upgrade process. To succeed, this script must be run on a fresh 2.0.0 database, or on a 1.9.5 version database, as those are the only ways to get the needed foreign keys to be marked as deferrable. The identifier conversion must be turned on by setting correct properties in metacat.properties. See the comments in GenerateGlobalIdentifiers for details. By default, conversion is set to false in the properties file. If you want to convert an instance to use DOIs, be sure to set metacat.properties up BEFORE running through the Metacat configuration and database upgrade.

use larger ("text") db field for guid in the xml_access.accessfileid column

remove flag for independent system metadata replication -- these entries are replicated along with the data/metadata objects or via hazelcast when the actual object is not on the server.

include 'archived' system metadata element in backing DB store

remove docid column in favor of guid
http://bugzilla.ecoinformatics.org/show_bug.cgi?id=5560

move the DataONE 1.0.0-SNAPSHOT

add User-Agent logging to support D1 requirements

remove ORE mapping from system metadata

include obsoletes and obsoletedBy for system metadata
repurpose the "provenance" table as the ORE mapping table for system metadata

use objectFormatIdentifier for listObjects()
remove provisional system metadata indicator - Metacat will not implement reserveIdentifier()

allow for provisional SystemMetadata records (provisional=true)

merge changes from 1.9.5 branch for upgrade process (1.9.3->1.9.4->1.9.5)

add option for replicating system metadata (dataone)
https://redmine.dataone.org/issues/1626
also make sure the latest table changes are included in upgrade scripts

include GUID column for xml_access and related methods for storing/retrieving access rules

persist system metadata replication policy and status using db tables

remove docid and rev from systemMetadata table

add systemMetadataProvenance table for tracking those relationships

add support for temporal element query in pathquery
http://bugzilla.ecoinformatics.org/show_bug.cgi?id=2084

fixed bugs in listObjects

adding fields for additional system metadata info

added systemMetadata table to the upgrade scripts

Modified table structure to change identifiers table (previously unused) to
represent a mapping between arbitrary string identifiers and metacat docids.
More information in https://trac.dataone.org/ticket/361. Modifications to
Oracle schemas were made but not tested.

Add upgrade scripts for 1.9.2 (scheduler tables)

Add additional indexed to match postgres scripts

replace <script>.sql files with <script>-oracle.sql files since the base files are implicitly oracle scripts