IF OBJECT_ID(N'[__EFMigrationsHistory]') IS NULL
BEGIN
    CREATE TABLE [__EFMigrationsHistory] (
        [MigrationId] nvarchar(150) NOT NULL,
        [ProductVersion] nvarchar(32) NOT NULL,
        CONSTRAINT [PK___EFMigrationsHistory] PRIMARY KEY ([MigrationId])
    );
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20190812233518_Initial')
BEGIN
    CREATE TABLE [AssetReceivers] (
        [AssetReceiverId] int NOT NULL IDENTITY,
        [PLReceiverId] int NOT NULL,
        [SubUnitId] int NULL,
        [AssetId] int NULL,
        [ReceiverHitDate] datetime2 NOT NULL,
        [UnitId] int NULL,
        [Active] bit NULL,
        [AddedOn] datetime2 NULL,
        [EditedOn] datetime2 NULL,
        [AddedBy] nvarchar(max) NULL,
        [EditedBy] nvarchar(max) NULL,
        CONSTRAINT [PK_AssetReceivers] PRIMARY KEY ([AssetReceiverId])
    );
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20190812233518_Initial')
BEGIN
    CREATE TABLE [Assets] (
        [AssetId] int NOT NULL IDENTITY,
        [AssetName] nvarchar(max) NOT NULL,
        [AssetSubTypeId] int NULL,
        [AssetTypeId] int NOT NULL,
        [BadgeId] bigint NULL,
        [Manufacturer] nvarchar(max) NULL,
        [Owner] nvarchar(max) NULL,
        [PreventativeMainteanceDate] datetime2 NULL,
        [BatteryChangeDate] datetime2 NULL,
        [Model] nvarchar(max) NULL,
        [AssetReceiverId] int NULL,
        [TEInitials] nvarchar(max) NULL,
        [TEFirstName] nvarchar(max) NULL,
        [TELastName] nvarchar(max) NULL,
        [TENameAlias] nvarchar(max) NULL,
        [Active] bit NULL,
        [AddedOn] datetime2 NULL,
        [EditedOn] datetime2 NULL,
        [AddedBy] nvarchar(max) NULL,
        [EditedBy] nvarchar(max) NULL,
        CONSTRAINT [PK_Assets] PRIMARY KEY ([AssetId])
    );
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20190812233518_Initial')
BEGIN
    CREATE TABLE [AssetSubTypes] (
        [AssetSubTypeId] int NOT NULL IDENTITY,
        [Description] nvarchar(max) NOT NULL,
        [AssetTypeId] int NOT NULL,
        [Active] bit NULL,
        [AddedOn] datetime2 NULL,
        [EditedOn] datetime2 NULL,
        [AddedBy] nvarchar(max) NULL,
        [EditedBy] nvarchar(max) NULL,
        CONSTRAINT [PK_AssetSubTypes] PRIMARY KEY ([AssetSubTypeId])
    );
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20190812233518_Initial')
BEGIN
    CREATE TABLE [AssetTypes] (
        [AssetTypeId] int NOT NULL IDENTITY,
        [Description] nvarchar(max) NOT NULL,
        [BadgeTypeId] int NULL,
        [Active] bit NULL,
        [AddedOn] datetime2 NULL,
        [EditedOn] datetime2 NULL,
        [AddedBy] nvarchar(max) NULL,
        [EditedBy] nvarchar(max) NULL,
        CONSTRAINT [PK_AssetTypes] PRIMARY KEY ([AssetTypeId])
    );
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20190812233518_Initial')
BEGIN
    CREATE TABLE [BadgeTypes] (
        [BadgeTypeId] int NOT NULL IDENTITY,
        [TEBadgeTypeId] int NOT NULL,
        [BadgeTypeDescription] nvarchar(max) NULL,
        [GraphicFilePathName] nvarchar(max) NULL,
        [Active] bit NULL,
        [AddedOn] datetime2 NULL,
        [EditedOn] datetime2 NULL,
        [AddedBy] nvarchar(max) NULL,
        [EditedBy] nvarchar(max) NULL,
        CONSTRAINT [PK_BadgeTypes] PRIMARY KEY ([BadgeTypeId])
    );
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20190812233518_Initial')
BEGIN
    CREATE TABLE [LocationChanges] (
        [LocationChangeId] int NOT NULL IDENTITY,
        [BadgeNumber] bigint NOT NULL,
        [Qualifiers] nvarchar(max) NULL,
        [Initials] nvarchar(max) NULL,
        [FirstName] nvarchar(max) NULL,
        [LastName] nvarchar(max) NULL,
        [NamePhone] nvarchar(max) NULL,
        [LocationID] int NULL,
        [LocationName] nvarchar(max) NULL,
        [LocationPhone] nvarchar(max) NULL,
        [Collector] nvarchar(max) NULL,
        [Sensor] nvarchar(max) NULL,
        [TimeEntered] nvarchar(max) NULL,
        [TimeLastSeen] nvarchar(max) NULL,
        [ReceiverType] int NULL,
        [LastLocationID] int NULL,
        [LastLocationName] nvarchar(max) NULL,
        [BadgeType] int NULL,
        [BadgeTypeDescription] nvarchar(max) NULL,
        CONSTRAINT [PK_LocationChanges] PRIMARY KEY ([LocationChangeId])
    );
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20190812233518_Initial')
BEGIN
    CREATE TABLE [NotificationDetails] (
        [NotificationDetailId] int NOT NULL IDENTITY,
        [NotificationTypeId] int NOT NULL,
        [NotificationDate] datetime2 NOT NULL,
        [PLEventDetailId] int NULL,
        [Active] bit NULL,
        [AddedOn] datetime2 NULL,
        [EditedOn] datetime2 NULL,
        [AddedBy] nvarchar(max) NULL,
        [EditedBy] nvarchar(max) NULL,
        CONSTRAINT [PK_NotificationDetails] PRIMARY KEY ([NotificationDetailId])
    );
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20190812233518_Initial')
BEGIN
    CREATE TABLE [Notifications] (
        [NotificationId] int NOT NULL IDENTITY,
        [EventId] int NOT NULL,
        [Active] bit NULL,
        [AddedOn] datetime2 NULL,
        [EditedOn] datetime2 NULL,
        [AddedBy] nvarchar(max) NULL,
        [EditedBy] nvarchar(max) NULL,
        CONSTRAINT [PK_Notifications] PRIMARY KEY ([NotificationId])
    );
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20190812233518_Initial')
BEGIN
    CREATE TABLE [NotificationTypes] (
        [NotificationTypeId] int NOT NULL IDENTITY,
        [Description] nvarchar(max) NOT NULL,
        [Active] bit NULL,
        [AddedOn] datetime2 NULL,
        [EditedOn] datetime2 NULL,
        [AddedBy] nvarchar(max) NULL,
        [EditedBy] nvarchar(max) NULL,
        CONSTRAINT [PK_NotificationTypes] PRIMARY KEY ([NotificationTypeId])
    );
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20190812233518_Initial')
BEGIN
    CREATE TABLE [PLAssetCounts] (
        [AssetCountId] int NOT NULL IDENTITY,
        [Count] int NOT NULL,
        [AssetTypeId] int NOT NULL,
        [UnitId] int NOT NULL,
        [Active] bit NULL,
        [AddedOn] datetime2 NULL,
        [EditedOn] datetime2 NULL,
        [AddedBy] nvarchar(max) NULL,
        [EditedBy] nvarchar(max) NULL,
        CONSTRAINT [PK_PLAssetCounts] PRIMARY KEY ([AssetCountId])
    );
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20190812233518_Initial')
BEGIN
    CREATE TABLE [PLBadges] (
        [PLBadgeId] bigint NOT NULL IDENTITY,
        [TEBadgeId] bigint NOT NULL,
        [Name] nvarchar(max) NOT NULL,
        [BadgeTypeId] int NOT NULL,
        [BadgeTypeDescription] nvarchar(max) NULL,
        [Initials] nvarchar(max) NOT NULL,
        [Active] bit NULL,
        [AddedOn] datetime2 NULL,
        [EditedOn] datetime2 NULL,
        [AddedBy] nvarchar(max) NULL,
        [EditedBy] nvarchar(max) NULL,
        CONSTRAINT [PK_PLBadges] PRIMARY KEY ([PLBadgeId])
    );
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20190812233518_Initial')
BEGIN
    CREATE TABLE [PLEventDetails] (
        [NotificationId] int NOT NULL IDENTITY,
        [EventDetailDate] int NOT NULL,
        [PLEventDetailType] int NOT NULL,
        [PLEventId] int NOT NULL,
        [Active] bit NULL,
        [AddedOn] datetime2 NULL,
        [EditedOn] datetime2 NULL,
        [AddedBy] nvarchar(max) NULL,
        [EditedBy] nvarchar(max) NULL,
        CONSTRAINT [PK_PLEventDetails] PRIMARY KEY ([NotificationId])
    );
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20190812233518_Initial')
BEGIN
    CREATE TABLE [PLEventDetailTypes] (
        [PLEventDetailTypeId] int NOT NULL IDENTITY,
        [Description] nvarchar(max) NOT NULL,
        [Active] bit NULL,
        [AddedOn] datetime2 NULL,
        [EditedOn] datetime2 NULL,
        [AddedBy] nvarchar(max) NULL,
        [EditedBy] nvarchar(max) NULL,
        CONSTRAINT [PK_PLEventDetailTypes] PRIMARY KEY ([PLEventDetailTypeId])
    );
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20190812233518_Initial')
BEGIN
    CREATE TABLE [PLEvents] (
        [PLEventId] int NOT NULL IDENTITY,
        [EventTypeId] int NOT NULL,
        [Description] int NOT NULL,
        [StartDate] datetime2 NOT NULL,
        [EndDate] datetime2 NULL,
        [Active] bit NULL,
        [AddedOn] datetime2 NULL,
        [EditedOn] datetime2 NULL,
        [AddedBy] nvarchar(max) NULL,
        [EditedBy] nvarchar(max) NULL,
        CONSTRAINT [PK_PLEvents] PRIMARY KEY ([PLEventId])
    );
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20190812233518_Initial')
BEGIN
    CREATE TABLE [PLEventTypes] (
        [PLEventTypeId] int NOT NULL IDENTITY,
        [Description] nvarchar(max) NOT NULL,
        [NotificationEnabled] bit NULL,
        [Color] nvarchar(max) NULL,
        [Active] bit NULL,
        [AddedOn] datetime2 NULL,
        [EditedOn] datetime2 NULL,
        [AddedBy] nvarchar(max) NULL,
        [EditedBy] nvarchar(max) NULL,
        CONSTRAINT [PK_PLEventTypes] PRIMARY KEY ([PLEventTypeId])
    );
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20190812233518_Initial')
BEGIN
    CREATE TABLE [PLReceivers] (
        [PLReceiverId] int NOT NULL IDENTITY,
        [TEReceiverID] int NOT NULL,
        [SubUnitId] int NULL,
        [ReceiverName] nvarchar(max) NULL,
        [ReceiverAlias] nvarchar(max) NULL,
        [Phone] nvarchar(max) NULL,
        [UnitId] int NULL,
        [Active] bit NULL,
        [AddedOn] datetime2 NULL,
        [EditedOn] datetime2 NULL,
        [AddedBy] nvarchar(max) NULL,
        [EditedBy] nvarchar(max) NULL,
        CONSTRAINT [PK_PLReceivers] PRIMARY KEY ([PLReceiverId])
    );
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20190812233518_Initial')
BEGIN
    CREATE TABLE [SubUnits] (
        [SubUnitId] int NOT NULL IDENTITY,
        [UnitId] int NOT NULL,
        [ReceiverId] int NOT NULL,
        [IsClean] bit NULL,
        [IsDirty] bit NULL,
        [Active] bit NULL,
        [AddedOn] datetime2 NULL,
        [EditedOn] datetime2 NULL,
        [AddedBy] nvarchar(max) NULL,
        [EditedBy] nvarchar(max) NULL,
        CONSTRAINT [PK_SubUnits] PRIMARY KEY ([SubUnitId])
    );
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20190812233518_Initial')
BEGIN
    CREATE TABLE [ThresholdholdTypes] (
        [ThresholdTypeId] int NOT NULL IDENTITY,
        [Description] nvarchar(max) NOT NULL,
        [Active] bit NULL,
        [AddedOn] datetime2 NULL,
        [EditedOn] datetime2 NULL,
        [AddedBy] nvarchar(max) NULL,
        [EditedBy] nvarchar(max) NULL,
        CONSTRAINT [PK_ThresholdholdTypes] PRIMARY KEY ([ThresholdTypeId])
    );
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20190812233518_Initial')
BEGIN
    CREATE TABLE [Thresholds] (
        [ThresholdId] int NOT NULL IDENTITY,
        [UnitId] int NOT NULL,
        [AssetTypeId] int NOT NULL,
        [Limit] int NULL,
        [ThresholdTypeId] int NOT NULL,
        [Active] bit NULL,
        [AddedOn] datetime2 NULL,
        [EditedOn] datetime2 NULL,
        [AddedBy] nvarchar(max) NULL,
        [EditedBy] nvarchar(max) NULL,
        CONSTRAINT [PK_Thresholds] PRIMARY KEY ([ThresholdId])
    );
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20190812233518_Initial')
BEGIN
    CREATE TABLE [UnitAssetCountGrids] (
        [UnitAssetCountGridId] int NOT NULL IDENTITY,
        [UnitId] int NOT NULL,
        [UnitDescription] nvarchar(max) NULL,
        [AssetTotalCount] int NULL,
        [AssetCountId] int NOT NULL,
        [AssetTypeId] int NOT NULL,
        [AssetSubTypeDescription] nvarchar(max) NULL,
        [AssetTypeDescription] nvarchar(max) NULL,
        [LowParLevel] int NULL,
        [ParLevel] int NULL,
        [HighParLevel] int NULL,
        [CleanCount] int NULL,
        [CleanLowParLevel] int NULL,
        [CleanParLevel] int NULL,
        [CleanHighParLevel] int NULL,
        [DirtyCount] int NULL,
        [DirtyLowParLevel] int NULL,
        [DirtyParLevel] int NULL,
        [DirtyHighParLevel] int NULL,
        [Active] bit NOT NULL,
        [AddedOn] datetime2 NOT NULL,
        [EditedOn] datetime2 NOT NULL,
        [AddedBy] nvarchar(max) NULL,
        [EditedBy] nvarchar(max) NULL,
        CONSTRAINT [PK_UnitAssetCountGrids] PRIMARY KEY ([UnitAssetCountGridId])
    );
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20190812233518_Initial')
BEGIN
    CREATE TABLE [Units] (
        [UnitId] int NOT NULL IDENTITY,
        [UnitName] nvarchar(max) NOT NULL,
        [Active] bit NULL,
        [AddedOn] datetime2 NULL,
        [EditedOn] datetime2 NULL,
        [AddedBy] nvarchar(max) NULL,
        [EditedBy] nvarchar(max) NULL,
        CONSTRAINT [PK_Units] PRIMARY KEY ([UnitId])
    );
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20190812233518_Initial')
BEGIN
    INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
    VALUES (N'20190812233518_Initial', N'3.1.1');
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20190812234344_OperationsV1')
BEGIN
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'UnitId', N'UnitName', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Units]'))
        SET IDENTITY_INSERT [Units] ON;
    INSERT INTO [Units] ([UnitId], [UnitName], [Active], [AddedOn], [EditedOn], [AddedBy], [EditedBy])
    VALUES (1, N'Neuro', CAST(1 AS bit), '2020-01-29T11:39:12.2166289-05:00', '2020-01-29T11:39:12.2166369-05:00', N'Midmark RTLS System', N'Midmark RTLS System');
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'UnitId', N'UnitName', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Units]'))
        SET IDENTITY_INSERT [Units] OFF;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20190812234344_OperationsV1')
