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

<!--
  * 3.0.0_edit_decisions.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 edit_decisions update.
  -->
<data>
	<sql>
		<!-- #2159 set stage_id = 3 (WORKFLOW_STAGE_ID_EXTERNAL_REVIEW) where stage_id IS NULL - applies for those migrated from OJS 2.4.x -->
		<query>UPDATE edit_decisions SET stage_id=3 WHERE stage_id IS NULL</query>
		<!-- #2159 set missing review_round_id, where possible - applies for those migrated from OJS 2.4.x -->
		<query driver="mysql,mysqli">UPDATE edit_decisions ed, review_rounds rr SET ed.review_round_id = rr.review_round_id WHERE rr.round = ed.round AND rr.submission_id = ed.submission_id</query>
		<query driver="postgres,postgres64,postgres7,postgres8,postgres9">UPDATE edit_decisions SET review_round_id = rr.review_round_id FROM review_rounds rr WHERE rr.round = edit_decisions.round AND rr.submission_id = edit_decisions.submission_id</query>
	</sql>
</data>