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


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

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

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