IF NOT EXISTS(
SELECT * 
   FROM syscolumns 
   WHERE id=object_id('T_RECEIVE_H') and Name='F_RecieveLockingState')
BEGIN
        ALTER TABLE T_RECEIVE_H DROP COLUMN F_Ministerid

        ALTER TABLE T_RECEIVE_H ADD F_RecieveLockingState int
        ALTER TABLE T_RECEIVE_H ADD F_RecieveLockingTime datetime
		ALTER TABLE T_RECEIVE_H ADD F_Ministerid varchar(10)
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 int
END