0_14_inc.php

一个bug追踪工具的PHP编写的源代码

<?php
	# Mantis - a php based bugtracking system
	# Copyright (C) 2000 - 2002  Kenzaburo Ito - [e-mail]
	# Copyright (C) 2002 - 2004  Mantis Team   - [e-mail]
	# This program is distributed under the terms and conditions of the GPL
	# See the README and LICENSE files for details

	# Changes applied to 0.14 database to give us 0.15

	# --------------------------------------------------------
	# $Id: 0_14_inc.php,v 1.9 2005/07/14 21:38:01 thraxisp Exp $
	# --------------------------------------------------------
?>
<?php
	require( dirname( dirname( __FILE__ ) ) . DIRECTORY_SEPARATOR . 'db_table_names_inc.php' );

	$upgrades = array();

# None of these have descriptions...

	$upgrades[] = new SQLUpgrade(
			'0.14a-0',
			'',
			"ALTER TABLE $t_project_table CHANGE view_state view_state VARCHAR (32) DEFAULT 'public' not null"
		);

	$upgrades[] = new SQLUpgrade(
			'0.14a-1',
			'',
			"ALTER TABLE $t_project_table CHANGE status status VARCHAR (32) DEFAULT 'development' not null"
		);

	$upgrades[] = new SQLUpgrade(
			'0.14a-2',
			'',
			"ALTER TABLE $t_user_table CHANGE access_level access_level VARCHAR (32) DEFAULT 'viewer' not null"
		);

	$upgrades[] = new SQLUpgrade(
			'0.14a-3',
			'',
			"ALTER TABLE $t_bug_table CHANGE eta eta VARCHAR (32) DEFAULT 'none' not null"
		);

	$upgrades[] = new SQLUpgrade(
			'0.14a-4',
			'',
			"ALTER TABLE $t_bug_table CHANGE projection projection VARCHAR (32) DEFAULT 'none' not null"
		);

	$upgrades[] = new SQLUpgrade(
			'0.14a-5',
			'',
			"ALTER TABLE $t_bug_table CHANGE resolution resolution VARCHAR (32) DEFAULT 'open' not null"
		);

	$upgrades[] = new SQLUpgrade(
			'0.14a-6',
			'',
			"ALTER TABLE $t_bug_table CHANGE priority priority VARCHAR (32) DEFAULT 'none' not null"
		);

	$upgrades[] = new SQLUpgrade(
			'0.14a-7',
			'',
			"ALTER TABLE $t_bug_table CHANGE status status VARCHAR (32) DEFAULT 'new' not null"
		);

	$upgrades[] = new SQLUpgrade(
			'0.14a-8',
			'',
			"ALTER TABLE $t_bug_table CHANGE severity severity VARCHAR (32) DEFAULT 'minor' not null"
		);

	$upgrades[] = new SQLUpgrade(
			'0.14a-9',
			'',
			"ALTER TABLE $t_bug_table CHANGE reproducibility reproducibility VARCHAR (32) DEFAULT 'always' not null"
		);

# Change some of the TIMESTAMP fields to DATETIME

	$upgrades[] = new SQLUpgrade(
			'0.14-0',
			'Change some of the TIMESTAMP fields to DATETIME',
			"ALTER TABLE $t_bug_table CHANGE date_submitted date_submitted DATETIME"
		);
	$upgrades[] = new SQLUpgrade(
			'0.14-1',
			'Change some of the TIMESTAMP fields to DATETIME',
			"ALTER TABLE $t_bugnote_table CHANGE date_submitted date_submitted DATETIME"
		);

	$upgrades[] = new SQLUpgrade(
			'0.14-2',
			'Change some of the TIMESTAMP fields to DATETIME',
			"ALTER TABLE $t_news_table CHANGE date_posted date_posted DATETIME"
		);

	$upgrades[] = new SQLUpgrade(
			'0.14-3',
			'Change some of the TIMESTAMP fields to DATETIME',
			"ALTER TABLE $t_user_table CHANGE date_created date_created DATETIME"
		);

