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

<!--
  * @file plugins/generic/booksForReview/xml/schema.xml
  *
  * Copyright (c) 2003-2012 John Willinsky
  * Distributed under the GNU GPL v2. For full terms see the file docs/COPYING.
  *
  * Books For Review plugin schema in XML.
  *
  -->

<schema version="0.2">

	<!--
	 *
	 * TABLE books_for_review
	 *
	 -->
	<table name="books_for_review">
		<field name="book_id" type="I8">
			<KEY/>
			<AUTOINCREMENT/>
		</field>
		<field name="journal_id" type="I8">
			<NOTNULL/>
		</field>
		<field name="status" type="I2">
			<NOTNULL/>
		</field>
		<field name="author_type" type="I2">
			<NOTNULL/>
		</field>
		<field name="publisher" type="C2" size="255">
			<NOTNULL/>
		</field>
		<field name="year" type="I2">
			<NOTNULL/>
		</field>
		<field name="language" type="C2" size="10">
			<NOTNULL/>
			<DEFAULT VALUE="en"/>
		</field>
		<field name="copy" type="I1">
			<NOTNULL/>
			<DEFAULT VALUE="0"/>
		</field>
		<field name="url" type="C2" size="255"/>
		<field name="edition" type="I1"/>
		<field name="pages" type="I2"/>
		<field name="isbn" type="C2" size="30"/>
		<field name="date_created" type="T">
			<NOTNULL/>
		</field>
		<field name="date_requested" type="T"/>
		<field name="date_assigned" type="T"/>
		<field name="date_mailed" type="T"/>
		<field name="date_due" type="T"/>
		<field name="date_submitted" type="T"/>
		<field name="user_id" type="I8"/>
		<field name="editor_id" type="I8"/>
		<field name="article_id" type="I8"/>
		<field name="notes" type="X"/>
		<descr>Books available for review.</descr>
		<index name="bfr_id">
			<col>book_id</col>
		</index>
	</table>

	<!--
	  *
	  * TABLE books_for_review_settings
	  *
	  -->
	<table name="books_for_review_settings">
		<field name="book_id" type="I8">
			<NOTNULL/>
		</field>
		<field name="locale" type="C2" size="5">
			<NOTNULL/>
			<DEFAULT VALUE=""/>
		</field>
		<field name="setting_name" type="C2" size="255">
			<NOTNULL/>
		</field>
		<field name="setting_value" type="X"/>
		<field name="setting_type" type="C2" size="6">
			<NOTNULL/>
			<descr>(bool|int|float|string|object)</descr>
		</field>
		<descr>Books for review settings.</descr>
		<index name="bfr_settings_book_id">
			<col>book_id</col>
		</index>
		<index name="bfr_settings_pkey">
			<col>book_id</col>
			<col>locale</col>
			<col>setting_name</col>
			<UNIQUE />
		</index>
	</table>

	<!--
	  *
	  * TABLE books_for_review_authors
	  *
	  -->
	<table name="books_for_review_authors">
		<field name="author_id" type="I8">
			<KEY />
			<AUTOINCREMENT/>
		</field>
		<field name="book_id" type="I8">
			<NOTNULL/>
		</field>
		<field name="seq" type="F">
			<NOTNULL/>
			<DEFAULT VALUE="0"/>
		</field>
		<field name="first_name" type="C2" size="40">
			<NOTNULL/>
		</field>
		<field name="middle_name" type="C2" size="40"/>
		<field name="last_name" type="C2" size="90">
			<NOTNULL/>
		</field>
		<descr>Author metadata for books for review.</descr>
		<index name="bfr_book_id">
			<col>book_id</col>
		</index>
	</table>

</schema>