JFIFICC_PROFILElcmsmntrRGB XYZ  acspMSFTsawsctrl-hand=@=@t," desc_cprt wtptrXYZ,gXYZ@bXYZTrTRCh`gTRCh`bTRCh`descuRGBtextCC0XYZ TXYZ o8XYZ bXYZ $curv*|uN  bj. C$)j.~39?FWM6Tv\dluV~,6۾ewC    #%$""!&+7/&)4)!"0A149;>>>%.DIC;C  ;("(;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;<" }!1AQa"q2#BR$3br %&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz w!1AQaq"2B #3Rbr $4%&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz ?|WH?cS?Ne.r˿ޱ5\YYhFOejT7PZ[qs2c/$Ep[Gqo(Nù=QHci;OipX=Ģ8d^mQeӴm1OsL/x2];i6p!zU -/uX!=<-}JFIFICC_PROFILElcmsmntrRGB XYZ  acspMSFTsawsctrl-hand=@=@t," desc_cprt wtptrXYZ,gXYZ@bXYZTrTRCh`gTRCh`bTRCh`descuRGBtextCC0XYZ TXYZ o8XYZ bXYZ $curv*|uN  bj. C$)j.~39?FWM6Tv\dluV~,6۾ewC    #%$""!&+7/&)4)!"0A149;>>>%.DIC;C  ;("(;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;<" }!1AQa"q2#BR$3br %&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz w!1AQaq"2B #3Rbr $4%&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz ?|WH?cS?Ne.r˿ޱ5\YYhFOejT7PZ[qs2c/$Ep[Gqo(Nù=QHci;OipX=Ģ8d^mQeӴm1OsL/x2];i6p!zU -/uX!=<-}JFIFICC_PROFILElcmsmntrRGB XYZ  acspMSFTsawsctrl-hand=@=@t," desc_cprt wtptrXYZ,gXYZ@bXYZTrTRCh`gTRCh`bTRCh`descuRGBtextCC0XYZ TXYZ o8XYZ bXYZ $curv*|uN  bj. C$)j.~39?FWM6Tv\dluV~,6۾ewC    #%$""!&+7/&)4)!"0A149;>>>%.DIC;C  ;("(;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;<" }!1AQa"q2#BR$3br %&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz w!1AQaq"2B #3Rbr $4%&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz ?|WH?cS?Ne.r˿ޱ5\YYhFOejT7PZ[qs2c/$Ep[Gqo(Nù=QHci;OipX=Ģ8d^mQeӴm1OsL/x2];i6p!zU -/uX!=<-}JFIFICC_PROFILElcmsmntrRGB XYZ  acspMSFTsawsctrl-hand=@=@t," desc_cprt wtptrXYZ,gXYZ@bXYZTrTRCh`gTRCh`bTRCh`descuRGBtextCC0XYZ TXYZ o8XYZ bXYZ $curv*|uN  bj. C$)j.~39?FWM6Tv\dluV~,6۾ewC    #%$""!&+7/&)4)!"0A149;>>>%.DIC;C  ;("(;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;<" }!1AQa"q2#BR$3br %&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz w!1AQaq"2B #3Rbr $4%&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz ?|WH?cS?Ne.r˿ޱ5\YYhFOejT7PZ[qs2c/$Ep[Gqo(Nù=QHci;OipX=Ģ8d^mQeӴm1OsL/x2];i6p!zU -/uX!=<-}JFIFICC_PROFILElcmsmntrRGB XYZ  acspMSFTsawsctrl-hand=@=@t," desc_cprt wtptrXYZ,gXYZ@bXYZTrTRCh`gTRCh`bTRCh`descuRGBtextCC0XYZ TXYZ o8XYZ bXYZ $curv*|uN  bj. C$)j.~39?FWM6Tv\dluV~,6۾ewC    #%$""!&+7/&)4)!"0A149;>>>%.DIC;C  ;("(;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;<" }!1AQa"q2#BR$3br %&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz w!1AQaq"2B #3Rbr $4%&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz ?|WH?cS?Ne.r˿ޱ5\YYhFOejT7PZ[qs2c/$Ep[Gqo(Nù=QHci;OipX=Ģ8d^mQeӴm1OsL/x2];i6p!zU -/uX!=<-}JFIFICC_PROFILElcmsmntrRGB XYZ  acspMSFTsawsctrl-hand=@=@t," desc_cprt wtptrXYZ,gXYZ@bXYZTrTRCh`gTRCh`bTRCh`descuRGBtextCC0XYZ TXYZ o8XYZ bXYZ $curv*|uN  bj. C$)j.~39?FWM6Tv\dluV~,6۾ewC    #%$""!&+7/&)4)!"0A149;>>>%.DIC;C  ;("(;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;<" }!1AQa"q2#BR$3br %&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz w!1AQaq"2B #3Rbr $4%&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz ?|WH?cS?Ne.r˿ޱ5\YYhFOejT7PZ[qs2c/$Ep[Gqo(Nù=QHci;OipX=Ģ8d^mQeӴm1OsL/x2];i6p!zU -/uX!=<-}JFIFICC_PROFILElcmsmntrRGB XYZ  acspMSFTsawsctrl-hand=@=@t," desc_cprt wtptrXYZ,gXYZ@bXYZTrTRCh`gTRCh`bTRCh`descuRGBtextCC0XYZ TXYZ o8XYZ bXYZ $curv*|uN  bj. C$)j.~39?FWM6Tv\dluV~,6۾ewC    #%$""!&+7/&)4)!"0A149;>>>%.DIC;C  ;("(;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;<" }!1AQa"q2#BR$3br %&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz w!1AQaq"2B #3Rbr $4%&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz ?|WH?cS?Ne.r˿ޱ5\YYhFOejT7PZ[qs2c/$Ep[Gqo(Nù=QHci;OipX=Ģ8d^mQeӴm1OsL/x2];i6p!zU -/uX!=<-}JFIFICC_PROFILElcmsmntrRGB XYZ  acspMSFTsawsctrl-hand=@=@t," desc_cprt wtptrXYZ,gXYZ@bXYZTrTRCh`gTRCh`bTRCh`descuRGBtextCC0XYZ TXYZ o8XYZ bXYZ $curv*|uN  bj. C$)j.~39?FWM6Tv\dluV~,6۾ewC    #%$""!&+7/&)4)!"0A149;>>>%.DIC;C  ;("(;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;<" }!1AQa"q2#BR$3br %&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz w!1AQaq"2B #3Rbr $4%&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz ?|WH?cS?Ne.r˿ޱ5\YYhFOejT7PZ[qs2c/$Ep[Gqo(Nù=QHci;OipX=Ģ8d^mQeӴm1OsL/x2];i6p!zU -/uX!=<-}JFIFICC_PROFILElcmsmntrRGB XYZ  acspMSFTsawsctrl-hand=@=@t," desc_cprt wtptrXYZ,gXYZ@bXYZTrTRCh`gTRCh`bTRCh`descuRGBtextCC0XYZ TXYZ o8XYZ bXYZ $curv*|uN  bj. C$)j.~39?FWM6Tv\dluV~,6۾ewC    #%$""!&+7/&)4)!"0A149;>>>%.DIC;C  ;("(;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;<" }!1AQa"q2#BR$3br %&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz w!1AQaq"2B #3Rbr $4%&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz ?|WH?cS?Ne.r˿ޱ5\YYhFOejT7PZ[qs2c/$Ep[Gqo(Nù=QHci;OipX=Ģ8d^mQeӴm1OsL/x2];i6p!zU -/uX!=<-}JFIFICC_PROFILElcmsmntrRGB XYZ  acspMSFTsawsctrl-hand=@=@t," desc_cprt wtptrXYZ,gXYZ@bXYZTrTRCh`gTRCh`bTRCh`descuRGBtextCC0XYZ TXYZ o8XYZ bXYZ $curv*|uN  bj. C$)j.~39?FWM6Tv\dluV~,6۾ewC    #%$""!&+7/&)4)!"0A149;>>>%.DIC;C  ;("(;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;<" }!1AQa"q2#BR$3br %&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz w!1AQaq"2B #3Rbr $4%&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz ?|WH?cS?Ne.r˿ޱ5\YYhFOejT7PZ[qs2c/$Ep[Gqo(Nù=QHci;OipX=Ģ8d^mQeӴm1OsL/x2];i6p!zU -/uX!=<-}JFIFICC_PROFILElcmsmntrRGB XYZ  acspMSFTsawsctrl-hand=@=@t," desc_cprt wtptrXYZ,gXYZ@bXYZTrTRCh`gTRCh`bTRCh`descuRGBtextCC0XYZ TXYZ o8XYZ bXYZ $curv*|uN  bj. C$)j.~39?FWM6Tv\dluV~,6۾ewC    #%$""!&+7/&)4)!"0A149;>>>%.DIC;C  ;("(;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;<" }!1AQa"q2#BR$3br %&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz w!1AQaq"2B #3Rbr $4%&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz ?|WH?cS?Ne.r˿ޱ5\YYhFOejT7PZ[qs2c/$Ep[Gqo(Nù=QHci;OipX=Ģ8d^mQeӴm1OsL/x2];i6p!zU -/uX!=<-}JFIFICC_PROFILElcmsmntrRGB XYZ  acspMSFTsawsctrl-hand=@=@t," desc_cprt wtptrXYZ,gXYZ@bXYZTrTRCh`gTRCh`bTRCh`descuRGBtextCC0XYZ TXYZ o8XYZ bXYZ $curv*|uN  bj. C$)j.~39?FWM6Tv\dluV~,6۾ewC    #%$""!&+7/&)4)!"0A149;>>>%.DIC;C  ;("(;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;<" }!1AQa"q2#BR$3br %&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz w!1AQaq"2B #3Rbr $4%&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz ?|WH?cS?Ne.r˿ޱ5\YYhFOejT7PZ[qs2c/$Ep[Gqo(Nù=QHci;OipX=Ģ8d^mQeӴm1OsL/x2];i6p!zU -/uX!=<-}JFIFICC_PROFILElcmsmntrRGB XYZ  acspMSFTsawsctrl-hand=@=@t," desc_cprt wtptrXYZ,gXYZ@bXYZTrTRCh`gTRCh`bTRCh`descuRGBtextCC0XYZ TXYZ o8XYZ bXYZ $curv*|uN  bj. C$)j.~39?FWM6Tv\dluV~,6۾ewC    #%$""!&+7/&)4)!"0A149;>>>%.DIC;C  ;("(;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;<" }!1AQa"q2#BR$3br %&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz w!1AQaq"2B #3Rbr $4%&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz ?|WH?cS?Ne.r˿ޱ5\YYhFOejT7PZ[qs2c/$Ep[Gqo(Nù=QHci;OipX=Ģ8d^mQeӴm1OsL/x2];i6p!zU -/uX!=<-}JFIFICC_PROFILElcmsmntrRGB XYZ  acspMSFTsawsctrl-hand=@=@t," desc_cprt wtptrXYZ,gXYZ@bXYZTrTRCh`gTRCh`bTRCh`descuRGBtextCC0XYZ TXYZ o8XYZ bXYZ $curv*|uN  bj. C$)j.~39?FWM6Tv\dluV~,6۾ewC    #%$""!&+7/&)4)!"0A149;>>>%.DIC;C  ;("(;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;<" }!1AQa"q2#BR$3br %&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz w!1AQaq"2B #3Rbr $4%&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz ?|WH?cS?Ne.r˿ޱ5\YYhFOejT7PZ[qs2c/$Ep[Gqo(Nù=QHci;OipX=Ģ8d^mQeӴm1OsL/x2];i6p!zU -/uX!=<-} .
LIBYA CYBER ARMY
Logo of a company Instagram@3g86    Server : Apache
System : Linux uta-edu.server.ly 4.18.0-513.11.1.el8_9.x86_64 #1 SMP Wed Jan 17 02:00:40 EST 2024 x86_64
User : utripoli ( 1001)
PHP Version : 7.4.33
Disable Function : NONE
Directory :  /home/utripoli/public_html/journal/wesam/dbscripts/xml/upgrade/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Current File : /home/utripoli/public_html/journal/wesam/dbscripts/xml/upgrade/3.0.0_update.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE data SYSTEM "../../../lib/pkp/dtd/xmlData.dtd">

