-- +migrate Up notransaction 
---------------只本地数据库执行 (去除会员相关的表的外键约束) ------------
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_欠款外键会员编号]') AND parent_object_id = OBJECT_ID(N'[dbo].[T_ARREARAGE]'))
  ALTER TABLE T_ARREARAGE drop CONSTRAINT FK_欠款外键会员编号
GO

IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_储物柜外键会员]') AND parent_object_id = OBJECT_ID(N'[dbo].[T_CABINET]'))
  ALTER TABLE T_CABINET drop CONSTRAINT FK_储物柜外键会员
GO

IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_结帐外键会员编号]') AND parent_object_id = OBJECT_ID(N'[dbo].[T_CHECKOUT]'))
  ALTER TABLE T_CHECKOUT drop CONSTRAINT FK_结帐外键会员编号
GO

IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_T_CHECKOUT_H_会员]') AND parent_object_id = OBJECT_ID(N'[dbo].[T_CHECKOUT_H]'))
  ALTER TABLE T_CHECKOUT_H drop CONSTRAINT FK_T_CHECKOUT_H_会员
GO

IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Table_会员指纹外键]') AND parent_object_id = OBJECT_ID(N'[dbo].[T_CLIENT_FINGERPRINTS]'))
  ALTER TABLE T_CLIENT_FINGERPRINTS drop CONSTRAINT FK_Table_会员指纹外键
GO

IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_会员的停卡日志外键会员编号]') AND parent_object_id = OBJECT_ID(N'[dbo].[T_CLIENTSTATECHANGELOG]'))
  ALTER TABLE T_CLIENTSTATECHANGELOG drop CONSTRAINT FK_会员的停卡日志外键会员编号
GO

IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_会员统计项目外键会员]') AND parent_object_id = OBJECT_ID(N'[dbo].[T_CLIENTUSEDSTATGOODS]'))
  ALTER TABLE T_CLIENTUSEDSTATGOODS drop CONSTRAINT FK_会员统计项目外键会员
GO

IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_客户回访外键客户]') AND parent_object_id = OBJECT_ID(N'[dbo].[T_CLIENTVISIT]'))
  ALTER TABLE T_CLIENTVISIT drop CONSTRAINT FK_客户回访外键客户
GO

IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_会员外键编号]') AND parent_object_id = OBJECT_ID(N'[dbo].[T_COMMEMORATE]'))
  ALTER TABLE T_COMMEMORATE drop CONSTRAINT FK_会员外键编号
GO


IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_消费外键次卡会员编号]') AND parent_object_id = OBJECT_ID(N'[dbo].[T_CONSUME]'))
  ALTER TABLE T_CONSUME drop CONSTRAINT FK_消费外键次卡会员编号
GO

IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_T_消费_历史_会员]') AND parent_object_id = OBJECT_ID(N'[dbo].[T_CONSUME_H]'))
  ALTER TABLE T_CONSUME_H drop CONSTRAINT FK_T_消费_历史_会员
GO

IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_消费调理外键会员编号]') AND parent_object_id = OBJECT_ID(N'[dbo].[T_CONSUMECASEHISTORY]'))
  ALTER TABLE T_CONSUMECASEHISTORY drop CONSTRAINT FK_消费调理外键会员编号
GO

IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_挂账外键会员号]') AND parent_object_id = OBJECT_ID(N'[dbo].[T_CREDIT]'))
  ALTER TABLE T_CREDIT drop CONSTRAINT FK_挂账外键会员号
GO

IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_外键预订会员]') AND parent_object_id = OBJECT_ID(N'[dbo].[T_DESTINE]'))
  ALTER TABLE T_DESTINE drop CONSTRAINT FK_外键预订会员
GO

IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_T_DESTINE_H_会员]') AND parent_object_id = OBJECT_ID(N'[dbo].[T_DESTINE_H]'))
  ALTER TABLE T_DESTINE_H drop CONSTRAINT FK_T_DESTINE_H_会员
GO

IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_染烫外键会员]') AND parent_object_id = OBJECT_ID(N'[dbo].[T_DYEBURN]'))
  ALTER TABLE T_DYEBURN drop CONSTRAINT FK_染烫外键会员
GO

IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_积分兑换外键客户]') AND parent_object_id = OBJECT_ID(N'[dbo].[T_INTEGRALCHANGE]'))
  ALTER TABLE T_INTEGRALCHANGE drop CONSTRAINT FK_积分兑换外键客户
GO

IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_T_积分兑换_历史_会员]') AND parent_object_id = OBJECT_ID(N'[dbo].[T_INTEGRALCHANGE_H]'))
  ALTER TABLE T_INTEGRALCHANGE_H drop CONSTRAINT FK_T_积分兑换_历史_会员
GO


IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_会员按次项目外键会员]') AND parent_object_id = OBJECT_ID(N'[dbo].[T_MEMBERAMOUNT]'))
  ALTER TABLE T_MEMBERAMOUNT drop CONSTRAINT FK_会员按次项目外键会员
GO

IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_T_消费_历史_会员]') AND parent_object_id = OBJECT_ID(N'[dbo].[T_MEMBERBYTIME]'))
  ALTER TABLE T_MEMBERBYTIME drop CONSTRAINT FK_T_消费_历史_会员
GO

IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_疗程消费外键会员]') AND parent_object_id = OBJECT_ID(N'[dbo].[T_MEMBERCOST]'))
  ALTER TABLE T_MEMBERCOST drop CONSTRAINT FK_疗程消费外键会员
GO

IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_T_次卡消费_历史_会员]') AND parent_object_id = OBJECT_ID(N'[dbo].[T_MEMBERCOST_H]'))
  ALTER TABLE T_MEMBERCOST_H drop CONSTRAINT FK_T_次卡消费_历史_会员
GO

IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_客户意见外键会员]') AND parent_object_id = OBJECT_ID(N'[dbo].[T_MEMBERIDEA]'))
  ALTER TABLE T_MEMBERIDEA drop CONSTRAINT FK_客户意见外键会员
GO

IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_会员照片外键会员]') AND parent_object_id = OBJECT_ID(N'[dbo].[T_MEMBERIMAGE]'))
  ALTER TABLE T_MEMBERIMAGE drop CONSTRAINT FK_会员照片外键会员
GO

IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_接待外键会员]') AND parent_object_id = OBJECT_ID(N'[dbo].[T_RECEIVE]'))
  ALTER TABLE T_RECEIVE drop CONSTRAINT FK_接待外键会员
GO

IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_T_接待_历史_会员]') AND parent_object_id = OBJECT_ID(N'[dbo].[T_RECEIVE_H]'))
  ALTER TABLE T_RECEIVE_H drop CONSTRAINT FK_T_接待_历史_会员
GO

IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_短信月费会员编号外键]') AND parent_object_id = OBJECT_ID(N'[dbo].[T_SMSMONTHFEE]'))
  ALTER TABLE T_SMSMONTHFEE drop CONSTRAINT FK_短信月费会员编号外键
GO

IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_外键预约会员]') AND parent_object_id = OBJECT_ID(N'[dbo].[T_SUBMITDESTINE]'))
  ALTER TABLE T_SUBMITDESTINE drop CONSTRAINT FK_外键预约会员
GO

IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_充值外键会员]') AND parent_object_id = OBJECT_ID(N'[dbo].[T_SUPPLEMENT]'))
  ALTER TABLE T_SUPPLEMENT drop CONSTRAINT FK_充值外键会员
GO

IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_T_充值_历史_会员]') AND parent_object_id = OBJECT_ID(N'[dbo].[T_SUPPLEMENT_H]'))
  ALTER TABLE T_SUPPLEMENT_H drop CONSTRAINT FK_T_充值_历史_会员
GO

IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_疗程充值外键会员]') AND parent_object_id = OBJECT_ID(N'[dbo].[T_SUPPLEMENTAMOUNT]'))
  ALTER TABLE T_SUPPLEMENTAMOUNT drop CONSTRAINT FK_疗程充值外键会员
GO

IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_T_次卡购买_历史_会员]') AND parent_object_id = OBJECT_ID(N'[dbo].[T_SUPPLEMENTAMOUNT_H]'))
  ALTER TABLE T_SUPPLEMENTAMOUNT_H drop CONSTRAINT FK_T_次卡购买_历史_会员
GO

IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_消费券会员卡号]') AND parent_object_id = OBJECT_ID(N'[dbo].[T_TICKET]'))
  ALTER TABLE T_TICKET drop CONSTRAINT FK_消费券会员卡号
GO

IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_手机浏览日志外键客户卡号]') AND parent_object_id = OBJECT_ID(N'[dbo].[T_WEBLOG]'))
  ALTER TABLE T_WEBLOG drop CONSTRAINT FK_手机浏览日志外键客户卡号
GO

IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_外键微信支付会员]') AND parent_object_id = OBJECT_ID(N'[dbo].[T_WeiXinPay]'))
  ALTER TABLE T_WeiXinPay drop CONSTRAINT FK_外键微信支付会员
GO

--------------- end (去除会员相关的表的外键约束) ------------

-------删除会员表自身的外键----


IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_会员外键地区]') AND parent_object_id = OBJECT_ID(N'[dbo].[T_CLIENT]'))
ALTER TABLE [dbo].[T_CLIENT] DROP CONSTRAINT [FK_会员外键地区]
GO



IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_会员外键卡店号]') AND parent_object_id = OBJECT_ID(N'[dbo].[T_CLIENT]'))
ALTER TABLE [dbo].[T_CLIENT] DROP CONSTRAINT [FK_会员外键卡店号]
GO


IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_会员外键卡类型]') AND parent_object_id = OBJECT_ID(N'[dbo].[T_CLIENT]'))
ALTER TABLE [dbo].[T_CLIENT] DROP CONSTRAINT [FK_会员外键卡类型]
GO


IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_会员外键卡推荐人]') AND parent_object_id = OBJECT_ID(N'[dbo].[T_CLIENT]'))
ALTER TABLE [dbo].[T_CLIENT] DROP CONSTRAINT [FK_会员外键卡推荐人]
GO


IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_会员外键来源]') AND parent_object_id = OBJECT_ID(N'[dbo].[T_CLIENT]'))
ALTER TABLE [dbo].[T_CLIENT] DROP CONSTRAINT [FK_会员外键来源]
GO


IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_客户外键员工]') AND parent_object_id = OBJECT_ID(N'[dbo].[T_CLIENT]'))
ALTER TABLE [dbo].[T_CLIENT] DROP CONSTRAINT [FK_客户外键员工]
GO

-----end