<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE data SYSTEM "../../../lib/pkp/dtd/xmlData.dtd">

<!--
  * 3.0.0_pubId_settings.xml
  *
  * Copyright (c) 2014-2021 Simon Fraser University
  * Copyright (c) 2003-2021 John Willinsky
  * Distributed under the GNU GPL v3. For full terms see the file docs/COPYING.
  *
  * 3.0.0.0 updates for public identifiers plugins settings.
  -->
<data>
	<!-- Issue #1457: Public identifiers migration to OJS 3.0 -->
	<sql>
		<!--  DOI -->
		<query>UPDATE plugin_settings SET setting_name = 'doiRepresentationSuffixPattern' WHERE setting_name = 'doiGalleySuffixPattern'</query>
		<query>UPDATE plugin_settings SET setting_name = 'doiSubmissionSuffixPattern' WHERE setting_name = 'doiArticleSuffixPattern'</query>
		<query>UPDATE plugin_settings SET setting_name = 'enableRepresentationDoi' WHERE setting_name = 'enableGalleyDoi'</query>
		<query>UPDATE plugin_settings SET setting_name = 'enableSubmissionDoi' WHERE setting_name = 'enableArticleDoi'</query>
		<query>DELETE FROM plugin_settings WHERE setting_name = 'doiSuppFileSuffixPattern'</query>
		<query>DELETE FROM plugin_settings WHERE setting_name = 'enableSuppFileDoi'</query>
		<!--  URN -->
		<query>UPDATE plugin_settings SET setting_name = 'urnRepresentationSuffixPattern' WHERE setting_name = 'urnGalleySuffixPattern'</query>
		<query>UPDATE plugin_settings SET setting_name = 'urnSubmissionSuffixPattern' WHERE setting_name = 'urnArticleSuffixPattern'</query>
		<query>UPDATE plugin_settings SET setting_name = 'enableRepresentationURN' WHERE setting_name = 'enableGalleyURN'</query>
		<query>UPDATE plugin_settings SET setting_name = 'enableSubmissionURN' WHERE setting_name = 'enableArticleURN'</query>
		<query>UPDATE plugin_settings SET setting_name = 'urnNamespace' WHERE setting_name = 'namespace'</query>
		<query>UPDATE plugin_settings SET setting_name = 'urnCheckNo' WHERE setting_name = 'checkNo'</query>
		<query>UPDATE plugin_settings SET setting_name = 'urnCheckNo' WHERE setting_name = 'checkNo'</query>
		<query>DELETE FROM plugin_settings WHERE setting_name = 'urnSuppFileSuffixPattern'</query>
		<query>DELETE FROM plugin_settings WHERE setting_name = 'enableSuppFileURN'</query>
		<!--  Remove the journal setting -->
		<query>DELETE FROM journal_settings WHERE setting_name = 'enablePageNumber'</query>
		<query>DELETE FROM journal_settings WHERE setting_name = 'enablePublicArticleId'</query>
		<query>DELETE FROM journal_settings WHERE setting_name = 'enablePublicGalleyId'</query>
		<query>DELETE FROM journal_settings WHERE setting_name = 'enablePublicIssueId'</query>
		<query>DELETE FROM journal_settings WHERE setting_name = 'enablePublicSuppFileId'</query>
	</sql>
</data>