weaver-hrm-organization/sqlupgrade/GS/sql202408220201.sql

delete from HtmlLabelIndex where id = 547469 and ( trim(indexdesc) is null ) ;
/

insert into HtmlLabelIndex(id,indexdesc) select  547469,'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ܴ<EFBFBD><EFBFBD><EFBFBD>ʣ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' from HtmlLabelIndex where not exists (select id from HtmlLabelIndex where id = 547469 and ( trim(indexdesc) is not null ))  and rownum = 1 ;
/

delete from HtmlLabelInfo where indexid = 547469 and languageid=7 and ( trim(labelname) is null    ) ;
/

insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select  547469 as indexid ,'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ܴ<EFBFBD><EFBFBD><EFBFBD>ʣ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' as content,7  as languageid from HtmlLabelInfo) t where not exists (select indexid,languageid from HtmlLabelInfo where indexid = 547469 and languageid=7 and ( trim(labelname) is not null   ))  and rownum = 1 ;
/

delete from HtmlLabelInfo where indexid = 547469 and languageid=8 and ( trim(labelname) is null   or length(labelname)!=lengthb(labelname)  ) ;
/

insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select  547469 as indexid ,'The frozen number cannot be greater than the remaining prepare number!' as content,8  as languageid from HtmlLabelInfo) t where not exists (select indexid,languageid from HtmlLabelInfo where indexid = 547469 and languageid=8 and ( trim(labelname) is not null   and length(labelname)=lengthb(labelname)  ))  and rownum = 1 ;
/

delete from HtmlLabelInfo where indexid = 547469 and languageid=9 and ( trim(labelname) is null    ) ;
/

insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select  547469 as indexid ,'<EFBFBD><EFBFBD><EFBFBD>Y<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ܴ<EFBFBD><EFBFBD><EFBFBD>ʣ<EFBFBD>N<EFBFBD><EFBFBD><EFBFBD>u<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' as content,9  as languageid from HtmlLabelInfo) t where not exists (select indexid,languageid from HtmlLabelInfo where indexid = 547469 and languageid=9 and ( trim(labelname) is not null   ))  and rownum = 1 ;
/

delete from HtmlModuleLabel where indexId = 547469 and moduleCode = 'HRM' and type = 'label' ;
/

insert into HtmlModuleLabel(type,moduleCode,indexId) values ('label','HRM',547469) ;
/

delete from HtmlLabelIndex where id = 547470 and ( trim(indexdesc) is null ) ;
/

insert into HtmlLabelIndex(id,indexdesc) select  547470,'ǿ<EFBFBD>ز<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ͷŵ<EFBFBD>ǰ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ְ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' from HtmlLabelIndex where not exists (select id from HtmlLabelIndex where id = 547470 and ( trim(indexdesc) is not null ))  and rownum = 1 ;
/

delete from HtmlLabelInfo where indexid = 547470 and languageid=7 and ( trim(labelname) is null    ) ;
/

insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select  547470 as indexid ,'ǿ<EFBFBD>ز<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ͷŵ<EFBFBD>ǰ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ְ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' as content,7  as languageid from HtmlLabelInfo) t where not exists (select indexid,languageid from HtmlLabelInfo where indexid = 547470 and languageid=7 and ( trim(labelname) is not null   ))  and rownum = 1 ;
/

delete from HtmlLabelInfo where indexid = 547470 and languageid=8 and ( trim(labelname) is null   or length(labelname)!=lengthb(labelname)  ) ;
/

insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select  547470 as indexid ,'Under the strong control strategy, please release the current frozen amount before completing the onboarding operation' as content,8  as languageid from HtmlLabelInfo) t where not exists (select indexid,languageid from HtmlLabelInfo where indexid = 547470 and languageid=8 and ( trim(labelname) is not null   and length(labelname)=lengthb(labelname)  ))  and rownum = 1 ;
/

delete from HtmlLabelInfo where indexid = 547470 and languageid=9 and ( trim(labelname) is null    ) ;
/

insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select  547470 as indexid ,'<EFBFBD><EFBFBD><EFBFBD>ز<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ո<EFBFBD><EFBFBD>ጷŮ<EFBFBD>ǰ<EFBFBD><EFBFBD><EFBFBD>Y<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>š<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' as content,9  as languageid from HtmlLabelInfo) t where not exists (select indexid,languageid from HtmlLabelInfo where indexid = 547470 and languageid=9 and ( trim(labelname) is not null   ))  and rownum = 1 ;
/

delete from HtmlModuleLabel where indexId = 547470 and moduleCode = 'HRM' and type = 'label' ;
/

insert into HtmlModuleLabel(type,moduleCode,indexId) values ('label','HRM',547470) ;
/

