zh_project_chapter_list.sql 1.0 KB

123456789101112131415161718192021222324252627282930313233
  1. /*
  2. Navicat MySQL Data Transfer
  3. Source Server : ubuntu-jl
  4. Source Server Version : 50722
  5. Source Host : 192.168.1.70:3306
  6. Source Database : calculation
  7. Target Server Type : MYSQL
  8. Target Server Version : 50722
  9. File Encoding : 65001
  10. Date: 2019-06-05 10:08:40
  11. */
  12. SET FOREIGN_KEY_CHECKS=0;
  13. -- ----------------------------
  14. -- Table structure for zh_project_chapter_list
  15. -- ----------------------------
  16. DROP TABLE IF EXISTS `zh_project_chapter_list`;
  17. CREATE TABLE `zh_project_chapter_list` (
  18. `id` int(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id',
  19. `name` varchar(60) NOT NULL COMMENT '项目章节名称',
  20. `remark` varchar(60) DEFAULT '' COMMENT '备注',
  21. `create_time` int(10) NOT NULL COMMENT '创建时间',
  22. PRIMARY KEY (`id`)
  23. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='项目节列表数据表';
  24. -- ----------------------------
  25. -- Records of zh_project_chapter_list
  26. -- ----------------------------
  27. INSERT INTO `zh_project_chapter_list` VALUES ('1', '测试项目节', '备注内容', '1515981171');