IF NOT EXISTS ( SELECT  *
                FROM    syscolumns
                WHERE   id = OBJECT_ID('T_TSC_MODE')
                        AND name = 'F_ENABLE' )
    BEGIN  
        ALTER TABLE T_TSC_MODE ADD F_ENABLE INTEGER NULL DEFAULT 0
    END
GO

IF NOT EXISTS ( SELECT  *
                FROM    syscolumns
                WHERE   id = OBJECT_ID('T_TSC_MODE')
                        AND name = 'F_STATUS' )
    BEGIN  
        ALTER TABLE T_TSC_MODE ADD F_STATUS INTEGER NULL DEFAULT 0
    END
GO

IF NOT EXISTS ( SELECT  *
                FROM    syscolumns
                WHERE   id = OBJECT_ID('T_TSC_MODE')
                        AND name = 'F_BRIGHTFOUR' )
    BEGIN  
        ALTER TABLE T_TSC_MODE ADD F_BRIGHTFOUR INTEGER NULL DEFAULT 0
    END
GO

IF NOT EXISTS ( SELECT  *
                FROM    syscolumns
                WHERE   id = OBJECT_ID('T_TSC_MODE')
                        AND name = 'F_BRIGHTTWO' )
    BEGIN  
        ALTER TABLE T_TSC_MODE ADD F_BRIGHTTWO INTEGER NULL DEFAULT 0
    END
GO

IF NOT EXISTS ( SELECT  *
                FROM    syscolumns
                WHERE   id = OBJECT_ID('T_TSC_MODE')
                        AND name = 'F_BRIGHTTHREE' )
    BEGIN  
        ALTER TABLE T_TSC_MODE ADD F_BRIGHTTHREE INTEGER NULL DEFAULT 0
    END
GO


IF NOT EXISTS ( SELECT  *
                FROM    syscolumns
                WHERE   id = OBJECT_ID('T_TSC_STATE')
                        AND name = 'F_ENABLE' )
    BEGIN  
        ALTER TABLE T_TSC_STATE ADD F_ENABLE INTEGER NULL DEFAULT 0
    END
GO

IF NOT EXISTS ( SELECT  *
                FROM    syscolumns
                WHERE   id = OBJECT_ID('T_TSC_STATE')
                        AND name = 'F_STATUS' )
    BEGIN  
        ALTER TABLE T_TSC_STATE ADD F_STATUS INTEGER NULL DEFAULT 0
    END
GO

IF NOT EXISTS ( SELECT  *
                FROM    syscolumns
                WHERE   id = OBJECT_ID('T_TSC_STATE')
                        AND name = 'F_BRIGHTFOUR' )
    BEGIN  
        ALTER TABLE T_TSC_STATE ADD F_BRIGHTFOUR INTEGER NULL DEFAULT 0
    END
GO

IF NOT EXISTS ( SELECT  *
                FROM    syscolumns
                WHERE   id = OBJECT_ID('T_TSC_STATE')
                        AND name = 'F_BRIGHTTWO' )
    BEGIN  
        ALTER TABLE T_TSC_STATE ADD F_BRIGHTTWO INTEGER NULL DEFAULT 0
    END
GO

IF NOT EXISTS ( SELECT  *
                FROM    syscolumns
                WHERE   id = OBJECT_ID('T_TSC_STATE')
                        AND name = 'F_BRIGHTTHREE' )
    BEGIN  
        ALTER TABLE T_TSC_STATE ADD F_BRIGHTTHREE INTEGER NULL DEFAULT 0
    END
GO