--レコード内のエイリアス指定を更新する


UPDATE ctaBannerRoboT
SET Description = Replace(Description, '/ec/', '/cybertrade/')

UPDATE ctdItemM
SET ItemImage = Replace(ItemImage, '/ec/', '/cybertrade/')

UPDATE cthPTenantM
SET ShopImage = Replace(ShopImage, '/ec/', '/cybertrade/')
	, ForeImage = Replace(ForeImage, '/ec/', '/cybertrade/')
	, BackImage = Replace(BackImage, '/ec/', '/cybertrade/')
	, GuideImage = Replace(GuideImage, '/ec/', '/cybertrade/')

UPDATE cthPTenantTItem
SET ItemImage = Replace(ItemImage, '/ec/', '/cybertrade/')
	, SalesImage1 = Replace(SalesImage1, '/ec/', '/cybertrade/')
	, SalesImage2 = Replace(SalesImage2, '/ec/', '/cybertrade/')
	, SalesImage3 = Replace(SalesImage3, '/ec/', '/cybertrade/')
	, SalesImage4 = Replace(SalesImage4, '/ec/', '/cybertrade/')
	, SalesImage5 = Replace(SalesImage5, '/ec/', '/cybertrade/')

UPDATE ctpPracticeM
SET BgImage = Replace(BgImage, '/ec/', '/cybertrade/')

UPDATE ctpTownT
SET BgImage = Replace(BgImage, '/ec/', '/cybertrade/')
	, TramImage = Replace(TramImage, '/ec/', '/cybertrade/')
	, RoadImage = Replace(RoadImage, '/ec/', '/cybertrade/')
	, ShopImage0 = Replace(ShopImage0, '/ec/', '/cybertrade/')
	, ShopImage1 = Replace(ShopImage1, '/ec/', '/cybertrade/')
	, ShopImage2 = Replace(ShopImage2, '/ec/', '/cybertrade/')
	, ShopImage3 = Replace(ShopImage3, '/ec/', '/cybertrade/')
	, ShopImage4 = Replace(ShopImage4, '/ec/', '/cybertrade/')
	, ShopImage5 = Replace(ShopImage5, '/ec/', '/cybertrade/')

UPDATE ctpTradeTrn
SET ItemImage = Replace(ItemImage, '/ec/', '/cybertrade/')

UPDATE ctsCodeTS
SET directory = Replace(directory, '/ec/', '/cybertrade/')

UPDATE ctsCodeTSgif
SET IdentName = Replace(IdentName, '/ec/', '/cybertrade/')