delete from hrsa_acct_result_temp      where 1=1
;
delete from hrsa_add_up_deduction     where 1=1
;
delete from hrsa_add_up_situation     where 1=1
;
delete from hrsa_attend_quote     where 1=1
;
delete from hrsa_attend_quote_data     where 1=1
;
delete from hrsa_attend_quote_data_value     where 1=1
;
delete from hrsa_attend_quote_field     where 1=1
;
delete from hrsa_attend_quote_sync_set     where 1=1
;


delete from hrsa_scheme_detail     where 1=1
;
delete from hrsa_social_archives     where 1=1
;
delete from hrsa_fund_archives     where 1=1
;
delete from hrsa_other_archives     where 1=1
;


delete from hrsa_bill_batch     where 1=1
;

delete from hrsa_bill_detail     where 1=1
;
delete from hrsa_bill_detail_temp     where 1=1
;
delete from hrsa_bill_inspect     where 1=1
;

-- delete from hrsa_insurance_category     where 1=1
-- ;

delete from hrsa_check_result     where 1=1
;
delete from hrsa_check_result_record     where 1=1
;
delete from hrsa_ck_result_detail_temp     where 1=1
;
delete from hrsa_excel_acct_result     where 1=1
;

delete from hrsa_other_deduction     where 1=1
;
delete from hrsa_salary_acct_emp     where 1=1
;
delete from hrsa_salary_acct_record     where 1=1
;
delete from hrsa_salary_acct_result     where 1=1
;
delete from hrsa_salary_archive     where 1=1
;
delete from hrsa_salary_archive_dimission     where 1=1
;
delete from hrsa_salary_archive_item     where 1=1
;
delete from hrsa_salary_archive_tax_agent     where 1=1
;
delete from hrsa_salary_item     where 1=1
;
delete from hrsa_salary_send     where 1=1
;
delete from hrsa_salary_send_info     where 1=1
;
delete from hrsa_salary_sob     where 1=1
;
delete from hrsa_salary_sob_adjust_rule     where 1=1
;
delete from hrsa_salary_sob_emp_field     where 1=1
;
delete from hrsa_salary_sob_item     where 1=1
;
delete from hrsa_salary_sob_item_group     where 1=1
;
delete from hrsa_salary_sob_range     where 1=1
;
delete from hrsa_salary_template     where 1=1
;

delete from hrsa_social_security_scheme     where 1=1
;
delete from hrsa_sys_tax_rate_base     where 1=1
;
delete from hrsa_sys_tax_rate_detail     where 1=1
;
delete from hrsa_tax_agent     where 1=1
;
delete from hrsa_tax_agent_emp           where 1=1
;
delete from hrsa_tax_agent_emp_change where 1=1
;
delete from hrsa_tax_agent_admin where 1=1
;
delete from hrsa_tax_agent_manage_range where 1=1
;
-- delete from hrsa_tax_agent_base where 1=1
-- ;
delete from hrsa_tax_agent_sub_admin where 1=1
;
delete from hrsa_tax_agent_sub_admin_emp where 1=1
;

delete from hrsa_tax_declaration     where 1=1
;
delete from hrsa_tax_declaration_detail     where 1=1
;
delete from hrsa_tax_rate_base     where 1=1
;
delete from hrsa_tax_rate_detail     where 1=1
;
delete from hrsa_salary_acct_result_report     where 1=1
;

delete from hrsa_insurance_base_info where 1=1
;

delete from hrsa_salary_item_hide where 1=1
;

delete from hrsa_special_add_deduction where 1=1
;

delete from hrsa_excel_bill_detail   where 1=1
;

delete from hrsa_salary_send_range where 1=1
;

delete from hrsa_salary_send_range_obj where 1=1
;

delete from hrsa_compensation_log where 1=1
;

delete from hrsa_compensation_config where 1=1
;

delete from hrsa_salary_sob_back_item where 1=1
;

delete from hrsa_sub_table where 1=1
;

delete from hrsa_sub_table_item where 1=1
;

delete from hrsa_salary_stats_dim where 1=1
;

delete from hrsa_salary_stats_report where 1=1
;

delete from hrsa_salary_statistics_item where 1=1
;

delete from hrsa_charts_setting where 1=1
;

delete from hrsa_salary_echarts_setting where 1=1
;

delete from hrsa_salary_bill_watermark where 1=1
;

-- INSERT INTO hrsa_tax_agent_base(id, devolution_status, create_time, update_time, creator, delete_type, tenant_key) VALUES (1653303537239, 0, '2022-05-23 18:58:53', '2022-05-23 19:12:12', 1, 0, 'all_teams');