BEGIN
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'UnitId', N'UnitName', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Units]'))
        SET IDENTITY_INSERT [Units] ON;
    INSERT INTO [Units] ([UnitId], [UnitName], [Active], [AddedOn], [EditedOn], [AddedBy], [EditedBy])
    VALUES (2, N'Ortho', CAST(1 AS bit), '2020-01-29T11:39:12.2180566-05:00', '2020-01-29T11:39:12.2180611-05:00', N'Midmark RTLS System', N'Midmark RTLS System');
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'UnitId', N'UnitName', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Units]'))
        SET IDENTITY_INSERT [Units] OFF;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20190812234344_OperationsV1')
BEGIN
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'UnitId', N'UnitName', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Units]'))
        SET IDENTITY_INSERT [Units] ON;
    INSERT INTO [Units] ([UnitId], [UnitName], [Active], [AddedOn], [EditedOn], [AddedBy], [EditedBy])
    VALUES (3, N'Labor/Delivery', CAST(1 AS bit), '2020-01-29T11:39:12.2180635-05:00', '2020-01-29T11:39:12.2180638-05:00', N'Midmark RTLS System', N'Midmark RTLS System');
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'UnitId', N'UnitName', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Units]'))
        SET IDENTITY_INSERT [Units] OFF;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20190812234344_OperationsV1')
BEGIN
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'UnitId', N'UnitName', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Units]'))
        SET IDENTITY_INSERT [Units] ON;
    INSERT INTO [Units] ([UnitId], [UnitName], [Active], [AddedOn], [EditedOn], [AddedBy], [EditedBy])
    VALUES (4, N'PreOp', CAST(1 AS bit), '2020-01-29T11:39:12.2180648-05:00', '2020-01-29T11:39:12.2180651-05:00', N'Midmark RTLS System', N'Midmark RTLS System');
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'UnitId', N'UnitName', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Units]'))
        SET IDENTITY_INSERT [Units] OFF;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20190812234344_OperationsV1')
BEGIN
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'UnitId', N'UnitName', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Units]'))
        SET IDENTITY_INSERT [Units] ON;
    INSERT INTO [Units] ([UnitId], [UnitName], [Active], [AddedOn], [EditedOn], [AddedBy], [EditedBy])
    VALUES (5, N'Surgery', CAST(1 AS bit), '2020-01-29T11:39:12.2180659-05:00', '2020-01-29T11:39:12.2180662-05:00', N'Midmark RTLS System', N'Midmark RTLS System');
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'UnitId', N'UnitName', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Units]'))
        SET IDENTITY_INSERT [Units] OFF;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20190812234344_OperationsV1')
BEGIN
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'UnitId', N'UnitName', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Units]'))
        SET IDENTITY_INSERT [Units] ON;
    INSERT INTO [Units] ([UnitId], [UnitName], [Active], [AddedOn], [EditedOn], [AddedBy], [EditedBy])
    VALUES (6, N'Peds', CAST(1 AS bit), '2020-01-29T11:39:12.2180674-05:00', '2020-01-29T11:39:12.2180677-05:00', N'Midmark RTLS System', N'Midmark RTLS System');
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'UnitId', N'UnitName', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Units]'))
        SET IDENTITY_INSERT [Units] OFF;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20190812234344_OperationsV1')
BEGIN
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'UnitId', N'UnitName', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Units]'))
        SET IDENTITY_INSERT [Units] ON;
    INSERT INTO [Units] ([UnitId], [UnitName], [Active], [AddedOn], [EditedOn], [AddedBy], [EditedBy])
    VALUES (7, N'PACU', CAST(1 AS bit), '2020-01-29T11:39:12.2180684-05:00', '2020-01-29T11:39:12.2180687-05:00', N'Midmark RTLS System', N'Midmark RTLS System');
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'UnitId', N'UnitName', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Units]'))
        SET IDENTITY_INSERT [Units] OFF;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20190812234344_OperationsV1')
BEGIN
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'UnitId', N'UnitName', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Units]'))
        SET IDENTITY_INSERT [Units] ON;
    INSERT INTO [Units] ([UnitId], [UnitName], [Active], [AddedOn], [EditedOn], [AddedBy], [EditedBy])
    VALUES (8, N'Cardiology', CAST(1 AS bit), '2020-01-29T11:39:12.2180695-05:00', '2020-01-29T11:39:12.2180698-05:00', N'Midmark RTLS System', N'Midmark RTLS System');
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'UnitId', N'UnitName', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Units]'))
        SET IDENTITY_INSERT [Units] OFF;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20190812234344_OperationsV1')
BEGIN
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'UnitId', N'UnitName', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Units]'))
        SET IDENTITY_INSERT [Units] ON;
    INSERT INTO [Units] ([UnitId], [UnitName], [Active], [AddedOn], [EditedOn], [AddedBy], [EditedBy])
    VALUES (9, N'Oncology', CAST(1 AS bit), '2020-01-29T11:39:12.2180706-05:00', '2020-01-29T11:39:12.2180709-05:00', N'Midmark RTLS System', N'Midmark RTLS System');
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'UnitId', N'UnitName', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Units]'))
        SET IDENTITY_INSERT [Units] OFF;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20190812234344_OperationsV1')
