--会员赠送金额是否只允许本店消费
if not exists(select * from T_WORKERQUEUEPARAMETER where F_ID = 'IsNamedAddClockEnqueAddClock') 
BEGIN
  INSERT INTO T_WORKERQUEUEPARAMETER (F_ID, F_VALUE, F_SHOPID, F_REMARK, F_ISHIDE, F_TYPE,F_VERSION,F_ADDDATE
) VALUES ('IsNamedAddClockEnqueAddClock', '0', NULL, '点钟加钟是否按加钟方式排钟', 0, '排钟方式','18.0.110','2017-08-02');
END

GO


--口碑券对应的系统卡类型
if not exists(select * from T_WORKERQUEUEPARAMETER where F_ID = 'KouBeiTicketTypeId') 
BEGIN
  INSERT INTO T_WORKERQUEUEPARAMETER (F_ID, F_VALUE, F_SHOPID, F_REMARK, F_ISHIDE, F_TYPE,F_VERSION,F_ADDDATE
) VALUES ('KouBeiTicketTypeId', '', NULL, '口碑券对应的系统卡类型', 0, '在线服务','18.0.110','2017-08-15');
END

GO

IF NOT EXISTS(
   SELECT * 
    FROM syscolumns 
    WHERE id=object_id('T_TICKET') and Name='F_IsECoupon')
BEGIN  
        ALTER TABLE T_TICKET ADD F_IsECoupon INTEGER DEFAULT 0 
END
GO