delete from HtmlLabelIndex where id = 547471 and ( trim(indexdesc) is null ) ;
/

insert into HtmlLabelIndex(id,indexdesc) select  547471,'ǿ<EFBFBD>ز<EFBFBD><EFBFBD><EFBFBD><EFBFBD>²<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' from HtmlLabelIndex where not exists (select id from HtmlLabelIndex where id = 547471 and ( trim(indexdesc) is not null ))  and rownum = 1 ;
/

delete from HtmlLabelInfo where indexid = 547471 and languageid=7 and ( trim(labelname) is null    ) ;
/

insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select  547471 as indexid ,'ǿ<EFBFBD>ز<EFBFBD><EFBFBD><EFBFBD><EFBFBD>²<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' as content,7  as languageid from HtmlLabelInfo) t where not exists (select indexid,languageid from HtmlLabelInfo where indexid = 547471 and languageid=7 and ( trim(labelname) is not null   ))  and rownum = 1 ;
/

delete from HtmlLabelInfo where indexid = 547471 and languageid=8 and ( trim(labelname) is null   or length(labelname)!=lengthb(labelname)  ) ;
/

insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select  547471 as indexid ,'Overloading is not allowed under the strong control strategy' as content,8  as languageid from HtmlLabelInfo) t where not exists (select indexid,languageid from HtmlLabelInfo where indexid = 547471 and languageid=8 and ( trim(labelname) is not null   and length(labelname)=lengthb(labelname)  ))  and rownum = 1 ;
/

delete from HtmlLabelInfo where indexid = 547471 and languageid=9 and ( trim(labelname) is null    ) ;
/

insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select  547471 as indexid ,'<EFBFBD><EFBFBD><EFBFBD>ز<EFBFBD><EFBFBD><EFBFBD><EFBFBD>²<EFBFBD><EFBFBD><EFBFBD><EFBFBD>S<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' as content,9  as languageid from HtmlLabelInfo) t where not exists (select indexid,languageid from HtmlLabelInfo where indexid = 547471 and languageid=9 and ( trim(labelname) is not null   ))  and rownum = 1 ;
/

delete from HtmlModuleLabel where indexId = 547471 and moduleCode = 'HRM' and type = 'label' ;
/

insert into HtmlModuleLabel(type,moduleCode,indexId) values ('label','HRM',547471) ;
/

delete from HtmlLabelIndex where id = 547472 and ( trim(indexdesc) is null ) ;
/

insert into HtmlLabelIndex(id,indexdesc) select  547472,'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ɴ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ڱ<EFBFBD><EFBFBD><EFBFBD>' from HtmlLabelIndex where not exists (select id from HtmlLabelIndex where id = 547472 and ( trim(indexdesc) is not null ))  and rownum = 1 ;
/

delete from HtmlLabelInfo where indexid = 547472 and languageid=7 and ( trim(labelname) is null    ) ;
/

insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select  547472 as indexid ,'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ɴ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ڱ<EFBFBD><EFBFBD><EFBFBD>' as content,7  as languageid from HtmlLabelInfo) t where not exists (select indexid,languageid from HtmlLabelInfo where indexid = 547472 and languageid=7 and ( trim(labelname) is not null   ))  and rownum = 1 ;
/

delete from HtmlLabelInfo where indexid = 547472 and languageid=8 and ( trim(labelname) is null   or length(labelname)!=lengthb(labelname)  ) ;
/

insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select  547472 as indexid ,'The adjustment quantity cannot be greater than the current number' as content,8  as languageid from HtmlLabelInfo) t where not exists (select indexid,languageid from HtmlLabelInfo where indexid = 547472 and languageid=8 and ( trim(labelname) is not null   and length(labelname)=lengthb(labelname)  ))  and rownum = 1 ;
/

delete from HtmlLabelInfo where indexid = 547472 and languageid=9 and ( trim(labelname) is null    ) ;
/

insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select  547472 as indexid ,'<EFBFBD>{<7B><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ɴ<EFBFBD><C9B4><EFBFBD><EFBFBD>ھ<EFBFBD><DABE><EFBFBD>' as content,9  as languageid from HtmlLabelInfo) t where not exists (select indexid,languageid from HtmlLabelInfo where indexid = 547472 and languageid=9 and ( trim(labelname) is not null   ))  and rownum = 1 ;
/

delete from HtmlModuleLabel where indexId = 547472 and moduleCode = 'HRM' and type = 'label' ;
/

insert into HtmlModuleLabel(type,moduleCode,indexId) values ('label','HRM',547472) ;
/

delete from HtmlLabelIndex where id = 547474 and ( trim(indexdesc) is null ) ;
/

