--====================OctAdvertiserSystemDB============================--

use OctAdvertiserSystemDB

select * from Adv_Carousel
update Adv_Carousel set ImgURL= replace(ImgURL, '127.0.0.1:8006/', 'fu.xxx.com/');

select * from Adv_ImgList
update Adv_ImgList set ImgURL= replace(ImgURL, '127.0.0.1:8006/', 'fu.xxx.com/');

select * from Nav_IconMsg
update Nav_IconMsg set IconUrl= replace(IconUrl, '127.0.0.1:8006/', 'fu.xxx.com/');

select * from Rcd_GoodsShop
select * from Search_FindMsg
select * from Search_HistoryGoodsShop


--====================OctAfterSaleAccCusDB============================--

use OctAfterSaleAccCusDB

select * from Admin_PowerMsg
select * from Admin_UserMsg
select * from AfterSale_ApplyMsg
select * from AfterSale_Delivery

select * from AfterSale_ProblemImgs
update AfterSale_ProblemImgs set ImgPath= replace(ImgPath, '127.0.0.1:8006/', 'fu.xxx.com/');
update AfterSale_ProblemImgs set ImgPath= replace(ImgPath, '127.0.0.1:8006/', 'fu.xxx.com/');


select * from AfterSale_SendGoods
select * from Buyer_SysMsg

select * from Explain_Text
update Explain_Text set ExplainContent= replace(ExplainContent, '//127.0.0.1:8006/Upload/', '//fu.xxx.com/Upload/');

select * from Order_ComplainMsg
select * from Platform_SysMsg
select * from Refund_ApplyMsg
select * from Refund_ProblemImgs
select * from Refund_SendGoods
select * from Shop_SysMsg


--====================OctFileUploadSystemDB============================--


use OctFileUploadSystemDB

select * from Activity_Img
update Activity_Img set ServerDomain= replace(ServerDomain, '127.0.0.1:8006', 'fu.xxx.com');

select * from Adv_BannerImg
--update Adv_BannerImg set ServerDomain= replace(ServerDomain, '127.0.0.1:8006', 'fu.xxx.com');

select * from Adv_CarouselImg
update Adv_CarouselImg set ServerDomain= replace(ServerDomain, '127.0.0.1:8006', 'fu.xxx.com');
update Adv_CarouselImg set ServerDomain= replace(ServerDomain, '127.0.0.1:8006', 'fu.xxx.com');

select * from Adv_ImgListImg
update Adv_ImgListImg set ServerDomain= replace(ServerDomain, '127.0.0.1:8006', 'fu.xxx.com');
update Adv_ImgListImg set ServerDomain= replace(ServerDomain, '127.0.0.1:8006', 'fu.xxx.com');

select * from AfterSale_ProblemImgs
update AfterSale_ProblemImgs set ServerDomain= replace(ServerDomain, '127.0.0.1:8006', 'fu.xxx.com');
update AfterSale_ProblemImgs set ServerDomain= replace(ServerDomain, '127.0.0.1:8006', 'fu.xxx.com');

select * from Buyer_HeaderImg
update Buyer_HeaderImg set ServerDomain= replace(ServerDomain, '127.0.0.1:8006', 'fu.xxx.com');

select * from Company_CertificateImg
update Company_CertificateImg set ServerDomain= replace(ServerDomain, '127.0.0.1:8006', 'fu.xxx.com');
update Company_CertificateImg set ServerDomain= replace(ServerDomain, '127.0.0.1:8006', 'fu.xxx.com');

select * from Distri_IDCardImg
select * from Distri_OwnerSelfieImg
select * from Distri_ShopHeaderImg
select * from Distri_ShopLogoImg

select * from Explain_Img
update Explain_Img set ServerDomain= replace(ServerDomain, '127.0.0.1:8006', 'fu.xxx.com');

select * from Goo_AppraiseImg
update Goo_AppraiseImg set ServerDomain= replace(ServerDomain, '127.0.0.1:8006', 'fu.xxx.com');
update Goo_AppraiseImg set ServerDomain= replace(ServerDomain, '127.0.0.1:8006', 'fu.xxx.com');

select * from Goo_GiftImg
update Goo_GiftImg set ServerDomain= replace(ServerDomain, '127.0.0.1:8006', 'fu.xxx.com');
update Goo_GiftImg set ServerDomain= replace(ServerDomain, '127.0.0.1:8006', 'fu.xxx.com');

