# $Id: upgrade_101_to_102.sql,v 1.5.12.2 2007/03/17 19:57:01 caseydk Exp $
#
# Upgrade dotProject DB Schema
# Version 1.0.1 to release 1.0.2
#
# NOTE: This will NOT upgrade older releases to release 1.0.1
#       You must apply older upgrade script first
#
# !                  W A R N I N G                !
# !BACKUP YOU DATABASE BEFORE APPLYING THIS SCRIPT!
# !                  W A R N I N G                !
#
# 00000000
# add task_departments and contacts to task table
ALTER TABLE `tasks` ADD `task_departments` CHAR( 100 ) ;
ALTER TABLE `tasks` ADD `task_contacts` CHAR( 100 ) ;

# add contact_department to contacts table
ALTER TABLE `contacts` ADD `contact_department` TINYTEXT AFTER `contact_company` ;
ALTER TABLE `contacts` CHANGE `icon` `contact_icon` VARCHAR( 20 ) NULL DEFAULT 'obj/contact';

# add custom info to tasks
ALTER TABLE `tasks` ADD `task_custom` LONGTEXT;

# custom info on companies
ALTER TABLE `companies` ADD `company_custom` LONGTEXT;

#
ALTER TABLE `tasks` DROP INDEX `idx_task_owner`;
ALTER TABLE `tasks` ADD INDEX `idx_task_owner` (`task_owner`);

# IMPORTANT NOTICE #
# This line will reset all dynamic tasks, and is required due to the
# changed nature of dynamic tasks.  Please check the release notices
# for details of the new functionality

UPDATE `tasks` SET `task_dynamic` = 0 WHERE `task_dynamic` = 1;