<!--
  * 3.0.0_update.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 general updates.
  -->
<data>
	<!-- Delete old-style notifications -->
	<sql>
		<query>DELETE FROM notifications WHERE type=16777224</query><!-- NOTIFICATION_TYPE_LAYOUT_COMMENT -->
		<query>DELETE FROM notifications WHERE type=16777225</query><!-- NOTIFICATION_TYPE_COPYEDIT_COMMENT -->
		<query>DELETE FROM notifications WHERE type=16777232</query><!-- NOTIFICATION_TYPE_PROOFREAD_COMMENT -->
		<query>DELETE FROM notifications WHERE type=16777220</query><!-- NOTIFICATION_TYPE_SUPP_FILE_MODIFIED WARNING: This type ID conflicts with others! -->
		<query>DELETE FROM notifications WHERE type=16777222</query><!-- NOTIFICATION_TYPE_GALLEY_MODIFIED WARNING: This type ID conflicts with others! -->
		<query>DELETE FROM notifications WHERE type=16777223</query><!-- NOTIFICATION_TYPE_SUBMISSION_COMMENT WARNING: This type ID conflicts with others! -->
		<query>DELETE FROM notifications WHERE type=16777234</query><!-- NOTIFICATION_TYPE_REVIEWER_FORM_COMMENT WARNING: This type ID conflicts with others! -->
		<query>DELETE FROM notifications WHERE type=16777235</query><!-- NOTIFICATION_TYPE_EDITOR_DECISION_COMMENT WARNING: This type ID conflicts with others! -->
		<query>DELETE FROM notifications WHERE type=268435476</query><!-- NOTIFICATION_TYPE_USER_COMMENT WARNING: This type ID conflicts with others! -->
	</sql>
	<!-- Bug #6968: Check review_type constant behavior. -->
	<sql>
		<query>UPDATE review_assignments SET stage_id=1 WHERE stage_id=0</query>
	</sql>
	<!-- Bug #6013: Make published dates for articles consistent -->
	<sql>
		<!-- CONCAT wrapper for issue #1788 -->
		<query driver="mysql,mysqli">UPDATE published_submissions SET date_published = NULL WHERE CONCAT(date_published) = '0000-00-00 00:00:00'</query>
	</sql>
	<!-- Re-map old ARTICLE_FILE_* constants to SUBMISSION_FILE_* ones.  The order here is important. -->
	<sql>
		<!-- attachment files -->
		<query>UPDATE submission_files SET file_stage = '13' WHERE file_stage = '9'</query>
		<!-- supplement files (no longer have supplement files in PKP-lib) -->
		<query>UPDATE submission_files SET file_stage = '13' WHERE file_stage = '6'</query>
		<!-- layout files -->
		<query>UPDATE submission_files SET file_stage = '10' WHERE file_stage = '5'</query>
		<!-- copyedit files -->
		<query>UPDATE submission_files SET file_stage = '9' WHERE file_stage = '4'</query>
		<!-- editor files temp -->
		<query>UPDATE submission_files SET file_stage = '8000' WHERE file_stage = '3'</query>
		<!-- review files -->
		<query>UPDATE submission_files SET file_stage = '4' WHERE file_stage = '2'</query>
		<!-- submission files -->
		<query>UPDATE submission_files SET file_stage = '2' WHERE file_stage = '1'</query>
		<!-- public files -->
		<query>UPDATE submission_files SET file_stage = '1' WHERE file_stage = '7'</query>
		<!-- note files temp -->
		<query>UPDATE submission_files SET file_stage = '3000' WHERE file_stage = '8'</query>
		<!-- editor files real -->
		<query>UPDATE submission_files SET file_stage = '8' WHERE file_stage = '8000'</query>
		<!-- note files real -->
		<query>UPDATE submission_files SET file_stage = '3' WHERE file_stage = '3000'</query>
	</sql>
	<!-- Bug #8212: Refactor MailTemplate code into PKP lib -->
	<sql>
		<!-- journalTitle becomes contextName -->
		<query>UPDATE email_templates_default_data SET body=REPLACE(body, '{$journalTitle}', '{$contextName}'), subject=REPLACE(subject, '{$journalTitle}', '{$contextName}')</query>
		<query>UPDATE email_templates_data SET body=REPLACE(body, '{$journalTitle}', '{$contextName}'), subject=REPLACE(subject, '{$journalTitle}', '{$contextName}')</query>
		<!-- journalName becomes contextName -->
		<query>UPDATE email_templates_default_data SET body=REPLACE(body, '{$journalName}', '{$contextName}'), subject=REPLACE(subject, '{$journalName}', '{$contextName}')</query>
		<query>UPDATE email_templates_data SET body=REPLACE(body, '{$journalName}', '{$contextName}'), subject=REPLACE(subject, '{$journalName}', '{$contextName}')</query>
		<!-- journalUrl becomes contextUrl -->
		<query>UPDATE email_templates_default_data SET body=REPLACE(body, '{$journalUrl}', '{$contextUrl}'), subject=REPLACE(subject, '{$journalUrl}', '{$contextUrl}')</query>
		<query>UPDATE email_templates_data SET body=REPLACE(body, '{$journalUrl}', '{$contextUrl}'), subject=REPLACE(subject, '{$journalUrl}', '{$contextUrl}')</query>
		<!-- articleTitle becomes submissionTitle -->
		<query>UPDATE email_templates_default_data SET body=REPLACE(body, '{$articleTitle}', '{$submissionTitle}'), subject=REPLACE(subject, '{$articleTitle}', '{$submissionTitle}')</query>
		<query>UPDATE email_templates_data SET body=REPLACE(body, '{$articleTitle}', '{$submissionTitle}'), subject=REPLACE(subject, '{$articleTitle}', '{$submissionTitle}')</query>
		<!-- articleId becomes submissionId -->
		<query>UPDATE email_templates_default_data SET body=REPLACE(body, '{$articleId}', '{$submissionId}'), subject=REPLACE(subject, '{$articleId}', '{$submissionId}')</query>
		<query>UPDATE email_templates_data SET body=REPLACE(body, '{$articleId}', '{$submissionId}'), subject=REPLACE(subject, '{$articleId}', '{$submissionId}')</query>
		<!-- articleAbstract becomes submissionAbstract -->
		<query>UPDATE email_templates_default_data SET body=REPLACE(body, '{$articleAbstract}', '{$submissionAbstract}'), subject=REPLACE(subject, '{$articleAbstract}', '{$submissionAbstract}')</query>
		<query>UPDATE email_templates_data SET body=REPLACE(body, '{$articleAbstract}', '{$submissionAbstract}'), subject=REPLACE(subject, '{$articleAbstract}', '{$submissionAbstract}')</query>
		<!-- weekLaterDate becomes responseDueDate -->
		<query>UPDATE email_templates_default_data SET body=REPLACE(body, '{$weekLaterDate}', '{$responseDueDate}'), subject=REPLACE(subject, '{$weekLaterDate}', '{$responseDueDate}')</query>
		<query>UPDATE email_templates_data SET body=REPLACE(body, '{$weekLaterDate}', '{$responseDueDate}'), subject=REPLACE(subject, '{$weekLaterDate}', '{$responseDueDate}')</query>
	</sql>
	<!--   Bug #8148: Submission process into PKP lib  -->
	<sql>
		<!-- issue #2506: the genre_id for 'article' from genres.xml -->
		<query driver="mysql,mysqli">UPDATE submission_files sf, genres g, submissions s SET sf.genre_id = g.genre_id WHERE g.entry_key = 'SUBMISSION' AND g.context_id = s.context_id AND s.submission_id = sf.submission_id</query>
		<query driver="postgres,postgres64,postgres7,postgres8,postgres9">UPDATE submission_files SET genre_id = g.genre_id FROM genres g, submissions s WHERE g.entry_key = 'SUBMISSION' AND g.context_id = s.context_id AND s.submission_id = submission_files.submission_id</query>
	</sql>
	<!-- issue #2758: the genre_id for HTML galley CSS files -->
	<sql>
		<query driver="mysql,mysqli">UPDATE submission_files sf, genres g, submissions s, article_galleys_migration agm SET sf.genre_id = g.genre_id WHERE g.entry_key = 'STYLE' AND g.context_id = s.context_id AND s.submission_id = sf.submission_id AND sf.file_id = agm.style_file_id</query>
		<query driver="postgres,postgres64,postgres7,postgres8,postgres9">UPDATE submission_files sf SET genre_id = g.genre_id FROM genres g, submissions s, article_galleys_migration agm WHERE g.entry_key = 'STYLE' AND g.context_id = s.context_id AND s.submission_id = sf.submission_id AND sf.file_id = agm.style_file_id</query>
	</sql>
	<!-- issue #2758: set assoc_type = 515 (ASSOC_TYPE_SUBMISSION_FILE) and the appropriate assoc_id for HTML galley CSS files -->
	<sql>
		<query driver="mysql,mysqli">UPDATE submission_files sf, article_galleys_migration agm SET sf.assoc_type = 515, sf.assoc_id = agm.file_id WHERE sf.file_id = agm.style_file_id</query>
		<query driver="postgres,postgres64,postgres7,postgres8,postgres9">UPDATE submission_files sf SET assoc_type = 515, assoc_id = agm.file_id FROM article_galleys_migration agm WHERE sf.file_id = agm.style_file_id</query>
	</sql>
	<!-- Bug #7745: Change no_NO to nb_NO -->
	<sql>
		<query>UPDATE announcement_type_settings SET locale='nb_NO' WHERE locale='no_NO'</query>
		<query>UPDATE announcement_settings SET locale='nb_NO' WHERE locale='no_NO'</query>
		<query>UPDATE user_settings SET locale='nb_NO' WHERE locale='no_NO'</query>
		<query>UPDATE notification_settings SET locale='nb_NO' WHERE locale='no_NO'</query>
		<query>UPDATE email_templates_default_data SET locale='nb_NO' WHERE locale='no_NO'</query>
		<query>UPDATE email_templates_data SET locale='nb_NO' WHERE locale='no_NO'</query>
		<query>UPDATE controlled_vocab_entry_settings SET locale='nb_NO' WHERE locale='no_NO'</query>
		<query>UPDATE citation_settings SET locale='nb_NO' WHERE locale='no_NO'</query>
		<query>UPDATE metadata_description_settings SET locale='nb_NO' WHERE locale='no_NO'</query>
		<query>UPDATE filter_settings SET locale='nb_NO' WHERE locale='no_NO'</query>
		<query>UPDATE review_form_settings SET locale='nb_NO' WHERE locale='no_NO'</query>
		<query>UPDATE review_form_element_settings SET locale='nb_NO' WHERE locale='no_NO'</query>
		<query>UPDATE user_group_settings SET locale='nb_NO' WHERE locale='no_NO'</query>
		<query>UPDATE submission_file_settings SET locale='nb_NO' WHERE locale='no_NO'</query>
		<query>UPDATE author_settings SET locale='nb_NO' WHERE locale='no_NO'</query>
		<query>UPDATE data_object_tombstone_settings SET locale='nb_NO' WHERE locale='no_NO'</query>
		<query>UPDATE journal_settings SET locale='nb_NO' WHERE locale='no_NO'</query>
		<query>UPDATE section_settings SET locale='nb_NO' WHERE locale='no_NO'</query>
		<query>UPDATE issue_settings SET locale='nb_NO' WHERE locale='no_NO'</query>
		<query>UPDATE issue_galleys SET locale='nb_NO' WHERE locale='no_NO'</query>
		<query>UPDATE issue_galley_settings SET locale='nb_NO' WHERE locale='no_NO'</query>
		<query>UPDATE submissions SET locale='nb_NO' WHERE locale='no_NO'</query>
		<query>UPDATE submission_settings SET locale='nb_NO' WHERE locale='no_NO'</query>
		<query>UPDATE submission_galleys SET locale='nb_NO' WHERE locale='no_NO'</query>
		<query>UPDATE subscription_type_settings SET locale='nb_NO' WHERE locale='no_NO'</query>
	</sql>
	<sql><!-- Bug #8397 -->
		<query>UPDATE submissions SET status=4 WHERE status=0</query><!-- STATUS_ARCHIVED to STATUS_DECLINED -->
	</sql>

	<!-- Issue #1296: clean up notification emails for participants grid -->
	<sql>
		<!-- submissionCopyeditingUrl to submissionUrl -->
		<query>UPDATE email_templates_default_data SET body=REPLACE(body, '{$submissionCopyeditingUrl}', '{$submissionUrl}')</query>
		<query>UPDATE email_templates_data SET body=REPLACE(body, '{$submissionCopyeditingUrl}', '{$submissionUrl}')</query>
		<!-- layoutEditorName to participantName -->
		<query>UPDATE email_templates_default_data SET body=REPLACE(body, '{$layoutEditorName}', '{$participantName}')</query>
		<query>UPDATE email_templates_data SET body=REPLACE(body, '{$layoutEditorName}', '{$participantName}')</query>
		<!-- layoutEditorUsername to participantUsername -->
		<query>UPDATE email_templates_default_data SET body=REPLACE(body, '{$layoutEditorUsername}', '{$participantUsername}')</query>
		<query>UPDATE email_templates_data SET body=REPLACE(body, '{$layoutEditorUsername}', '{$participantUsername}')</query>
		<!-- copyeditorName to participantName -->
		<query>UPDATE email_templates_default_data SET body=REPLACE(body, '{$copyeditorName}', '{$participantName}')</query>
		<query>UPDATE email_templates_data SET body=REPLACE(body, '{$copyeditorName}', '{$participantName}')</query>
		<!-- copyeditorUsername to participantUsername -->
		<query>UPDATE email_templates_default_data SET body=REPLACE(body, '{$copyeditorUsername}', '{$participantUsername}')</query>
		<query>UPDATE email_templates_data SET body=REPLACE(body, '{$copyeditorUsername}', '{$participantUsername}')</query>
	</sql>

	<!-- Issue #1328: Stop addressing single recipient in reviewer accept/decline emails -->
	<sql>
		<query>UPDATE email_templates_default_data SET body=REPLACE(body, '{$editorialContactName}', 'Editors') WHERE locale = 'en_US' AND email_key IN ('REVIEW_CONFIRM', 'REVIEW_DECLINE')</query>
		<query>UPDATE email_templates_data SET body=REPLACE(body, '{$editorialContactName}', 'Editors') WHERE locale = 'en_US' AND email_key IN ('REVIEW_CONFIRM', 'REVIEW_DECLINE')</query>
		<query>UPDATE email_templates_default_data SET body=REPLACE(body, '{$editorialContactName}', 'Herausgeber/innen') WHERE locale = 'de_DE' AND email_key IN ('REVIEW_CONFIRM', 'REVIEW_DECLINE')</query>
		<query>UPDATE email_templates_data SET body=REPLACE(body, '{$editorialContactName}', 'Herausgeber/innen') WHERE locale = 'de_DE' AND email_key IN ('REVIEW_CONFIRM', 'REVIEW_DECLINE')</query>
		<query>UPDATE email_templates_default_data SET body=REPLACE(body, '{$editorialContactName}', 'Επιμελητές') WHERE locale = 'el_GR' AND email_key IN ('REVIEW_CONFIRM', 'REVIEW_DECLINE')</query>
		<query>UPDATE email_templates_data SET body=REPLACE(body, '{$editorialContactName}', 'Επιμελητές') WHERE locale = 'el_GR' AND email_key IN ('REVIEW_CONFIRM', 'REVIEW_DECLINE')</query>
		<query>UPDATE email_templates_default_data SET body=REPLACE(body, '{$editorialContactName}', 'Editores') WHERE locale = 'es_ES' AND email_key IN ('REVIEW_CONFIRM', 'REVIEW_DECLINE')</query>
		<query>UPDATE email_templates_data SET body=REPLACE(body, '{$editorialContactName}', 'Editores') WHERE locale = 'es_ES' AND email_key IN ('REVIEW_CONFIRM', 'REVIEW_DECLINE')</query>
		<query>UPDATE email_templates_default_data SET body=REPLACE(body, '{$editorialContactName}', 'Éditeurs') WHERE locale = 'fr_CA' AND email_key IN ('REVIEW_CONFIRM', 'REVIEW_DECLINE')</query>
		<query>UPDATE email_templates_data SET body=REPLACE(body, '{$editorialContactName}', 'Éditeurs') WHERE locale = 'fr_CA' AND email_key IN ('REVIEW_CONFIRM', 'REVIEW_DECLINE')</query>
		<query>UPDATE email_templates_default_data SET body=REPLACE(body, '{$editorialContactName}', 'Editores') WHERE locale = 'pt_BR' AND email_key IN ('REVIEW_CONFIRM', 'REVIEW_DECLINE')</query>
		<query>UPDATE email_templates_data SET body=REPLACE(body, '{$editorialContactName}', 'Editores') WHERE locale = 'pt_BR' AND email_key IN ('REVIEW_CONFIRM', 'REVIEW_DECLINE')</query>
	</sql>

	<sql><!-- Make the default theme plugin active for all journals and the site. -->
		<query>INSERT INTO plugin_settings (plugin_name, setting_name, setting_value, setting_type, context_id) VALUES ('defaultthemeplugin', 'enabled', '1', 'bool', 0)</query>
		<query>INSERT INTO plugin_settings (plugin_name, setting_name, setting_value, setting_type, context_id) SELECT 'defaultthemeplugin', 'enabled', '1', 'bool', journal_id FROM journals</query>
		<query>INSERT INTO site_settings (setting_name, setting_value) VALUES ('themePluginPath', 'default')</query>
		<query>INSERT INTO journal_settings (setting_name, setting_value, journal_id) SELECT 'themePluginPath', 'default', journal_id FROM journals</query>
	</sql>
	<sql><!-- Issue #4989: Set default review mode on upgrade from 2.x -->
		<query>INSERT INTO journal_settings (setting_name, setting_value, journal_id) SELECT 'defaultReviewMode', 'default', journal_id FROM journals</query><!-- SUBMISSION_REVIEW_METHOD_DOUBLEANONYMOUS -->
	</sql>

	<sql><!-- OJS 2.4.x used log.author.submitted to log submission events; use submission.event.submissionSubmitted instead -->
		<query>UPDATE event_log SET message='submission.event.submissionSubmitted' WHERE message='log.author.submitted'</query>
	</sql>

	<sql><!-- Set submission stages based on progress through the 2.4.x workflow. WARNING: These cascade; they cannot be moved out of sequence. -->
		<!-- All submissions will begin with workflow stage 1 (WORKFLOW_STAGE_ID_SUBMISSION), per schema descriptor -->
		<query>UPDATE submissions SET stage_id=3 WHERE submission_id IN (SELECT DISTINCT submission_id FROM review_assignments)</query><!-- WORKFLOW_STAGE_ID_EXTERNAL_REVIEW -->
		<query>UPDATE submissions SET stage_id=3 WHERE stage_id = 1 AND submission_id IN (SELECT DISTINCT submission_id FROM review_rounds)</query><!-- WORKFLOW_STAGE_ID_EXTERNAL_REVIEW -->
		<query>UPDATE submissions SET stage_id=4 WHERE submission_id IN (SELECT e1.submission_id FROM edit_decisions e1 LEFT JOIN edit_decisions e2 ON (e2.edit_decision_id > e1.edit_decision_id AND e2.submission_id = e1.submission_id) WHERE e2.edit_decision_id IS NULL AND e1.decision = 1)</query><!-- WORKFLOW_STAGE_ID_EDITING; SUBMISSION_EDITOR_DECISION_ACCEPT -->
	</sql>
	<sql><!-- Update review schema to suit OJS 3.0 -->
		<query>UPDATE review_rounds SET stage_id=3</query><!-- All reviews are in external review stage in OJS -->
		<query>UPDATE review_assignments SET stage_id=3</query><!-- All reviews are in external review stage in OJS -->
		<query driver="mysql,mysqli">UPDATE review_assignments ra, review_rounds rr SET ra.review_round_id = rr.review_round_id WHERE ra.submission_id = rr.submission_id AND ra.round = rr.round</query>
		<query driver="postgres,postgres64,postgres7,postgres8,postgres9">UPDATE review_assignments SET review_round_id=rr.review_round_id FROM review_rounds rr WHERE rr.round = review_assignments.round AND rr.submission_id = review_assignments.submission_id</query>
		<query>INSERT INTO review_round_files (submission_id, review_round_id, stage_id, file_id, revision) SELECT afm.article_id, rr.review_round_id, 3, afm.file_id, afm.revision FROM article_files_migration afm, articles_migration am, review_rounds rr WHERE am.review_file_id = afm.file_id AND rr.submission_id = afm.article_id AND rr.round = afm.round</query><!-- WORKFLOW_STAGE_ID_EXTERNAL_REVIEW -->
		<query>INSERT INTO review_round_files (submission_id, review_round_id, stage_id, file_id, revision) SELECT afm.article_id, rr.review_round_id, 3, afm.file_id, afm.revision FROM article_files_migration afm, articles_migration am, review_rounds rr WHERE am.revised_file_id = afm.file_id AND rr.submission_id = afm.article_id AND rr.round = afm.round</query><!-- WORKFLOW_STAGE_ID_EXTERNAL_REVIEW -->
		<query>INSERT INTO review_files (review_id, file_id) SELECT DISTINCT ra.review_id, afm.file_id FROM article_files_migration afm, articles_migration am, review_assignments ra WHERE ra.submission_id = am.article_id AND am.review_file_id = afm.file_id</query>
	</sql>
	<sql><!-- Update file stages -->
		<query driver="mysql,mysqli">UPDATE submission_files sf, articles_migration am SET sf.file_stage=2 WHERE am.submission_file_id=sf.file_id</query><!-- SUBMISSION_FILE_SUBMISSION -->
		<query driver="postgres,postgres64,postgres7,postgres8,postgres9">UPDATE submission_files SET file_stage=2 FROM articles_migration am WHERE am.submission_file_id=submission_files.file_id</query><!-- SUBMISSION_FILE_SUBMISSION -->

		<query driver="mysql,mysqli">UPDATE submission_files sf, articles_migration am SET sf.file_stage=4 WHERE am.review_file_id=sf.file_id</query><!-- SUBMISSION_FILE_REVIEW_FILE -->
		<query driver="postgres,postgres64,postgres7,postgres8,postgres9">UPDATE submission_files SET file_stage=4 FROM articles_migration am WHERE am.review_file_id=submission_files.file_id</query><!-- SUBMISSION_FILE_REVIEW_FILE -->

		<query driver="mysql,mysqli">UPDATE submission_files sf, articles_migration am SET sf.file_stage=15 WHERE am.revised_file_id=sf.file_id</query><!-- SUBMISSION_FILE_REVISION -->
		<query driver="postgres,postgres64,postgres7,postgres8,postgres9">UPDATE submission_files SET file_stage=15 FROM articles_migration am WHERE am.revised_file_id=submission_files.file_id</query><!-- SUBMISSION_FILE_REVISION -->

		<query driver="mysql,mysqli">UPDATE submission_files sf, submission_galleys sg SET sf.file_stage=10 WHERE sg.file_id=sf.file_id</query><!-- SUBMISSION_FILE_PROOF -->
		<query driver="postgres,postgres64,postgres7,postgres8,postgres9">UPDATE submission_files SET file_stage=10 FROM submission_galleys sg WHERE sg.file_id=submission_files.file_id</query><!-- SUBMISSION_FILE_PROOF -->
		<query driver="mysql,mysqli">UPDATE submission_files sf, article_galleys_migration agm SET sf.file_stage=17 WHERE agm.style_file_id=sf.file_id</query><!-- SUBMISSION_FILE_DEPENDANT -->
		<query driver="postgres,postgres64,postgres7,postgres8,postgres9">UPDATE submission_files SET file_stage=17 FROM article_galleys_migration agm WHERE agm.style_file_id=submission_files.file_id</query><!-- SUBMISSION_FILE_DEPENDANT -->
	</sql>
	<sql><!-- #1838 Automatic emails for open access/subscription triggered post-install -->
		<query>DELETE FROM scheduled_tasks WHERE class_name = 'classes.tasks.OpenAccessNotification'</query>
		<query>DELETE FROM scheduled_tasks WHERE class_name = 'classes.tasks.SubscriptionExpiryReminder'</query>
	</sql>
	<sql><!-- remove filter_groups -->
		<query>DELETE FROM filter_groups WHERE symbolic IN ('citation=>nlm30', 'isbn=>nlm30-element-citation', 'nlm30-article-xml=>nlm23-article-xml', 'nlm30-element-citation=>isbn', 'nlm30-element-citation=>nlm30-element-citation', 'nlm30-element-citation=>nlm30-xml', 'nlm30-element-citation=>plaintext', 'nlm30=>citation', 'plaintext=>nlm30-element-citation', 'submission=>nlm23-article-xml', 'submission=>nlm30-article-xml', 'submission=>reference-list')</query>
	</sql>
</data>

3g86 2022