ÿþUSE [master]

GO

/****** Object:  Database [Automart]    Script Date: 06/28/2011 10:58:48 ******/

If EXISTS

	(SELECT Name FROM sys.databases

	  WHERE Name='Automart')

BEGIN

DROP DATABASE Automart

END



CREATE DATABASE [Automart] 



GO

USE [Automart]

GO

/****** Object:  Schema [Employee]    Script Date: 06/28/2011 10:58:48 ******/

CREATE SCHEMA [Employee] AUTHORIZATION [dbo]

GO

/****** Object:  Schema [customer]    Script Date: 06/28/2011 10:58:48 ******/

CREATE SCHEMA [customer] AUTHORIZATION [dbo]

GO

/****** Object:  XmlSchemaCollection [dbo].[AutoMartServiceDescription]    Script Date: 06/28/2011 10:58:48 ******/

CREATE XML SCHEMA COLLECTION [dbo].[AutoMartServiceDescription] AS N'<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:t="http://www.automart.com/servicedescription" targetNamespace="http://www.automart.com/servicedescription" elementFormDefault="qualified"><xsd:element name="servicedescription"><xsd:complexType><xsd:complexContent><xsd:restriction base="xsd:anyType"><xsd:sequence><xsd:element name="description" type="xsd:string" /><xsd:element name="parts"><xsd:complexType><xsd:complexContent><xsd:restriction base="xsd:anyType"><xsd:sequence><xsd:element name="part" maxOccurs="unbounded"><xsd:complexType><xsd:complexContent><xsd:restriction base="xsd:anyType"><xsd:sequence><xsd:element name="partname" type="xsd:string" /><xsd:element name="quantity" type="xsd:unsignedByte" /><xsd:element name="perpartprice" type="xsd:decimal" /></xsd:sequence></xsd:restriction></xsd:complexContent></xsd:complexType></xsd:element></xsd:sequence></xsd:restriction></xsd:complexContent></xsd:complexType></xsd:element><xsd:element name="labor"><xsd:complexType><xsd:complexContent><xsd:restriction base="xsd:anyType"><xsd:sequence><xsd:element name="workers" type="xsd:unsignedByte" /><xsd:element name="hours" type="xsd:decimal" /></xsd:sequence></xsd:restriction></xsd:complexContent></xsd:complexType></xsd:element></xsd:sequence></xsd:restriction></xsd:complexContent></xsd:complexType></xsd:element></xsd:schema>'

GO

/****** Object:  XmlSchemaCollection [dbo].[AutomartNotesSchema]    Script Date: 06/28/2011 10:58:48 ******/

CREATE XML SCHEMA COLLECTION [dbo].[AutomartNotesSchema] AS N'<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:t="http://www.automart.com/comments" targetNamespace="http://www.automart.com/comments" elementFormDefault="qualified"><xsd:element name="Comments"><xsd:complexType><xsd:complexContent><xsd:restriction base="xsd:anyType"><xsd:sequence><xsd:element name="comment" type="xsd:string" /></xsd:sequence></xsd:restriction></xsd:complexContent></xsd:complexType></xsd:element></xsd:schema>'

GO

/****** Object:  XmlSchemaCollection [dbo].[AutomartCommentsSchema]    Script Date: 06/28/2011 10:58:48 ******/

CREATE XML SCHEMA COLLECTION [dbo].[AutomartCommentsSchema] AS N'<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:t="http://www.automart.com/notes" targetNamespace="http://www.automart.com/notes" elementFormDefault="qualified"><xsd:element name="notes"><xsd:complexType><xsd:complexContent><xsd:restriction base="xsd:anyType"><xsd:sequence><xsd:element name="note" type="xsd:anyType" maxOccurs="unbounded" /></xsd:sequence></xsd:restriction></xsd:complexContent></xsd:complexType></xsd:element></xsd:schema>'

GO