select * from Goo_GoodsImg
update Goo_GoodsImg set ServerDomain= replace(ServerDomain, '127.0.0.1:8006', 'fu.xxx.com');
update Goo_GoodsImg set ServerDomain= replace(ServerDomain, '127.0.0.1:8006', 'fu.xxx.com');

select * from Goo_GoodsTypeIcon
update Goo_GoodsTypeIcon set ServerDomain= replace(ServerDomain, '127.0.0.1:8006', 'fu.xxx.com');
update Goo_GoodsTypeIcon set ServerDomain= replace(ServerDomain, '127.0.0.1:8006', 'fu.xxx.com');

select * from Goo_SpecParamImg
update Goo_SpecParamImg set ServerDomain= replace(ServerDomain, '127.0.0.1:8006', 'fu.xxx.com');
update Goo_SpecParamImg set ServerDomain= replace(ServerDomain, '127.0.0.1:8006', 'fu.xxx.com');

select * from LuckyDraw_Img
update LuckyDraw_Img set ServerDomain= replace(ServerDomain, '127.0.0.1:8006', 'fu.xxx.com');
update LuckyDraw_Img set ServerDomain= replace(ServerDomain, '127.0.0.1:8006', 'fu.xxx.com');

select * from Nav_IconImg
update Nav_IconImg set ServerDomain= replace(ServerDomain, '127.0.0.1:8006', 'fu.xxx.com');
update Nav_IconImg set ServerDomain= replace(ServerDomain, '127.0.0.1:8006', 'fu.xxx.com');

select * from Pay_TransCertImg
update Pay_TransCertImg set ServerDomain= replace(ServerDomain, '127.0.0.1:8006', 'fu.xxx.com');
update Pay_TransCertImg set ServerDomain= replace(ServerDomain, '127.0.0.1:8006', 'fu.xxx.com');

select * from Present_Img
update Present_Img set ServerDomain= replace(ServerDomain, '127.0.0.1:8006', 'fu.xxx.com');
update Present_Img set ServerDomain= replace(ServerDomain, '127.0.0.1:8006', 'fu.xxx.com');

select * from Refund_ProblemImgs
update Refund_ProblemImgs set ServerDomain= replace(ServerDomain, '127.0.0.1:8006', 'fu.xxx.com');
update Refund_ProblemImgs set ServerDomain= replace(ServerDomain, '127.0.0.1:8006', 'fu.xxx.com');

select * from Settle_CertificateImg
update Settle_CertificateImg set ServerDomain= replace(ServerDomain, '127.0.0.1:8006', 'fu.xxx.com');
update Settle_CertificateImg set ServerDomain= replace(ServerDomain, '127.0.0.1:8006', 'fu.xxx.com');

select * from Settle_TransferVoucherImg
update Settle_TransferVoucherImg set ServerDomain= replace(ServerDomain, '127.0.0.1:8006', 'fu.xxx.com');
update Settle_TransferVoucherImg set ServerDomain= replace(ServerDomain, '127.0.0.1:8006', 'fu.xxx.com');

select * from Shop_AlbumImg
update Shop_AlbumImg set ServerDomain= replace(ServerDomain, '127.0.0.1:8006', 'fu.xxx.com');
update Shop_AlbumImg set ServerDomain= replace(ServerDomain, '127.0.0.1:8006', 'fu.xxx.com');

select * from Shop_CarouselImg
update Shop_CarouselImg set ServerDomain= replace(ServerDomain, '127.0.0.1:8006', 'fu.xxx.com');
update Shop_CarouselImg set ServerDomain= replace(ServerDomain, '127.0.0.1:8006', 'fu.xxx.com');

select * from Shop_HeaderImg
update Shop_HeaderImg set ServerDomain= replace(ServerDomain, '127.0.0.1:8006', 'fu.xxx.com');
update Shop_HeaderImg set ServerDomain= replace(ServerDomain, '127.0.0.1:8006', 'fu.xxx.com');

select * from Shop_LogoImg
update Shop_LogoImg set ServerDomain= replace(ServerDomain, '127.0.0.1:8006', 'fu.xxx.com');
update Shop_LogoImg set ServerDomain= replace(ServerDomain, '127.0.0.1:8006', 'fu.xxx.com');

