587SEfJg

1-- phpMyAdmin SQL Dump
2-- version 4.8.5
3-- https://www.phpmyadmin.net/
4--
5-- Hôte : 127.0.0.1:3306
6-- Généré le :  mar. 29 sep. 2020 à 14:40
7-- Version du serveur :  5.7.26
8-- Version de PHP :  7.2.18
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET AUTOCOMMIT = 0;
12START TRANSACTION;
13SET time_zone = "+00:00";
14
15
16/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
17/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
18/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
19/*!40101 SET NAMES utf8mb4 */;
20
21--
22-- Base de données :  `mabase`
23--
24
25-- --------------------------------------------------------
26
27--
28-- Structure de la table `action`
29--
30
31DROP TABLE IF EXISTS `action`;
32CREATE TABLE IF NOT EXISTS `action` (
33  `ID_ACTION` decimal(8,0) NOT NULL,
34  `NOM_ACTION` varchar(256) DEFAULT NULL,
35  PRIMARY KEY (`ID_ACTION`)
36) ENGINE=MyISAM DEFAULT CHARSET=latin1;
37
38-- --------------------------------------------------------
39
40--
41-- Structure de la table `utilisateur_poste`
42--
43
44DROP TABLE IF EXISTS `utilisateur_poste`;
45CREATE TABLE IF NOT EXISTS `utilisateur_poste` (
46  `ID_POSTE` decimal(8,0) NOT NULL,
47  `ID_UTILISATEUR` decimal(8,0) NOT NULL,
48  PRIMARY KEY (`ID_POSTE`,`ID_UTILISATEUR`),
49  KEY `FK_ASSOCIATION_2` (`ID_UTILISATEUR`)
50) ENGINE=MyISAM DEFAULT CHARSET=latin1;
51
52-- --------------------------------------------------------
53
54--
55-- Structure de la table `poste_priorite`
56--
57
58DROP TABLE IF EXISTS `poste_priorite`;
59CREATE TABLE IF NOT EXISTS `poste_priorite` (
60  `ID_PRIORITE` decimal(8,0) NOT NULL,
61  `ID_POSTE` decimal(8,0) NOT NULL,
62  PRIMARY KEY (`ID_PRIORITE`,`ID_POSTE`),
63  KEY `FK_ASSOCIATION_8` (`ID_POSTE`)
64) ENGINE=MyISAM DEFAULT CHARSET=latin1;
65
66-- --------------------------------------------------------
67
68--
69-- Structure de la table `utilisateur_machine`
70--
71
72DROP TABLE IF EXISTS `utilisateur_machine`;
73CREATE TABLE IF NOT EXISTS `utilisateur_machine` (
74  `ID_MACHINE` decimal(8,0) NOT NULL,
75  `ID_UTILISATEUR` decimal(8,0) NOT NULL,
76  PRIMARY KEY (`ID_MACHINE`,`ID_UTILISATEUR`),
77  KEY `FK_ASSOCIATION_22` (`ID_UTILISATEUR`)
78) ENGINE=MyISAM DEFAULT CHARSET=latin1;
79
80-- --------------------------------------------------------
81
82--
83-- Structure de la table `intervention_action`
84--
85
86DROP TABLE IF EXISTS `intervention_action`;
87CREATE TABLE IF NOT EXISTS `intervention_action` (
88  `ID_ACTION` decimal(8,0) NOT NULL,
89  `ID_INTERVENTION` decimal(8,0) NOT NULL,
90  PRIMARY KEY (`ID_ACTION`,`ID_INTERVENTION`),
91  KEY `FK_ASSOCIATION_24` (`ID_INTERVENTION`)
92) ENGINE=MyISAM DEFAULT CHARSET=latin1;
93
94-- --------------------------------------------------------
95
96--
97-- Structure de la table `intervenant_intervention`
98--
99
100DROP TABLE IF EXISTS `intervenant_intervention`;
101CREATE TABLE IF NOT EXISTS `intervenant_intervention` (
102  `ID_INTERVENANT` decimal(8,0) NOT NULL,
103  `ID_INTERVENTION` decimal(8,0) NOT NULL,
104  PRIMARY KEY (`ID_INTERVENANT`,`ID_INTERVENTION`),
105  KEY `FK_ASSOCIATION_26` (`ID_INTERVENTION`)
106) ENGINE=MyISAM DEFAULT CHARSET=latin1;
107
108-- --------------------------------------------------------
109
110--
111-- Structure de la table `type_probleme_sous_type`
112--
113
114DROP TABLE IF EXISTS `type_probleme_sous_type`;
115CREATE TABLE IF NOT EXISTS `type_probleme_sous_type` (
116  `ID_SOUS_TYPE` decimal(8,0) NOT NULL,
117  `ID_TYPE_PROBLEME` decimal(8,0) NOT NULL,
118  PRIMARY KEY (`ID_SOUS_TYPE`,`ID_TYPE_PROBLEME`),
119  KEY `FK_ASSOCIATION_28` (`ID_TYPE_PROBLEME`)
120) ENGINE=MyISAM DEFAULT CHARSET=latin1;
121
122-- --------------------------------------------------------
123
124--
125-- Structure de la table `etat`
126--
127
128DROP TABLE IF EXISTS `etat`;
129CREATE TABLE IF NOT EXISTS `etat` (
130  `ID_ETAT` decimal(8,0) NOT NULL,
131  `NOM_ETAT` varchar(256) DEFAULT NULL,
132  PRIMARY KEY (`ID_ETAT`)
133) ENGINE=MyISAM DEFAULT CHARSET=latin1;
134
135-- --------------------------------------------------------
136
137--
138-- Structure de la table `histo_etat_ticket`
139--
140
141DROP TABLE IF EXISTS `histo_etat_ticket`;
142CREATE TABLE IF NOT EXISTS `histo_etat_ticket` (
143  `ID_HISTO` decimal(8,0) NOT NULL,
144  `ID_ETAT` decimal(8,0) DEFAULT NULL,
145  `ID_INTERVENTION` decimal(8,0) DEFAULT NULL,
146  `ID_TICKET` decimal(8,0) DEFAULT NULL,
147  `DATE_HISTO` datetime DEFAULT NULL,
148  PRIMARY KEY (`ID_HISTO`),
149  KEY `FK_ASSOCIATION_20` (`ID_INTERVENTION`),
150  KEY `FK_ASSOCIATION_6` (`ID_ETAT`),
151  KEY `FK_ASSOCIATION_7` (`ID_TICKET`)
152) ENGINE=MyISAM DEFAULT CHARSET=latin1;
153
154-- --------------------------------------------------------
155
156--
157-- Structure de la table `intervenant`
158--
159
160DROP TABLE IF EXISTS `intervenant`;
161CREATE TABLE IF NOT EXISTS `intervenant` (
162  `ID_INTERVENANT` decimal(8,0) NOT NULL,
163  `ID_TYPE_INTERVENANT` decimal(8,0) DEFAULT NULL,
164  `NOM_INTERVENANT` varchar(256) DEFAULT NULL,
165  PRIMARY KEY (`ID_INTERVENANT`),
166  KEY `FK_ASSOCIATION_10` (`ID_TYPE_INTERVENANT`)
167) ENGINE=MyISAM DEFAULT CHARSET=latin1;
168
169-- --------------------------------------------------------
170
171--
172-- Structure de la table `intervention`
173--
174
175DROP TABLE IF EXISTS `intervention`;
176CREATE TABLE IF NOT EXISTS `intervention` (
177  `ID_INTERVENTION` decimal(8,0) NOT NULL,
178  `ID_TICKET` decimal(8,0) DEFAULT NULL,
179  `ID_HISTO` decimal(8,0) DEFAULT NULL,
180  `DATE_INTERVENTION` datetime DEFAULT NULL,
181  PRIMARY KEY (`ID_INTERVENTION`),
182  KEY `FK_ASSOCIATION_16` (`ID_TICKET`),
183  KEY `FK_ASSOCIATION_21` (`ID_HISTO`)
184) ENGINE=MyISAM DEFAULT CHARSET=latin1;
185
186-- --------------------------------------------------------
187
188--
189-- Structure de la table `machine`
190--
191
192DROP TABLE IF EXISTS `machine`;
193CREATE TABLE IF NOT EXISTS `machine` (
194  `ID_MACHINE` decimal(8,0) NOT NULL,
195  PRIMARY KEY (`ID_MACHINE`)
196) ENGINE=MyISAM DEFAULT CHARSET=latin1;
197
198-- --------------------------------------------------------
199
200--
201-- Structure de la table `moyen_contact`
202--
203
204DROP TABLE IF EXISTS `moyen_contact`;
205CREATE TABLE IF NOT EXISTS `moyen_contact` (
206  `ID_MOYEN_CONTACT` decimal(8,0) NOT NULL,
207  `ID_TICKET` decimal(8,0) DEFAULT NULL,
208  `NOM_MOYEN_CONTACT` varchar(256) DEFAULT NULL,
209  PRIMARY KEY (`ID_MOYEN_CONTACT`),
210  KEY `FK_ASSOCIATION_15` (`ID_TICKET`)
211) ENGINE=MyISAM DEFAULT CHARSET=latin1;
212
213-- --------------------------------------------------------
214
215--
216-- Structure de la table `poste`
217--
218
219DROP TABLE IF EXISTS `poste`;
220CREATE TABLE IF NOT EXISTS `poste` (
221  `ID_POSTE` decimal(8,0) NOT NULL,
222  `NOM_POSTE` varchar(256) DEFAULT NULL,
223  PRIMARY KEY (`ID_POSTE`)
224) ENGINE=MyISAM DEFAULT CHARSET=latin1;
225
226-- --------------------------------------------------------
227
228--
229-- Structure de la table `priorite`
230--
231
232DROP TABLE IF EXISTS `priorite`;
233CREATE TABLE IF NOT EXISTS `priorite` (
234  `ID_PRIORITE` decimal(8,0) NOT NULL,
235  `ID_TICKET` decimal(8,0) DEFAULT NULL,
236  `NOM_PRIORITE` varchar(256) DEFAULT NULL,
237  PRIMARY KEY (`ID_PRIORITE`),
238  KEY `FK_ASSOCIATION_19` (`ID_TICKET`)
239) ENGINE=MyISAM DEFAULT CHARSET=latin1;
240
241-- --------------------------------------------------------
242
243--
244-- Structure de la table `probleme`
245--
246
247DROP TABLE IF EXISTS `probleme`;
248CREATE TABLE IF NOT EXISTS `probleme` (
249  `ID_PROBLEME` decimal(8,0) NOT NULL,
250  `ID_MACHINE` decimal(8,0) DEFAULT NULL,
251  `NOM_PROBLEME` varchar(256) DEFAULT NULL,
252  PRIMARY KEY (`ID_PROBLEME`),
253  KEY `FK_ASSOCIATION_4` (`ID_MACHINE`)
254) ENGINE=MyISAM DEFAULT CHARSET=latin1;
255
256-- --------------------------------------------------------
257
258--
259-- Structure de la table `sous_type`
260--
261
262DROP TABLE IF EXISTS `sous_type`;
263CREATE TABLE IF NOT EXISTS `sous_type` (
264  `ID_SOUS_TYPE` decimal(8,0) NOT NULL,
265  `ID_PROBLEME` decimal(8,0) DEFAULT NULL,
266  `NOM_SOUS_TYPE` varchar(256) DEFAULT NULL,
267  PRIMARY KEY (`ID_SOUS_TYPE`),
268  KEY `FK_ASSOCIATION_13` (`ID_PROBLEME`)
269) ENGINE=MyISAM DEFAULT CHARSET=latin1;
270
271-- --------------------------------------------------------
272
273--
274-- Structure de la table `ticket`
275--
276
277DROP TABLE IF EXISTS `ticket`;
278CREATE TABLE IF NOT EXISTS `ticket` (
279  `ID_TICKET` decimal(8,0) NOT NULL,
280  `ID_MOYEN_CONTACT` decimal(8,0) DEFAULT NULL,
281  `ID_PRIORITE` decimal(8,0) DEFAULT NULL,
282  `ID_PROBLEME` decimal(8,0) DEFAULT NULL,
283  `DATE_TICKET` datetime DEFAULT NULL,
284  PRIMARY KEY (`ID_TICKET`),
285  KEY `FK_ASSOCIATION_14` (`ID_MOYEN_CONTACT`),
286  KEY `FK_ASSOCIATION_17` (`ID_PROBLEME`),
287  KEY `FK_ASSOCIATION_18` (`ID_PRIORITE`)
288) ENGINE=MyISAM DEFAULT CHARSET=latin1;
289
290-- --------------------------------------------------------
291
292--
293-- Structure de la table `type_intervenant`
294--
295
296DROP TABLE IF EXISTS `type_intervenant`;
297CREATE TABLE IF NOT EXISTS `type_intervenant` (
298  `ID_TYPE_INTERVENANT` decimal(8,0) NOT NULL,
299  `ID_TYPE_PROBLEME` decimal(8,0) DEFAULT NULL,
300  `NOM_TYPE_INTERVENANT` varchar(256) DEFAULT NULL,
301  PRIMARY KEY (`ID_TYPE_INTERVENANT`),
302  KEY `FK_ASSOCIATION_12` (`ID_TYPE_PROBLEME`)
303) ENGINE=MyISAM DEFAULT CHARSET=latin1;
304
305-- --------------------------------------------------------
306
307--
308-- Structure de la table `type_probleme`
309--
310
311DROP TABLE IF EXISTS `type_probleme`;
312CREATE TABLE IF NOT EXISTS `type_probleme` (
313  `ID_TYPE_PROBLEME` decimal(8,0) NOT NULL,
314  `ID_TYPE_INTERVENANT` decimal(8,0) DEFAULT NULL,
315  `ID_PROBLEME` decimal(8,0) DEFAULT NULL,
316  `NOM_TYPE_PROBLEME` varchar(256) DEFAULT NULL,
317  PRIMARY KEY (`ID_TYPE_PROBLEME`),
318  KEY `FK_ASSOCIATION_11` (`ID_TYPE_INTERVENANT`),
319  KEY `FK_ASSOCIATION_3` (`ID_PROBLEME`)
320) ENGINE=MyISAM DEFAULT CHARSET=latin1;
321
322-- --------------------------------------------------------
323
324--
325-- Structure de la table `utilisateur`
326--
327
328DROP TABLE IF EXISTS `utilisateur`;
329CREATE TABLE IF NOT EXISTS `utilisateur` (
330  `ID_UTILISATEUR` decimal(8,0) NOT NULL,
331  `NOM_UTILISATEUR` varchar(256) DEFAULT NULL,
332  PRIMARY KEY (`ID_UTILISATEUR`)
333) ENGINE=MyISAM DEFAULT CHARSET=latin1;
334COMMIT;
335
336/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
337/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
338/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
339