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


IF OBJECT_ID (N'T_EXPENSE_CONSUME_AWORE') IS NULL
BEGIN  --如果不存在该表，则进行创建

CREATE TABLE [dbo].[T_EXPENSE_CONSUME_AWORE](
	[F_ID] [VARCHAR](20) NOT NULL,
	[F_CLIENTID] [VARCHAR](20) NOT NULL,
	[F_MONEY] [DECIMAL](15, 2) NOT NULL,
	[F_DATETIME] [DATETIME] NULL,
	[F_ROOMID] [VARCHAR](20) NOT NULL,
	[F_CANCOSTMONEY] [DECIMAL](15, 2) NOT NULL,
	[F_REMARK] [VARCHAR](250) NULL,
	[F_SHOPID] [VARCHAR](10) NULL,
 CONSTRAINT [PK_EXPENSE_CONSUME_AWORE] 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, FILLFACTOR = 95) ON [PRIMARY]
) ON [PRIMARY]

END
GO
IF NOT EXISTS ( SELECT  *
                FROM    syscolumns
                WHERE   id = OBJECT_ID('T_RECEIVE')
                        AND Name = 'F_SOEUSERID' )
    BEGIN  
       
      ALTER TABLE T_RECEIVE ADD F_SOEUSERID VARCHAR(50) NULL; 
    
    END


GO
IF NOT EXISTS ( SELECT  *
                FROM    syscolumns
                WHERE   id = OBJECT_ID('T_RECEIVE_H')
                        AND Name = 'F_SOEUSERID' )
    BEGIN  
        
      ALTER TABLE T_RECEIVE_H ADD F_SOEUSERID VARCHAR(50) NULL; 
    
   END


GO

IF NOT EXISTS ( SELECT  *
                FROM    syscolumns
                WHERE   id = OBJECT_ID('T_RECEIVE')
                        AND Name = 'F_OPENRECEIVETYPE' )
    BEGIN  
        
      ALTER TABLE T_RECEIVE ADD F_OPENRECEIVETYPE VARCHAR(50) NULL; 
    
    END


GO

IF NOT EXISTS ( SELECT  *
                FROM    syscolumns
                WHERE   id = OBJECT_ID('T_RECEIVE_H')
                        AND Name = 'F_OPENRECEIVETYPE' )
    BEGIN  
       
       ALTER TABLE T_RECEIVE_H ADD F_OPENRECEIVETYPE VARCHAR(50) NULL; 
    
    END


GO


IF NOT EXISTS(
   SELECT * 
    FROM syscolumns 
    WHERE id=object_id('T_EXPENSE_CONSUME_AWORE') and Name='F_CURRENTUSEDMONEY')
BEGIN  
        ALTER TABLE T_EXPENSE_CONSUME_AWORE ADD F_CURRENTUSEDMONEY DECIMAL(9, 2)
       
END

GO