ALTER TABLE [dbo].[Asset_Software] ALTER COLUMN [InstallLocation] NVARCHAR (4000) NULL;

ALTER TABLE [dbo].[Asset_Software] ALTER COLUMN [PackageCode] NVARCHAR (255) NULL;

ALTER TABLE [dbo].[Asset_Software] ALTER COLUMN [PackageName] NVARCHAR (255) NULL;


GO

ALTER TABLE [dbo].[Asset_Win32_Service] ALTER COLUMN [PathName] NVARCHAR (4000) NULL;


GO

ALTER TABLE [dbo].[BitLockerSettings]
    ADD [NeedsUpdate] BIT CONSTRAINT [BitLockerSettings_NeedsUpdate_DF] DEFAULT ((0)) NOT NULL;


GO

CREATE TABLE [dbo].[BitLockerPolicyDevice] (
    [DeviceGuid] VARCHAR (100) NOT NULL,
    CONSTRAINT [BitLockerPolicyDevice_DeviceGuid_PK] PRIMARY KEY NONCLUSTERED ([DeviceGuid] ASC)
);


GO

