
CREATE TABLE `eb_licMgnt` (
  `licId` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(10) unsigned NOT NULL,
  `bid` int(10) unsigned DEFAULT NULL,
  `licenseType` set('free','paid','rental') CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT 'paid',
  `noLicense` int(10) unsigned NOT NULL DEFAULT '0',
  `datePurchase` datetime DEFAULT NULL,
  `modDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `poNum` varchar(50) NOT NULL DEFAULT '',
  `vendor` varchar(255) NOT NULL DEFAULT '',
  `deleted` smallint(3) DEFAULT '0',
  `startDate` datetime DEFAULT NULL,
  `endDate` datetime DEFAULT NULL,
  `note` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`licId`),
  KEY `bid` (`bid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


