Server : Apache/2.4.41 (Ubuntu) System : Linux journalup 5.4.0-198-generic #218-Ubuntu SMP Fri Sep 27 20:18:53 UTC 2024 x86_64 User : www-data ( 33) PHP Version : 7.4.33 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare, Directory :  /var/www/html/dbscripts/xml/upgrade/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

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

<!--
  * 3.2.0_update.xml
  *
  * Copyright (c) 2014-2020 Simon Fraser University
  * Copyright (c) 2003-2020 John Willinsky
  * Distributed under the GNU GPL v3. For full terms see the file docs/COPYING.
  *
  * 3.2.0.0 general updates.
  -->
<data>
	<sql><!-- pkp/pkp-lib#2160/4726: Clean up editorial history -->
		<query>UPDATE event_log_settings SET setting_name='submissionId' WHERE setting_name='articleId'</query>
		<query>UPDATE event_log_settings SET setting_name='submissionId' WHERE setting_name='submission_id'</query>
	</sql>
	<sql><!-- pkp/pkp-lib#4573 Enable OAI interface by default -->
		<!-- PostgreSQL ADODB driver does not seem to properly support dropping constraints -->
		<query driver="postgres7">ALTER TABLE journal_settings ALTER COLUMN setting_type DROP NOT NULL</query>
		<query>INSERT INTO journal_settings (setting_name, setting_value, journal_id) SELECT 'enableOai', '1', j.journal_id FROM journals j WHERE NOT EXISTS (SELECT js.setting_name FROM journal_settings js WHERE js.setting_name = 'enableOai' AND js.journal_id = j.journal_id)</query>
	</sql>
	<sql><!-- pkp/pkp-lib#5445 Use new setting name for LicenseUrl -->
		<query>UPDATE journal_settings SET setting_name='licenseUrl' WHERE setting_name='licenseURL'</query>
		<query>UPDATE publication_settings SET setting_name='licenseUrl' WHERE setting_name='licenseURL'</query>
	</sql>
	<sql><!-- Migrate immersion theme settings stored as context settings to plugin settings -->
		<query>
			INSERT INTO plugin_settings (plugin_name, context_id, setting_name, setting_value, setting_type)
				SELECT 'immersionthemeplugin', js.journal_id, js.setting_name, js.setting_value, 'string'
				FROM journal_settings as js
				WHERE js.setting_name='immersionAnnouncementsColor'
		</query>
		<query>
			DELETE FROM journal_settings WHERE setting_name='immersionAnnouncementsColor'
		</query>
	</sql>
	<!-- Migrate email templates from email_templates_data to email_templates_settings -->
	<sql>
		<query>
			INSERT INTO email_templates_settings (email_id, locale, setting_value, setting_name)
			SELECT email_id, locale, subject, 'subject'
			FROM email_templates_data
		</query>
		<query>
			INSERT INTO email_templates_settings (email_id, locale, setting_value, setting_name)
			SELECT email_id, locale, body, 'body'
			FROM email_templates_data
		</query>
		<drop table="email_templates_data" />
	</sql>
</data>