Metacat

Change the path data type to text

Add new index into xml_index table.

Change data type of columns to TEXT

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 QueryTerm.java to use the '=' comparator rather
than 'LIKE' so that we can do index scans rather than table scans. This needs...

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

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.

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....

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

Fixed bug in previous commit

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 metacat.properties
3. Addes a new table xml_nodes_revision which stores the nodes of old revisions and deleted documents...

Removing code added for creating nodedata column in xml_index table

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

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

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

New schema changes, including upgrade scripts. Includes renamed postgres
scripts.