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

<!--
  * dbscripts/xml/upgrade/3.2.0_stylesheet.xml
  *
  * Copyright (c) 2013-2021 Simon Fraser University
  * Copyright (c) 2003-2021 John Willinsky
  * Distributed under the GNU GPL v3. For full terms see the file docs/COPYING.
  *
  * Update the context setting `stylesheet` format to drop the image attributes
	* object and replace it with a string referencing the filename. Also remove
	* the unused original_style_file_name column from the site table.
  *
  -->

<data>
	<sql>
		<query>
			UPDATE journal_settings SET setting_value='a:3:{s:4:"name";s:9:"admin.css";s:10:"uploadName";s:14:"styleSheet.css";s:12:"dateUploaded";s:0:"";}' WHERE setting_name='styleSheet';
		</query>
		<query>
			ALTER TABLE site DROP COLUMN original_style_file_name
		</query>
	</sql>
</data>