
--Migration_RCCP_20220623_184900.txt
ALTER TABLE [dbo].[MessageJobs] DROP CONSTRAINT [PK_dbo.MessageJobs]
DECLARE @var0 nvarchar(128)
SELECT @var0 = name
FROM sys.default_constraints
WHERE parent_object_id = object_id(N'dbo.MessageJobs')
AND col_name(parent_object_id, parent_column_id) = 'Id';
IF @var0 IS NOT NULL
    EXECUTE('ALTER TABLE [dbo].[MessageJobs] DROP CONSTRAINT [' + @var0 + ']')
ALTER TABLE [dbo].[MessageJobs] ALTER COLUMN [Id] [uniqueidentifier] NOT NULL
ALTER TABLE [dbo].[MessageJobs] ADD CONSTRAINT [PK_dbo.MessageJobs] PRIMARY KEY ([Id])

--Migration_RCCP_20220623_185822.txt
ALTER TABLE [dbo].[MessageJobs] DROP CONSTRAINT [PK_dbo.MessageJobs]
DECLARE @var0 nvarchar(128)
SELECT @var0 = name
FROM sys.default_constraints
WHERE parent_object_id = object_id(N'dbo.MessageJobs')
AND col_name(parent_object_id, parent_column_id) = 'Id';
IF @var0 IS NOT NULL
    EXECUTE('ALTER TABLE [dbo].[MessageJobs] DROP CONSTRAINT [' + @var0 + ']')
ALTER TABLE [dbo].[MessageJobs] ALTER COLUMN [Id] [uniqueidentifier] NOT NULL
ALTER TABLE [dbo].[MessageJobs] ADD CONSTRAINT [PK_dbo.MessageJobs] PRIMARY KEY ([Id])

--Migration_RCCP_20220623_191332.txt
ALTER TABLE [dbo].[MessageJobs] DROP CONSTRAINT [PK_dbo.MessageJobs]
DECLARE @var0 nvarchar(128)
SELECT @var0 = name
FROM sys.default_constraints
WHERE parent_object_id = object_id(N'dbo.MessageJobs')
AND col_name(parent_object_id, parent_column_id) = 'Id';
IF @var0 IS NOT NULL
    EXECUTE('ALTER TABLE [dbo].[MessageJobs] DROP CONSTRAINT [' + @var0 + ']')
ALTER TABLE [dbo].[MessageJobs] ALTER COLUMN [Id] [uniqueidentifier] NOT NULL
ALTER TABLE [dbo].[MessageJobs] ADD CONSTRAINT [PK_dbo.MessageJobs] PRIMARY KEY ([Id])

--Migration_RCCP_20220623_192752.txt
ALTER TABLE [dbo].[MessageJobs] DROP CONSTRAINT [PK_dbo.MessageJobs]
DECLARE @var0 nvarchar(128)
SELECT @var0 = name
FROM sys.default_constraints
WHERE parent_object_id = object_id(N'dbo.MessageJobs')
AND col_name(parent_object_id, parent_column_id) = 'Id';
IF @var0 IS NOT NULL
    EXECUTE('ALTER TABLE [dbo].[MessageJobs] DROP CONSTRAINT [' + @var0 + ']')
ALTER TABLE [dbo].[MessageJobs] ALTER COLUMN [Id] [uniqueidentifier] NOT NULL
ALTER TABLE [dbo].[MessageJobs] ADD CONSTRAINT [PK_dbo.MessageJobs] PRIMARY KEY ([Id])
