26 lines
4.1 KiB
SQL
26 lines
4.1 KiB
SQL
INSERT INTO hrsa_formula (id, name, description, module, use_for, reference_type, return_type, validate_type, extend_param, formula, formulaRunScript, creator, delete_type, create_time, update_time) VALUES (1653993466778, '무駕1', '구鬧', 'salary', 'salaryitem', 'formula', 'number', 'number', '{}', '{작셕淚淃맒속왱뇜.작셕遼렛덞운적口}', 'addUpDeductions_addUpHousingLoanInterest', 1, 0, '2022-05-31 18:37:47', '2022-05-31 18:37:47');
|
||
INSERT INTO hrsa_formula_var ( id , name , formula_id , field_id , field_name , field_type , source , order_index , creator , delete_type , create_time , update_time ) VALUES (1653993466787, '작셕遼렛덞운적口', 1653993466778, 'addUpDeductions_addUpHousingLoanInterest', '{작셕淚淃맒속왱뇜.작셕遼렛덞운적口}', 'number', 'addUpDeductions', 0, 1, 0, '2022-05-31 18:37:47', '2022-05-31 18:37:47');
|
||
|
||
|
||
INSERT INTO hrsa_formula ( id , name , description , module , use_for , reference_type , return_type , validate_type , extend_param , formula , formulaRunScript , creator , delete_type , create_time , update_time ) VALUES (1653993837931, '무駕1', '구鬧', 'salary', 'salaryitem', 'formula', 'number', 'number', '{}', '{작셕淚淃맒속왱뇜.작셕遼렛理쏜}', 'addUpDeductions_addUpHousingRent', 1, 0, '2022-05-31 18:43:58', '2022-05-31 18:43:58');
|
||
INSERT INTO hrsa_formula_var ( id , name , formula_id , field_id , field_name , field_type , source , order_index , creator , delete_type , create_time , update_time ) VALUES (1653993837947, '작셕遼렛理쏜', 1653993837931, 'addUpDeductions_addUpHousingRent', '{작셕淚淃맒속왱뇜.작셕遼렛理쏜}', 'number', 'addUpDeductions', 0, 1, 0, '2022-05-31 18:43:58', '2022-05-31 18:43:58');
|
||
|
||
INSERT INTO hrsa_formula ( id , name , description , module , use_for , reference_type , return_type , validate_type , extend_param , formula , formulaRunScript , creator , delete_type , create_time , update_time ) VALUES (1653993954233, '무駕1', '구鬧', 'salary', 'salaryitem', 'formula', 'number', 'number', '{}', '{작셕淚淃맒속왱뇜.작셕셨崎싱搗}', 'addUpDeductions_addUpContinuingEducation', 1, 0, '2022-05-31 18:45:54', '2022-05-31 18:45:54');
|
||
INSERT INTO hrsa_formula_var ( id , name , formula_id , field_id , field_name , field_type , source , order_index , creator , delete_type , create_time , update_time ) VALUES (1653993954257, '작셕셨崎싱搗', 1653993954233, 'addUpDeductions_addUpContinuingEducation', '{작셕淚淃맒속왱뇜.작셕셨崎싱搗}', 'number', 'addUpDeductions', 0, 1, 0, '2022-05-31 18:45:54', '2022-05-31 18:45:54');
|
||
|
||
|
||
INSERT INTO hrsa_formula ( id , name , description , module , use_for , reference_type , return_type , validate_type , extend_param , formula , formulaRunScript , creator , delete_type , create_time , update_time ) VALUES (1653994061764, '무駕1', '구鬧', 'salary', 'salaryitem', 'formula', 'number', 'number', '{}', '{작셕淚淃맒속왱뇜.작셕<EC9E91>楠일훙}', 'addUpDeductions_addUpSupportElderly', 1, 0, '2022-05-31 18:47:42', '2022-05-31 18:47:42');
|
||
INSERT INTO hrsa_formula_var ( id , name , formula_id , field_id , field_name , field_type , source , order_index , creator , delete_type , create_time , update_time ) VALUES (1653994061780, '작셕<EFBFBD>楠일훙', 1653994061764, 'addUpDeductions_addUpSupportElderly', '{작셕淚淃맒속왱뇜.작셕<EC9E91>楠일훙}', 'number', 'addUpDeductions', 0, 1, 0, '2022-05-31 18:47:42', '2022-05-31 18:47:42');
|
||
|
||
|
||
|
||
update hrsa_sys_salary_item set formula_id = 1653993466778 where id = 674853617092214800;
|
||
update hrsa_sys_salary_item set formula_id = 1653993837931 where id = 674853617092214801;
|
||
update hrsa_sys_salary_item set formula_id = 1653993954233 where id = 674853617092214802;
|
||
update hrsa_sys_salary_item set formula_id = 1653994061764 where id = 674853617092214803;
|
||
|
||
|
||
update hrsa_salary_item set formula_id = 1653993466778 where sys_salary_item_id = 674853617092214800;
|
||
update hrsa_salary_item set formula_id = 1653993837931 where sys_salary_item_id = 674853617092214801;
|
||
update hrsa_salary_item set formula_id = 1653993954233 where sys_salary_item_id = 674853617092214802;
|
||
update hrsa_salary_item set formula_id = 1653994061764 where sys_salary_item_id = 674853617092214803; |