
CREATE TABLE `eb_bookmark` (
  `bmId` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(10) unsigned NOT NULL,
  `bid` int(10) unsigned DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `note` text COLLATE utf8_unicode_ci,
  `fid` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `percFr` varchar(25) COLLATE utf8_unicode_ci DEFAULT '0.00',
  `percTo` varchar(25) COLLATE utf8_unicode_ci DEFAULT '0.00',
  `bmDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`bmId`),
  UNIQUE KEY `u_key` (`uid`,`bid`,`fid`,`percFr`,`percTo`),
  KEY `bmkKey` (`uid`,`bid`,`fid`),
  KEY `percent` (`percFr`,`percTo`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


