update lm_sys_listtable set slname='短期(小于15天)' where slcode='lm_pub_treqtime' and slid='1' ;


alter table zzt_base_emprequest modify (empployto varchar2(4));


alter table ZZT_JYGL_EMPLOY modify (empcoid varchar2(14));


--alter table zzt_t_trainitem add (trainitemsub number(8,2));


insert into LM_SYS_LISTTABLE values ('lm_pub_emomode','15','kgscdj','可供输出登记');


alter table lm_base_pbinfo add (armyman varchar2(1));
commit ;

insert into lm_sys_listtable(slcode,slid,slspell,slname) values('lm_pub_employto','12','tj','天津');

insert into lm_sys_listtable(slcode,slid,slspell,slname) values('lm_pub_employto','13','db','东北三省');

insert into lm_sys_listtable(slcode,slid,slspell,slname) values('lm_pub_employto','14','sh','上海');

insert into lm_sys_listtable(slcode,slid,slspell,slname) values('lm_pub_employto','15','zj','浙江');

insert into lm_sys_listtable(slcode,slid,slspell,slname) values('lm_pub_employto','16','sd','山东');

insert into lm_sys_listtable(slcode,slid,slspell,slname) values('lm_pub_employto','17','gd','广东');

insert into lm_sys_listtable(slcode,slid,slspell,slname) values('lm_pub_employto','18','sn','苏南');

insert into lm_sys_listtable(slcode,slid,slspell,slname) values('lm_pub_employto','19','sz','苏中');

insert into lm_sys_listtable(slcode,slid,slspell,slname) values('lm_pub_employto','20','sb','苏北');

insert into lm_sys_listtable(slcode,slid,slspell,slname) values('lm_pub_employto','21','xb','西部地区');

insert into lm_sys_listtable(slcode,slid,slspell,slname) values('lm_pub_employto','22','qt','其他');

insert into lm_sys_listtable(slcode,slid,slspell,slname) values('lm_pub_employto','11','bj','北京');


update lm_sys_listtable t set t.slcode='lm_pub_employto1' where t.slcode='lm_pub_employto' and t.slid='0';

update lm_sys_listtable t set t.slcode='lm_pub_employto1' where t.slcode='lm_pub_employto' and t.slid='1';

update lm_sys_listtable t set t.slcode='lm_pub_employto1' where t.slcode='lm_pub_employto' and t.slid='2';

update lm_sys_listtable t set t.slcode='lm_pub_employto1' where t.slcode='lm_pub_employto' and t.slid='3';

update lm_sys_listtable t set t.slcode='lm_pub_employto1' where t.slcode='lm_pub_employto' and t.slid='4';
commit;
ALTER TABLE ZZT_BASE_EMPREQUEST modify EMPPLOYTO CHAR(2);
commit ;

/

--0911修改

--delete from lm_sys_listtable t where t.slcode='lm_pub_employto' ;
--update lm_sys_listtable t set t.slcode='lm_pub_employto' where t.slcode='lm_pub_employto1';
commit ;

/

--0912修改
alter table ZZT_JYGL_EMPLOY add EMPSTATE varchar2(3);
update ZZT_JYGL_EMPLOY set EMPSTATE='1';
insert into LM_SYS_LISTTABLE(SLCODE,SLID,SLSPELL,SLNAME) values('lm_pub_empstate','1','yx','有效');
insert into LM_SYS_LISTTABLE(SLCODE,SLID,SLSPELL,SLNAME) values('lm_pub_empstate','2','zx','注销');
commit;

/