BEGIN
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'Description', N'BadgeTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[AssetTypes]'))
        SET IDENTITY_INSERT [AssetTypes] ON;
    INSERT INTO [AssetTypes] ([Description], [BadgeTypeId], [Active], [AddedOn], [EditedOn], [AddedBy], [EditedBy])
    VALUES (N'IV Pump', 1001, CAST(1 AS bit), '2020-01-29T11:39:12.2180818-05:00', '2020-01-29T11:39:12.2180822-05:00', N'Midmark RTLS System', N'Midmark RTLS System');
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'Description', N'BadgeTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[AssetTypes]'))
        SET IDENTITY_INSERT [AssetTypes] OFF;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20190812234344_OperationsV1')
BEGIN
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'Description', N'BadgeTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[AssetTypes]'))
        SET IDENTITY_INSERT [AssetTypes] ON;
    INSERT INTO [AssetTypes] ([Description], [BadgeTypeId], [Active], [AddedOn], [EditedOn], [AddedBy], [EditedBy])
    VALUES (N'Multi-Channel IV Pump', 1002, CAST(1 AS bit), '2020-01-29T11:39:12.2180831-05:00', '2020-01-29T11:39:12.2180834-05:00', N'Midmark RTLS System', N'Midmark RTLS System');
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'Description', N'BadgeTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[AssetTypes]'))
        SET IDENTITY_INSERT [AssetTypes] OFF;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20190812234344_OperationsV1')
BEGIN
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'Description', N'BadgeTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[AssetTypes]'))
        SET IDENTITY_INSERT [AssetTypes] ON;
    INSERT INTO [AssetTypes] ([Description], [BadgeTypeId], [Active], [AddedOn], [EditedOn], [AddedBy], [EditedBy])
    VALUES (N'PCA Pump', 1003, CAST(1 AS bit), '2020-01-29T11:39:12.2180842-05:00', '2020-01-29T11:39:12.2180845-05:00', N'Midmark RTLS System', N'Midmark RTLS System');
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'Description', N'BadgeTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[AssetTypes]'))
        SET IDENTITY_INSERT [AssetTypes] OFF;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20190812234344_OperationsV1')
BEGIN
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'Description', N'BadgeTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[AssetTypes]'))
        SET IDENTITY_INSERT [AssetTypes] ON;
    INSERT INTO [AssetTypes] ([Description], [BadgeTypeId], [Active], [AddedOn], [EditedOn], [AddedBy], [EditedBy])
    VALUES (N'SCD Pump', 1004, CAST(1 AS bit), '2020-01-29T11:39:12.2180852-05:00', '2020-01-29T11:39:12.2180856-05:00', N'Midmark RTLS System', N'Midmark RTLS System');
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'Description', N'BadgeTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[AssetTypes]'))
        SET IDENTITY_INSERT [AssetTypes] OFF;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20190812234344_OperationsV1')
BEGIN
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'Description', N'BadgeTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[AssetTypes]'))
        SET IDENTITY_INSERT [AssetTypes] ON;
    INSERT INTO [AssetTypes] ([Description], [BadgeTypeId], [Active], [AddedOn], [EditedOn], [AddedBy], [EditedBy])
    VALUES (N'Vein Finder', 1005, CAST(1 AS bit), '2020-01-29T11:39:12.2180865-05:00', '2020-01-29T11:39:12.2180868-05:00', N'Midmark RTLS System', N'Midmark RTLS System');
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'Description', N'BadgeTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[AssetTypes]'))
        SET IDENTITY_INSERT [AssetTypes] OFF;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20190812234344_OperationsV1')
BEGIN
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'Description', N'BadgeTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[AssetTypes]'))
        SET IDENTITY_INSERT [AssetTypes] ON;
    INSERT INTO [AssetTypes] ([Description], [BadgeTypeId], [Active], [AddedOn], [EditedOn], [AddedBy], [EditedBy])
    VALUES (N'Bladder Scanner', 1006, CAST(1 AS bit), '2020-01-29T11:39:12.2180876-05:00', '2020-01-29T11:39:12.2180879-05:00', N'Midmark RTLS System', N'Midmark RTLS System');
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'Description', N'BadgeTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[AssetTypes]'))
        SET IDENTITY_INSERT [AssetTypes] OFF;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20190812234344_OperationsV1')
BEGIN
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'Description', N'BadgeTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[AssetTypes]'))
        SET IDENTITY_INSERT [AssetTypes] ON;
    INSERT INTO [AssetTypes] ([Description], [BadgeTypeId], [Active], [AddedOn], [EditedOn], [AddedBy], [EditedBy])
    VALUES (N'Infusion Pump', 1007, CAST(1 AS bit), '2020-01-29T11:39:12.2180887-05:00', '2020-01-29T11:39:12.2180890-05:00', N'Midmark RTLS System', N'Midmark RTLS System');
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'Description', N'BadgeTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[AssetTypes]'))
        SET IDENTITY_INSERT [AssetTypes] OFF;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20190812234344_OperationsV1')
BEGIN
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'Description', N'BadgeTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[AssetTypes]'))
        SET IDENTITY_INSERT [AssetTypes] ON;
    INSERT INTO [AssetTypes] ([Description], [BadgeTypeId], [Active], [AddedOn], [EditedOn], [AddedBy], [EditedBy])
    VALUES (N'ECG', 1008, CAST(1 AS bit), '2020-01-29T11:39:12.2180898-05:00', '2020-01-29T11:39:12.2180901-05:00', N'Midmark RTLS System', N'Midmark RTLS System');
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'Description', N'BadgeTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[AssetTypes]'))
        SET IDENTITY_INSERT [AssetTypes] OFF;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20190812234344_OperationsV1')
BEGIN
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'Description', N'BadgeTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[AssetTypes]'))
        SET IDENTITY_INSERT [AssetTypes] ON;
    INSERT INTO [AssetTypes] ([Description], [BadgeTypeId], [Active], [AddedOn], [EditedOn], [AddedBy], [EditedBy])
    VALUES (N'Defibrillator', 1009, CAST(1 AS bit), '2020-01-29T11:39:12.2180910-05:00', '2020-01-29T11:39:12.2180913-05:00', N'Midmark RTLS System', N'Midmark RTLS System');
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'Description', N'BadgeTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[AssetTypes]'))
        SET IDENTITY_INSERT [AssetTypes] OFF;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20190812234344_OperationsV1')
BEGIN
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'Description', N'BadgeTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[AssetTypes]'))
        SET IDENTITY_INSERT [AssetTypes] ON;
    INSERT INTO [AssetTypes] ([Description], [BadgeTypeId], [Active], [AddedOn], [EditedOn], [AddedBy], [EditedBy])
    VALUES (N'Stretcher', 1010, CAST(1 AS bit), '2020-01-29T11:39:12.2180921-05:00', '2020-01-29T11:39:12.2180924-05:00', N'Midmark RTLS System', N'Midmark RTLS System');
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'Description', N'BadgeTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[AssetTypes]'))
        SET IDENTITY_INSERT [AssetTypes] OFF;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20190812234344_OperationsV1')
BEGIN
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'Description', N'BadgeTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[AssetTypes]'))
        SET IDENTITY_INSERT [AssetTypes] ON;
    INSERT INTO [AssetTypes] ([Description], [BadgeTypeId], [Active], [AddedOn], [EditedOn], [AddedBy], [EditedBy])
    VALUES (N'Crash Cart', 1011, CAST(1 AS bit), '2020-01-29T11:39:12.2180931-05:00', '2020-01-29T11:39:12.2180934-05:00', N'Midmark RTLS System', N'Midmark RTLS System');
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'Description', N'BadgeTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[AssetTypes]'))
        SET IDENTITY_INSERT [AssetTypes] OFF;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20190812234344_OperationsV1')
BEGIN
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'Description', N'BadgeTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[AssetTypes]'))
        SET IDENTITY_INSERT [AssetTypes] ON;
    INSERT INTO [AssetTypes] ([Description], [BadgeTypeId], [Active], [AddedOn], [EditedOn], [AddedBy], [EditedBy])
    VALUES (N'Wheelchair', 1012, CAST(1 AS bit), '2020-01-29T11:39:12.2180942-05:00', '2020-01-29T11:39:12.2180945-05:00', N'Midmark RTLS System', N'Midmark RTLS System');
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'Description', N'BadgeTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[AssetTypes]'))
        SET IDENTITY_INSERT [AssetTypes] OFF;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20190812234344_OperationsV1')
BEGIN
    BULK INSERT plreceivers FROM 'c:\Users\sdpollack\Source\Repos\ParLevelApplication\ParLevelApplication\Migrations\plreceivers.csv' WITH (FIELDTERMINATOR = ',', ROWTERMINATOR = '\n' )
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20190812234344_OperationsV1')
BEGIN
    BULK INSERT SubUnits FROM 'c:\Users\sdpollack\Source\Repos\ParLevelApplication\ParLevelApplication\Migrations\SubUnits.csv' WITH (FIELDTERMINATOR = ',', ROWTERMINATOR = '\n' )
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20190812234344_OperationsV1')
BEGIN
    INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
    VALUES (N'20190812234344_OperationsV1', N'3.1.1');
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20190920195036_OperationsV2')
BEGIN
    CREATE TABLE [Locations] (
        [LocationId] int NOT NULL,
        [LocationName] nvarchar(max) NULL,
        [LocationAlias] nvarchar(max) NULL,
        [LocationType] int NOT NULL,
        [LocationPhone] nvarchar(max) NULL,
        [LoadedOn] datetime2 NULL,
        CONSTRAINT [PK_Locations] PRIMARY KEY ([LocationId])
    );
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20190920195036_OperationsV2')
BEGIN
    CREATE TABLE [UnitLocations] (
        [UnitLocationId] int NOT NULL IDENTITY,
        [UnitId] int NOT NULL,
        [LocationId] int NOT NULL,
        [IsClean] bit NULL,
        [IsDirty] bit NULL,
        [Active] bit NULL,
        [AddedOn] datetime2 NULL,
        [EditedOn] datetime2 NULL,
        [AddedBy] nvarchar(max) NULL,
        [EditedBy] nvarchar(max) NULL,
        CONSTRAINT [PK_UnitLocations] PRIMARY KEY ([UnitLocationId])
    );
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20190920195036_OperationsV2')
BEGIN
    insert into unitlocations ([UnitId] ,[LocationId],[IsClean],[IsDirty],[Active],[AddedOn],[EditedOn],[AddedBy],[EditedBy]) select[UnitId],[ReceiverId],[IsClean],[IsDirty],[Active],[AddedOn],[EditedOn],[AddedBy],[EditedBy]from subunits
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20190920195036_OperationsV2')
BEGIN
    INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
    VALUES (N'20190920195036_OperationsV2', N'3.1.1');
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20191022202156_OperationV3')
BEGIN
    ALTER TABLE [Units] ADD [ParentUnitId] int NULL;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20191022202156_OperationV3')
