USE [master]
GO
/****** Object: Database [vLocations] Script Date: 09/12/2021 09:21:49 ******/
CREATE DATABASE [vLocations]
CONTAINMENT = NONE
ON PRIMARY
( NAME = N'vLocations', FILENAME = N'C:\Program Files\Microsoft SQL
Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\vLocations.mdf' , SIZE = 8192KB , MAXSIZE =
UNLIMITED, FILEGROWTH = 65536KB )
LOG ON
( NAME = N'vLocations_log', FILENAME = N'C:\Program Files\Microsoft SQL
Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\vLocations_log.ldf' , SIZE = 8192KB , MAXSIZE
= 2048GB , FILEGROWTH = 65536KB )
WITH CATALOG_COLLATION = DATABASE_DEFAULT
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [vLocations].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [vLocations] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [vLocations] SET ANSI_NULLS OFF
GO
ALTER DATABASE [vLocations] SET ANSI_PADDING OFF
GO
ALTER DATABASE [vLocations] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [vLocations] SET ARITHABORT OFF
GO
ALTER DATABASE [vLocations] SET AUTO_CLOSE OFF
GO
ALTER DATABASE [vLocations] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [vLocations] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [vLocations] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [vLocations] SET CURSOR_DEFAULT GLOBAL
GO
ALTER DATABASE [vLocations] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [vLocations] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [vLocations] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [vLocations] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [vLocations] SET DISABLE_BROKER
GO
ALTER DATABASE [vLocations] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [vLocations] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [vLocations] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [vLocations] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [vLocations] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [vLocations] SET READ_COMMITTED_SNAPSHOT OFF
GO
ALTER DATABASE [vLocations] SET HONOR_BROKER_PRIORITY OFF
GO
ALTER DATABASE [vLocations] SET RECOVERY FULL
GO
ALTER DATABASE [vLocations] SET MULTI_USER
GO
ALTER DATABASE [vLocations] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [vLocations] SET DB_CHAINING OFF
GO
ALTER DATABASE [vLocations] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF )
GO
ALTER DATABASE [vLocations] SET TARGET_RECOVERY_TIME = 60 SECONDS
GO
ALTER DATABASE [vLocations] SET DELAYED_DURABILITY = DISABLED
GO
ALTER DATABASE [vLocations] SET ACCELERATED_DATABASE_RECOVERY = OFF
GO
ALTER DATABASE [vLocations] SET QUERY_STORE = OFF
GO
ALTER DATABASE [vLocations] SET READ_WRITE
GO
USE [vLocations]
GO
/****** Object: Table [dbo].[marque] Script Date: 09/12/2021 09:22:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[marque](
[N°marque] [int] IDENTITY(1,1) NOT NULL,
[Marque] [varchar](80) NOT NULL,
CONSTRAINT [PK_marque] PRIMARY KEY CLUSTERED
(
[N°marque] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,
ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON
[PRIMARY]
) ON [PRIMARY]
GO
USE [vLocations]
GO
/****** Object: Table [dbo].[modele] Script Date: 09/12/2021 09:22:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[modele](
[N°modele] [int] IDENTITY(1,1) NOT NULL,
[modele] [varchar](80) NOT NULL,
CONSTRAINT [PK_modele] PRIMARY KEY CLUSTERED
(
[N°modele] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,
ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON
[PRIMARY]
) ON [PRIMARY]
GO
USE [vLocations]
GO
/****** Object: Table [dbo].[client] Script Date: 09/12/2021 09:23:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[client](
[N°client] [int] IDENTITY(1,1) NOT NULL,
[nationnalite] [varchar](60) NOT NULL,
[N°passeport] [varchar](50) NULL,
[date naissance] [date] NOT NULL,
[N°CIN] [varchar](30) NULL,
[date CIN_fin] [date] NULL,
[N°permis] [varchar](30) NOT NULL,
[date obtention] [date] NOT NULL,
[date validite] [date] NOT NULL,
[tel] [varchar](40) NOT NULL,
[adresse] [varchar](150) NULL,
[nom prenom] [varchar](80) NULL,
CONSTRAINT [PK_client] PRIMARY KEY CLUSTERED
(
[N°client] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,
ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON
[PRIMARY]
) ON [PRIMARY]
GO
USE [vLocations]
GO
/****** Object: Table [dbo].[voiture] Script Date: 09/12/2021 09:23:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[voiture](
[N°voiture] [int] IDENTITY(1,1) NOT NULL,
[N°marque] [int] NOT NULL,
[N°modele] [int] NOT NULL,
[matricule] [varchar](40) NOT NULL,
[carburant] [varchar](30) NOT NULL,
[date sortie] [date] NOT NULL,
[option] [varchar](100) NOT NULL,
[vitesse] [varchar](30) NOT NULL,
[coleur] [varchar](60) NOT NULL,
[km] [int] NOT NULL,
[prix] [int] NOT NULL,
[etat] [varchar](60) NOT NULL,
[disponible] [varchar](60) NOT NULL,
CONSTRAINT [PK_voiture] PRIMARY KEY CLUSTERED
(
[N°voiture] ASC,
[N°marque] ASC,
[N°modele] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,
ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON
[PRIMARY]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[voiture] WITH CHECK ADD CONSTRAINT [FK_voiture_marque] FOREIGN
KEY([N°marque])
REFERENCES [dbo].[marque] ([N°marque])
GO
ALTER TABLE [dbo].[voiture] CHECK CONSTRAINT [FK_voiture_marque]
GO
ALTER TABLE [dbo].[voiture] WITH CHECK ADD CONSTRAINT [FK_voiture_modele] FOREIGN
KEY([N°modele])
REFERENCES [dbo].[modele] ([N°modele])
GO
ALTER TABLE [dbo].[voiture] CHECK CONSTRAINT [FK_voiture_modele]
GO
