Here is db structure:
Code: Select all
CREATE TABLE `bids` (
`PK_ID` int(11) NOT NULL auto_increment,
`FK_USER_ID` int(11) default NULL,
`FK_PRODUCT_ID` int(11) default NULL,
`bid_price` float(11,0) default NULL,
`created_on` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (`PK_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ;