Project

General

Profile

Statistics
| Revision:

metacat/src @ 2530

Name Size Revision Age Author Comment
  com 2447 over 19 years sgarg Removed occurence of enum which is a keyword in...
  edu 2526 over 19 years sgarg Bugfix to the previous commit. Also made chang...
  perl 2499 over 19 years sgarg Adding perl script for changing ldap password f...
addforeignkeyfortable.sql 135 Bytes 1626 over 21 years Jing Tao Create a foreign key for table accesssubtree.
clear.sql 312 Bytes 704 almost 24 years berkley added removal of relations
drop-postgres.sql 1.93 KB 2457 over 19 years Matt Jones dropping the sequences as well in the postgres ...
loaddtd.sql 2.36 KB 979 over 22 years Jing Tao Change every "http://@server@ to "@systemidserv...
loaddtdschema.sql 2.92 KB 2394 over 19 years sgarg Added sql command to delete also schema entries...
loadschema.sql 476 Bytes 2229 over 20 years sgarg Modified directory name for eml-2.0.x checkouts...
package-count.sql 373 Bytes 2283 about 20 years Matt Jones Added sql for counting packages.
showdoc.sql 340 Bytes 390 over 24 years Matt Jones Added new utility query to return all of the xm...
sqlcatlist.sql 253 Bytes 123 over 24 years Matt Jones Modifying storage model to use DOM TEXT nodes
sqldoclist.sql 209 Bytes 531 about 24 years Matt Jones Changed utility query to include the user_owner...
sqlnodeslist.sql 94 Bytes 108 over 24 years Matt Jones added utility files and queries
sqlnodesview.sql 358 Bytes 166 over 24 years Matt Jones minor modifications to fix problems introduced ...
sqlrevisions.sql 205 Bytes 203 over 24 years Matt Jones Merged in substantial changes to DBWriter and a...
upgrade-db-to-1.2-postgres.sql 637 Bytes 2276 about 20 years Matt Jones New schema changes, including upgrade scripts. ...
upgrade-db-to-1.2.sql 596 Bytes 1827 about 21 years Matt Jones Renamed the upgrade sql files to more understan...
upgrade-db-to-1.3-postgres.sql 2.56 KB 2276 about 20 years Matt Jones New schema changes, including upgrade scripts. ...
upgrade-db-to-1.3.sql 1.44 KB 1827 about 21 years Matt Jones Renamed the upgrade sql files to more understan...
upgrade-db-to-1.4-postgres.sql 5.11 KB 2314 about 20 years sgarg Added code that changes the node column size
upgrade-db-to-1.4.sql 4.44 KB 2279 about 20 years Matt Jones Added lines for updating xml_catalog in the upg...
upgrade-db-to-1.5-postgres.sql 6.13 KB 2504 over 19 years sgarg Making changes in postgres db upgrade script su...
upgrade-db-to-1.5.sql 5.79 KB 2443 over 19 years sgarg Removed the code which created triggers. Added ...
upgrade-db-to-1.6-postgres.sql 7.45 KB 2530 over 19 years sgarg Changes to the upgrade script so that 'IN' and ...
upgrade-db-to-1.6.sql 5.54 KB 2520 over 19 years sgarg Adding new files for upgrading version 1.5 data...
upgrade_db_to_1_5.java 4.83 KB 2504 over 19 years sgarg Making changes in postgres db upgrade script su...
xmlpackage.sql 1.94 KB 439 about 24 years berkley sql file defining the table structure for eml-p...
xmltables-postgres.sql 16.2 KB 2519 over 19 years sgarg Added code to create new tables xml_path_index ...
xmltables-sqlserver.sql 11.8 KB 2359 almost 20 years sgarg Modified database creation sql code so that in ...
xmltables.sql 19.1 KB 2519 over 19 years sgarg Added code to create new tables xml_path_index ...

Latest revisions

# Date Author Comment
2530 08/01/2005 09:29 AM sgarg

Changes to the upgrade script so that 'IN' and 'NOT IN' are not used in the queries and hence the upgrade script is much faster.
2526 07/26/2005 09:17 AM sgarg

Bugfix to the previous commit.

Also made changes so that while indexing the path in buildIndex(), instead of seperate database calls to the database for each path, one call is made with all the paths in it.
2524 07/25/2005 11:57 AM sgarg

Modified code to enter/remove data from xml_path_index and enter data into xml_nodes_revision when action=insert, update and delete are performed.
2523 07/25/2005 11:54 AM sgarg

Check if all the paths in returnfield are indexed. If yes, then you xml_path_index for getting values of returnfields instead of using xml_nodes + xml_index
2522 07/25/2005 11:52 AM sgarg

Adding code to check if all the paths being searched for indexed are not. If all paths are indexed, the code will use xml_path_index instead of using xml_nodes and xml_index
2521 07/25/2005 11:49 AM sgarg

Adding a new method to MetaCatServlet for getting the value of paths to be indexed from metacat.properties file and indexing those paths in xml_path_index
2520 07/25/2005 11:45 AM sgarg

Adding new files for upgrading version 1.5 database to version 1.6 database
2519 07/25/2005 11:45 AM sgarg

Added code to create new tables xml_path_index and xml_nodes_revisions...
2517 07/21/2005 04:54 PM sgarg

Changed the name of the function
2516 07/21/2005 04:52 PM sgarg

Modified xmltables 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

View revisions

Also available in: Atom