update20201126.sql 3.4 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768
  1. ALTER TABLE `zh_tender`
  2. ADD COLUMN `copy_id` INT(10) NULL COMMENT '被拷贝标段id' AFTER `uuid`;
  3. ALTER TABLE `zh_change_audit_list` ADD `gcl_id` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '台账对应id(非准确)' AFTER `xmj_jldy`;
  4. UPDATE `zh_change_audit_list` SET `gcl_id`=`lid` WHERE `lid` != '0';
  5. -- sync2bim相关
  6. ALTER TABLE `zh_s2b_proj`
  7. ADD COLUMN `merge_code` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 AFTER `common_option`;
  8. -- ----------------------------
  9. -- Table structure for zh_tender_tag
  10. -- ----------------------------
  11. CREATE TABLE `zh_tender_tag` (
  12. `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  13. `tid` int(11) NOT NULL COMMENT '标段id',
  14. `pid` int(11) NOT NULL COMMENT '项目id',
  15. `ledger_time` datetime DEFAULT NULL COMMENT '台账分解审批完成时间',
  16. `revise_time` datetime DEFAULT NULL COMMENT '最后一次台账修订审批完成时间',
  17. `stage_time` datetime DEFAULT NULL COMMENT '最后一次期审批完成时间',
  18. `bgl_time` datetime DEFAULT NULL COMMENT '最后一次变更令审批完成时间',
  19. PRIMARY KEY (`id`)
  20. ) ENGINE=InnoDB AUTO_INCREMENT=2049 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  21. -- ----------------------------
  22. -- Table structure for zh_s2b_proj_push
  23. -- ----------------------------
  24. CREATE TABLE `zh_s2b_proj_push` (
  25. `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  26. `pid` int(11) NOT NULL COMMENT '项目id-zh_s2b_proj中的id',
  27. `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '名称',
  28. `url` varchar(255) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT '推送的url',
  29. `ledger` tinyint(1) NOT NULL DEFAULT '1' COMMENT '台账审批通过-是否推送',
  30. `revise` tinyint(1) NOT NULL DEFAULT '1' COMMENT '台账修订审批通过-是否推送',
  31. `stage` tinyint(1) NOT NULL DEFAULT '1' COMMENT '期审批通过-是否推送',
  32. `bgl` tinyint(1) NOT NULL DEFAULT '1' COMMENT '变更令审批通过-是否需要推送',
  33. `add_time` datetime(4) DEFAULT NULL COMMENT '创建时间',
  34. `lastest_time` datetime(4) DEFAULT NULL COMMENT '最后修改时间',
  35. `push_time` datetime(4) DEFAULT NULL COMMENT '最近一次推送时间',
  36. PRIMARY KEY (`id`)
  37. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  38. Insert Into zh_tender_tag (tid, pid) Select id, project_id From zh_tender Where 1=1;
  39. -- ----------------------------
  40. -- Table structure for zh_s2b_push_log
  41. -- ----------------------------
  42. CREATE TABLE `zh_s2b_push_log` (
  43. `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  44. `pid` int(11) NOT NULL COMMENT '项目id',
  45. `push_id` int(11) NOT NULL COMMENT '推送id',
  46. `url` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '推送url',
  47. `push_data` text COLLATE utf8_unicode_ci COMMENT '推送内容',
  48. `push_time` datetime NOT NULL COMMENT '推送时间',
  49. `push_result` text COLLATE utf8_unicode_ci COMMENT '推送结果',
  50. `push_err` varchar(1000) CHARACTER SET utf8 DEFAULT NULL COMMENT '推送错误',
  51. PRIMARY KEY (`id`)
  52. ) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  53. ALTER TABLE `zh_s2b_c_proj`
  54. ADD COLUMN `push_tender` varchar(1000) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT '推送的标段' AFTER `base_data`;
  55. ALTER TABLE `zh_s2b_proj`
  56. ADD COLUMN `filter_tender` varchar(1000) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT '过滤标段' AFTER `merge_code`;
  57. ALTER TABLE `zh_category_value` ADD `sort` int(11) DEFAULT NULL COMMENT '排序' AFTER `value`;
  58. UPDATE `zh_category_value` SET `sort`=`id`;