if not exists(select * from T_WORKERQUEUEPARAMETER where F_ID = 'WeMiniAPPID') 
BEGIN
  INSERT INTO T_WORKERQUEUEPARAMETER (F_ID, F_VALUE, F_SHOPID, F_REMARK, F_ISHIDE, F_TYPE,F_VERSION,F_ADDDATE) VALUES ('WeMiniAPPID', '', NULL, '微信小程序APPID', 0, '微信(新)','18.0.125','2018-04-25');
END
GO

if not exists(select * from T_WORKERQUEUEPARAMETER where F_ID = 'WeMiniQrCodeUrl') 
BEGIN
  INSERT INTO T_WORKERQUEUEPARAMETER (F_ID, F_VALUE, F_SHOPID, F_REMARK, F_ISHIDE, F_TYPE,F_VERSION,F_ADDDATE) VALUES ('WeMiniQrCodeUrl', 'https://www.soelife.cn/wxminiapp-service/api/wxma/qrcode/scene', NULL, '生成微信小程序码Url', 0, '微信(新)','18.0.125','2018-04-25');
END
GO

--美团券对应的系统卡类型
if not exists(select * from T_WORKERQUEUEPARAMETER where F_ID = 'SoeTicketTypeId') 
BEGIN
  INSERT INTO T_WORKERQUEUEPARAMETER (F_ID, F_VALUE, F_SHOPID, F_REMARK, F_ISHIDE, F_TYPE,F_VERSION,F_ADDDATE
) VALUES ('SoeTicketTypeId', '', NULL, '索易券对应的系统卡类型', 0, '在线服务','18.0.125','2018-05-04');
END

GO

if not exists(select * from T_WORKERQUEUEPARAMETER where F_ID = 'FastCashGoodsId') 
BEGIN
  INSERT INTO T_WORKERQUEUEPARAMETER (F_ID, F_VALUE, F_SHOPID, F_REMARK, F_ISHIDE, F_TYPE,F_VERSION,F_ADDDATE
) VALUES ('FastCashGoodsId', '', NULL, '索易快速消费对应项目编号', 0, '在线服务','18.0.125','2018-05-04');
END

GO

IF EXISTS(
   SELECT * 
    FROM syscolumns 
    WHERE id=object_id('T_TICKET') and Name='F_SNID')
BEGIN   
   ALTER TABLE T_TICKET alter COLUMN F_SNID varchar(50)
END

GO


--hj
--预约表
IF OBJECT_ID (N'HttpDestineInfo') IS NULL
BEGIN  --如果不存在该表，则进行创建
CREATE TABLE [dbo].[HttpDestineInfo](
	[tradeNo] [VARCHAR](100) NOT NULL,
        [code] [VARCHAR](50) NOT NULL,
	[shopId] [VARCHAR](20) NULL,
	[dateTime] [DATETIME] NULL,
	[destineTime] [DATETIME] NULL,
	[soeUserId] [VARCHAR](20) NULL,
	[clientID] [VARCHAR](20) NULL,
	[clientName] [VARCHAR](20) NULL,
	[moveTel] [VARCHAR](30) NULL,
	[state] [INT] NOT NULL,
	[amount] [INT] NOT NULL,
	[paymentType] [VARCHAR](20) NULL,
	[payMoney] decimal(15, 2),
	[reduceMoney] decimal(15, 2),
	[remark] [VARCHAR](2000) NULL
PRIMARY KEY CLUSTERED 
(
	[tradeNo] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 95) ON [PRIMARY]
) ON [PRIMARY]

ALTER TABLE [dbo].[HttpDestineInfo] ADD  DEFAULT ((0)) FOR [state]
ALTER TABLE [dbo].[HttpDestineInfo] ADD  DEFAULT ((0)) FOR [amount]
END
GO

--预约项目（子表）
IF OBJECT_ID (N'HttpDestineGoods') IS NULL
BEGIN  --如果不存在该表，则进行创建
CREATE TABLE [dbo].[HttpDestineGoods](
        [guID] [VARCHAR](100) NOT NULL,
	[tradeNo] [VARCHAR](100) NOT NULL,
        [goodsName] [VARCHAR](30) NULL,
	[goodsId] [VARCHAR](20) NULL,
        [goodsAmount] [int] NOT NULL
PRIMARY KEY CLUSTERED 
(
	[guID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 95) ON [PRIMARY]
) ON [PRIMARY]

ALTER TABLE [dbo].[HttpDestineGoods]  WITH NOCHECK ADD  CONSTRAINT [FK_HttpDestineGoods_tradeNo] FOREIGN KEY([tradeNo])
REFERENCES HttpDestineInfo ([tradeNo])
ON DELETE CASCADE

ALTER TABLE [dbo].[HttpDestineGoods] ADD  DEFAULT ((0)) FOR [goodsAmount]
END
GO


--更新参数功能说明

update T_WORKERQUEUEPARAMETER set  F_REMARK = '是否启用线上预约弹框提醒', F_VERSION = '18.0.124.1526' where F_ID = 'IsUseWeiXinDestine';

GO



--添加付款方式
IF NOT EXISTS(
   SELECT * FROM T_CHECKOUTTYPE WHERE F_Name = '优惠折扣')
BEGIN  
  IF NOT EXISTS(
     SELECT * FROM T_CHECKOUTTYPE WHERE F_ID = 'W24')
  BEGIN  
     INSERT T_CHECKOUTTYPE
             ( F_ID ,
               F_NAME ,
               F_OrderID ,
               F_IsStop ,
               F_IsSupplent ,
               F_IsCheckout ,
               F_IsNeedAuthorize
             )
     VALUES  ( 'W24' , -- F_ID - varchar(10)
               '优惠折扣' , -- F_NAME - varchar(20)
               '9999' , -- F_OrderID - varchar(10)
               0 , -- F_IsStop - smallint
               1 , -- F_IsSupplent - smallint
               1 , -- F_IsCheckout - smallint
               0
             )
  END
END
GO

--end hj



IF OBJECT_ID (N'T_RECEIVE_EXTEND') IS NULL
BEGIN  
CREATE TABLE [dbo].[T_RECEIVE_EXTEND](
	[F_ID] [VARCHAR](20) NOT NULL,
	[F_ROOMID] [VARCHAR](20) NOT NULL,
	[F_STARTDATETIME] [DATETIME] NULL,
	[F_ENDDATETIME] [DATETIME] NULL,
	[F_SHOPID] [VARCHAR](20) NULL,
	[F_RECEIVEID] [VARCHAR](20) NOT NULL,
	[F_USERID] [VARCHAR](20) NULL,
 CONSTRAINT [PK_T_EXTEND_RECEIVE] PRIMARY KEY CLUSTERED 
(
	[F_ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
END

GO