--V3.2 sql
--无线呼叫铃
IF OBJECT_ID (N'T_RCCALL') IS NULL
BEGIN  
CREATE TABLE [dbo].[T_RCCALL](
	[F_ADDRESS] [varchar](10) NULL,
	[F_LINGID] [varchar](20) NULL,
	[F_LOC] [int] NULL,
	[F_LOC_REMARK] [varchar](50) NULL,
	[F_SHOPID] [varchar](20) NULL,
	[F_ID] [varchar](20) NULL
) ON [PRIMARY]

END
GO


--18.1.114.1516
--线上会员服务
if not exists(select * from T_WORKERQUEUEPARAMETER where F_ID = 'EnableOnlineMemberService') 
BEGIN
  INSERT INTO T_WORKERQUEUEPARAMETER (F_ID, F_VALUE, F_SHOPID, F_REMARK, F_ISHIDE, F_TYPE) VALUES ('EnableOnlineMemberService', '0', NULL, '是否启用线上会员服务', 0, '在线服务');
END
Go

--线上会员服务
if not exists(select * from T_WORKERQUEUEPARAMETER where F_ID = 'OnlineMemberServiceURI') 
BEGIN
  INSERT INTO T_WORKERQUEUEPARAMETER (F_ID, F_VALUE, F_SHOPID, F_REMARK, F_ISHIDE, F_TYPE) VALUES ('OnlineMemberServiceURI', 'https://www.zhizhongbao.cn/protea-service/api/', NULL, '线上会员服务请求地址', 0, '在线服务');
END
Go


--索易认证服务
if not exists(select * from T_WORKERQUEUEPARAMETER where F_ID = 'OnlineAuthServiceURI') 
BEGIN
  INSERT INTO T_WORKERQUEUEPARAMETER (F_ID, F_VALUE, F_SHOPID, F_REMARK, F_ISHIDE, F_TYPE) VALUES ('OnlineAuthServiceURI', 'https://www.zhizhongbao.cn/soeauth-service/api/', NULL, '线上认证服务请求地址', 0, '在线服务');
END
Go


DROP VIEW [dbo].[V_MEMBERBYTIME]
GO

CREATE VIEW [dbo].[V_MEMBERBYTIME](
    "F_AUTOID",
    "F_MEMBERID",
    "F_GOODSID",
    "F_GOODSNAME",
    "F_GOODSABC",
    "F_STATE",
    "F_PRICE",
    "F_AMOUNT",
    "F_REMARK",
    "F_TRANSMITGROUP",
    "F_COST",
    "F_GOODSTYPENAME",
    "F_CANREBATE",
    "F_COSTTYPE",
    "F_ISSTORAGE",
    "F_CLIENTAUTOID",
    "F_CLIENTID",
    "F_CLIENTNAME",
    "F_SHOPID",
    "F_TELEPHONE",
    "F_MOVETEL",
    "F_CARDTYPENAME",
	"F_ID")
AS
select T_MEMBERBYTIME.F_AUTOID,
T_MEMBERBYTIME.F_MEMBERID,
T_MEMBERBYTIME.F_GOODSID,
T_GOODS.F_NAME F_GOODSNAME,
T_GOODS.F_NAMEABC F_GOODSABC,
T_GOODSTYPE1.F_STATE,
T_MEMBERBYTIME.F_PRICE,
T_MEMBERBYTIME.F_AMOUNT,
T_MEMBERBYTIME.F_REMARK,
T_MEMBERBYTIME.F_TRANSMITGROUP,
T_GOODS.F_COST,
T_GOODSTYPE.F_NAME As F_GOODSTYPENAME,
T_GOODS.F_CANREBATE,
T_GOODS.F_COSTTYPE,
T_GOODSTYPE1.F_ISSTORAGE,
T_CLIENT.f_autoid AS F_CLIENTAUTOID,
T_CLIENT.F_ID AS F_CLIENTID,
T_CLIENT.f_name AS F_CLIENTNAME,
T_CLIENT.f_shopid,
T_CLIENT.f_telephone,
T_CLIENT.f_movetel,
T_CARDTYPE.f_name AS F_CARDTYPENAME,
T_MEMBERBYTIME.F_ID from T_MEMBERBYTIME
  left join T_CLIENT ON (t_memberbytime.f_memberid =  T_CLIENT.F_ID)
  LEFT JOIN t_goods ON (T_MEMBERBYTIME.f_goodsid = t_goods.f_id)
  LEFT JOIN t_cardtype ON (t_client.f_cardtypeid = t_cardtype.f_id)
  LEFT JOIN t_goodstype ON (t_goods.f_goodstypeid = t_goodstype.f_id)
  LEFT JOIN t_goodstype1 ON (t_goods.f_goodstype1id = t_goodstype1.f_id)
; 

GO