Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  com 2532 almost 19 years sgarg renaming enum to catalogEnum to prevent compila...
  edu 10207 over 7 years Jing Tao Move a statement e.printStactTrace to the logMe...
  org 5030 almost 15 years daigle Change location of PropertyService to propertie...
  perl 10206 over 7 years Chris Jones Add the 'Collaborator' role to the list of role...
  php 3134 over 17 years perry added gpl header to php metacat lib
  python 8265 almost 11 years ben leinfelder Refer to metacat.war deployments since those ar...
  query-client 2824 over 18 years tyburczy Unix port of transform.bat
  ruby 3132 over 17 years perry Initial import of Chad Burt's ruby metacat client
  scripts 9521 over 8 years Chris Jones In order to access the JWT authentication token...
LTER_DOI_conversion.sql 717 Bytes 7283 about 12 years ben leinfelder remove the non-doi identifiers before updating ...
addforeignkeyfortable.sql 135 Bytes 1626 about 21 years Jing Tao Create a foreign key for table accesssubtree.
alter-datafile-for-knbbackup.sql 1.66 KB 2662 almost 19 years Jing Tao Add a new sql file to alter control file which ...
apply-xmlconstraints-postgres-knb.sql 6.23 KB 7181 about 12 years ben leinfelder script for re-applying missing FK constraints o...
clear.sql 312 Bytes 704 over 23 years berkley added removal of relations
convert_denyFirst.sql 2.12 KB 7227 about 12 years ben leinfelder script to aid in converting denyFirst rules to ...
delete-xml-documents.sql 937 Bytes 3123 over 17 years Jing Tao Add a script to delete documents manually.
delete-xml-revisions.sql 110 Bytes 3125 over 17 years Jing Tao Add a script can delete xml_revision records.
delete_all_by_pid.sql 4.31 KB 8846 almost 10 years Jing Tao Add the code to delete the records in the xml_a...
doi_registration.sql 27.9 KB 7416 over 11 years ben leinfelder update pub_date when the length of that field i...
drop-postgres.sql 2.24 KB 5956 over 13 years Matt Jones Updated DROP script that was missing tables and...
increase-xml-queryresult-size-postgres.sql 952 Bytes 3297 about 17 years Jing Tao A sql to increase column size of queryresult_st...
loaddtd.sql 2.07 KB 4080 about 16 years daigle Merge 1.9 changes into Head
loaddtdschema-oracle.sql 9.08 KB 9553 over 8 years Jing Tao Change the version to 2.6.0
loaddtdschema-postgres.sql 12.3 KB 10213 over 7 years Jing Tao Change the version to 2.9.0
loadschema.sql 395 Bytes 4080 about 16 years daigle Merge 1.9 changes into Head
package-count.sql 373 Bytes 2283 almost 20 years Matt Jones Added sql for counting packages.
rollback-db-from-1.9-oracle.sql 903 Bytes 4818 over 15 years daigle Add db rollback scripts
rollback-db-from-1.9-postgres.sql 465 Bytes 4818 over 15 years daigle Add db rollback scripts
showdoc.sql 340 Bytes 390 almost 24 years Matt Jones Added new utility query to return all of the xm...
sqlcatlist.sql 253 Bytes 123 about 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 about 24 years Matt Jones added utility files and queries
sqlnodesview.sql 358 Bytes 166 about 24 years Matt Jones minor modifications to fix problems introduced ...
sqlrevisions.sql 205 Bytes 203 about 24 years Matt Jones Merged in substantial changes to DBWriter and a...
system_metadata_revisions.sql 1.6 KB 8366 over 10 years ben leinfelder include update statement for marking newer revi...
tsvector.sql 788 Bytes 3751 over 16 years Jing Tao Add new code for xml_nodes table.
upgrade-db-to-1.2-oracle.sql 600 Bytes 4104 about 16 years daigle replace <script>.sql files with <script>-oracle...
upgrade-db-to-1.2-postgres.sql 637 Bytes 4080 about 16 years daigle Merge 1.9 changes into Head
upgrade-db-to-1.3-oracle.sql 1.44 KB 4104 about 16 years daigle replace <script>.sql files with <script>-oracle...
upgrade-db-to-1.3-postgres.sql 2.56 KB 4080 about 16 years daigle Merge 1.9 changes into Head
upgrade-db-to-1.4-oracle.sql 4.36 KB 4104 about 16 years daigle replace <script>.sql files with <script>-oracle...
upgrade-db-to-1.4-postgres.sql 5.03 KB 4080 about 16 years daigle Merge 1.9 changes into Head
upgrade-db-to-1.5-oracle.sql 5.9 KB 4413 almost 16 years daigle Add nodedatanumerical column and associated pop...
upgrade-db-to-1.5-postgres.sql 5.65 KB 4080 about 16 years daigle Merge 1.9 changes into Head
upgrade-db-to-1.6-oracle.sql 9.66 KB 4414 almost 16 years daigle Re-add the xml_node id trigger. In oracle, thi...
upgrade-db-to-1.6-postgres.sql 7.66 KB 4080 about 16 years daigle Merge 1.9 changes into Head
upgrade-db-to-1.7-oracle.sql 509 Bytes 4104 about 16 years daigle replace <script>.sql files with <script>-oracle...
upgrade-db-to-1.7-postgres.sql 509 Bytes 3052 almost 18 years Matt Jones Modifications to the table definitions to add i...
upgrade-db-to-1.8-oracle.sql 214 Bytes 4104 about 16 years daigle replace <script>.sql files with <script>-oracle...
upgrade-db-to-1.8-postgres.sql 1.43 KB 3607 over 16 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 15 years daigle Add db rollback scripts
upgrade-db-to-1.9-postgres.sql 903 Bytes 4797 over 15 years daigle Add the service registration xml schema to the ...
upgrade-db-to-1.9.1-oracle.sql 127 Bytes 4873 over 15 years daigle Update version to 1.9.1. Add nrs ldap properti...
upgrade-db-to-1.9.1-postgres.sql 125 Bytes 4873 over 15 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 12 years ben leinfelder fixed Oracle script issues identified by: Brian...
upgrade-db-to-1.9.2-postgres.sql 1.34 KB 5012 almost 15 years daigle Added end time to workflow scheduler.
upgrade-db-to-1.9.3-oracle.sql 127 Bytes 5507 almost 14 years ben leinfelder add 1.9.3 upgrade scripts to trunk
upgrade-db-to-1.9.3-postgres.sql 125 Bytes 5507 almost 14 years ben leinfelder add 1.9.3 upgrade scripts to trunk
upgrade-db-to-1.9.4-oracle.sql 127 Bytes 6209 about 13 years ben leinfelder merge changes from 1.9.5 branch for upgrade pro...
upgrade-db-to-1.9.4-postgres.sql 125 Bytes 6209 about 13 years ben leinfelder merge changes from 1.9.5 branch for upgrade pro...
upgrade-db-to-1.9.5-oracle.sql 195 Bytes 6209 about 13 years ben leinfelder merge changes from 1.9.5 branch for upgrade pro...
upgrade-db-to-1.9.5-postgres.sql 194 Bytes 6209 about 13 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 almost 12 years ben leinfelder shorten the systemmetadata* table names for Ora...
upgrade-db-to-2.0.0-postgres.sql 8.2 KB 7386 almost 12 years ben leinfelder use correct column (guid) for temporary index
upgrade-db-to-2.0.1-oracle.sql 164 Bytes 7276 about 12 years ben leinfelder update for 2.0.1 upgrade -- scripts, docs, readme
upgrade-db-to-2.0.1-postgres.sql 163 Bytes 7276 about 12 years ben leinfelder update for 2.0.1 upgrade -- scripts, docs, readme
upgrade-db-to-2.0.2-oracle.sql 164 Bytes 7300 about 12 years ben leinfelder prep for 2.0.2 release by updating the version ...
upgrade-db-to-2.0.2-postgres.sql 163 Bytes 7300 about 12 years ben leinfelder prep for 2.0.2 release by updating the version ...
upgrade-db-to-2.0.3-oracle.sql 164 Bytes 7347 almost 12 years ben leinfelder prep for 2.0.3 release
upgrade-db-to-2.0.3-postgres.sql 163 Bytes 7347 almost 12 years ben leinfelder prep for 2.0.3 release
upgrade-db-to-2.0.4-oracle.sql 838 Bytes 7372 almost 12 years ben leinfelder include missing identifier mappings during 2.0....
upgrade-db-to-2.0.4-postgres.sql 837 Bytes 7372 almost 12 years ben leinfelder include missing identifier mappings during 2.0....
upgrade-db-to-2.0.5-oracle.sql 980 Bytes 7455 over 11 years ben leinfelder additional db indexes for pathquery performance...
upgrade-db-to-2.0.5-postgres.sql 830 Bytes 7455 over 11 years ben leinfelder additional db indexes for pathquery performance...
upgrade-db-to-2.0.6-oracle.sql 164 Bytes 7496 over 11 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 11 years ben leinfelder ready Metacat for 2.0.6 release (docs, db versi...
upgrade-db-to-2.0.7-oracle.sql 164 Bytes 7644 about 11 years ben leinfelder Use 2.0.7 version number in configuration/upgra...
upgrade-db-to-2.0.7-postgres.sql 163 Bytes 7644 about 11 years ben leinfelder Use 2.0.7 version number in configuration/upgra...
upgrade-db-to-2.0.8-oracle.sql 164 Bytes 7834 about 11 years ben leinfelder merging upgrade scripts from 2.0 branch to trun...
upgrade-db-to-2.0.8-postgres.sql 163 Bytes 7834 about 11 years ben leinfelder merging upgrade scripts from 2.0 branch to trun...
upgrade-db-to-2.1.0-oracle.sql 1.03 KB 8028 almost 11 years ben leinfelder type the doctype="metadata" objects as "FGDC-ST...
upgrade-db-to-2.1.0-postgres.sql 1.02 KB 8028 almost 11 years ben leinfelder type the doctype="metadata" objects as "FGDC-ST...
upgrade-db-to-2.1.1-oracle.sql 164 Bytes 8146 almost 11 years ben leinfelder [merge from branch to keep trunk up to date wit...
upgrade-db-to-2.1.1-postgres.sql 163 Bytes 8146 almost 11 years ben leinfelder [merge from branch to keep trunk up to date wit...
upgrade-db-to-2.2.0-oracle.sql 164 Bytes 8223 almost 11 years ben leinfelder prep for 2.2.0 release. include configuration v...
upgrade-db-to-2.2.0-postgres.sql 163 Bytes 8223 almost 11 years ben leinfelder prep for 2.2.0 release. include configuration v...
upgrade-db-to-2.2.1-oracle.sql 164 Bytes 8307 almost 11 years ben leinfelder prep project for 2.2.1 patch release -- will al...
upgrade-db-to-2.2.1-postgres.sql 163 Bytes 8307 almost 11 years ben leinfelder prep project for 2.2.1 patch release -- will al...
upgrade-db-to-2.3.0-oracle.sql 327 Bytes 8393 over 10 years ben leinfelder add indices for access log performance during u...
upgrade-db-to-2.3.0-postgres.sql 327 Bytes 8393 over 10 years ben leinfelder add indices for access log performance during u...
upgrade-db-to-2.3.1-oracle.sql 164 Bytes 8440 over 10 years ben leinfelder prep for 2.3.1 release
upgrade-db-to-2.3.1-postgres.sql 164 Bytes 8440 over 10 years ben leinfelder prep for 2.3.1 release
upgrade-db-to-2.4.0-oracle.sql 3.03 KB 8617 over 10 years Chris Jones Add in Darwin Core schema support into xml_cata...
upgrade-db-to-2.4.0-postgres.sql 5.77 KB 8642 over 10 years ben leinfelder merge recent upgrade changes from 2.4 branch
upgrade-db-to-2.4.1-oracle.sql 165 Bytes 8655 over 10 years ben leinfelder simple upgrade scripts for version 2.4.1
upgrade-db-to-2.4.1-postgres.sql 165 Bytes 8655 over 10 years ben leinfelder simple upgrade scripts for version 2.4.1
upgrade-db-to-2.4.2-oracle.sql 334 Bytes 8993 over 9 years Chris Jones Merge changes in the 2.4 branch into the trunk ...
upgrade-db-to-2.4.2-postgres.sql 334 Bytes 8993 over 9 years Chris Jones Merge changes in the 2.4 branch into the trunk ...
upgrade-db-to-2.4.3-oracle.sql 165 Bytes 9172 over 9 years ben leinfelder include 2.4.3 upgrade scripts in the trunk (mer...
upgrade-db-to-2.4.3-postgres.sql 165 Bytes 9172 over 9 years ben leinfelder include 2.4.3 upgrade scripts in the trunk (mer...
upgrade-db-to-2.5.0-oracle.sql 3.76 KB 9243 about 9 years Jing Tao Add the code to insert entries in xml_catalog f...
upgrade-db-to-2.5.0-postgres.sql 3.8 KB 9435 over 8 years Jing Tao Reset the xml_catalog_id sequence value to the ...
upgrade-db-to-2.5.1-oracle.sql 164 Bytes 9449 over 8 years Jing Tao Add the sql file for the upgrading.
upgrade-db-to-2.5.1-postgres.sql 299 Bytes 9449 over 8 years Jing Tao Add the sql file for the upgrading.
upgrade-db-to-2.6.0-oracle.sql 571 Bytes 9483 over 8 years Jing Tao Add a policy_id in the smReplicationPolicy tabl...
upgrade-db-to-2.6.0-postgres.sql 560 Bytes 9483 over 8 years Jing Tao Add a policy_id in the smReplicationPolicy tabl...
upgrade-db-to-2.7.0-postgres.sql 2.52 KB 9575 over 8 years Jing Tao Add the upgrade script which add a new column f...
upgrade-db-to-2.7.1-postgres.sql 514 Bytes 9857 about 8 years Lauren Walker Merge changes from 2.7 branch
upgrade-db-to-2.7.2-postgres.sql 1.53 KB 9936 almost 8 years Jing Tao Change the type for the no-name-namespace schem...
upgrade-db-to-2.8.0-postgres.sql 299 Bytes 9794 about 8 years Jing Tao Add a upgrade script for 2.8.0
upgrade-db-to-2.8.1-postgres.sql 830 Bytes 10136 over 7 years Jing Tao Add the sql to register schema files for the fo...
upgrade-db-to-2.9.0-postgres.sql 299 Bytes 10209 over 7 years Jing Tao Add the script to upgrade the db to 2.9.0
xmlpackage.sql 1.94 KB 439 almost 24 years berkley sql file defining the table structure for eml-p...
xmltables-oracle.sql 26.2 KB 9483 over 8 years Jing Tao Add a policy_id in the smReplicationPolicy tabl...
xmltables-postgres.sql 23.2 KB 9924 almost 8 years Jing Tao Add the code to create a new column on xml_cata...
xmltables-sqlserver.sql 12.2 KB 6012 over 13 years ben leinfelder add support for temporal element query in pathq...

Latest revisions

# Date Author Comment
10213 04/06/2017 04:22 PM Jing Tao

Change the version to 2.9.0

10209 04/06/2017 04:14 PM Jing Tao

Add the script to upgrade the db to 2.9.0

10207 04/06/2017 02:34 PM Jing Tao

Move a statement e.printStactTrace to the logMetacat.error method.

10206 04/06/2017 09:51 AM Chris Jones

Add the 'Collaborator' role to the list of roles in the EML Registry CGI.

refs https://github.com/NCEAS/metacatui/issues/78

10205 04/06/2017 08:54 AM Jing Tao

In the expandRightHolder method, we don't use the parameter count=-1 to query the cn. Now we use count=200 and will use the page query to query again if it is necessary.

10202 04/05/2017 03:06 PM Jing Tao

Add the debug statement.

10201 04/05/2017 03:04 PM Jing Tao

Add the debug statement.

10193 03/14/2017 03:57 PM Jing Tao

Add more debug statement on cn.create method.

10188 03/06/2017 04:22 PM ben leinfelder

extract EML creator[s] and use those names or organizations when registering DOI with EZID. https://github.nceas.ucsb.edu/KNB/arctic-data/issues/143

10186 03/01/2017 02:16 PM Jing Tao

In the archive method, add a new mechanism to check if the local id is in the xml_revision table if it is not in the xml_documents table.

View revisions

Also available in: Atom