1.表结构字段变化
ALTER TABLE res ADD unit varchar(50) NULL COMMENT '计量单位';

ALTER TABLE res_c_basicinformation ADD tlabel1 varchar(50) NULL;
ALTER TABLE res_c_basicinformation ADD tunit varchar(50) NULL;
ALTER TABLE res_c_basicinformation ADD tconfdesc varchar(100) NULL;
ALTER TABLE res_c_basicinformation ADD tlocdtl varchar(100) NULL;

ALTER TABLE res_c_basicinformation ADD tlabel1status varchar(50) NULL;
ALTER TABLE res_c_basicinformation ADD tunitstatus varchar(50) NULL;
ALTER TABLE res_c_basicinformation ADD tconfdescstatus varchar(50) NULL;
ALTER TABLE res_c_basicinformation ADD tlocdtlstatus varchar(50) NULL;

ALTER TABLE res_c_basicinformation_item ADD tlabel1 varchar(50) NULL;
ALTER TABLE res_c_basicinformation_item ADD tunit varchar(50) NULL;
ALTER TABLE res_c_basicinformation_item ADD tconfdesc varchar(100) NULL;
ALTER TABLE res_c_basicinformation_item ADD tlocdtl varchar(100) NULL;


ALTER TABLE res_c_basicinformation_item ADD flabel1 varchar(50) NULL;
ALTER TABLE res_c_basicinformation_item ADD funit varchar(50) NULL;
ALTER TABLE res_c_basicinformation_item ADD fconfdesc varchar(100) NULL;
ALTER TABLE res_c_basicinformation_item ADD flocdtl varchar(100) NULL;

ALTER TABLE res_c_basicinformation_item ADD tlabel1status varchar(50) NULL;
ALTER TABLE res_c_basicinformation_item ADD tunitstatus varchar(50) NULL;
ALTER TABLE res_c_basicinformation_item ADD tconfdescstatus varchar(50) NULL;
ALTER TABLE res_c_basicinformation_item ADD tlocdtlstatus varchar(50) NULL;

update hrm_org_info set org_name='组织架构' where org_id='1';
ALTER TABLE res ADD isscrap varchar(10) DEFAULT 0 NULL;
update res set isscrap='0';