auctions.sql 958 B

123456789101112131415161718192021222324252627282930313233343536
  1. /*
  2. Navicat MySQL Data Transfer
  3. Source Server : localhost
  4. Source Server Version : 50528
  5. Source Host : localhost:3306
  6. Source Database : test
  7. Target Server Type : MYSQL
  8. Target Server Version : 50528
  9. File Encoding : 65001
  10. Date: 2013-06-02 17:52:57
  11. */
  12. SET FOREIGN_KEY_CHECKS=0;
  13. -- ----------------------------
  14. -- Table structure for `auctions`
  15. -- ----------------------------
  16. DROP TABLE IF EXISTS `auctions`;
  17. CREATE TABLE `auctions` (
  18. `id` int(11) NOT NULL,
  19. `BiddingFor` varchar(64) NOT NULL DEFAULT '(none)',
  20. `InProgress` int(11) NOT NULL DEFAULT '0',
  21. `Bid` int(11) NOT NULL DEFAULT '0',
  22. `Bidder` int(11) NOT NULL DEFAULT '0',
  23. `Expires` int(11) NOT NULL DEFAULT '0',
  24. `Wining` varchar(24) NOT NULL DEFAULT '(none)',
  25. `Increment` int(11) NOT NULL DEFAULT '0',
  26. PRIMARY KEY (`id`)
  27. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  28. -- ----------------------------
  29. -- Records of auctions
  30. -- ----------------------------