IF OBJECT_ID (N'T_RECEIVE_PREPAY') IS NULL
BEGIN  --如果不存在该表，则进行创建
CREATE TABLE [T_RECEIVE_PREPAY](
	[F_ID] [VARCHAR](20) NOT NULL,
	[F_RECEIVEID] [VARCHAR](20) NOT NULL,
	[F_TYPE] [VARCHAR](20) NOT NULL,
	[F_GATHERING] [DECIMAL](15, 2) NOT NULL,
	[F_REMARK] [VARCHAR](200) NULL,
        [F_KEYID] [VARCHAR](50) NULL,
        [F_PAYMENTTYPE] [VARCHAR](30) NULL,
 CONSTRAINT [PK_T_RECEIVE_PREPAY] 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]

ALTER TABLE [dbo].[T_RECEIVE_PREPAY]  WITH CHECK ADD  CONSTRAINT [FK_T_RECEIVE_PREPAY_T_RECEIVE] FOREIGN KEY([F_RECEIVEID])
REFERENCES [dbo].[T_RECEIVE] ([F_ID])
ON DELETE CASCADE

ALTER TABLE [dbo].[T_RECEIVE_PREPAY] CHECK CONSTRAINT [FK_T_RECEIVE_PREPAY_T_RECEIVE]
END


GO

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

GO

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

GO

IF NOT EXISTS(
   SELECT * 
    FROM syscolumns 
    WHERE id=object_id('T_CONSUME') and Name='F_DESTINEGOODSID')
BEGIN  
    ALTER TABLE T_CONSUME ADD F_DESTINEGOODSID VARCHAR(30);	
END

GO

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

GO

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

GO

IF NOT EXISTS(
   SELECT * 
    FROM syscolumns 
    WHERE id=object_id('T_DELETE_CONSUME') and Name='F_DESTINEGOODSID')
BEGIN  
    ALTER TABLE T_DELETE_CONSUME ADD F_DESTINEGOODSID VARCHAR(30);	
END

GO


IF NOT EXISTS(
   SELECT * 
    FROM syscolumns 
    WHERE id=object_id('T_SoeSwitch') and Name='F_DelayType')
BEGIN  
        ALTER TABLE T_SoeSwitch ADD F_DelayType varchar(20) NOT NULL DEFAULT '00' 
END

GO