update.sql 9.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142
  1. ALTER TABLE `zh_material_checklist` CHANGE `unit_price` `unit_price` DECIMAL(30,8) NULL DEFAULT NULL COMMENT '单价';
  2. ALTER TABLE `zh_material_checklist` CHANGE `quantity` `quantity` DECIMAL(30,8) NULL DEFAULT NULL COMMENT '数量(工程量)';
  3. ALTER TABLE `zh_material_checklist` CHANGE `total_price` `total_price` DECIMAL(30,8) NULL DEFAULT NULL COMMENT '金额';
  4. ALTER TABLE `zh_change` ADD `up_decimal` TINYINT(2) NULL DEFAULT NULL COMMENT '数量小数位数' AFTER `tp_decimal`;
  5. ALTER TABLE `zh_rpt_custom_define`
  6. ADD COLUMN `material_sum_select` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT '用户定制信息 - 材差 - 多期汇总表' AFTER `stage_select`;
  7. ALTER TABLE `zh_change`
  8. ADD COLUMN `selected` tinyint(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '报表用,是否选择' AFTER `tid`;
  9. ALTER TABLE `zh_change_project`
  10. ADD COLUMN `selected` tinyint(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '报表用,是否选择' AFTER `tid`;
  11. ALTER TABLE `zh_change_apply`
  12. ADD COLUMN `selected` tinyint(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '报表用,是否选择' AFTER `tid`;
  13. CREATE TABLE `zh_change_apply` (
  14. `id` int(11) NOT NULL AUTO_INCREMENT,
  15. `tid` int(11) NOT NULL COMMENT '标段id',
  16. `selected` tinyint(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '报表用,是否选择',
  17. `uid` int(11) NOT NULL COMMENT '发起人',
  18. `code` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '申请编号',
  19. `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '申请名称(变更工程名称)',
  20. `in_time` datetime NOT NULL COMMENT '创建时间',
  21. `status` tinyint(2) NOT NULL COMMENT '申请状态',
  22. `times` tinyint(2) NOT NULL COMMENT '申请次数',
  23. `project_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '变更意向编号',
  24. `notice_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '通知书编号',
  25. `notice_uid` int(11) NULL DEFAULT NULL COMMENT '通知书发起人',
  26. `org_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '原设计图名称',
  27. `peg` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '桩号',
  28. `new_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '图号',
  29. `c_new_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '变更图号',
  30. `design_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '变更设计名称',
  31. `class` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '变更类别',
  32. `quality` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '变更性质',
  33. `org_price` decimal(30, 8) NULL DEFAULT NULL COMMENT '原工程造价(元)',
  34. `change_price` decimal(30, 8) NULL DEFAULT NULL COMMENT '变更后工程造价(元)',
  35. `crease_price` decimal(30, 8) NULL DEFAULT NULL COMMENT '工程造价增减(元)',
  36. `reason` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT '变更原因',
  37. `org_content` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT '原设计情况描述',
  38. `site_content` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT '现场实际情况描述',
  39. `content` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT '变更内容',
  40. PRIMARY KEY (`id`) USING BTREE
  41. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '变更申请表' ROW_FORMAT = Dynamic;
  42. CREATE TABLE `zh_change_apply_attachment` (
  43. `id` int(11) NOT NULL AUTO_INCREMENT,
  44. `tid` int(11) NOT NULL COMMENT '标段id',
  45. `caid` int(11) NOT NULL COMMENT '申请id',
  46. `type` tinyint(1) NULL DEFAULT NULL COMMENT '文件类型',
  47. `uid` int(11) NOT NULL COMMENT '上传者id',
  48. `filename` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '文件名称',
  49. `fileext` varchar(5) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '文件后缀',
  50. `filesize` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '文件大小',
  51. `filepath` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '文件存储路径',
  52. `upload_time` datetime NOT NULL COMMENT '上传时间',
  53. `extra_upload` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否为审核通过后再次上传的文件,0为否',
  54. PRIMARY KEY (`id`) USING BTREE,
  55. INDEX `idx_cid`(`caid`) USING BTREE
  56. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '变更申请附件表' ROW_FORMAT = Dynamic;
  57. CREATE TABLE `zh_change_apply_audit` (
  58. `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  59. `tid` int(11) NOT NULL COMMENT '标段id',
  60. `caid` int(11) NOT NULL COMMENT '申请id',
  61. `aid` int(11) NOT NULL COMMENT '审批人id',
  62. `order` int(11) NOT NULL COMMENT '审批顺序',
  63. `times` int(11) NOT NULL COMMENT '审批次数',
  64. `status` tinyint(1) NOT NULL COMMENT '审批状态',
  65. `begin_time` datetime NULL DEFAULT NULL COMMENT '开始审批时间',
  66. `end_time` datetime NULL DEFAULT NULL COMMENT '结束审批时间',
  67. `opinion` varchar(1000) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '审批意见',
  68. PRIMARY KEY (`id`) USING BTREE
  69. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '变更申请审批表' ROW_FORMAT = Dynamic;
  70. CREATE TABLE `zh_change_project` (
  71. `id` int(11) NOT NULL AUTO_INCREMENT,
  72. `tid` int(11) NOT NULL COMMENT '标段id',
  73. `selected` tinyint(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '报表用,是否选择',
  74. `uid` int(11) NOT NULL COMMENT '发起人',
  75. `code` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '立项书编号',
  76. `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '立项书名称',
  77. `in_time` datetime NOT NULL COMMENT '发起时间',
  78. `status` tinyint(2) NOT NULL COMMENT '立项状态',
  79. `times` tinyint(2) NOT NULL COMMENT '审批次数',
  80. `type` tinyint(1) NOT NULL COMMENT '立项书类型',
  81. `org_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '原设计图名称',
  82. `peg` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '桩号',
  83. `new_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '图号',
  84. `class` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '变更类别',
  85. `quality` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '变更性质',
  86. `org_price` decimal(30, 8) NULL DEFAULT NULL COMMENT '原工程造价(元)',
  87. `change_price` decimal(30, 8) NULL DEFAULT NULL COMMENT '预计变更造价(元)',
  88. `crease_price` decimal(30, 8) NULL DEFAULT NULL COMMENT '预计造价增减(元)',
  89. `reason` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT '变更原因',
  90. `content` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT '内容摘要',
  91. PRIMARY KEY (`id`) USING BTREE
  92. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '变更立项表' ROW_FORMAT = Dynamic;
  93. CREATE TABLE `zh_change_project_attachment` (
  94. `id` int(11) NOT NULL AUTO_INCREMENT,
  95. `tid` int(11) NOT NULL COMMENT '标段id',
  96. `cpid` int(11) NOT NULL COMMENT '立项id',
  97. `uid` int(11) NOT NULL COMMENT '上传者id',
  98. `filename` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '文件名称',
  99. `fileext` varchar(5) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '文件后缀',
  100. `filesize` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '文件大小',
  101. `filepath` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '文件存储路径',
  102. `upload_time` datetime NOT NULL COMMENT '上传时间',
  103. `extra_upload` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否为审核通过后再次上传的文件,0为否',
  104. PRIMARY KEY (`id`) USING BTREE,
  105. INDEX `idx_cid`(`cpid`) USING BTREE
  106. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '变更立项附件表' ROW_FORMAT = Dynamic;
  107. CREATE TABLE `zh_change_project_audit` (
  108. `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  109. `tid` int(11) NOT NULL COMMENT '标段id',
  110. `cpid` int(11) NOT NULL COMMENT '立项id',
  111. `aid` int(11) NOT NULL COMMENT '审批人id',
  112. `order` int(11) NOT NULL COMMENT '审批顺序',
  113. `times` int(11) NOT NULL COMMENT '审批次数',
  114. `status` tinyint(1) NOT NULL COMMENT '审批状态',
  115. `begin_time` datetime NULL DEFAULT NULL COMMENT '开始审批时间',
  116. `end_time` datetime NULL DEFAULT NULL COMMENT '结束审批时间',
  117. `opinion` varchar(1000) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '审批意见',
  118. PRIMARY KEY (`id`) USING BTREE
  119. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '变更立项审批表' ROW_FORMAT = Dynamic;
  120. CREATE TABLE `zh_change_project_xs_audit` (
  121. `id` int(11) NOT NULL AUTO_INCREMENT,
  122. `tid` int(11) NOT NULL COMMENT '标段id',
  123. `cpid` int(11) NOT NULL COMMENT '立项id',
  124. `aid` int(11) NOT NULL COMMENT '人员id',
  125. `for_aid` int(11) NOT NULL COMMENT '添加人id',
  126. `in_time` datetime NOT NULL COMMENT '入库时间',
  127. PRIMARY KEY (`id`) USING BTREE,
  128. INDEX `cpid`(`cpid`) USING BTREE,
  129. INDEX `tid`(`tid`) USING BTREE
  130. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '立项协审人' ROW_FORMAT = Dynamic;