注意：

以下所有操作之前，需要备份分店、集团数据库。

请把每种情况的操作方式看明白了，在进行操作。

否则由此带来的任何问题，我们没法处理。因为是针对数据库执行语句，执行以后无法恢复。

以下操作，需严格分类按照次序，依次执行。

一、分店没有加入集团会员

1、集团停用分店。

2、分店执行语句

use yumstone

go

Update HotelOption set HotelID=Null,URL=Null,FTPPort=Null,MemberUrl=Null,MemberPort=Null,nettag=Null

go

delete from Group_Brand
go
delete from Group_Hotel
go

二、分店加入了集团会员，脱离集团后，会员由集团管理

（此种方式脱离后，分店没有任何会员信息）

1、集团停用分店，并按照提示将会员托管给其他分店。

2、分店执行语句

use yumstone

go

Update HotelOption set HotelID=Null,URL=Null,FTPPort=Null,MemberUrl=Null,MemberPort=Null,nettag=Null

go

delete from Group_Brand
go
delete from Group_Hotel
go

delete from MemberCard
go
delete from MemberItem
go
delete from mebmer
go
delete from MemberItemHis
go
delete from MemberHis
go
delete from MemberCardLog
go

delete from MemberSynParam
go

三、分店加入了集团会员，脱离集团后，会员由分店自行管理

(此种方式脱离后，集团和其他分店都会删除要脱离分店的会员)

1、所有分店手动执行一下会员同步，确保数据都传给集团了。

2、集团执行语句

use yumcloud
go
Update MemberItem set HotelID='要脱离的分店编号' where mCode in (select mCode from Member where HotelID='要脱离的分店编号')
go

3、要脱离的分店，用易石工程师工具，从集团重新下载所有会员数据。

4、要脱离的分店执行语句

use yumstone
go
delete from MemberItem where mCode in (select mCode from Member where HotelID<>'要脱离的分店编号')
go
delete from Member where HotelID<>'要脱离的分店编号'
go
delete from Group_Brand
go
delete from Group_Hotel
go
delete from MemberSynParam
go

update member set hotelid=null

go

Update HotelOption set HotelID=Null,URL=Null,FTPPort=Null,MemberUrl=Null,MemberPort=Null,nettag=Null

go

5、集团下所有其他分店执行语句

use yumstone
go
delete from MemberItem where mCode in (select mCode from Member where HotelID='要脱离的分店编号')
go
delete from Member where HotelID='要脱离的分店编号'
go

6、集团执行语句

use yumcloud
go
delete from MemberItem where HotelID='要脱离的分店编号'
go
delete from Member where HotelID='要脱离的分店编号'
go
Update Group_Hotel set usetag=0 where HotelID='要脱离的分店编号'
go
exec yum_fixMemberDepositAndPoints
go

7、要脱离的分店，使用易石门店会员纠错工具，执行一下纠错操作。