CREATE TABLE [dbo].[VendorModel]
(
[ModelID] [int] NOT NULL,
[Manufacturer] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Model] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[NormalizedModel] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[IsSBSMatch] [bit] NULL CONSTRAINT [DF_VendorModel_IsSBSMatch] DEFAULT ((1)),
[Engine_Match] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Engine_Manu] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FamilyUID] [uniqueidentifier] NULL,
[ToshibaModelID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[VendorModel] ADD CONSTRAINT [PK_VendorModel_ModelID] PRIMARY KEY CLUSTERED ([ModelID]) ON [PRIMARY]
GO