arrestpoints.sql 948 B

1234567891011121314151617181920212223242526272829303132333435
  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:51
  11. */
  12. SET FOREIGN_KEY_CHECKS=0;
  13. -- ----------------------------
  14. -- Table structure for `arrestpoints`
  15. -- ----------------------------
  16. DROP TABLE IF EXISTS `arrestpoints`;
  17. CREATE TABLE `arrestpoints` (
  18. `id` int(2) NOT NULL AUTO_INCREMENT,
  19. `PosX` float(10,5) NOT NULL DEFAULT '0.00000',
  20. `PosY` float(10,5) NOT NULL DEFAULT '0.00000',
  21. `PosZ` float(10,5) NOT NULL DEFAULT '0.00000',
  22. `VW` int(5) NOT NULL DEFAULT '0',
  23. `Int` int(5) NOT NULL DEFAULT '0',
  24. `Type` int(1) NOT NULL DEFAULT '0',
  25. PRIMARY KEY (`id`)
  26. ) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8;
  27. -- ----------------------------
  28. -- Records of arrestpoints
  29. -- ----------------------------