<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE data SYSTEM "../../../dbscripts/xml/dtd/xmldata.dtd">

<!--
  * data.xml
  *
  * Copyright (c) 2003-2008 John Willinsky
  * Distributed under the GNU GPL v2. For full terms see the file docs/COPYING.
  *
  * Manual payment plugin email templates data XML file.
  *
  * $Id: data.xml,v 1.4 2008/06/13 20:16:46 asmecher Exp $
  -->

<data>
	<sql><!-- Make sure duplicate inserts are not attempted i.e. on upgrade-->
		<query>DELETE FROM email_templates_default WHERE email_key = 'MANUAL_PAYMENT_NOTIFICATION'</query>
		<query>DELETE FROM email_templates_default_data WHERE email_key = 'MANUAL_PAYMENT_NOTIFICATION'</query>
	</sql>
	<table name="email_templates_default">
		<row>
			<field name="email_key">MANUAL_PAYMENT_NOTIFICATION</field>
			<field name="can_edit">1</field>
			<field name="can_disable">0</field>
		</row>
	</table>

	<table name="email_templates_default_data">
		<row>
			<field name="locale">en_US</field>
			<field name="email_key">MANUAL_PAYMENT_NOTIFICATION</field>
			<field name="subject">Manual Payment Notification</field>
			<field name="body">A manual payment needs to be processed for the journal {$journalName} and the user {$userFullName} (username "{$userName}").

The item being paid for is "{$itemName}".
The cost is {$itemCost} ({$itemCurrencyCode}).

This email was generated by Open Journal Systems' Manual Payment plugin.</field>
			<field name="description">This email template is used to notify a journal manager contact that a manual payment was requested.</field>
		</row>
	</table>
</data>
