· 5 years ago · Sep 30, 2020, 07:54 AM
1use merise_sql;
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(8) 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(8) NOT NULL,
49 `ID_UTILISATEUR` int(8) 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(8) NOT NULL,
63 `ID_POSTE` int(8) 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(8) NOT NULL,
77 `ID_UTILISATEUR` int(8) 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(8) NOT NULL,
91 `ID_INTERVENTION` int(8) 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(8) NOT NULL,
105 `ID_INTERVENTION` int(8) 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(8) NOT NULL,
119 `ID_TYPE_PROBLEME` int(8) 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(8) 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(8) AUTO_INCREMENT,
146 `ID_ETAT` int(8) DEFAULT NULL,
147 `ID_INTERVENTION` int(8) DEFAULT NULL,
148 `ID_TICKET` int(8) 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(8) AUTO_INCREMENT,
165 `ID_TYPE_INTERVENANT` int(8) 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(8) AUTO_INCREMENT,
180 `ID_TICKET` int(8) DEFAULT NULL,
181 `ID_HISTO` int(8) 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(8) AUTO_INCREMENT,
197 `NOM_MACHINE` VARCHAR(256),
198 PRIMARY KEY (`ID_MACHINE`)
199) ENGINE=MyISAM DEFAULT CHARSET=latin1;
200
201-- --------------------------------------------------------
202
203--
204-- Structure de la table `moyen_contact`
205--
206
207DROP TABLE IF EXISTS `moyen_contact`;
208CREATE TABLE IF NOT EXISTS `moyen_contact` (
209 `ID_MOYEN_CONTACT` int(8) AUTO_INCREMENT,
210 `NOM_MOYEN_CONTACT` varchar(256) DEFAULT NULL,
211 PRIMARY KEY (`ID_MOYEN_CONTACT`)
212) ENGINE=MyISAM DEFAULT CHARSET=latin1;
213
214-- --------------------------------------------------------
215
216--
217-- Structure de la table `poste`
218--
219
220DROP TABLE IF EXISTS `poste`;
221CREATE TABLE IF NOT EXISTS `poste` (
222 `ID_POSTE` int(8) AUTO_INCREMENT,
223 `NOM_POSTE` varchar(256) DEFAULT NULL,
224 PRIMARY KEY (`ID_POSTE`)
225) ENGINE=MyISAM DEFAULT CHARSET=latin1;
226
227-- --------------------------------------------------------
228
229--
230-- Structure de la table `priorite`
231--
232
233DROP TABLE IF EXISTS `priorite`;
234CREATE TABLE IF NOT EXISTS `priorite` (
235 `ID_PRIORITE` int(8) AUTO_INCREMENT,
236 `ID_TICKET` int(8) DEFAULT NULL,
237 `NOM_PRIORITE` varchar(256) DEFAULT NULL,
238 PRIMARY KEY (`ID_PRIORITE`),
239 KEY `FK_ASSOCIATION_19` (`ID_TICKET`)
240) ENGINE=MyISAM DEFAULT CHARSET=latin1;
241
242-- --------------------------------------------------------
243
244--
245-- Structure de la table `probleme`
246--
247
248DROP TABLE IF EXISTS `probleme`;
249CREATE TABLE IF NOT EXISTS `probleme` (
250 `ID_PROBLEME` int(8) AUTO_INCREMENT,
251 `ID_MACHINE` int(8) DEFAULT NULL,
252 `NOM_PROBLEME` varchar(256) DEFAULT NULL,
253 PRIMARY KEY (`ID_PROBLEME`),
254 KEY `FK_ASSOCIATION_4` (`ID_MACHINE`)
255) ENGINE=MyISAM DEFAULT CHARSET=latin1;
256
257-- --------------------------------------------------------
258
259--
260-- Structure de la table `sous_type`
261--
262
263DROP TABLE IF EXISTS `sous_type`;
264CREATE TABLE IF NOT EXISTS `sous_type` (
265 `ID_SOUS_TYPE` int(8) AUTO_INCREMENT,
266 `ID_PROBLEME` int(8) DEFAULT NULL,
267 `NOM_SOUS_TYPE` varchar(256) DEFAULT NULL,
268 PRIMARY KEY (`ID_SOUS_TYPE`),
269 KEY `FK_ASSOCIATION_13` (`ID_PROBLEME`)
270) ENGINE=MyISAM DEFAULT CHARSET=latin1;
271
272-- --------------------------------------------------------
273
274--
275-- Structure de la table `ticket`
276--
277
278DROP TABLE IF EXISTS `ticket`;
279CREATE TABLE IF NOT EXISTS `ticket` (
280 `ID_TICKET` int(8) AUTO_INCREMENT,
281 `ID_MOYEN_CONTACT` int(8) DEFAULT NULL,
282 `ID_PRIORITE` int(8) DEFAULT NULL,
283 `ID_PROBLEME` int(8) DEFAULT NULL,
284 `DATE_TICKET` datetime DEFAULT NULL,
285 PRIMARY KEY (`ID_TICKET`),
286 KEY `FK_ASSOCIATION_14` (`ID_MOYEN_CONTACT`),
287 KEY `FK_ASSOCIATION_17` (`ID_PROBLEME`),
288 KEY `FK_ASSOCIATION_18` (`ID_PRIORITE`)
289) ENGINE=MyISAM DEFAULT CHARSET=latin1;
290
291-- --------------------------------------------------------
292
293--
294-- Structure de la table `type_intervenant`
295--
296
297DROP TABLE IF EXISTS `type_intervenant`;
298CREATE TABLE IF NOT EXISTS `type_intervenant` (
299 `ID_TYPE_INTERVENANT` int(8) AUTO_INCREMENT,
300 `ID_TYPE_PROBLEME` int(8) DEFAULT NULL,
301 `NOM_TYPE_INTERVENANT` varchar(256) DEFAULT NULL,
302 PRIMARY KEY (`ID_TYPE_INTERVENANT`),
303 KEY `FK_ASSOCIATION_12` (`ID_TYPE_PROBLEME`)
304) ENGINE=MyISAM DEFAULT CHARSET=latin1;
305
306-- --------------------------------------------------------
307
308--
309-- Structure de la table `type_probleme`
310--
311
312DROP TABLE IF EXISTS `type_probleme`;
313CREATE TABLE IF NOT EXISTS `type_probleme` (
314 `ID_TYPE_PROBLEME` int(8) AUTO_INCREMENT,
315 `ID_TYPE_INTERVENANT` int(8) DEFAULT NULL,
316 `ID_PROBLEME` int(8) DEFAULT NULL,
317 `NOM_TYPE_PROBLEME` varchar(256) DEFAULT NULL,
318 PRIMARY KEY (`ID_TYPE_PROBLEME`),
319 KEY `FK_ASSOCIATION_11` (`ID_TYPE_INTERVENANT`),
320 KEY `FK_ASSOCIATION_3` (`ID_PROBLEME`)
321) ENGINE=MyISAM DEFAULT CHARSET=latin1;
322
323-- --------------------------------------------------------
324
325--
326-- Structure de la table `utilisateur`
327--
328
329DROP TABLE IF EXISTS `utilisateur`;
330CREATE TABLE IF NOT EXISTS `utilisateur` (
331 `ID_UTILISATEUR` int(8) AUTO_INCREMENT,
332 `NOM_UTILISATEUR` varchar(256) DEFAULT NULL,
333 PRIMARY KEY (`ID_UTILISATEUR`)
334) ENGINE=MyISAM DEFAULT CHARSET=latin1;
335COMMIT;
336
337/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
338/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
339/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
340