[Mantisbt-cvs] mantisbt/admin admin_upgrade_0_18_0.php,1.3,1.4

[<vb...@us...>]

Update of /cvsroot/mantisbt/mantisbt/admin
In directory usw-pr-cvs1:/tmp/cvs-serv20625/admin

Modified Files:
	admin_upgrade_0_18_0.php 
Log Message:
- Fixed a warning that showed up twice because the customisation feature is ON and not used.
- Added the SQL tables to create the new table to the 0.17.x to 0.18.x upgrade script in the admin folder.
- Removed a couple of echo's that were used for debugging and were left there.

Index: admin_upgrade_0_18_0.php
===================================================================
RCS file: /cvsroot/mantisbt/mantisbt/admin/admin_upgrade_0_18_0.php,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- admin_upgrade_0_18_0.php	8 Jun 2002 23:54:40 -0000	1.3
+++ admin_upgrade_0_18_0.php	10 Aug 2002 11:17:31 -0000	1.4
@@ -6,7 +6,27 @@
 
 	# START OF UPGRADE SQL STATEMENTS
 	# --- LATEST CHANGES SHOULD GO AT THE BOTTOM ---
-	
+
+	$upgrade_obj->AddItem( "# Mantis Project Customization" );
+	$upgrade_obj->AddItem( "CREATE TABLE mantis_project_customization_table ".
+	                       "(project_id int(7) unsigned zerofill NOT NULL default '0000000', ".
+						   "priorities varchar(200) NOT NULL default '', ".
+						   "severities varchar(200) NOT NULL default '', ".
+						   "reproducibilities varchar(200) NOT NULL default '', ".
+						   "states varchar(200) NOT NULL default '', ".
+						   "resolutions varchar(200) NOT NULL default '', ".
+						   "projections varchar(200) NOT NULL default '', ".
+						   "etas varchar(200) NOT NULL default '', ".
+						   "colors varchar(160) NOT NULL default '', ".
+						   "KEY project_id (project_id))" );
+	$upgrade_obj->AddItem();
+
+	$upgrade_obj->AddItem( "# Printing Preference Table" );
+	$upgrade_obj->AddItem( "CREATE TABLE mantis_user_print_pref_table (user_id int(7) unsigned zerofill NOT ".
+	                       "NULL default '0000000', print_pref varchar(27) NOT NULL default '', PRIMARY KEY ".
+						   "(user_id))" );
+	$upgrade_obj->AddItem();
+
 	$upgrade_obj->AddItem( "# Bug history" );
 	$upgrade_obj->AddItem( "ALTER TABLE mantis_bug_history_table ADD type INT(2) NOT NULL" );
 	$upgrade_obj->AddItem();