--T+新版 的系统库不一定未uftsystem,且eap_user注意同步修改为config
--增加管理员密码为空到账套
use UFTData511168_600024
declare @cacc_num varchar(20)
declare @id varchar(20)
select @cacc_num =cacc_num from uftsystem..EAP_Account where dsname='UFTData511168_600024'
insert into EAP_User(Code,name,password ,isAdmin,isStoped ,AuthState ,PersonName ,issystem ,ShowNewFuncIntro,OrderNum ,IdMarketingOrgan ,actortype,IsHeadQuarters ,UpgradePwdState )
values ('管理员','管理员','dL4Wl5cQ1MTnxmR4VgiEVg==','1','0','0','管理员','0','0','1','1','0','1','0')
select @id =id from EAP_User where code='管理员'
insert into UFTSystem..EAP_User(cacc_num,USERID ,name ,password ,idwebserver )
values ( @cacc_num ,@id,'管理员','dL4Wl5cQ1MTnxmR4VgiEVg==','0')
|