if not exists(select * from T_WORKERQUEUEPARAMETER where F_ID = 'Z8QrCodeURL') 
BEGIN
  INSERT INTO T_WORKERQUEUEPARAMETER (F_ID, F_VALUE, F_SHOPID, F_REMARK, F_ISHIDE, F_TYPE) VALUES ('Z8QrCodeURL', '', NULL, 'Z8二维码链接格式', 0, '在线服务');
END
Go

--Z8二维码管理表
IF OBJECT_ID (N'T_TS_QRCODE') IS NULL
BEGIN
CREATE TABLE [dbo].[T_TS_QRCODE](
	[F_ADDRESS] [int] NOT NULL,
	[F_QRCODETYPE] [int] NOT NULL,
	[F_ROOMSHOWID] [varchar](20) NULL,
	[F_TITLE] [varchar](20) NULL,
	[F_CONTENT] [varchar](100) NULL,
	[F_SHOPCODE] [varchar](10) NULL,
	[F_CRMID] [varchar](10) NULL,
	[F_SHOPID] [varchar](10) NULL,
	[F_SHORTURL] [varchar](200) NULL,
 CONSTRAINT [PK_T_TS_QRCODE] PRIMARY KEY CLUSTERED 
(
	[F_ADDRESS] ASC,
	[F_QRCODETYPE] 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].[T_TS_QRCODE]  WITH CHECK ADD  CONSTRAINT [FK_T_TS_QRCODE_T_SHOP] FOREIGN KEY([F_SHOPID])
REFERENCES [dbo].[T_SHOP] ([F_ID])

ALTER TABLE [dbo].[T_TS_QRCODE] CHECK CONSTRAINT [FK_T_TS_QRCODE_T_SHOP]

END

GO