Merge 1.9 changes into Head
Add two indexes to improve deleting and update speed.
Create index to speed deleting.
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 usedwhen searching the database. Added an upgrade script to create theseindices as well. Modified QueryTerm.java to use the '=' comparator ratherthan '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 ratherthan ant properties. This makes the classpath easier to manage, but requiredchanges 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_nodes2. Added a new table xml_path_index which is used to index the paths specified by user in metacat.properties3. 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 postgresscripts.