Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  com 71 over 24 years higgins Catalog files from arbortext added
  edu 2424 almost 20 years sgarg Added code such that an offset can be specified...
  perl 2416 almost 20 years sgarg Changes made in the css for the skins.
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.8 KB 2276 over 20 years Matt Jones New schema changes, including upgrade scripts. ...
loaddtd.sql 2.36 KB 979 over 22 years Jing Tao Change every "http://@server@ to "@systemidserv...
loaddtdschema.sql 2.92 KB 2394 almost 20 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 over 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 over 20 years Matt Jones New schema changes, including upgrade scripts. ...
upgrade-db-to-1.2.sql 596 Bytes 1827 over 21 years Matt Jones Renamed the upgrade sql files to more understan...
upgrade-db-to-1.3-postgres.sql 2.56 KB 2276 over 20 years Matt Jones New schema changes, including upgrade scripts. ...
upgrade-db-to-1.3.sql 1.44 KB 1827 over 21 years Matt Jones Renamed the upgrade sql files to more understan...
upgrade-db-to-1.4-postgres.sql 5.11 KB 2314 over 20 years sgarg Added code that changes the node column size
upgrade-db-to-1.4.sql 4.44 KB 2279 over 20 years Matt Jones Added lines for updating xml_catalog in the upg...
upgrade-db-to-1.5.sql 4.06 KB 2423 almost 20 years Jing Tao Modify the update for xml_relation.
upgrade_db_to_1_5.java 7.8 KB 2379 almost 20 years sgarg nodedata added to xml_index for nodes with node...
xmlpackage.sql 1.94 KB 439 over 24 years berkley sql file defining the table structure for eml-p...
xmltables-postgres.sql 13.3 KB 2422 almost 20 years sgarg Made changes in the sql scripts to create new t...
xmltables-sqlserver.sql 11.8 KB 2359 almost 20 years sgarg Modified database creation sql code so that in ...
xmltables.sql 15.8 KB 2422 almost 20 years sgarg Made changes in the sql scripts to create new t...

Latest revisions

# Date Author Comment
2424 03/18/2005 08:51 AM sgarg

Added code such that an offset can be specified in metacat.properties for entering records into xml_queryresult table. The value of xml_returnfield.usage_count should be more than the value specified in metacat.properties for records to be entered into xml_queryresult. so if you want results for any combination of returnfields should be stored in xml_queryresult only after that combination has been requested 50 times, set this value to 50

2423 03/17/2005 06:52 PM Jing Tao

Modify the update for xml_relation.

2422 03/17/2005 05:58 PM sgarg

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

2421 03/17/2005 05:26 PM sgarg

Changes for entering new records into xml_queryresult:

1. Added a function which checks if there is a record exsists in xml_returnfield table for a given combination of return fields. If a record is found, the id for the record is returned. otherwise a new record is created in the xml_returnfield table and the id of the new record is returned....

2420 03/17/2005 04:48 PM sgarg

Added code for updating xml_queryresult for action=delete and action=update

For both actions, the entries in xml_queryresult are deleted.
This works for action=update because deletion of entry is simple and the entries will be created again when the docid is part of a search result next time.

2419 03/17/2005 04:42 PM sgarg

Added a function which gives back a string which is generated by sorting the returnfields requested for given query specifications

2416 03/16/2005 03:48 PM sgarg

Changes made in the css for the skins.

2415 03/16/2005 03:41 PM sgarg

Fixed some bugs from previous commits. Veronique changes the text of error messages. Added a new stage to distinguish errors because of logins.

2414 03/16/2005 03:37 PM sgarg

Added new actions so that error message is not shown the first time resetPassword and changePasswords are called. Also fixed a bug where $cfg was not being passed to genericHeader.tmpl

2406 03/10/2005 11:47 AM sgarg

Modified the offset which is used for creating the resultset. This helps in fixing the 'more than 1000 enteries in IN query' bug on Oracle.

View revisions

Also available in: Atom