CREATE TABLE `tasktypes` (
`id` INT(10) NOT NULL AUTO_INCREMENT ,
`name` VARCHAR(100) NOT NULL ,
`isDefault` TINYINT(1) NOT NULL DEFAULT '0' ,
`active` TINYINT(1) NOT NULL DEFAULT '1' ,
`created` DATETIME NOT NULL DEFAULT '0001-01-01 00:00:00' ,
`createdById` INT(10) NOT NULL DEFAULT '10' ,
`updated` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ,
`updatedById` INT(10) NOT NULL DEFAULT '10' ,    PRIMARY KEY  (`id`)) ENGINE = InnoDB;

ALTER TABLE `tasktypes` ADD INDEX(`name`);
ALTER TABLE `tasktypes` ADD INDEX(`isDefault`);

INSERT INTO `tasktypes` (`id`, `name`, `isDefault`, `active`, `created`, `createdById`, `updated`, `updatedById`) VALUES
    ('1', 'Pre Hire Check', 1, 1, NOW(), 10, NOW(), 10),
    ('2', 'Post Hire Check', 1, 1, NOW(), 10, NOW(), 10),
    ('3', 'RMA Hireable Item Check', 1, 1, NOW(), 10, NOW(), 10);
