
CREATE TABLE `opl_ebLoan` (
  `idloan` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `bid` int(10) unsigned DEFAULT NULL,
  `uid` int(10) unsigned NOT NULL,
  `dateLoan` datetime DEFAULT NULL,
  `dateDue` datetime DEFAULT NULL,
  `dateReturn` datetime DEFAULT NULL,
  `note` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`idloan`),
  KEY `i_loan` (`bid`,`uid`,`dateLoan`,`dateDue`,`dateReturn`)
) ENGINE=MyISAM DEFAULT  CHARSET=utf8 COLLATE=utf8_unicode_ci;


