-
Notifications
You must be signed in to change notification settings - Fork 1
/
povoamento.sql
670 lines (656 loc) · 78.4 KB
/
povoamento.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
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
USE caogest;
-- User
INSERT INTO User VALUES('[email protected]', 'caogestadmin', 0, 0);
INSERT INTO User VALUES('[email protected]','carolina',1,0);
INSERT INTO User VALUES('[email protected]','rodolfapass',1, 0);
INSERT INTO User VALUES('[email protected]','ferreirinha123',1, 0);
INSERT INTO User VALUES('[email protected]','mypass12',1, 0);
INSERT INTO User VALUES('[email protected]','silvamarco',1, 0);
INSERT INTO User VALUES('[email protected]','1cristina',1, 0);
INSERT INTO User VALUES('[email protected]','micas998',1, 0);
INSERT INTO User VALUES('[email protected]','manuelcaogest',1, 0);
INSERT INTO User VALUES('[email protected]','josejoaquim',1, 0);
INSERT INTO User VALUES('[email protected]','guilhermina',1, 0);
INSERT INTO User VALUES('[email protected]','manuelantunes',1, 0);
INSERT INTO User VALUES('[email protected]','margarida1freitas',1, 0);
INSERT INTO User VALUES('[email protected]','pedrofrazao',1, 0);
INSERT INTO User VALUES('[email protected]','menezesaurora',1, 0);
INSERT INTO User VALUES('[email protected]','soniaraujo',1, 0);
INSERT INTO User VALUES('[email protected]','joanapereira',1, 0);
INSERT INTO User VALUES('[email protected]','antoniomoreira',1, 0);
INSERT INTO User VALUES('[email protected]','amelia',1, 0);
INSERT INTO User VALUES('[email protected]','ameliana',1, 0);
INSERT INTO User VALUES('[email protected]','joanavaz',1, 0);
INSERT INTO User VALUES('[email protected]','felisberto',1, 0);
INSERT INTO User VALUES('[email protected]','marianasantos',1, 0);
INSERT INTO User VALUES('[email protected]','vilarcatia',1, 0);
INSERT INTO User VALUES('[email protected]','eduardalongras',1, 0);
INSERT INTO User VALUES('[email protected]','veracarvalho',1, 0);
INSERT INTO User VALUES('[email protected]','justina',1, 0);
INSERT INTO User VALUES('[email protected]','silviamatos58',1, 0);
INSERT INTO User VALUES('[email protected]','lauramatos',1, 0);
INSERT INTO User VALUES('[email protected]','armando',1, 0);
INSERT INTO User VALUES('[email protected]','claudiocarvalho',1, 0);
INSERT INTO User VALUES('[email protected]','henriqueferreira',1, 0);
INSERT INTO User VALUES('[email protected]','leonelcosta24',1, 0);
INSERT INTO User VALUES('[email protected]','romeu',1, 0);
INSERT INTO User VALUES('[email protected]','joaopaulo',1, 0);
INSERT INTO User VALUES('[email protected]','filipefreitas',1, 0);
INSERT INTO User VALUES('[email protected]','marcosoliveira12',1, 0);
INSERT INTO User VALUES('[email protected]','celiarodrigues',1, 0);
INSERT INTO User VALUES('[email protected]','cristinarodrigues',1, 0);
INSERT INTO User VALUES('[email protected]','evamorais',1, 0);
INSERT INTO User VALUES('[email protected]','liliana12freitas',1, 0);
INSERT INTO User VALUES('[email protected]','loidesilva',1, 0);
INSERT INTO User VALUES('[email protected]','anabelacarvalho',1, 0);
INSERT INTO User VALUES('[email protected]','salomeMartins',1, 0);
INSERT INTO User VALUES('[email protected]','estefania',1, 0);
INSERT INTO User VALUES('[email protected]','lucindapacheco',1, 0);
INSERT INTO User VALUES('[email protected]','florbela',1, 0);
INSERT INTO User VALUES('[email protected]','alexandraleite',1, 0);
INSERT INTO User VALUES('[email protected]','vieira',1, 0);
INSERT INTO User VALUES('[email protected]','teresavilela',1, 0);
INSERT INTO User VALUES('[email protected]','ritinhanovais',1, 0);
INSERT INTO User VALUES('[email protected]','josemiguelribeiro',1, 0);
INSERT INTO User VALUES('[email protected]','marisa',1, 0);
INSERT INTO User VALUES('[email protected]','rafaelalves',1, 0);
INSERT INTO User VALUES('[email protected]','carlasousa',1, 0);
INSERT INTO User VALUES('[email protected]','marcoantonio',1, 0);
INSERT INTO User VALUES('[email protected]','ritadiana',1, 0);
INSERT INTO User VALUES('[email protected]','andreiapereira',1, 0);
INSERT INTO User VALUES('[email protected]','gracindamatias',1, 0);
INSERT INTO User VALUES('[email protected]','penso',1, 0);
INSERT INTO User VALUES('[email protected]','emiliaribeiro',1, 0);
INSERT INTO User VALUES('[email protected]','fatima',1, 0);
INSERT INTO User VALUES('[email protected]','joaoricardo',1, 0);
INSERT INTO User VALUES('[email protected]','josepereira',1, 0);
INSERT INTO User VALUES('[email protected]','arturlemos',1, 0);
INSERT INTO User VALUES('[email protected]','soniaribeiro',1, 0);
INSERT INTO User VALUES('[email protected]','rosamarinho',1, 0);
INSERT INTO User VALUES('[email protected]','alicinhanovais',1, 0);
INSERT INTO User VALUES('[email protected]','guilhermenovais',1, 0);
INSERT INTO User VALUES('[email protected]','flaviacarminho',1, 0);
INSERT INTO User VALUES('[email protected]','gabrielamoreira',1, 0);
INSERT INTO User VALUES('[email protected]','carlosbartolo',1, 0);
INSERT INTO User VALUES('[email protected]', 'aaav', 2, 0);
INSERT INTO User VALUES('[email protected]', 'quatropatas', 2, 0);
INSERT INTO User VALUES('[email protected]', 'streetdogs', 2, 0);
INSERT INTO User VALUES('[email protected]', 'amica', 2, 0);
INSERT INTO User VALUES('[email protected]', 'apaae', 2, 0);
INSERT INTO User VALUES('[email protected]', 'gadaff', 2, 0);
INSERT INTO User VALUES('[email protected]', 'geral', 2, 0);
INSERT INTO User VALUES('[email protected]', 'aaparc', 2, 0);
INSERT INTO User VALUES('[email protected]', 'pproanimal', 2, 0);
INSERT INTO User VALUES('[email protected]', 'rafeiroscompanhia', 2, 0);
INSERT INTO User VALUES('[email protected]', 'focinhos', 2, 0);
INSERT INTO User VALUES('[email protected]', 'adaca', 2, 0);
INSERT INTO User VALUES('[email protected]', 'info', 2, 0);
INSERT INTO User VALUES('[email protected]', 'geral', 2, 0);
INSERT INTO User VALUES('[email protected]', 'amigos.da.bicharada', 2, 0);
INSERT INTO User VALUES('[email protected]', 'apacanimaiscadaval', 2, 0);
INSERT INTO User VALUES('[email protected]', 'apamg.geral', 2, 0);
INSERT INTO User VALUES('[email protected]', 'acasota', 2, 0);
INSERT INTO User VALUES('[email protected]', 'associacaoguadi', 2, 0);
INSERT INTO User VALUES('[email protected]', 'pata.ativa', 2, 0);
INSERT INTO User VALUES('[email protected]', 'cat.cantinhodosanimais', 2, 0);
INSERT INTO User VALUES('[email protected]','joao',2,0);
-- Utilizador
INSERT INTO Utilizador VALUES ('[email protected]','Rodolfina Oliveira','1984/03/05','Braga','Rua da Porta','Caldas de Vizela','13141232','Feminino','919187762', 0,'404937371');
INSERT INTO Utilizador VALUES ('[email protected]','Sofia Ferreira','1976/09/06','Braga','Rua de Santa Margarida','Braga','25912338','Feminino','965748219', 0,'276560690');
INSERT INTO Utilizador VALUES ('[email protected]','Nuno Dias','2007/02/05','Porto','Travessa das Arroteias','Rio Tinto','12345697','Masculino','928791236', 0,'227180608');
INSERT INTO Utilizador VALUES ('[email protected]','Marco Silva','1992/08/22','Braga','Rua Primeiro de Maio','Braga','65425167','Masculino','938102941', 0,'897923809');
INSERT INTO Utilizador VALUES ('[email protected]','Cristina Pinheiro','1983/11/12','Porto','Rua de Portugal','Valongo','97867514','Feminino','918265910', 0,'862334712');
INSERT INTO Utilizador VALUES ('[email protected]','Miquelina Maria','1987/01/15','Braga','Rua Gil Vicente','Guimarães','13356412','Feminino','934561297', 0,'417507009');
INSERT INTO Utilizador VALUES ('[email protected]','Francisco Manuel','2013/02/09','Braga','Rua Maximino de Matos','Fafe','995513531','Masculino','961296503', 0,'589266514');
INSERT INTO Utilizador VALUES ('[email protected]','José Joaquim','1967/05/28','Braga','Rua Camilo Castelo Branco','Vila Nova de Famalicão','772413145','Masculino','912436109', 0,'336604097');
INSERT INTO Utilizador VALUES ('[email protected]','Guilhermina Sá Freitas','1999/10/17','Porto','Rua Santa Catarina','Porto','13389721','Feminino','931409809', 0,'312293085');
INSERT INTO Utilizador VALUES ('[email protected]','Manuel Antunes','1980/03/25','Porto','Rua de Bom Jardim','Paredes','35376115','Masculino','961296438', 0,'941336871');
INSERT INTO Utilizador VALUES ('[email protected]','Margarida Freitas','1988/04/27','Braga','Rua da Misericórdia','Vila Verde','22583954','Feminino','911123412', 0,'805194843');
INSERT INTO Utilizador VALUES ('[email protected]','Pedro Frazão','1988/08/10','Braga','Rua da Igreja','Póvoa de Lanhoso','66755315','Masculino','932456123', 0,'840302748');
INSERT INTO Utilizador VALUES ('[email protected]','Aurora Menezes','1957/11/11','Porto','Rua Padre Américo','Penafiel','18082725','Feminino','912401967', 0,'926991034');
INSERT INTO Utilizador VALUES ('[email protected]','Sónia Araújo','1992/09/25','Viana do Castelo','Praça da República','Caminha','51794325','Feminino','912300098', 0,'561104814');
INSERT INTO Utilizador VALUES ('[email protected]','Joana Pereira','2003/05/05','Viana do Castelo','Rua das Barcas','Ponte da Barca','69315615','Feminino','914443215', 0,'429975467');
INSERT INTO Utilizador VALUES ('[email protected]','António Moreira','1958/12/12','Braga','Rua São João de Deus','Vila Nova de Famalicão','95413251','Masculino','931122334', 0,'303215910');
INSERT INTO Utilizador VALUES ('[email protected]','Amélia Carmélia','1968/01/31','Braga','Rua São Marcos','Felgueiras','57638288','Feminino','918908907', 0,'652471303');
INSERT INTO Utilizador VALUES ('[email protected]','Ameliana Carmo','1962/06/21','Braga','Avenida Central','Braga','57613216','Feminino','913453458', 0,'419992055');
INSERT INTO Utilizador VALUES ('[email protected]','Joana Vaz','1997/10/19','Braga','Rua da Porta Nova','Braga','15263787','Feminino','912396748', 0,'878063378');
INSERT INTO Utilizador VALUES ('[email protected]','Felisberto Castro','1994/06/21','Braga','Rua Cândido dos Reis','Barcelos','83927153','Masculino','912398654', 0,'384325654');
INSERT INTO Utilizador VALUES ('[email protected]','Mariana Santos','1992/10/29','Braga','Rua da Senhorinha','Cabeceiras de Basto','1514132','Feminino','912312764', 0,'999361101');
INSERT INTO Utilizador VALUES ('[email protected]','Cátia Vilar','1987/10/09','Bragança','Rua Almirante Reis','Bragança','1923754','Feminino','912985411', 0,'514542519');
INSERT INTO Utilizador VALUES ('[email protected]','Eduarda Longras','1965/04/09','Bragança','Rua da Fonte','Vinhais','1239842','Feminino','933332343', 0,'980972498');
INSERT INTO Utilizador VALUES ('[email protected]','Vera Carvalho','1975/02/14','Bragança','Rua Caminho de Ginço','Macedo de Cavaleiros','1872635','Feminino','912312341', 0,'168901881');
INSERT INTO Utilizador VALUES ('[email protected]','Justina Nazário','1979/01/14','Vila Real','Rua da Bouça da Raposa','Vila Real','1354236','Feminino','922314528', 0,'106396122');
INSERT INTO Utilizador VALUES ('[email protected]','Silvia Matos','1958/06/24','Vila Real','Rua de Valbom','Mirandela','1445512','Feminino','912095473', 0,'240895021');
INSERT INTO Utilizador VALUES ('[email protected]','Laura Matos','1989/08/29','Vila Real','Rua Comendador Alfredo Álvares','Mondim de Basto','2396795','Feminino','913452367', 0,'952950240');
INSERT INTO Utilizador VALUES ('[email protected]','Armando Dinis','1979/03/09','Viana do Castelo','Rua de Valença','Valença','2312456','Masculino','912345890', 0,'584036351');
INSERT INTO Utilizador VALUES ('[email protected]','Cláudio Carvalho','1982/11/15','Aveiro','Rua da Ribeira','Aveiro','1283924','Masculino','913332221', 0,'963700498');
INSERT INTO Utilizador VALUES ('[email protected]','Henrique Ferreira','1997/10/17','Aveiro','Travessa Visconde','São João da Madeira','1112349','Masculino','93949512', 0,'024344899');
INSERT INTO Utilizador VALUES ('[email protected]','Leonel Costa','1980/01/25','Aveiro','Travessa Visconde','Albergaria-A-Velha','3124572','Masculino','931213141', 0,'455728561');
INSERT INTO Utilizador VALUES ('[email protected]','Romeu Pereira','1989/09/01','Viseu','Rua das Cameiras','Lamego','4127823','Masculino','923242521', 0,'938185882');
INSERT INTO Utilizador VALUES ('[email protected]','João Paulo Silva','1999/12/21','Viseu','Rua Nunes de Carvalho','Viseu','1235553','Masculino','912156545', 0, '573317976');
INSERT INTO Utilizador VALUES ('[email protected]','Filipe Freitas','1998/02/13','Viseu','Rua Doutor Oliveira Serrão','Sernancelhe','1452511','Masculino','939323490', 0,'365254552');
INSERT INTO Utilizador VALUES ('[email protected]','Marcos Oliveira','2002/04/12','Guarda','Rua do Hospital','Covilhã','2341234','Masculino','919123123', 0, '658526272');
INSERT INTO Utilizador VALUES ('[email protected]','Célia Rodrigues','1959/03/01','Guarda','Avenida da República','Trancoso','1112878','Feminino','929391234', 0, '529076536');
INSERT INTO Utilizador VALUES ('[email protected]','Cristina Rodrigues','1979/05/11','Castelo Branco','Travessa de Santana','Vila Velha de Rodão','1231111','Feminino','912312399', 0, '408677838');
INSERT INTO Utilizador VALUES ('[email protected]','Eva Morais','1967/08/14','Coimbra','Avenida de Coimbra','Coimbra','7642312','Feminino','912223123', 0, '877607765');
INSERT INTO Utilizador VALUES ('[email protected]','Liliana Freitas','1996/11/30','Coimbra','Rua da Ribeira','Lousã','1239555','Feminino','913454562', 0, '344877213');
INSERT INTO Utilizador VALUES ('[email protected]','Loide Silva','1956/01/31','Coimbra','Rua São Lourenço','Penela','1451231','Masculino','965676132', 0, '130362050');
INSERT INTO Utilizador VALUES ('[email protected]','Anabela Carvalho','1971/02/01','Leiria','Rua Vieira de Leiria','Marinha Grande','4523412','Feminino','968743123', 0, '367306629');
INSERT INTO Utilizador VALUES ('[email protected]','Salomé Martins','1982/09/20','Leiria','Rua São Francisco','Leiria','8976123','Feminino','967687621', 0, '400140959');
INSERT INTO Utilizador VALUES ('[email protected]','Estefânia Bustabad','1952/10/22','Leiria','Travessa da Nazaré','Nazaré','7523142','Feminino','967213321', 0, '716965281');
INSERT INTO Utilizador VALUES ('[email protected]','Carlos Bártolo','1949/07/02','Santarém','Rua Doutor Egas Moniz','Tomar','4617182','Masculino','965689123', 0, '691168087');
INSERT INTO Utilizador VALUES ('[email protected]','Lucinda Pacheco','1960/09/14','Santarém','Rua Cinco de Outubro','Almeirim','9087625','Feminino','934212345', 0, '019433462');
INSERT INTO Utilizador VALUES ('[email protected]','Florbela Teixeira','1971/09/09','Lisboa','Rua Santo António de Lisboa','Amadora','5261372','Feminino','969998731', 0, '145870521');
INSERT INTO Utilizador VALUES ('[email protected]','Alexandra Leite','1999/06/27','Lisboa','Rua de Loures','Loures','1231231','Feminino','911111123', 0, '461905457');
INSERT INTO Utilizador VALUES ('[email protected]','Margarida Vieira','1978/03/29','Lisboa','Rua do Alcaide','Cascais','5463728','Feminino','917283413', 0, '429321092');
INSERT INTO Utilizador VALUES ('[email protected]','Teresa Vilela','1989/02/15','Lisboa','Avenida do Cristo Rei','Almada','1000892','Feminino','912312341', 0, '042863340');
INSERT INTO Utilizador VALUES ('[email protected]','Rita Novais ','1989/08/12','Portalegre','Rua da Mouraria','Portalegre','1324521','Feminino','912222213', 0, '912752581');
INSERT INTO Utilizador VALUES ('[email protected]','José Miguel Ribeiro','1970/05/26','Portalegre','Rua de Baixo','Marvão','9862713','Masculino','969897111', 0, '611468549');
INSERT INTO Utilizador VALUES ('[email protected]','Marisa João Sousa','1977/09/01','Portalegre','Rua João António Gordo','Castelo de Vide','1357986','Feminino','919293949', 0, '302676317');
INSERT INTO Utilizador VALUES ('[email protected]','Rafaela Alves','1987/01/03','Évora','Rua Dom Afonso III','Estremoz','4442123','Feminino','919299542', 0, '330363485');
INSERT INTO Utilizador VALUES ('[email protected]','Carla Sousa','1988/09/01','Évora','Rua Direita','Redondo','1288763','Feminino','917364521', 0, '450754884');
INSERT INTO Utilizador VALUES ('[email protected]','Marco António','1967/05/11','Setúbal','Rua do Convento','Setúbal','7863524','Masculino','969213425', 0, '126301068');
INSERT INTO Utilizador VALUES ('[email protected]','Rita Diana','1987/01/31','Setúbal','Rua do Zimbro','Tróia','1562731','Feminino','911213145', 0, '799808135');
INSERT INTO Utilizador VALUES ('[email protected]','Andreia Pereira','1993/10/11','Setúbal','Rua dos Ciprestes','Alcácer do Sal','6725132','Feminino','916273123', 0, '000134229');
INSERT INTO Utilizador VALUES ('[email protected]','Gracinda Matias','1965/04/21','Beja','Rua da Casa Pia','Ferreira do Alentejo','1452314','Feminino','967623142', 0, '406744137');
INSERT INTO Utilizador VALUES ('[email protected]','Ana Penso','1990/12/12','Beja','Rua de Arouche','Moura','3421231','Feminino','934212387', 0, '386452775');
INSERT INTO Utilizador VALUES ('[email protected]','Emília Ribeiro','1970/11/29','Faro','Rua João de Deus','Faro','4512738','Feminino','939281723', 0, '845149090');
INSERT INTO Utilizador VALUES ('[email protected]','Fátima Ferreira','1978/10/23','Faro','Rua 8 de Maio','Loulé','9725162','Feminino','967676212', 0, '448536372');
INSERT INTO Utilizador VALUES ('[email protected]','João Ricardo','1995/04/22','Faro','Rua da Liberdade','Olhão','1425361','Masculino','912776542', 0, '597265896');
INSERT INTO Utilizador VALUES ('[email protected]','José Pereira','1998/12/22','Angra do Heroísmo','Rua Canada das Almas','Angra do Heroísmo','7621321','Masculino','912132123', 0, '669292013');
INSERT INTO Utilizador VALUES ('[email protected]','Artur Lemos','1960/06/28','Angra do Heroísmo','Travessa do Falcão','Vila São Sebastião','3421231','Masculino','934212387', 0, '068512227');
INSERT INTO Utilizador VALUES ('[email protected]','Sónia Ribeiro','1998/01/04','Funchal','Travessa de São Martinho','Funchal','1444231','Feminino','962713281', 0, '761812660');
INSERT INTO Utilizador VALUES ('[email protected]','Rosa Marinho','1992/03/29','Funchal','Rua Semião Pestana','Porto Santo','1887231','Feminino','912367751', 0, '445141402');
INSERT INTO Utilizador VALUES ('[email protected]','Alice Novais','1963/01/07','Horta','Rua Advogado Graça','Horta','1666523','Feminino','915263123', 0, '342440289');
INSERT INTO Utilizador VALUES ('[email protected]','Guilherme Novais','1981/05/05','Horta','Rua da Igreja','Ribeirinha','1426162','Masculino','967852613', 0, '938681311');
INSERT INTO Utilizador VALUES ('[email protected]','Flávia Carminho','1970/07/02','Ponta Delgada','Avenida Antero Quental','Ponta Delgada','1452132','Feminino','919777213', 0, '860592136');
INSERT INTO Utilizador VALUES ('[email protected]','Gabriela Moreira','1984/09/21','Lisboa','Rua Castelinhos','Lisboa','1728352','Feminino','962415236', 0, '554264811');
INSERT INTO Utilizador VALUES('[email protected]','Carolina Cunha','1999/04/13','Braga','Rua de Teibães','Fafe','14744712','Feminino','915293785',0,'249705672');
-- Canis
INSERT INTO Canil VALUES('[email protected]','001000003960114000128','Canil do João',20,100,'Porto','Rua da Padaria, Lousada','Lousada','251123152','Aceite',0);
INSERT INTO Canil VALUES ('[email protected]','001000003960114000128','Associação dos Amigos dos Animais',50,200,'Aveiro','Rua do Brejo - São Marcos 3850', 'Albergaria-A-Velha', 'N/A', 'Aceite', 0);
INSERT INTO Canil VALUES ('[email protected]','003300004548044209005','Quatro Patas e Focinhos',40,150,'Aveiro','Pussos', 'Mealhada', '918570448', 'Aceite', 0);
INSERT INTO Canil VALUES ('[email protected]','002300004544552141194','StreetDogs',100,300,'Braga','Rua do Queimado','Barcelos','N/A','Aceite', 0);
INSERT INTO Canil VALUES ('[email protected]','004522164027154963919', 'Associação Amicus Canis',120,200,'Bragança', 'Alameda de Santa Apolónia 253, 5300-252 Bragança', 'Santa Apolónia' ,'926708103', 'Rejeitado', 0);
INSERT INTO Canil VALUES ('[email protected]','N/A', 'APAAE', 40,150, 'Castelo Branco', 'Rua Dr. João Frade Correia', 'Castelo Branco', '963667892', 'Aceite', 0);
INSERT INTO Canil VALUES ('[email protected]', '001000005346315000151', 'Associação Gadaff', 60,100, 'Coimbra', 'Broeiras, Figueira da Foz', 'Figueira da Foz', '912409823', 'Pendente', 0);
INSERT INTO Canil VALUES ('[email protected]', '001800080617255402014', 'Associação Faialense dos Amigos dos Animais', 70,100, 'Açores', 'Canada dos Arrendamentos','Faial', '926374477', 'Aceite', 0);
INSERT INTO Canil VALUES ('[email protected]', '004510904027009161388', 'Associação dos Amigos e Protectores dos Animais em Risco de Cinfães', 36,60, 'Viseu', 'R MAJOR MONTEIRO LEITE 39, 4690-042','Cinfães', 'N/A', 'Aceite', 0);
INSERT INTO Canil VALUES ('[email protected]', '001000004814325000121', 'Plataforma Proanimal', 29,60, 'Vila Real', ' R. Dom Pedro de Castro, Vila Real','Vila Real', '910600404', 'Aceite', 0);
INSERT INTO Canil VALUES ('[email protected]', '003300004542571236205', 'Rafeiros e Companhia', 52,74, 'Viana do Castelo', ' Monção, Viana do Castelo','Monção', '969179738', 'Aceite', 0);
INSERT INTO Canil VALUES ('[email protected]', '004560204023925818957', 'Focinhos', 58,68, 'Setúbal', ' Beco de São Miguel, Alcácer do Sal, 7580-219','Alcácer do Sal', 'N/A', 'Aceite', 0);
INSERT INTO Canil VALUES ('[email protected]', '003507000000605213075', 'Associação Defesa dos Animais do Concelho de Abrantes', 58,68, 'Santarém', 'R. das Comissões 21-23','Abrantes', '968386916', 'Aceite', 0);
INSERT INTO Canil VALUES ('[email protected]', 'N/A', 'Associação AMAW', 25,50, 'Madeira', 'Rua Cidade de Oakland, Funchal','Funchal', '966295555', 'Aceite', 0);
INSERT INTO Canil VALUES ('[email protected]', '003504290005282393016', 'Cãoviver', 76,104, 'Porto', ' R. Central do Sobreiro, 4470-372 Maia','Maia', 'N/A', 'Pendente', 0);
INSERT INTO Canil VALUES ('[email protected]', '004602422549310010652', 'Amigos da Bicharada', 30,40, 'Portalegre', 'AV DA PIEDADE8,7350-094','Elvas', 'N/A', 'Aceite', 0);
INSERT INTO Canil VALUES ('[email protected]', '003501800001528253087', 'Associação Protectora de Animais do Cadaval', 111,152, 'Lisboa', 'Rua Padre José Inácio Pereira ','Cadaval', '927295099', 'Aceite', 0);
INSERT INTO Canil VALUES ('[email protected]', '003300004527819243405', 'Associação Protectora Animais Marinha Grande', 87,113, 'Leiria', 'Rua Machado Santos, n.21','Marinha Grande', '919737733', 'Aceite', 0);
INSERT INTO Canil VALUES ('[email protected]', '003503600004042373017', 'A Casota', 74,97, 'Guarda', 'Rua Dr Lopo de Carvalho nº37 6300-700 ','Guarda', '967243606', 'Aceite', 0);
INSERT INTO Canil VALUES ('[email protected]', '003502340000669213002', 'Associação Guadi', 70,90, 'Faro', 'Rua D. Pedro V, nº 38, 2º 8900 - 283','Vila Real de Santo António', '927167755', 'Aceite', 0);
INSERT INTO Canil VALUES ('[email protected]', '004570124028115653408', 'Pata Ativa', 83,92, 'Faro', 'Beco da Felosa, Albufeira','Albufeira', '912538744', 'Aceite', 0);
INSERT INTO Canil VALUES ('[email protected]', '003502970006941573012', 'Cantinho dos Animais', 115,135, 'Évora', 'Cantinho dos Animais, Évora','Évora', '964648988', 'Aceite', 0);
-- Voluntários
INSERT INTO Voluntarios VALUES ('[email protected]','[email protected]');
INSERT INTO Voluntarios VALUES ('[email protected]','[email protected]');
INSERT INTO Voluntarios VALUES ('[email protected]','[email protected]');
INSERT INTO Voluntarios VALUES ('[email protected]','[email protected]');
INSERT INTO Voluntarios VALUES ('[email protected]','[email protected]');
INSERT INTO Voluntarios VALUES ('[email protected]','[email protected]');
INSERT INTO Voluntarios VALUES ('[email protected]','[email protected]');
INSERT INTO Voluntarios VALUES ('[email protected]','[email protected]');
INSERT INTO Voluntarios VALUES ('[email protected]','[email protected]');
INSERT INTO Voluntarios VALUES ('[email protected]','[email protected]');
INSERT INTO Voluntarios VALUES ('[email protected]','[email protected]');
INSERT INTO Voluntarios VALUES ('[email protected]','[email protected]');
INSERT INTO Voluntarios VALUES ('[email protected]','[email protected]');
INSERT INTO Voluntarios VALUES ('[email protected]','[email protected]');
INSERT INTO Voluntarios VALUES ('[email protected]','[email protected]');
INSERT INTO Voluntarios VALUES ('[email protected]', '[email protected]');
INSERT INTO Voluntarios VALUES ('[email protected]', '[email protected]');
INSERT INTO Voluntarios VALUES ('[email protected]', '[email protected]');
-- Parceria
INSERT INTO Parceria VALUES(1, 'Clínica Veterinária Planeta Animal', 'https://www.planetaanimal.pt', 'https://www.asuaclinica.pt/wp-content/sabai/File/files/l_4b9badb1ef6d0aacefb7fdf2aaa7b9a2.png');
INSERT INTO Parceria VALUES(2, 'Clínica Veterinária de Albergaria', 'https://clinicaveterinariaalbergaria.pt' ,'https://clinicaveterinariaalbergaria.pt/wp-content/uploads/2019/09/vetalbergaria_marca.png');
INSERT INTO Parceria VALUES(3, 'Clínica Veterinária VetAmigo', 'http://www.vetamigo.com', 'https://centrostalento.pt/wp-content/uploads/vetamigo.jpg');
INSERT INTO Parceria VALUES(4, 'Hospital Veterinário do Baixo Vouga','http://www.onevetgroup.pt/hvbv/','https://www.onevetgroup.pt/media/119340/hvbv-720x149.png?mode=max&width=720&height=405');
INSERT INTO Parceria VALUES(5, 'Policlínica Veterinária de Aveiro', 'http://www.onevetgroup.pt/pvaveiro/','https://www.onevetgroup.pt/media/118237/policlinica-aveiro.png?mode=max&width=720&height=405');
INSERT INTO Parceria VALUES(6, 'Junta de Freguesia de Albergaria-A-Velha', 'https://www.jf-albergaria.pt', 'http://www.areacelular.pt/fotos_1/albergaria.jpg');
INSERT INTO Parceria VALUES(7, 'Câmara Municipal de Albergaria-A-Velha', 'https://www.cm-albergaria.pt', 'https://albacowork.pt/_files/200000036-e4f84e4f87/450/CMAAV.png');
INSERT INTO Parceria VALUES(8, 'Clínica Veterinária de Pedrinhas','https://clinicaveterinariadaspedrinhas.negocio.site', 'https://2.bp.blogspot.com/-9NCrwZwPcco/VJNxNanuvbI/AAAAAAAAFgk/n6-rd0D5UPU/s320/clinica%2Bdas%2Bpedrinhas.jpg');
INSERT INTO Parceria VALUES(9, 'Esfera Design','http://www.esfera.pt', 'https://2.bp.blogspot.com/-ltn98Aw-15I/UwZ55Yp-xsI/AAAAAAAAD0M/X9A_2rgwi5k/s1600/logo+esfera.png');
INSERT INTO Parceria VALUES(10, 'Centro Veterinário de Vilarinho', 'https://www.facebook.com/CentroVeterinarioDeVilarinho', 'https://petlaces.com/cropped/IMG34087dbaa447493fb756f930319b5423_750x500.jpg');
INSERT INTO Parceria VALUES(11, 'Best Choice Lodging', 'https://www.bestchoicelodging.com', 'https://uppa.pt/wp-content/uploads/2019/03/Best-Choice-Lodging.jpg');
INSERT INTO Parceria VALUES(12, 'Alves Bandeira','https://www.alvesbandeira.pt/rede-de-postos/', 'https://autolook.pt/wp-content/uploads/2019/05/Alves-Bandeira-Logo-300x200.png');
INSERT INTO Parceria VALUES(13, 'SOMAQ', 'https://www.facebook.com/somaq.guilhermerololda', 'https://4.bp.blogspot.com/-3U7HwmVSmho/Ua-kgqHSCvI/AAAAAAAACK0/sxqV2-t9WQ8/s320/somaq+pequeno.jpg');
INSERT INTO Parceria VALUES(14, 'VetOlival', 'https://www.facebook.com/centroveterinarioolival/', 'https://www.streetdogspt.com/img/vetolival.jpg');
INSERT INTO Parceria VALUES(15, 'WisePets', 'https://www.facebook.com/wisepetsportugal/','https://scontent.fopo2-1.fna.fbcdn.net/v/t1.0-9/36818920_1286679321465497_9200198957421035520_o.jpg?_nc_cat=102&_nc_sid=09cbfe&_nc_ohc=eNiLsDpIVUYAX8okV4L&_nc_ht=scontent.fopo2-1.fna&oh=6335f8de52359a88e7628f52cd8ca670&oe=5F25BABA');
INSERT INTO Parceria VALUES(16, 'Mia Bigodes', 'https://miabigodes.com','https://pro2-bar-s3-cdn-cf6.myportfolio.com/6b38b14a-9390-41ea-98ea-c57425e373bb/aa37201f-3ad2-4447-abf8-a11526d24e16_rwc_0x0x447x129x4096.png?h=21e3abd112d1e6dfbc3332f01b4654c5');
INSERT INTO Parceria VALUES(17, 'Fiona & Lucifera', 'https://www.facebook.com/fionalucifera/', 'https://scontent.fopo2-1.fna.fbcdn.net/v/t1.0-9/81924768_1386552338192645_6637095962751795200_n.jpg?_nc_cat=101&_nc_sid=09cbfe&_nc_ohc=r5iMVrq87y4AX8iiFXJ&_nc_ht=scontent.fopo2-1.fna&oh=d40f22ab3361a17f59cf636677bf84b5&oe=5F2519E0');
INSERT INTO Parceria VALUES(18, 'Animalife','https://animalife.pt/pt/home', 'https://upload.wikimedia.org/wikipedia/commons/1/1f/Coração_Animalife_Roxo.png');
INSERT INTO Parceria VALUES(19, 'OrniEx', 'http://www.orniex.com', 'http://www.apk.pt/wp-content/uploads/2018/06/logorniex.jpg');
INSERT INTO Parceria VALUES(20, 'Farmácia Ayres Pinheiro', 'https://www.facebook.com/farmaciaayrespinheiro', 'https://scontent.fopo2-1.fna.fbcdn.net/v/t1.0-9/70104780_2905615579513567_8848258196041629696_o.png?_nc_cat=111&_nc_sid=85a577&_nc_ohc=A3NBc42PBPQAX_33haI&_nc_ht=scontent.fopo2-1.fna&oh=e391f00dc405c783a725895d87edaeb1&oe=5ED91028');
INSERT INTO Parceria VALUES(21, 'GO Gym Lisa Medeiros','https://www.facebook.com/GO-Gym-Lisa-Medeiros-420714301416696/','https://scontent.fopo2-1.fna.fbcdn.net/v/t31.0-8/10928909_420714378083355_8659079041190972321_o.jpg?_nc_cat=105&_nc_sid=85a577&_nc_ohc=08Gp5yA07mEAX-H4sh-&_nc_ht=scontent.fopo2-1.fna&oh=9bd9ffab3c8413d2db7649e5cab19834&oe=5EDB0CAA');
INSERT INTO Parceria VALUES(22, 'Azul Pastel','http://www.loftsazulpastel.pt','https://azoreanrooms.com/wp-content/uploads/2018/04/12801129_192042014500279_3447199156715151020_n-1.jpg');
INSERT INTO Parceria VALUES(23, 'Val Vet', 'https://www.facebook.com/Valvet-Centro-Veterinário-da-Ilha-do-Faial-131539476862366/' ,'https://scontent.fopo2-1.fna.fbcdn.net/v/t1.0-9/18033578_1704644679551830_7141788561539390528_n.png?_nc_cat=105&_nc_sid=85a577&_nc_ohc=_fv2d95pSZYAX9xVtPN&_nc_ht=scontent.fopo2-1.fna&oh=7e3a9ab8b37c0c7bc7c5831b7b5d9a55&oe=5EDC7D87');
INSERT INTO Parceria VALUES(24, 'Espaço X', 'http://www.espacox.com', 'https://scontent.fopo2-1.fna.fbcdn.net/v/t1.0-9/67735738_2504080166290165_2347403938858270720_o.png?_nc_cat=101&_nc_sid=85a577&_nc_ohc=a9g5b6yinkUAX9cqJxf&_nc_ht=scontent.fopo2-1.fna&oh=aaa27dbe579de8084f538be508584655&oe=5EDB2652');
INSERT INTO Parceria VALUES(25, 'Oh My Dog', 'https://www.facebook.com/Ohmydog.face/', 'https://scontent.fopo2-1.fna.fbcdn.net/v/t1.0-9/17457642_1444311232267647_5933040043777457405_n.png?_nc_cat=105&_nc_sid=85a577&_nc_ohc=fuBx8p-7ZSsAX9TdZJc&_nc_ht=scontent.fopo2-1.fna&oh=062b2112c2707e67b7439fd755b98b6e&oe=5EDB8550');
INSERT INTO Parceria VALUES(26, 'Husse', 'https://portugal.husse.com', 'https://pbs.twimg.com/profile_images/547004873/Husse_Cat_Dog_logo_no_line.jpg');
INSERT INTO Parceria VALUES(27, 'Reino Animal', 'http://reinoanimal.pt', 'http://reinoanimal.pt/static/imgs/logo.png');
INSERT INTO Parceria VALUES(28, 'Nutridente', 'http://www.nutridente.pt', 'http://www.nutridente.pt/images/nutrilogo.png');
INSERT INTO Parceria VALUES(29, 'Ótica das Figueiras', 'https://www.opticafigueiras.pt', 'https://www.opticafigueiras.pt/img/0581/157.png');
INSERT INTO Parceria VALUES(30, 'Monte dos Animais', 'https://montedosanimais.pt', 'https://scontent.fopo2-1.fna.fbcdn.net/v/t1.0-9/14344889_10154492029313774_563802644034171479_n.jpg?_nc_cat=101&_nc_sid=e007fa&_nc_ohc=Msi4Kx_O534AX_a9ILj&_nc_ht=scontent.fopo2-1.fna&oh=5136e4d20d5a9f3c54ac6f8f1f49a7d1&oe=5ED96009');
INSERT INTO Parceria VALUES(31, 'Hospital Veterinário Muralha de Évora', 'https://www.hvetmuralha.pt', 'https://www.hvetmuralha.pt/wp-content/uploads/2013/10/logo_hvme.png');
INSERT INTO Parceria VALUES(32, 'Hangar Criativo', 'http://hangarcriativo.pt', 'https://scontent.fopo2-2.fna.fbcdn.net/v/t31.0-8/12247679_10153697011138774_7940628829604190743_o.jpg?_nc_cat=107&_nc_sid=e007fa&_nc_ohc=CugsLzQ_8uUAX88pZ6U&_nc_ht=scontent.fopo2-2.fna&oh=eb79c4464d502cde8babc28ccb813041&oe=5ED90995');
INSERT INTO Parceria VALUES(33, 'Herdade da Amendoeira', 'http://www.herdadeamendoeira.com', 'https://lh3.googleusercontent.com/proxy/O1-WbPNq6p95AwPLiKI6-FIry7pcrQzTTvz1TWrYv8U5WVBwdgec-1lWRlTi3vRVJZ3NUskg-5r0xAAC90UP3a2uw_HZnf_hrXrHDxI');
INSERT INTO Parceria VALUES(34, 'LuXury Fitness Boutique', 'https://www.facebook.com/luxuryfitnessboutique/', 'https://scontent.fopo2-2.fna.fbcdn.net/v/t1.0-9/79165364_749982565498032_6804942614664577024_n.png?_nc_cat=108&_nc_sid=85a577&_nc_ohc=u6YBkiTa2kEAX9_U3sM&_nc_ht=scontent.fopo2-2.fna&oh=509efa59b91969c792e71aa37e648575&oe=5ED9817E');
INSERT INTO Parceria VALUES(35, 'Alfarroba Café', 'https://www.alfarrobacafe.com', 'https://scontent.fopo2-1.fna.fbcdn.net/v/t1.0-9/46722188_550339222058731_8348571130910474240_n.jpg?_nc_cat=109&_nc_sid=85a577&_nc_ohc=Si7pCPeA-KcAX_llUqN&_nc_ht=scontent.fopo2-1.fna&oh=170a721beafb4ea57718b7d18563e273&oe=5ED90057');
INSERT INTO Parceria VALUES(36, 'Feel Saúde', 'https://www.facebook.com/clinicafeelsaude/', 'https://scontent.fopo2-2.fna.fbcdn.net/v/t31.0-8/15723335_1825108284370345_8427239383828669893_o.png?_nc_cat=108&_nc_sid=7aed08&_nc_ohc=TaYVUaaQ6wsAX8GIwEK&_nc_ht=scontent.fopo2-2.fna&oh=27b4a44f1a33c7e2cbd103006dae1b66&oe=5ED907D1');
INSERT INTO Parceria VALUES(37, 'U-Dance', 'https://www.facebook.com/U.Dance.Pt', 'https://scontent.fopo2-2.fna.fbcdn.net/v/t1.0-9/10392553_493143250828518_1058586618322788632_n.png?_nc_cat=107&_nc_sid=85a577&_nc_ohc=cjrfTKwjCO8AX-PSuMP&_nc_ht=scontent.fopo2-2.fna&oh=a86e396ddab5b5950335872356362cfb&oe=5EDBB901');
INSERT INTO Parceria VALUES(38, 'Naturallife', 'https://www.facebook.com/naturallifesaudeebemestar/', 'https://scontent.fopo2-2.fna.fbcdn.net/v/t1.0-9/27540768_148077719243510_6640449335277335174_n.png?_nc_cat=100&_nc_sid=85a577&_nc_ohc=zCPvdozdykkAX8pniFD&_nc_ht=scontent.fopo2-2.fna&oh=5dfea230f1c5e8b033006c63b68d730f&oe=5EDB56C8');
INSERT INTO Parceria VALUES(39, 'Algarvet', 'https://centro-veterinario-dos-olhos-de.negocio.site', 'https://lh3.googleusercontent.com/7ax8-XJ_18BrcjwYNlb2x0RW6J-oCl7FnjxZ3LwvB1EVh1IsHrTrqe3FjrGCV8eI1RNqtidJOYoeb3IC=w768-h768-n-o-v1');
INSERT INTO Parceria VALUES(40, 'Clínica Medicalvet','https://www.facebook.com/Clinicavetcovilha/', 'https://1.bp.blogspot.com/-KuS2uRugH5c/UTkj-DmxfjI/AAAAAAAAC0U/aGyQ2w06DeQ/s1600/medicalvet.png');
INSERT INTO Parceria VALUES(41, 'Comunilog', 'https://www.comunilog.com', 'https://1.bp.blogspot.com/-omDbLFSdwWw/URb7MeyvpgI/AAAAAAAACrw/lWxmNsGZ6Sw/s1600/logo.png');
INSERT INTO Parceria VALUES(42, 'Companhia de 4 Patas', 'https://companhiade4patas.pt', 'https://companhiade4patas.pt/wp-content/uploads/2018/10/logotipo-companhia-de-4-patas-e1546902081492.png');
INSERT INTO Parceria VALUES(43, 'Agro Viseu', 'http://www.agroviseu.pt', 'https://scontent.fopo2-2.fna.fbcdn.net/v/t1.0-9/295985_244930798896358_1464405672_n.jpg?_nc_cat=100&_nc_sid=85a577&_nc_ohc=Z3_pvpdvwC0AX8lBLsL&_nc_ht=scontent.fopo2-2.fna&oh=72d732030af82db60fe233a51e85e91d&oe=5EDCCE60');
INSERT INTO Parceria VALUES(44, 'Terezel', 'https://www.facebook.com/Terezel.MonteGordo/', 'https://scontent.fopo2-1.fna.fbcdn.net/v/t1.0-9/72357561_116874809721944_4600215840111984640_n.jpg?_nc_cat=105&_nc_sid=85a577&_nc_ohc=BFYLl29BwFoAX_cANTu&_nc_ht=scontent.fopo2-1.fna&oh=564bac200f2973c388db159d46cd781d&oe=5EDD0BE7');
INSERT INTO Parceria VALUES(45, 'The Blue Parrot', 'https://www.facebook.com/pages/category/Bar---Grill/The-Blue-Parrot-301791583364281/', 'https://scontent.fopo2-2.fna.fbcdn.net/v/t1.0-9/13606954_495042137372557_3074238100660652659_n.jpg?_nc_cat=108&_nc_sid=85a577&_nc_ohc=ybYDxq2EhMkAX9ekrxR&_nc_ht=scontent.fopo2-2.fna&oh=6b7c132c157e2954c9e1dd507b03614e&oe=5EDC47DA');
INSERT INTO Parceria VALUES(46, 'VillaPet', 'https://www.facebook.com/VillapetHospitalVeterinario/', 'https://scontent.fopo2-2.fna.fbcdn.net/v/t1.0-9/34017460_1946558178708911_5008794773310406656_o.jpg?_nc_cat=110&_nc_sid=85a577&_nc_ohc=8YtATx5gNNAAX_oWESa&_nc_ht=scontent.fopo2-2.fna&oh=5de50664159a4d171b39b1ecc8673b28&oe=5EDB93CA');
INSERT INTO Parceria VALUES(47, 'Clínica Veterinária', 'https://www.facebook.com/ConsultorioVeterinarioDraElisabetePacoSantos', 'https://scontent.fopo2-2.fna.fbcdn.net/v/t1.0-9/29314491_1360390394062811_1357371066112016384_o.jpg?_nc_cat=106&_nc_sid=85a577&_nc_ohc=YDTPuwEj8CsAX9Ivcx0&_nc_ht=scontent.fopo2-2.fna&oh=b62b3083ae8e689f8a3ace687ee5ceda&oe=5EDCDC1B');
INSERT INTO Parceria VALUES(48, 'Portal Key Store', 'https://www.facebook.com/portalkeystore/', 'https://scontent.fopo2-2.fna.fbcdn.net/v/t31.0-8/15626042_1358325690885906_872043284464213097_o.png?_nc_cat=106&_nc_sid=85a577&_nc_ohc=f6hxLJodOsYAX-klNCD&_nc_ht=scontent.fopo2-2.fna&oh=9f2972f320cd4a0ff3f1e2fe404c7099&oe=5EDB563F');
INSERT INTO Parceria VALUES(49, 'Continente', 'https://www.continente.pt', 'https://upload.wikimedia.org/wikipedia/commons/9/9d/Logocontinente.jpg');
INSERT INTO Parceria VALUES(50, 'Jumbo', 'https://www.auchan.pt/Frontoffice/', 'https://www.labpaisagem.pt/wp-content/uploads/2017/03/jumbo-logo.png');
INSERT INTO Parceria VALUES(51, 'UTAD Hospital Veterinário', 'https://www.utad.pt/hvutad/', 'https://www.agroportal.pt/wp-content/uploads/UTAD-1.png');
INSERT INTO Parceria VALUES(52, 'bleam', 'https://www.bleam.pt','https://www.bleam.pt/wp-content/uploads/2019/01/Bleam_Logo-01.png');
-- Canil_has_Parceria
INSERT INTO Canil_has_Parceria VALUES ('[email protected]',1);
INSERT INTO Canil_has_Parceria VALUES ('[email protected]',2);
INSERT INTO Canil_has_Parceria VALUES ('[email protected]',3);
INSERT INTO Canil_has_Parceria VALUES ('[email protected]',4);
INSERT INTO Canil_has_Parceria VALUES ('[email protected]',5);
INSERT INTO Canil_has_Parceria VALUES ('[email protected]',6);
INSERT INTO Canil_has_Parceria VALUES ('[email protected]',7);
INSERT INTO Canil_has_Parceria VALUES ('[email protected]',8);
INSERT INTO Canil_has_Parceria VALUES ('[email protected]',9);
INSERT INTO Canil_has_Parceria VALUES ('[email protected]',10);
INSERT INTO Canil_has_Parceria VALUES ('[email protected]',11);
INSERT INTO Canil_has_Parceria VALUES ('[email protected]',12);
INSERT INTO Canil_has_Parceria VALUES ('[email protected]',13);
INSERT INTO Canil_has_Parceria VALUES ('[email protected]',14);
INSERT INTO Canil_has_Parceria VALUES ('[email protected]',15);
INSERT INTO Canil_has_Parceria VALUES ('[email protected]',16);
INSERT INTO Canil_has_Parceria VALUES ('[email protected]',17);
INSERT INTO Canil_has_Parceria VALUES ('[email protected]',18);
INSERT INTO Canil_has_Parceria VALUES ('[email protected]',19);
INSERT INTO Canil_has_Parceria VALUES ('[email protected]',20);
INSERT INTO Canil_has_Parceria VALUES ('[email protected]',21);
INSERT INTO Canil_has_Parceria VALUES ('[email protected]',22);
INSERT INTO Canil_has_Parceria VALUES ('[email protected]',23);
INSERT INTO Canil_has_Parceria VALUES ('[email protected]',24);
INSERT INTO Canil_has_Parceria VALUES ('[email protected]', 25);
INSERT INTO Canil_has_Parceria VALUES ('[email protected]', 26);
INSERT INTO Canil_has_Parceria VALUES ('[email protected]', 27);
INSERT INTO Canil_has_Parceria VALUES ('[email protected]', 28);
INSERT INTO Canil_has_Parceria VALUES ('[email protected]', 29);
INSERT INTO Canil_has_Parceria VALUES ('[email protected]', 30);
INSERT INTO Canil_has_Parceria VALUES ('[email protected]', 31);
INSERT INTO Canil_has_Parceria VALUES ('[email protected]', 32);
INSERT INTO Canil_has_Parceria VALUES ('[email protected]', 33);
INSERT INTO Canil_has_Parceria VALUES ('[email protected]', 34);
INSERT INTO Canil_has_Parceria VALUES ('[email protected]', 35);
INSERT INTO Canil_has_Parceria VALUES ('[email protected]', 36);
INSERT INTO Canil_has_Parceria VALUES ('[email protected]', 37);
INSERT INTO Canil_has_Parceria VALUES ('[email protected]', 38);
INSERT INTO Canil_has_Parceria VALUES ('[email protected]', 39);
INSERT INTO Canil_has_Parceria VALUES ('[email protected]', 40);
INSERT INTO Canil_has_Parceria VALUES ('[email protected]', 41);
INSERT INTO Canil_has_Parceria VALUES ('[email protected]', 26);
INSERT INTO Canil_has_Parceria VALUES ('[email protected]', 42);
INSERT INTO Canil_has_Parceria VALUES ('[email protected]', 43);
INSERT INTO Canil_has_Parceria VALUES ('[email protected]',44);
INSERT INTO Canil_has_Parceria VALUES ('[email protected]',45);
INSERT INTO Canil_has_Parceria VALUES ('[email protected]',46);
INSERT INTO Canil_has_Parceria VALUES ('[email protected]',47);
INSERT INTO Canil_has_Parceria VALUES ('[email protected]',48);
INSERT INTO Canil_has_Parceria VALUES ('[email protected]', 49);
INSERT INTO Canil_has_Parceria VALUES ('[email protected]', 50);
INSERT INTO Canil_has_Parceria VALUES ('[email protected]', 51);
INSERT INTO Canil_has_Parceria VALUES ('[email protected]', 52);
-- Donativos
INSERT INTO Donativos VALUES(1,'[email protected]','[email protected]',150,'2018/10/14', NULL);
INSERT INTO Donativos VALUES(2,'[email protected]','[email protected]',10,'2020/03/02',NULL);
INSERT INTO Donativos VALUES(3,'[email protected]','[email protected]',200,'2018/04/01',NULL);
INSERT INTO Donativos VALUES(4,'[email protected]','[email protected]',150,'2018/12/14',NULL);
INSERT INTO Donativos VALUES(5,'[email protected]','[email protected]',10,'2020/03/02',NULL);
INSERT INTO Donativos VALUES(6,'[email protected]','[email protected]',200,'2018/04/01',NULL);
INSERT INTO Donativos VALUES(7,'[email protected]','[email protected]',450,'2018/11/14',NULL);
INSERT INTO Donativos VALUES(8,'[email protected]','[email protected]',200,'2020/03/02',NULL);
INSERT INTO Donativos VALUES(9,'[email protected]','[email protected]',100,'2018/04/01',NULL);
INSERT INTO Donativos VALUES (10,'[email protected]','[email protected]',20,'2020/02/12',NULL);
INSERT INTO Donativos VALUES (11,'[email protected]','[email protected]',10,'2020/03/12',NULL);
INSERT INTO Donativos VALUES (12,'[email protected]','[email protected]',35,'2020/03/22',NULL);
INSERT INTO Donativos VALUES (13,'[email protected]','[email protected]',20,'2020/01/06',NULL);
INSERT INTO Donativos VALUES (14,'[email protected]','[email protected]',15,'2020/01/04',NULL);
INSERT INTO Donativos VALUES (15,'[email protected]','[email protected]',15,'2020/01/04',NULL);
INSERT INTO Donativos VALUES (16,'[email protected]','[email protected]',15,'2020/01/04',NULL);
INSERT INTO Donativos VALUES (17,'[email protected]','[email protected]',5,'2020/02/19',NULL);
INSERT INTO Donativos VALUES (18,'[email protected]','[email protected]',15,'2020/03/19',NULL);
INSERT INTO Donativos VALUES (19,'[email protected]','[email protected]',30,'2020/05/01',NULL);
INSERT INTO Donativos VALUES (20,'[email protected]','[email protected]',15,'2020/01/30',NULL);
INSERT INTO Donativos VALUES (21,'[email protected]','[email protected]',10,'2020/04/13',NULL);
INSERT INTO Donativos VALUES (22,'[email protected]','[email protected]',25,'2020/02/13',NULL);
INSERT INTO Donativos VALUES (23,'[email protected]','[email protected]',25,'2020/05/03',NULL);
INSERT INTO Donativos VALUES (24, '[email protected]', '[email protected]', 45, '2018/12/01',NULL);
INSERT INTO Donativos VALUES (25, '[email protected]', '[email protected]', 100, '2019/01/25',NULL);
INSERT INTO Donativos VALUES (26, '[email protected]', '[email protected]', 110, '2019/02/14',NULL);
INSERT INTO Donativos VALUES (27, '[email protected]', '[email protected]', 20, '2019/02/25',NULL);
INSERT INTO Donativos VALUES (28, '[email protected]', '[email protected]', 50, '2019/04/13',NULL);
INSERT INTO Donativos VALUES (29, '[email protected]', '[email protected]', 15, '2019/04/29',NULL);
INSERT INTO Donativos VALUES (30, '[email protected]', '[email protected]', 5, '2019/06/03',NULL);
INSERT INTO Donativos VALUES (31, '[email protected]', '[email protected]', 5, '2019/08/03',NULL);
INSERT INTO Donativos VALUES (32, '[email protected] ', '[email protected]', 5, '2019/08/03',NULL);
INSERT INTO Donativos VALUES (33, '[email protected] ', '[email protected]', 30, '2019/08/15',NULL);
INSERT INTO Donativos VALUES (34, '[email protected]', '[email protected]', 30, '2019/08/15',NULL);
INSERT INTO Donativos VALUES (35, '[email protected]', '[email protected]', 20, '2019/08/20',NULL);
INSERT INTO Donativos VALUES (36, '[email protected]', '[email protected]', 20, '2019/10/15',NULL);
INSERT INTO Donativos VALUES (37, '[email protected]', '[email protected]', 5, '2019/10/30',NULL);
INSERT INTO Donativos VALUES (38, '[email protected]', '[email protected]', 15, '2019/11/12',NULL);
INSERT INTO Donativos VALUES (39, '[email protected]', '[email protected]', 15, '2018/11/12',NULL);
INSERT INTO Donativos VALUES (40, '[email protected]', '[email protected]', 25, '2019/12/24',NULL);
INSERT INTO Donativos VALUES (41, '[email protected]', '[email protected]', 35, '2018/04/14',NULL);
INSERT INTO Donativos VALUES (42, '[email protected]', '[email protected]', 70, '2018/12/17',NULL);
INSERT INTO Donativos VALUES (43, '[email protected]', '[email protected]', 20, '2018/06/03',NULL);
INSERT INTO Donativos VALUES (44, '[email protected]', '[email protected]', 50, '2018/10/15',NULL);
INSERT INTO Donativos VALUES (45, '[email protected]', '[email protected]', 5, '2018/08/30',NULL);
INSERT INTO Donativos VALUES (46, '[email protected]', '[email protected]', 15, '2018/10/12',NULL);
INSERT INTO Donativos VALUES (47, '[email protected]', '[email protected]', 55, '2018/09/11',NULL);
INSERT INTO Donativos VALUES (48, '[email protected]', '[email protected]', 14, '2018/07/12',NULL);
INSERT INTO Donativos VALUES (49, '[email protected]', '[email protected]', 22, '2018/09/22',NULL);
INSERT INTO Donativos VALUES (50, '[email protected]', '[email protected]', 80, '2018/06/17',NULL);
-- Cão
INSERT INTO Cao VALUES (1,'Pastel','Macho','Energético, dócil, fiel. Adora brincar e de companhia','Por Adotar','Sem Raça Definida','Branco',4,'Sim','Médio','[email protected]');
INSERT INTO Cao VALUES (2,'Rafa','Macho','Muito amigável e adora brincar. Adora comer fruta','Por Adotar','Sem Raça Definida','Creme',3,'Não','Médio','[email protected]');
INSERT INTO Cao VALUES (3,'Boris','Macho','Muito energético, brincalhão e meigo','Por Adotar','Labrador Retriever','Creme',1,'Sim','Médio','[email protected]');
INSERT INTO Cao VALUES (4,'Bucky','Macho','Não é dado a afetos e é independente, com sentidos fracos devido à idade e dificuldades motoras','Por Adotar' ,'Sem Raça Definida','Branco, Castanho, Preto',16,'Não','Pequeno','[email protected]');
INSERT INTO Cao VALUES (5,'Poti','Macho','Protetor e fiel','Por Adotar','São Bernardo','Castanho, Branco, Preto',9,'Não','Grande','[email protected]');
INSERT INTO Cao VALUES (6,'Puscas','Macho','Protetor, meigo, carente de mimo e companhia','Por Adotar','Serra da Estrela','Castanho',7,'Não','Grande','[email protected]');
INSERT INTO Cao VALUES (7,'Rex','Macho',NULL,'Por Adotar','Labrador Retriever','Creme',13,'Sim','Médio','[email protected]');
INSERT INTO Cao VALUES (8,'Lassie','Fêmea',NULL,'Por Adotar','Yorkshire Terrier','Dourado, Cinzento',2,'Sim','Pequeno','[email protected]');
INSERT INTO Cao VALUES (9,'Cookie','Macho','Adora fazer companhia e brincar','Por Adotar','Yorkshire Terrier','Dourado, Cinzento',7,'Sim','Pequeno','[email protected]');
INSERT INTO Cao VALUES (10,'Tay','Macho','Muito energético e leal. Com necessidade de muito carinho e paciência.','Por Adotar','Sem Raça Definida','Castanho',8,'Não','Pequeno','[email protected]');
INSERT INTO Cao VALUES (11,'Rubi','Macho','Extremamente amigável com humanos e outros animais','Por Adotar','Serra da Estrela','Castanho',7,'Não','Grande','[email protected]');
INSERT INTO Cao VALUES (12,'Pó de Arroz','Macho',NULL,'Por Adotar','Weimaraner','Cinzento',5,'Sim','Grande','[email protected]');
INSERT INTO Cao VALUES (13,'Minnie', 'Fêmea', 'Cachorro de 5 meses, com muita energia.','Por Adotar','Pastor Alemão', 'Castanho, Preto',0,'Não','Grande','[email protected]');
INSERT INTO Cao VALUES (14,'Maxi','Macho',NULL, 'Por Adotar', 'Beagle','Castanho, Branco, Preto',2,'Sim','Pequeno','[email protected]');
INSERT INTO Cao VALUES (15,'Black', 'Fêmea', 'Muito beijoqueira e dorminhoca', 'Por Adotar', 'Teckel', 'Castanho, Preto',8,'Não','Pequeno','[email protected]');
INSERT INTO Cao VALUES (16,'Broa de Mel','Macho',NULL, 'Por Adotar','Teckel','Castanho, Preto', 4, 'Sim','Pequeno','[email protected]');
INSERT INTO Cao VALUES (17,'Enzo','Macho','Brincalhão e meigo','Por Adotar','Bulldog Francês','Preto',2,'Não','Pequeno', '[email protected]');
INSERT INTO Cao VALUES (18,'Kika','Fêmea',NULL, 'Por Adotar','Beagle', 'Castanho, Branco, Preto',2,'Sim','Pequeno','[email protected]');
INSERT INTO Cao VALUES (19,'SimbA','Macho',NULL,'Por Adotar','Sem Raça Definida','Castanho',2,'Sim','Pequeno','[email protected]');
INSERT INTO Cao VALUES (20,'Maya','Fêmea',NULL,'Por Adotar','Samoiedo','Branco',4,'Não','Médio','[email protected]');
INSERT INTO Cao VALUES (21,'Nina', 'Fêmea', 'Ótima companhia,adora os seus peluches, muito meiga e alegre', 'Por Adotar','Golden Retriever','Dourado',7,'Não','Médio','[email protected]');
INSERT INTO Cao VALUES (22,'Leite Creme', 'Macho', 'Cachorro de 3 meses', 'Por Adotar', 'Sem Raça Definida', 'Castanho, Branco', 0, 'Não', 'Médio','[email protected]');
INSERT INTO Cao VALUES (23,'Bolt', 'Macho', 'Cachorro de 3 meses','Por Adotar','Sem Raça Definida','Preto',0,'Não','Médio','[email protected]');
INSERT INTO Cao VALUES (24, 'Milka', 'Fêmea', 'Muito dócil e alegre', 'Por Adotar','Husky','Branco',5,'Sim','Médio','[email protected]');
INSERT INTO Cao VALUES (25, 'Junior', 'Macho', 'Calmo e meigo, mas também muito traquina', 'Por Adotar', 'Sem Raça Definida','Branco, Castanho',12,'Não','Pequeno','[email protected]');
INSERT INTO Cao VALUES (26, 'Martini', 'Macho', 'Está sempre pronto a brincar','Por Adotar','Labrador Retriever','Castanho',2,'Não','Médio','[email protected]');
INSERT INTO Cao VALUES (27, 'Princesa', 'Fêmea', 'Extremamente meiga e amigável, adora comer maçãs','Por Adotar', 'Dogue Alemão','Preto',1,'Não','Grande','[email protected]');
INSERT INTO Cao VALUES (28, 'Cherry', 'Fêmea', 'Extremamente meiga. Cachorro de 4 meses','Por Adotar', 'Dogue Alemão','Preto',0,'Não','Grande','[email protected]');
INSERT INTO Cao VALUES (29, 'Rudi', 'Macho', 'Protetor, mas dócil. Adora brincar e fazer companhia', 'Por Adotar','Serra da Estrela', 'Castanho',4,'Não','Grande','[email protected]');
INSERT INTO Cao VALUES (30, 'Runa', 'Fêmea','Muito meiga, adora dar beijinhos e é muito alegre', 'Por Adotar', 'Serra da Estrela', 'Castanho, Preto', 5, 'Sim','Grande','[email protected]');
INSERT INTO Cao VALUES (31, 'Gorbi','Macho','Muito calmo e meigo', 'Por Adotar', 'Serra da Estrela', 'Castanho, Preto',13, 'Não','Grande','[email protected]');
INSERT INTO Cao VALUES (32, 'Nikita','Fêmea','Muito inteligente e meiga','Por Adotar','Serra da Estrela','Castanho, Preto',7,'Não','Grande','[email protected]');
INSERT INTO Cao VALUES (33, 'Zuki','Macho','Calmo, educado e adora brincar','Por Adotar','Serra da Estrela','Castanho',2,'Não','Grande','[email protected]');
INSERT INTO Cao VALUES (34, 'Pterion','Macho',NULL, 'Por Adotar','Pastor Alemão','Castanho,Preto',9,'Não', 'Grande','[email protected]');
INSERT INTO Cao VALUES (35, 'Violeta', 'Fêmea', 'Brincalhona com um apetite maior que o seu tamanho', 'Por Adotar','Yorkshire Terrier','Preto',7,'Não', 'Pequeno','[email protected]');
INSERT INTO Cao VALUES (36, 'Eva', 'Fêmea', NULL, 'Por Adotar', 'Sem Raça Definida','Branco',7,'Não','Pequeno', '[email protected]');
INSERT INTO Cao VALUES (37, 'Lua', 'Fêmea','Muito energética e sempre com disposição para brincar', 'Por Adotar','Rotweiller', 'Castanho, Preto',2,'Sim','Pequeno','[email protected]');
INSERT INTO Cao VALUES (38, 'Lex', 'Macho','Adora brincar, comer e dormir','Por Adotar','Labrador Retriever','Creme',1,'Sim','Médio','[email protected]');
INSERT INTO Cao VALUES (39, 'Pantera', 'Macho','Dorminhoco e brincalhão','Por Adotar','Labrador Retriever','Preto',3,'Sim','Médio','[email protected]');
INSERT INTO Cao VALUES (40, 'Tico', 'Macho','Dorminhoco e brincalhão','Por Adotar','Pinscher','Castanho',4,'Sim','Pequeno','[email protected]');
INSERT INTO Cao VALUES (41, 'Kiko', 'Macho',NULL, 'Por Adotar','Tibetan Spaniel','Castanho',5,'Não','Pequeno','[email protected]');
INSERT INTO Cao VALUES (42, 'Mel', 'Fêmea',NULL, 'Por Adotar','Pastor Alemão','Castanho, Preto',7,'Não','Grande','[email protected]');
INSERT INTO Cao VALUES (43, 'Simba', 'Macho','Molenga, detesta banhos mas adora fazer chop chop na água','Por Adotar','Labrador Retriever','Creme',11,'Não','Médio','[email protected]');
INSERT INTO Cao VALUES (44, 'Zuri', 'Macho','Extremamente mimalho e inteligente e tem um fetiche pelo ecoponto dos plásticos ','Por Adotar','Serra da Estrela','Castanho, Preto',9,'Não','Grande','[email protected]');
INSERT INTO Cao VALUES (45, 'Snoopy','Macho',NULL, 'Por Adotar','Sem Raça Definida','Creme',2,'Não','Pequeno','[email protected]');
INSERT INTO Cao VALUES (46, 'Vitória','Fêmea',NULL, 'Por Adotar', 'Golden Retriever','Creme',10,'Não','Médio','[email protected]');
INSERT INTO Cao VALUES (47, 'Kiki','Fêmea',NULL,'Por Adotar','Sem Raça Definida','Castanho',8,'Não','Pequeno','[email protected]');
INSERT INTO Cao VALUES (48, 'Pepe','Macho','Cachorro de 6 meses','Por Adotar','Bulldog Francês','Castanho',0,'Não','Pequeno','[email protected]');
INSERT INTO Cao VALUES (49, 'Penny','Fêmea',NULL,'Por Adotar','Cocker Spaniel','Castanho',3,'Sim','Médio','[email protected]');
INSERT INTO Cao VALUES (50, 'Barney','Macho',NULL,'Por Adotar','Golden Retriever','Creme',3,'Sim','Médio','[email protected]');
INSERT INTO Cao VALUES (51, 'Pena','Fêmea','Cachorro com 1 mês.','Por Adotar','Cocker Spaniel','Castanho',0,'Não','Médio','[email protected]');
INSERT INTO Cao VALUES (52, 'Pepa','Fêmea',NULL,'Por Adotar','Cocker Spaniel','Castanho',2,'Sim','Médio','[email protected]');
-- Fotografia
INSERT INTO Fotografia VALUES(1,'Pastel.jpg',1);
INSERT INTO Fotografia VALUES(2,'Rafa.png',2);
INSERT INTO Fotografia VALUES(3,'Boris.jpg',3);
INSERT INTO Fotografia VALUES(4,'Bucky.png',4);
INSERT INTO Fotografia VALUES(5,'Poti.png',5);
INSERT INTO Fotografia VALUES(6,'Puscas.jpg',6);
INSERT INTO Fotografia VALUES(7,'Rex.jpg',7);
INSERT INTO Fotografia VALUES(8,'Lassie.jpg',8);
INSERT INTO Fotografia VALUES(9,'Cookie.jpg',9);
INSERT INTO Fotografia VALUES(10,'Tay.png',10);
INSERT INTO Fotografia VALUES(11,'Rubi.jpg',11);
INSERT INTO Fotografia VALUES(12,'PoArroz.png',12);
INSERT INTO Fotografia VALUES(13,'Minnie.jpg',13);
INSERT INTO Fotografia VALUES(14,'Maxi.png',14);
INSERT INTO Fotografia VALUES(15,'Black.png',15);
INSERT INTO Fotografia VALUES(16,'BroaMel.png',16);
INSERT INTO Fotografia VALUES(17,'Enzo.jpg',17);
INSERT INTO Fotografia VALUES(18,'Kika.png',18);
INSERT INTO Fotografia VALUES(19,'simba.jpg',19);
INSERT INTO Fotografia VALUES(20,'Maya.png',20);
INSERT INTO Fotografia VALUES(21,'Nina.png',21);
INSERT INTO Fotografia VALUES(22,'LeiteCreme.png',22);
INSERT INTO Fotografia VALUES(23,'Bolt.png',23);
INSERT INTO Fotografia VALUES(24,'Milka.jpg',24);
INSERT INTO Fotografia VALUES(25,'Junior.jpg',25);
INSERT INTO Fotografia VALUES(26,'Martini.jpg',26);
INSERT INTO Fotografia VALUES(27,'Princesa.jpg',27);
INSERT INTO Fotografia VALUES(28,'Cherry.jpg',28);
INSERT INTO Fotografia VALUES(29,'Rudi.jpg',29);
INSERT INTO Fotografia VALUES(30,'Runa.jpg',30);
INSERT INTO Fotografia VALUES(31,'Gorbi.jpg',31);
INSERT INTO Fotografia VALUES(32,'Nikita.jpg',32);
INSERT INTO Fotografia VALUES(33,'Zuki.jpg', 33);
INSERT INTO Fotografia VALUES(34,'Pterion.jpg',34);
INSERT INTO Fotografia VALUES(35, 'Violeta.png',35);
INSERT INTO Fotografia VALUES(36, 'Eva.png',36);
INSERT INTO Fotografia VALUES(37, 'Lua.png', 37);
INSERT INTO Fotografia VALUES(38, 'Lex.jpg', 38);
INSERT INTO Fotografia VALUES(39, 'Pantera.png', 39);
INSERT INTO Fotografia VALUES(40, 'Tico.png', 40);
INSERT INTO Fotografia VALUES(41, 'Kiko.png', 41);
INSERT INTO Fotografia VALUES(42, 'Mel.png', 42);
INSERT INTO Fotografia VALUES(43, 'Simba.png', 43);
INSERT INTO Fotografia VALUES(44, 'Zuri.png', 44);
INSERT INTO Fotografia VALUES(45,'Snoopy.png',45);
INSERT INTO Fotografia VALUES(46,'Vitoria.jpg',46);
INSERT INTO Fotografia VALUES(47,'Kiki.png',47);
INSERT INTO Fotografia VALUES(48,'Pepe.jpg',48);
INSERT INTO Fotografia VALUES(49,'Penny.png',49);
INSERT INTO Fotografia VALUES(50,'Barney.png',50);
INSERT INTO Fotografia VALUES(51,'Pena.png',51);
INSERT INTO Fotografia VALUES(52,'Pepa.jpg',52);
-- Favoritos
INSERT INTO Favoritos VALUES(2,'[email protected]');
INSERT INTO Favoritos VALUES(6,'[email protected]');
INSERT INTO Favoritos VALUES(21,'[email protected]');
-- Adoção
INSERT INTO Adocao VALUES (1,'2019/12/03','Aceite',3,'É própria','Não',NULL,'Acompanhará a família','Própria','Jardim','Moradia','Guarda','[email protected]','Sim','Não');
INSERT INTO Adocao VALUES (2,'2020/04/03','Aceite',6,'É própria','Não','Gato','Ficará com familiares/amigos','Própria','Jardim','Vivenda','Companhia','[email protected]','Sim','Sim');
INSERT INTO Adocao VALUES (3,'2020/02/23','Aceite',9,'É própria','Não','Cão Labrador Retriever','Ficará com familiares/amigos','Própria','Jardim','Vivenda','Companhia','[email protected]','Sim','Sim');
INSERT INTO Adocao VALUES (4,'2020/04/14','Aceite',10,'Sim','Não',NULL,'Ficará com familiares/amigos','Alugada','Varanda','Apartamento','Companhia','[email protected]','Sim','Não');
INSERT INTO Adocao VALUES (5,'2020/01/31','Pendente',2,'É própria','Não',NULL,'Acompanhará a família','Própria','Jardim','Vivenda','Companhia','[email protected]','Sim','Não');
INSERT INTO Adocao VALUES (6,'2018/02/04','Expirado',12,'Sim','Nao','cão, gato','Ficará num hotel','Própria','Jardim','Moradia','Companhia','[email protected]','Sim','Sim');
INSERT INTO Adocao VALUES (7,'2017/10/06','Recusado',7,'Sim','Nao','cão','Acompanhará a família','Arrendada','Jardim','Apartamento','Companhia','[email protected]','Sim','Sim');
INSERT INTO Adocao VALUES (8,'2019/04/01','Recusado',11,'Sim','Nao','piriquito','Ficará com familiares/amigos','Própria','Jardim','Vivenda','Companhia','[email protected]','Sim','Sim');
INSERT INTO Adocao VALUES (9,'2019/04/01','Aceite',11,'Sim','Nao','cão','Ficará com familiares/amigos','Própria','Jardim','Vivenda','Companhia','[email protected]','Sim','Sim');
INSERT INTO Adocao VALUES(10,'2020/05/31','Pendente', 4, 'Sim','Nao','cão','Ficará com familiares/amigos','Própria','Jardim','Vivenda','Companhia','[email protected]','Sim','Sim');
-- Sugestões
INSERT INTO Sugestoes VALUES(1,'Fátima Ferreira', '[email protected]', 'Quero fazer um donativo','Boa tarde. Na tentativa de realizar um donativo, este não me foi permitido. Agradecia esclarecimento. Fátima', 'Lida','2020/05/05','Enviada');
INSERT INTO Sugestoes VALUES(2,'Célia Rodrigues', '[email protected]', 'Quero voluntariar-me para um canil', 'Bom dia. Não estou a conseguir voluntariar-me no canil StreetDogs.', 'Não Lida','2020/01/01','Enviada' );
INSERT INTO Sugestoes VALUES(3,'José Ribeiro', '[email protected]', 'Outro', 'Bom dia. Encontro-me com problemas na procura de cães por raça. José Ribeiro', 'Não Lida', '2020/05/01' ,'Enviada');
INSERT INTO Sugestoes VALUES(4,'Leonel Costa', '[email protected]', 'Cuidados com o cão que adotei', 'Boa Tarde, o cão que adotei na passada terça-feira encontra-se desde então a vomitar. Ele encontrava-se sobre algum cuidado especial?', 'Lida', '2019/12/05','Enviada');
INSERT INTO Sugestoes VALUES(5,'Romeu Pereira', '[email protected]', 'Quero fazer um donativo','Boa tarde. Como devo proceder à doação de bens?', 'Não Lida','2020/02/18','Enviada');
INSERT INTO Sugestoes VALUES(6,'Margarida Vieira', '[email protected]', 'Quero voluntariar-me para um canil', 'Bom dia. Não estou a conseguir voluntariar-me no canil StreetDogs.', 'Não Lida', '2020/01/02' ,'Enviada');
INSERT INTO Sugestoes VALUES(7,'Sofia Ferreira', '[email protected]', 'Outro', 'Bom dia. Qual o critério para aceitação de registos de adoção?', 'Não Lida', '2020/05/08' ,'Enviada');
INSERT INTO Sugestoes VALUES(8,'Eva Morais', '[email protected]', 'Quero atualizar os meus dados pessoais', 'Boa Noite, gostaria de alterar o meu e-mail com a qual me registei nesta plataforma. Seria possível? Obrigada, Eva.', 'Lida', '2019/04/12','Enviada');
INSERT INTO Sugestoes VALUES(9,'Fátima Ferreira', '[email protected]', 'Quero fazer um donativo','Boa tarde, Fátima. Verifique se foi introduzido o IBAN correto. A equipa, CãoGest.', 'Enviada','2020/05/05','Não Lida');
INSERT INTO Sugestoes VALUES(10,'Leonel Costa', '[email protected]', 'Cuidados com o cão que adotei', 'Boa Tarde, Leonel. Deve entrar em contacto com o canil onde adotou o cão assim que possível. Considere também levá-lo ao veterinário. A equipa, CãoGest.', 'Enviada', '2019/12/05','Não Lida');
INSERT INTO Sugestoes VALUES(11,'Eva Morais', '[email protected]', 'Quero atualizar os meus dados pessoais', 'Bom dia, Eva. Não é permitida a alteração do endereço de email com o qual se registou. A equipa, CãoGest.', 'Enviada', '2019/04/12','Não Lida');
-- Horários
INSERT INTO Horario VALUES('2020/05/12 9:00:00', '2020/05/12 17:00:00', 7,0, 1, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 9:00:00', '2020/05/12 17:00:00', 7,0, 2, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 9:00:00', '2020/05/12 17:00:00', 7,0, 3, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 9:00:00', '2020/05/12 17:00:00', 7,0, 4, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 9:00:00', '2020/05/12 17:00:00', 7,0, 5, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 9:00:00', '2020/05/12 15:00:00', 7,0, 6, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 9:00:00', '2020/05/12 13:00:00', 7,0, 7, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 9:00:00', '2020/05/12 17:00:00', 7,0, 1, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 9:00:00', '2020/05/12 17:00:00', 7,0, 2, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 9:00:00', '2020/05/12 17:00:00', 7,0, 3, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 9:00:00', '2020/05/12 17:00:00', 7,0, 4, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 9:00:00', '2020/05/12 17:00:00', 7,0, 5, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 9:00:00', '2020/05/12 15:00:00', 7,0, 6, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 9:00:00', '2020/05/12 13:00:00', 7,0, 7, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 9:00:00', '2020/05/12 17:00:00', 7,0, 1, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 9:00:00', '2020/05/12 17:00:00', 7,0, 2, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 9:00:00', '2020/05/12 17:00:00', 7,0, 3, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 9:00:00', '2020/05/12 17:00:00', 7,0, 4, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 9:00:00', '2020/05/12 17:00:00', 7,0, 5, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 9:00:00', '2020/05/12 15:00:00', 7,0, 6, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 9:00:00', '2020/05/12 13:00:00', 7,0, 7, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 9:00:00', '2020/05/12 17:00:00', 7,0, 1, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 9:00:00', '2020/05/12 17:00:00', 7,0, 2, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 9:00:00', '2020/05/12 17:00:00', 7,0, 3, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 9:00:00', '2020/05/12 17:00:00', 7,0, 4, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 9:00:00', '2020/05/12 17:00:00', 7,0, 5, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 9:00:00', '2020/05/12 15:00:00', 7,0, 6, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 9:00:00', '2020/05/12 13:00:00', 7,0, 7, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 13:30:00', '2020/05/12 19:00:00', 7,0, 1, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 13:30:00', '2020/05/12 19:00:00', 7,0, 2, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 13:30:00', '2020/05/12 19:00:00', 7,0, 3, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 13:30:00', '2020/05/12 19:00:00', 7,0, 4, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 13:30:00', '2020/05/12 19:00:00', 7,0, 5, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 13:30:00', '2020/05/12 19:00:00', 7,0, 6, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 00:00:00', '2020/05/12 00:00:00', 7,0, 7, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 1, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 2, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 3, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 4, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 5, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 15:00:00', 7,0, 6, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 13:00:00', 7,0, 7, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 17:30:00', '2020/05/12 19:00:00', 7,0, 1, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 17:30:00', '2020/05/12 19:00:00', 7,0, 2, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 17:30:00', '2020/05/12 19:00:00', 7,0, 3, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 17:30:00', '2020/05/12 19:00:00', 7,0, 4, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 17:30:00', '2020/05/12 19:00:00', 7,0, 5, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 17:30:00', '2020/05/12 19:00:00', 7,0, 6, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 17:30:00', '2020/05/12 19:00:00', 7,0, 7, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 1, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 2, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 3, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 4, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 5, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 10:00:00', '2020/05/12 15:00:00', 7,0, 6, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 13:00:00', 7,0, 7, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 1, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 2, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 3, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 4, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 5, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 10:00:00', '2020/05/12 15:00:00', 7,0, 6, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 13:00:00', 7,0, 7, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 1, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 2, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 3, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 4, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 5, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 10:00:00', '2020/05/12 15:00:00', 7,0, 6, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 13:00:00', 7,0, 7, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 1, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 2, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 3, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 4, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 5, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 10:00:00', '2020/05/12 15:00:00', 7,0, 6, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 13:00:00', 7,0, 7, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 1, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 2, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 3, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 4, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 5, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 10:00:00', '2020/05/12 15:00:00', 7,0, 6, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 13:00:00', 7,0, 7, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 1, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 2, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 3, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 4, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 5, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 10:00:00', '2020/05/12 15:00:00', 7,0, 6, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 13:00:00', 7,0, 7, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 1, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 2, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 3, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 4, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 5, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 10:00:00', '2020/05/12 15:00:00', 7,0, 6, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 13:00:00', 7,0, 7, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 1, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 2, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 3, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 4, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 5, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 10:00:00', '2020/05/12 15:00:00', 7,0, 6, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 13:00:00', 7,0, 7, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 1, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 2, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 3, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 4, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 5, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 10:00:00', '2020/05/12 15:00:00', 7,0, 6, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 13:00:00', 7,0, 7, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 1, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 2, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 3, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 4, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 5, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 10:00:00', '2020/05/12 15:00:00', 7,0, 6, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 13:00:00', 7,0, 7, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 1, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 2, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 3, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 4, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 5, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 10:00:00', '2020/05/12 15:00:00', 7,0, 6, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 13:00:00', 7,0, 7, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 1, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 2, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 3, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 4, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 5, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 10:00:00', '2020/05/12 15:00:00', 7,0, 6, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 13:00:00', 7,0, 7, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 1, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 2, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 3, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 4, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 17:00:00', 7,0, 5, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 10:00:00', '2020/05/12 15:00:00', 7,0, 6, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 13:00:00', 7,0, 7, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 13:00:00', 7,0, 1, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 13:00:00', 7,0, 2, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 13:00:00', 7,0, 3, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 13:00:00', 7,0, 4, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 13:00:00', 7,0, 5, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 13:00:00', 7,0, 6, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 13:00:00', 7,0, 7, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 13:00:00', 7,0, 1, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 13:00:00', 7,0, 2, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 13:00:00', 7,0, 3, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 13:00:00', 7,0, 4, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 13:00:00', 7,0, 5, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 13:00:00', 7,0, 6, '[email protected]');
INSERT INTO Horario VALUES('2020/05/12 09:00:00', '2020/05/12 13:00:00', 7,0, 7, '[email protected]');