BEGIN
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'UnitId', N'UnitName', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy', N'ParentUnitId') AND [object_id] = OBJECT_ID(N'[Units]'))
        SET IDENTITY_INSERT [Units] ON;
    INSERT INTO [Units] ([UnitId], [UnitName], [Active], [AddedOn], [EditedOn], [AddedBy], [EditedBy], [ParentUnitId])
    VALUES (0, N'All', CAST(1 AS bit), '2020-01-29T11:39:12.2846567-05:00', '2020-01-29T11:39:12.2846628-05:00', N'Midmark RTLS System', N'Midmark RTLS System', NULL);
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'UnitId', N'UnitName', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy', N'ParentUnitId') AND [object_id] = OBJECT_ID(N'[Units]'))
        SET IDENTITY_INSERT [Units] OFF;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20191022202156_OperationV3')
BEGIN
    update units set parentunitid = 0 where unitId != 0
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20191022202156_OperationV3')
BEGIN
    INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
    VALUES (N'20191022202156_OperationV3', N'3.1.1');
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20191024130932_OperationsV4')
BEGIN

                    create procedure UnitNode as

              WITH

              sortedUnits(UnitId, ParentUnitId, UnitName, Active, AddedOn, EditedOn, AddedBy, EditedBy) as
              (
              select top 2147483647 unitId, ParentUnitId, UnitName, active,AddedOn, EditedOn, AddedBy, EditedBy
              from units
    	        where active != 0
              order by unitName
              ),

              ct(UnitId, ParentUnitId, TopLevel, UnitName, Active, Node, AddedOn, EditedOn, AddedBy, EditedBy) as
              (
                 SELECT unitId, ParentUnitId, 0 as toplevel, unitName, Active, convert(varchar(max), '/1/') as Node, 
                  AddedOn, EditedOn, AddedBy, EditedBy
                 FROM sortedUnits
                 WHERE ParentUnitId is null 

                 UNION ALL

                 SELECT c2.unitId, c2.ParentUnitId, ct.toplevel + 1, c2.unitName, c2.Active,
                      node  + convert(varchar(max), right('0000' + cast(right(row_number() over(order by ct.unitId), 10) as varchar(4)), 4)) + '/' as Node,
                      c2.AddedOn, c2.EditedOn, c2.AddedBy, c2.EditedBy
                 FROM sortedUnits c2
                 INNER JOIN ct ON c2.ParentUnitId = ct.unitId
              ) 
              select
    		      UnitId, ParentUnitId, TopLevel as Level, Node, UnitName, Active, AddedOn, EditedOn, AddedBy, EditedBy
    		      from ct
              order by node
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20191024130932_OperationsV4')
BEGIN
    INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
    VALUES (N'20191024130932_OperationsV4', N'3.1.1');
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20191104163218_OperationsV5')
BEGIN
    ALTER TABLE [ThresholdholdTypes] DROP CONSTRAINT [PK_ThresholdholdTypes];
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20191104163218_OperationsV5')
BEGIN
    EXEC sp_rename N'[ThresholdholdTypes]', N'ThresholdTypes';
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20191104163218_OperationsV5')
BEGIN
    ALTER TABLE [ThresholdTypes] ADD CONSTRAINT [PK_ThresholdTypes] PRIMARY KEY ([ThresholdTypeId]);
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20191104163218_OperationsV5')
BEGIN
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdTypeId', N'Description', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[ThresholdTypes]'))
        SET IDENTITY_INSERT [ThresholdTypes] ON;
    INSERT INTO [ThresholdTypes] ([ThresholdTypeId], [Description], [Active], [AddedOn], [EditedOn], [AddedBy], [EditedBy])
    VALUES (1, N'Critical Low', CAST(1 AS bit), '2020-01-29T11:39:12.3338719-05:00', '2020-01-29T11:39:12.3338789-05:00', N'Midmark RTLS System', N'Midmark RTLS System');
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdTypeId', N'Description', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[ThresholdTypes]'))
        SET IDENTITY_INSERT [ThresholdTypes] OFF;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20191104163218_OperationsV5')
BEGIN
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdTypeId', N'Description', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[ThresholdTypes]'))
        SET IDENTITY_INSERT [ThresholdTypes] ON;
    INSERT INTO [ThresholdTypes] ([ThresholdTypeId], [Description], [Active], [AddedOn], [EditedOn], [AddedBy], [EditedBy])
    VALUES (2, N'Low', CAST(1 AS bit), '2020-01-29T11:39:12.3338821-05:00', '2020-01-29T11:39:12.3338824-05:00', N'Midmark RTLS System', N'Midmark RTLS System');
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdTypeId', N'Description', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[ThresholdTypes]'))
        SET IDENTITY_INSERT [ThresholdTypes] OFF;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20191104163218_OperationsV5')
BEGIN
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdTypeId', N'Description', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[ThresholdTypes]'))
        SET IDENTITY_INSERT [ThresholdTypes] ON;
    INSERT INTO [ThresholdTypes] ([ThresholdTypeId], [Description], [Active], [AddedOn], [EditedOn], [AddedBy], [EditedBy])
    VALUES (3, N'High', CAST(1 AS bit), '2020-01-29T11:39:12.3338839-05:00', '2020-01-29T11:39:12.3338843-05:00', N'Midmark RTLS System', N'Midmark RTLS System');
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdTypeId', N'Description', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[ThresholdTypes]'))
        SET IDENTITY_INSERT [ThresholdTypes] OFF;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20191104163218_OperationsV5')
BEGIN
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdId', N'UnitId', N'AssetTypeId', N'Limit', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Thresholds]'))
        SET IDENTITY_INSERT [Thresholds] ON;
    INSERT INTO [Thresholds] ([ThresholdId], [UnitId], [AssetTypeId], [Limit], [ThresholdTypeId], [Active], [AddedOn], [EditedOn], [AddedBy], [EditedBy])
    VALUES (1, 1, 1, 3, 1, CAST(1 AS bit), '2020-01-29T11:39:12.3338853-05:00', '2020-01-29T11:39:12.3338856-05:00', N'Midmark RTLS System', N'Midmark RTLS System');
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdId', N'UnitId', N'AssetTypeId', N'Limit', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Thresholds]'))
        SET IDENTITY_INSERT [Thresholds] OFF;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20191104163218_OperationsV5')
BEGIN
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdId', N'UnitId', N'AssetTypeId', N'Limit', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Thresholds]'))
        SET IDENTITY_INSERT [Thresholds] ON;
    INSERT INTO [Thresholds] ([ThresholdId], [UnitId], [AssetTypeId], [Limit], [ThresholdTypeId], [Active], [AddedOn], [EditedOn], [AddedBy], [EditedBy])
    VALUES (2, 1, 1, 6, 2, CAST(1 AS bit), '2020-01-29T11:39:12.3338936-05:00', '2020-01-29T11:39:12.3338940-05:00', N'Midmark RTLS System', N'Midmark RTLS System');
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdId', N'UnitId', N'AssetTypeId', N'Limit', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Thresholds]'))
        SET IDENTITY_INSERT [Thresholds] OFF;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20191104163218_OperationsV5')
BEGIN
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdId', N'UnitId', N'AssetTypeId', N'Limit', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Thresholds]'))
        SET IDENTITY_INSERT [Thresholds] ON;
    INSERT INTO [Thresholds] ([ThresholdId], [UnitId], [AssetTypeId], [Limit], [ThresholdTypeId], [Active], [AddedOn], [EditedOn], [AddedBy], [EditedBy])
    VALUES (3, 1, 1, 12, 3, CAST(1 AS bit), '2020-01-29T11:39:12.3338949-05:00', '2020-01-29T11:39:12.3338952-05:00', N'Midmark RTLS System', N'Midmark RTLS System');
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdId', N'UnitId', N'AssetTypeId', N'Limit', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Thresholds]'))
        SET IDENTITY_INSERT [Thresholds] OFF;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20191104163218_OperationsV5')
BEGIN
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdId', N'UnitId', N'AssetTypeId', N'Limit', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Thresholds]'))
        SET IDENTITY_INSERT [Thresholds] ON;
    INSERT INTO [Thresholds] ([ThresholdId], [UnitId], [AssetTypeId], [Limit], [ThresholdTypeId], [Active], [AddedOn], [EditedOn], [AddedBy], [EditedBy])
    VALUES (4, 1, 2, 3, 1, CAST(1 AS bit), '2020-01-29T11:39:12.3338963-05:00', '2020-01-29T11:39:12.3338965-05:00', N'Midmark RTLS System', N'Midmark RTLS System');
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdId', N'UnitId', N'AssetTypeId', N'Limit', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Thresholds]'))
        SET IDENTITY_INSERT [Thresholds] OFF;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20191104163218_OperationsV5')
BEGIN
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdId', N'UnitId', N'AssetTypeId', N'Limit', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Thresholds]'))
        SET IDENTITY_INSERT [Thresholds] ON;
    INSERT INTO [Thresholds] ([ThresholdId], [UnitId], [AssetTypeId], [Limit], [ThresholdTypeId], [Active], [AddedOn], [EditedOn], [AddedBy], [EditedBy])
    VALUES (5, 1, 2, 6, 2, CAST(1 AS bit), '2020-01-29T11:39:12.3338975-05:00', '2020-01-29T11:39:12.3338978-05:00', N'Midmark RTLS System', N'Midmark RTLS System');
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdId', N'UnitId', N'AssetTypeId', N'Limit', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Thresholds]'))
        SET IDENTITY_INSERT [Thresholds] OFF;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20191104163218_OperationsV5')
BEGIN
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdId', N'UnitId', N'AssetTypeId', N'Limit', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Thresholds]'))
        SET IDENTITY_INSERT [Thresholds] ON;
    INSERT INTO [Thresholds] ([ThresholdId], [UnitId], [AssetTypeId], [Limit], [ThresholdTypeId], [Active], [AddedOn], [EditedOn], [AddedBy], [EditedBy])
    VALUES (6, 1, 2, 12, 3, CAST(1 AS bit), '2020-01-29T11:39:12.3338987-05:00', '2020-01-29T11:39:12.3338990-05:00', N'Midmark RTLS System', N'Midmark RTLS System');
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdId', N'UnitId', N'AssetTypeId', N'Limit', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Thresholds]'))
        SET IDENTITY_INSERT [Thresholds] OFF;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20191104163218_OperationsV5')
