0_15_inc.php

<?php
	# Mantis - a php based bugtracking system
	# Copyright (C) 2000 - 2002  Kenzaburo Ito - kenito@300baud.org
	# Copyright (C) 2002 - 2004  Mantis Team   - mantisbt-dev@lists.sourceforge.net
	# This program is distributed under the terms and conditions of the GPL
	# See the README and LICENSE files for details

	# Changes applied to 0.15 database to give us 0.16

	# --------------------------------------------------------
	# $Id: 0_15_inc.php,v 1.6 2004-02-06 14:51:14 jlatour Exp $
	# --------------------------------------------------------
?>
<?php
	require_once( 'db_table_names_inc.php' );

	$upgrades = array();

	$upgrades[] = new FunctionUpgrade( 
			'0.15-1',
			'Add file type column to bug file table',
			'upgrade_0_15_1' );
	
	function upgrade_0_15_1() {
		global $t_bug_file_table;
		
		if ( !db_field_exists( 'file_type', $t_bug_file_table ) ) {
			$query = "ALTER TABLE $t_bug_file_table ADD file_type VARCHAR(250) NOT NULL AFTER filesize";
	
			$result = @db_query( $query );
	
			if ( false == $result ) {
				return false;
			}
		}
		
		return true;
	}

	$upgrades[] = new FunctionUpgrade( 
			'0.15-2',
			'Add file type column to project file table',
			'upgrade_0_15_2' );
	
	function upgrade_0_15_2() {
		global $t_project_file_table;
		
		if ( !db_field_exists( 'file_type', $t_project_file_table ) ) {
			$query = "ALTER TABLE $t_project_file_table ADD file_type VARCHAR(250) NOT NULL AFTER filesize";
	
			$result = @db_query( $query );
	
			if ( false == $result ) {
				return false;
			}
		}
		
		return true;
	}

	$upgrades[] = new SQLUpgrade(
			'0.15-3',
			'',
			"ALTER TABLE $t_bug_table CHANGE os_build os_build VARCHAR(32) NOT NULL"
		);

	$upgrades[] = new SQLUpgrade(
			'0.15-4',
			'',
			"ALTER TABLE $t_bug_table CHANGE build build VARCHAR(32) NOT NULL"
		);

	$upgrades[] = new SQLUpgrade(
			'0.15-5',
			'',
			"ALTER TABLE $t_bug_table CHANGE votes votes INT(4) NOT NULL"
		);

	$upgrades[] = new SQLUpgrade(
			'0.15-6',
			'',
			"ALTER TABLE $t_user_profile_table CHANGE os_build os_build VARCHAR(32) NOT NULL"
		);

	$upgrades[] = new SQLUpgrade(
			'0.15-7',
			'',
			"ALTER TABLE $t_user_pref_table CHANGE language language VARCHAR(32) DEFAULT 'english' NOT NULL"
		);

	$upgrades[] = new SQLUpgrade(
			'0.15-8',
			'Create bug history table',
			"CREATE TABLE IF NOT EXISTS $t_bug_history_table (
			  user_id int(7) unsigned zerofill NOT NULL default '0000000',
			  bug_id int(7) unsigned zerofill NOT NULL default '0000000',
			  date_modified datetime NOT NULL default '1970-01-01 00:00:01',
			  field_name varchar(32) NOT NULL default '',
			  old_value varchar(128) NOT NULL default '',
			  new_value varchar(128) NOT NULL default '',
			  KEY bug_id (bug_id),
			  KEY user_id (user_id))"
		);


	$upgrades[] = new FunctionUpgrade( 
			'0.15-9',
			'Add order field to project version table',
			'upgrade_0_15_9' );
	
	function upgrade_0_15_9() {
		global $t_project_version_table;
		
		if ( !db_field_exists( 'date_order', $t_project_version_table ) ) {
			$query = "ALTER TABLE $t_project_version_table ADD date_order DATETIME DEFAULT '1970-01-01 00:00:01' NOT NULL";
	
			$result = @db_query( $query );
	
			if ( false == $result ) {
				return false;
			}
		}
		
		return true;
	}
	
	return $upgrades;
?>