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

<!--
  * 2.2.0_preupdate.xml
  *
  * Copyright (c) 2003-2012 John Willinsky
  * Distributed under the GNU GPL v2. For full terms see the file docs/COPYING.
  *
  * 2.2.0 database updates XML file (executed before database schema updates).
  *
  * $Id$
  -->

<data>
	<!-- Bug #2424: Change from currency IDs to 3-letter codes; the currency
	     table can be dropped (later) and XML is used instead. -->
	<sql>
		<!-- This syntax works for both PostgreSQL and MySQL. -->
		<query>
			ALTER TABLE subscription_types ADD COLUMN currency_code_alpha VARCHAR(3)
		</query>
	</sql>

	<!-- Bug #2490: Update Subscription Type Public Display Column --> 
	<sql>
		<!-- Syntax for MySQL. -->
		<query driver="mysql">
			ALTER TABLE subscription_types CHANGE COLUMN pub disable_public_display TINYINT NOT NULL
		</query>
	</sql>

	<sql>
		<!-- Syntax for PostgreSQL. -->
		<query driver="postgres7">
			ALTER TABLE subscription_types RENAME COLUMN pub TO disable_public_display 
		</query>
	</sql>

	<!-- Bug #2291: Change from existing issue identification to more flexible 
	     issue identification. -->
	<sql>
		<!-- Syntax for MySQL. -->
		<query driver="mysql">
			ALTER TABLE issues ADD COLUMN show_volume TINYINT NOT NULL DEFAULT 0
		</query>
		<query driver="mysql">
			ALTER TABLE issues ADD COLUMN show_number TINYINT NOT NULL DEFAULT 0
		</query>
		<query driver="mysql">
			ALTER TABLE issues ADD COLUMN show_year TINYINT NOT NULL DEFAULT 0
		</query>
		<query driver="mysql">
			ALTER TABLE issues ADD COLUMN show_title TINYINT NOT NULL DEFAULT 0
		</query>

		<!-- Syntax for PostgreSQL. -->
		<query driver="postgres7">
			ALTER TABLE issues ADD COLUMN show_volume SMALLINT
		</query>
		<query driver="postgres7">
			ALTER TABLE issues ALTER COLUMN show_volume SET DEFAULT 0
		</query>
		<query driver="postgres7">
			UPDATE issues SET show_volume=0
		</query>
		<query driver="postgres7">
			ALTER TABLE issues ALTER COLUMN show_volume SET NOT NULL
		</query>
		<query driver="postgres7">
			ALTER TABLE issues ADD COLUMN show_number SMALLINT
		</query>
		<query driver="postgres7">
			ALTER TABLE issues ALTER COLUMN show_number SET DEFAULT 0
		</query>
		<query driver="postgres7">
			UPDATE issues SET show_number=0
		</query>
		<query driver="postgres7">
			ALTER TABLE issues ALTER COLUMN show_number SET NOT NULL
		</query>
		<query driver="postgres7">
			ALTER TABLE issues ADD COLUMN show_year SMALLINT
		</query>
		<query driver="postgres7">
			ALTER TABLE issues ALTER COLUMN show_year SET DEFAULT 0
		</query>
		<query driver="postgres7">
			UPDATE issues SET show_year=0
		</query>
		<query driver="postgres7">
			ALTER TABLE issues ALTER COLUMN show_year SET NOT NULL
		</query>
		<query driver="postgres7">
			ALTER TABLE issues ADD COLUMN show_title SMALLINT
		</query>
		<query driver="postgres7">
			ALTER TABLE issues ALTER COLUMN show_title SET DEFAULT 0
		</query>
		<query driver="postgres7">
			UPDATE issues SET show_title=0
		</query>
		<query driver="postgres7">
			ALTER TABLE issues ALTER COLUMN show_title SET NOT NULL
		</query>
	</sql>

	<!-- Bug #2961: Localization overhaul -->
	<sql>
		<rename table="site" column="locale" to="primary_locale" />
	</sql>
</data>