BEGIN
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdId', N'UnitId', N'AssetTypeId', N'Limit', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Thresholds]'))
        SET IDENTITY_INSERT [Thresholds] ON;
    INSERT INTO [Thresholds] ([ThresholdId], [UnitId], [AssetTypeId], [Limit], [ThresholdTypeId], [Active], [AddedOn], [EditedOn], [AddedBy], [EditedBy])
    VALUES (7, 1, 3, 3, 1, CAST(1 AS bit), '2020-01-29T11:39:12.3339000-05:00', '2020-01-29T11:39:12.3339003-05:00', N'Midmark RTLS System', N'Midmark RTLS System');
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdId', N'UnitId', N'AssetTypeId', N'Limit', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Thresholds]'))
        SET IDENTITY_INSERT [Thresholds] OFF;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20191104163218_OperationsV5')
BEGIN
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdId', N'UnitId', N'AssetTypeId', N'Limit', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Thresholds]'))
        SET IDENTITY_INSERT [Thresholds] ON;
    INSERT INTO [Thresholds] ([ThresholdId], [UnitId], [AssetTypeId], [Limit], [ThresholdTypeId], [Active], [AddedOn], [EditedOn], [AddedBy], [EditedBy])
    VALUES (8, 1, 3, 6, 2, CAST(1 AS bit), '2020-01-29T11:39:12.3339012-05:00', '2020-01-29T11:39:12.3339015-05:00', N'Midmark RTLS System', N'Midmark RTLS System');
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdId', N'UnitId', N'AssetTypeId', N'Limit', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Thresholds]'))
        SET IDENTITY_INSERT [Thresholds] OFF;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20191104163218_OperationsV5')
BEGIN
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdId', N'UnitId', N'AssetTypeId', N'Limit', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Thresholds]'))
        SET IDENTITY_INSERT [Thresholds] ON;
    INSERT INTO [Thresholds] ([ThresholdId], [UnitId], [AssetTypeId], [Limit], [ThresholdTypeId], [Active], [AddedOn], [EditedOn], [AddedBy], [EditedBy])
    VALUES (9, 1, 3, 12, 3, CAST(1 AS bit), '2020-01-29T11:39:12.3339024-05:00', '2020-01-29T11:39:12.3339027-05:00', N'Midmark RTLS System', N'Midmark RTLS System');
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdId', N'UnitId', N'AssetTypeId', N'Limit', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Thresholds]'))
        SET IDENTITY_INSERT [Thresholds] OFF;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20191104163218_OperationsV5')
BEGIN
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdId', N'UnitId', N'AssetTypeId', N'Limit', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Thresholds]'))
        SET IDENTITY_INSERT [Thresholds] ON;
    INSERT INTO [Thresholds] ([ThresholdId], [UnitId], [AssetTypeId], [Limit], [ThresholdTypeId], [Active], [AddedOn], [EditedOn], [AddedBy], [EditedBy])
    VALUES (10, 1, 4, 3, 1, CAST(1 AS bit), '2020-01-29T11:39:12.3339036-05:00', '2020-01-29T11:39:12.3339038-05:00', N'Midmark RTLS System', N'Midmark RTLS System');
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdId', N'UnitId', N'AssetTypeId', N'Limit', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Thresholds]'))
        SET IDENTITY_INSERT [Thresholds] OFF;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20191104163218_OperationsV5')
BEGIN
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdId', N'UnitId', N'AssetTypeId', N'Limit', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Thresholds]'))
        SET IDENTITY_INSERT [Thresholds] ON;
    INSERT INTO [Thresholds] ([ThresholdId], [UnitId], [AssetTypeId], [Limit], [ThresholdTypeId], [Active], [AddedOn], [EditedOn], [AddedBy], [EditedBy])
    VALUES (11, 1, 4, 6, 2, CAST(1 AS bit), '2020-01-29T11:39:12.3339047-05:00', '2020-01-29T11:39:12.3339050-05:00', N'Midmark RTLS System', N'Midmark RTLS System');
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdId', N'UnitId', N'AssetTypeId', N'Limit', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Thresholds]'))
        SET IDENTITY_INSERT [Thresholds] OFF;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20191104163218_OperationsV5')
BEGIN
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdId', N'UnitId', N'AssetTypeId', N'Limit', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Thresholds]'))
        SET IDENTITY_INSERT [Thresholds] ON;
    INSERT INTO [Thresholds] ([ThresholdId], [UnitId], [AssetTypeId], [Limit], [ThresholdTypeId], [Active], [AddedOn], [EditedOn], [AddedBy], [EditedBy])
    VALUES (12, 1, 4, 12, 3, CAST(1 AS bit), '2020-01-29T11:39:12.3339060-05:00', '2020-01-29T11:39:12.3339063-05:00', N'Midmark RTLS System', N'Midmark RTLS System');
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdId', N'UnitId', N'AssetTypeId', N'Limit', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Thresholds]'))
        SET IDENTITY_INSERT [Thresholds] OFF;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20191104163218_OperationsV5')
BEGIN
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdId', N'UnitId', N'AssetTypeId', N'Limit', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Thresholds]'))
        SET IDENTITY_INSERT [Thresholds] ON;
    INSERT INTO [Thresholds] ([ThresholdId], [UnitId], [AssetTypeId], [Limit], [ThresholdTypeId], [Active], [AddedOn], [EditedOn], [AddedBy], [EditedBy])
    VALUES (13, 1, 5, 3, 1, CAST(1 AS bit), '2020-01-29T11:39:12.3339073-05:00', '2020-01-29T11:39:12.3339076-05:00', N'Midmark RTLS System', N'Midmark RTLS System');
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdId', N'UnitId', N'AssetTypeId', N'Limit', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Thresholds]'))
        SET IDENTITY_INSERT [Thresholds] OFF;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20191104163218_OperationsV5')
BEGIN
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdId', N'UnitId', N'AssetTypeId', N'Limit', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Thresholds]'))
        SET IDENTITY_INSERT [Thresholds] ON;
    INSERT INTO [Thresholds] ([ThresholdId], [UnitId], [AssetTypeId], [Limit], [ThresholdTypeId], [Active], [AddedOn], [EditedOn], [AddedBy], [EditedBy])
    VALUES (14, 1, 5, 6, 2, CAST(1 AS bit), '2020-01-29T11:39:12.3339085-05:00', '2020-01-29T11:39:12.3339088-05:00', N'Midmark RTLS System', N'Midmark RTLS System');
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdId', N'UnitId', N'AssetTypeId', N'Limit', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Thresholds]'))
        SET IDENTITY_INSERT [Thresholds] OFF;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20191104163218_OperationsV5')
BEGIN
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdId', N'UnitId', N'AssetTypeId', N'Limit', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Thresholds]'))
        SET IDENTITY_INSERT [Thresholds] ON;
    INSERT INTO [Thresholds] ([ThresholdId], [UnitId], [AssetTypeId], [Limit], [ThresholdTypeId], [Active], [AddedOn], [EditedOn], [AddedBy], [EditedBy])
    VALUES (15, 1, 5, 12, 3, CAST(1 AS bit), '2020-01-29T11:39:12.3339149-05:00', '2020-01-29T11:39:12.3339152-05:00', N'Midmark RTLS System', N'Midmark RTLS System');
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdId', N'UnitId', N'AssetTypeId', N'Limit', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Thresholds]'))
        SET IDENTITY_INSERT [Thresholds] OFF;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20191104163218_OperationsV5')
BEGIN
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdId', N'UnitId', N'AssetTypeId', N'Limit', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Thresholds]'))
        SET IDENTITY_INSERT [Thresholds] ON;
    INSERT INTO [Thresholds] ([ThresholdId], [UnitId], [AssetTypeId], [Limit], [ThresholdTypeId], [Active], [AddedOn], [EditedOn], [AddedBy], [EditedBy])
    VALUES (16, 2, 1, 3, 1, CAST(1 AS bit), '2020-01-29T11:39:12.3339161-05:00', '2020-01-29T11:39:12.3339164-05:00', N'Midmark RTLS System', N'Midmark RTLS System');
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdId', N'UnitId', N'AssetTypeId', N'Limit', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Thresholds]'))
        SET IDENTITY_INSERT [Thresholds] OFF;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20191104163218_OperationsV5')
BEGIN
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdId', N'UnitId', N'AssetTypeId', N'Limit', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Thresholds]'))
        SET IDENTITY_INSERT [Thresholds] ON;
    INSERT INTO [Thresholds] ([ThresholdId], [UnitId], [AssetTypeId], [Limit], [ThresholdTypeId], [Active], [AddedOn], [EditedOn], [AddedBy], [EditedBy])
    VALUES (17, 2, 1, 6, 2, CAST(1 AS bit), '2020-01-29T11:39:12.3339176-05:00', '2020-01-29T11:39:12.3339179-05:00', N'Midmark RTLS System', N'Midmark RTLS System');
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdId', N'UnitId', N'AssetTypeId', N'Limit', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Thresholds]'))
        SET IDENTITY_INSERT [Thresholds] OFF;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20191104163218_OperationsV5')
BEGIN
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdId', N'UnitId', N'AssetTypeId', N'Limit', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Thresholds]'))
        SET IDENTITY_INSERT [Thresholds] ON;
    INSERT INTO [Thresholds] ([ThresholdId], [UnitId], [AssetTypeId], [Limit], [ThresholdTypeId], [Active], [AddedOn], [EditedOn], [AddedBy], [EditedBy])
    VALUES (18, 2, 1, 12, 3, CAST(1 AS bit), '2020-01-29T11:39:12.3339187-05:00', '2020-01-29T11:39:12.3339190-05:00', N'Midmark RTLS System', N'Midmark RTLS System');
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdId', N'UnitId', N'AssetTypeId', N'Limit', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Thresholds]'))
        SET IDENTITY_INSERT [Thresholds] OFF;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20191104163218_OperationsV5')
BEGIN
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdId', N'UnitId', N'AssetTypeId', N'Limit', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Thresholds]'))
        SET IDENTITY_INSERT [Thresholds] ON;
    INSERT INTO [Thresholds] ([ThresholdId], [UnitId], [AssetTypeId], [Limit], [ThresholdTypeId], [Active], [AddedOn], [EditedOn], [AddedBy], [EditedBy])
    VALUES (19, 2, 2, 3, 1, CAST(1 AS bit), '2020-01-29T11:39:12.3339199-05:00', '2020-01-29T11:39:12.3339202-05:00', N'Midmark RTLS System', N'Midmark RTLS System');
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdId', N'UnitId', N'AssetTypeId', N'Limit', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Thresholds]'))
        SET IDENTITY_INSERT [Thresholds] OFF;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20191104163218_OperationsV5')
