USE [logging2006]
GO

/****** Object:  Table [dbo].[Asset_ServiceContract_Vendor]    Script Date: 10-05-2020 21:05:42 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Asset_ServiceContract_Vendor](
	[VendorID] [uniqueidentifier] ROWGUIDCOL  NOT NULL,
	[Name] [nvarchar](50) NULL,
	[Address1] [nvarchar](128) NULL,
	[Address2] [nvarchar](128) NULL,
	[PostCode] [nvarchar](10) NULL,
	[City] [nvarchar](50) NULL,
	[Country] [nvarchar](128) NULL,
	[Telephone] [nvarchar](50) NULL,
	[Mobile] [nvarchar](50) NULL,
	[Email] [nvarchar](128) NULL,
	[ContactSirName] [nvarchar](50) NULL,
	[ContactLastName] [nvarchar](50) NULL
) ON [PRIMARY]

GO

ALTER TABLE [dbo].[Asset_ServiceContract_Vendor] ADD  CONSTRAINT [DF_Asset_ServiceContract_Vendor_VendorID]  DEFAULT (newid()) FOR [VendorID]
GO