# INT(1) Updates (Before ALTERation)


	$upgrades[] = new SQLUpgrade(
			'0.14-4',
			'INT(1) Updates (Before ALTERation)',
			"UPDATE $t_project_table SET enabled='0' WHERE enabled=''"
		);

	$upgrades[] = new SQLUpgrade(
			'0.14-5',
			'INT(1) Updates (Before ALTERation)',
			"UPDATE $t_project_table SET enabled='1' WHERE enabled='on'"
		);


	$upgrades[] = new SQLUpgrade(
			'0.14-6',
			'INT(1) Updates (Before ALTERation)',
			"UPDATE $t_user_pref_table SET advanced_report='0' WHERE advanced_report=''"
		);

	$upgrades[] = new SQLUpgrade(
			'0.14-7',
			'INT(1) Updates (Before ALTERation)',
			"UPDATE $t_user_pref_table SET advanced_report='1' WHERE advanced_report='on'"
		);


	$upgrades[] = new SQLUpgrade(
			'0.14-8',
			'INT(1) Updates (Before ALTERation)',
			"UPDATE $t_user_pref_table SET advanced_view='0' WHERE advanced_view=''"
		);

	$upgrades[] = new SQLUpgrade(
			'0.14-9',
			'INT(1) Updates (Before ALTERation)',
			"UPDATE $t_user_pref_table SET advanced_view='1' WHERE advanced_view='on'"
		);


	$upgrades[] = new SQLUpgrade(
			'0.14-10',
			'INT(1) Updates (Before ALTERation)',
			"UPDATE $t_user_profile_table SET default_profile='0' WHERE default_profile=''"
		);

	$upgrades[] = new SQLUpgrade(
			'0.14-11',
			'INT(1) Updates (Before ALTERation)',
			"UPDATE $t_user_profile_table SET default_profile='1' WHERE default_profile='on'"
		);


	$upgrades[] = new SQLUpgrade(
			'0.14-12',
			'INT(1) Updates (Before ALTERation)',
			"UPDATE $t_user_table SET enabled='0' WHERE enabled=''"
		);

	$upgrades[] = new SQLUpgrade(
			'0.14-13',
			'INT(1) Updates (Before ALTERation)',
			"UPDATE $t_user_table SET enabled='1' WHERE enabled='on'"
		);


	$upgrades[] = new SQLUpgrade(
			'0.14-14',
			'INT(1) Updates (Before ALTERation)',
			"UPDATE $t_user_table SET protected='0' WHERE protected=''"
		);

	$upgrades[] = new SQLUpgrade(
			'0.14-15',
			'INT(1) Updates (Before ALTERation)',
			"UPDATE $t_user_table SET protected='1' WHERE protected='on'"
		);

# Change CHAR(3) to INT(1)


	$upgrades[] = new SQLUpgrade(
			'0.14-16',
			'Change CHAR(3) to INT(1)',
			"ALTER TABLE $t_project_table CHANGE enabled enabled INT (1) not null"
		);

	$upgrades[] = new SQLUpgrade(
			'0.14-17',
			'Change CHAR(3) to INT(1)',
			"ALTER TABLE $t_user_pref_table CHANGE advanced_report advanced_report INT (1) not null"
		);

	$upgrades[] = new SQLUpgrade(
			'0.14-18',
			'Change CHAR(3) to INT(1)',
			"ALTER TABLE $t_user_pref_table CHANGE advanced_view advanced_view INT (1) not null"
		);

	$upgrades[] = new SQLUpgrade(
			'0.14-19',
			'Change CHAR(3) to INT(1)',
			"ALTER TABLE $t_user_profile_table CHANGE default_profile default_profile INT (1) not null"
		);

	$upgrades[] = new SQLUpgrade(
			'0.14-20',
			'Change CHAR(3) to INT(1)',
			"ALTER TABLE $t_user_table CHANGE enabled enabled INT (1) DEFAULT '1' not null"
		);

	$upgrades[] = new SQLUpgrade(
			'0.14-21',
			'Change CHAR(3) to INT(1)',
			"ALTER TABLE $t_user_table CHANGE protected protected INT (1) not null"
		);