insert into HtmlLabelIndex(id,indexdesc) select  547474,'δ<EFBFBD><EFBFBD>ѯ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ӧ<EFBFBD><EFBFBD><EFBFBD>Ʒ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>µ<EFBFBD><EFBFBD><EFBFBD>֯<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ϣ' from HtmlLabelIndex where not exists (select id from HtmlLabelIndex where id = 547474 and ( trim(indexdesc) is not null ))  and rownum = 1 ;
/

delete from HtmlLabelInfo where indexid = 547474 and languageid=7 and ( trim(labelname) is null    ) ;
/

insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select  547474 as indexid ,'δ<EFBFBD><EFBFBD>ѯ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ӧ<EFBFBD><EFBFBD><EFBFBD>Ʒ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>µ<EFBFBD><EFBFBD><EFBFBD>֯<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ϣ' as content,7  as languageid from HtmlLabelInfo) t where not exists (select indexid,languageid from HtmlLabelInfo where indexid = 547474 and languageid=7 and ( trim(labelname) is not null   ))  and rownum = 1 ;
/

delete from HtmlLabelInfo where indexid = 547474 and languageid=8 and ( trim(labelname) is null   or length(labelname)!=lengthb(labelname)  ) ;
/

insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select  547474 as indexid ,'The organization''s prepare information under the corresponding prepare scheme is not Query' as content,8  as languageid from HtmlLabelInfo) t where not exists (select indexid,languageid from HtmlLabelInfo where indexid = 547474 and languageid=8 and ( trim(labelname) is not null   and length(labelname)=lengthb(labelname)  ))  and rownum = 1 ;
/

delete from HtmlLabelInfo where indexid = 547474 and languageid=9 and ( trim(labelname) is null    ) ;
/

insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select  547474 as indexid ,'δ<EFBFBD><EFBFBD>ԃ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>u<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>µĽM<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>u<EFBFBD><EFBFBD>Ϣ' as content,9  as languageid from HtmlLabelInfo) t where not exists (select indexid,languageid from HtmlLabelInfo where indexid = 547474 and languageid=9 and ( trim(labelname) is not null   ))  and rownum = 1 ;
/

delete from HtmlModuleLabel where indexId = 547474 and moduleCode = 'HRM' and type = 'label' ;
/

insert into HtmlModuleLabel(type,moduleCode,indexId) values ('label','HRM',547474) ;
/

delete from HtmlLabelIndex where id = 547949 and ( trim(indexdesc) is null ) ;
/

insert into HtmlLabelIndex(id,indexdesc) select  547949,'<EFBFBD><EFBFBD>ǰ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ϊ0,<2C><><EFBFBD><EFBFBD><EFBFBD>ͷ<EFBFBD>' from HtmlLabelIndex where not exists (select id from HtmlLabelIndex where id = 547949 and ( trim(indexdesc) is not null ))  and rownum = 1 ;
/

delete from HtmlLabelInfo where indexid = 547949 and languageid=7 and ( trim(labelname) is null    ) ;
/

insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select  547949 as indexid ,'<EFBFBD><EFBFBD>ǰ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ϊ0,<2C><><EFBFBD><EFBFBD><EFBFBD>ͷ<EFBFBD>' as content,7  as languageid from HtmlLabelInfo) t where not exists (select indexid,languageid from HtmlLabelInfo where indexid = 547949 and languageid=7 and ( trim(labelname) is not null   ))  and rownum = 1 ;
/

delete from HtmlLabelInfo where indexid = 547949 and languageid=8 and ( trim(labelname) is null   or length(labelname)!=lengthb(labelname)  ) ;
/

insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select  547949 as indexid ,'The current frozen number is 0, no need to release it' as content,8  as languageid from HtmlLabelInfo) t where not exists (select indexid,languageid from HtmlLabelInfo where indexid = 547949 and languageid=8 and ( trim(labelname) is not null   and length(labelname)=lengthb(labelname)  ))  and rownum = 1 ;
/

delete from HtmlLabelInfo where indexid = 547949 and languageid=9 and ( trim(labelname) is null    ) ;
/

insert into HtmlLabelInfo(indexid,labelname,languageid) select * from (select  547949 as indexid ,'<EFBFBD><EFBFBD>ǰ<EFBFBD><EFBFBD><EFBFBD>Y<EFBFBD><EFBFBD><EFBFBD><EFBFBD>0,<2C>o<EFBFBD><6F>ጷ<EFBFBD>' as content,9  as languageid from HtmlLabelInfo) t where not exists (select indexid,languageid from HtmlLabelInfo where indexid = 547949 and languageid=9 and ( trim(labelname) is not null   ))  and rownum = 1 ;
/

delete from HtmlModuleLabel where indexId = 547949 and moduleCode = 'HRM' and type = 'label' ;
/

insert into HtmlModuleLabel(type,moduleCode,indexId) values ('label','HRM',547949) ;
/