Metacat

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.