metacat / src / xmltables-postgres.sql @ 6642

  • svn:eol-style: native
  • svn:executable: *
  • svn:keywords: Author Date Id Revision
# Date Author Comment
6561 10/27/2011 05:51 PM ben leinfelder

move the DataONE 1.0.0-SNAPSHOT

6542 10/20/2011 02:03 PM ben leinfelder

add User-Agent logging to support D1 requirements

6377 07/29/2011 10:40 AM ben leinfelder

remove ORE mapping from system metadata

6375 07/28/2011 05:11 PM ben leinfelder

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

6337 07/12/2011 03:02 PM ben leinfelder

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

6277 07/01/2011 12:35 PM ben leinfelder

allow for provisional SystemMetadata records (provisional=true)

6232 06/28/2011 10:13 AM ben leinfelder

add missing comma in xml_replication insert

6209 06/24/2011 09:31 PM ben leinfelder

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

6136 06/08/2011 05:08 PM ben leinfelder

add option for replicating system metadata (dataone)
also make sure the latest table changes are included in upgrade scripts

6122 06/06/2011 03:28 PM ben leinfelder

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

6107 05/27/2011 09:45 AM ben leinfelder

persist system metadata replication policy and status using db tables

6100 05/25/2011 12:05 PM ben leinfelder

remove docid and rev from systemMetadata table

6098 05/24/2011 04:26 PM ben leinfelder

add systemMetadataProvenance table for tracking those relationships

6012 03/16/2011 10:56 PM ben leinfelder

add support for temporal element query in pathquery

5917 02/04/2011 12:39 PM berkley

fixed bugs in listObjects

5887 02/02/2011 03:52 PM berkley

adding fields for additional system metadata info

5333 05/03/2010 03:05 PM berkley

adding a system to track system metadata documents for dataone

5276 03/16/2010 12:33 AM Matt Jones

Modified table structure to change identifiers table (previously unused) to
represent a mapping between arbitrary string identifiers and metacat docids.
More information in Modifications to
Oracle schemas were made but not tested.

5171 12/30/2009 09:21 AM daigle

add xml_revisions docid index

5027 08/14/2009 02:26 PM daigle

Change MetaCatVersion to MetacatVersion

4975 07/07/2009 10:20 AM daigle

Add upgrade scripts for 1.9.2 (scheduler tables)

4080 07/06/2008 09:25 PM daigle

Merge 1.9 changes into Head

3504 10/04/2007 03:55 PM Jing Tao

Add two indexes to improve deleting and update speed.

3412 09/10/2007 06:22 PM Jing Tao

Create index to speed deleting.

3352 08/08/2007 05:02 PM Jing Tao

Change the path data type to text

3347 08/07/2007 05:47 PM Jing Tao

Add new index into xml_index table.

3336 07/31/2007 04:07 PM Jing Tao

Change data type of columns to TEXT

3052 09/27/2006 04:21 PM Matt Jones

Modifications to the table definitions to add indices that should be used
when searching the database. Added an upgrade script to create these
indices as well. Modified to use the '=' comparator rather
than 'LIKE' so that we can do index scans rather than table scans. This needs...

2949 03/08/2006 02:33 PM berkley

fixed a bug with postgres 8.1.6 where the sequence must be created before the table is created.

2769 11/18/2005 05:10 PM Matt Jones

New SQL tables and db upgrade scripts that define a new table stucture for identifiers and delete the previously unused accession_number table. This is in anticipation of supporting LSID identifiers. Currently these tables are unused by the servlet but are in place for discussion.

2599 09/27/2005 04:48 PM Matt Jones

Refactored the build to use a <path> element for the classpath rather
than ant properties. This makes the classpath easier to manage, but required
changes throughout the build. I think everything should still build fine --
it works for me.

Upgraded the JDBC driver for postgres to the version 8 driver....

2519 07/25/2005 11:45 AM sgarg

Added code to create new tables xml_path_index and xml_nodes_revisions...

2515 07/21/2005 04:46 PM sgarg

Fixed bug in previous commit

2514 07/21/2005 04:31 PM sgarg

Modified postgres script so that:
1. Foreign key for rootnodeid in xml_revision points to xml_node_revision table instead of xml_nodes
2. Added a new table xml_path_index which is used to index the paths specified by user in
3. Addes a new table xml_nodes_revision which stores the nodes of old revisions and deleted documents...

2442 04/04/2005 10:12 AM sgarg

Removing code added for creating nodedata column in xml_index table

2422 03/17/2005 05:58 PM sgarg

Made changes in the sql scripts to create new tables xml_returnfield and xml_queryresult

2377 01/18/2005 12:17 PM sgarg

Modified xmltables to add nodedata as part of the xml_index tables.

2359 12/30/2004 03:51 PM sgarg

Modified database creation sql code so that in xml_nodes, nodedatanumerical coulmn is added.

2276 09/15/2004 08:56 AM Matt Jones

New schema changes, including upgrade scripts. Includes renamed postgres