DROP TABLE IF EXISTS `suppliercontact`;
CREATE TABLE `suppliercontact` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `supplierId` int(10) unsigned NOT NULL DEFAULT '0',
  `name` varchar(100) NOT NULL DEFAULT '',
  `email` varchar(100) DEFAULT '',
  `contactNo` varchar(50) DEFAULT '',
  `role` varchar(100) DEFAULT '',
  `mobile` varchar(50) 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`),
  KEY `supplierId` (`supplierId`),
  KEY `name` (`name`),
  KEY `email` (`email`),
  KEY `contactNo` (`contactNo`),
  KEY `mobile` (`mobile`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