/****** Object:  Table [dbo].[Person]    Script Date: 06/28/2011 10:58:50 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Person](

	[Personkey] [int] IDENTITY(1,1) NOT NULL,

	[LastName] [nvarchar](255) NOT NULL,

	[FirstName] [nvarchar](255) NULL,

 CONSTRAINT [PK__Person__AA2FFB857F60ED59] PRIMARY KEY CLUSTERED 

(

	[Personkey] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

SET IDENTITY_INSERT [dbo].[Person] ON

INSERT [dbo].[Person] ([Personkey], [LastName], [FirstName]) VALUES (1, N'Anderson', N'Jay')

INSERT [dbo].[Person] ([Personkey], [LastName], [FirstName]) VALUES (2, N'Zimmerman', N'Toby')

INSERT [dbo].[Person] ([Personkey], [LastName], [FirstName]) VALUES (3, N'Mann', N'Louis')

INSERT [dbo].[Person] ([Personkey], [LastName], [FirstName]) VALUES (4, N'Carmel', N'Bob')

INSERT [dbo].[Person] ([Personkey], [LastName], [FirstName]) VALUES (5, N'Lewis', N'Mary')

INSERT [dbo].[Person] ([Personkey], [LastName], [FirstName]) VALUES (6, N'Tanner', N'Thomas')

INSERT [dbo].[Person] ([Personkey], [LastName], [FirstName]) VALUES (7, N'Patterson', N'Jody')

INSERT [dbo].[Person] ([Personkey], [LastName], [FirstName]) VALUES (8, N'Brown', N'Matt')

INSERT [dbo].[Person] ([Personkey], [LastName], [FirstName]) VALUES (9, N'Smith', N'Jerry')

INSERT [dbo].[Person] ([Personkey], [LastName], [FirstName]) VALUES (10, N'Peters', N'Jay')

INSERT [dbo].[Person] ([Personkey], [LastName], [FirstName]) VALUES (11, N'Masters', N'Fae')

INSERT [dbo].[Person] ([Personkey], [LastName], [FirstName]) VALUES (12, N'Moon', N'Tina')

INSERT [dbo].[Person] ([Personkey], [LastName], [FirstName]) VALUES (13, N'Nguyen', N'Lu')

INSERT [dbo].[Person] ([Personkey], [LastName], [FirstName]) VALUES (14, N'Chau', N'Mary')

INSERT [dbo].[Person] ([Personkey], [LastName], [FirstName]) VALUES (15, N'Kerry', N'Anne')

INSERT [dbo].[Person] ([Personkey], [LastName], [FirstName]) VALUES (16, N'Robinson', N'Mike')

INSERT [dbo].[Person] ([Personkey], [LastName], [FirstName]) VALUES (17, N'Martin', N'Taylor')

INSERT [dbo].[Person] ([Personkey], [LastName], [FirstName]) VALUES (18, N'McGraw', N'Alysson')

INSERT [dbo].[Person] ([Personkey], [LastName], [FirstName]) VALUES (19, N'Morgan', N'Cheryl')

INSERT [dbo].[Person] ([Personkey], [LastName], [FirstName]) VALUES (20, N'Tan', N'Lee')

INSERT [dbo].[Person] ([Personkey], [LastName], [FirstName]) VALUES (21, N'Jameson', N'Roberto')

INSERT [dbo].[Person] ([Personkey], [LastName], [FirstName]) VALUES (22, N'Banner', N'June')

INSERT [dbo].[Person] ([Personkey], [LastName], [FirstName]) VALUES (23, N'Lee', N'Tracy')

INSERT [dbo].[Person] ([Personkey], [LastName], [FirstName]) VALUES (24, N'Fabre', N'Jill')

INSERT [dbo].[Person] ([Personkey], [LastName], [FirstName]) VALUES (25, N'Gardner', N'Tom')

INSERT [dbo].[Person] ([Personkey], [LastName], [FirstName]) VALUES (26, N'Yesler', N'Bill')

INSERT [dbo].[Person] ([Personkey], [LastName], [FirstName]) VALUES (27, N'Caroll', N'Lisa')

INSERT [dbo].[Person] ([Personkey], [LastName], [FirstName]) VALUES (28, N'Lamont', N'Tess')

INSERT [dbo].[Person] ([Personkey], [LastName], [FirstName]) VALUES (29, N'Johnston', N'Sara')

INSERT [dbo].[Person] ([Personkey], [LastName], [FirstName]) VALUES (30, N'Eliot', N'James')

INSERT [dbo].[Person] ([Personkey], [LastName], [FirstName]) VALUES (31, N'Nguyen', N'Jane')

INSERT [dbo].[Person] ([Personkey], [LastName], [FirstName]) VALUES (32, N'Perry', N'Lee')

INSERT [dbo].[Person] ([Personkey], [LastName], [FirstName]) VALUES (33, N'Norton', N'Carrie')

INSERT [dbo].[Person] ([Personkey], [LastName], [FirstName]) VALUES (34, N'Farris', N'Mark')

INSERT [dbo].[Person] ([Personkey], [LastName], [FirstName]) VALUES (35, N'Farmer', N'Tim')

INSERT [dbo].[Person] ([Personkey], [LastName], [FirstName]) VALUES (36, N'Sanders', N'Lea')

INSERT [dbo].[Person] ([Personkey], [LastName], [FirstName]) VALUES (37, N'Smith', N'Jim')

INSERT [dbo].[Person] ([Personkey], [LastName], [FirstName]) VALUES (38, N'Zukof', N'Petra')

INSERT [dbo].[Person] ([Personkey], [LastName], [FirstName]) VALUES (39, N'Kim', N'Karen')

INSERT [dbo].[Person] ([Personkey], [LastName], [FirstName]) VALUES (40, N'Norman', N'Tina')

INSERT [dbo].[Person] ([Personkey], [LastName], [FirstName]) VALUES (41, N'Manning', N'Carol')

INSERT [dbo].[Person] ([Personkey], [LastName], [FirstName]) VALUES (42, N'Patton', N'Laura')

INSERT [dbo].[Person] ([Personkey], [LastName], [FirstName]) VALUES (43, N'Jorgenson', N'Amy')

INSERT [dbo].[Person] ([Personkey], [LastName], [FirstName]) VALUES (44, N'Schneider', N'Franz')

INSERT [dbo].[Person] ([Personkey], [LastName], [FirstName]) VALUES (45, N'Kim', N'Lee')

INSERT [dbo].[Person] ([Personkey], [LastName], [FirstName]) VALUES (46, N'Denny', N'Phil')

INSERT [dbo].[Person] ([Personkey], [LastName], [FirstName]) VALUES (47, N'Conner', N'Jessie')

INSERT [dbo].[Person] ([Personkey], [LastName], [FirstName]) VALUES (48, N'Keanne', N'Ann')

INSERT [dbo].[Person] ([Personkey], [LastName], [FirstName]) VALUES (49, N'Meuller', N'John')

INSERT [dbo].[Person] ([Personkey], [LastName], [FirstName]) VALUES (50, N'Rogers', N'Cherise')

INSERT [dbo].[Person] ([Personkey], [LastName], [FirstName]) VALUES (51, N'Ponge', N'Sue')

INSERT [dbo].[Person] ([Personkey], [LastName], [FirstName]) VALUES (52, N'Simpson', N'Bart')

SET IDENTITY_INSERT [dbo].[Person] OFF

/****** Object:  Table [customer].[Location]    Script Date: 06/28/2011 10:58:50 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [customer].[Location](

	[LocationID] [int] IDENTITY(1,1) NOT NULL,

	[LocationName] [nvarchar](255) NOT NULL,

	[LocationAddress] [nvarchar](255) NOT NULL,

	[LocationCity] [nvarchar](255) NOT NULL,

	[LocationState] [nchar](2) NOT NULL,

	[LocationZip] [nchar](10) NOT NULL,

	[LocationPhone] [nchar](13) NOT NULL,

PRIMARY KEY CLUSTERED 

(

	[LocationID] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

SET IDENTITY_INSERT [customer].[Location] ON

INSERT [customer].[Location] ([LocationID], [LocationName], [LocationAddress], [LocationCity], [LocationState], [LocationZip], [LocationPhone]) VALUES (1, N'North Seattle', N'101 Northgate Way', N'Seattle', N'WA', N'98100     ', N'2065551000   ')

INSERT [customer].[Location] ([LocationID], [LocationName], [LocationAddress], [LocationCity], [LocationState], [LocationZip], [LocationPhone]) VALUES (2, N'South Seattle', N'200 Martin Luther Way', N'Seattle', N'WA', N'98101     ', N'2065551001   ')

INSERT [customer].[Location] ([LocationID], [LocationName], [LocationAddress], [LocationCity], [LocationState], [LocationZip], [LocationPhone]) VALUES (3, N'Federal Way', N'1011 Meridian', N'Federal Way', N'WA', N'98002     ', N'2535551000   ')

INSERT [customer].[Location] ([LocationID], [LocationName], [LocationAddress], [LocationCity], [LocationState], [LocationZip], [LocationPhone]) VALUES (4, N'Spokane', N'2001 Division St', N'Spokane', N'WA', N'98103     ', N'2095552000   ')

INSERT [customer].[Location] ([LocationID], [LocationName], [LocationAddress], [LocationCity], [LocationState], [LocationZip], [LocationPhone]) VALUES (5, N'Tacoma', N'100 Tacoma Way South', N'Tacoma', N'WA', N'98000     ', N'2535551001   ')

SET IDENTITY_INSERT [customer].[Location] OFF

/****** Object:  Table [dbo].[Employee]    Script Date: 06/28/2011 10:58:50 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Employee](

	[EmployeeID] [int] IDENTITY(1,1) NOT NULL,

	[PersonKey] [int] NULL,

	[HireDate] [date] NOT NULL,

	[LocationID] [int] NULL,

	[SupervisorID] [int] NULL,

PRIMARY KEY CLUSTERED 

(

	[EmployeeID] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

SET IDENTITY_INSERT [dbo].[Employee] ON

INSERT [dbo].[Employee] ([EmployeeID], [PersonKey], [HireDate], [LocationID], [SupervisorID]) VALUES (1, 5, CAST(0x32240B00 AS Date), 1, NULL)

INSERT [dbo].[Employee] ([EmployeeID], [PersonKey], [HireDate], [LocationID], [SupervisorID]) VALUES (2, 6, CAST(0xD5280B00 AS Date), 1, 1)

INSERT [dbo].[Employee] ([EmployeeID], [PersonKey], [HireDate], [LocationID], [SupervisorID]) VALUES (3, 7, CAST(0xE6280B00 AS Date), 1, 1)

INSERT [dbo].[Employee] ([EmployeeID], [PersonKey], [HireDate], [LocationID], [SupervisorID]) VALUES (4, 8, CAST(0x712E0B00 AS Date), 1, 1)

INSERT [dbo].[Employee] ([EmployeeID], [PersonKey], [HireDate], [LocationID], [SupervisorID]) VALUES (6, 15, CAST(0xCA290B00 AS Date), 2, NULL)

INSERT [dbo].[Employee] ([EmployeeID], [PersonKey], [HireDate], [LocationID], [SupervisorID]) VALUES (8, 16, CAST(0xCA290B00 AS Date), 2, 6)

INSERT [dbo].[Employee] ([EmployeeID], [PersonKey], [HireDate], [LocationID], [SupervisorID]) VALUES (9, 17, CAST(0xFE2B0B00 AS Date), 2, 6)

INSERT [dbo].[Employee] ([EmployeeID], [PersonKey], [HireDate], [LocationID], [SupervisorID]) VALUES (10, 18, CAST(0x90320B00 AS Date), 2, 6)

INSERT [dbo].[Employee] ([EmployeeID], [PersonKey], [HireDate], [LocationID], [SupervisorID]) VALUES (11, 30, CAST(0x152F0B00 AS Date), 3, NULL)

INSERT [dbo].[Employee] ([EmployeeID], [PersonKey], [HireDate], [LocationID], [SupervisorID]) VALUES (12, 31, CAST(0x152F0B00 AS Date), 3, 11)

INSERT [dbo].[Employee] ([EmployeeID], [PersonKey], [HireDate], [LocationID], [SupervisorID]) VALUES (13, 32, CAST(0x9B2F0B00 AS Date), 3, 11)

INSERT [dbo].[Employee] ([EmployeeID], [PersonKey], [HireDate], [LocationID], [SupervisorID]) VALUES (14, 33, CAST(0xC2330B00 AS Date), 3, 11)

INSERT [dbo].[Employee] ([EmployeeID], [PersonKey], [HireDate], [LocationID], [SupervisorID]) VALUES (15, 46, CAST(0x57310B00 AS Date), 4, NULL)

INSERT [dbo].[Employee] ([EmployeeID], [PersonKey], [HireDate], [LocationID], [SupervisorID]) VALUES (16, 47, CAST(0x57310B00 AS Date), 4, 15)

INSERT [dbo].[Employee] ([EmployeeID], [PersonKey], [HireDate], [LocationID], [SupervisorID]) VALUES (17, 48, CAST(0xB8320B00 AS Date), 4, 15)

INSERT [dbo].[Employee] ([EmployeeID], [PersonKey], [HireDate], [LocationID], [SupervisorID]) VALUES (18, 49, CAST(0x2B340B00 AS Date), 4, 15)

SET IDENTITY_INSERT [dbo].[Employee] OFF

/****** Object:  Table [customer].[CustomerSurvey]    Script Date: 06/28/2011 10:58:50 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [customer].[CustomerSurvey](

	[SurveyID] [int] IDENTITY(1,1) NOT NULL,

	[LocationID] [int] NULL,

	[SurveyDate] [datetime] NOT NULL,

	[Rating] [int] NULL,

	[Comments] [xml](CONTENT [dbo].[AutomartCommentsSchema]) NULL,

PRIMARY KEY CLUSTERED 

(

	[SurveyID] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

/****** Object:  Table [customer].[AutoService]    Script Date: 06/28/2011 10:58:50 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [customer].[AutoService](

	[AutoServiceID] [int] IDENTITY(1,1) NOT NULL,

	[ServiceName] [nvarchar](255) NOT NULL,

	[ServicePrice] [money] NOT NULL,

	[ServiceDescription] [xml](CONTENT [dbo].[AutoMartServiceDescription]) NULL,

PRIMARY KEY CLUSTERED 

(

	[AutoServiceID] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

SET IDENTITY_INSERT [customer].[AutoService] ON

INSERT [customer].[AutoService] ([AutoServiceID], [ServiceName], [ServicePrice], [ServiceDescription]) VALUES (7, N'Oil Change', 45.5000, N'<servicedescription xmlns="http://www.automart.com/servicedescription"><description>

Change of oil and replacement of oil filter.

check of all filters, fluids and tire pressure

</description><parts><part><partname>oil quarts</partname><quantity>5</quantity><perpartprice>3.22</perpartprice></part><part><partname>Oil Filter</partname><quantity>1</quantity><perpartprice>3.15</perpartprice></part></parts><labor><workers>2</workers><hours>0.5</hours></labor></servicedescription>')

INSERT [customer].[AutoService] ([AutoServiceID], [ServiceName], [ServicePrice], [ServiceDescription]) VALUES (9, N'Radiator Flush', 80.5000, N'<servicedescription xmlns="http://www.automart.com/servicedescription"><description>

Flush the radiator, Replace with anafreeze

Check all hoses and related belts

</description><parts><part><partname>anafreeze</partname><quantity>1</quantity><perpartprice>7.65</perpartprice></part></parts><labor><workers>2</workers><hours>0.75</hours></labor></servicedescription>')

INSERT [customer].[AutoService] ([AutoServiceID], [ServiceName], [ServicePrice], [ServiceDescription]) VALUES (10, N'Tire Rotation', 24.5000, N'<servicedescription xmlns="http://www.automart.com/servicedescription"><description>

Rotate and rebalance tires for better wear

</description><parts><part><partname>none</partname><quantity>0</quantity><perpartprice>0</perpartprice></part></parts><labor><workers>2</workers><hours>0.5</hours></labor></servicedescription>')

INSERT [customer].[AutoService] ([AutoServiceID], [ServiceName], [ServicePrice], [ServiceDescription]) VALUES (11, N'Tune Up', 175.8000, N'<servicedescription xmlns="http://www.automart.com/servicedescription"><description>

Replace sparkplugs, airfilter. Adjust fuel injection

</description><parts><part><partname>spark plugs</partname><quantity>4</quantity><perpartprice>2.25</perpartprice></part><part><partname>air Filter</partname><quantity>1</quantity><perpartprice>6</perpartprice></part></parts><labor><workers>3</workers><hours>1</hours></labor></servicedescription>')

INSERT [customer].[AutoService] ([AutoServiceID], [ServiceName], [ServicePrice], [ServiceDescription]) VALUES (12, N'Replace fuel pump', 90.5000, N'<servicedescription xmlns="http://www.automart.com/servicedescription"><description>

Replace fuel pump

</description><parts><part><partname>fuel pump</partname><quantity>1</quantity><perpartprice>22.5</perpartprice></part></parts><labor><workers>1</workers><hours>1.2</hours></labor></servicedescription>')

INSERT [customer].[AutoService] ([AutoServiceID], [ServiceName], [ServicePrice], [ServiceDescription]) VALUES (13, N'Replace Alternator', 300.7500, N'<servicedescription xmlns="http://www.automart.com/servicedescription"><description>

Remove old alternator and replace with new

</description><parts><part><partname>Alternator</partname><quantity>1</quantity><perpartprice>93.6</perpartprice></part><part><partname>belt</partname><quantity>1</quantity><perpartprice>12.44</perpartprice></part></parts><labor><workers>2</workers><hours>3</hours></labor></servicedescription>')

INSERT [customer].[AutoService] ([AutoServiceID], [ServiceName], [ServicePrice], [ServiceDescription]) VALUES (14, N'Windsheild wipers', 30.5000, N'<servicedescription xmlns="http://www.automart.com/servicedescription"><description>

Replace windshield wiper blades

</description><parts><part><partname>Windshield wiper</partname><quantity>2</quantity><perpartprice>12</perpartprice></part></parts><labor><workers>1</workers><hours>0.2</hours></labor></servicedescription>')

INSERT [customer].[AutoService] ([AutoServiceID], [ServiceName], [ServicePrice], [ServiceDescription]) VALUES (15, N'clutch replacement', 950.5000, N'<servicedescription xmlns="http://www.automart.com/servicedescription"><description>

replace the clutch assembly in a manual transmission

</description><parts><part><partname>clutch assembly</partname><quantity>1</quantity><perpartprice>250.55</perpartprice></part></parts><labor><workers>3</workers><hours>6</hours></labor></servicedescription>')

SET IDENTITY_INSERT [customer].[AutoService] OFF

/****** Object:  Table [customer].[vehicle]    Script Date: 06/28/2011 10:58:50 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [customer].[vehicle](

	[VehicleId] [int] IDENTITY(1,1) NOT NULL,

	[LicenseNumber] [nvarchar](10) NOT NULL,

	[VehicleMake] [nvarchar](255) NOT NULL,

	[VehicleYear] [nchar](4) NOT NULL,

	[PersonKey] [int] NULL,

PRIMARY KEY CLUSTERED 

(

	[VehicleId] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],

UNIQUE NONCLUSTERED 

(

	[LicenseNumber] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

SET IDENTITY_INSERT [customer].[vehicle] ON

INSERT [customer].[vehicle] ([VehicleId], [LicenseNumber], [VehicleMake], [VehicleYear], [PersonKey]) VALUES (1, N'WEB326', N'Toyota Camry', N'2004', 1)

INSERT [customer].[vehicle] ([VehicleId], [LicenseNumber], [VehicleMake], [VehicleYear], [PersonKey]) VALUES (2, N'ITC226', N'Ford Mustang', N'2009', 2)

INSERT [customer].[vehicle] ([VehicleId], [LicenseNumber], [VehicleMake], [VehicleYear], [PersonKey]) VALUES (3, N'XML100', N'Saturn SL', N'1996', 3)

INSERT [customer].[vehicle] ([VehicleId], [LicenseNumber], [VehicleMake], [VehicleYear], [PersonKey]) VALUES (5, N'ABD201', N'Ford Windstar', N'2005', 4)

INSERT [customer].[vehicle] ([VehicleId], [LicenseNumber], [VehicleMake], [VehicleYear], [PersonKey]) VALUES (6, N'WWF202', N'Honda Civic', N'2010', 9)

INSERT [customer].[vehicle] ([VehicleId], [LicenseNumber], [VehicleMake], [VehicleYear], [PersonKey]) VALUES (7, N'MYCAR2', N'Chevy Firebird', N'2000', 10)

INSERT [customer].[vehicle] ([VehicleId], [LicenseNumber], [VehicleMake], [VehicleYear], [PersonKey]) VALUES (8, N'MLB343', N'Volkswagen Beetle', N'2003', 11)

INSERT [customer].[vehicle] ([VehicleId], [LicenseNumber], [VehicleMake], [VehicleYear], [PersonKey]) VALUES (9, N'LOL201', N'Kia Sephia', N'1999', 12)

INSERT [customer].[vehicle] ([VehicleId], [LicenseNumber], [VehicleMake], [VehicleYear], [PersonKey]) VALUES (10, N'DTK900', N'Huyandai Sonata', N'2009', 13)

INSERT [customer].[vehicle] ([VehicleId], [LicenseNumber], [VehicleMake], [VehicleYear], [PersonKey]) VALUES (11, N'SSS109', N'Honda Civic', N'2010', 14)

INSERT [customer].[vehicle] ([VehicleId], [LicenseNumber], [VehicleMake], [VehicleYear], [PersonKey]) VALUES (12, N'BIG100', N'Dodge Ram', N'2000', 19)

INSERT [customer].[vehicle] ([VehicleId], [LicenseNumber], [VehicleMake], [VehicleYear], [PersonKey]) VALUES (13, N'NET200', N'Ford Focus', N'2008', 20)

INSERT [customer].[vehicle] ([VehicleId], [LicenseNumber], [VehicleMake], [VehicleYear], [PersonKey]) VALUES (14, N'MSN001', N'Acura', N'2011', 21)

INSERT [customer].[vehicle] ([VehicleId], [LicenseNumber], [VehicleMake], [VehicleYear], [PersonKey]) VALUES (15, N'STG345', N'Audi', N'2001', 22)

INSERT [customer].[vehicle] ([VehicleId], [LicenseNumber], [VehicleMake], [VehicleYear], [PersonKey]) VALUES (16, N'KMK200', N'Honda Civic', N'2001', 23)

INSERT [customer].[vehicle] ([VehicleId], [LicenseNumber], [VehicleMake], [VehicleYear], [PersonKey]) VALUES (17, N'LKJ098', N'Ford Freestar', N'2004', 24)

INSERT [customer].[vehicle] ([VehicleId], [LicenseNumber], [VehicleMake], [VehicleYear], [PersonKey]) VALUES (18, N'KPF999', N'Lexus', N'2002', 23)

INSERT [customer].[vehicle] ([VehicleId], [LicenseNumber], [VehicleMake], [VehicleYear], [PersonKey]) VALUES (19, N'OPO234', N'Jeep Cherokee', N'1998', 24)

INSERT [customer].[vehicle] ([VehicleId], [LicenseNumber], [VehicleMake], [VehicleYear], [PersonKey]) VALUES (20, N'GHG198', N'Kia Rio', N'2007', 25)

INSERT [customer].[vehicle] ([VehicleId], [LicenseNumber], [VehicleMake], [VehicleYear], [PersonKey]) VALUES (21, N'MYBUG1', N'Volkswagen Beetle', N'2005', 26)

INSERT [customer].[vehicle] ([VehicleId], [LicenseNumber], [VehicleMake], [VehicleYear], [PersonKey]) VALUES (22, N'DDL202', N'BMW', N'1997', 28)

INSERT [customer].[vehicle] ([VehicleId], [LicenseNumber], [VehicleMake], [VehicleYear], [PersonKey]) VALUES (23, N'PFX100', N'Ford Escort', N'2000', 29)

INSERT [customer].[vehicle] ([VehicleId], [LicenseNumber], [VehicleMake], [VehicleYear], [PersonKey]) VALUES (24, N'POP999', N'Buick', N'2010', 34)

INSERT [customer].[vehicle] ([VehicleId], [LicenseNumber], [VehicleMake], [VehicleYear], [PersonKey]) VALUES (25, N'JKI234', N'Toyota Celica', N'2008', 35)

INSERT [customer].[vehicle] ([VehicleId], [LicenseNumber], [VehicleMake], [VehicleYear], [PersonKey]) VALUES (26, N'ISO456', N'Toyata Camry', N'2010', 36)

INSERT [customer].[vehicle] ([VehicleId], [LicenseNumber], [VehicleMake], [VehicleYear], [PersonKey]) VALUES (27, N'GGF357', N'Hyundai Sonata', N'2011', 37)

INSERT [customer].[vehicle] ([VehicleId], [LicenseNumber], [VehicleMake], [VehicleYear], [PersonKey]) VALUES (28, N'YTJ002', N'Ford Taurus', N'2005', 38)

INSERT [customer].[vehicle] ([VehicleId], [LicenseNumber], [VehicleMake], [VehicleYear], [PersonKey]) VALUES (29, N'LGF900', N'Toyota Escalade', N'2006', 39)

INSERT [customer].[vehicle] ([VehicleId], [LicenseNumber], [VehicleMake], [VehicleYear], [PersonKey]) VALUES (30, N'UUH821', N'Ford Windstar', N'2002', 40)

INSERT [customer].[vehicle] ([VehicleId], [LicenseNumber], [VehicleMake], [VehicleYear], [PersonKey]) VALUES (31, N'KHD030', N'Kia Sephia', N'2009', 41)

INSERT [customer].[vehicle] ([VehicleId], [LicenseNumber], [VehicleMake], [VehicleYear], [PersonKey]) VALUES (32, N'KLK767', N'Honda Civic', N'2010', 42)

INSERT [customer].[vehicle] ([VehicleId], [LicenseNumber], [VehicleMake], [VehicleYear], [PersonKey]) VALUES (33, N'SXS500', N'Acura', N'2001', 43)

INSERT [customer].[vehicle] ([VehicleId], [LicenseNumber], [VehicleMake], [VehicleYear], [PersonKey]) VALUES (34, N'STS101', N'Dodge RAm', N'2009', 44)

INSERT [customer].[vehicle] ([VehicleId], [LicenseNumber], [VehicleMake], [VehicleYear], [PersonKey]) VALUES (35, N'NFS296', N'Ford Maveric', N'1997', 43)

INSERT [customer].[vehicle] ([VehicleId], [LicenseNumber], [VehicleMake], [VehicleYear], [PersonKey]) VALUES (36, N'JGF333', N'Lexus', N'2003', 44)

INSERT [customer].[vehicle] ([VehicleId], [LicenseNumber], [VehicleMake], [VehicleYear], [PersonKey]) VALUES (37, N'NSN894', N'Chevy Suburban', N'2000', 45)

INSERT [customer].[vehicle] ([VehicleId], [LicenseNumber], [VehicleMake], [VehicleYear], [PersonKey]) VALUES (38, N'XXX989', N'Ford Explorer', N'2005', 50)

INSERT [customer].[vehicle] ([VehicleId], [LicenseNumber], [VehicleMake], [VehicleYear], [PersonKey]) VALUES (39, N'MXM912', N'Cadillac Escalade', N'2010', 51)

INSERT [customer].[vehicle] ([VehicleId], [LicenseNumber], [VehicleMake], [VehicleYear], [PersonKey]) VALUES (40, N'XCX430', N'Toyata Celica', N'2003', 52)

INSERT [customer].[vehicle] ([VehicleId], [LicenseNumber], [VehicleMake], [VehicleYear], [PersonKey]) VALUES (41, N'MMM222', N'Ford Explorer', N'2009', 3)

INSERT [customer].[vehicle] ([VehicleId], [LicenseNumber], [VehicleMake], [VehicleYear], [PersonKey]) VALUES (42, N'LKL343', N'Honda Civic', N'2010', 10)

INSERT [customer].[vehicle] ([VehicleId], [LicenseNumber], [VehicleMake], [VehicleYear], [PersonKey]) VALUES (43, N'KMK303', N'Acura', N'2007', 19)

INSERT [customer].[vehicle] ([VehicleId], [LicenseNumber], [VehicleMake], [VehicleYear], [PersonKey]) VALUES (44, N'CVC223', N'BMW', N'2000', 23)

INSERT [customer].[vehicle] ([VehicleId], [LicenseNumber], [VehicleMake], [VehicleYear], [PersonKey]) VALUES (45, N'LFM002', N'Ford Taurus', N'2002', 40)

INSERT [customer].[vehicle] ([VehicleId], [LicenseNumber], [VehicleMake], [VehicleYear], [PersonKey]) VALUES (46, N'ASA900', N'Honda Civic ', N'2006', 42)

SET IDENTITY_INSERT [customer].[vehicle] OFF

/****** Object:  Table [customer].[RegisteredCustomer]    Script Date: 06/28/2011 10:58:50 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [customer].[RegisteredCustomer](

	[RegisteredCustomerID] [int] IDENTITY(1,1) NOT NULL,

	[Email] [nvarchar](255) NOT NULL,

	[CustomerPassword] [nvarchar](20) NOT NULL,

	[PersonKey] [int] NULL,

PRIMARY KEY CLUSTERED 

(

	[RegisteredCustomerID] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],

UNIQUE NONCLUSTERED 

(

	[Email] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

SET IDENTITY_INSERT [customer].[RegisteredCustomer] ON

INSERT [customer].[RegisteredCustomer] ([RegisteredCustomerID], [Email], [CustomerPassword], [PersonKey]) VALUES (1, N'janderson@gmail.com', N'jpass', 1)

INSERT [customer].[RegisteredCustomer] ([RegisteredCustomerID], [Email], [CustomerPassword], [PersonKey]) VALUES (2, N'zman@hotmail.com', N'tz98', 2)

INSERT [customer].[RegisteredCustomer] ([RegisteredCustomerID], [Email], [CustomerPassword], [PersonKey]) VALUES (3, N'themann@yahoo.com', N'louis97', 3)

INSERT [customer].[RegisteredCustomer] ([RegisteredCustomerID], [Email], [CustomerPassword], [PersonKey]) VALUES (4, N'candyman@gmail.com', N'bobpass', 4)

INSERT [customer].[RegisteredCustomer] ([RegisteredCustomerID], [Email], [CustomerPassword], [PersonKey]) VALUES (5, N'jerry@jerrysmith.net', N'jspass', 9)

INSERT [customer].[RegisteredCustomer] ([RegisteredCustomerID], [Email], [CustomerPassword], [PersonKey]) VALUES (6, N'jpeters@aol.com', N'peterpass', 10)

INSERT [customer].[RegisteredCustomer] ([RegisteredCustomerID], [Email], [CustomerPassword], [PersonKey]) VALUES (7, N'masters@uwashington.edu', N'faepass', 11)

INSERT [customer].[RegisteredCustomer] ([RegisteredCustomerID], [Email], [CustomerPassword], [PersonKey]) VALUES (8, N'luna@comcast.com', N'moonlight', 12)

INSERT [customer].[RegisteredCustomer] ([RegisteredCustomerID], [Email], [CustomerPassword], [PersonKey]) VALUES (9, N'cindylu@gmail.com', N'lulu', 13)

INSERT [customer].[RegisteredCustomer] ([RegisteredCustomerID], [Email], [CustomerPassword], [PersonKey]) VALUES (10, N'marychau@seattlecentral.edu', N'chauall', 14)

INSERT [customer].[RegisteredCustomer] ([RegisteredCustomerID], [Email], [CustomerPassword], [PersonKey]) VALUES (11, N'morgana@yahoo.com', N'morganfay', 19)

INSERT [customer].[RegisteredCustomer] ([RegisteredCustomerID], [Email], [CustomerPassword], [PersonKey]) VALUES (12, N'leetan@hotmail.com', N'leepass', 20)

INSERT [customer].[RegisteredCustomer] ([RegisteredCustomerID], [Email], [CustomerPassword], [PersonKey]) VALUES (13, N'roberto@hotmail.com', N'robpass', 21)

INSERT [customer].[RegisteredCustomer] ([RegisteredCustomerID], [Email], [CustomerPassword], [PersonKey]) VALUES (14, N'junewedding@gmail.com', N'junepass', 22)

INSERT [customer].[RegisteredCustomer] ([RegisteredCustomerID], [Email], [CustomerPassword], [PersonKey]) VALUES (15, N'tracyLee@plu.edu', N'tlpass', 23)

INSERT [customer].[RegisteredCustomer] ([RegisteredCustomerID], [Email], [CustomerPassword], [PersonKey]) VALUES (16, N'Fabre@yahoo.com', N'jillPass', 24)

INSERT [customer].[RegisteredCustomer] ([RegisteredCustomerID], [Email], [CustomerPassword], [PersonKey]) VALUES (17, N'gardner@hotmail.com', N'gpass', 25)

INSERT [customer].[RegisteredCustomer] ([RegisteredCustomerID], [Email], [CustomerPassword], [PersonKey]) VALUES (18, N'byessler@msn.com', N'bypass', 26)

INSERT [customer].[RegisteredCustomer] ([RegisteredCustomerID], [Email], [CustomerPassword], [PersonKey]) VALUES (19, N'lc@carol.com', N'lisapass', 27)

INSERT [customer].[RegisteredCustomer] ([RegisteredCustomerID], [Email], [CustomerPassword], [PersonKey]) VALUES (20, N'lamont@communityassist.org', N'tesspass', 28)

INSERT [customer].[RegisteredCustomer] ([RegisteredCustomerID], [Email], [CustomerPassword], [PersonKey]) VALUES (21, N'sara_johnson@mac.com', N'sjohnpass', 29)

INSERT [customer].[RegisteredCustomer] ([RegisteredCustomerID], [Email], [CustomerPassword], [PersonKey]) VALUES (22, N'farris@rainierconnect.com', N'fbdo', 34)

INSERT [customer].[RegisteredCustomer] ([RegisteredCustomerID], [Email], [CustomerPassword], [PersonKey]) VALUES (23, N'tfarmer@msn.com', N'farmerpass', 35)

INSERT [customer].[RegisteredCustomer] ([RegisteredCustomerID], [Email], [CustomerPassword], [PersonKey]) VALUES (24, N'lsanders@gmail.com', N'leapass', 36)

INSERT [customer].[RegisteredCustomer] ([RegisteredCustomerID], [Email], [CustomerPassword], [PersonKey]) VALUES (25, N'jimSmith@hotmail.com', N'smithpass', 37)

INSERT [customer].[RegisteredCustomer] ([RegisteredCustomerID], [Email], [CustomerPassword], [PersonKey]) VALUES (26, N'zukof@aol.com', N'petrapass', 38)

INSERT [customer].[RegisteredCustomer] ([RegisteredCustomerID], [Email], [CustomerPassword], [PersonKey]) VALUES (27, N'kk@southwestern.org', N'kkpass', 39)

INSERT [customer].[RegisteredCustomer] ([RegisteredCustomerID], [Email], [CustomerPassword], [PersonKey]) VALUES (28, N'tnorman@hotmail.com', N'tinapass', 40)

INSERT [customer].[RegisteredCustomer] ([RegisteredCustomerID], [Email], [CustomerPassword], [PersonKey]) VALUES (29, N'cmanning@gmail.com', N'cmpass', 41)

INSERT [customer].[RegisteredCustomer] ([RegisteredCustomerID], [Email], [CustomerPassword], [PersonKey]) VALUES (30, N'patton@gmail.com', N'laurapass', 42)

INSERT [customer].[RegisteredCustomer] ([RegisteredCustomerID], [Email], [CustomerPassword], [PersonKey]) VALUES (31, N'aj@morningstar.net', N'amypass', 43)

INSERT [customer].[RegisteredCustomer] ([RegisteredCustomerID], [Email], [CustomerPassword], [PersonKey]) VALUES (32, N'franz@aol.com', N'franzpass', 44)

INSERT [customer].[RegisteredCustomer] ([RegisteredCustomerID], [Email], [CustomerPassword], [PersonKey]) VALUES (33, N'superhero@gmail.com', N'lkpass', 45)

INSERT [customer].[RegisteredCustomer] ([RegisteredCustomerID], [Email], [CustomerPassword], [PersonKey]) VALUES (34, N'cherise@rogers.com', N'cherisepass', 50)

INSERT [customer].[RegisteredCustomer] ([RegisteredCustomerID], [Email], [CustomerPassword], [PersonKey]) VALUES (35, N'sueponge@gmail.com', N'pongepass', 51)

INSERT [customer].[RegisteredCustomer] ([RegisteredCustomerID], [Email], [CustomerPassword], [PersonKey]) VALUES (36, N'bartfart@simpsons.com', N'bfpass', 52)

SET IDENTITY_INSERT [customer].[RegisteredCustomer] OFF

/****** Object:  Table [Employee].[VehicleService]    Script Date: 06/28/2011 10:58:50 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [Employee].[VehicleService](

	[VehicleServiceID] [int] IDENTITY(1,1) NOT NULL,

	[VehicleID] [int] NULL,

	[LocationID] [int] NULL,

	[ServiceDate] [date] NOT NULL,

	[ServiceTime] [time](7) NOT NULL,

PRIMARY KEY CLUSTERED 

(

	[VehicleServiceID] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

SET IDENTITY_INSERT [Employee].[VehicleService] ON

INSERT [Employee].[VehicleService] ([VehicleServiceID], [VehicleID], [LocationID], [ServiceDate], [ServiceTime]) VALUES (3, 1, 1, CAST(0x80320B00 AS Date), CAST(0x070048F9F66C0000 AS Time))

INSERT [Employee].[VehicleService] ([VehicleServiceID], [VehicleID], [LocationID], [ServiceDate], [ServiceTime]) VALUES (4, 2, 2, CAST(0x81320B00 AS Date), CAST(0x070010ACD1530000 AS Time))

INSERT [Employee].[VehicleService] ([VehicleServiceID], [VehicleID], [LocationID], [ServiceDate], [ServiceTime]) VALUES (5, 3, 3, CAST(0x83320B00 AS Date), CAST(0x0700B0BD58750000 AS Time))

INSERT [Employee].[VehicleService] ([VehicleServiceID], [VehicleID], [LocationID], [ServiceDate], [ServiceTime]) VALUES (7, 5, 4, CAST(0x83320B00 AS Date), CAST(0x07007870335C0000 AS Time))

INSERT [Employee].[VehicleService] ([VehicleServiceID], [VehicleID], [LocationID], [ServiceDate], [ServiceTime]) VALUES (8, 6, 1, CAST(0x83320B00 AS Date), CAST(0x07007870335C0000 AS Time))

INSERT [Employee].[VehicleService] ([VehicleServiceID], [VehicleID], [LocationID], [ServiceDate], [ServiceTime]) VALUES (9, 7, 2, CAST(0x83320B00 AS Date), CAST(0x07007870335C0000 AS Time))

INSERT [Employee].[VehicleService] ([VehicleServiceID], [VehicleID], [LocationID], [ServiceDate], [ServiceTime]) VALUES (10, 8, 2, CAST(0x83320B00 AS Date), CAST(0x070048F9F66C0000 AS Time))

INSERT [Employee].[VehicleService] ([VehicleServiceID], [VehicleID], [LocationID], [ServiceDate], [ServiceTime]) VALUES (11, 9, 3, CAST(0x85320B00 AS Date), CAST(0x0700B0BD58750000 AS Time))

INSERT [Employee].[VehicleService] ([VehicleServiceID], [VehicleID], [LocationID], [ServiceDate], [ServiceTime]) VALUES (12, 10, 4, CAST(0x85320B00 AS Date), CAST(0x0700B0BD58750000 AS Time))

INSERT [Employee].[VehicleService] ([VehicleServiceID], [VehicleID], [LocationID], [ServiceDate], [ServiceTime]) VALUES (13, 11, 1, CAST(0x85320B00 AS Date), CAST(0x07001882BA7D0000 AS Time))

INSERT [Employee].[VehicleService] ([VehicleServiceID], [VehicleID], [LocationID], [ServiceDate], [ServiceTime]) VALUES (14, 11, 1, CAST(0x85320B00 AS Date), CAST(0x07001882BA7D0000 AS Time))

INSERT [Employee].[VehicleService] ([VehicleServiceID], [VehicleID], [LocationID], [ServiceDate], [ServiceTime]) VALUES (15, 12, 2, CAST(0x85320B00 AS Date), CAST(0x07001882BA7D0000 AS Time))

INSERT [Employee].[VehicleService] ([VehicleServiceID], [VehicleID], [LocationID], [ServiceDate], [ServiceTime]) VALUES (16, 13, 3, CAST(0x87320B00 AS Date), CAST(0x0700E03495640000 AS Time))

INSERT [Employee].[VehicleService] ([VehicleServiceID], [VehicleID], [LocationID], [ServiceDate], [ServiceTime]) VALUES (17, 14, 4, CAST(0x87320B00 AS Date), CAST(0x0700E03495640000 AS Time))

INSERT [Employee].[VehicleService] ([VehicleServiceID], [VehicleID], [LocationID], [ServiceDate], [ServiceTime]) VALUES (18, 15, 1, CAST(0x87320B00 AS Date), CAST(0x0700E03495640000 AS Time))

INSERT [Employee].[VehicleService] ([VehicleServiceID], [VehicleID], [LocationID], [ServiceDate], [ServiceTime]) VALUES (19, 16, 2, CAST(0x87320B00 AS Date), CAST(0x0700E03495640000 AS Time))

INSERT [Employee].[VehicleService] ([VehicleServiceID], [VehicleID], [LocationID], [ServiceDate], [ServiceTime]) VALUES (20, 17, 3, CAST(0x87320B00 AS Date), CAST(0x0700E03495640000 AS Time))

INSERT [Employee].[VehicleService] ([VehicleServiceID], [VehicleID], [LocationID], [ServiceDate], [ServiceTime]) VALUES (21, 18, 4, CAST(0x87320B00 AS Date), CAST(0x0700E03495640000 AS Time))

INSERT [Employee].[VehicleService] ([VehicleServiceID], [VehicleID], [LocationID], [ServiceDate], [ServiceTime]) VALUES (22, 19, 1, CAST(0x89320B00 AS Date), CAST(0x0700A8E76F4B0000 AS Time))

INSERT [Employee].[VehicleService] ([VehicleServiceID], [VehicleID], [LocationID], [ServiceDate], [ServiceTime]) VALUES (23, 20, 2, CAST(0x89320B00 AS Date), CAST(0x0700DCC9A04F0000 AS Time))

INSERT [Employee].[VehicleService] ([VehicleServiceID], [VehicleID], [LocationID], [ServiceDate], [ServiceTime]) VALUES (24, 21, 3, CAST(0x89320B00 AS Date), CAST(0x0700DCC9A04F0000 AS Time))

INSERT [Employee].[VehicleService] ([VehicleServiceID], [VehicleID], [LocationID], [ServiceDate], [ServiceTime]) VALUES (25, 22, 4, CAST(0x89320B00 AS Date), CAST(0x0700AC5264600000 AS Time))

INSERT [Employee].[VehicleService] ([VehicleServiceID], [VehicleID], [LocationID], [ServiceDate], [ServiceTime]) VALUES (26, 23, 1, CAST(0x89320B00 AS Date), CAST(0x07001417C6680000 AS Time))

INSERT [Employee].[VehicleService] ([VehicleServiceID], [VehicleID], [LocationID], [ServiceDate], [ServiceTime]) VALUES (27, 24, 2, CAST(0x89320B00 AS Date), CAST(0x07001417C6680000 AS Time))

INSERT [Employee].[VehicleService] ([VehicleServiceID], [VehicleID], [LocationID], [ServiceDate], [ServiceTime]) VALUES (28, 25, 3, CAST(0x89320B00 AS Date), CAST(0x07001417C6680000 AS Time))

INSERT [Employee].[VehicleService] ([VehicleServiceID], [VehicleID], [LocationID], [ServiceDate], [ServiceTime]) VALUES (29, 26, 4, CAST(0x8A320B00 AS Date), CAST(0x0700AC5264600000 AS Time))

INSERT [Employee].[VehicleService] ([VehicleServiceID], [VehicleID], [LocationID], [ServiceDate], [ServiceTime]) VALUES (30, 27, 1, CAST(0x8A320B00 AS Date), CAST(0x07007CDB27710000 AS Time))

INSERT [Employee].[VehicleService] ([VehicleServiceID], [VehicleID], [LocationID], [ServiceDate], [ServiceTime]) VALUES (31, 28, 2, CAST(0x8A320B00 AS Date), CAST(0x0700E49F89790000 AS Time))

INSERT [Employee].[VehicleService] ([VehicleServiceID], [VehicleID], [LocationID], [ServiceDate], [ServiceTime]) VALUES (32, 29, 3, CAST(0x8B320B00 AS Date), CAST(0x0700448E02580000 AS Time))

INSERT [Employee].[VehicleService] ([VehicleServiceID], [VehicleID], [LocationID], [ServiceDate], [ServiceTime]) VALUES (33, 30, 4, CAST(0x8B320B00 AS Date), CAST(0x0700448E02580000 AS Time))

INSERT [Employee].[VehicleService] ([VehicleServiceID], [VehicleID], [LocationID], [ServiceDate], [ServiceTime]) VALUES (34, 31, 1, CAST(0x8B320B00 AS Date), CAST(0x0700448E02580000 AS Time))

INSERT [Employee].[VehicleService] ([VehicleServiceID], [VehicleID], [LocationID], [ServiceDate], [ServiceTime]) VALUES (35, 32, 2, CAST(0x8B320B00 AS Date), CAST(0x0700448E02580000 AS Time))

INSERT [Employee].[VehicleService] ([VehicleServiceID], [VehicleID], [LocationID], [ServiceDate], [ServiceTime]) VALUES (36, 33, 3, CAST(0x8B320B00 AS Date), CAST(0x0700448E02580000 AS Time))

INSERT [Employee].[VehicleService] ([VehicleServiceID], [VehicleID], [LocationID], [ServiceDate], [ServiceTime]) VALUES (37, 34, 4, CAST(0x8B320B00 AS Date), CAST(0x0700448E02580000 AS Time))

INSERT [Employee].[VehicleService] ([VehicleServiceID], [VehicleID], [LocationID], [ServiceDate], [ServiceTime]) VALUES (38, 35, 1, CAST(0x8B320B00 AS Date), CAST(0x0700448E02580000 AS Time))

INSERT [Employee].[VehicleService] ([VehicleServiceID], [VehicleID], [LocationID], [ServiceDate], [ServiceTime]) VALUES (39, 36, 2, CAST(0x8D320B00 AS Date), CAST(0x0700AC5264600000 AS Time))

INSERT [Employee].[VehicleService] ([VehicleServiceID], [VehicleID], [LocationID], [ServiceDate], [ServiceTime]) VALUES (40, 37, 3, CAST(0x8D320B00 AS Date), CAST(0x0700AC5264600000 AS Time))

INSERT [Employee].[VehicleService] ([VehicleServiceID], [VehicleID], [LocationID], [ServiceDate], [ServiceTime]) VALUES (41, 37, 3, CAST(0x8D320B00 AS Date), CAST(0x0700E49F89790000 AS Time))

INSERT [Employee].[VehicleService] ([VehicleServiceID], [VehicleID], [LocationID], [ServiceDate], [ServiceTime]) VALUES (42, 38, 4, CAST(0x8D320B00 AS Date), CAST(0x0700E49F89790000 AS Time))

INSERT [Employee].[VehicleService] ([VehicleServiceID], [VehicleID], [LocationID], [ServiceDate], [ServiceTime]) VALUES (43, 39, 1, CAST(0x8E320B00 AS Date), CAST(0x0700DCC9A04F0000 AS Time))

INSERT [Employee].[VehicleService] ([VehicleServiceID], [VehicleID], [LocationID], [ServiceDate], [ServiceTime]) VALUES (44, 40, 2, CAST(0x8E320B00 AS Date), CAST(0x0700DCC9A04F0000 AS Time))

INSERT [Employee].[VehicleService] ([VehicleServiceID], [VehicleID], [LocationID], [ServiceDate], [ServiceTime]) VALUES (45, 41, 3, CAST(0x8E320B00 AS Date), CAST(0x0700DCC9A04F0000 AS Time))

INSERT [Employee].[VehicleService] ([VehicleServiceID], [VehicleID], [LocationID], [ServiceDate], [ServiceTime]) VALUES (46, 42, 4, CAST(0x8E320B00 AS Date), CAST(0x0700DCC9A04F0000 AS Time))

INSERT [Employee].[VehicleService] ([VehicleServiceID], [VehicleID], [LocationID], [ServiceDate], [ServiceTime]) VALUES (47, 43, 1, CAST(0x99320B00 AS Date), CAST(0x0700AC5264600000 AS Time))

INSERT [Employee].[VehicleService] ([VehicleServiceID], [VehicleID], [LocationID], [ServiceDate], [ServiceTime]) VALUES (48, 44, 2, CAST(0x99320B00 AS Date), CAST(0x0700AC5264600000 AS Time))

INSERT [Employee].[VehicleService] ([VehicleServiceID], [VehicleID], [LocationID], [ServiceDate], [ServiceTime]) VALUES (49, 45, 3, CAST(0x99320B00 AS Date), CAST(0x0700AC5264600000 AS Time))

INSERT [Employee].[VehicleService] ([VehicleServiceID], [VehicleID], [LocationID], [ServiceDate], [ServiceTime]) VALUES (50, 46, 4, CAST(0x99320B00 AS Date), CAST(0x0700AC5264600000 AS Time))

INSERT [Employee].[VehicleService] ([VehicleServiceID], [VehicleID], [LocationID], [ServiceDate], [ServiceTime]) VALUES (51, 1, 4, CAST(0xA7320B00 AS Date), CAST(0x0700448E02580000 AS Time))

INSERT [Employee].[VehicleService] ([VehicleServiceID], [VehicleID], [LocationID], [ServiceDate], [ServiceTime]) VALUES (52, 2, 1, CAST(0xA7320B00 AS Date), CAST(0x0700448E02580000 AS Time))

INSERT [Employee].[VehicleService] ([VehicleServiceID], [VehicleID], [LocationID], [ServiceDate], [ServiceTime]) VALUES (53, 5, 1, CAST(0xA7320B00 AS Date), CAST(0x0700448E02580000 AS Time))

INSERT [Employee].[VehicleService] ([VehicleServiceID], [VehicleID], [LocationID], [ServiceDate], [ServiceTime]) VALUES (54, 6, 1, CAST(0xA9320B00 AS Date), CAST(0x0700AC5264600000 AS Time))

INSERT [Employee].[VehicleService] ([VehicleServiceID], [VehicleID], [LocationID], [ServiceDate], [ServiceTime]) VALUES (55, 8, 2, CAST(0xA9320B00 AS Date), CAST(0x0700AC5264600000 AS Time))

INSERT [Employee].[VehicleService] ([VehicleServiceID], [VehicleID], [LocationID], [ServiceDate], [ServiceTime]) VALUES (56, 12, 2, CAST(0xA9320B00 AS Date), CAST(0x0700AC5264600000 AS Time))

INSERT [Employee].[VehicleService] ([VehicleServiceID], [VehicleID], [LocationID], [ServiceDate], [ServiceTime]) VALUES (57, 15, 3, CAST(0xB4320B00 AS Date), CAST(0x0700E49F89790000 AS Time))

INSERT [Employee].[VehicleService] ([VehicleServiceID], [VehicleID], [LocationID], [ServiceDate], [ServiceTime]) VALUES (58, 17, 2, CAST(0xB4320B00 AS Date), CAST(0x0700E49F89790000 AS Time))

INSERT [Employee].[VehicleService] ([VehicleServiceID], [VehicleID], [LocationID], [ServiceDate], [ServiceTime]) VALUES (59, 18, 3, CAST(0xB4320B00 AS Date), CAST(0x0700E49F89790000 AS Time))

INSERT [Employee].[VehicleService] ([VehicleServiceID], [VehicleID], [LocationID], [ServiceDate], [ServiceTime]) VALUES (60, 19, 4, CAST(0xB4320B00 AS Date), CAST(0x0700E49F89790000 AS Time))

INSERT [Employee].[VehicleService] ([VehicleServiceID], [VehicleID], [LocationID], [ServiceDate], [ServiceTime]) VALUES (61, 19, 4, CAST(0xB9320B00 AS Date), CAST(0x0700448E02580000 AS Time))

INSERT [Employee].[VehicleService] ([VehicleServiceID], [VehicleID], [LocationID], [ServiceDate], [ServiceTime]) VALUES (62, 1, 1, CAST(0xC4320B00 AS Date), CAST(0x0700448E02580000 AS Time))

INSERT [Employee].[VehicleService] ([VehicleServiceID], [VehicleID], [LocationID], [ServiceDate], [ServiceTime]) VALUES (63, 5, 2, CAST(0xC4320B00 AS Date), CAST(0x0700448E02580000 AS Time))

SET IDENTITY_INSERT [Employee].[VehicleService] OFF

/****** Object:  Table [Employee].[VehicleServiceDetail]    Script Date: 06/28/2011 10:58:50 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [Employee].[VehicleServiceDetail](

	[VSReferenceID] [int] IDENTITY(1,1) NOT NULL,

	[VehicleServiceID] [int] NULL,

	[AutoServiceID] [int] NULL,

	[DiscountPercent] [decimal](3, 2) NULL,

	[TaxPercent] [decimal](4, 3) NULL,

	[serviceNotes] [xml](CONTENT [dbo].[AutomartNotesSchema]) NULL,

PRIMARY KEY CLUSTERED 

(

	[VSReferenceID] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

SET IDENTITY_INSERT [Employee].[VehicleServiceDetail] ON

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (5, 3, 7, CAST(0.05 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>Routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (6, 3, 14, CAST(0.05 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>Routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (7, 4, 11, CAST(0.00 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>Routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (8, 4, 7, CAST(0.00 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>Routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (9, 5, 10, CAST(0.05 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>Routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (11, 7, 7, CAST(0.15 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>Routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (12, 8, 7, CAST(0.10 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>Weekly special rate</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (13, 9, 9, CAST(0.05 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>Radiator shows signs of rust and should be replaced soon</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (14, 10, 7, CAST(0.05 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>Routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (15, 11, 7, CAST(0.05 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>Routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (16, 12, 7, CAST(0.05 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>Routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (17, 12, 14, CAST(0.00 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>Routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (18, 13, 7, CAST(0.05 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>Routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (19, 14, 13, CAST(0.10 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>Had to order alternator. Took an extra 3 hours so discounted 10%</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (20, 15, 7, CAST(0.02 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>Routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (21, 15, 14, CAST(0.00 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>Routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (22, 16, 7, CAST(0.02 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>Routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (23, 17, 12, CAST(0.10 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>gaskets leaking and should be replaced</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (24, 17, 7, CAST(0.10 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>Routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (25, 18, 7, CAST(0.05 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>Severe dent in oil pan</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (26, 19, 15, CAST(0.20 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>total replacement</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (27, 20, 10, CAST(0.00 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (28, 21, 7, CAST(0.05 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (29, 21, 12, CAST(0.10 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>Routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (30, 22, 13, CAST(0.05 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (31, 23, 7, CAST(0.05 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (32, 24, 7, CAST(0.05 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (33, 24, 14, CAST(0.05 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>Routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (34, 25, 7, CAST(0.05 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (35, 26, 7, CAST(0.05 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (36, 27, 9, CAST(0.20 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>special discount</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (37, 28, 11, CAST(0.15 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>sRecommend timing belt replacement</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (38, 29, 7, CAST(0.15 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>special promotion price</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (39, 30, 7, CAST(0.15 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>special promotion price</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (40, 31, 7, CAST(0.15 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>special promotion price</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (41, 32, 7, CAST(0.05 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (42, 32, 14, CAST(0.05 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>Routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (43, 33, 7, CAST(0.05 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (44, 34, 7, CAST(0.05 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (45, 34, 14, CAST(0.05 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>Routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (46, 35, 13, CAST(0.15 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (47, 36, 7, CAST(0.15 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (48, 36, 14, CAST(0.05 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>Routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (49, 37, 11, CAST(0.15 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (50, 37, 14, CAST(0.05 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>Routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (51, 38, 7, CAST(0.05 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (52, 39, 7, CAST(0.05 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (53, 40, 7, CAST(0.05 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (54, 41, 7, CAST(0.05 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (55, 41, 14, CAST(0.05 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>Routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (56, 42, 7, CAST(0.05 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (57, 43, 10, CAST(0.05 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (58, 44, 10, CAST(0.05 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>Front tires bald should be replaced</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (59, 45, 10, CAST(0.05 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>Front tires bald should be replaced</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (60, 46, 7, CAST(0.05 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>Front tires bald should be replaced</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (61, 46, 14, CAST(0.05 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>Routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (62, 47, 7, CAST(0.05 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>Front tires bald should be replaced</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (63, 47, 14, CAST(0.05 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>Routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (64, 48, 7, CAST(0.05 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (65, 49, 7, CAST(0.05 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (66, 49, 14, CAST(0.05 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>Routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (67, 50, 7, CAST(0.05 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (68, 50, 14, CAST(0.05 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>Routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (69, 51, 7, CAST(0.05 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (70, 52, 12, CAST(0.15 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (71, 53, 7, CAST(0.15 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (72, 54, 11, CAST(0.15 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (73, 54, 14, CAST(0.05 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>Routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (74, 55, 11, CAST(0.15 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (75, 55, 14, CAST(0.05 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>Routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (76, 56, 11, CAST(0.15 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (77, 56, 14, CAST(0.05 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>Routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (78, 57, 7, CAST(0.05 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (79, 58, 7, CAST(0.05 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (80, 59, 7, CAST(0.05 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (81, 59, 14, CAST(0.05 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>Routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (82, 60, 12, CAST(0.05 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (83, 61, 12, CAST(0.05 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (84, 62, 12, CAST(0.05 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>routine</comment></Comments>')

INSERT [Employee].[VehicleServiceDetail] ([VSReferenceID], [VehicleServiceID], [AutoServiceID], [DiscountPercent], [TaxPercent], [serviceNotes]) VALUES (85, 63, 12, CAST(0.05 AS Decimal(3, 2)), CAST(0.090 AS Decimal(4, 3)), N'<Comments xmlns="http://www.automart.com/comments"><comment>routine</comment></Comments>')

SET IDENTITY_INSERT [Employee].[VehicleServiceDetail] OFF

/****** Object:  Default [DF__VehicleSe__Disco__239E4DCF]    Script Date: 06/28/2011 10:58:50 ******/