BEGIN
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdId', N'UnitId', N'AssetTypeId', N'Limit', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Thresholds]'))
        SET IDENTITY_INSERT [Thresholds] ON;
    INSERT INTO [Thresholds] ([ThresholdId], [UnitId], [AssetTypeId], [Limit], [ThresholdTypeId], [Active], [AddedOn], [EditedOn], [AddedBy], [EditedBy])
    VALUES (20, 2, 2, 6, 2, CAST(1 AS bit), '2020-01-29T11:39:12.3339211-05:00', '2020-01-29T11:39:12.3339213-05:00', N'Midmark RTLS System', N'Midmark RTLS System');
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdId', N'UnitId', N'AssetTypeId', N'Limit', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Thresholds]'))
        SET IDENTITY_INSERT [Thresholds] OFF;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20191104163218_OperationsV5')
BEGIN
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdId', N'UnitId', N'AssetTypeId', N'Limit', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Thresholds]'))
        SET IDENTITY_INSERT [Thresholds] ON;
    INSERT INTO [Thresholds] ([ThresholdId], [UnitId], [AssetTypeId], [Limit], [ThresholdTypeId], [Active], [AddedOn], [EditedOn], [AddedBy], [EditedBy])
    VALUES (21, 2, 2, 12, 3, CAST(1 AS bit), '2020-01-29T11:39:12.3339222-05:00', '2020-01-29T11:39:12.3339225-05:00', N'Midmark RTLS System', N'Midmark RTLS System');
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdId', N'UnitId', N'AssetTypeId', N'Limit', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Thresholds]'))
        SET IDENTITY_INSERT [Thresholds] OFF;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20191104163218_OperationsV5')
BEGIN
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdId', N'UnitId', N'AssetTypeId', N'Limit', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Thresholds]'))
        SET IDENTITY_INSERT [Thresholds] ON;
    INSERT INTO [Thresholds] ([ThresholdId], [UnitId], [AssetTypeId], [Limit], [ThresholdTypeId], [Active], [AddedOn], [EditedOn], [AddedBy], [EditedBy])
    VALUES (22, 2, 3, 3, 1, CAST(1 AS bit), '2020-01-29T11:39:12.3339234-05:00', '2020-01-29T11:39:12.3339237-05:00', N'Midmark RTLS System', N'Midmark RTLS System');
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdId', N'UnitId', N'AssetTypeId', N'Limit', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Thresholds]'))
        SET IDENTITY_INSERT [Thresholds] OFF;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20191104163218_OperationsV5')
BEGIN
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdId', N'UnitId', N'AssetTypeId', N'Limit', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Thresholds]'))
        SET IDENTITY_INSERT [Thresholds] ON;
    INSERT INTO [Thresholds] ([ThresholdId], [UnitId], [AssetTypeId], [Limit], [ThresholdTypeId], [Active], [AddedOn], [EditedOn], [AddedBy], [EditedBy])
    VALUES (23, 2, 3, 6, 2, CAST(1 AS bit), '2020-01-29T11:39:12.3339245-05:00', '2020-01-29T11:39:12.3339248-05:00', N'Midmark RTLS System', N'Midmark RTLS System');
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdId', N'UnitId', N'AssetTypeId', N'Limit', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Thresholds]'))
        SET IDENTITY_INSERT [Thresholds] OFF;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20191104163218_OperationsV5')
BEGIN
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdId', N'UnitId', N'AssetTypeId', N'Limit', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Thresholds]'))
        SET IDENTITY_INSERT [Thresholds] ON;
    INSERT INTO [Thresholds] ([ThresholdId], [UnitId], [AssetTypeId], [Limit], [ThresholdTypeId], [Active], [AddedOn], [EditedOn], [AddedBy], [EditedBy])
    VALUES (24, 2, 3, 12, 3, CAST(1 AS bit), '2020-01-29T11:39:12.3339257-05:00', '2020-01-29T11:39:12.3339260-05:00', N'Midmark RTLS System', N'Midmark RTLS System');
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdId', N'UnitId', N'AssetTypeId', N'Limit', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Thresholds]'))
        SET IDENTITY_INSERT [Thresholds] OFF;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20191104163218_OperationsV5')
BEGIN
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdId', N'UnitId', N'AssetTypeId', N'Limit', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Thresholds]'))
        SET IDENTITY_INSERT [Thresholds] ON;
    INSERT INTO [Thresholds] ([ThresholdId], [UnitId], [AssetTypeId], [Limit], [ThresholdTypeId], [Active], [AddedOn], [EditedOn], [AddedBy], [EditedBy])
    VALUES (25, 2, 4, 3, 1, CAST(1 AS bit), '2020-01-29T11:39:12.3339268-05:00', '2020-01-29T11:39:12.3339271-05:00', N'Midmark RTLS System', N'Midmark RTLS System');
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdId', N'UnitId', N'AssetTypeId', N'Limit', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Thresholds]'))
        SET IDENTITY_INSERT [Thresholds] OFF;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20191104163218_OperationsV5')
BEGIN
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdId', N'UnitId', N'AssetTypeId', N'Limit', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Thresholds]'))
        SET IDENTITY_INSERT [Thresholds] ON;
    INSERT INTO [Thresholds] ([ThresholdId], [UnitId], [AssetTypeId], [Limit], [ThresholdTypeId], [Active], [AddedOn], [EditedOn], [AddedBy], [EditedBy])
    VALUES (26, 2, 4, 6, 2, CAST(1 AS bit), '2020-01-29T11:39:12.3339280-05:00', '2020-01-29T11:39:12.3339283-05:00', N'Midmark RTLS System', N'Midmark RTLS System');
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdId', N'UnitId', N'AssetTypeId', N'Limit', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Thresholds]'))
        SET IDENTITY_INSERT [Thresholds] OFF;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20191104163218_OperationsV5')
BEGIN
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdId', N'UnitId', N'AssetTypeId', N'Limit', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Thresholds]'))
        SET IDENTITY_INSERT [Thresholds] ON;
    INSERT INTO [Thresholds] ([ThresholdId], [UnitId], [AssetTypeId], [Limit], [ThresholdTypeId], [Active], [AddedOn], [EditedOn], [AddedBy], [EditedBy])
    VALUES (27, 2, 4, 12, 3, CAST(1 AS bit), '2020-01-29T11:39:12.3339291-05:00', '2020-01-29T11:39:12.3339294-05:00', N'Midmark RTLS System', N'Midmark RTLS System');
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdId', N'UnitId', N'AssetTypeId', N'Limit', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Thresholds]'))
        SET IDENTITY_INSERT [Thresholds] OFF;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20191104163218_OperationsV5')
BEGIN
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdId', N'UnitId', N'AssetTypeId', N'Limit', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Thresholds]'))
        SET IDENTITY_INSERT [Thresholds] ON;
    INSERT INTO [Thresholds] ([ThresholdId], [UnitId], [AssetTypeId], [Limit], [ThresholdTypeId], [Active], [AddedOn], [EditedOn], [AddedBy], [EditedBy])
    VALUES (28, 2, 5, 3, 1, CAST(1 AS bit), '2020-01-29T11:39:12.3339355-05:00', '2020-01-29T11:39:12.3339358-05:00', N'Midmark RTLS System', N'Midmark RTLS System');
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdId', N'UnitId', N'AssetTypeId', N'Limit', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Thresholds]'))
        SET IDENTITY_INSERT [Thresholds] OFF;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20191104163218_OperationsV5')
BEGIN
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdId', N'UnitId', N'AssetTypeId', N'Limit', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Thresholds]'))
        SET IDENTITY_INSERT [Thresholds] ON;
    INSERT INTO [Thresholds] ([ThresholdId], [UnitId], [AssetTypeId], [Limit], [ThresholdTypeId], [Active], [AddedOn], [EditedOn], [AddedBy], [EditedBy])
    VALUES (29, 2, 5, 6, 2, CAST(1 AS bit), '2020-01-29T11:39:12.3339367-05:00', '2020-01-29T11:39:12.3339370-05:00', N'Midmark RTLS System', N'Midmark RTLS System');
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdId', N'UnitId', N'AssetTypeId', N'Limit', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Thresholds]'))
        SET IDENTITY_INSERT [Thresholds] OFF;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20191104163218_OperationsV5')
BEGIN
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdId', N'UnitId', N'AssetTypeId', N'Limit', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Thresholds]'))
        SET IDENTITY_INSERT [Thresholds] ON;
    INSERT INTO [Thresholds] ([ThresholdId], [UnitId], [AssetTypeId], [Limit], [ThresholdTypeId], [Active], [AddedOn], [EditedOn], [AddedBy], [EditedBy])
    VALUES (30, 2, 5, 12, 3, CAST(1 AS bit), '2020-01-29T11:39:12.3339378-05:00', '2020-01-29T11:39:12.3339381-05:00', N'Midmark RTLS System', N'Midmark RTLS System');
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdId', N'UnitId', N'AssetTypeId', N'Limit', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[Thresholds]'))
        SET IDENTITY_INSERT [Thresholds] OFF;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20191104163218_OperationsV5')
