zh_bill_list.sql 1004 B

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:05:58
  11. */
  12. SET FOREIGN_KEY_CHECKS=0;
  13. -- ----------------------------
  14. -- Table structure for zh_bill_list
  15. -- ----------------------------
  16. DROP TABLE IF EXISTS `zh_bill_list`;
  17. CREATE TABLE `zh_bill_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_bill_list
  26. -- ----------------------------
  27. INSERT INTO `zh_bill_list` VALUES ('1', '测试清单', '内容', '1515981196');