/* Update From 1.5.x to 1.6 */

ALTER TABLE  `project` MODIFY `name` varchar(100) NOT NULL default 'unknown';
/* --------------------------------------------------------------------------- */
ALTER TABLE  `project` CHANGE `active` active_enum enum('y','n') NOT NULL default 'y';
ALTER TABLE  `project` ADD COLUMN  active  BOOL  NOT NULL default 1;

UPDATE  `project` SET active=1 WHERE active_enum='y';
UPDATE  `project` SET active=0 WHERE active_enum='n';

ALTER TABLE  `project` DROP COLUMN active_enum;
/* --------------------------------------------------------------------------- */
ALTER TABLE  `project`  COMMENT='All of the project information - Updated to TL 1.6' ;