Project

General

Profile

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

Latest revisions

# Date Author Comment
2504 04/22/2005 04:05 PM sgarg

Making changes in postgres db upgrade script such that instead of JDBC, SQL is used for updating the DB

2503 04/22/2005 02:18 PM sgarg

Fixed a bug in printSQL function. The bug came into the picture for queries which involve multiple query groups and one of the query groups does a % search.

2499 04/19/2005 12:11 PM sgarg

Adding perl script for changing ldap password for an account.

2491 04/14/2005 07:44 PM sgarg

Added code to delete all entries in xml_queryresult table when buildIndex for a docid is called.

2489 04/14/2005 01:51 PM sgarg

Adding the call to normalize function for now -- too many calls to normalize function are made and this needs to be looked into. Removing call to normalize function caused trouble in text like this "A&B"

2487 04/13/2005 06:22 PM sgarg

Fixed a bug in last commit. Doing a search like
pathquery version="1.2">
<returndoctype>eml://ecoinformatics.org/eml-2.0.0</returndoctype><returnfield>originator/individualName/surName</returnfield><querygroup operator="INTERSECT"><queryterm casesensitive="false" searchmode="contains"><value>%</value></queryterm><queryterm casesensitive="false" searchmode="contains"><value>National Center for Ecological Analysis and Synthesis</value><pathexpr>organizationName</pathexpr></queryterm></querygroup></pathquery>...

2486 04/13/2005 11:38 AM sgarg

Fixed a bug - when returnfield_id is not found in xml_returnfield, records are not added to xml_queryresults

2484 04/12/2005 11:44 PM Matt Jones

Modified the upgrade java script to provide more effective feedback during the
nodedata copy operation so that users don't think it has failed or crashed.

2478 04/08/2005 01:34 PM sgarg

Modified the code so that lastid file is created in a skin when lastid file is not found.
Commented out the code which uses AdminDB module and uncommented the test function.

2474 04/07/2005 05:04 PM sgarg

1. removed the call to QuerySpecification.printAttributeSQL() from QuerySpecification.printExtendedSQL()
2. in QuerySpecification.printExtendedSQL() if ( returnFieldList.size() == 0 ) then it returns null
3. DBQuery.addReturnfield() doesnt execute the element query if printExtendedSQL returns null

View revisions

Also available in: Atom