
ALTER TABLE `customer`
ADD `hasCustomerInstruction` TINYINT(1) NOT NULL DEFAULT '0' AFTER `monthlyEmail`,
ADD `customerInstructions` VARCHAR(150) NULL DEFAULT NULL AFTER `hasCustomerInstruction`,
ADD INDEX( `hasCustomerInstruction`),
ADD INDEX( `customerInstructions`);

ALTER TABLE `customer` ADD COLUMN `prospect`  tinyint(1) NOT NULL DEFAULT 0 AFTER `mageId`;
CREATE INDEX `prospect` ON `customer`(`prospect`) USING BTREE ;

DROP TABLE IF EXISTS `suppliergroup`;
CREATE TABLE `suppliergroup`(
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL DEFAULT '',
  `description` varchar(100) NOT NULL DEFAULT '',
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
  `createdById` int(10) unsigned NOT NULL DEFAULT '0',
  `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updatedById` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

ALTER TABLE `suppliergroup`
ADD INDEX( `name`);


ALTER TABLE `supplier`
ADD `supplierGroupId` INT(10) NULL DEFAULT NULL AFTER `instructions`,
ADD INDEX(`supplierGroupId`);