BEGIN

              create procedure UnitLimits @unitId int
              as
              begin
              with at_thresholds
              as
              (select at.assetTypeId,
                clt.thresholdid as CriticalLowThresholdId, clt.limit as CriticalLowThresholdLimit, 
                lt.thresholdid as LowThresholdId, lt.limit as LowThresholdLimit, 
                ht.thresholdid as HighThresholdId, ht.limit as HighThresholdLimit
              from assettypes at
              left join thresholds clt on at.assettypeid = clt.assettypeid
              left join thresholds lt on at.assettypeid = lt.assettypeid
              left join thresholds ht on at.assettypeid = ht.assettypeid
              where clt.thresholdtypeid = 1 and clt.unitId = @unitId
                and lt.thresholdtypeid = 2 and lt.unitId = @unitId
                and ht.thresholdtypeid = 3 and ht.unitId = @unitId
              ) 
              select at.AssetTypeId, at.Description, at.BadgeTypeId, at.Active, at.AddedOn, 
    		        at.EditedOn, at.AddedBy, at.EditedBy,  
    		        t.CriticalLowThresholdId, t.CriticalLowThresholdLimit,
    		        t.LowThresholdId, t.LowThresholdLimit,
    		        t.HighThresholdId,HighThresholdLimit
    		      from AssetTypes as at
              left join at_thresholds as t on t.assetTypeId = at.assetTypeId
              where active = 1
              order by at.Description
              end                 
              
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20191104163218_OperationsV5')
BEGIN
    INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
    VALUES (N'20191104163218_OperationsV5', N'3.1.1');
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20191105143707_OperationsV6')
BEGIN
    INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
    VALUES (N'20191105143707_OperationsV6', N'3.1.1');
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20191118205510_OperationsV7')
BEGIN

              create procedure [dbo].[UnitNodeFromParent] @parentUnitId int as
    			    begin 

    			with

              sortedUnits(UnitId, ParentUnitId, UnitName, Active, AddedOn, EditedOn, AddedBy, EditedBy) as
              (
              select top 2147483647 unitId, ParentUnitId, UnitName, active,AddedOn, EditedOn, AddedBy, EditedBy
              from units
    	        where active != 0
              order by unitName
              ),

              ct(UnitId, ParentUnitId, TopLevel, UnitName, Active, Node, AddedOn, EditedOn, AddedBy, EditedBy) as
              (
                 SELECT unitId, ParentUnitId, 0 as toplevel, unitName, Active, convert(varchar(max), '/1/') as Node, 
                  AddedOn, EditedOn, AddedBy, EditedBy
                 FROM sortedUnits
                 WHERE ParentUnitId = @parentUnitId 

                 UNION ALL

                 SELECT c2.unitId, c2.ParentUnitId, ct.toplevel + 1, c2.unitName, c2.Active,
                      node  + convert(varchar(max), right('0000' + cast(right(row_number() over(order by ct.unitId), 10) as varchar(4)), 4)) + '/' as Node,
                      c2.AddedOn, c2.EditedOn, c2.AddedBy, c2.EditedBy
                 FROM sortedUnits c2
                 INNER JOIN ct ON c2.ParentUnitId = ct.unitId
              ) 
              select
    		      UnitId, ParentUnitId, TopLevel as Level, Node, UnitName, Active, AddedOn, EditedOn, AddedBy, EditedBy
    		      from ct
              order by node

        		  end                
              
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20191118205510_OperationsV7')
BEGIN
    INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
    VALUES (N'20191118205510_OperationsV7', N'3.1.1');
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20200108192123_OperationsV8')
BEGIN
    DROP TABLE [NotificationDetails];
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20200108192123_OperationsV8')
BEGIN
    DROP TABLE [Notifications];
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20200108192123_OperationsV8')
BEGIN
    DROP TABLE [NotificationTypes];
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20200108192123_OperationsV8')
BEGIN
    DROP TABLE [PLEventDetails];
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20200108192123_OperationsV8')
BEGIN
    DROP TABLE [PLEventDetailTypes];
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20200108192123_OperationsV8')
BEGIN
    DECLARE @var0 sysname;
    SELECT @var0 = [d].[name]
    FROM [sys].[default_constraints] [d]
    INNER JOIN [sys].[columns] [c] ON [d].[parent_column_id] = [c].[column_id] AND [d].[parent_object_id] = [c].[object_id]
    WHERE ([d].[parent_object_id] = OBJECT_ID(N'[PLEventTypes]') AND [c].[name] = N'Color');
    IF @var0 IS NOT NULL EXEC(N'ALTER TABLE [PLEventTypes] DROP CONSTRAINT [' + @var0 + '];');
    ALTER TABLE [PLEventTypes] DROP COLUMN [Color];
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20200108192123_OperationsV8')
BEGIN
    DECLARE @var1 sysname;
    SELECT @var1 = [d].[name]
    FROM [sys].[default_constraints] [d]
    INNER JOIN [sys].[columns] [c] ON [d].[parent_column_id] = [c].[column_id] AND [d].[parent_object_id] = [c].[object_id]
    WHERE ([d].[parent_object_id] = OBJECT_ID(N'[PLEventTypes]') AND [c].[name] = N'NotificationEnabled');
    IF @var1 IS NOT NULL EXEC(N'ALTER TABLE [PLEventTypes] DROP CONSTRAINT [' + @var1 + '];');
    ALTER TABLE [PLEventTypes] DROP COLUMN [NotificationEnabled];
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20200108192123_OperationsV8')
BEGIN
    DECLARE @var2 sysname;
    SELECT @var2 = [d].[name]
    FROM [sys].[default_constraints] [d]
    INNER JOIN [sys].[columns] [c] ON [d].[parent_column_id] = [c].[column_id] AND [d].[parent_object_id] = [c].[object_id]
    WHERE ([d].[parent_object_id] = OBJECT_ID(N'[PLEvents]') AND [c].[name] = N'EventTypeId');
    IF @var2 IS NOT NULL EXEC(N'ALTER TABLE [PLEvents] DROP CONSTRAINT [' + @var2 + '];');
    ALTER TABLE [PLEvents] DROP COLUMN [EventTypeId];
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20200108192123_OperationsV8')
BEGIN
    ALTER TABLE [ThresholdTypes] ADD [Color] nvarchar(max) NULL;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20200108192123_OperationsV8')
BEGIN
    ALTER TABLE [ThresholdTypes] ADD [ShortDescription] nvarchar(max) NULL;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20200108192123_OperationsV8')
BEGIN
    ALTER TABLE [Thresholds] ADD [ThresholdAreaId] int NOT NULL DEFAULT 0;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20200108192123_OperationsV8')
BEGIN
    DECLARE @var3 sysname;
    SELECT @var3 = [d].[name]
    FROM [sys].[default_constraints] [d]
    INNER JOIN [sys].[columns] [c] ON [d].[parent_column_id] = [c].[column_id] AND [d].[parent_object_id] = [c].[object_id]
    WHERE ([d].[parent_object_id] = OBJECT_ID(N'[PLEventTypes]') AND [c].[name] = N'Description');
    IF @var3 IS NOT NULL EXEC(N'ALTER TABLE [PLEventTypes] DROP CONSTRAINT [' + @var3 + '];');
    ALTER TABLE [PLEventTypes] ALTER COLUMN [Description] nvarchar(max) NULL;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20200108192123_OperationsV8')
BEGIN
    ALTER TABLE [PLEventTypes] ADD [ShortDescription] nvarchar(max) NULL;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20200108192123_OperationsV8')
BEGIN
    ALTER TABLE [PLEventTypes] ADD [ThresholdTypeId] int NULL;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20200108192123_OperationsV8')
BEGIN
    ALTER TABLE [PLEvents] ADD [AssetTypeId] int NOT NULL DEFAULT 0;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20200108192123_OperationsV8')
BEGIN
    ALTER TABLE [PLEvents] ADD [Count] int NOT NULL DEFAULT 0;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20200108192123_OperationsV8')
BEGIN
    ALTER TABLE [PLEvents] ADD [PLEventTypeId] int NOT NULL DEFAULT 0;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20200108192123_OperationsV8')
BEGIN
    ALTER TABLE [PLEvents] ADD [UnitId] int NOT NULL DEFAULT 0;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20200108192123_OperationsV8')
BEGIN
    CREATE TABLE [NotificationGroupMembers] (
        [NotificationGroupMemberId] int NOT NULL IDENTITY,
        [NotificationMemberTypeId] int NOT NULL,
        [Identifier] nvarchar(max) NOT NULL,
        [EscalationMinutes] int NULL,
        [Active] bit NULL,
        [AddedOn] datetime2 NULL,
        [EditedOn] datetime2 NULL,
        [AddedBy] nvarchar(max) NULL,
        [EditedBy] nvarchar(max) NULL,
        CONSTRAINT [PK_NotificationGroupMembers] PRIMARY KEY ([NotificationGroupMemberId])
    );
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20200108192123_OperationsV8')
BEGIN
    CREATE TABLE [NotificationGroupMemberTypes] (
        [NotificationGroupMemberTypeId] int NOT NULL IDENTITY,
        [Description] nvarchar(max) NOT NULL,
        [Active] bit NULL,
        [AddedOn] datetime2 NULL,
        [EditedOn] datetime2 NULL,
        [AddedBy] nvarchar(max) NULL,
        [EditedBy] nvarchar(max) NULL,
        CONSTRAINT [PK_NotificationGroupMemberTypes] PRIMARY KEY ([NotificationGroupMemberTypeId])
    );
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20200108192123_OperationsV8')
BEGIN
    CREATE TABLE [NotificationGroups] (
        [NotificationGroupId] int NOT NULL IDENTITY,
        [PLEventTypeId] int NOT NULL,
        [Description] nvarchar(max) NULL,
        [Active] bit NULL,
        [AddedOn] datetime2 NULL,
        [EditedOn] datetime2 NULL,
        [AddedBy] nvarchar(max) NULL,
        [EditedBy] nvarchar(max) NULL,
        CONSTRAINT [PK_NotificationGroups] PRIMARY KEY ([NotificationGroupId])
    );
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20200108192123_OperationsV8')
BEGIN
    CREATE TABLE [PLEventNotificationDetails] (
        [PLEventNotificationDetailsId] int NOT NULL IDENTITY,
        [PLEventNotificationId] int NOT NULL,
        [Description] int NOT NULL,
        [SentDate] datetime2 NOT NULL,
        [ConfirmedDate] datetime2 NULL,
        [Active] bit NULL,
        [AddedOn] datetime2 NULL,
        [EditedOn] datetime2 NULL,
        [AddedBy] nvarchar(max) NULL,
        [EditedBy] nvarchar(max) NULL,
        CONSTRAINT [PK_PLEventNotificationDetails] PRIMARY KEY ([PLEventNotificationDetailsId])
    );
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20200108192123_OperationsV8')
BEGIN
    CREATE TABLE [PLEventNotifications] (
        [PLEventNotificatgionId] int NOT NULL IDENTITY,
        [PLEventTypeId] int NOT NULL,
        [NotificationGroupId] int NOT NULL,
        [Description] int NOT NULL,
        [StartDate] datetime2 NOT NULL,
        [EndDate] datetime2 NULL,
        [Active] bit NULL,
        [AddedOn] datetime2 NULL,
        [EditedOn] datetime2 NULL,
        [AddedBy] nvarchar(max) NULL,
        [EditedBy] nvarchar(max) NULL,
        CONSTRAINT [PK_PLEventNotifications] PRIMARY KEY ([PLEventNotificatgionId])
    );
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20200108192123_OperationsV8')
BEGIN
    CREATE TABLE [ThresholdAreas] (
        [ThresholdAreaId] int NOT NULL IDENTITY,
        [Description] nvarchar(max) NOT NULL,
        [ShortDescription] nvarchar(max) NULL,
        [Active] bit NULL,
        [AddedOn] datetime2 NULL,
        [EditedOn] datetime2 NULL,
        [AddedBy] nvarchar(max) NULL,
        [EditedBy] nvarchar(max) NULL,
        CONSTRAINT [PK_ThresholdAreas] PRIMARY KEY ([ThresholdAreaId])
    );
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20200108192123_OperationsV8')
BEGIN
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdAreaId', N'Description', N'ShortDescription', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[ThresholdAreas]'))
        SET IDENTITY_INSERT [ThresholdAreas] ON;
    INSERT INTO [ThresholdAreas] ([ThresholdAreaId], [Description], [ShortDescription], [Active], [AddedOn], [EditedOn], [AddedBy], [EditedBy])
    VALUES (1, N'Entire Unit', N'Total', CAST(1 AS bit), '2020-01-29T11:39:12.4362005-05:00', '2020-01-29T11:39:12.4362065-05:00', N'Midmark RTLS System', N'Midmark RTLS System');
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdAreaId', N'Description', N'ShortDescription', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[ThresholdAreas]'))
        SET IDENTITY_INSERT [ThresholdAreas] OFF;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20200108192123_OperationsV8')
