CREATE TABLE [dbo].[GraviteeLogs] (
    [ID] [bigint] NOT NULL IDENTITY,
    [LogUploadDateTime] [datetime] NOT NULL,
    [apiCallDateTime] [datetime] NOT NULL,
    [plan] [nvarchar](max),
    [application] [nvarchar](max),
    [path] [nvarchar](max),
    [method] [nvarchar](max),
    [status] [int] NOT NULL,
    [responsetime] [int] NOT NULL,
    CONSTRAINT [PK_dbo.GraviteeLogs] PRIMARY KEY ([ID])
)


ALTER TABLE [dbo].[FFBranches] ADD [DwellTimeSource] [nvarchar](max)

ALTER TABLE [dbo].[ffbranches] ADD DEFAULT 'inout' for [DwellTimeSource]

UPDATE [dbo].[ffbranches] SET [DwellTimeSource] = 'inout' WHERE [DwellTimeSource] IS NULL

ALTER TABLE [dbo].[DashboardInstances] ADD [Configurations] [nvarchar](max)
ALTER TABLE [dbo].[DashboardTemplates] ADD [Configurations] [nvarchar](max)


ALTER TABLE [dbo].[Companies] ADD [GraviteePlanId] [nvarchar](max)