gist

20180531-1648.sql

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 IsCustomerRequestInitial BIT NOT NULL
GO