auction_bid.sql 460 B

1234567891011121314
  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. clan_name varchar(50) NOT NULL,
  10. maxBid int(11) NOT NULL default 0,
  11. time_bid decimal(20,0) NOT NULL default '0',
  12. PRIMARY KEY (auctionId, bidderId),
  13. KEY id (id)
  14. );