-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathNOUVELLE BDD.SQL
326 lines (265 loc) · 22.9 KB
/
NOUVELLE BDD.SQL
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
drop table if exists PLO_CONCERNER;
drop table if exists PLO_PALANQUEE;
drop table if exists PLO_PLONGEE;
drop table if exists PLO_DIRECTEUR;
drop table if exists PLO_SECURITE_DE_SURFACE;
drop table if exists PLO_PLONGEUR;
drop table if exists PLO_SITE;
drop table if exists PLO_EMBARCATION;
drop table if exists PLO_PERSONNE;
drop table if exists PLO_APTITUDE;
CREATE TABLE PLO_DIRECTEUR
(
PER_NUM SMALLINT NOT NULL
, PRIMARY KEY (PER_NUM)
);
CREATE TABLE PLO_PERSONNE
(
PER_NUM SMALLINT NOT NULL ,
PER_NOM VARCHAR(30) NULL ,
PER_PRENOM VARCHAR(30) NULL ,
PER_ACTIVE BOOL NULL ,
PER_DATE_CERTIF_MED DATE NULL
, PRIMARY KEY (PER_NUM)
);
CREATE TABLE PLO_APTITUDE
(
APT_CODE CHAR(5) NOT NULL ,
APT_LIBELLE VARCHAR(100) NULL
, PRIMARY KEY (APT_CODE)
);
CREATE TABLE PLO_EMBARCATION
(
EMB_NUM CHAR(32) NOT NULL ,
EMB_NOM VARCHAR(64) NULL
, PRIMARY KEY (EMB_NUM)
);
CREATE TABLE PLO_PLONGEUR
(
PER_NUM SMALLINT NOT NULL ,
APT_CODE CHAR(5) NOT NULL
, PRIMARY KEY (PER_NUM)
);
CREATE INDEX I_FK_PLO_PLONGEUR_PLO_APTITUDE
ON PLO_PLONGEUR (APT_CODE ASC);
CREATE TABLE PLO_SECURITE_DE_SURFACE
(
PER_NUM SMALLINT NOT NULL
, PRIMARY KEY (PER_NUM)
);
CREATE TABLE PLO_PALANQUEE
(
PLO_DATE DATE NOT NULL ,
PLO_MAT_MID_SOI CHAR(1) NOT NULL ,
PAL_NUM INTEGER NOT NULL ,
PAL_PROFONDEUR_MAX REAL(6,2) NULL ,
PAL_DUREE_MAX INTEGER NULL ,
PAL_HEURE_IMMERSION TIME NULL ,
PAL_HEURE_SORTIE_EAU TIME NULL ,
PAL_PROFONDEUR_REELLE INTEGER NULL ,
PAL_DUREE_FOND INTEGER NULL
, PRIMARY KEY (PLO_DATE,PLO_MAT_MID_SOI,PAL_NUM)
);
CREATE INDEX I_FK_PLO_PALANQUEE_PLO_PLONGEE
ON PLO_PALANQUEE (PLO_DATE ASC,PLO_MAT_MID_SOI ASC);
CREATE TABLE PLO_PLONGEE
(
PLO_DATE DATE NOT NULL ,
PLO_MAT_MID_SOI CHAR(1) NOT NULL ,
SIT_NUM INTEGER NOT NULL ,
EMB_NUM CHAR(32) NOT NULL ,
PER_NUM_DIR SMALLINT NOT NULL ,
PER_NUM_SECU SMALLINT NOT NULL ,
PLO_EFFECTIF_PLONGEURS INTEGER NULL ,
PLO_EFFECTIF_BATEAU INTEGER NULL ,
PLO_NB_PALANQUEES INTEGER NULL ,
PLO_ETAT VARCHAR(16) NULL
, PRIMARY KEY (PLO_DATE,PLO_MAT_MID_SOI)
);
CREATE INDEX I_FK_PLO_PLONGEE_PLO_DIRECTEUR ON PLO_PLONGEE (PER_NUM_DIR ASC);
CREATE INDEX I_FK_PLO_PLONGEE_PLO_SITE ON PLO_PLONGEE (SIT_NUM ASC);
CREATE INDEX I_FK_PLO_PLONGEE_PLO_SECURITE_DE_SURFACE ON PLO_PLONGEE (PER_NUM_SECU ASC);
CREATE INDEX I_FK_PLO_PLONGEE_PLO_EMBARCATION ON PLO_PLONGEE (EMB_NUM ASC);
CREATE TABLE PLO_SITE
(
SIT_NUM INTEGER NOT NULL ,
SIT_NOM VARCHAR(128) NULL ,
SIT_LOCALISATION VARCHAR(64) NULL
, PRIMARY KEY (SIT_NUM)
);
CREATE TABLE PLO_CONCERNER
(
PLO_DATE DATE NOT NULL ,
PLO_MAT_MID_SOI CHAR(1) NOT NULL ,
PAL_NUM INTEGER NOT NULL ,
PER_NUM SMALLINT NOT NULL
, PRIMARY KEY (PLO_DATE,PLO_MAT_MID_SOI,PAL_NUM,PER_NUM)
);
CREATE INDEX I_FK_PLO_CONCERNER_PLO_PALANQUEE ON PLO_CONCERNER (PLO_DATE ASC,PLO_MAT_MID_SOI ASC,PAL_NUM ASC);
CREATE INDEX I_FK_PLO_CONCERNER_PLO_PLONGEUR ON PLO_CONCERNER (PER_NUM ASC);
ALTER TABLE PLO_DIRECTEUR
ADD FOREIGN KEY FK_PLO_DIRECTEUR_PLO_PERSONNE (PER_NUM)
REFERENCES PLO_PERSONNE (PER_NUM) ;
ALTER TABLE PLO_PLONGEUR
ADD FOREIGN KEY FK_PLO_PLONGEUR_PLO_APTITUDE (APT_CODE)
REFERENCES PLO_APTITUDE (APT_CODE) ;
ALTER TABLE PLO_PLONGEUR
ADD FOREIGN KEY FK_PLO_PLONGEUR_PLO_PERSONNE (PER_NUM)
REFERENCES PLO_PERSONNE (PER_NUM) ;
ALTER TABLE PLO_SECURITE_DE_SURFACE
ADD FOREIGN KEY FK_PLO_SECURITE_DE_SURFACE_PLO_PERSONNE (PER_NUM)
REFERENCES PLO_PERSONNE (PER_NUM) ;
ALTER TABLE PLO_PALANQUEE
ADD FOREIGN KEY FK_PLO_PALANQUEE_PLO_PLONGEE (PLO_DATE,PLO_MAT_MID_SOI)
REFERENCES PLO_PLONGEE (PLO_DATE,PLO_MAT_MID_SOI) ;
ALTER TABLE PLO_PLONGEE
ADD FOREIGN KEY FK_PLO_PLONGEE_PLO_DIRECTEUR (PER_NUM_DIR)
REFERENCES PLO_DIRECTEUR (PER_NUM) ;
ALTER TABLE PLO_PLONGEE
ADD FOREIGN KEY FK_PLO_PLONGEE_PLO_SITE (SIT_NUM)
REFERENCES PLO_SITE (SIT_NUM) ;
ALTER TABLE PLO_PLONGEE
ADD FOREIGN KEY FK_PLO_PLONGEE_PLO_SECURITE_DE_SURFACE (PER_NUM_SECU)
REFERENCES PLO_SECURITE_DE_SURFACE (PER_NUM) ;
ALTER TABLE PLO_PLONGEE
ADD FOREIGN KEY FK_PLO_PLONGEE_PLO_EMBARCATION (EMB_NUM)
REFERENCES PLO_EMBARCATION (EMB_NUM) ;
ALTER TABLE PLO_CONCERNER
ADD FOREIGN KEY FK_PLO_CONCERNER_PLO_PALANQUEE (PLO_DATE,PLO_MAT_MID_SOI,PAL_NUM)
REFERENCES PLO_PALANQUEE (PLO_DATE,PLO_MAT_MID_SOI,PAL_NUM) ;
ALTER TABLE PLO_CONCERNER
ADD FOREIGN KEY FK_PLO_CONCERNER_PLO_PLONGEUR (PER_NUM)
REFERENCES PLO_PLONGEUR (PER_NUM) ;
INSERT INTO `PLO_APTITUDE` (`APT_CODE`,`APT_LIBELLE`) VALUES ('B', 'Baptéme');
INSERT INTO `PLO_APTITUDE` (`APT_CODE`,`APT_LIBELLE`) VALUES ('PPB', 'Préparation plongeur Bronze');
INSERT INTO `PLO_APTITUDE` (`APT_CODE`,`APT_LIBELLE`) VALUES ('PPA', 'Préparation plongeur Argent');
INSERT INTO `PLO_APTITUDE` (`APT_CODE`,`APT_LIBELLE`) VALUES ('PN1', 'Préparation plongeur Niveau 1');
INSERT INTO `PLO_APTITUDE` (`APT_CODE`,`APT_LIBELLE`) VALUES ('PN2', 'Préparation plongeur Niveau 2');
INSERT INTO `PLO_APTITUDE` (`APT_CODE`,`APT_LIBELLE`) VALUES ('PN3', 'Préparation plongeur Niveau 3');
INSERT INTO `PLO_APTITUDE` (`APT_CODE`,`APT_LIBELLE`) VALUES ('PN4', 'Préparation plongeur Niveau 4');
INSERT INTO `PLO_APTITUDE` (`APT_CODE`,`APT_LIBELLE`) VALUES ('PE-6', 'Plongeur encadré jusqu''au 6 m.');
INSERT INTO `PLO_APTITUDE` (`APT_CODE`,`APT_LIBELLE`) VALUES ('PE-12', 'Plongeur encadré jusqu''au 12 m.');
INSERT INTO `PLO_APTITUDE` (`APT_CODE`,`APT_LIBELLE`) VALUES ('PE-20', 'Plongeur encadré jusqu''au 20 m.');
INSERT INTO `PLO_APTITUDE` (`APT_CODE`,`APT_LIBELLE`) VALUES ('PE-40', 'Plongeur encadré jusqu''au 40 m.');
INSERT INTO `PLO_APTITUDE` (`APT_CODE`,`APT_LIBELLE`) VALUES ('PA-20', 'Plongeur autonome jusqu''au 20 m.');
INSERT INTO `PLO_APTITUDE` (`APT_CODE`,`APT_LIBELLE`) VALUES ('PA-40', 'Plongeur autonome jusqu''au 40 m.');
INSERT INTO `PLO_APTITUDE` (`APT_CODE`,`APT_LIBELLE`) VALUES ('PA-60', 'Plongeur autonome jusqu''au 60 m.');
INSERT INTO `PLO_APTITUDE` (`APT_CODE`,`APT_LIBELLE`) VALUES ('E1', 'Encadrant jusqu''au 6 m.');
INSERT INTO `PLO_APTITUDE` (`APT_CODE`,`APT_LIBELLE`) VALUES ('E2', 'Encadrant jusqu''au 40 m.');
INSERT INTO `PLO_APTITUDE` (`APT_CODE`,`APT_LIBELLE`) VALUES ('E3', 'Encadrant moniteur fédéral 1');
INSERT INTO `PLO_APTITUDE` (`APT_CODE`,`APT_LIBELLE`) VALUES ('E4', 'Encadrant moniteur fédéral 2');
insert into `PLO_PERSONNE`(`per_num`, `per_nom`, `per_prenom`, `per_active`, `per_date_certif_med`) values (0,'AUDABRAM','Luc',1,STR_TO_DATE('5/9/2019','%d/%m/%Y'));
insert into `PLO_PERSONNE`(`per_num`, `per_nom`, `per_prenom`, `per_active`, `per_date_certif_med`) values (1,'RIVAT','Matthis',0,STR_TO_DATE('6/9/2019','%d/%m/%Y'));
insert into `PLO_PERSONNE`(`per_num`, `per_nom`, `per_prenom`, `per_active`, `per_date_certif_med`) values (2,'SIMONIN','Mélissande',0,STR_TO_DATE('7/9/2019','%d/%m/%Y'));
insert into `PLO_PERSONNE`(`per_num`, `per_nom`, `per_prenom`, `per_active`, `per_date_certif_med`) values (3,'CHAVAS','Nathan',1,STR_TO_DATE('7/9/2019','%d/%m/%Y'));
insert into `PLO_PERSONNE`(`per_num`, `per_nom`, `per_prenom`, `per_active`, `per_date_certif_med`) values (4,'GRIMARD','Roslyn',1,STR_TO_DATE('8/9/2019','%d/%m/%Y'));
insert into `PLO_PERSONNE`(`per_num`, `per_nom`, `per_prenom`, `per_active`, `per_date_certif_med`) values (5,'BRISEBOIS','Christian',0,STR_TO_DATE('9/9/2019','%d/%m/%Y'));
insert into `PLO_PERSONNE`(`per_num`, `per_nom`, `per_prenom`, `per_active`, `per_date_certif_med`) values (6,'MIRON','Merlin',1,STR_TO_DATE('10/9/2019','%d/%m/%Y'));
insert into `PLO_PERSONNE`(`per_num`, `per_nom`, `per_prenom`, `per_active`, `per_date_certif_med`) values (7,'LEBEL ','Brice',1,STR_TO_DATE('10/9/2019','%d/%m/%Y'));
insert into `PLO_PERSONNE`(`per_num`, `per_nom`, `per_prenom`, `per_active`, `per_date_certif_med`) values (8,'BELISTE ','Francis',0,STR_TO_DATE('10/9/2019','%d/%m/%Y'));
insert into `PLO_PERSONNE`(`per_num`, `per_nom`, `per_prenom`, `per_active`, `per_date_certif_med`) values (9,'ALLARD ','Aloin',0,STR_TO_DATE('11/9/2019','%d/%m/%Y'));
insert into `PLO_PERSONNE`(`per_num`, `per_nom`, `per_prenom`, `per_active`, `per_date_certif_med`) values (10,'SCIVREIT','Parfait',0,STR_TO_DATE('12/9/2019','%d/%m/%Y'));
insert into `PLO_PERSONNE`(`per_num`, `per_nom`, `per_prenom`, `per_active`, `per_date_certif_med`) values (11,'CARIGNAN','Arnaud',1,STR_TO_DATE('13/9/2019','%d/%m/%Y'));
insert into `PLO_PERSONNE`(`per_num`, `per_nom`, `per_prenom`, `per_active`, `per_date_certif_med`) values (12,'LAGRANGE','Grosvenor',1,STR_TO_DATE('14/9/2019','%d/%m/%Y'));
insert into `PLO_PERSONNE`(`per_num`, `per_nom`, `per_prenom`, `per_active`, `per_date_certif_med`) values (13,'HARQUIN','Nicolette',0,STR_TO_DATE('15/9/2019','%d/%m/%Y'));
insert into `PLO_PERSONNE`(`per_num`, `per_nom`, `per_prenom`, `per_active`, `per_date_certif_med`) values (14,'LALIBERTE','Fantina',0,STR_TO_DATE('16/9/2019','%d/%m/%Y'));
insert into `PLO_PERSONNE`(`per_num`, `per_nom`, `per_prenom`, `per_active`, `per_date_certif_med`) values (15,'LAROCQUE','Flordelis',1,STR_TO_DATE('17/9/2019','%d/%m/%Y'));
insert into `PLO_PERSONNE`(`per_num`, `per_nom`, `per_prenom`, `per_active`, `per_date_certif_med`) values (16,'LAFONTAINE','Arber',0,STR_TO_DATE('18/9/2019','%d/%m/%Y'));
insert into `PLO_PERSONNE`(`per_num`, `per_nom`, `per_prenom`, `per_active`, `per_date_certif_med`) values (17,'VAILLANCOURS','Julien',1,STR_TO_DATE('19/9/2019','%d/%m/%Y'));
insert into `PLO_PERSONNE`(`per_num`, `per_nom`, `per_prenom`, `per_active`, `per_date_certif_med`) values (18,'AILLEBOUST','Corinne',1,STR_TO_DATE('20/9/2019','%d/%m/%Y'));
insert into `PLO_PERSONNE`(`per_num`, `per_nom`, `per_prenom`, `per_active`, `per_date_certif_med`) values (19,'BIENVENUE','Jewel',0,STR_TO_DATE('21/9/2019','%d/%m/%Y'));
insert into `PLO_PERSONNE`(`per_num`, `per_nom`, `per_prenom`, `per_active`, `per_date_certif_med`) values (20,'GARREAU','Eulalie',0,STR_TO_DATE('22/9/2019','%d/%m/%Y'));
insert into `PLO_PERSONNE`(`per_num`, `per_nom`, `per_prenom`, `per_active`, `per_date_certif_med`) values (21,'QUESSY','Fleur',1,STR_TO_DATE('23/9/2019','%d/%m/%Y'));
insert into `PLO_PERSONNE`(`per_num`, `per_nom`, `per_prenom`, `per_active`, `per_date_certif_med`) values (22,'ROUSSEAU','Robinette',0,STR_TO_DATE('23/9/2019','%d/%m/%Y'));
insert into `PLO_PERSONNE`(`per_num`, `per_nom`, `per_prenom`, `per_active`, `per_date_certif_med`) values (23,'FLAMENT','Monique',0,STR_TO_DATE('24/9/2019','%d/%m/%Y'));
insert into `PLO_PERSONNE`(`per_num`, `per_nom`, `per_prenom`, `per_active`, `per_date_certif_med`) values (24,'CHAUSSEE','Joanna',1,STR_TO_DATE('25/9/2019','%d/%m/%Y'));
INSERT INTO `PLO_PLONGEUR`(`PER_NUM`,`APT_CODE`) VALUES (3,"B");
INSERT INTO `PLO_PLONGEUR`(`PER_NUM`,`APT_CODE`) VALUES (4,"E4");
INSERT INTO `PLO_PLONGEUR`(`PER_NUM`,`APT_CODE`) VALUES (5,"PPB");
INSERT INTO `PLO_PLONGEUR`(`PER_NUM`,`APT_CODE`) VALUES (7,"PN1");
INSERT INTO `PLO_PLONGEUR`(`PER_NUM`,`APT_CODE`) VALUES (13,"PE-20");
INSERT INTO `PLO_PLONGEUR`(`PER_NUM`,`APT_CODE`) VALUES (0,"PE-40");
INSERT INTO `PLO_PLONGEUR`(`PER_NUM`,`APT_CODE`) VALUES (22,"PN3");
INSERT INTO `PLO_PLONGEUR`(`PER_NUM`,`APT_CODE`) VALUES (24,"E3");
INSERT INTO `PLO_PLONGEUR`(`PER_NUM`,`APT_CODE`) VALUES (18,"PPB");
INSERT INTO `PLO_PLONGEUR`(`PER_NUM`,`APT_CODE`) VALUES (6,"PE-40");
INSERT INTO `PLO_PLONGEUR`(`PER_NUM`,`APT_CODE`) VALUES (16,"PN3");
INSERT INTO `PLO_PLONGEUR`(`PER_NUM`,`APT_CODE`) VALUES (19,"E3");
INSERT INTO `PLO_PLONGEUR`(`PER_NUM`,`APT_CODE`) VALUES (9,"PPB");
INSERT INTO `PLO_SECURITE_DE_SURFACE`(`PER_NUM`) VALUES (1);
INSERT INTO `PLO_SECURITE_DE_SURFACE`(`PER_NUM`) VALUES (5);
INSERT INTO `PLO_SECURITE_DE_SURFACE`(`PER_NUM`) VALUES (4);
INSERT INTO `PLO_SECURITE_DE_SURFACE`(`PER_NUM`) VALUES (9);
INSERT INTO `PLO_SECURITE_DE_SURFACE`(`PER_NUM`) VALUES (22);
INSERT INTO `PLO_SECURITE_DE_SURFACE`(`PER_NUM`) VALUES (10);
INSERT INTO `PLO_DIRECTEUR`(`PER_NUM`) VALUES (2);
INSERT INTO `PLO_DIRECTEUR`(`PER_NUM`) VALUES (1);
INSERT INTO `PLO_DIRECTEUR`(`PER_NUM`) VALUES (6);
INSERT INTO `PLO_DIRECTEUR`(`PER_NUM`) VALUES (16);
INSERT INTO `PLO_DIRECTEUR`(`PER_NUM`) VALUES (18);
INSERT INTO `PLO_DIRECTEUR`(`PER_NUM`) VALUES (20);
INSERT INTO `PLO_EMBARCATION`(`EMB_NUM`, `EMB_NOM`) VALUES (1,"titanic");
INSERT INTO `PLO_EMBARCATION`(`EMB_NUM`, `EMB_NOM`) VALUES (2,"Black Pearl");
INSERT INTO `PLO_EMBARCATION`(`EMB_NUM`, `EMB_NOM`) VALUES (3,"Hollandais volant");
INSERT INTO `PLO_SITE`(`SIT_NUM`, `SIT_NOM`, `SIT_LOCALISATION`) VALUES (1,"Triangle des bermude","Pacifique");
INSERT INTO `PLO_SITE`(`SIT_NUM`, `SIT_NOM`, `SIT_LOCALISATION`) VALUES (2,"Caraibe","Caraibe");
INSERT INTO `PLO_SITE`(`SIT_NUM`, `SIT_NOM`, `SIT_LOCALISATION`) VALUES (3,"Atlantide","Perdu");
INSERT INTO `PLO_PLONGEE`(`PLO_DATE`, `PLO_MAT_MID_SOI`, `SIT_NUM`, `EMB_NUM`, `PER_NUM_DIR`, `PER_NUM_SECU`, `PLO_EFFECTIF_PLONGEURS`, `PLO_EFFECTIF_BATEAU`, `PLO_NB_PALANQUEES`, `PLO_ETAT`) VALUES (STR_TO_DATE('02/10/2018','%d/%m/%Y'),"A",1,1,1,22,10,15,2,"Complète");
INSERT INTO `PLO_PLONGEE`(`PLO_DATE`, `PLO_MAT_MID_SOI`, `SIT_NUM`, `EMB_NUM`, `PER_NUM_DIR`, `PER_NUM_SECU`, `PLO_EFFECTIF_PLONGEURS`, `PLO_EFFECTIF_BATEAU`, `PLO_NB_PALANQUEES`, `PLO_ETAT`) VALUES (STR_TO_DATE('10/10/2019','%d/%m/%Y'),"M",1,1,1,10,10,15,2,"Complète");
INSERT INTO `PLO_PLONGEE`(`PLO_DATE`, `PLO_MAT_MID_SOI`, `SIT_NUM`, `EMB_NUM`, `PER_NUM_DIR`, `PER_NUM_SECU`, `PLO_EFFECTIF_PLONGEURS`, `PLO_EFFECTIF_BATEAU`, `PLO_NB_PALANQUEES`, `PLO_ETAT`) VALUES (STR_TO_DATE('15/10/2019','%d/%m/%Y'),"S",1,2,2,5,2,20,4,"Paramétrée");
INSERT INTO `PLO_PLONGEE`(`PLO_DATE`, `PLO_MAT_MID_SOI`, `SIT_NUM`, `EMB_NUM`, `PER_NUM_DIR`, `PER_NUM_SECU`, `PLO_EFFECTIF_PLONGEURS`, `PLO_EFFECTIF_BATEAU`, `PLO_NB_PALANQUEES`, `PLO_ETAT`) VALUES (STR_TO_DATE('16/10/2019','%d/%m/%Y'),"A",2,1,6,4,20,26,2,"Complète");
INSERT INTO `PLO_PLONGEE`(`PLO_DATE`, `PLO_MAT_MID_SOI`, `SIT_NUM`, `EMB_NUM`, `PER_NUM_DIR`, `PER_NUM_SECU`, `PLO_EFFECTIF_PLONGEURS`, `PLO_EFFECTIF_BATEAU`, `PLO_NB_PALANQUEES`, `PLO_ETAT`) VALUES (STR_TO_DATE('10/11/2019','%d/%m/%Y'),"M",3,3,1,5,3,3,2,"Paramétrée");
INSERT INTO `PLO_PLONGEE`(`PLO_DATE`, `PLO_MAT_MID_SOI`, `SIT_NUM`, `EMB_NUM`, `PER_NUM_DIR`, `PER_NUM_SECU`, `PLO_EFFECTIF_PLONGEURS`, `PLO_EFFECTIF_BATEAU`, `PLO_NB_PALANQUEES`, `PLO_ETAT`) VALUES (STR_TO_DATE('10/11/2019','%d/%m/%Y'),"A",3,3,1,5,3,3,0,"Créée");
INSERT INTO `PLO_PLONGEE`(`PLO_DATE`, `PLO_MAT_MID_SOI`, `SIT_NUM`, `EMB_NUM`, `PER_NUM_DIR`, `PER_NUM_SECU`, `PLO_EFFECTIF_PLONGEURS`, `PLO_EFFECTIF_BATEAU`, `PLO_NB_PALANQUEES`, `PLO_ETAT`) VALUES (STR_TO_DATE('10/11/2019','%d/%m/%Y'),"S",3,3,1,5,3,3,0,"Créée");
INSERT INTO `PLO_PALANQUEE`(`PLO_DATE`, `PLO_MAT_MID_SOI`, `PAL_NUM`, `PAL_PROFONDEUR_MAX`, `PAL_DUREE_MAX`, `PAL_HEURE_IMMERSION`, `PAL_HEURE_SORTIE_EAU`, `PAL_PROFONDEUR_REELLE`, `PAL_DUREE_FOND`) VALUES (STR_TO_DATE('02/10/2018','%d/%m/%Y'),"A",1,20,7,TIME_FORMAT('10', '%h'),TIME_FORMAT('11', '%h'),5,5);
INSERT INTO `PLO_PALANQUEE`(`PLO_DATE`, `PLO_MAT_MID_SOI`, `PAL_NUM`, `PAL_PROFONDEUR_MAX`, `PAL_DUREE_MAX`, `PAL_HEURE_IMMERSION`, `PAL_HEURE_SORTIE_EAU`, `PAL_PROFONDEUR_REELLE`, `PAL_DUREE_FOND`) VALUES (STR_TO_DATE('02/10/2018','%d/%m/%Y'),"A",2,6,9,TIME_FORMAT('15', '%h'),TIME_FORMAT('16', '%h'),50,15);
INSERT INTO `PLO_PALANQUEE`(`PLO_DATE`, `PLO_MAT_MID_SOI`, `PAL_NUM`, `PAL_PROFONDEUR_MAX`, `PAL_DUREE_MAX`, `PAL_HEURE_IMMERSION`, `PAL_HEURE_SORTIE_EAU`, `PAL_PROFONDEUR_REELLE`, `PAL_DUREE_FOND`) VALUES (STR_TO_DATE('10/10/2019','%d/%m/%Y'),"M",1,10,5,TIME_FORMAT('10', '%h'),TIME_FORMAT('11', '%h'),20,5);
INSERT INTO `PLO_PALANQUEE`(`PLO_DATE`, `PLO_MAT_MID_SOI`, `PAL_NUM`, `PAL_PROFONDEUR_MAX`, `PAL_DUREE_MAX`, `PAL_HEURE_IMMERSION`, `PAL_HEURE_SORTIE_EAU`, `PAL_PROFONDEUR_REELLE`, `PAL_DUREE_FOND`) VALUES (STR_TO_DATE('10/10/2019','%d/%m/%Y'),"M",2,15,10,TIME_FORMAT('15', '%h'),TIME_FORMAT('16', '%h'),10,15);
INSERT INTO `PLO_PALANQUEE`(`PLO_DATE`, `PLO_MAT_MID_SOI`, `PAL_NUM`, `PAL_PROFONDEUR_MAX`, `PAL_DUREE_MAX`, `PAL_HEURE_IMMERSION`, `PAL_HEURE_SORTIE_EAU`, `PAL_PROFONDEUR_REELLE`, `PAL_DUREE_FOND`) VALUES (STR_TO_DATE('15/10/2019','%d/%m/%Y'),"S",1,10,5,TIME_FORMAT('10', '%h'),TIME_FORMAT('11', '%h'),20,5);
INSERT INTO `PLO_PALANQUEE`(`PLO_DATE`, `PLO_MAT_MID_SOI`, `PAL_NUM`, `PAL_PROFONDEUR_MAX`, `PAL_DUREE_MAX`, `PAL_HEURE_IMMERSION`, `PAL_HEURE_SORTIE_EAU`, `PAL_PROFONDEUR_REELLE`, `PAL_DUREE_FOND`) VALUES (STR_TO_DATE('15/10/2019','%d/%m/%Y'),"S",2,15,10,TIME_FORMAT('15', '%h'),TIME_FORMAT('16', '%h'),10,15);
INSERT INTO `PLO_PALANQUEE`(`PLO_DATE`, `PLO_MAT_MID_SOI`, `PAL_NUM`, `PAL_PROFONDEUR_MAX`, `PAL_DUREE_MAX`) VALUES (STR_TO_DATE('15/10/2019','%d/%m/%Y'),"S",3,5,15);
INSERT INTO `PLO_PALANQUEE`(`PLO_DATE`, `PLO_MAT_MID_SOI`, `PAL_NUM`, `PAL_PROFONDEUR_MAX`, `PAL_DUREE_MAX`) VALUES (STR_TO_DATE('15/10/2019','%d/%m/%Y'),"S",4,20,20);
INSERT INTO `PLO_PALANQUEE`(`PLO_DATE`, `PLO_MAT_MID_SOI`, `PAL_NUM`, `PAL_PROFONDEUR_MAX`, `PAL_DUREE_MAX`, `PAL_HEURE_IMMERSION`, `PAL_HEURE_SORTIE_EAU`, `PAL_PROFONDEUR_REELLE`, `PAL_DUREE_FOND`) VALUES (STR_TO_DATE('16/10/2019','%d/%m/%Y'),"A",1,10,5,TIME_FORMAT('19', '%h'),TIME_FORMAT('20', '%h'),10,20);
INSERT INTO `PLO_PALANQUEE`(`PLO_DATE`, `PLO_MAT_MID_SOI`, `PAL_NUM`, `PAL_PROFONDEUR_MAX`, `PAL_DUREE_MAX`, `PAL_HEURE_IMMERSION`, `PAL_HEURE_SORTIE_EAU`, `PAL_PROFONDEUR_REELLE`, `PAL_DUREE_FOND`) VALUES (STR_TO_DATE('16/10/2019','%d/%m/%Y'),"A",2,15,10,TIME_FORMAT('14', '%h'),TIME_FORMAT('15', '%h'),20,15);
INSERT INTO `PLO_PALANQUEE`(`PLO_DATE`, `PLO_MAT_MID_SOI`, `PAL_NUM`, `PAL_PROFONDEUR_MAX`, `PAL_DUREE_MAX`) VALUES (STR_TO_DATE('10/11/2019','%d/%m/%Y'),"M",1,20,20);
INSERT INTO `PLO_PALANQUEE`(`PLO_DATE`, `PLO_MAT_MID_SOI`, `PAL_NUM`, `PAL_PROFONDEUR_MAX`, `PAL_DUREE_MAX`) VALUES (STR_TO_DATE('10/11/2019','%d/%m/%Y'),"M",2,5,20);
INSERT INTO `PLO_CONCERNER`(`PLO_DATE`, `PLO_MAT_MID_SOI`, `PAL_NUM`, `PER_NUM`) VALUES (STR_TO_DATE('02/10/2018','%d/%m/%Y'),"A",1,3);
INSERT INTO `PLO_CONCERNER`(`PLO_DATE`, `PLO_MAT_MID_SOI`, `PAL_NUM`, `PER_NUM`) VALUES (STR_TO_DATE('02/10/2018','%d/%m/%Y'),"A",1,4);
INSERT INTO `PLO_CONCERNER`(`PLO_DATE`, `PLO_MAT_MID_SOI`, `PAL_NUM`, `PER_NUM`) VALUES (STR_TO_DATE('02/10/2018','%d/%m/%Y'),"A",1,5);
INSERT INTO `PLO_CONCERNER`(`PLO_DATE`, `PLO_MAT_MID_SOI`, `PAL_NUM`, `PER_NUM`) VALUES (STR_TO_DATE('02/10/2018','%d/%m/%Y'),"A",1,7);
INSERT INTO `PLO_CONCERNER`(`PLO_DATE`, `PLO_MAT_MID_SOI`, `PAL_NUM`, `PER_NUM`) VALUES (STR_TO_DATE('02/10/2018','%d/%m/%Y'),"A",2,6);
INSERT INTO `PLO_CONCERNER`(`PLO_DATE`, `PLO_MAT_MID_SOI`, `PAL_NUM`, `PER_NUM`) VALUES (STR_TO_DATE('02/10/2018','%d/%m/%Y'),"A",2,9);
INSERT INTO `PLO_CONCERNER`(`PLO_DATE`, `PLO_MAT_MID_SOI`, `PAL_NUM`, `PER_NUM`) VALUES (STR_TO_DATE('02/10/2018','%d/%m/%Y'),"A",2,16);
INSERT INTO `PLO_CONCERNER`(`PLO_DATE`, `PLO_MAT_MID_SOI`, `PAL_NUM`, `PER_NUM`) VALUES (STR_TO_DATE('02/10/2018','%d/%m/%Y'),"A",2,19);
INSERT INTO `PLO_CONCERNER`(`PLO_DATE`, `PLO_MAT_MID_SOI`, `PAL_NUM`, `PER_NUM`) VALUES (STR_TO_DATE('10/10/2019','%d/%m/%Y'),"M",1,0);
INSERT INTO `PLO_CONCERNER`(`PLO_DATE`, `PLO_MAT_MID_SOI`, `PAL_NUM`, `PER_NUM`) VALUES (STR_TO_DATE('10/10/2019','%d/%m/%Y'),"M",1,3);
INSERT INTO `PLO_CONCERNER`(`PLO_DATE`, `PLO_MAT_MID_SOI`, `PAL_NUM`, `PER_NUM`) VALUES (STR_TO_DATE('10/10/2019','%d/%m/%Y'),"M",1,5);
INSERT INTO `PLO_CONCERNER`(`PLO_DATE`, `PLO_MAT_MID_SOI`, `PAL_NUM`, `PER_NUM`) VALUES (STR_TO_DATE('10/10/2019','%d/%m/%Y'),"M",1,7);
INSERT INTO `PLO_CONCERNER`(`PLO_DATE`, `PLO_MAT_MID_SOI`, `PAL_NUM`, `PER_NUM`) VALUES (STR_TO_DATE('10/10/2019','%d/%m/%Y'),"M",2,18);
INSERT INTO `PLO_CONCERNER`(`PLO_DATE`, `PLO_MAT_MID_SOI`, `PAL_NUM`, `PER_NUM`) VALUES (STR_TO_DATE('10/10/2019','%d/%m/%Y'),"M",2,4);
INSERT INTO `PLO_CONCERNER`(`PLO_DATE`, `PLO_MAT_MID_SOI`, `PAL_NUM`, `PER_NUM`) VALUES (STR_TO_DATE('10/10/2019','%d/%m/%Y'),"M",2,22);
INSERT INTO `PLO_CONCERNER`(`PLO_DATE`, `PLO_MAT_MID_SOI`, `PAL_NUM`, `PER_NUM`) VALUES (STR_TO_DATE('10/10/2019','%d/%m/%Y'),"M",2,13);
INSERT INTO `PLO_CONCERNER`(`PLO_DATE`, `PLO_MAT_MID_SOI`, `PAL_NUM`, `PER_NUM`) VALUES (STR_TO_DATE('15/10/2019','%d/%m/%Y'),"S",1,0);
INSERT INTO `PLO_CONCERNER`(`PLO_DATE`, `PLO_MAT_MID_SOI`, `PAL_NUM`, `PER_NUM`) VALUES (STR_TO_DATE('15/10/2019','%d/%m/%Y'),"S",1,22);
INSERT INTO `PLO_CONCERNER`(`PLO_DATE`, `PLO_MAT_MID_SOI`, `PAL_NUM`, `PER_NUM`) VALUES (STR_TO_DATE('15/10/2019','%d/%m/%Y'),"S",2,24);
INSERT INTO `PLO_CONCERNER`(`PLO_DATE`, `PLO_MAT_MID_SOI`, `PAL_NUM`, `PER_NUM`) VALUES (STR_TO_DATE('15/10/2019','%d/%m/%Y'),"S",2,9);
INSERT INTO `PLO_CONCERNER`(`PLO_DATE`, `PLO_MAT_MID_SOI`, `PAL_NUM`, `PER_NUM`) VALUES (STR_TO_DATE('15/10/2019','%d/%m/%Y'),"S",3,18);
INSERT INTO `PLO_CONCERNER`(`PLO_DATE`, `PLO_MAT_MID_SOI`, `PAL_NUM`, `PER_NUM`) VALUES (STR_TO_DATE('15/10/2019','%d/%m/%Y'),"S",3,13);
INSERT INTO `PLO_CONCERNER`(`PLO_DATE`, `PLO_MAT_MID_SOI`, `PAL_NUM`, `PER_NUM`) VALUES (STR_TO_DATE('15/10/2019','%d/%m/%Y'),"S",4,7);
INSERT INTO `PLO_CONCERNER`(`PLO_DATE`, `PLO_MAT_MID_SOI`, `PAL_NUM`, `PER_NUM`) VALUES (STR_TO_DATE('15/10/2019','%d/%m/%Y'),"S",4,3);
INSERT INTO `PLO_CONCERNER`(`PLO_DATE`, `PLO_MAT_MID_SOI`, `PAL_NUM`, `PER_NUM`) VALUES (STR_TO_DATE('16/10/2019','%d/%m/%Y'),"A",1,3);
INSERT INTO `PLO_CONCERNER`(`PLO_DATE`, `PLO_MAT_MID_SOI`, `PAL_NUM`, `PER_NUM`) VALUES (STR_TO_DATE('16/10/2019','%d/%m/%Y'),"A",1,4);
INSERT INTO `PLO_CONCERNER`(`PLO_DATE`, `PLO_MAT_MID_SOI`, `PAL_NUM`, `PER_NUM`) VALUES (STR_TO_DATE('16/10/2019','%d/%m/%Y'),"A",1,9);
INSERT INTO `PLO_CONCERNER`(`PLO_DATE`, `PLO_MAT_MID_SOI`, `PAL_NUM`, `PER_NUM`) VALUES (STR_TO_DATE('16/10/2019','%d/%m/%Y'),"A",1,24);
INSERT INTO `PLO_CONCERNER`(`PLO_DATE`, `PLO_MAT_MID_SOI`, `PAL_NUM`, `PER_NUM`) VALUES (STR_TO_DATE('16/10/2019','%d/%m/%Y'),"A",2,7);
INSERT INTO `PLO_CONCERNER`(`PLO_DATE`, `PLO_MAT_MID_SOI`, `PAL_NUM`, `PER_NUM`) VALUES (STR_TO_DATE('16/10/2019','%d/%m/%Y'),"A",2,18);
INSERT INTO `PLO_CONCERNER`(`PLO_DATE`, `PLO_MAT_MID_SOI`, `PAL_NUM`, `PER_NUM`) VALUES (STR_TO_DATE('16/10/2019','%d/%m/%Y'),"A",2,22);
INSERT INTO `PLO_CONCERNER`(`PLO_DATE`, `PLO_MAT_MID_SOI`, `PAL_NUM`, `PER_NUM`) VALUES (STR_TO_DATE('16/10/2019','%d/%m/%Y'),"A",2,13);
INSERT INTO `PLO_CONCERNER`(`PLO_DATE`, `PLO_MAT_MID_SOI`, `PAL_NUM`, `PER_NUM`) VALUES (STR_TO_DATE('10/11/2019','%d/%m/%Y'),"M",1,0);
INSERT INTO `PLO_CONCERNER`(`PLO_DATE`, `PLO_MAT_MID_SOI`, `PAL_NUM`, `PER_NUM`) VALUES (STR_TO_DATE('10/11/2019','%d/%m/%Y'),"M",1,24);
INSERT INTO `PLO_CONCERNER`(`PLO_DATE`, `PLO_MAT_MID_SOI`, `PAL_NUM`, `PER_NUM`) VALUES (STR_TO_DATE('10/11/2019','%d/%m/%Y'),"M",1,18);
INSERT INTO `PLO_CONCERNER`(`PLO_DATE`, `PLO_MAT_MID_SOI`, `PAL_NUM`, `PER_NUM`) VALUES (STR_TO_DATE('10/11/2019','%d/%m/%Y'),"M",1,13);
INSERT INTO `PLO_CONCERNER`(`PLO_DATE`, `PLO_MAT_MID_SOI`, `PAL_NUM`, `PER_NUM`) VALUES (STR_TO_DATE('10/11/2019','%d/%m/%Y'),"M",2,3);
INSERT INTO `PLO_CONCERNER`(`PLO_DATE`, `PLO_MAT_MID_SOI`, `PAL_NUM`, `PER_NUM`) VALUES (STR_TO_DATE('10/11/2019','%d/%m/%Y'),"M",2,6);
INSERT INTO `PLO_CONCERNER`(`PLO_DATE`, `PLO_MAT_MID_SOI`, `PAL_NUM`, `PER_NUM`) VALUES (STR_TO_DATE('10/11/2019','%d/%m/%Y'),"M",2,4);
INSERT INTO `PLO_CONCERNER`(`PLO_DATE`, `PLO_MAT_MID_SOI`, `PAL_NUM`, `PER_NUM`) VALUES (STR_TO_DATE('10/11/2019','%d/%m/%Y'),"M",2,19);