ALTER TABLE [Employee].[VehicleServiceDetail] ADD  DEFAULT ((0)) FOR [DiscountPercent]

GO

/****** Object:  Default [DF__VehicleSe__TaxPe__24927208]    Script Date: 06/28/2011 10:58:50 ******/

ALTER TABLE [Employee].[VehicleServiceDetail] ADD  DEFAULT ((0.095)) FOR [TaxPercent]

GO

/****** Object:  Check [CK__CustomerS__Ratin__25869641]    Script Date: 06/28/2011 10:58:50 ******/

ALTER TABLE [customer].[CustomerSurvey]  WITH CHECK ADD CHECK  (([rating]>=(0) AND [rating]<=(10)))

GO

/****** Object:  ForeignKey [FK__Employee__Locati__267ABA7A]    Script Date: 06/28/2011 10:58:50 ******/

ALTER TABLE [dbo].[Employee]  WITH CHECK ADD FOREIGN KEY([LocationID])

REFERENCES [customer].[Location] ([LocationID])

GO

/****** Object:  ForeignKey [FK__Employee__Person__145C0A3F]    Script Date: 06/28/2011 10:58:50 ******/

ALTER TABLE [dbo].[Employee]  WITH CHECK ADD  CONSTRAINT [FK__Employee__Person__145C0A3F] FOREIGN KEY([PersonKey])

