38 lines
2.4 KiB
SQL
38 lines
2.4 KiB
SQL
ALTER TABLE `ldlz_record` ADD COLUMN `zg_type` int(11) NULL COMMENT '是否全部整改 0:不需要 1:是,2否';
|
||
ALTER TABLE `sys_user` ADD COLUMN `zf_type` varchar(1) NULL COMMENT '正职 1，副职 2';
|
||
|
||
ALTER TABLE `ldlz_leave_log` ADD COLUMN `file_info` varchar(1000) NULL COMMENT '请假附件';
|
||
ALTER TABLE `ldlz_leave_log` ADD COLUMN `approver_id` bigint(20) NULL COMMENT '审批人';
|
||
ALTER TABLE `ldlz_leave_log` ADD COLUMN `approver_status` varchar(2) NULL COMMENT '审批状态 0待审批 1通过 2拒绝';
|
||
ALTER TABLE `ldlz_leave_log` ADD COLUMN `approver_comment` varchar(255) NULL COMMENT '审批意见';
|
||
ALTER TABLE `ldlz_leave_log` ADD COLUMN `approver_time` datetime NULL COMMENT '审批时间';
|
||
|
||
CREATE TABLE `ldlz_leave_apperover_log` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
|
||
`leave_id` bigint(20) DEFAULT NULL COMMENT '请假id',
|
||
`create_by` varchar(64) CHARACTER SET utf8 DEFAULT '' COMMENT '创建者',
|
||
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
|
||
`update_by` varchar(64) CHARACTER SET utf8 DEFAULT '' COMMENT '更新者',
|
||
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
|
||
`remark` varchar(500) CHARACTER SET utf8 DEFAULT NULL COMMENT '备注',
|
||
`approver_id` bigint(20) DEFAULT NULL COMMENT '审批人',
|
||
`approver_status` varchar(2) CHARACTER SET utf8 DEFAULT NULL COMMENT '审批状态 0待审批 1通过 2拒绝',
|
||
`approver_comment` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '审批意见',
|
||
`approver_time` datetime DEFAULT NULL COMMENT '审批时间',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
|
||
|
||
ALTER TABLE `ldlz_record`
|
||
ADD COLUMN `aqhd` varchar(2) NULL COMMENT '安全活动',
|
||
ADD COLUMN `aqhd_file` varchar(1000) NULL COMMENT '安全活动附件',
|
||
ADD COLUMN `aqbg` varchar(2) NULL COMMENT '安全把关',
|
||
ADD COLUMN `aqbg_file` varchar(1000) NULL COMMENT '安全把关附件',
|
||
ADD COLUMN `tctl` varchar(2) NULL COMMENT '同吃同劳动',
|
||
ADD COLUMN `tctl_file` varchar(1000) NULL COMMENT '同吃同劳动附件',
|
||
ADD COLUMN `wtjz` varchar(2) NULL COMMENT '问题解决',
|
||
ADD COLUMN `wtjz_file` varchar(1000) NULL COMMENT '问题解决附件';
|
||
|
||
ALTER TABLE `project`
|
||
ADD COLUMN `project_manager` varchar(20) NULL COMMENT '执行经理',
|
||
ADD COLUMN `project_manager_phone` varchar(255) NULL COMMENT '执行经理电话';
|