• Home
• org.eclipse.pass
• pass-core-main
• 1.11.0
• source code
• deposit-repo-copy-publication-id-fix.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

db.changelog.data.deposit-repo-copy-publication-id-fix.sql Maven / Gradle / Ivy

update pass_repository_copy
set publication_id = pass_submission.publication_id
from pass_deposit, pass_submission
where pass_deposit.submission_id = pass_submission.id
and pass_repository_copy.id = pass_deposit.repositorycopy_id
and pass_repository_copy.publication_id is null;