20180531-1648.sql

gistfile1.txt

ALTER TABLE [EstimationSparePart]
	ADD
		[IsFreeOfCharge] BIT NULL,
		[IsFreeOfChargeInitial] BIT NULL
GO
UPDATE [EstimationSparePart] SET [IsFreeOfCharge] = 0, [IsFreeOfChargeInitial] = 0
GO
ALTER TABLE [EstimationSparePart] ALTER COLUMN IsFreeOfCharge BIT NOT NULL
GO
ALTER TABLE [EstimationSparePart] ALTER COLUMN IsFreeOfChargeInitial BIT NOT NULL
GO

ALTER TABLE [EstimationMDWorkInstruction]
	ADD
		[IsCustomerRequest] BIT NULL,
		[IsFreeOfChargeInitial] BIT NULL,
		[IsCustomerRequestInitial] BIT NULL
GO
UPDATE [EstimationMDWorkInstruction] SET
	[IsCustomerRequest] = 0,
	[IsFreeOfChargeInitial] = 0,
	[IsCustomerRequestInitial] = 0
GO
ALTER TABLE [EstimationMDWorkInstruction] ALTER COLUMN IsCustomerRequest BIT NOT NULL
GO
ALTER TABLE [EstimationMDWorkInstruction] ALTER COLUMN IsFreeOfChargeInitial BIT NOT NULL
GO
ALTER TABLE [EstimationMDWorkInstruction] ALTER COLUMN IsFreeOfChargeInitial BIT NOT NULL
GO