BEGIN
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdAreaId', N'Description', N'ShortDescription', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[ThresholdAreas]'))
        SET IDENTITY_INSERT [ThresholdAreas] ON;
    INSERT INTO [ThresholdAreas] ([ThresholdAreaId], [Description], [ShortDescription], [Active], [AddedOn], [EditedOn], [AddedBy], [EditedBy])
    VALUES (2, N'Clean Areas', N'Clean', CAST(1 AS bit), '2020-01-29T11:39:12.4362100-05:00', '2020-01-29T11:39:12.4362103-05:00', N'Midmark RTLS System', N'Midmark RTLS System');
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdAreaId', N'Description', N'ShortDescription', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[ThresholdAreas]'))
        SET IDENTITY_INSERT [ThresholdAreas] OFF;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20200108192123_OperationsV8')
BEGIN
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdAreaId', N'Description', N'ShortDescription', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[ThresholdAreas]'))
        SET IDENTITY_INSERT [ThresholdAreas] ON;
    INSERT INTO [ThresholdAreas] ([ThresholdAreaId], [Description], [ShortDescription], [Active], [AddedOn], [EditedOn], [AddedBy], [EditedBy])
    VALUES (3, N'Dirty Areas', N'Dirty', CAST(1 AS bit), '2020-01-29T11:39:12.4362191-05:00', '2020-01-29T11:39:12.4362195-05:00', N'Midmark RTLS System', N'Midmark RTLS System');
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ThresholdAreaId', N'Description', N'ShortDescription', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[ThresholdAreas]'))
        SET IDENTITY_INSERT [ThresholdAreas] OFF;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20200108192123_OperationsV8')
BEGIN
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'PLEventTypeId', N'Description', N'ShortDescription', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[PLEventTypes]'))
        SET IDENTITY_INSERT [PLEventTypes] ON;
    INSERT INTO [PLEventTypes] ([PLEventTypeId], [Description], [ShortDescription], [ThresholdTypeId], [Active], [AddedOn], [EditedOn], [AddedBy], [EditedBy])
    VALUES (1, N'Normal', N'Normal', NULL, CAST(1 AS bit), '2020-01-29T11:39:12.4362206-05:00', '2020-01-29T11:39:12.4362209-05:00', N'Midmark RTLS System', N'Midmark RTLS System');
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'PLEventTypeId', N'Description', N'ShortDescription', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[PLEventTypes]'))
        SET IDENTITY_INSERT [PLEventTypes] OFF;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20200108192123_OperationsV8')
BEGIN
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'PLEventTypeId', N'Description', N'ShortDescription', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[PLEventTypes]'))
        SET IDENTITY_INSERT [PLEventTypes] ON;
    INSERT INTO [PLEventTypes] ([PLEventTypeId], [Description], [ShortDescription], [ThresholdTypeId], [Active], [AddedOn], [EditedOn], [AddedBy], [EditedBy])
    VALUES (2, N'Critical Low Alert', N'CriticalLowAlert', 1, CAST(1 AS bit), '2020-01-29T11:39:12.4362219-05:00', '2020-01-29T11:39:12.4362223-05:00', N'Midmark RTLS System', N'Midmark RTLS System');
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'PLEventTypeId', N'Description', N'ShortDescription', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[PLEventTypes]'))
        SET IDENTITY_INSERT [PLEventTypes] OFF;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20200108192123_OperationsV8')
BEGIN
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'PLEventTypeId', N'Description', N'ShortDescription', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[PLEventTypes]'))
        SET IDENTITY_INSERT [PLEventTypes] ON;
    INSERT INTO [PLEventTypes] ([PLEventTypeId], [Description], [ShortDescription], [ThresholdTypeId], [Active], [AddedOn], [EditedOn], [AddedBy], [EditedBy])
    VALUES (3, N'Low Alert', N'LowAlert', 2, CAST(1 AS bit), '2020-01-29T11:39:12.4362233-05:00', '2020-01-29T11:39:12.4362236-05:00', N'Midmark RTLS System', N'Midmark RTLS System');
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'PLEventTypeId', N'Description', N'ShortDescription', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[PLEventTypes]'))
        SET IDENTITY_INSERT [PLEventTypes] OFF;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20200108192123_OperationsV8')
BEGIN
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'PLEventTypeId', N'Description', N'ShortDescription', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[PLEventTypes]'))
        SET IDENTITY_INSERT [PLEventTypes] ON;
    INSERT INTO [PLEventTypes] ([PLEventTypeId], [Description], [ShortDescription], [ThresholdTypeId], [Active], [AddedOn], [EditedOn], [AddedBy], [EditedBy])
    VALUES (4, N'High Alert', N'HighAlert', 3, CAST(1 AS bit), '2020-01-29T11:39:12.4362244-05:00', '2020-01-29T11:39:12.4362247-05:00', N'Midmark RTLS System', N'Midmark RTLS System');
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'PLEventTypeId', N'Description', N'ShortDescription', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[PLEventTypes]'))
        SET IDENTITY_INSERT [PLEventTypes] OFF;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20200108192123_OperationsV8')
BEGIN
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'PLEventTypeId', N'Description', N'ShortDescription', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[PLEventTypes]'))
        SET IDENTITY_INSERT [PLEventTypes] ON;
    INSERT INTO [PLEventTypes] ([PLEventTypeId], [Description], [ShortDescription], [ThresholdTypeId], [Active], [AddedOn], [EditedOn], [AddedBy], [EditedBy])
    VALUES (5, N'No Threshold', N'NoThreshold', NULL, CAST(1 AS bit), '2020-01-29T11:39:12.4362255-05:00', '2020-01-29T11:39:12.4362258-05:00', N'Midmark RTLS System', N'Midmark RTLS System');
    IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'PLEventTypeId', N'Description', N'ShortDescription', N'ThresholdTypeId', N'Active', N'AddedOn', N'EditedOn', N'AddedBy', N'EditedBy') AND [object_id] = OBJECT_ID(N'[PLEventTypes]'))
        SET IDENTITY_INSERT [PLEventTypes] OFF;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20200108192123_OperationsV8')
BEGIN
    update Thresholds set ThresholdAreaId = 1
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20200108192123_OperationsV8')
BEGIN
    INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
    VALUES (N'20200108192123_OperationsV8', N'3.1.1');
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20200128154202_OperationsV9')
BEGIN
    DECLARE @var4 sysname;
    SELECT @var4 = [d].[name]
    FROM [sys].[default_constraints] [d]
    INNER JOIN [sys].[columns] [c] ON [d].[parent_column_id] = [c].[column_id] AND [d].[parent_object_id] = [c].[object_id]
    WHERE ([d].[parent_object_id] = OBJECT_ID(N'[PLEvents]') AND [c].[name] = N'Count');
    IF @var4 IS NOT NULL EXEC(N'ALTER TABLE [PLEvents] DROP CONSTRAINT [' + @var4 + '];');
    ALTER TABLE [PLEvents] DROP COLUMN [Count];
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20200128154202_OperationsV9')
BEGIN
    EXEC sp_rename N'[LocationChanges].[LocationID]', N'LocationId', N'COLUMN';
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20200128154202_OperationsV9')
BEGIN
    EXEC sp_rename N'[LocationChanges].[LastLocationID]', N'LastLocationId', N'COLUMN';
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20200128154202_OperationsV9')
BEGIN
    DECLARE @var5 sysname;
    SELECT @var5 = [d].[name]
    FROM [sys].[default_constraints] [d]
    INNER JOIN [sys].[columns] [c] ON [d].[parent_column_id] = [c].[column_id] AND [d].[parent_object_id] = [c].[object_id]
    WHERE ([d].[parent_object_id] = OBJECT_ID(N'[UnitLocations]') AND [c].[name] = N'IsDirty');
    IF @var5 IS NOT NULL EXEC(N'ALTER TABLE [UnitLocations] DROP CONSTRAINT [' + @var5 + '];');
    ALTER TABLE [UnitLocations] ALTER COLUMN [IsDirty] bit NOT NULL;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20200128154202_OperationsV9')
BEGIN
    DECLARE @var6 sysname;
    SELECT @var6 = [d].[name]
    FROM [sys].[default_constraints] [d]
    INNER JOIN [sys].[columns] [c] ON [d].[parent_column_id] = [c].[column_id] AND [d].[parent_object_id] = [c].[object_id]
    WHERE ([d].[parent_object_id] = OBJECT_ID(N'[UnitLocations]') AND [c].[name] = N'IsClean');
    IF @var6 IS NOT NULL EXEC(N'ALTER TABLE [UnitLocations] DROP CONSTRAINT [' + @var6 + '];');
    ALTER TABLE [UnitLocations] ALTER COLUMN [IsClean] bit NOT NULL;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20200128154202_OperationsV9')
BEGIN
    DECLARE @var7 sysname;
    SELECT @var7 = [d].[name]
    FROM [sys].[default_constraints] [d]
    INNER JOIN [sys].[columns] [c] ON [d].[parent_column_id] = [c].[column_id] AND [d].[parent_object_id] = [c].[object_id]
    WHERE ([d].[parent_object_id] = OBJECT_ID(N'[PLEvents]') AND [c].[name] = N'Description');
    IF @var7 IS NOT NULL EXEC(N'ALTER TABLE [PLEvents] DROP CONSTRAINT [' + @var7 + '];');
    ALTER TABLE [PLEvents] ALTER COLUMN [Description] nvarchar(max) NOT NULL;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20200128154202_OperationsV9')
BEGIN
    ALTER TABLE [PLEvents] ADD [NewCount] int NOT NULL DEFAULT 0;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20200128154202_OperationsV9')
BEGIN
    ALTER TABLE [PLEvents] ADD [PreviousCount] int NOT NULL DEFAULT 0;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20200128154202_OperationsV9')
BEGIN
    ALTER TABLE [PLEvents] ADD [ThresholdAreaId] int NOT NULL DEFAULT 0;
END;

GO

IF NOT EXISTS(SELECT * FROM [__EFMigrationsHistory] WHERE [MigrationId] = N'20200128154202_OperationsV9')
BEGIN
    INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
    VALUES (N'20200128154202_OperationsV9', N'3.1.1');
END;

GO