USE [Zawada]
GO
/****** Object:  User [administrator]    Script Date: 11/21/2017 11:18:58 ******/
IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'administrator')
CREATE USER [administrator] FOR LOGIN [administrator] WITH DEFAULT_SCHEMA=[dbo]
GO
/****** Object:  User [bank]    Script Date: 11/21/2017 11:18:58 ******/
IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'bank')
CREATE USER [bank] FOR LOGIN [bank] WITH DEFAULT_SCHEMA=[dbo]
GO
/****** Object:  User [customer]    Script Date: 11/21/2017 11:18:58 ******/
IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'customer')
CREATE USER [customer] FOR LOGIN [customer] WITH DEFAULT_SCHEMA=[dbo]
GO
/****** Object:  User [klient]    Script Date: 11/21/2017 11:18:58 ******/
IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'klient')
CREATE USER [klient] FOR LOGIN [klient] WITH DEFAULT_SCHEMA=[dbo]
GO
/****** Object:  User [sales]    Script Date: 11/21/2017 11:18:58 ******/
IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'sales')
CREATE USER [sales] FOR LOGIN [sales] WITH DEFAULT_SCHEMA=[dbo]
GO
/****** Object:  User [zawada]    Script Date: 11/21/2017 11:18:58 ******/
IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'zawada')
CREATE USER [zawada] FOR LOGIN [zawada] WITH DEFAULT_SCHEMA=[dbo]
GO
/****** Object:  Schema [emp]    Script Date: 11/21/2017 11:18:58 ******/
IF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = N'emp')
EXEC sys.sp_executesql N'CREATE SCHEMA [emp] AUTHORIZATION [dbo]'
GO
/****** Object:  Schema [ManageCar]    Script Date: 11/21/2017 11:18:58 ******/
IF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = N'ManageCar')
EXEC sys.sp_executesql N'CREATE SCHEMA [ManageCar] AUTHORIZATION [administrator]'
GO
/****** Object:  Table [dbo].[Logs]    Script Date: 11/21/2017 11:18:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Logs]') AND TYPE IN (N'U'))
BEGIN
CREATE TABLE [dbo].[Logs](
    [customer_id] [INT] NULL,
    [mobile_phone] [INT] NULL,
    [userID] [VARCHAR](50) NULL
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Car_Loans]    Script Date: 11/21/2017 11:18:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Car_Loans]') AND TYPE IN (N'U'))
BEGIN
CREATE TABLE [dbo].[Car_Loans](
    [loan_id] [INT] NOT NULL,
    [customer_payment_id] [INT] NOT NULL,
    [loan_amount] [DECIMAL](11, 2) NULL,
 CONSTRAINT [PK_Car_Loans_1] PRIMARY KEY CLUSTERED
(
    [loan_id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Car_Loans]') AND name = N'loan_amount_index')
CREATE NONCLUSTERED INDEX [loan_amount_index] ON [dbo].[Car_Loans]
(
    [loan_amount] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 20) ON [PRIMARY]
GO
INSERT [dbo].[Car_Loans] ([loan_id], [customer_payment_id], [loan_amount]) VALUES (1, 1, CAST(10.12 AS DECIMAL(11, 2)))
/****** Object:  Table [ManageCar].[Car_Categories]    Script Date: 11/21/2017 11:18:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[ManageCar].[Car_Categories]') AND TYPE IN (N'U'))
BEGIN
CREATE TABLE [ManageCar].[Car_Categories](
    [car_categories_id] [INT] NOT NULL,
    [car_description] [VARCHAR](255) NULL,
 CONSTRAINT [PK_Car_Categories] PRIMARY KEY CLUSTERED
(
    [car_categories_id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
INSERT [ManageCar].[Car_Categories] ([car_categories_id], [car_description]) VALUES (1, N'sedan')
INSERT [ManageCar].[Car_Categories] ([car_categories_id], [car_description]) VALUES (2, N'kombi')
INSERT [ManageCar].[Car_Categories] ([car_categories_id], [car_description]) VALUES (3, N'suv')
/****** Object:  Table [dbo].[Customers]    Script Date: 11/21/2017 11:18:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Customers]') AND TYPE IN (N'U'))
BEGIN
CREATE TABLE [dbo].[Customers](
    [customer_id] [INT] NOT NULL,
    [mobile_phone] [INT] NULL,
    [email_address] [VARCHAR](255) NULL,
    [first_name] [VARCHAR](50) NULL,
    [last_name] [VARCHAR](50) NULL,
 CONSTRAINT [PK_Customers] PRIMARY KEY CLUSTERED
(
    [customer_id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Customers]') AND name = N'customer_id_first_last_name_index')
CREATE UNIQUE NONCLUSTERED INDEX [customer_id_first_last_name_index] ON [dbo].[Customers]
(
    [customer_id] ASC,
    [first_name] ASC,
    [last_name] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 20) ON [PRIMARY]
GO
INSERT [dbo].[Customers] ([customer_id], [mobile_phone], [email_address], [first_name], [last_name]) VALUES (1, 123123123, N'test_1@test.com', N'Piotr', N'Zawada')
INSERT [dbo].[Customers] ([customer_id], [mobile_phone], [email_address], [first_name], [last_name]) VALUES (2, 123456789, N'test_2@test.com', N'Pawel', N'Kordos')
INSERT [dbo].[Customers] ([customer_id], [mobile_phone], [email_address], [first_name], [last_name]) VALUES (3, 987654321, N'test_3@test.com', N'Dominik', N'Jakubiak')
INSERT [dbo].[Customers] ([customer_id], [mobile_phone], [email_address], [first_name], [last_name]) VALUES (222, 123321456, N'test+222@test.com', N'Janusz', N'Biznesu')
/****** Object:  Table [ManageCar].[Car_Models]    Script Date: 11/21/2017 11:18:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[ManageCar].[Car_Models]') AND TYPE IN (N'U'))
BEGIN
CREATE TABLE [ManageCar].[Car_Models](
    [modal_id] [INT] NOT NULL,
    [modal_name] [VARCHAR](50) NOT NULL,
    [car_categories_ID] [INT] NOT NULL,
 CONSTRAINT [PK_Car_Models] PRIMARY KEY CLUSTERED
(
    [modal_id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[ManageCar].[Car_Models]') AND name = N'modal_name_index')
CREATE NONCLUSTERED INDEX [modal_name_index] ON [ManageCar].[Car_Models]
(
    [modal_name] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 20) ON [PRIMARY]
GO
INSERT [ManageCar].[Car_Models] ([modal_id], [modal_name], [car_categories_ID]) VALUES (103, N'a3', 1)
INSERT [ManageCar].[Car_Models] ([modal_id], [modal_name], [car_categories_ID]) VALUES (105, N'Q3', 3)
INSERT [ManageCar].[Car_Models] ([modal_id], [modal_name], [car_categories_ID]) VALUES (204, N'a4', 2)
INSERT [ManageCar].[Car_Models] ([modal_id], [modal_name], [car_categories_ID]) VALUES (606, N'Q7', 1)
/****** Object:  Trigger [LoanIDTrigger]    Script Date: 11/21/2017 11:18:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.triggers WHERE object_id = OBJECT_ID(N'[dbo].[LoanIDTrigger]'))
EXEC dbo.sp_executesql @statement = N'CREATE TRIGGER [dbo].[LoanIDTrigger] ON [dbo].[Car_Loans]
AFTER INSERT, UPDATE
AS
IF EXISTS (
    SELECT *
    FROM dbo.Car_Loans loan
    JOIN inserted AS ins ON loan.loan_id = ins.loan_id
    WHERE loan.loan_id NOT LIKE ''[^0-9]''
)

BEGIN
    RAISERROR (''Pozyczka o podanym id istnieje'', 10, 1);
    ROLLBACK TRANSACTION;
    RETURN
END;
'
GO
/****** Object:  Trigger [DeleteCustomerLog]    Script Date: 11/21/2017 11:18:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.triggers WHERE object_id = OBJECT_ID(N'[dbo].[DeleteCustomerLog]'))
EXEC dbo.sp_executesql @statement = N'
CREATE TRIGGER [dbo].[DeleteCustomerLog] ON [dbo].[Customers]
FOR DELETE
AS
BEGIN
    INSERT INTO Logs (customer_id, mobile_phone,userID)
    SELECT  del.customer_id AS ''customer_id'',
            del.mobile_phone AS ''mobile_phone'',
            SYSTEM_USER AS ''userID''
    FROM Deleted del

END
'
GO
/****** Object:  Table [dbo].[Cars]    Script Date: 11/21/2017 11:18:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Cars]') AND TYPE IN (N'U'))
BEGIN
CREATE TABLE [dbo].[Cars](
    [car_id] [INT] NOT NULL,
    [sold_id] [INT] NOT NULL,
    [modal_id] [INT] NOT NULL,
 CONSTRAINT [PK_Cars] PRIMARY KEY CLUSTERED
(
    [car_id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
INSERT [dbo].[Cars] ([car_id], [sold_id], [modal_id]) VALUES (1, 1, 103)
INSERT [dbo].[Cars] ([car_id], [sold_id], [modal_id]) VALUES (2, 1, 103)
INSERT [dbo].[Cars] ([car_id], [sold_id], [modal_id]) VALUES (3, 0, 105)
INSERT [dbo].[Cars] ([car_id], [sold_id], [modal_id]) VALUES (4, 1, 204)
INSERT [dbo].[Cars] ([car_id], [sold_id], [modal_id]) VALUES (9901, 0, 606)
/****** Object:  StoredProcedure [dbo].[NewCLient]    Script Date: 11/21/2017 11:18:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[NewCLient]') AND TYPE IN (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[NewCLient]
@ClientID int,
@MobilePhone int,
@EmailAddress varchar(255),
@FirstName varchar(50),
@LastName varchar(50)
AS
BEGIN
INSERT INTO dbo.Customers(customer_id, mobile_phone, email_address, first_name, last_name)
VALUES
(@ClientID, @MobilePhone, @EmailAddress, @FirstName, @LastName)
END'
END
GO
/****** Object:  Table [dbo].[Addresses]    Script Date: 11/21/2017 11:18:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Addresses]') AND TYPE IN (N'U'))
BEGIN
CREATE TABLE [dbo].[Addresses](
    [address_id] [INT] NOT NULL,
    [customer_id] [INT] NOT NULL,
    [address_data] [VARCHAR](255) NULL,
 CONSTRAINT [PK_Addresses] PRIMARY KEY CLUSTERED
(
    [address_id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
INSERT [dbo].[Addresses] ([address_id], [customer_id], [address_data]) VALUES (1, 1, N'Warszawa 22-222 Testowa 1')
INSERT [dbo].[Addresses] ([address_id], [customer_id], [address_data]) VALUES (2, 2, N'Warszawa 22-222 Testowa 2')
INSERT [dbo].[Addresses] ([address_id], [customer_id], [address_data]) VALUES (3, 3, N'Warszawa 22-222 Testowa 3')
/****** Object:  Table [ManageCar].[Car_Feature]    Script Date: 11/21/2017 11:18:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[ManageCar].[Car_Feature]') AND TYPE IN (N'U'))
BEGIN
CREATE TABLE [ManageCar].[Car_Feature](
    [car_feature_id] [INT] NOT NULL,
    [modal_id] [INT] NOT NULL,
    [car_feature_desc] [VARCHAR](50) NOT NULL,
 CONSTRAINT [PK_Car_Feature] PRIMARY KEY CLUSTERED
(
    [car_feature_id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[ManageCar].[Car_Feature]') AND name = N'feature_id_desc_index')
CREATE NONCLUSTERED INDEX [feature_id_desc_index] ON [ManageCar].[Car_Feature]
(
    [car_feature_id] ASC,
    [car_feature_desc] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 20) ON [PRIMARY]
GO
INSERT [ManageCar].[Car_Feature] ([car_feature_id], [modal_id], [car_feature_desc]) VALUES (1, 103, N'nawigacja')
INSERT [ManageCar].[Car_Feature] ([car_feature_id], [modal_id], [car_feature_desc]) VALUES (2, 204, N'relingi')
INSERT [ManageCar].[Car_Feature] ([car_feature_id], [modal_id], [car_feature_desc]) VALUES (3, 105, N'podwyzszone zawieszenie')
/****** Object:  Trigger [CustomerPhoneLength]    Script Date: 11/21/2017 11:18:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.triggers WHERE object_id = OBJECT_ID(N'[dbo].[CustomerPhoneLength]'))
EXEC dbo.sp_executesql @statement = N'
CREATE TRIGGER [dbo].[CustomerPhoneLength] ON [dbo].[Customers]
AFTER INSERT, UPDATE
AS
IF EXISTS (
    SELECT *
    FROM dbo.Customers customer
    JOIN inserted AS ins ON customer.mobile_phone = ins.mobile_phone
    WHERE len(customer.mobile_phone) < 9
)

BEGIN
    RAISERROR (''Numer musi posiadać minimum 9 cyfr'', 10, 1)
    ROLLBACK TRANSACTION;
    RETURN
END;
'
GO
/****** Object:  Table [dbo].[Customer_Payment]    Script Date: 11/21/2017 11:18:57 ******/
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_Payment]') AND TYPE IN (N'U'))
BEGIN
CREATE TABLE [dbo].[Customer_Payment](
    [customer_payment_id] [INT] NOT NULL,
    [customer_id] [INT] NOT NULL,
    [car_id] [INT] NULL,
 CONSTRAINT [PK_Customer_Payment] PRIMARY KEY CLUSTERED
(
    [customer_payment_id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Customer_Payment]') AND name = N'IX_Customer_Payment')
CREATE NONCLUSTERED INDEX [IX_Customer_Payment] ON [dbo].[Customer_Payment]
(
    [customer_payment_id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 20) ON [PRIMARY]
GO
INSERT [dbo].[Customer_Payment] ([customer_payment_id], [customer_id], [car_id]) VALUES (1, 1, 1)
INSERT [dbo].[Customer_Payment] ([customer_payment_id], [customer_id], [car_id]) VALUES (2, 2, 2)
INSERT [dbo].[Customer_Payment] ([customer_payment_id], [customer_id], [car_id]) VALUES (3, 3, 3)
/****** Object:  Table [dbo].[Cars_conept]    Script Date: 11/21/2017 11:18:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Cars_conept]') AND TYPE IN (N'U'))
BEGIN
CREATE TABLE [dbo].[Cars_conept](
    [car_id] [INT] NOT NULL,
    [prototype_name] [VARCHAR](50) NOT NULL,
    [prototype_desc] [text] NULL,
 CONSTRAINT [PK_Cars_conept] PRIMARY KEY CLUSTERED
(
    [car_id] ASC,
    [prototype_name] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
INSERT [dbo].[Cars_conept] ([car_id], [prototype_name], [prototype_desc]) VALUES (9901, N'Q7', N'bigger than q5')
/****** Object:  View [dbo].[PlatnoscKlientow]    Script Date: 11/21/2017 11:18:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[PlatnoscKlientow]'))
EXEC dbo.sp_executesql @statement = N'CREATE VIEW [dbo].[PlatnoscKlientow] AS
SELECT Car_Loans.loan_amount
FROM Customer_Payment ,Car_Loans
WHERE  Customer_Payment.customer_payment_id= Car_Loans.customer_payment_id;
'
GO
/****** Object:  ForeignKey [FK_Addresses_Customers]    Script Date: 11/21/2017 11:18:57 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Addresses_Customers]') AND parent_object_id = OBJECT_ID(N'[dbo].[Addresses]'))
ALTER TABLE [dbo].[Addresses]  WITH CHECK ADD  CONSTRAINT [FK_Addresses_Customers] FOREIGN KEY([customer_id])
REFERENCES [dbo].[Customers] ([customer_id])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Addresses_Customers]') AND parent_object_id = OBJECT_ID(N'[dbo].[Addresses]'))
ALTER TABLE [dbo].[Addresses] CHECK CONSTRAINT [FK_Addresses_Customers]
GO
/****** Object:  ForeignKey [FK_Cars_Car_Models]    Script Date: 11/21/2017 11:18:57 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Cars_Car_Models]') AND parent_object_id = OBJECT_ID(N'[dbo].[Cars]'))
ALTER TABLE [dbo].[Cars]  WITH CHECK ADD  CONSTRAINT [FK_Cars_Car_Models] FOREIGN KEY([modal_id])
REFERENCES [ManageCar].[Car_Models] ([modal_id])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Cars_Car_Models]') AND parent_object_id = OBJECT_ID(N'[dbo].[Cars]'))
ALTER TABLE [dbo].[Cars] CHECK CONSTRAINT [FK_Cars_Car_Models]
GO
/****** Object:  ForeignKey [FK_Cars_conept_Cars]    Script Date: 11/21/2017 11:18:57 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Cars_conept_Cars]') AND parent_object_id = OBJECT_ID(N'[dbo].[Cars_conept]'))
ALTER TABLE [dbo].[Cars_conept]  WITH CHECK ADD  CONSTRAINT [FK_Cars_conept_Cars] FOREIGN KEY([car_id])
REFERENCES [dbo].[Cars] ([car_id])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Cars_conept_Cars]') AND parent_object_id = OBJECT_ID(N'[dbo].[Cars_conept]'))
ALTER TABLE [dbo].[Cars_conept] CHECK CONSTRAINT [FK_Cars_conept_Cars]
GO
/****** Object:  ForeignKey [FK_Customer_Payment_Cars]    Script Date: 11/21/2017 11:18:57 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Customer_Payment_Cars]') AND parent_object_id = OBJECT_ID(N'[dbo].[Customer_Payment]'))
ALTER TABLE [dbo].[Customer_Payment]  WITH CHECK ADD  CONSTRAINT [FK_Customer_Payment_Cars] FOREIGN KEY([car_id])
REFERENCES [dbo].[Cars] ([car_id])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Customer_Payment_Cars]') AND parent_object_id = OBJECT_ID(N'[dbo].[Customer_Payment]'))
ALTER TABLE [dbo].[Customer_Payment] CHECK CONSTRAINT [FK_Customer_Payment_Cars]
GO
/****** Object:  ForeignKey [FK_Customer_Payment_Customers]    Script Date: 11/21/2017 11:18:57 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Customer_Payment_Customers]') AND parent_object_id = OBJECT_ID(N'[dbo].[Customer_Payment]'))
ALTER TABLE [dbo].[Customer_Payment]  WITH CHECK ADD  CONSTRAINT [FK_Customer_Payment_Customers] FOREIGN KEY([customer_id])
REFERENCES [dbo].[Customers] ([customer_id])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Customer_Payment_Customers]') AND parent_object_id = OBJECT_ID(N'[dbo].[Customer_Payment]'))
ALTER TABLE [dbo].[Customer_Payment] CHECK CONSTRAINT [FK_Customer_Payment_Customers]
GO
/****** Object:  ForeignKey [FK_Car_Feature_Car_Feature]    Script Date: 11/21/2017 11:18:57 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[ManageCar].[FK_Car_Feature_Car_Feature]') AND parent_object_id = OBJECT_ID(N'[ManageCar].[Car_Feature]'))
ALTER TABLE [ManageCar].[Car_Feature]  WITH CHECK ADD  CONSTRAINT [FK_Car_Feature_Car_Feature] FOREIGN KEY([modal_id])
REFERENCES [ManageCar].[Car_Models] ([modal_id])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[ManageCar].[FK_Car_Feature_Car_Feature]') AND parent_object_id = OBJECT_ID(N'[ManageCar].[Car_Feature]'))
ALTER TABLE [ManageCar].[Car_Feature] CHECK CONSTRAINT [FK_Car_Feature_Car_Feature]
GO
/****** Object:  ForeignKey [FK_Car_Models_Car_Categories]    Script Date: 11/21/2017 11:18:57 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[ManageCar].[FK_Car_Models_Car_Categories]') AND parent_object_id = OBJECT_ID(N'[ManageCar].[Car_Models]'))
ALTER TABLE [ManageCar].[Car_Models]  WITH CHECK ADD  CONSTRAINT [FK_Car_Models_Car_Categories] FOREIGN KEY([car_categories_ID])
REFERENCES [ManageCar].[Car_Categories] ([car_categories_id])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[ManageCar].[FK_Car_Models_Car_Categories]') AND parent_object_id = OBJECT_ID(N'[ManageCar].[Car_Models]'))
ALTER TABLE [ManageCar].[Car_Models] CHECK CONSTRAINT [FK_Car_Models_Car_Categories]
GO