|
|
update "dyh_th_third_cause" set cause_code = '24_02-46' where case_code ='24_02-51';
|
update "dyh_th_third_cause" set cause_code = '24_02-9' where case_code = '24_02-52';
|
update "dyh_th_third_cause" set cause_code = '24_02-9' where case_code = '24_02-56';
|
update "dyh_th_third_cause" set cause_code = '24_02-5' where case_code = '24_02-67';
|
update "dyh_th_third_cause" set cause_code = '24_02-25' where case_code ='24_02-70';
|
update "dyh_th_third_cause" set cause_code = '24_02-5' where case_code = '24_02-71';
|
|
|
|
update "dyh_case_info" set case_type_first = '24_01-1' ,case_type_first_name='市场监管' where case_type='24_02-59';
|
update "dyh_case_info" set case_type_first = '24_01-1' ,case_type_first_name='市场监管' where case_type='24_02-69';
|
update "dyh_case_info" set case_type_first = '24_01-1' ,case_type_first_name='市场监管' where case_type='24_02-62';
|
update "dyh_case_info" set case_type_first = '24_01-1' ,case_type_first_name='市场监管' where case_type='24_02-60';
|
update "dyh_case_info" set case_type_first = '24_01-4' ,case_type_first_name='交通运输' where case_type='24_02-58';
|
update "dyh_case_info" set case_type_first = '24_01-7' ,case_type_first_name='房屋规划' where case_type='24_02-65';
|
update "dyh_case_info" set case_type_first = '24_01-7' ,case_type_first_name='房屋规划' where case_type='24_02-64';
|
update "dyh_case_info" set case_type_first = '24_01-7' ,case_type_first_name='房屋规划' where case_type='24_02-68';
|
update "dyh_case_info" set case_type_first = '24_01-7' ,case_type_first_name='房屋规划' where case_type='24_02-66';
|
update "dyh_case_info" set case_type_first = '24_01-9' ,case_type_first_name='民事经济纠纷' where case_type='24_02-57';
|
update "dyh_case_info" set case_type_first = '24_01-9' ,case_type_first_name='民事经济纠纷' where case_type='24_02-61';
|
update "dyh_case_info" set case_type_first = '24_01-9' ,case_type_first_name='民事经济纠纷' where case_type='24_02-63';
|
|
|
|
|
|
|
|
update "dyh_case_info" set case_type = '24_02-46',case_type_name='租赁纠纷' where case_type='24_02-51';
|
update "dyh_case_info" set case_type = '24_02-9' ,case_type_name='拖欠、克扣工资' where case_type='24_02-52';
|
update "dyh_case_info" set case_type = '24_02-9' ,case_type_name='拖欠、克扣工资' where case_type='24_02-56';
|
update "dyh_case_info" set case_type = '24_02-5' ,case_type_name='网购及其他消费纠纷' where case_type='24_02-67';
|
update "dyh_case_info" set case_type = '24_02-25',case_type_name='噪声、气味、污水等环境问题' where case_type='24_02-70';
|
update "dyh_case_info" set case_type = '24_02-5' ,case_type_name='网购及其他消费纠纷' where case_type='24_02-71';
|
|
|
insert into "HUGETEST"."dyh_sy_cause"("id", "name", "level", "parent_id", "issue_id", "create_time", "update_time", "icon") VALUES('24_02-73','债务纠纷','2','24_01-11',null,'2025-07-04','2025-07-04',null);
|
insert into "HUGETEST"."dyh_sy_cause"("id", "name", "level", "parent_id", "issue_id", "create_time", "update_time", "icon") VALUES('24_02-74','涉退役军人纠纷','2','24_01-11',null,'2025-07-04','2025-07-04',null);
|
insert into "HUGETEST"."dyh_sy_cause"("id", "name", "level", "parent_id", "issue_id", "create_time", "update_time", "icon") VALUES('24_02-75','涉行政争议纠纷','2','24_01-11',null,'2025-07-04','2025-07-04',null);
|
insert into "HUGETEST"."dyh_sy_cause"("id", "name", "level", "parent_id", "issue_id", "create_time", "update_time", "icon") VALUES('24_02-76','涉法涉诉纠纷','2','24_01-11',null,'2025-07-04','2025-07-04',null);
|
|
|
delete from dyh_sy_cause where id ='24_02-51';
|
delete from dyh_sy_cause where id = '24_02-52';
|
delete from dyh_sy_cause where id = '24_02-56';
|
delete from dyh_sy_cause where id = '24_02-67';
|
delete from dyh_sy_cause where id ='24_02-70';
|
delete from dyh_sy_cause where id = '24_02-71';
|
|
|
update "dyh_sy_cause" set parent_id = '24_01-1' where id='24_02-59';
|
update "dyh_sy_cause" set parent_id = '24_01-1' where id='24_02-69';
|
update "dyh_sy_cause" set parent_id = '24_01-1' where id='24_02-62';
|
update "dyh_sy_cause" set parent_id = '24_01-1' where id='24_02-60';
|
update "dyh_sy_cause" set parent_id = '24_01-4' where id='24_02-58';
|
update "dyh_sy_cause" set parent_id = '24_01-7' where id='24_02-65';
|
update "dyh_sy_cause" set parent_id = '24_01-7' where id='24_02-64';
|
update "dyh_sy_cause" set parent_id = '24_01-7' where id='24_02-68';
|
update "dyh_sy_cause" set parent_id = '24_01-7' where id='24_02-66';
|
update "dyh_sy_cause" set parent_id = '24_01-9' where id='24_02-57';
|
update "dyh_sy_cause" set parent_id = '24_01-9' where id='24_02-61';
|
update "dyh_sy_cause" set parent_id = '24_01-9' where id='24_02-63';
|
|
|
|
|
|
update "dyh_case_info" set case_type_first = '24_01-3' ,case_type_first_name='城市管理' where case_type='24_02-25';
|
update "dyh_case_info" set case_type_first = '24_01-1' ,case_type_first_name='市场监管' where case_type='24_02-5';
|
update "dyh_case_info" set case_type_first = '24_01-2' ,case_type_first_name='劳动社保' where case_type='24_02-9';
|
