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

<!--
  * 2.3.7_update.xml
  *
  * Copyright (c) 2000-2012 John Willinsky
  * Distributed under the GNU GPL v2. For full terms see the file docs/COPYING.
  *
  * 2.3.7 database updates XML file.
  *
  -->

<data>
	<!-- Bug #6876: Galleys uploaded in Firefox not indexed for search -->
	<sql>
		<!-- Syntax for MySQL. -->
		<query driver="mysql">
			UPDATE article_files SET file_type = 'application/pdf' WHERE original_file_name RLIKE '\\.pdf$'
		</query>

		<query driver="mysql">
			UPDATE article_files SET file_type = 'application/msword' WHERE original_file_name RLIKE '\\.doc$'
		</query>

		<query driver="mysql">
			UPDATE article_files SET file_type = 'application/vnd.ms-powerpoint' WHERE original_file_name RLIKE '\\.ppt$'
		</query>

		<query driver="mysql">
			UPDATE article_files SET file_type = 'application/vnd.ms-powerpoint' WHERE original_file_name RLIKE '\\.pps$'
		</query>

		<query driver="mysql">
			UPDATE article_files SET file_type = 'application/vnd.openxmlformats-officedocument.wordprocessingml.document' WHERE original_file_name RLIKE '\\.docx$'
		</query>

		<query driver="mysql">
			UPDATE article_files SET file_type = 'application/vnd.openxmlformats-officedocument.presentationml.presentation' WHERE original_file_name RLIKE '\\.pptx$'
		</query>

		<query driver="mysql">
			UPDATE article_files SET file_type = 'application/vnd.openxmlformats-officedocument.presentationml.slideshow' WHERE original_file_name RLIKE '\\.ppsx$'
		</query>

		<!-- Syntax for PostgreSQL. -->
		<query driver="postgres">
			UPDATE article_files SET file_type = 'application/pdf' WHERE original_file_name ~* '.pdf$'
		</query>

		<query driver="postgres">
			UPDATE article_files SET file_type = 'application/msword' WHERE original_file_name ~* '.doc$'
		</query>

		<query driver="postgres">
			UPDATE article_files SET file_type = 'application/vnd.ms-powerpoint' WHERE original_file_name ~* '.ppt$'
		</query>

		<query driver="postgres">
			UPDATE article_files SET file_type = 'application/vnd.ms-powerpoint' WHERE original_file_name ~* '.pps$'
		</query>

		<query driver="postgres">
			UPDATE article_files SET file_type = 'application/vnd.openxmlformats-officedocument.wordprocessingml.document' WHERE original_file_name ~* '.docx$'
		</query>

		<query driver="postgres">
			UPDATE article_files SET file_type = 'application/vnd.openxmlformats-officedocument.presentationml.presentation' WHERE original_file_name ~* '.pptx$'
		</query>

		<query driver="postgres">
			UPDATE article_files SET file_type = 'application/vnd.openxmlformats-officedocument.presentationml.slideshow' WHERE original_file_name ~* '.ppsx$'
		</query>
	</sql>

</data>