update.sql 2.2 KB

12345678910111213141516171819202122232425262728293031323334
  1. ALTER TABLE `zh_budget_std`
  2. ADD COLUMN `zb_chapter_id` varchar(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT '招标-项目节-id列表(\',\'分隔)' AFTER `in_time`,
  3. ADD COLUMN `zb_template_id` varchar(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT '招标-新建模板-id列表(\',\'分隔)' AFTER `zb_chapter_id`,
  4. ADD COLUMN `zb_bills_id` varchar(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT '招标-工程量清单-id列表(\',\'分隔)' AFTER `zb_template_id`;
  5. CREATE TABLE `zh_budget_zb` (
  6. `id` varchar(36) NOT NULL COMMENT 'uuid',
  7. `bid` int(10) NOT NULL COMMENT '概算投资项目id',
  8. `tree_id` int(10) NOT NULL COMMENT '节点id',
  9. `tree_pid` int(10) NOT NULL COMMENT '父节点id',
  10. `level` tinyint(4) NOT NULL COMMENT '层级',
  11. `order` mediumint(4) NOT NULL DEFAULT '0' COMMENT '同级排序',
  12. `full_path` varchar(255) DEFAULT '' COMMENT '层级定位辅助字段parent.full_path-tree_id',
  13. `is_leaf` tinyint(1) NOT NULL COMMENT '是否叶子节点,界面显示辅助字段',
  14. `code` varchar(50) DEFAULT '' COMMENT '节点编号',
  15. `b_code` varchar(50) DEFAULT NULL,
  16. `name` varchar(255) DEFAULT NULL COMMENT '名称',
  17. `unit` varchar(15) DEFAULT '' COMMENT '单位',
  18. `unit_price` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '单价',
  19. `quantity` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '数量',
  20. `total_price` decimal(24,8) DEFAULT '0.00000000' COMMENT '金额',
  21. `dgn_qty1` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '设计数量1',
  22. `dgn_qty2` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '设计数量2',
  23. `drawing_code` varchar(255) DEFAULT NULL COMMENT '图册号',
  24. `memo` varchar(1000) DEFAULT '' COMMENT '备注',
  25. `node_type` int(4) unsigned DEFAULT '0' COMMENT '节点类别',
  26. `source` varchar(30) DEFAULT '' COMMENT '添加源',
  27. `remark` varchar(60) DEFAULT '' COMMENT '备注',
  28. PRIMARY KEY (`id`),
  29. KEY `idx_bid` (`bid`),
  30. KEY `idx_tree_pid` (`tree_pid`),
  31. KEY `idx_level` (`level`),
  32. KEY `idx_full_path` (`bid`,`full_path`) USING BTREE
  33. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='招标预算数据';