Project

General

Profile

Statistics
| Revision:

metacat / src @ 8579

Name Size Revision Age Author Comment
  com 2532 about 14 years sgarg renaming enum to catalogEnum to prevent compila...
  edu 8579 over 5 years Peter Slaughter sync pids of <distribution><online> data object...
  org 5030 about 10 years daigle Change location of PropertyService to propertie...
  perl 8540 over 5 years Jing Tao Use an array of a hash to keep the orgName/orgL...
  php 3134 almost 13 years perry added gpl header to php metacat lib
  python 8265 about 6 years ben leinfelder Refer to metacat.war deployments since those ar...
  query-client 2824 almost 14 years tyburczy Unix port of transform.bat
  ruby 3132 almost 13 years perry Initial import of Chad Burt's ruby metacat client
  scripts 8549 over 5 years Jing Tao Add a note to let users know where to run the s...
LTER_DOI_conversion.sql 717 Bytes 7283 over 7 years ben leinfelder remove the non-doi identifiers before updating ...
addforeignkeyfortable.sql 135 Bytes 1626 over 16 years Jing Tao Create a foreign key for table accesssubtree.
alter-datafile-for-knbbackup.sql 1.66 KB 2662 about 14 years Jing Tao Add a new sql file to alter control file which ...
apply-xmlconstraints-postgres-knb.sql 6.23 KB 7181 over 7 years ben leinfelder script for re-applying missing FK constraints o...
clear.sql 312 Bytes 704 over 18 years berkley added removal of relations
convert_denyFirst.sql 2.12 KB 7227 over 7 years ben leinfelder script to aid in converting denyFirst rules to ...
delete-xml-documents.sql 937 Bytes 3123 almost 13 years Jing Tao Add a script to delete documents manually.
delete-xml-revisions.sql 110 Bytes 3125 almost 13 years Jing Tao Add a script can delete xml_revision records.
delete_all_by_pid.sql 4.1 KB 7392 about 7 years ben leinfelder shorten the systemmetadata* table names for Ora...
doi_registration.sql 27.9 KB 7416 almost 7 years ben leinfelder update pub_date when the length of that field i...
drop-postgres.sql 2.24 KB 5956 over 8 years Matt Jones Updated DROP script that was missing tables and...
increase-xml-queryresult-size-postgres.sql 952 Bytes 3297 over 12 years Jing Tao A sql to increase column size of queryresult_st...
loaddtd.sql 2.07 KB 4080 over 11 years daigle Merge 1.9 changes into Head
loaddtdschema-oracle.sql 5.57 KB 8555 over 5 years ben leinfelder use v2.4.0 for documentation and upgrade scripts.
loaddtdschema-postgres.sql 5.57 KB 8555 over 5 years ben leinfelder use v2.4.0 for documentation and upgrade scripts.
loadschema.sql 395 Bytes 4080 over 11 years daigle Merge 1.9 changes into Head
package-count.sql 373 Bytes 2283 about 15 years Matt Jones Added sql for counting packages.
rollback-db-from-1.9-oracle.sql 903 Bytes 4818 over 10 years daigle Add db rollback scripts
rollback-db-from-1.9-postgres.sql 465 Bytes 4818 over 10 years daigle Add db rollback scripts
showdoc.sql 340 Bytes 390 about 19 years Matt Jones Added new utility query to return all of the xm...
sqlcatlist.sql 253 Bytes 123 over 19 years Matt Jones Modifying storage model to use DOM TEXT nodes
sqldoclist.sql 209 Bytes 531 almost 19 years Matt Jones Changed utility query to include the user_owner...
sqlnodeslist.sql 94 Bytes 108 over 19 years Matt Jones added utility files and queries
sqlnodesview.sql 358 Bytes 166 over 19 years Matt Jones minor modifications to fix problems introduced ...
sqlrevisions.sql 205 Bytes 203 over 19 years Matt Jones Merged in substantial changes to DBWriter and a...
system_metadata_revisions.sql 1.6 KB 8366 almost 6 years ben leinfelder include update statement for marking newer revi...
tsvector.sql 788 Bytes 3751 over 11 years Jing Tao Add new code for xml_nodes table.
upgrade-db-to-1.2-oracle.sql 600 Bytes 4104 over 11 years daigle replace <script>.sql files with <script>-oracle...
upgrade-db-to-1.2-postgres.sql 637 Bytes 4080 over 11 years daigle Merge 1.9 changes into Head
upgrade-db-to-1.3-oracle.sql 1.44 KB 4104 over 11 years daigle replace <script>.sql files with <script>-oracle...
upgrade-db-to-1.3-postgres.sql 2.56 KB 4080 over 11 years daigle Merge 1.9 changes into Head
upgrade-db-to-1.4-oracle.sql 4.36 KB 4104 over 11 years daigle replace <script>.sql files with <script>-oracle...
upgrade-db-to-1.4-postgres.sql 5.03 KB 4080 over 11 years daigle Merge 1.9 changes into Head
upgrade-db-to-1.5-oracle.sql 5.9 KB 4413 about 11 years daigle Add nodedatanumerical column and associated pop...
upgrade-db-to-1.5-postgres.sql 5.65 KB 4080 over 11 years daigle Merge 1.9 changes into Head
upgrade-db-to-1.6-oracle.sql 9.66 KB 4414 about 11 years daigle Re-add the xml_node id trigger. In oracle, thi...
upgrade-db-to-1.6-postgres.sql 7.66 KB 4080 over 11 years daigle Merge 1.9 changes into Head
upgrade-db-to-1.7-oracle.sql 509 Bytes 4104 over 11 years daigle replace <script>.sql files with <script>-oracle...
upgrade-db-to-1.7-postgres.sql 509 Bytes 3052 about 13 years Matt Jones Modifications to the table definitions to add i...
upgrade-db-to-1.8-oracle.sql 214 Bytes 4104 over 11 years daigle replace <script>.sql files with <script>-oracle...
upgrade-db-to-1.8-postgres.sql 1.43 KB 3607 almost 12 years Jing Tao A file rename from 1.7.1 since we decide to rel...
upgrade-db-to-1.9-oracle.sql 1.03 KB 4818 over 10 years daigle Add db rollback scripts
upgrade-db-to-1.9-postgres.sql 903 Bytes 4797 over 10 years daigle Add the service registration xml schema to the ...
upgrade-db-to-1.9.1-oracle.sql 127 Bytes 4873 over 10 years daigle Update version to 1.9.1. Add nrs ldap properti...
upgrade-db-to-1.9.1-postgres.sql 125 Bytes 4873 over 10 years daigle Update version to 1.9.1. Add nrs ldap properti...
upgrade-db-to-1.9.2-oracle.sql 1.62 KB 7035 over 7 years ben leinfelder fixed Oracle script issues identified by: Brian...
upgrade-db-to-1.9.2-postgres.sql 1.34 KB 5012 about 10 years daigle Added end time to workflow scheduler.
upgrade-db-to-1.9.3-oracle.sql 127 Bytes 5507 about 9 years ben leinfelder add 1.9.3 upgrade scripts to trunk
upgrade-db-to-1.9.3-postgres.sql 125 Bytes 5507 about 9 years ben leinfelder add 1.9.3 upgrade scripts to trunk
upgrade-db-to-1.9.4-oracle.sql 127 Bytes 6209 over 8 years ben leinfelder merge changes from 1.9.5 branch for upgrade pro...
upgrade-db-to-1.9.4-postgres.sql 125 Bytes 6209 over 8 years ben leinfelder merge changes from 1.9.5 branch for upgrade pro...
upgrade-db-to-1.9.5-oracle.sql 195 Bytes 6209 over 8 years ben leinfelder merge changes from 1.9.5 branch for upgrade pro...
upgrade-db-to-1.9.5-postgres.sql 194 Bytes 6209 over 8 years ben leinfelder merge changes from 1.9.5 branch for upgrade pro...
upgrade-db-to-2.0.0-oracle.sql 8.21 KB 7392 about 7 years ben leinfelder shorten the systemmetadata* table names for Ora...
upgrade-db-to-2.0.0-postgres.sql 8.2 KB 7386 about 7 years ben leinfelder use correct column (guid) for temporary index
upgrade-db-to-2.0.1-oracle.sql 164 Bytes 7276 over 7 years ben leinfelder update for 2.0.1 upgrade -- scripts, docs, readme
upgrade-db-to-2.0.1-postgres.sql 163 Bytes 7276 over 7 years ben leinfelder update for 2.0.1 upgrade -- scripts, docs, readme
upgrade-db-to-2.0.2-oracle.sql 164 Bytes 7300 over 7 years ben leinfelder prep for 2.0.2 release by updating the version ...
upgrade-db-to-2.0.2-postgres.sql 163 Bytes 7300 over 7 years ben leinfelder prep for 2.0.2 release by updating the version ...
upgrade-db-to-2.0.3-oracle.sql 164 Bytes 7347 about 7 years ben leinfelder prep for 2.0.3 release
upgrade-db-to-2.0.3-postgres.sql 163 Bytes 7347 about 7 years ben leinfelder prep for 2.0.3 release
upgrade-db-to-2.0.4-oracle.sql 838 Bytes 7372 about 7 years ben leinfelder include missing identifier mappings during 2.0....
upgrade-db-to-2.0.4-postgres.sql 837 Bytes 7372 about 7 years ben leinfelder include missing identifier mappings during 2.0....
upgrade-db-to-2.0.5-oracle.sql 980 Bytes 7455 almost 7 years ben leinfelder additional db indexes for pathquery performance...
upgrade-db-to-2.0.5-postgres.sql 830 Bytes 7455 almost 7 years ben leinfelder additional db indexes for pathquery performance...
upgrade-db-to-2.0.6-oracle.sql 164 Bytes 7496 over 6 years ben leinfelder ready Metacat for 2.0.6 release (docs, db versi...
upgrade-db-to-2.0.6-postgres.sql 163 Bytes 7496 over 6 years ben leinfelder ready Metacat for 2.0.6 release (docs, db versi...
upgrade-db-to-2.0.7-oracle.sql 164 Bytes 7644 over 6 years ben leinfelder Use 2.0.7 version number in configuration/upgra...
upgrade-db-to-2.0.7-postgres.sql 163 Bytes 7644 over 6 years ben leinfelder Use 2.0.7 version number in configuration/upgra...
upgrade-db-to-2.0.8-oracle.sql 164 Bytes 7834 over 6 years ben leinfelder merging upgrade scripts from 2.0 branch to trun...
upgrade-db-to-2.0.8-postgres.sql 163 Bytes 7834 over 6 years ben leinfelder merging upgrade scripts from 2.0 branch to trun...
upgrade-db-to-2.1.0-oracle.sql 1.03 KB 8028 about 6 years ben leinfelder type the doctype="metadata" objects as "FGDC-ST...
upgrade-db-to-2.1.0-postgres.sql 1.02 KB 8028 about 6 years ben leinfelder type the doctype="metadata" objects as "FGDC-ST...
upgrade-db-to-2.1.1-oracle.sql 164 Bytes 8146 about 6 years ben leinfelder [merge from branch to keep trunk up to date wit...
upgrade-db-to-2.1.1-postgres.sql 163 Bytes 8146 about 6 years ben leinfelder [merge from branch to keep trunk up to date wit...
upgrade-db-to-2.2.0-oracle.sql 164 Bytes 8223 about 6 years ben leinfelder prep for 2.2.0 release. include configuration v...
upgrade-db-to-2.2.0-postgres.sql 163 Bytes 8223 about 6 years ben leinfelder prep for 2.2.0 release. include configuration v...
upgrade-db-to-2.2.1-oracle.sql 164 Bytes 8307 about 6 years ben leinfelder prep project for 2.2.1 patch release -- will al...
upgrade-db-to-2.2.1-postgres.sql 163 Bytes 8307 about 6 years ben leinfelder prep project for 2.2.1 patch release -- will al...
upgrade-db-to-2.3.0-oracle.sql 327 Bytes 8393 almost 6 years ben leinfelder add indices for access log performance during u...
upgrade-db-to-2.3.0-postgres.sql 327 Bytes 8393 almost 6 years ben leinfelder add indices for access log performance during u...
upgrade-db-to-2.3.1-oracle.sql 164 Bytes 8440 almost 6 years ben leinfelder prep for 2.3.1 release
upgrade-db-to-2.3.1-postgres.sql 164 Bytes 8440 almost 6 years ben leinfelder prep for 2.3.1 release
upgrade-db-to-2.4.0-oracle.sql 164 Bytes 8555 over 5 years ben leinfelder use v2.4.0 for documentation and upgrade scripts.
upgrade-db-to-2.4.0-postgres.sql 3.73 KB 8578 over 5 years ben leinfelder restrict the archived=false update to revisions...
xmlpackage.sql 1.94 KB 439 about 19 years berkley sql file defining the table structure for eml-p...
xmltables-oracle.sql 25.2 KB 8335 almost 6 years ben leinfelder add 2 indexes to speed up dataONE log retrieval...
xmltables-postgres.sql 22.3 KB 8335 almost 6 years ben leinfelder add 2 indexes to speed up dataONE log retrieval...
xmltables-sqlserver.sql 12.2 KB 6012 over 8 years ben leinfelder add support for temporal element query in pathq...

Latest revisions

# Date Author Comment
8579 02/07/2014 12:40 PM Peter Slaughter

sync pids of <distribution><online> data objects with CN when their access rules change in EML 2.0.* <additionalMetadata>

8578 02/07/2014 09:20 AM ben leinfelder

restrict the archived=false update to revisions that still have current entries in the xml_documents table.

8577 02/06/2014 05:36 PM ben leinfelder

tested the restore insertions - adjusted for FK constraints. I was able to delete a document locally, then restore it, then update the document with a new revision as expected.

8576 02/06/2014 03:03 PM ben leinfelder

use 'with' query to find the most recent revision of an object that was archived. still want more feedback on the criteria.

8575 02/06/2014 02:42 PM Jing Tao

Modified the usage.

8574 02/06/2014 11:56 AM ben leinfelder

continue to work on the criteria for selecting documents to restore.
expanded the criteria for setting archived=false to include any revision that was already obsoleted_by somethign else.

8572 02/05/2014 02:18 PM ben leinfelder

correct syntax - add more criteria for selecting documents.

8566 02/05/2014 01:55 PM ben leinfelder

do not set sm.archived=true when generating system metadata for objects that come in via the old Metacat API.

8565 02/05/2014 01:50 PM ben leinfelder

draft of fix for erroneously archived documents - first discovered by LTER - but also applicable to other Metacat MNs that still use the Metacat API as of Jan 2014 CN changes.

8564 02/05/2014 01:24 PM Jing Tao

Modify the usage message.

View revisions

Also available in: Atom