-- linx 修复清除历史记录出错
IF NOT EXISTS(
   SELECT * 
    FROM syscolumns 
    WHERE id=object_id('T_DESTINE_H') and Name='F_DESTINEWORKERAUTOID')
BEGIN  
        ALTER TABLE T_DESTINE_H ADD F_DESTINEWORKERAUTOID int NULL 
END

GO 

IF NOT EXISTS(
   SELECT * 
    FROM syscolumns 
    WHERE id=object_id('T_RECEIVE_H') and Name='F_RecieveLockingState')
BEGIN  
        ALTER TABLE T_RECEIVE_H ADD F_RecieveLockingState int NULL 
END
GO 
IF NOT EXISTS(
   SELECT * 
    FROM syscolumns 
    WHERE id=object_id('T_RECEIVE_H') and Name='F_RecieveLockingTime')
BEGIN  
        ALTER TABLE T_RECEIVE_H ADD F_RecieveLockingTime datetime NULL 
END
GO 
IF NOT EXISTS(
   SELECT * 
    FROM syscolumns 
    WHERE id=object_id('T_CONSUME_H') and Name='F_GOODSSHOWID')
BEGIN  
        ALTER TABLE T_CONSUME_H ADD F_GOODSSHOWID varchar(30) NULL 
END
GO 
IF NOT EXISTS(
   SELECT * 
    FROM syscolumns 
    WHERE id=object_id('T_CONSUMEWORKER_H') and Name='F_SelClock')
BEGIN  
        ALTER TABLE T_CONSUMEWORKER_H ADD F_SelClock varchar(200) NULL 
END
GO