if not exists (select * FROM sys.sysobjects where id = object_id(N'dbo.Subscription'))
    create table dbo.Subscription
    (
        ID uniqueidentifier not null constraint PK_Subscription primary key clustered
        ,SubscriptionType varchar(50) not null
        ,GroupName nvarchar(max) null
        ,UserID uniqueidentifier not null
        ,IsActive bit not null constraint DF_Subscription_IsActive default (1)
    )