select * from Shop_TypeIcon
update Shop_TypeIcon set ServerDomain= replace(ServerDomain, '127.0.0.1:8006', 'fu.xxx.com');
update Shop_TypeIcon set ServerDomain= replace(ServerDomain, '127.0.0.1:8006', 'fu.xxx.com');


--====================OctImSystemDB============================

--use OctImSystemDB

--select * from Chat_Imgs

--select * from Chat_MemberList
--delete from Chat_MemberList

--delete from Chat_Msg

--select * from Shop_Account
--update Shop_Account set ShopHeaderImg= replace(ShopHeaderImg, '127.0.0.1:1900', 'oim.opencodetiger.com');
--update Shop_Account set ShopHeaderImg= replace(ShopHeaderImg, '127.0.0.1:8006', 'fu.xxx.com');
--update Shop_Account set ShopHeaderImg= replace(ShopHeaderImg, '127.0.0.1:6688', 'oim.opencodetiger.com');

--select * from Shop_OnLineUserList
--delete from Sms_SendMsg

--select * from User_VisitEnter
--delete from User_VisitEnter



--====================OctThirdApiCallSystemDB============================--

use OctThirdApiCallSystemDB
delete from Sms_SendMsg


--====================OctTradingSystemDB============================--

use OctTradingSystemDB

select * from Buyer_WithDraw

select * from Pay_TransBankMsg

select * from Pay_TransRecord
update Pay_TransRecord set TransCertImg= replace(TransCertImg, '127.0.0.1:8006', 'fu.xxx.com');

select * from Settle_Apply
update Settle_Apply set TransferVoucherImg= replace(TransferVoucherImg, '127.0.0.1:8006', 'fu.xxx.com');


--====================OctUserGoodsShopSystemDB============================--

use OctUserGoodsShopSystemDB

select * from Activity_Imgs
update Activity_Imgs set ImgURL= replace(ImgURL, '127.0.0.1:8006/', 'fu.xxx.com/');
update Activity_Imgs set ImgURL= replace(ImgURL, '127.0.0.1:8006/', 'fu.xxx.com/');


select * from Activity_Join
update Activity_Join set HeaderImg= replace(HeaderImg, '127.0.0.1:8006/', 'fu.xxx.com/');

select * from Activity_Msg
update Activity_Msg set AcCoverImg= replace(AcCoverImg, '127.0.0.1:8006/', 'fu.xxx.com/');
update Activity_Msg set AcCoverImg= replace(AcCoverImg, '127.0.0.1:8006/', 'fu.xxx.com/');

select * from Buyer_Msg
update Buyer_Msg set HeaderImg= replace(HeaderImg, '127.0.0.1:8006/', 'fu.xxx.com/');

select * from Company_Certificate
update Company_Certificate set CertImg= replace(CertImg, '127.0.0.1:8006/', 'fu.xxx.com/');
update Company_Certificate set CertImg= replace(CertImg, '127.0.0.1:8006/', 'fu.xxx.com/');

select * from Goo_AppraiseImgs
update Goo_AppraiseImgs set ImgUrl= replace(ImgUrl, '127.0.0.1:8006/', 'fu.xxx.com/');
update Goo_AppraiseImgs set ImgUrl= replace(ImgUrl, '127.0.0.1:8006/', 'fu.xxx.com/');

select * from Goo_GiftImg
update Goo_GiftImg set ImgUrl= replace(ImgUrl, '127.0.0.1:8006/', 'fu.xxx.com/');
update Goo_GiftImg set ImgUrl= replace(ImgUrl, '127.0.0.1:8006/', 'fu.xxx.com/');

select * from Goo_GiftMsg
update Goo_GiftMsg set GiftImgUrl= replace(GiftImgUrl, '127.0.0.1:8006/', 'fu.xxx.com/');
update Goo_GiftMsg set GiftImgUrl= replace(GiftImgUrl, '127.0.0.1:8006/', 'fu.xxx.com/');

update Goo_GiftMsg set GiftDesc= replace(GiftDesc, '127.0.0.1:8006/', 'fu.xxx.com/');
update Goo_GiftMsg set GiftDesc= replace(GiftDesc, '127.0.0.1:8006/', 'fu.xxx.com/');

