数据库修改用友U8账套
适用于对数据库语句稍微有些了解的同学
以下为自用Sql代码(自己按需修改)
alter table dbo.UA_log drop constraint FK__UA_Log__cUser_Id__6AEFE058;
alter table dbo.UA_Log drop constraint FK__UA_Log__cAcc_Id__4F7CD00D;
alter table dbo.UA_Role drop constraint FK__UA_Role__cUser_Id;
alter table dbo.ua_account_sub drop constraint FK__UA_Accoun__cAcc___44FF419A;
alter table dbo.UA_Period drop constraint FK__UA_Period__cAcc___45F365D3;
UPDATE Ua_user SET cUser_Id = '878' WHERE cUser_Id = '888';
UPDATE Ua_user SET cUser_Name = '自己的名字' WHERE cUser_Name = '同学的名字';
UPDATE Ua_user SET cPassword = '' WHERE cUser_Id = '878';
select * from Ua_user;
UPDATE UA_Role SET cUser_Id = '878' WHERE cUser_Id = '888';
select * from UA_Role;
UPDATE dbo.UA_Log SET cUser_Id = '878' WHERE cUser_Id = '888';
UPDATE dbo.UA_Log SET cAcc_Id = '878' WHERE cAcc_Id = '888';
select * from dbo.UA_Log;
update UA_Account set cAcc_Id='878' where cAcc_Id='888';
update UA_Account set cAcc_Name='自己的供应链' where cAcc_Name='同学的供应链';
update UA_Account set cAcc_Master='878' where cAcc_Master='888';
update UA_Account set cUnitLP='自己的名字' where cUnitLP='同学的名字';
select * from ua_account;
UPDATE Ua_user SET cUser_Id = '878' WHERE cUser_Id = '888';
UPDATE Ua_user SET cUser_Name = '自己的名字' WHERE cUser_Name = '同学的名字';
UPDATE Ua_user SET cPassword = '' WHERE cUser_Id = '878';
select * from Ua_user;
UPDATE Ua_user_Ex SET cUser_Id = '878' WHERE cUser_Id = '888';
UPDATE Ua_user_Ex SET cUser_Name = '自己的名字' WHERE cUser_Name = '同学的名字';
update UA_User_Ex set cPassword ='' where cUser_Id='878';
select * from Ua_user_Ex;
update UA_Log_Ex set cAcc_Id='878' where cAcc_Id='888';
update UA_Log_Ex set cUser_Id='878' where cuser_id='888';
select * from UA_Log_Ex;
update hr_hi_person set cPsn_Name='自己的名字' where cPsn_Name='同学的名字';
select * from hr_hi_person;
update zpurrkdlist set cmaker='自己的名字' where cmaker='同学的名字';
select * from zpurrkdlist;
update purbillvouchsIA870 set cMaker='自己的名字' where cMaker='同学的名字';
update purbillvouchsIA870 set cVerifier='自己的名字' where cVerifier='同学的名字';
select * from purbillvouchsIA870;
update PO_Pomain set cMaker='自己的名字' where cMaker='同学的名字';
update PO_Pomain set cVerifier='自己的名字' where cVerifier='同学的名字';
select * from PO_Pomain;
update IA_Subsidiary set cHandler='自己的名字' where cHandler='同学的名字';
update IA_Subsidiary set cAccounter='自己的名字' where cAccounter='同学的名字';
update IA_Subsidiary set cMaker='自己的名字' where cMaker='同学的名字';
select * from IA_Subsidiary;
update purbillvouch set cReviser='自己的名字' where cReviser='同学的名字';
select * from purbillvouch;
update PurSettleVouch set cMaker='自己的名字' where cMaker='同学的名字';
select * from PurSettleVouch;
update PurSettleVouchs set cbAccounter='自己的名字' where cbAccounter='同学的名字';
select * from PurSettleVouchs;
update vendor set cCreatePerson='自己的名字' where cCreatePerson='同学的名字'
update vendor set cModifyPerson='自己的名字' where cModifyPerson='同学的名字'
select * from vendor;
update RdRecord01 set cHandler='自己的名字' where cHandler='同学的名字';
update RdRecord01 set cMaker='自己的名字' where cMaker='同学的名字';
select * from RdRecord01;
update RdRecords01 set cbaccounter='自己的名字' where cbaccounter='同学的名字';
select * from RdRecords01;
update gl_accvouch set cbill='自己的名字' where cbill='同学的名字';
select * from gl_accvouch;
select * from zpurpoheader;
update salebillvouch set cMaker='自己的名字' where cMaker='同学的名字';
update salebillvouch set cVerifier='自己的名字' where cVerifier='同学的名字';
update salebillvouch set cChecker='自己的名字' where cChecker='同学的名字';
update salebillvouch set cmodifier='自己的名字' where cmodifier='同学的名字';
select * from salebillvouch;
update DispatchList set cVerifier='自己的名字' where cVerifier='同学的名字';
update DispatchList set cmaker='自己的名字' where cmaker='同学的名字';
select * from DispatchList;
update DispatchListsIA870 set cMaker='自己的名字' where cMaker='同学的名字';
select * from DispatchListsIA870;
update salepayvoucht set cmaker='自己的名字' where cmaker='同学的名字';
update salepayvoucht set cverifier='自己的名字' where cverifier='同学的名字';
select * from salepayvoucht;
select * from scmVouchRelInfo;
update relrecordmain32 set cMaker='自己的名字' where cMaker='同学的名字';
update relrecordmain32 set cVerifier='自己的名字' where cVerifier='同学的名字';
select * from relrecordmain32;
update Inventory set cCreatePerson='自己的名字' where cCreatePerson='同学的名字';
update Inventory set cModifyPerson='自己的名字' where cModifyPerson='同学的名字';
select * from Inventory