REFERENCES [dbo].[Person] ([Personkey])

GO

ALTER TABLE [dbo].[Employee] CHECK CONSTRAINT [FK__Employee__Person__145C0A3F]

GO

/****** Object:  ForeignKey [FK__Employee__Superv__286302EC]    Script Date: 06/28/2011 10:58:50 ******/

ALTER TABLE [dbo].[Employee]  WITH CHECK ADD FOREIGN KEY([SupervisorID])

REFERENCES [dbo].[Employee] ([EmployeeID])

GO

/****** Object:  ForeignKey [FK__CustomerS__Locat__29572725]    Script Date: 06/28/2011 10:58:50 ******/

ALTER TABLE [customer].[CustomerSurvey]  WITH CHECK ADD FOREIGN KEY([LocationID])

REFERENCES [customer].[Location] ([LocationID])

GO

/****** Object:  ForeignKey [FK__vehicle__PersonK__0F975522]    Script Date: 06/28/2011 10:58:50 ******/

ALTER TABLE [customer].[vehicle]  WITH CHECK ADD  CONSTRAINT [FK__vehicle__PersonK__0F975522] FOREIGN KEY([PersonKey])

REFERENCES [dbo].[Person] ([Personkey])

GO

ALTER TABLE [customer].[vehicle] CHECK CONSTRAINT [FK__vehicle__PersonK__0F975522]

