auction_bid.sql 377 B

123456789101112
  1. -- ---------------------------
  2. -- Table structure for auction_bid
  3. -- ---------------------------
  4. CREATE TABLE IF NOT EXISTS auction_bid (
  5. id INT NOT NULL default 0,
  6. auctionId INT NOT NULL default 0,
  7. bidderId INT NOT NULL default 0,
  8. bidderName varchar(50) NOT NULL,
  9. maxBid int(11) NOT NULL default 0,
  10. PRIMARY KEY (auctionId, bidderId),
  11. KEY id (id)
  12. );