# ENUM Updates (Before ALTERation)


	$upgrades[] = new SQLUpgrade(
			'0.14-22',
			'ENUM Updates (Before ALTERation)',
			"UPDATE $t_project_table SET view_state='10' WHERE view_state='public'"
		);

	$upgrades[] = new SQLUpgrade(
			'0.14-23',
			'ENUM Updates (Before ALTERation)',
			"UPDATE $t_project_table SET view_state='50' WHERE view_state='private'"
		);


	$upgrades[] = new SQLUpgrade(
			'0.14-24',
			'ENUM Updates (Before ALTERation)',
			"UPDATE $t_project_table SET status='10' WHERE status='development'"
		);

	$upgrades[] = new SQLUpgrade(
			'0.14-25',
			'ENUM Updates (Before ALTERation)',
			"UPDATE $t_project_table SET status='30' WHERE status='release'"
		);

	$upgrades[] = new SQLUpgrade(
			'0.14-26',
			'ENUM Updates (Before ALTERation)',
			"UPDATE $t_project_table SET status='50' WHERE status='stable'"
		);

	$upgrades[] = new SQLUpgrade(
			'0.14-27',
			'ENUM Updates (Before ALTERation)',
			"UPDATE $t_project_table SET status='70' WHERE status='obsolete'"
		);


	$upgrades[] = new SQLUpgrade(
			'0.14-28',
			'ENUM Updates (Before ALTERation)',
			"UPDATE $t_user_table SET access_level='10' WHERE access_level='viewer'"
		);

	$upgrades[] = new SQLUpgrade(
			'0.14-29',
			'ENUM Updates (Before ALTERation)',
			"UPDATE $t_user_table SET access_level='25' WHERE access_level='reporter'"
		);

	$upgrades[] = new SQLUpgrade(
			'0.14-30',
			'ENUM Updates (Before ALTERation)',
			"UPDATE $t_user_table SET access_level='40' WHERE access_level='updater'"
		);

	$upgrades[] = new SQLUpgrade(
			'0.14-31',
			'ENUM Updates (Before ALTERation)',
			"UPDATE $t_user_table SET access_level='55' WHERE access_level='developer'"
		);

	$upgrades[] = new SQLUpgrade(
			'0.14-32',
			'ENUM Updates (Before ALTERation)',
			"UPDATE $t_user_table SET access_level='70' WHERE access_level='manager'"
		);

	$upgrades[] = new SQLUpgrade(
			'0.14-33',
			'ENUM Updates (Before ALTERation)',
			"UPDATE $t_user_table SET access_level='90' WHERE access_level='administrator'"
		);


	$upgrades[] = new SQLUpgrade(
			'0.14-34',
			'ENUM Updates (Before ALTERation)',
			"UPDATE $t_bug_table SET eta='10' WHERE eta='none'"
		);

	$upgrades[] = new SQLUpgrade(
			'0.14-35',
			'ENUM Updates (Before ALTERation)',
			"UPDATE $t_bug_table SET eta='20' WHERE eta='< 1 day'"
		);

	$upgrades[] = new SQLUpgrade(
			'0.14-36',
			'ENUM Updates (Before ALTERation)',
			"UPDATE $t_bug_table SET eta='30' WHERE eta='2-3 days'"
		);

	$upgrades[] = new SQLUpgrade(
			'0.14-37',
			'ENUM Updates (Before ALTERation)',
			"UPDATE $t_bug_table SET eta='40' WHERE eta='< 1 week'"
		);

	$upgrades[] = new SQLUpgrade(
			'0.14-38',
			'ENUM Updates (Before ALTERation)',
			"UPDATE $t_bug_table SET eta='50' WHERE eta='< 1 month'"
		);

	$upgrades[] = new SQLUpgrade(
			'0.14-39',
			'ENUM Updates (Before ALTERation)',
			"UPDATE $t_bug_table SET eta='60' WHERE eta='> 1 month'"
		);


	$upgrades[] = new SQLUpgrade(
			'0.14-40',
			'ENUM Updates (Before ALTERation)',
			"UPDATE $t_bug_table SET projection='10' WHERE projection='none'"
		);

	$upgrades[] = new SQLUpgrade(
			'0.14-41',
			'ENUM Updates (Before ALTERation)',
			"UPDATE $t_bug_table SET projection='30' WHERE projection='tweak'"
		);

	$upgrades[] = new SQLUpgrade(
			'0.14-42',
			'ENUM Updates (Before ALTERation)',
			"UPDATE $t_bug_table SET projection='50' WHERE projection='minor fix'"
		);

	$upgrades[] = new SQLUpgrade(
			'0.14-43',
			'ENUM Updates (Before ALTERation)',
			"UPDATE $t_bug_table SET projection='70' WHERE projection='major rework'"
		);

	$upgrades[] = new SQLUpgrade(
			'0.14-44',
			'ENUM Updates (Before ALTERation)',
			"UPDATE $t_bug_table SET projection='90' WHERE projection='redesign'"
		);


	$upgrades[] = new SQLUpgrade(
			'0.14-45',
			'ENUM Updates (Before ALTERation)',
			"UPDATE $t_bug_table SET resolution='10' WHERE resolution='open'"
		);

	$upgrades[] = new SQLUpgrade(
			'0.14-46',
			'ENUM Updates (Before ALTERation)',
			"UPDATE $t_bug_table SET resolution='20' WHERE resolution='fixed'"
		);

	$upgrades[] = new SQLUpgrade(
			'0.14-47',
			'ENUM Updates (Before ALTERation)',
			"UPDATE $t_bug_table SET resolution='30' WHERE resolution='reopened'"
		);

	$upgrades[] = new SQLUpgrade(
			'0.14-48',
			'ENUM Updates (Before ALTERation)',
			"UPDATE $t_bug_table SET resolution='40' WHERE resolution='unable to duplicate'"
		);

	$upgrades[] = new SQLUpgrade(
			'0.14-49',
			'ENUM Updates (Before ALTERation)',
			"UPDATE $t_bug_table SET resolution='50' WHERE resolution='not fixable'"
		);

	$upgrades[] = new SQLUpgrade(
			'0.14-50',
			'ENUM Updates (Before ALTERation)',
			"UPDATE $t_bug_table SET resolution='60' WHERE resolution='duplicate'"
		);

	$upgrades[] = new SQLUpgrade(
			'0.14-51',
			'ENUM Updates (Before ALTERation)',
			"UPDATE $t_bug_table SET resolution='70' WHERE resolution='not a bug'"
		);

	$upgrades[] = new SQLUpgrade(
			'0.14-52',
			'ENUM Updates (Before ALTERation)',
			"UPDATE $t_bug_table SET resolution='80' WHERE resolution='suspended'"
		);


	$upgrades[] = new SQLUpgrade(
			'0.14-53',
			'ENUM Updates (Before ALTERation)',
			"UPDATE $t_bug_table SET priority='10' WHERE priority='none'"
		);

	$upgrades[] = new SQLUpgrade(
			'0.14-54',
			'ENUM Updates (Before ALTERation)',
			"UPDATE $t_bug_table SET priority='20' WHERE priority='low'"
		);