GO

/****** Object:  ForeignKey [FK__Registere__Perso__1DE57479]    Script Date: 06/28/2011 10:58:50 ******/

ALTER TABLE [customer].[RegisteredCustomer]  WITH CHECK ADD  CONSTRAINT [FK__Registere__Perso__1DE57479] FOREIGN KEY([PersonKey])

REFERENCES [dbo].[Person] ([Personkey])

GO

ALTER TABLE [customer].[RegisteredCustomer] CHECK CONSTRAINT [FK__Registere__Perso__1DE57479]

GO

/****** Object:  ForeignKey [FK__VehicleSe__Locat__2C3393D0]    Script Date: 06/28/2011 10:58:50 ******/

ALTER TABLE [Employee].[VehicleService]  WITH CHECK ADD FOREIGN KEY([LocationID])

REFERENCES [customer].[Location] ([LocationID])

GO

/****** Object:  ForeignKey [FK_VehicleService_vehicle]    Script Date: 06/28/2011 10:58:50 ******/

ALTER TABLE [Employee].[VehicleService]  WITH CHECK ADD  CONSTRAINT [FK_VehicleService_vehicle] FOREIGN KEY([VehicleID])

REFERENCES [customer].[vehicle] ([VehicleId])

GO

ALTER TABLE [Employee].[VehicleService] CHECK CONSTRAINT [FK_VehicleService_vehicle]

GO

/****** Object:  ForeignKey [FK__VehicleSe__AutoS__2D27B809]    Script Date: 06/28/2011 10:58:50 ******/

ALTER TABLE [Employee].[VehicleServiceDetail]  WITH CHECK ADD FOREIGN KEY([AutoServiceID])

REFERENCES [customer].[AutoService] ([AutoServiceID])

GO

/****** Object:  ForeignKey [FK__VehicleSe__Vehic__2E1BDC42]    Script Date: 06/28/2011 10:58:50 ******/

ALTER TABLE [Employee].[VehicleServiceDetail]  WITH CHECK ADD FOREIGN KEY([VehicleServiceID])

REFERENCES [Employee].[VehicleService] ([VehicleServiceID])

GO