update20200903.sql 6.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116
  1. CREATE TABLE `zh_notice` (
  2. `id` int(11) NOT NULL AUTO_INCREMENT,
  3. `type` int(11) NOT NULL COMMENT '推送的类型',
  4. `uid` int(11) NOT NULL COMMENT '接收者id',
  5. `status` int(11) NOT NULL COMMENT '状态',
  6. `is_read` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否已读,0:未读,1:已读',
  7. `create_time` datetime DEFAULT CURRENT_TIMESTAMP,
  8. `pid` int(11) NOT NULL COMMENT '项目id',
  9. `content` text COLLATE utf8_unicode_ci NOT NULL COMMENT '推送必要的查询字段,如 ''{tid, mid}''',
  10. PRIMARY KEY (`id`)
  11. ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='关注推送表';
  12. SELECT * FROM calculation.zh_notice;
  13. -- ----------------------------
  14. -- 以上于2020-7-29 18:00 因更新至prod,尚未更新uat,如需增加sql,请一定在其后添加
  15. -- ----------------------------
  16. ALTER TABLE `zh_ledger`
  17. ADD COLUMN `gxby_status` tinyint(4) NULL DEFAULT -1 COMMENT '工序报验-状态' AFTER `qtcl_expr`,
  18. ADD COLUMN `dagl_status` tinyint(4) NULL DEFAULT -1 COMMENT '档案管理-状态' AFTER `gxby_status`;
  19. ALTER TABLE `zh_revise_bills`
  20. ADD COLUMN `gxby_status` tinyint(4) NULL DEFAULT -1 COMMENT '工序报验状态' AFTER `sjcl_expr`,
  21. ADD COLUMN `dagl_status` tinyint(4) NULL DEFAULT -1 COMMENT '档案管理状态' AFTER `gxby_status`;
  22. ALTER TABLE `zh_pos`
  23. ADD COLUMN `gxby_status` tinyint(4) NULL DEFAULT -1 COMMENT '工序报验-状态' AFTER `real_qty`,
  24. ADD COLUMN `dagl_status` tinyint(4) NULL DEFAULT -1 COMMENT '档案管理-状态' AFTER `gxby_status`;
  25. ALTER TABLE `zh_revise_pos`
  26. ADD COLUMN `gxby_status` tinyint(4) NULL DEFAULT -1 COMMENT '工序报验-状态' AFTER `real_qty`,
  27. ADD COLUMN `dagl_status` tinyint(4) NULL DEFAULT -1 COMMENT '档案管理-状态' AFTER `gxby_status`;
  28. ALTER TABLE `zh_tender`
  29. ADD COLUMN `uuid` varchar(50) CHARACTER SET ascii COLLATE ascii_general_ci NULL DEFAULT NULL COMMENT 'uuid' AFTER `deal_tp`;
  30. CREATE TABLE `zh_s2b_log` (
  31. `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  32. `pid` int(11) NOT NULL COMMENT '项目id',
  33. `tid` int(11) NOT NULL COMMENT '标段id',
  34. `url` varchar(255) CHARACTER SET utf8 NOT NULL COMMENT '请求url',
  35. `post_data` text CHARACTER SET utf8 COMMENT '请求数据',
  36. `post_data_file` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '请求数据文件(部分请求可能数据量比较大,以文件形式存储)',
  37. `result_data` text COLLATE utf8_unicode_ci,
  38. `result_data_file` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '结果数据文件(部分请求结果可能数据量比较大,以文件形式存储)',
  39. `post_time` datetime DEFAULT NULL COMMENT '请求时间',
  40. PRIMARY KEY (`id`)
  41. ) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  42. CREATE TABLE `zh_advance_pay` (
  43. `id` int(11) NOT NULL AUTO_INCREMENT,
  44. `uid` int(11) NOT NULL COMMENT '创建者id',
  45. `times` int(11) DEFAULT '1' COMMENT '审批次数',
  46. `status` int(11) DEFAULT NULL COMMENT '审核状态',
  47. `tid` int(11) NOT NULL COMMENT '标段id',
  48. `order` int(11) DEFAULT NULL COMMENT '期数索引',
  49. `type` int(1) NOT NULL DEFAULT '0' COMMENT '预付款类型,0为开工预付款,1为材料预付款',
  50. `pay_ratio` decimal(5,2) DEFAULT NULL COMMENT '支付比例',
  51. `cur_amount` decimal(24,8) DEFAULT NULL COMMENT '本期金额',
  52. `prev_amount` decimal(24,8) DEFAULT NULL COMMENT '截止上期金额',
  53. `prev_total_amount` decimal(24,8) DEFAULT NULL COMMENT '截止本期金额',
  54. `create_time` datetime DEFAULT CURRENT_TIMESTAMP,
  55. `remark` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '备注',
  56. `end_time` datetime DEFAULT NULL,
  57. PRIMARY KEY (`id`)
  58. ) ENGINE=InnoDB AUTO_INCREMENT=274 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='预付款记录';
  59. CREATE TABLE `zh_advance_audit` (
  60. `id` int(11) NOT NULL AUTO_INCREMENT,
  61. `tid` int(11) NOT NULL COMMENT '标段id',
  62. `vid` int(11) NOT NULL COMMENT '预付款记录id',
  63. `type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '预付款类型,0为开工预付款,1为材料预付款',
  64. `times` tinyint(4) DEFAULT NULL COMMENT '审批次数',
  65. `order` tinyint(4) DEFAULT NULL COMMENT '审核顺序',
  66. `audit_id` int(11) DEFAULT NULL COMMENT '审核人id',
  67. `status` tinyint(1) DEFAULT NULL COMMENT '审核状态',
  68. `create_time` datetime DEFAULT NULL,
  69. `end_time` datetime DEFAULT NULL,
  70. `opinion` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '审核意见',
  71. PRIMARY KEY (`id`)
  72. ) ENGINE=InnoDB AUTO_INCREMENT=165 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='预付款审核表';
  73. CREATE TABLE `zh_advance_file` (
  74. `id` int(11) NOT NULL AUTO_INCREMENT,
  75. `tid` int(11) NOT NULL COMMENT '标段id',
  76. `vid` int(11) NOT NULL COMMENT '预付款记录id',
  77. `uid` int(11) NOT NULL COMMENT '上传者id',
  78. `create_time` datetime NOT NULL COMMENT '上传时间',
  79. `filepath` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '附件路径',
  80. `filesize` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '附件大小',
  81. `filename` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '附件名字',
  82. `fileext` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  83. PRIMARY KEY (`id`)
  84. ) ENGINE=InnoDB AUTO_INCREMENT=124 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='预付款附件';
  85. -- ----------------------------
  86. -- Table structure for zh_material_month
  87. -- ----------------------------
  88. CREATE TABLE `zh_material_month` (
  89. `id` int(11) NOT NULL AUTO_INCREMENT,
  90. `tid` int(11) NOT NULL COMMENT '标段id',
  91. `mid` int(11) NOT NULL COMMENT '调差期id',
  92. `mb_id` int(11) NOT NULL COMMENT '工料id',
  93. `msg_tp` decimal(30,8) DEFAULT NULL COMMENT '月信息单价',
  94. `yearmonth` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '对应年月份',
  95. PRIMARY KEY (`id`),
  96. KEY `mid` (`mid`)
  97. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='调差月信息价工料单价表';
  98. ALTER TABLE `zh_material` ADD `months` VARCHAR(1000) NULL DEFAULT NULL COMMENT '月信息价-年月份列表' AFTER `s_order`;
  99. ALTER TABLE `calculation`.`zh_material_file`
  100. ADD COLUMN `fileext` VARCHAR(45) NULL COMMENT '文件类型' AFTER `s_order`;