CREATE TABLE `eb_licMgntLog` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `logDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `licId` int(10) unsigned NOT NULL,
  `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 NULL,
  `noLicense` int(10) unsigned NOT NULL DEFAULT '0',
  `datePurchase` datetime DEFAULT NULL,
  `modDate` datetime NOT NULL,
  `poNum` varchar(50) NOT NULL DEFAULT '',
  `vendor` varchar(255) NOT NULL DEFAULT '',
  `startDate` datetime DEFAULT NULL,
  `endDate` datetime DEFAULT NULL,
  `note` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `id` (`licId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

