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