[SABER_ZINOUBI]

كود :

USE [master]
GO
/****** Object:  Database [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF]    Script Date: 2020/11/09 21:06:16 ******/
CREATE DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF]
CONTAINMENT = NONE
ON  PRIMARY
( NAME = N'Dtbase', FILENAME = N'C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF' , SIZE = 8192KB , MAXSIZE = UNLIMITED, FILEGROWTH = 65536KB )
LOG ON
( NAME = N'Dtbase_log', FILENAME = N'C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\landrydata_log.ldf' , SIZE = 768KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10%)
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET COMPATIBILITY_LEVEL = 130
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET ANSI_NULLS OFF
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET ANSI_PADDING OFF
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET ARITHABORT OFF
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET AUTO_CLOSE ON
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET AUTO_SHRINK ON
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET CURSOR_DEFAULT  GLOBAL
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET  DISABLE_BROKER
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET READ_COMMITTED_SNAPSHOT OFF
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET HONOR_BROKER_PRIORITY OFF
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET RECOVERY SIMPLE
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET  MULTI_USER
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET PAGE_VERIFY CHECKSUM  
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET DB_CHAINING OFF
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF )
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET TARGET_RECOVERY_TIME = 60 SECONDS
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET DELAYED_DURABILITY = DISABLED
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET QUERY_STORE = OFF
GO
USE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF]
GO
ALTER DATABASE SCOPED CONFIGURATION SET LEGACY_CARDINALITY_ESTIMATION = OFF;
GO
ALTER DATABASE SCOPED CONFIGURATION SET MAXDOP = 0;
GO
ALTER DATABASE SCOPED CONFIGURATION SET PARAMETER_SNIFFING = ON;
GO
ALTER DATABASE SCOPED CONFIGURATION SET QUERY_OPTIMIZER_HOTFIXES = OFF;
GO
USE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF]
GO
/****** Object:  Table [dbo].[Article]    Script Date: 2020/11/09 21:06:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Article](
    [id] [int] IDENTITY(1,1) NOT NULL,
    [ref_article] [nvarchar](50) NOT NULL,
    [nom_article_arabe] [nvarchar](50) NULL,
    [nom_article_english] [nvarchar](50) NOT NULL,
    [ref_unite] [nvarchar](50) NOT NULL,
    [type_article] [int] NOT NULL,
CONSTRAINT [PK_Article] PRIMARY KEY CLUSTERED
(
    [ref_article] 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 [dbo].[clients]    Script Date: 2020/11/09 21:06:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[clients](
    [id] [int] IDENTITY(1,1) NOT NULL,
    [ref_client] [nvarchar](50) NOT NULL,
    [nom_client] [nvarchar](50) NULL,
    [max_credit] [real] NULL,
    [val] [int] NULL,
    [adresse] [nvarchar](50) NULL,
CONSTRAINT [PK_clients] PRIMARY KEY CLUSTERED
(
    [ref_client] 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 [dbo].[factures]    Script Date: 2020/11/09 21:06:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[factures](
    [id] [int] IDENTITY(1,1) NOT NULL,
    [ref_fournisseur] [nvarchar](50) NOT NULL,
    [num_facture] [bigint] NULL,
    [ref_client] [nvarchar](50) NOT NULL,
    [ref_kaisse] [nvarchar](50) NULL,
    [ref_users] [nvarchar](50) NULL,
    [dte_fac] [date] NULL,
    [dte_paid] [date] NULL,
    [amount] [real] NULL,
    [remise] [real] NULL,
    [type_fac] [int] NULL,
    [notes] [nvarchar](100) NULL,
    [val] [bit] NOT NULL,
CONSTRAINT [PK_factures] PRIMARY KEY CLUSTERED
(
    [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]
GO
/****** Object:  Table [dbo].[fournisseur]    Script Date: 2020/11/09 21:06:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[fournisseur](
    [id] [int] IDENTITY(1,1) NOT NULL,
    [ref_fournisseur] [nvarchar](50) NULL,
    [nom_fournisseur] [nvarchar](50) NULL,
    [max_credit] [real] NULL,
    [val] [int] NULL,
    [adresse] [nvarchar](50) NULL,
CONSTRAINT [PK_fournisseur] PRIMARY KEY CLUSTERED
(
    [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]
GO
/****** Object:  Table [dbo].[gestion_article]    Script Date: 2020/11/09 21:06:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[gestion_article](
    [id] [int] IDENTITY(1,1) NOT NULL,
    [ref_article] [nvarchar](50) NULL,
    [nom_service] [nvarchar](50) NOT NULL,
    [prix] [real] NULL,
    [qte] [real] NULL,
    [note] [nvarchar](100) NOT NULL,
    [numfacture] [nvarchar](50) NULL,
    [dte] [date] NULL,
    [ref_users] [nvarchar](50) NULL,
    [ref_fournisseur] [nvarchar](50) NOT NULL,
    [ref_client] [nvarchar](50) NOT NULL,
CONSTRAINT [PK_vente_article] PRIMARY KEY CLUSTERED
(
    [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]
GO
/****** Object:  Table [dbo].[kaisse]    Script Date: 2020/11/09 21:06:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[kaisse](
    [id] [int] IDENTITY(1,1) NOT NULL,
    [ref_kaisse] [nvarchar](50) NULL,
    [nom_kaisse] [nvarchar](50) NULL,
CONSTRAINT [PK_kaisse] PRIMARY KEY CLUSTERED
(
    [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]
GO
/****** Object:  Table [dbo].[prix_article]    Script Date: 2020/11/09 21:06:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[prix_article](
    [id] [int] IDENTITY(1,1) NOT NULL,
    [ref_article] [nvarchar](50) NOT NULL,
    [ref_service] [nvarchar](50) NOT NULL,
    [prix] [real] NULL,
    [ref_unite] [nvarchar](50) NOT NULL,
CONSTRAINT [PK_prix_article] PRIMARY KEY CLUSTERED
(
    [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]
GO
/****** Object:  Table [dbo].[Services]    Script Date: 2020/11/09 21:06:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Services](
    [id] [int] IDENTITY(1,1) NOT NULL,
    [ref_service] [nvarchar](50) NULL,
    [nom_service] [nvarchar](50) NULL,
CONSTRAINT [PK_Services] PRIMARY KEY CLUSTERED
(
    [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]
GO
/****** Object:  Table [dbo].[unite]    Script Date: 2020/11/09 21:06:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[unite](
    [id] [int] IDENTITY(1,1) NOT NULL,
    [ref_unite] [nvarchar](50) NULL,
    [nom_unite] [nvarchar](50) NULL,
CONSTRAINT [PK_unite] PRIMARY KEY CLUSTERED
(
    [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]
GO
/****** Object:  Table [dbo].[users]    Script Date: 2020/11/09 21:06:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[users](
    [id] [int] IDENTITY(1,1) NOT NULL,
    [ref_users] [nvarchar](50) NOT NULL,
    [nom_users] [nvarchar](50) NULL,
    [salaire] [real] NULL,
    [dte_travail] [date] NULL,
    [val] [int] NULL,
CONSTRAINT [PK_users] PRIMARY KEY CLUSTERED
(
    [ref_users] 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 [dbo].[validite_users]    Script Date: 2020/11/09 21:06:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[validite_users](
    [id] [int] IDENTITY(1,1) NOT NULL,
    [name_btn] [nvarchar](50) NULL,
    [id_users] [nvarchar](50) NULL,
    [val] [bit] NULL,
CONSTRAINT [PK_validite_users] PRIMARY KEY CLUSTERED
(
    [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]
GO
ALTER TABLE [dbo].[Article] ADD  CONSTRAINT [DF_Article_nom_article_english]  DEFAULT ('') FOR [nom_article_english]
GO
ALTER TABLE [dbo].[Article] ADD  CONSTRAINT [DF_Article_ref_unite]  DEFAULT ('') FOR [ref_unite]
GO
ALTER TABLE [dbo].[Article] ADD  CONSTRAINT [DF_Article_type_article]  DEFAULT ((0)) FOR [type_article]
GO
ALTER TABLE [dbo].[factures] ADD  CONSTRAINT [DF_factures_ref_fournisseur]  DEFAULT ('') FOR [ref_fournisseur]
GO
ALTER TABLE [dbo].[factures] ADD  CONSTRAINT [DF_factures_ref_client]  DEFAULT ('') FOR [ref_client]
GO
ALTER TABLE [dbo].[factures] ADD  CONSTRAINT [DF_factures_val]  DEFAULT ((0)) FOR [val]
GO
ALTER TABLE [dbo].[gestion_article] ADD  CONSTRAINT [DF_gestion_article_nom_service]  DEFAULT ('') FOR [nom_service]
GO
ALTER TABLE [dbo].[gestion_article] ADD  CONSTRAINT [DF_gestion_article_note]  DEFAULT ('') FOR [note]
GO
ALTER TABLE [dbo].[gestion_article] ADD  CONSTRAINT [DF_gestion_article_ref_fournisseur]  DEFAULT ('') FOR [ref_fournisseur]
GO
ALTER TABLE [dbo].[gestion_article] ADD  CONSTRAINT [DF_gestion_article_ref_client]  DEFAULT ('') FOR [ref_client]
GO
ALTER TABLE [dbo].[prix_article] ADD  CONSTRAINT [DF_prix_article_ref_service]  DEFAULT ('') FOR [ref_service]
GO
ALTER TABLE [dbo].[prix_article] ADD  CONSTRAINT [DF_prix_article_ref_unite]  DEFAULT ('') FOR [ref_unite]
GO
USE [master]
GO
ALTER DATABASE [C:\USERS\SABRI\DOCUMENTS\ZISCOMDATA\LANDRYDATA.MDF] SET  READ_WRITE
GO