ÿþSET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Customer]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[Customer](

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

	[FirstName] [nvarchar](50) NOT NULL,

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

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

 CONSTRAINT [PK_Customer] PRIMARY KEY CLUSTERED 

(

	[Id] ASC

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

) ON [PRIMARY]

END

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CustomerInquiry]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[CustomerInquiry](

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

	[CustomerId] [int] NOT NULL,

	[Days] [int] NOT NULL,

	[StartDate] [datetime] NOT NULL,

	[NumberOfAdults] [int] NULL,

	[NumberOfChildren] [int] NULL,

	[Destination] [nvarchar](50) NULL,

	[OtherRequests] [text] NULL,

 CONSTRAINT [PK_CustomerInquiry] PRIMARY KEY CLUSTERED 

(

	[Id] ASC

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

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

END

GO

IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_CustomerInquiry_Customer]') AND parent_object_id = OBJECT_ID(N'[dbo].[CustomerInquiry]'))

ALTER TABLE [dbo].[CustomerInquiry]  WITH CHECK ADD  CONSTRAINT [FK_CustomerInquiry_Customer] FOREIGN KEY([CustomerId])

REFERENCES [dbo].[Customer] ([Id])

GO

ALTER TABLE [dbo].[CustomerInquiry] CHECK CONSTRAINT [FK_CustomerInquiry_Customer]