Letter Response Release

by Ivan Gerasimenko

JavaScript

/*
Deployment script

This code was generated by a tool.
Changes to this file may cause incorrect behavior and will be lost if
the code is regenerated.
*/

SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, CONCAT_NULL_YIELDS_NULL, QUOTED_IDENTIFIER ON;

SET NUMERIC_ROUNDABORT OFF;

GO

USE [DocflowZC];


GO
/*
The column Content on table [dbo].[LetterResponseContent] must be changed from NULL to NOT NULL. If the table contains data, the ALTER script may not work. To avoid this issue, you must add values to this column for all rows or mark it as allowing NULL values, or enable the generation of smart-defaults as a deployment option.

The column DocId on table [dbo].[LetterResponseContent] must be changed from NULL to NOT NULL. If the table contains data, the ALTER script may not work. To avoid this issue, you must add values to this column for all rows or mark it as allowing NULL values, or enable the generation of smart-defaults as a deployment option.
*/

IF EXISTS (select top 1 1 from [dbo].[LetterResponseContent])
    RAISERROR (N'Rows were detected. The schema update is terminating because data loss might occur.', 16, 127) WITH NOWAIT

GO
PRINT N'Dropping [dbo].[LD_OfficeStatus].[_dta_index_LD_OfficeStatus_5_1666104976__K11_K1_3]...';


GO
DROP INDEX [_dta_index_LD_OfficeStatus_5_1666104976__K11_K1_3]
    ON [dbo].[LD_OfficeStatus];


GO
PRINT N'Dropping [dbo].[ListDocs].[sdrt]...';


GO
DROP INDEX [sdrt]
    ON [dbo].[ListDocs];


GO
PRINT N'Dropping [dbo].[LD_OfficeStatus].[IX_LD_OfficeStatus_idOffice]...';


GO
DROP INDEX [IX_LD_OfficeStatus_idOffice]
    ON [dbo].[LD_OfficeStatus];


GO
PRINT N'Dropping [dbo].[LD_OfficeStatus].[IX_LD_OfficeStatus_idOffice_idStatus]...';


GO
DROP INDEX [IX_LD_OfficeStatus_idOffice_idStatus]
    ON [dbo].[LD_OfficeStatus];


GO
PRINT N'Dropping FK__LetterRes__DocId__14A6EE59...';


GO
ALTER TABLE [dbo].[LetterResponseContent] DROP CONSTRAINT [FK__LetterRes__DocId__14A6EE59];


GO
PRINT N'Altering...