· 5 years ago · Sep 30, 2020, 07:38 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 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(8) 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(8) 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(8) AUTO_INCREMENT,
235 `ID_TICKET` int(8) 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` int(8) AUTO_INCREMENT,
250 `ID_MACHINE` int(8) 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` int(8) AUTO_INCREMENT,
265 `ID_PROBLEME` int(8) 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` int(8) AUTO_INCREMENT,
280 `ID_MOYEN_CONTACT` int(8) DEFAULT NULL,
281 `ID_PRIORITE` int(8) DEFAULT NULL,
282 `ID_PROBLEME` int(8) 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` int(8) AUTO_INCREMENT,
299 `ID_TYPE_PROBLEME` int(8) 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` int(8) AUTO_INCREMENT,
314 `ID_TYPE_INTERVENANT` int(8) DEFAULT NULL,
315 `ID_PROBLEME` int(8) 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` int(8) AUTO_INCREMENT,
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