nation_queue.sql 855 B

12345678910111213141516171819202122232425262728293031323334
  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:56:17
  11. */
  12. SET FOREIGN_KEY_CHECKS=0;
  13. -- ----------------------------
  14. -- Table structure for `nation_queue`
  15. -- ----------------------------
  16. DROP TABLE IF EXISTS `nation_queue`;
  17. CREATE TABLE `nation_queue` (
  18. `id` int(11) NOT NULL AUTO_INCREMENT,
  19. `playerid` int(11) NOT NULL,
  20. `name` varchar(24) DEFAULT NULL,
  21. `date` datetime NOT NULL,
  22. `nation` int(1) NOT NULL,
  23. `status` int(1) NOT NULL DEFAULT '1',
  24. PRIMARY KEY (`id`)
  25. ) ENGINE=InnoDB AUTO_INCREMENT=4585 DEFAULT CHARSET=utf8;
  26. -- ----------------------------
  27. -- Records of nation_queue
  28. -- ----------------------------