select * from Goo_GoodsImg
update Goo_GoodsImg set ImgPath= replace(ImgPath, '127.0.0.1:8006/', 'fu.xxx.com/');
update Goo_GoodsImg set ImgPath= replace(ImgPath, '127.0.0.1:8006/', 'fu.xxx.com/');

select * from Goo_GoodsMsg order by PageOrder desc
update Goo_GoodsMsg set GoodsDesc= replace(GoodsDesc, '127.0.0.1:8006/', 'fu.xxx.com/');
update Goo_GoodsMsg set GoodsDesc= replace(GoodsDesc, '127.0.0.1:8006/', 'fu.xxx.com/');


select * from Goo_GoodsType
update Goo_GoodsType set TypeIcon= replace(TypeIcon, '127.0.0.1:8006/', 'fu.xxx.com/');
update Goo_GoodsType set TypeIcon= replace(TypeIcon, '127.0.0.1:8006/', 'fu.xxx.com/');

select * from Goo_SpecParam
update Goo_SpecParam set SpecParamImg= replace(SpecParamImg, '127.0.0.1:8006/', 'fu.xxx.com/');
update Goo_SpecParam set SpecParamImg= replace(SpecParamImg, '127.0.0.1:8006/', 'fu.xxx.com/');

select * from Group_CreateMsg
update Group_CreateMsg set HeaderImg= replace(HeaderImg, '127.0.0.1:8006/', 'fu.xxx.com/');

select * from Group_JoinMsg
update Group_JoinMsg set HeaderImg= replace(HeaderImg, '127.0.0.1:8006/', 'fu.xxx.com/');

select * from LuckyDraw_Imgs
update LuckyDraw_Imgs set ImgURL= replace(ImgURL, '127.0.0.1:8006/', 'fu.xxx.com/');
update LuckyDraw_Imgs set ImgURL= replace(ImgURL, '127.0.0.1:8006/', 'fu.xxx.com/');

select * from LuckyDraw_JoinMsg
update LuckyDraw_JoinMsg set HeaderImg= replace(HeaderImg, '127.0.0.1:8006/', 'fu.xxx.com/');
update LuckyDraw_JoinMsg set HeaderImg= replace(HeaderImg, '127.0.0.1:8006/', 'fu.xxx.com/');

select * from LuckyDraw_Msg
update LuckyDraw_Msg set CoverImgUrl= replace(CoverImgUrl, '127.0.0.1:8006/', 'fu.xxx.com/');
update LuckyDraw_Msg set CoverImgUrl= replace(CoverImgUrl, '127.0.0.1:8006/', 'fu.xxx.com/');

select * from Present_Imgs
update Present_Imgs set ImgURL= replace(ImgURL, '127.0.0.1:8006/', 'fu.xxx.com/');
update Present_Imgs set ImgURL= replace(ImgURL, '127.0.0.1:8006/', 'fu.xxx.com/');

select * from Present_Msg
update Present_Msg set PresentDesc= replace(PresentDesc, '127.0.0.1:8006/', 'fu.xxx.com/');
update Present_Msg set PresentDesc= replace(PresentDesc, '127.0.0.1:8006/', 'fu.xxx.com/');

select * from Shop_Carousel
update Shop_Carousel set ImgURL= replace(ImgURL, '127.0.0.1:8006/', 'fu.xxx.com/');
update Shop_Carousel set ImgURL= replace(ImgURL, '127.0.0.1:8006/', 'fu.xxx.com/');

select * from Shop_LogoImg
update Shop_LogoImg set ImgURL= replace(ImgURL, '127.0.0.1:8006/', 'fu.xxx.com/');
update Shop_LogoImg set ImgURL= replace(ImgURL, '127.0.0.1:8006/', 'fu.xxx.com/');

select * from Shop_Msg
update Shop_Msg set ShopHeaderImg= replace(ShopHeaderImg, '127.0.0.1:8006/', 'fu.xxx.com/');
update Shop_Msg set ShopHeaderImg= replace(ShopHeaderImg, '127.0.0.1:8006/', 'fu.xxx.com/');

select * from Shop_Type
update Shop_Type set TypeIcon= replace(TypeIcon, '127.0.0.1:8006/', 'fu.xxx.com/');
update Shop_Type set TypeIcon= replace(TypeIcon, '127.0.0.1:8006/', 'fu.xxx.com/');