
--Migration_RCCP_20241002_151142.txt
ALTER TABLE [dbo].[CounterUpdateFirmwareJobs] ADD [CompanySerial] [nvarchar](max)
ALTER TABLE [dbo].[CounterUpdateFirmwareJobs] ADD [FirmwareJobId] [nvarchar](max)
ALTER TABLE [dbo].[DevicePlanConfigurations] ADD [MountingHeight] [float] NOT NULL DEFAULT 0
ALTER TABLE [dbo].[PlannedDevices] ADD [DeviceName] [nvarchar](max)
DECLARE @var0 nvarchar(128)
SELECT @var0 = name
FROM sys.default_constraints
WHERE parent_object_id = object_id(N'dbo.CounterUpdateFirmwareJobs')
AND col_name(parent_object_id, parent_column_id) = 'CompanySerialList';
IF @var0 IS NOT NULL
    EXECUTE('ALTER TABLE [dbo].[CounterUpdateFirmwareJobs] DROP CONSTRAINT [' + @var0 + ']')
ALTER TABLE [dbo].[CounterUpdateFirmwareJobs] DROP COLUMN [CompanySerialList]
