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

<!--
  * dbscripts/xml/upgrade/3.0.0_change_assoc_type.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 assoc_type XML file.
  -->
<data>
	<!-- synchronize the ASSOC_TYPE_ARTICLE constant to ASSOC_TYPE_SUBMISSION defined in PKPApplication -->
	<sql>
		<query>UPDATE controlled_vocabs SET assoc_type = 1048585 WHERE assoc_type = 257</query>
		<query>UPDATE notifications SET assoc_type = 1048585 WHERE assoc_type = 257</query>
		<query>UPDATE notes SET assoc_type = 1048585 WHERE assoc_type = 257</query>
		<query>UPDATE email_log SET assoc_type = 1048585 WHERE assoc_type = 257</query>
		<query>UPDATE event_log SET assoc_type = 1048585 WHERE assoc_type = 257</query>
		<query>UPDATE signoffs SET assoc_type = 1048585 WHERE assoc_type = 257</query>
	</sql>
	<!-- synchronize the ASSOC_TYPE_GALLEY constant to ASSOC_TYPE_REPRESENTATION defined in PKPApplication -->
	<sql>
		<query>UPDATE controlled_vocabs SET assoc_type = 521 WHERE assoc_type = 260</query>
		<query>UPDATE notifications SET assoc_type = 521 WHERE assoc_type = 260</query>
		<query>UPDATE notes SET assoc_type = 521 WHERE assoc_type = 260</query>
		<query>UPDATE submission_files SET assoc_type = 521 WHERE assoc_type = 260</query>
		<query>UPDATE email_log SET assoc_type = 521 WHERE assoc_type = 260</query>
		<query>UPDATE event_log SET assoc_type = 521 WHERE assoc_type = 260</query>
		<query>UPDATE signoffs SET assoc_type = 521 WHERE assoc_type = 260</query>
	</sql>
	<!-- synchronize the ASSOC_TYPE_ANNOUNCEMENT constant change -->
	<sql>
		<query>UPDATE notifications SET assoc_type = 522 WHERE assoc_type = 258</query>
	</sql>
	<!-- synchronize the NOTIFICATION_TYPE_REVIEWER_COMMENT constant change -->
	<sql>
		<query>UPDATE notifications SET type=16777219 WHERE type=16777233</query>
	</sql>
</data>