3jNgP9Q2

1-- Adminer 4.3.1 MySQL dump
2
3SET NAMES utf8;
4SET time_zone = '+00:00';
5SET foreign_key_checks = 0;
6SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
7
8DROP TABLE IF EXISTS `AchatClient`;
9CREATE TABLE `AchatClient` (
10  `a_p_id` int(11) NOT NULL,
11  `a_fc_id` int(11) NOT NULL,
12  `a_quantite` int(11) NOT NULL,
13  PRIMARY KEY (`a_p_id`,`a_fc_id`),
14  KEY `a_fc_id` (`a_fc_id`),
15  CONSTRAINT `AchatClient_ibfk_1` FOREIGN KEY (`a_fc_id`) REFERENCES `FactureClient` (`fc_id`),
16  CONSTRAINT `AchatClient_ibfk_2` FOREIGN KEY (`a_p_id`) REFERENCES `Produit` (`p_id`)
17) ENGINE=InnoDB DEFAULT CHARSET=latin1;
18
19
20DROP TABLE IF EXISTS `Client`;
21CREATE TABLE `Client` (
22  `c_id` int(11) NOT NULL AUTO_INCREMENT,
23  `c_nom` varchar(255) NOT NULL DEFAULT 'Unname',
24  `c_adresse` varchar(255) NOT NULL,
25  `c_telephone` varchar(255) NOT NULL,
26  `c_mail` varchar(255) NOT NULL,
27  PRIMARY KEY (`c_id`)
28) ENGINE=InnoDB DEFAULT CHARSET=latin1;
29
30
31DROP TABLE IF EXISTS `FactureClient`;
32CREATE TABLE `FactureClient` (
33  `fc_id` int(11) NOT NULL AUTO_INCREMENT,
34  `fc_c_id` int(11) NOT NULL,
35  `fc_reference` varchar(255) NOT NULL,
36  `fc_emission` date NOT NULL,
37  `fc_recouvrement` date NOT NULL,
38  `fc_tva` double NOT NULL DEFAULT '20',
39  `fc_acquitee` bit(1) NOT NULL,
40  `fc_montantHT` double NOT NULL,
41  `fc_montantTTC` double NOT NULL,
42  PRIMARY KEY (`fc_id`),
43  KEY `fc_c_id` (`fc_c_id`),
44  CONSTRAINT `FactureClient_ibfk_1` FOREIGN KEY (`fc_c_id`) REFERENCES `Client` (`c_id`)
45) ENGINE=InnoDB DEFAULT CHARSET=latin1;
46
47
48DROP TABLE IF EXISTS `FactureFournisseur`;
49CREATE TABLE `FactureFournisseur` (
50  `ff_id` int(11) NOT NULL AUTO_INCREMENT,
51  `ff_f_id` int(11) NOT NULL,
52  `ff_reference` varchar(255) NOT NULL,
53  `ff_description` varchar(255) NOT NULL,
54  `ff_TVA` double NOT NULL,
55  `ff_acquitee` bit(1) NOT NULL,
56  `ff_montantHT` double NOT NULL,
57  `ff_montantTTC` double NOT NULL,
58  PRIMARY KEY (`ff_id`)
59) ENGINE=InnoDB DEFAULT CHARSET=latin1;
60
61
62DROP TABLE IF EXISTS `Fournisseur`;
63CREATE TABLE `Fournisseur` (
64  `f_id` int(11) NOT NULL AUTO_INCREMENT,
65  `f_nom` varchar(255) NOT NULL,
66  `f_adresse` varchar(255) NOT NULL,
67  `f_telephone` varchar(255) NOT NULL,
68  `f_mail` varchar(255) NOT NULL,
69  PRIMARY KEY (`f_id`)
70) ENGINE=InnoDB DEFAULT CHARSET=latin1;
71
72
73DROP TABLE IF EXISTS `Produit`;
74CREATE TABLE `Produit` (
75  `p_id` int(11) NOT NULL AUTO_INCREMENT,
76  `p_appelation` varchar(255) NOT NULL,
77  `p_description` varchar(255) NOT NULL,
78  `p_image` varchar(255) NOT NULL,
79  `p_montantHT` double NOT NULL,
80  PRIMARY KEY (`p_id`)
81) ENGINE=InnoDB DEFAULT CHARSET=latin1;
82
83
84DROP TABLE IF EXISTS `Salarie`;
85CREATE TABLE `Salarie` (
86  `s_id` int(11) NOT NULL AUTO_INCREMENT,
87  `s_nom` varchar(255) NOT NULL,
88  `s_adresse` varchar(255) NOT NULL,
89  `s_telephone` varchar(255) NOT NULL,
90  `s_mail` varchar(255) NOT NULL,
91  `s_poste` varchar(255) NOT NULL,
92  PRIMARY KEY (`s_id`)
93) ENGINE=InnoDB DEFAULT CHARSET=latin1;
94
95
96DROP TABLE IF EXISTS `Taxe`;
97CREATE TABLE `Taxe` (
98  `t_id` int(11) NOT NULL AUTO_INCREMENT,
99  `t_type` varchar(255) NOT NULL,
100  `t_montant` double NOT NULL,
101  `t_emission` date NOT NULL,
102  `t_recouvrement` date NOT NULL,
103  PRIMARY KEY (`t_id`)
104) ENGINE=InnoDB DEFAULT CHARSET=latin1;
105
106
107DROP TABLE IF EXISTS `User`;
108CREATE TABLE `User` (
109  `login` varchar(255) NOT NULL,
110  `password` varchar(255) NOT NULL,
111  `level` int(11) NOT NULL
112) ENGINE=InnoDB DEFAULT CHARSET=latin1;
113
114
115-- 2018-01-08 14:47:23