set ANSI_PADDING on;
set ANSI_PADDING on;
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'T_RECEIVE_PREPAY') AND name = N'UNI_RECEIVE_PREPAY_TRADENO')
BEGIN

CREATE UNIQUE NONCLUSTERED INDEX UNI_RECEIVE_PREPAY_TRADENO
ON T_RECEIVE_PREPAY(F_RECEIVEID, F_KEYID) WHERE F_KEYID is not NULL

END


GO

IF NOT EXISTS(
   SELECT * 
    FROM syscolumns 
    WHERE id=object_id('T_TSC_STATE') and Name='F_ROOMID')
BEGIN  
        ALTER TABLE T_TSC_STATE ADD F_ROOMID VARCHAR(10)
END

GO


UPDATE T_TSC_STATE SET F_ROOMID = T_SMARTLIST.F_ROOMID   FROM T_SMARTLIST 
WHERE T_SMARTLIST.F_ADDRESS = T_TSC_STATE.F_ADDRESS AND  T_SMARTLIST.F_SHOPID = T_TSC_STATE.F_SHOPID

GO



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


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


GO