
CREATE TABLE [PrinterTransform]
(
[TransformGuid] [uniqueidentifier] NOT NULL CONSTRAINT [DF_PrinterTransform_TransformGuid] DEFAULT (newid()),
[Name] [nvarchar] (255) NOT NULL,
[TransformFile] [image] NOT NULL,
[MajorVersion] [int] NOT NULL CONSTRAINT [DF_PrinterTransform_MajorVersion] DEFAULT ((1)),
[MinorVersion] [int] NOT NULL CONSTRAINT [DF_PrinterTransform_MinorVersion] DEFAULT ((0)),
[Build] [int] NOT NULL CONSTRAINT [DF_PrinterTransform_Build] DEFAULT ((1)),
[Revision] [int] NOT NULL CONSTRAINT [DF_PrinterTransform_Revision] DEFAULT ((0)),
[UserName] [nvarchar] (200) NULL,
[DateModified] [bigint] NULL,
[Vendor] [nvarchar] (200) NULL
)
GO


CREATE UNIQUE NONCLUSTERED INDEX [PrinterTransform_Name_AK] ON [PrinterTransform] ([Name])
GO


delete [File]
where Folder = 14
go