-- MySQL Server: 5.5.29

CREATE TABLE IF NOT EXISTS `auctions` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`entity_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

INSERT INTO `auctions` (`entity_id`) VALUES
(4);


CREATE TABLE IF NOT EXISTS `bids` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `customer_id` int(10) unsigned NOT NULL,
  `auction_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `bid_amt` decimal(12,4) NOT NULL,
  PRIMARY KEY (`entity_id`),
  KEY `bid_amt_ordering` (`auction_id`,`created_at`,`bid_amt`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=70 ;

INSERT INTO `bids` (`entity_id`, `customer_id`, `auction_id`, `created_at`, `bid_amt`) VALUES
(1, 59, 4, '2012-12-13 08:16:23', '99.0000'),
(2, 88, 4, '2012-12-21 11:36:42', '500.0000'),
(3, 12, 4, '2012-12-19 07:29:22', '1111.0000');