-- INSERT INTO hrsa_insurance_category (id, insurance_name, welfare_type, is_use, payment_scope, data_type, create_time, update_time, creator, delete_type, tenant_key) VALUES (9001, '养老保险', 1, 1, '1,2', 1, '2022-02-22 10:46:02', '2022-02-22 10:46:02', 0, 0, 'all_teams')
-- ;
-- INSERT INTO hrsa_insurance_category (id, insurance_name, welfare_type, is_use, payment_scope, data_type, create_time, update_time, creator, delete_type, tenant_key) VALUES (9002, '医疗保险', 1, 1, '1,2', 1, '2022-02-22 10:46:02', '2022-02-22 10:46:02', 0, 0, 'all_teams')
-- ;
-- INSERT INTO hrsa_insurance_category (id, insurance_name, welfare_type, is_use, payment_scope, data_type, create_time, update_time, creator, delete_type, tenant_key) VALUES (9003, '工伤保险', 1, 1, '1,2', 1, '2022-02-22 10:46:02', '2022-02-22 10:46:02', 0, 0, 'all_teams')
-- ;
-- INSERT INTO hrsa_insurance_category (id, insurance_name, welfare_type, is_use, payment_scope, data_type, create_time, update_time, creator, delete_type, tenant_key) VALUES (9004, '失业保险', 1, 1, '1,2', 1, '2022-02-22 10:46:02', '2022-02-22 10:46:02', 0, 0, 'all_teams')
-- ;
-- INSERT INTO hrsa_insurance_category (id, insurance_name, welfare_type, is_use, payment_scope, data_type, create_time, update_time, creator, delete_type, tenant_key) VALUES (9005, '生育保险', 1, 1, '1,2', 1, '2022-02-22 10:46:02', '2022-02-22 10:46:02', 0, 0, 'all_teams')
-- ;
-- INSERT INTO hrsa_insurance_category (id, insurance_name, welfare_type, is_use, payment_scope, data_type, create_time, update_time, creator, delete_type, tenant_key) VALUES (9006, '住房公积金', 2, 1, '1,2', 1, '2022-02-22 10:46:02', '2022-02-22 10:46:02', 0, 0, 'all_teams')
-- ;
-- INSERT INTO hrsa_insurance_category (id, insurance_name, welfare_type, is_use, payment_scope, data_type, create_time, update_time, creator, delete_type, tenant_key) VALUES (9007, '企业年金', 3, 1, '1,2', 1, '2022-02-22 10:46:02', '2022-02-22 10:46:02', 0, 0, 'all_teams')
-- ;
-- INSERT INTO hrsa_insurance_category (id, insurance_name, welfare_type, is_use, payment_scope, data_type, create_time, update_time, creator, delete_type, tenant_key) VALUES (9008, '补充住房公积金', 2, 1, '1,2', 1, '2022-02-22 10:46:02', '2022-02-22 10:46:02', 0, 0, 'all_teams')
-- ;




---oracle

-- INSERT INTO hrsa_tax_agent_base(id, devolution_status, create_time, update_time, creator, delete_type, tenant_key) VALUES (1653303537239, 0, to_date('2022-05-10 16:03:02','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 16:03:02','yyyy-MM-dd HH24:mi:ss'), 1, 0, 'all_teams');

-- INSERT INTO hrsa_insurance_category (id, insurance_name, welfare_type, is_use, payment_scope, data_type, create_time, update_time, creator, delete_type, tenant_key) VALUES (9001, '养老保险', 1, 1, '1,2', 1, to_date('2022-05-10 16:03:02','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 16:03:02','yyyy-MM-dd HH24:mi:ss'), 0, 0, 'all_teams')
-- ;
-- INSERT INTO hrsa_insurance_category (id, insurance_name, welfare_type, is_use, payment_scope, data_type, create_time, update_time, creator, delete_type, tenant_key) VALUES (9002, '医疗保险', 1, 1, '1,2', 1, to_date('2022-05-10 16:03:02','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 16:03:02','yyyy-MM-dd HH24:mi:ss'), 0, 0, 'all_teams')
-- ;
-- INSERT INTO hrsa_insurance_category (id, insurance_name, welfare_type, is_use, payment_scope, data_type, create_time, update_time, creator, delete_type, tenant_key) VALUES (9003, '工伤保险', 1, 1, '1,2', 1, to_date('2022-05-10 16:03:02','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 16:03:02','yyyy-MM-dd HH24:mi:ss'), 0, 0, 'all_teams')
-- ;
-- INSERT INTO hrsa_insurance_category (id, insurance_name, welfare_type, is_use, payment_scope, data_type, create_time, update_time, creator, delete_type, tenant_key) VALUES (9004, '失业保险', 1, 1, '1,2', 1, to_date('2022-05-10 16:03:02','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 16:03:02','yyyy-MM-dd HH24:mi:ss'), 0, 0, 'all_teams')
-- ;
-- INSERT INTO hrsa_insurance_category (id, insurance_name, welfare_type, is_use, payment_scope, data_type, create_time, update_time, creator, delete_type, tenant_key) VALUES (9005, '生育保险', 1, 1, '1,2', 1, to_date('2022-05-10 16:03:02','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 16:03:02','yyyy-MM-dd HH24:mi:ss'), 0, 0, 'all_teams')
-- ;
-- INSERT INTO hrsa_insurance_category (id, insurance_name, welfare_type, is_use, payment_scope, data_type, create_time, update_time, creator, delete_type, tenant_key) VALUES (9006, '住房公积金', 2, 1, '1,2', 1, to_date('2022-05-10 16:03:02','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 16:03:02','yyyy-MM-dd HH24:mi:ss'), 0, 0, 'all_teams')
-- ;
-- INSERT INTO hrsa_insurance_category (id, insurance_name, welfare_type, is_use, payment_scope, data_type, create_time, update_time, creator, delete_type, tenant_key) VALUES (9007, '企业年金', 3, 1, '1,2', 1, to_date('2022-05-10 16:03:02','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 16:03:02','yyyy-MM-dd HH24:mi:ss'), 0, 0, 'all_teams')
-- ;
-- INSERT INTO hrsa_insurance_category (id, insurance_name, welfare_type, is_use, payment_scope, data_type, create_time, update_time, creator, delete_type, tenant_key) VALUES (9008, '补充住房公积金', 2, 1, '1,2', 1, to_date('2022-05-10 16:03:02','yyyy-MM-dd HH24:mi:ss'), to_date('2022-05-10 16:03:02','yyyy-MM-dd HH24:mi:ss'), 0, 0, 'all_teams')
-- ;


