Project

General

Profile

Download (17.2 KB) Statistics
| Revision:

metacat/src/xmltables-postgres.sql @ 4044

  • svn:eol-style: native
  • svn:executable: *
  • svn:keywords: Author Date Id Revision

# Date Author Comment
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 QueryTerm.java 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 metacat.properties
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
scripts.