-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathschema.sql
17140 lines (16892 loc) · 581 KB
/
schema.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
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Hôte : mariadb:3306
-- Généré le : jeu. 08 août 2024 à 09:33
-- Version du serveur : 11.4.2-MariaDB-ubu2404
-- Version de PHP : 8.2.22
START TRANSACTION;
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Base de données : `demo`
--
CREATE DATABASE IF NOT EXISTS `demo` DEFAULT CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci;
USE demo;
-- --------------------------------------------------------
--
-- Structure de la table `Album`
--
CREATE TABLE `Album` (
`AlbumId` int(11) NOT NULL,
`Title` varchar(160) NOT NULL,
`ArtistId` int(11) NOT NULL
) ;
--
-- Déchargement des données de la table `Album`
--
INSERT INTO `Album` (`AlbumId`, `Title`, `ArtistId`) VALUES
(1, 'For Those About To Rock We Salute You', 1),
(2, 'Balls to the Wall', 2),
(3, 'Restless and Wild', 2),
(4, 'Let There Be Rock', 1),
(5, 'Big Ones', 3),
(6, 'Jagged Little Pill', 4),
(7, 'Facelift', 5),
(8, 'Warner 25 Anos', 6),
(9, 'Plays Metallica By Four Cellos', 7),
(10, 'Audioslave', 8),
(11, 'Out Of Exile', 8),
(12, 'BackBeat Soundtrack', 9),
(13, 'The Best Of Billy Cobham', 10),
(14, 'Alcohol Fueled Brewtality Live! [Disc 1]', 11),
(15, 'Alcohol Fueled Brewtality Live! [Disc 2]', 11),
(16, 'Black Sabbath', 12),
(17, 'Black Sabbath Vol. 4 (Remaster)', 12),
(18, 'Body Count', 13),
(19, 'Chemical Wedding', 14),
(20, 'The Best Of Buddy Guy - The Millenium Collection', 15),
(21, 'Prenda Minha', 16),
(22, 'Sozinho Remix Ao Vivo', 16),
(23, 'Minha Historia', 17),
(24, 'Afrociberdelia', 18),
(25, 'Da Lama Ao Caos', 18),
(26, 'Acústico MTV [Live]', 19),
(27, 'Cidade Negra - Hits', 19),
(28, 'Na Pista', 20),
(29, 'Axé Bahia 2001', 21),
(30, 'BBC Sessions [Disc 1] [Live]', 22),
(31, 'Bongo Fury', 23),
(32, 'Carnaval 2001', 21),
(33, 'Chill: Brazil (Disc 1)', 24),
(34, 'Chill: Brazil (Disc 2)', 6),
(35, 'Garage Inc. (Disc 1)', 50),
(36, 'Greatest Hits II', 51),
(37, 'Greatest Kiss', 52),
(38, 'Heart of the Night', 53),
(39, 'International Superhits', 54),
(40, 'Into The Light', 55),
(41, 'Meus Momentos', 56),
(42, 'Minha História', 57),
(43, 'MK III The Final Concerts [Disc 1]', 58),
(44, 'Physical Graffiti [Disc 1]', 22),
(45, 'Sambas De Enredo 2001', 21),
(46, 'Supernatural', 59),
(47, 'The Best of Ed Motta', 37),
(48, 'The Essential Miles Davis [Disc 1]', 68),
(49, 'The Essential Miles Davis [Disc 2]', 68),
(50, 'The Final Concerts (Disc 2)', 58),
(51, 'Up An\' Atom', 69),
(52, 'Vinícius De Moraes - Sem Limite', 70),
(53, 'Vozes do MPB', 21),
(54, 'Chronicle, Vol. 1', 76),
(55, 'Chronicle, Vol. 2', 76),
(56, 'Cássia Eller - Coleção Sem Limite [Disc 2]', 77),
(57, 'Cássia Eller - Sem Limite [Disc 1]', 77),
(58, 'Come Taste The Band', 58),
(59, 'Deep Purple In Rock', 58),
(60, 'Fireball', 58),
(61, 'Knocking at Your Back Door: The Best Of Deep Purple in the 80\'s', 58),
(62, 'Machine Head', 58),
(63, 'Purpendicular', 58),
(64, 'Slaves And Masters', 58),
(65, 'Stormbringer', 58),
(66, 'The Battle Rages On', 58),
(67, 'Vault: Def Leppard\'s Greatest Hits', 78),
(68, 'Outbreak', 79),
(69, 'Djavan Ao Vivo - Vol. 02', 80),
(70, 'Djavan Ao Vivo - Vol. 1', 80),
(71, 'Elis Regina-Minha História', 41),
(72, 'The Cream Of Clapton', 81),
(73, 'Unplugged', 81),
(74, 'Album Of The Year', 82),
(75, 'Angel Dust', 82),
(76, 'King For A Day Fool For A Lifetime', 82),
(77, 'The Real Thing', 82),
(78, 'Deixa Entrar', 83),
(79, 'In Your Honor [Disc 1]', 84),
(80, 'In Your Honor [Disc 2]', 84),
(81, 'One By One', 84),
(82, 'The Colour And The Shape', 84),
(83, 'My Way: The Best Of Frank Sinatra [Disc 1]', 85),
(84, 'Roda De Funk', 86),
(85, 'As Canções de Eu Tu Eles', 27),
(86, 'Quanta Gente Veio Ver (Live)', 27),
(87, 'Quanta Gente Veio ver--Bônus De Carnaval', 27),
(88, 'Faceless', 87),
(89, 'American Idiot', 54),
(90, 'Appetite for Destruction', 88),
(91, 'Use Your Illusion I', 88),
(92, 'Use Your Illusion II', 88),
(93, 'Blue Moods', 89),
(94, 'A Matter of Life and Death', 90),
(95, 'A Real Dead One', 90),
(96, 'A Real Live One', 90),
(97, 'Brave New World', 90),
(98, 'Dance Of Death', 90),
(99, 'Fear Of The Dark', 90),
(100, 'Iron Maiden', 90),
(101, 'Killers', 90),
(102, 'Live After Death', 90),
(103, 'Live At Donington 1992 (Disc 1)', 90),
(104, 'Live At Donington 1992 (Disc 2)', 90),
(105, 'No Prayer For The Dying', 90),
(106, 'Piece Of Mind', 90),
(107, 'Powerslave', 90),
(108, 'Rock In Rio [CD1]', 90),
(109, 'Rock In Rio [CD2]', 90),
(110, 'Seventh Son of a Seventh Son', 90),
(111, 'Somewhere in Time', 90),
(112, 'The Number of The Beast', 90),
(113, 'The X Factor', 90),
(114, 'Virtual XI', 90),
(115, 'Sex Machine', 91),
(116, 'Emergency On Planet Earth', 92),
(117, 'Synkronized', 92),
(118, 'The Return Of The Space Cowboy', 92),
(119, 'Get Born', 93),
(120, 'Are You Experienced?', 94),
(121, 'Surfing with the Alien (Remastered)', 95),
(122, 'Jorge Ben Jor 25 Anos', 46),
(123, 'Jota Quest-1995', 96),
(124, 'Cafezinho', 97),
(125, 'Living After Midnight', 98),
(126, 'Unplugged [Live]', 52),
(127, 'BBC Sessions [Disc 2] [Live]', 22),
(128, 'Coda', 22),
(129, 'Houses Of The Holy', 22),
(130, 'In Through The Out Door', 22),
(131, 'IV', 22),
(132, 'Led Zeppelin I', 22),
(133, 'Led Zeppelin II', 22),
(134, 'Led Zeppelin III', 22),
(135, 'Physical Graffiti [Disc 2]', 22),
(136, 'Presence', 22),
(137, 'The Song Remains The Same (Disc 1)', 22),
(138, 'The Song Remains The Same (Disc 2)', 22),
(139, 'A TempestadeTempestade Ou O Livro Dos Dias', 99),
(140, 'Mais Do Mesmo', 99),
(141, 'Greatest Hits', 100),
(142, 'Lulu Santos - RCA 100 Anos De Música - Álbum 01', 101),
(143, 'Lulu Santos - RCA 100 Anos De Música - Álbum 02', 101),
(144, 'Misplaced Childhood', 102),
(145, 'Barulhinho Bom', 103),
(146, 'Seek And Shall Find: More Of The Best (1963-1981)', 104),
(147, 'The Best Of Men At Work', 105),
(148, 'Black Album', 50),
(149, 'Garage Inc. (Disc 2)', 50),
(150, 'Kill \'Em All', 50),
(151, 'Load', 50),
(152, 'Master Of Puppets', 50),
(153, 'ReLoad', 50),
(154, 'Ride The Lightning', 50),
(155, 'St. Anger', 50),
(156, '...And Justice For All', 50),
(157, 'Miles Ahead', 68),
(158, 'Milton Nascimento Ao Vivo', 42),
(159, 'Minas', 42),
(160, 'Ace Of Spades', 106),
(161, 'Demorou...', 108),
(162, 'Motley Crue Greatest Hits', 109),
(163, 'From The Muddy Banks Of The Wishkah [Live]', 110),
(164, 'Nevermind', 110),
(165, 'Compositores', 111),
(166, 'Olodum', 112),
(167, 'Acústico MTV', 113),
(168, 'Arquivo II', 113),
(169, 'Arquivo Os Paralamas Do Sucesso', 113),
(170, 'Bark at the Moon (Remastered)', 114),
(171, 'Blizzard of Ozz', 114),
(172, 'Diary of a Madman (Remastered)', 114),
(173, 'No More Tears (Remastered)', 114),
(174, 'Tribute', 114),
(175, 'Walking Into Clarksdale', 115),
(176, 'Original Soundtracks 1', 116),
(177, 'The Beast Live', 117),
(178, 'Live On Two Legs [Live]', 118),
(179, 'Pearl Jam', 118),
(180, 'Riot Act', 118),
(181, 'Ten', 118),
(182, 'Vs.', 118),
(183, 'Dark Side Of The Moon', 120),
(184, 'Os Cães Ladram Mas A Caravana Não Pára', 121),
(185, 'Greatest Hits I', 51),
(186, 'News Of The World', 51),
(187, 'Out Of Time', 122),
(188, 'Green', 124),
(189, 'New Adventures In Hi-Fi', 124),
(190, 'The Best Of R.E.M.: The IRS Years', 124),
(191, 'Cesta Básica', 125),
(192, 'Raul Seixas', 126),
(193, 'Blood Sugar Sex Magik', 127),
(194, 'By The Way', 127),
(195, 'Californication', 127),
(196, 'Retrospective I (1974-1980)', 128),
(197, 'Santana - As Years Go By', 59),
(198, 'Santana Live', 59),
(199, 'Maquinarama', 130),
(200, 'O Samba Poconé', 130),
(201, 'Judas 0: B-Sides and Rarities', 131),
(202, 'Rotten Apples: Greatest Hits', 131),
(203, 'A-Sides', 132),
(204, 'Morning Dance', 53),
(205, 'In Step', 133),
(206, 'Core', 134),
(207, 'Mezmerize', 135),
(208, '[1997] Black Light Syndrome', 136),
(209, 'Live [Disc 1]', 137),
(210, 'Live [Disc 2]', 137),
(211, 'The Singles', 138),
(212, 'Beyond Good And Evil', 139),
(213, 'Pure Cult: The Best Of The Cult (For Rockers, Ravers, Lovers & Sinners) [UK]', 139),
(214, 'The Doors', 140),
(215, 'The Police Greatest Hits', 141),
(216, 'Hot Rocks, 1964-1971 (Disc 1)', 142),
(217, 'No Security', 142),
(218, 'Voodoo Lounge', 142),
(219, 'Tangents', 143),
(220, 'Transmission', 143),
(221, 'My Generation - The Very Best Of The Who', 144),
(222, 'Serie Sem Limite (Disc 1)', 145),
(223, 'Serie Sem Limite (Disc 2)', 145),
(224, 'Acústico', 146),
(225, 'Volume Dois', 146),
(226, 'Battlestar Galactica: The Story So Far', 147),
(227, 'Battlestar Galactica, Season 3', 147),
(228, 'Heroes, Season 1', 148),
(229, 'Lost, Season 3', 149),
(230, 'Lost, Season 1', 149),
(231, 'Lost, Season 2', 149),
(232, 'Achtung Baby', 150),
(233, 'All That You Can\'t Leave Behind', 150),
(234, 'B-Sides 1980-1990', 150),
(235, 'How To Dismantle An Atomic Bomb', 150),
(236, 'Pop', 150),
(237, 'Rattle And Hum', 150),
(238, 'The Best Of 1980-1990', 150),
(239, 'War', 150),
(240, 'Zooropa', 150),
(241, 'UB40 The Best Of - Volume Two [UK]', 151),
(242, 'Diver Down', 152),
(243, 'The Best Of Van Halen, Vol. I', 152),
(244, 'Van Halen', 152),
(245, 'Van Halen III', 152),
(246, 'Contraband', 153),
(247, 'Vinicius De Moraes', 72),
(248, 'Ao Vivo [IMPORT]', 155),
(249, 'The Office, Season 1', 156),
(250, 'The Office, Season 2', 156),
(251, 'The Office, Season 3', 156),
(252, 'Un-Led-Ed', 157),
(253, 'Battlestar Galactica (Classic), Season 1', 158),
(254, 'Aquaman', 159),
(255, 'Instant Karma: The Amnesty International Campaign to Save Darfur', 150),
(256, 'Speak of the Devil', 114),
(257, '20th Century Masters - The Millennium Collection: The Best of Scorpions', 179),
(258, 'House of Pain', 180),
(259, 'Radio Brasil (O Som da Jovem Vanguarda) - Seleccao de Henrique Amaro', 36),
(260, 'Cake: B-Sides and Rarities', 196),
(261, 'LOST, Season 4', 149),
(262, 'Quiet Songs', 197),
(263, 'Muso Ko', 198),
(264, 'Realize', 199),
(265, 'Every Kind of Light', 200),
(266, 'Duos II', 201),
(267, 'Worlds', 202),
(268, 'The Best of Beethoven', 203),
(269, 'Temple of the Dog', 204),
(270, 'Carry On', 205),
(271, 'Revelations', 8),
(272, 'Adorate Deum: Gregorian Chant from the Proper of the Mass', 206),
(273, 'Allegri: Miserere', 207),
(274, 'Pachelbel: Canon & Gigue', 208),
(275, 'Vivaldi: The Four Seasons', 209),
(276, 'Bach: Violin Concertos', 210),
(277, 'Bach: Goldberg Variations', 211),
(278, 'Bach: The Cello Suites', 212),
(279, 'Handel: The Messiah (Highlights)', 213),
(280, 'The World of Classical Favourites', 214),
(281, 'Sir Neville Marriner: A Celebration', 215),
(282, 'Mozart: Wind Concertos', 216),
(283, 'Haydn: Symphonies 99 - 104', 217),
(284, 'Beethoven: Symhonies Nos. 5 & 6', 218),
(285, 'A Soprano Inspired', 219),
(286, 'Great Opera Choruses', 220),
(287, 'Wagner: Favourite Overtures', 221),
(288, 'Fauré: Requiem, Ravel: Pavane & Others', 222),
(289, 'Tchaikovsky: The Nutcracker', 223),
(290, 'The Last Night of the Proms', 224),
(291, 'Puccini: Madama Butterfly - Highlights', 225),
(292, 'Holst: The Planets, Op. 32 & Vaughan Williams: Fantasies', 226),
(293, 'Pavarotti\'s Opera Made Easy', 227),
(294, 'Great Performances - Barber\'s Adagio and Other Romantic Favorites for Strings', 228),
(295, 'Carmina Burana', 229),
(296, 'A Copland Celebration, Vol. I', 230),
(297, 'Bach: Toccata & Fugue in D Minor', 231),
(298, 'Prokofiev: Symphony No.1', 232),
(299, 'Scheherazade', 233),
(300, 'Bach: The Brandenburg Concertos', 234),
(301, 'Chopin: Piano Concertos Nos. 1 & 2', 235),
(302, 'Mascagni: Cavalleria Rusticana', 236),
(303, 'Sibelius: Finlandia', 237),
(304, 'Beethoven Piano Sonatas: Moonlight & Pastorale', 238),
(305, 'Great Recordings of the Century - Mahler: Das Lied von der Erde', 240),
(306, 'Elgar: Cello Concerto & Vaughan Williams: Fantasias', 241),
(307, 'Adams, John: The Chairman Dances', 242),
(308, 'Tchaikovsky: 1812 Festival Overture, Op.49, Capriccio Italien & Beethoven: Wellington\'s Victory', 243),
(309, 'Palestrina: Missa Papae Marcelli & Allegri: Miserere', 244),
(310, 'Prokofiev: Romeo & Juliet', 245),
(311, 'Strauss: Waltzes', 226),
(312, 'Berlioz: Symphonie Fantastique', 245),
(313, 'Bizet: Carmen Highlights', 246),
(314, 'English Renaissance', 247),
(315, 'Handel: Music for the Royal Fireworks (Original Version 1749)', 208),
(316, 'Grieg: Peer Gynt Suites & Sibelius: Pelléas et Mélisande', 248),
(317, 'Mozart Gala: Famous Arias', 249),
(318, 'SCRIABIN: Vers la flamme', 250),
(319, 'Armada: Music from the Courts of England and Spain', 251),
(320, 'Mozart: Symphonies Nos. 40 & 41', 248),
(321, 'Back to Black', 252),
(322, 'Frank', 252),
(323, 'Carried to Dust (Bonus Track Version)', 253),
(324, 'Beethoven: Symphony No. 6 \'Pastoral\' Etc.', 254),
(325, 'Bartok: Violin & Viola Concertos', 255),
(326, 'Mendelssohn: A Midsummer Night\'s Dream', 256),
(327, 'Bach: Orchestral Suites Nos. 1 - 4', 257),
(328, 'Charpentier: Divertissements, Airs & Concerts', 258),
(329, 'South American Getaway', 259),
(330, 'Górecki: Symphony No. 3', 260),
(331, 'Purcell: The Fairy Queen', 261),
(332, 'The Ultimate Relexation Album', 262),
(333, 'Purcell: Music for the Queen Mary', 263),
(334, 'Weill: The Seven Deadly Sins', 264),
(335, 'J.S. Bach: Chaconne, Suite in E Minor, Partita in E Major & Prelude, Fugue and Allegro', 265),
(336, 'Prokofiev: Symphony No.5 & Stravinksy: Le Sacre Du Printemps', 248),
(337, 'Szymanowski: Piano Works, Vol. 1', 266),
(338, 'Nielsen: The Six Symphonies', 267),
(339, 'Great Recordings of the Century: Paganini\'s 24 Caprices', 268),
(340, 'Liszt - 12 Études D\'Execution Transcendante', 269),
(341, 'Great Recordings of the Century - Shubert: Schwanengesang, 4 Lieder', 270),
(342, 'Locatelli: Concertos for Violin, Strings and Continuo, Vol. 3', 271),
(343, 'Respighi:Pines of Rome', 226),
(344, 'Schubert: The Late String Quartets & String Quintet (3 CD\'s)', 272),
(345, 'Monteverdi: L\'Orfeo', 273),
(346, 'Mozart: Chamber Music', 274),
(347, 'Koyaanisqatsi (Soundtrack from the Motion Picture)', 275);
-- --------------------------------------------------------
--
-- Structure de la table `Artist`
--
CREATE TABLE `Artist` (
`ArtistId` int(11) NOT NULL,
`Name` varchar(120) DEFAULT NULL
) ;
--
-- Déchargement des données de la table `Artist`
--
INSERT INTO `Artist` (`ArtistId`, `Name`) VALUES
(1, 'AC/DC'),
(2, 'Accept'),
(3, 'Aerosmith'),
(4, 'Alanis Morissette'),
(5, 'Alice In Chains'),
(6, 'Antônio Carlos Jobim'),
(7, 'Apocalyptica'),
(8, 'Audioslave'),
(9, 'BackBeat'),
(10, 'Billy Cobham'),
(11, 'Black Label Society'),
(12, 'Black Sabbath'),
(13, 'Body Count'),
(14, 'Bruce Dickinson'),
(15, 'Buddy Guy'),
(16, 'Caetano Veloso'),
(17, 'Chico Buarque'),
(18, 'Chico Science & Nação Zumbi'),
(19, 'Cidade Negra'),
(20, 'Cláudio Zoli'),
(21, 'Various Artists'),
(22, 'Led Zeppelin'),
(23, 'Frank Zappa & Captain Beefheart'),
(24, 'Marcos Valle'),
(25, 'Milton Nascimento & Bebeto'),
(26, 'Azymuth'),
(27, 'Gilberto Gil'),
(28, 'João Gilberto'),
(29, 'Bebel Gilberto'),
(30, 'Jorge Vercilo'),
(31, 'Baby Consuelo'),
(32, 'Ney Matogrosso'),
(33, 'Luiz Melodia'),
(34, 'Nando Reis'),
(35, 'Pedro Luís & A Parede'),
(36, 'O Rappa'),
(37, 'Ed Motta'),
(38, 'Banda Black Rio'),
(39, 'Fernanda Porto'),
(40, 'Os Cariocas'),
(41, 'Elis Regina'),
(42, 'Milton Nascimento'),
(43, 'A Cor Do Som'),
(44, 'Kid Abelha'),
(45, 'Sandra De Sá'),
(46, 'Jorge Ben'),
(47, 'Hermeto Pascoal'),
(48, 'Barão Vermelho'),
(49, 'Edson, DJ Marky & DJ Patife Featuring Fernanda Porto'),
(50, 'Metallica'),
(51, 'Queen'),
(52, 'Kiss'),
(53, 'Spyro Gyra'),
(54, 'Green Day'),
(55, 'David Coverdale'),
(56, 'Gonzaguinha'),
(57, 'Os Mutantes'),
(58, 'Deep Purple'),
(59, 'Santana'),
(60, 'Santana Feat. Dave Matthews'),
(61, 'Santana Feat. Everlast'),
(62, 'Santana Feat. Rob Thomas'),
(63, 'Santana Feat. Lauryn Hill & Cee-Lo'),
(64, 'Santana Feat. The Project G&B'),
(65, 'Santana Feat. Maná'),
(66, 'Santana Feat. Eagle-Eye Cherry'),
(67, 'Santana Feat. Eric Clapton'),
(68, 'Miles Davis'),
(69, 'Gene Krupa'),
(70, 'Toquinho & Vinícius'),
(71, 'Vinícius De Moraes & Baden Powell'),
(72, 'Vinícius De Moraes'),
(73, 'Vinícius E Qurteto Em Cy'),
(74, 'Vinícius E Odette Lara'),
(75, 'Vinicius, Toquinho & Quarteto Em Cy'),
(76, 'Creedence Clearwater Revival'),
(77, 'Cássia Eller'),
(78, 'Def Leppard'),
(79, 'Dennis Chambers'),
(80, 'Djavan'),
(81, 'Eric Clapton'),
(82, 'Faith No More'),
(83, 'Falamansa'),
(84, 'Foo Fighters'),
(85, 'Frank Sinatra'),
(86, 'Funk Como Le Gusta'),
(87, 'Godsmack'),
(88, 'Guns N\' Roses'),
(89, 'Incognito'),
(90, 'Iron Maiden'),
(91, 'James Brown'),
(92, 'Jamiroquai'),
(93, 'JET'),
(94, 'Jimi Hendrix'),
(95, 'Joe Satriani'),
(96, 'Jota Quest'),
(97, 'João Suplicy'),
(98, 'Judas Priest'),
(99, 'Legião Urbana'),
(100, 'Lenny Kravitz'),
(101, 'Lulu Santos'),
(102, 'Marillion'),
(103, 'Marisa Monte'),
(104, 'Marvin Gaye'),
(105, 'Men At Work'),
(106, 'Motörhead'),
(107, 'Motörhead & Girlschool'),
(108, 'Mônica Marianno'),
(109, 'Mötley Crüe'),
(110, 'Nirvana'),
(111, 'O Terço'),
(112, 'Olodum'),
(113, 'Os Paralamas Do Sucesso'),
(114, 'Ozzy Osbourne'),
(115, 'Page & Plant'),
(116, 'Passengers'),
(117, 'Paul D\'Ianno'),
(118, 'Pearl Jam'),
(119, 'Peter Tosh'),
(120, 'Pink Floyd'),
(121, 'Planet Hemp'),
(122, 'R.E.M. Feat. Kate Pearson'),
(123, 'R.E.M. Feat. KRS-One'),
(124, 'R.E.M.'),
(125, 'Raimundos'),
(126, 'Raul Seixas'),
(127, 'Red Hot Chili Peppers'),
(128, 'Rush'),
(129, 'Simply Red'),
(130, 'Skank'),
(131, 'Smashing Pumpkins'),
(132, 'Soundgarden'),
(133, 'Stevie Ray Vaughan & Double Trouble'),
(134, 'Stone Temple Pilots'),
(135, 'System Of A Down'),
(136, 'Terry Bozzio, Tony Levin & Steve Stevens'),
(137, 'The Black Crowes'),
(138, 'The Clash'),
(139, 'The Cult'),
(140, 'The Doors'),
(141, 'The Police'),
(142, 'The Rolling Stones'),
(143, 'The Tea Party'),
(144, 'The Who'),
(145, 'Tim Maia'),
(146, 'Titãs'),
(147, 'Battlestar Galactica'),
(148, 'Heroes'),
(149, 'Lost'),
(150, 'U2'),
(151, 'UB40'),
(152, 'Van Halen'),
(153, 'Velvet Revolver'),
(154, 'Whitesnake'),
(155, 'Zeca Pagodinho'),
(156, 'The Office'),
(157, 'Dread Zeppelin'),
(158, 'Battlestar Galactica (Classic)'),
(159, 'Aquaman'),
(160, 'Christina Aguilera featuring BigElf'),
(161, 'Aerosmith & Sierra Leone\'s Refugee Allstars'),
(162, 'Los Lonely Boys'),
(163, 'Corinne Bailey Rae'),
(164, 'Dhani Harrison & Jakob Dylan'),
(165, 'Jackson Browne'),
(166, 'Avril Lavigne'),
(167, 'Big & Rich'),
(168, 'Youssou N\'Dour'),
(169, 'Black Eyed Peas'),
(170, 'Jack Johnson'),
(171, 'Ben Harper'),
(172, 'Snow Patrol'),
(173, 'Matisyahu'),
(174, 'The Postal Service'),
(175, 'Jaguares'),
(176, 'The Flaming Lips'),
(177, 'Jack\'s Mannequin & Mick Fleetwood'),
(178, 'Regina Spektor'),
(179, 'Scorpions'),
(180, 'House Of Pain'),
(181, 'Xis'),
(182, 'Nega Gizza'),
(183, 'Gustavo & Andres Veiga & Salazar'),
(184, 'Rodox'),
(185, 'Charlie Brown Jr.'),
(186, 'Pedro Luís E A Parede'),
(187, 'Los Hermanos'),
(188, 'Mundo Livre S/A'),
(189, 'Otto'),
(190, 'Instituto'),
(191, 'Nação Zumbi'),
(192, 'DJ Dolores & Orchestra Santa Massa'),
(193, 'Seu Jorge'),
(194, 'Sabotage E Instituto'),
(195, 'Stereo Maracana'),
(196, 'Cake'),
(197, 'Aisha Duo'),
(198, 'Habib Koité and Bamada'),
(199, 'Karsh Kale'),
(200, 'The Posies'),
(201, 'Luciana Souza/Romero Lubambo'),
(202, 'Aaron Goldberg'),
(203, 'Nicolaus Esterhazy Sinfonia'),
(204, 'Temple of the Dog'),
(205, 'Chris Cornell'),
(206, 'Alberto Turco & Nova Schola Gregoriana'),
(207, 'Richard Marlow & The Choir of Trinity College, Cambridge'),
(208, 'English Concert & Trevor Pinnock'),
(209, 'Anne-Sophie Mutter, Herbert Von Karajan & Wiener Philharmoniker'),
(210, 'Hilary Hahn, Jeffrey Kahane, Los Angeles Chamber Orchestra & Margaret Batjer'),
(211, 'Wilhelm Kempff'),
(212, 'Yo-Yo Ma'),
(213, 'Scholars Baroque Ensemble'),
(214, 'Academy of St. Martin in the Fields & Sir Neville Marriner'),
(215, 'Academy of St. Martin in the Fields Chamber Ensemble & Sir Neville Marriner'),
(216, 'Berliner Philharmoniker, Claudio Abbado & Sabine Meyer'),
(217, 'Royal Philharmonic Orchestra & Sir Thomas Beecham'),
(218, 'Orchestre Révolutionnaire et Romantique & John Eliot Gardiner'),
(219, 'Britten Sinfonia, Ivor Bolton & Lesley Garrett'),
(220, 'Chicago Symphony Chorus, Chicago Symphony Orchestra & Sir Georg Solti'),
(221, 'Sir Georg Solti & Wiener Philharmoniker'),
(222, 'Academy of St. Martin in the Fields, John Birch, Sir Neville Marriner & Sylvia McNair'),
(223, 'London Symphony Orchestra & Sir Charles Mackerras'),
(224, 'Barry Wordsworth & BBC Concert Orchestra'),
(225, 'Herbert Von Karajan, Mirella Freni & Wiener Philharmoniker'),
(226, 'Eugene Ormandy'),
(227, 'Luciano Pavarotti'),
(228, 'Leonard Bernstein & New York Philharmonic'),
(229, 'Boston Symphony Orchestra & Seiji Ozawa'),
(230, 'Aaron Copland & London Symphony Orchestra'),
(231, 'Ton Koopman'),
(232, 'Sergei Prokofiev & Yuri Temirkanov'),
(233, 'Chicago Symphony Orchestra & Fritz Reiner'),
(234, 'Orchestra of The Age of Enlightenment'),
(235, 'Emanuel Ax, Eugene Ormandy & Philadelphia Orchestra'),
(236, 'James Levine'),
(237, 'Berliner Philharmoniker & Hans Rosbaud'),
(238, 'Maurizio Pollini'),
(239, 'Academy of St. Martin in the Fields, Sir Neville Marriner & William Bennett'),
(240, 'Gustav Mahler'),
(241, 'Felix Schmidt, London Symphony Orchestra & Rafael Frühbeck de Burgos'),
(242, 'Edo de Waart & San Francisco Symphony'),
(243, 'Antal Doráti & London Symphony Orchestra'),
(244, 'Choir Of Westminster Abbey & Simon Preston'),
(245, 'Michael Tilson Thomas & San Francisco Symphony'),
(246, 'Chor der Wiener Staatsoper, Herbert Von Karajan & Wiener Philharmoniker'),
(247, 'The King\'s Singers'),
(248, 'Berliner Philharmoniker & Herbert Von Karajan'),
(249, 'Sir Georg Solti, Sumi Jo & Wiener Philharmoniker'),
(250, 'Christopher O\'Riley'),
(251, 'Fretwork'),
(252, 'Amy Winehouse'),
(253, 'Calexico'),
(254, 'Otto Klemperer & Philharmonia Orchestra'),
(255, 'Yehudi Menuhin'),
(256, 'Philharmonia Orchestra & Sir Neville Marriner'),
(257, 'Academy of St. Martin in the Fields, Sir Neville Marriner & Thurston Dart'),
(258, 'Les Arts Florissants & William Christie'),
(259, 'The 12 Cellists of The Berlin Philharmonic'),
(260, 'Adrian Leaper & Doreen de Feis'),
(261, 'Roger Norrington, London Classical Players'),
(262, 'Charles Dutoit & L\'Orchestre Symphonique de Montréal'),
(263, 'Equale Brass Ensemble, John Eliot Gardiner & Munich Monteverdi Orchestra and Choir'),
(264, 'Kent Nagano and Orchestre de l\'Opéra de Lyon'),
(265, 'Julian Bream'),
(266, 'Martin Roscoe'),
(267, 'Göteborgs Symfoniker & Neeme Järvi'),
(268, 'Itzhak Perlman'),
(269, 'Michele Campanella'),
(270, 'Gerald Moore'),
(271, 'Mela Tenenbaum, Pro Musica Prague & Richard Kapp'),
(272, 'Emerson String Quartet'),
(273, 'C. Monteverdi, Nigel Rogers - Chiaroscuro; London Baroque; London Cornett & Sackbu'),
(274, 'Nash Ensemble'),
(275, 'Philip Glass Ensemble');
-- --------------------------------------------------------
--
-- Structure de la table `Customer`
--
CREATE TABLE `Customer` (
`CustomerId` int(11) NOT NULL,
`FirstName` varchar(40) NOT NULL,
`LastName` varchar(20) NOT NULL,
`Company` varchar(80) DEFAULT NULL,
`Address` varchar(70) DEFAULT NULL,
`City` varchar(40) DEFAULT NULL,
`State` varchar(40) DEFAULT NULL,
`Country` varchar(40) DEFAULT NULL,
`PostalCode` varchar(10) DEFAULT NULL,
`Phone` varchar(24) DEFAULT NULL,
`Fax` varchar(24) DEFAULT NULL,
`Email` varchar(60) NOT NULL,
`SupportRepId` int(11) DEFAULT NULL
) ;
--
-- Déchargement des données de la table `Customer`
--
INSERT INTO `Customer` (`CustomerId`, `FirstName`, `LastName`, `Company`, `Address`, `City`, `State`, `Country`, `PostalCode`, `Phone`, `Fax`, `Email`, `SupportRepId`) VALUES
(1, 'Luís', 'Gonçalves', 'Embraer - Empresa Brasileira de Aeronáutica S.A.', 'Av. Brigadeiro Faria Lima, 2170', 'São José dos Campos', 'SP', 'Brazil', '12227-000', '+55 (12) 3923-5555', '+55 (12) 3923-5566', '[email protected]', 3),
(2, 'Leonie', 'Köhler', NULL, 'Theodor-Heuss-Straße 34', 'Stuttgart', NULL, 'Germany', '70174', '+49 0711 2842222', NULL, '[email protected]', 5),
(3, 'François', 'Tremblay', NULL, '1498 rue Bélanger', 'Montréal', 'QC', 'Canada', 'H2G 1A7', '+1 (514) 721-4711', NULL, '[email protected]', 3),
(4, 'Bjørn', 'Hansen', NULL, 'Ullevålsveien 14', 'Oslo', NULL, 'Norway', '0171', '+47 22 44 22 22', NULL, '[email protected]', 4),
(5, 'František', 'Wichterlová', 'JetBrains s.r.o.', 'Klanova 9/506', 'Prague', NULL, 'Czech Republic', '14700', '+420 2 4172 5555', '+420 2 4172 5555', '[email protected]', 4),
(6, 'Helena', 'Holý', NULL, 'Rilská 3174/6', 'Prague', NULL, 'Czech Republic', '14300', '+420 2 4177 0449', NULL, '[email protected]', 5),
(7, 'Astrid', 'Gruber', NULL, 'Rotenturmstraße 4, 1010 Innere Stadt', 'Vienne', NULL, 'Austria', '1010', '+43 01 5134505', NULL, '[email protected]', 5),
(8, 'Daan', 'Peeters', NULL, 'Grétrystraat 63', 'Brussels', NULL, 'Belgium', '1000', '+32 02 219 03 03', NULL, '[email protected]', 4),
(9, 'Kara', 'Nielsen', NULL, 'Sønder Boulevard 51', 'Copenhagen', NULL, 'Denmark', '1720', '+453 3331 9991', NULL, '[email protected]', 4),
(10, 'Eduardo', 'Martins', 'Woodstock Discos', 'Rua Dr. Falcão Filho, 155', 'São Paulo', 'SP', 'Brazil', '01007-010', '+55 (11) 3033-5446', '+55 (11) 3033-4564', '[email protected]', 4),
(11, 'Alexandre', 'Rocha', 'Banco do Brasil S.A.', 'Av. Paulista, 2022', 'São Paulo', 'SP', 'Brazil', '01310-200', '+55 (11) 3055-3278', '+55 (11) 3055-8131', '[email protected]', 5),
(12, 'Roberto', 'Almeida', 'Riotur', 'Praça Pio X, 119', 'Rio de Janeiro', 'RJ', 'Brazil', '20040-020', '+55 (21) 2271-7000', '+55 (21) 2271-7070', '[email protected]', 3),
(13, 'Fernanda', 'Ramos', NULL, 'Qe 7 Bloco G', 'Brasília', 'DF', 'Brazil', '71020-677', '+55 (61) 3363-5547', '+55 (61) 3363-7855', '[email protected]', 4),
(14, 'Mark', 'Philips', 'Telus', '8210 111 ST NW', 'Edmonton', 'AB', 'Canada', 'T6G 2C7', '+1 (780) 434-4554', '+1 (780) 434-5565', '[email protected]', 5),
(15, 'Jennifer', 'Peterson', 'Rogers Canada', '700 W Pender Street', 'Vancouver', 'BC', 'Canada', 'V6C 1G8', '+1 (604) 688-2255', '+1 (604) 688-8756', '[email protected]', 3),
(16, 'Frank', 'Harris', 'Google Inc.', '1600 Amphitheatre Parkway', 'Mountain View', 'CA', 'USA', '94043-1351', '+1 (650) 253-0000', '+1 (650) 253-0000', '[email protected]', 4),
(17, 'Jack', 'Smith', 'Microsoft Corporation', '1 Microsoft Way', 'Redmond', 'WA', 'USA', '98052-8300', '+1 (425) 882-8080', '+1 (425) 882-8081', '[email protected]', 5),
(18, 'Michelle', 'Brooks', NULL, '627 Broadway', 'New York', 'NY', 'USA', '10012-2612', '+1 (212) 221-3546', '+1 (212) 221-4679', '[email protected]', 3),
(19, 'Tim', 'Goyer', 'Apple Inc.', '1 Infinite Loop', 'Cupertino', 'CA', 'USA', '95014', '+1 (408) 996-1010', '+1 (408) 996-1011', '[email protected]', 3),
(20, 'Dan', 'Miller', NULL, '541 Del Medio Avenue', 'Mountain View', 'CA', 'USA', '94040-111', '+1 (650) 644-3358', NULL, '[email protected]', 4),
(21, 'Kathy', 'Chase', NULL, '801 W 4th Street', 'Reno', 'NV', 'USA', '89503', '+1 (775) 223-7665', NULL, '[email protected]', 5),
(22, 'Heather', 'Leacock', NULL, '120 S Orange Ave', 'Orlando', 'FL', 'USA', '32801', '+1 (407) 999-7788', NULL, '[email protected]', 4),
(23, 'John', 'Gordon', NULL, '69 Salem Street', 'Boston', 'MA', 'USA', '2113', '+1 (617) 522-1333', NULL, '[email protected]', 4),
(24, 'Frank', 'Ralston', NULL, '162 E Superior Street', 'Chicago', 'IL', 'USA', '60611', '+1 (312) 332-3232', NULL, '[email protected]', 3),
(25, 'Victor', 'Stevens', NULL, '319 N. Frances Street', 'Madison', 'WI', 'USA', '53703', '+1 (608) 257-0597', NULL, '[email protected]', 5),
(26, 'Richard', 'Cunningham', NULL, '2211 W Berry Street', 'Fort Worth', 'TX', 'USA', '76110', '+1 (817) 924-7272', NULL, '[email protected]', 4),
(27, 'Patrick', 'Gray', NULL, '1033 N Park Ave', 'Tucson', 'AZ', 'USA', '85719', '+1 (520) 622-4200', NULL, '[email protected]', 4),
(28, 'Julia', 'Barnett', NULL, '302 S 700 E', 'Salt Lake City', 'UT', 'USA', '84102', '+1 (801) 531-7272', NULL, '[email protected]', 5),
(29, 'Robert', 'Brown', NULL, '796 Dundas Street West', 'Toronto', 'ON', 'Canada', 'M6J 1V1', '+1 (416) 363-8888', NULL, '[email protected]', 3),
(30, 'Edward', 'Francis', NULL, '230 Elgin Street', 'Ottawa', 'ON', 'Canada', 'K2P 1L7', '+1 (613) 234-3322', NULL, '[email protected]', 3),
(31, 'Martha', 'Silk', NULL, '194A Chain Lake Drive', 'Halifax', 'NS', 'Canada', 'B3S 1C5', '+1 (902) 450-0450', NULL, '[email protected]', 5),
(32, 'Aaron', 'Mitchell', NULL, '696 Osborne Street', 'Winnipeg', 'MB', 'Canada', 'R3L 2B9', '+1 (204) 452-6452', NULL, '[email protected]', 4),
(33, 'Ellie', 'Sullivan', NULL, '5112 48 Street', 'Yellowknife', 'NT', 'Canada', 'X1A 1N6', '+1 (867) 920-2233', NULL, '[email protected]', 3),
(34, 'João', 'Fernandes', NULL, 'Rua da Assunção 53', 'Lisbon', NULL, 'Portugal', NULL, '+351 (213) 466-111', NULL, '[email protected]', 4),
(35, 'Madalena', 'Sampaio', NULL, 'Rua dos Campeões Europeus de Viena, 4350', 'Porto', NULL, 'Portugal', NULL, '+351 (225) 022-448', NULL, '[email protected]', 4),
(36, 'Hannah', 'Schneider', NULL, 'Tauentzienstraße 8', 'Berlin', NULL, 'Germany', '10789', '+49 030 26550280', NULL, '[email protected]', 5),
(37, 'Fynn', 'Zimmermann', NULL, 'Berger Straße 10', 'Frankfurt', NULL, 'Germany', '60316', '+49 069 40598889', NULL, '[email protected]', 3),
(38, 'Niklas', 'Schröder', NULL, 'Barbarossastraße 19', 'Berlin', NULL, 'Germany', '10779', '+49 030 2141444', NULL, '[email protected]', 3),
(39, 'Camille', 'Bernard', NULL, '4, Rue Milton', 'Paris', NULL, 'France', '75009', '+33 01 49 70 65 65', NULL, '[email protected]', 4),
(40, 'Dominique', 'Lefebvre', NULL, '8, Rue Hanovre', 'Paris', NULL, 'France', '75002', '+33 01 47 42 71 71', NULL, '[email protected]', 4),
(41, 'Marc', 'Dubois', NULL, '11, Place Bellecour', 'Lyon', NULL, 'France', '69002', '+33 04 78 30 30 30', NULL, '[email protected]', 5),
(42, 'Wyatt', 'Girard', NULL, '9, Place Louis Barthou', 'Bordeaux', NULL, 'France', '33000', '+33 05 56 96 96 96', NULL, '[email protected]', 3),
(43, 'Isabelle', 'Mercier', NULL, '68, Rue Jouvence', 'Dijon', NULL, 'France', '21000', '+33 03 80 73 66 99', NULL, '[email protected]', 3),
(44, 'Terhi', 'Hämäläinen', NULL, 'Porthaninkatu 9', 'Helsinki', NULL, 'Finland', '00530', '+358 09 870 2000', NULL, '[email protected]', 3),
(45, 'Ladislav', 'Kovács', NULL, 'Erzsébet krt. 58.', 'Budapest', NULL, 'Hungary', 'H-1073', NULL, NULL, '[email protected]', 3),
(46, 'Hugh', 'O\'Reilly', NULL, '3 Chatham Street', 'Dublin', 'Dublin', 'Ireland', NULL, '+353 01 6792424', NULL, '[email protected]', 3),
(47, 'Lucas', 'Mancini', NULL, 'Via Degli Scipioni, 43', 'Rome', 'RM', 'Italy', '00192', '+39 06 39733434', NULL, '[email protected]', 5),
(48, 'Johannes', 'Van der Berg', NULL, 'Lijnbaansgracht 120bg', 'Amsterdam', 'VV', 'Netherlands', '1016', '+31 020 6223130', NULL, '[email protected]', 5),
(49, 'Stanisław', 'Wójcik', NULL, 'Ordynacka 10', 'Warsaw', NULL, 'Poland', '00-358', '+48 22 828 37 39', NULL, 'stanisław.wó[email protected]', 4),
(50, 'Enrique', 'Muñoz', NULL, 'C/ San Bernardo 85', 'Madrid', NULL, 'Spain', '28015', '+34 914 454 454', NULL, '[email protected]', 5),
(51, 'Joakim', 'Johansson', NULL, 'Celsiusg. 9', 'Stockholm', NULL, 'Sweden', '11230', '+46 08-651 52 52', NULL, '[email protected]', 5),
(52, 'Emma', 'Jones', NULL, '202 Hoxton Street', 'London', NULL, 'United Kingdom', 'N1 5LH', '+44 020 7707 0707', NULL, '[email protected]', 3),
(53, 'Phil', 'Hughes', NULL, '113 Lupus St', 'London', NULL, 'United Kingdom', 'SW1V 3EN', '+44 020 7976 5722', NULL, '[email protected]', 3),
(54, 'Steve', 'Murray', NULL, '110 Raeburn Pl', 'Edinburgh ', NULL, 'United Kingdom', 'EH4 1HH', '+44 0131 315 3300', NULL, '[email protected]', 5),
(55, 'Mark', 'Taylor', NULL, '421 Bourke Street', 'Sidney', 'NSW', 'Australia', '2010', '+61 (02) 9332 3633', NULL, '[email protected]', 4),
(56, 'Diego', 'Gutiérrez', NULL, '307 Macacha Güemes', 'Buenos Aires', NULL, 'Argentina', '1106', '+54 (0)11 4311 4333', NULL, '[email protected]', 4),
(57, 'Luis', 'Rojas', NULL, 'Calle Lira, 198', 'Santiago', NULL, 'Chile', NULL, '+56 (0)2 635 4444', NULL, '[email protected]', 5),
(58, 'Manoj', 'Pareek', NULL, '12,Community Centre', 'Delhi', NULL, 'India', '110017', '+91 0124 39883988', NULL, '[email protected]', 3),
(59, 'Puja', 'Srivastava', NULL, '3,Raj Bhavan Road', 'Bangalore', NULL, 'India', '560001', '+91 080 22289999', NULL, '[email protected]', 3);
-- --------------------------------------------------------
--
-- Structure de la table `Employee`
--
CREATE TABLE `Employee` (
`EmployeeId` int(11) NOT NULL,
`LastName` varchar(20) NOT NULL,
`FirstName` varchar(20) NOT NULL,
`Title` varchar(30) DEFAULT NULL,
`ReportsTo` int(11) DEFAULT NULL,
`BirthDate` datetime DEFAULT NULL,
`HireDate` datetime DEFAULT NULL,
`Address` varchar(70) DEFAULT NULL,
`City` varchar(40) DEFAULT NULL,
`State` varchar(40) DEFAULT NULL,
`Country` varchar(40) DEFAULT NULL,
`PostalCode` varchar(10) DEFAULT NULL,
`Phone` varchar(24) DEFAULT NULL,
`Fax` varchar(24) DEFAULT NULL,
`Email` varchar(60) DEFAULT NULL
) ;
--
-- Déchargement des données de la table `Employee`
--
INSERT INTO `Employee` (`EmployeeId`, `LastName`, `FirstName`, `Title`, `ReportsTo`, `BirthDate`, `HireDate`, `Address`, `City`, `State`, `Country`, `PostalCode`, `Phone`, `Fax`, `Email`) VALUES
(1, 'Adams', 'Andrew', 'General Manager', NULL, '1962-02-18 00:00:00', '2002-08-14 00:00:00', '11120 Jasper Ave NW', 'Edmonton', 'AB', 'Canada', 'T5K 2N1', '+1 (780) 428-9482', '+1 (780) 428-3457', '[email protected]'),
(2, 'Edwards', 'Nancy', 'Sales Manager', 1, '1958-12-08 00:00:00', '2002-05-01 00:00:00', '825 8 Ave SW', 'Calgary', 'AB', 'Canada', 'T2P 2T3', '+1 (403) 262-3443', '+1 (403) 262-3322', '[email protected]'),
(3, 'Peacock', 'Jane', 'Sales Support Agent', 2, '1973-08-29 00:00:00', '2002-04-01 00:00:00', '1111 6 Ave SW', 'Calgary', 'AB', 'Canada', 'T2P 5M5', '+1 (403) 262-3443', '+1 (403) 262-6712', '[email protected]'),
(4, 'Park', 'Margaret', 'Sales Support Agent', 2, '1947-09-19 00:00:00', '2003-05-03 00:00:00', '683 10 Street SW', 'Calgary', 'AB', 'Canada', 'T2P 5G3', '+1 (403) 263-4423', '+1 (403) 263-4289', '[email protected]'),
(5, 'Johnson', 'Steve', 'Sales Support Agent', 2, '1965-03-03 00:00:00', '2003-10-17 00:00:00', '7727B 41 Ave', 'Calgary', 'AB', 'Canada', 'T3B 1Y7', '1 (780) 836-9987', '1 (780) 836-9543', '[email protected]'),
(6, 'Mitchell', 'Michael', 'IT Manager', 1, '1973-07-01 00:00:00', '2003-10-17 00:00:00', '5827 Bowness Road NW', 'Calgary', 'AB', 'Canada', 'T3B 0C5', '+1 (403) 246-9887', '+1 (403) 246-9899', '[email protected]'),
(7, 'King', 'Robert', 'IT Staff', 6, '1970-05-29 00:00:00', '2004-01-02 00:00:00', '590 Columbia Boulevard West', 'Lethbridge', 'AB', 'Canada', 'T1K 5N8', '+1 (403) 456-9986', '+1 (403) 456-8485', '[email protected]'),
(8, 'Callahan', 'Laura', 'IT Staff', 6, '1968-01-09 00:00:00', '2004-03-04 00:00:00', '923 7 ST NW', 'Lethbridge', 'AB', 'Canada', 'T1H 1Y8', '+1 (403) 467-3351', '+1 (403) 467-8772', '[email protected]');
-- --------------------------------------------------------
--
-- Structure de la table `Genre`
--
CREATE TABLE `Genre` (
`GenreId` int(11) NOT NULL,
`Name` varchar(120) DEFAULT NULL
) ;
--
-- Déchargement des données de la table `Genre`
--
INSERT INTO `Genre` (`GenreId`, `Name`) VALUES
(1, 'Rock'),
(2, 'Jazz'),
(3, 'Metal'),
(4, 'Alternative & Punk'),
(5, 'Rock And Roll'),
(6, 'Blues'),
(7, 'Latin'),
(8, 'Reggae'),
(9, 'Pop'),
(10, 'Soundtrack'),
(11, 'Bossa Nova'),
(12, 'Easy Listening'),
(13, 'Heavy Metal'),
(14, 'R&B/Soul'),
(15, 'Electronica/Dance'),
(16, 'World'),
(17, 'Hip Hop/Rap'),
(18, 'Science Fiction'),
(19, 'TV Shows'),
(20, 'Sci Fi & Fantasy'),
(21, 'Drama'),
(22, 'Comedy'),
(23, 'Alternative'),
(24, 'Classical'),
(25, 'Opera');
-- --------------------------------------------------------
--
-- Structure de la table `Invoice`
--
CREATE TABLE `Invoice` (
`InvoiceId` int(11) NOT NULL,
`CustomerId` int(11) NOT NULL,
`InvoiceDate` datetime NOT NULL,
`BillingAddress` varchar(70) DEFAULT NULL,
`BillingCity` varchar(40) DEFAULT NULL,
`BillingState` varchar(40) DEFAULT NULL,
`BillingCountry` varchar(40) DEFAULT NULL,
`BillingPostalCode` varchar(10) DEFAULT NULL,
`Total` decimal(10,2) NOT NULL
) ;
--
-- Déchargement des données de la table `Invoice`
--
INSERT INTO `Invoice` (`InvoiceId`, `CustomerId`, `InvoiceDate`, `BillingAddress`, `BillingCity`, `BillingState`, `BillingCountry`, `BillingPostalCode`, `Total`) VALUES
(1, 2, '2009-01-01 00:00:00', 'Theodor-Heuss-Straße 34', 'Stuttgart', NULL, 'Germany', '70174', 1.98),
(2, 4, '2009-01-02 00:00:00', 'Ullevålsveien 14', 'Oslo', NULL, 'Norway', '0171', 3.96),
(3, 8, '2009-01-03 00:00:00', 'Grétrystraat 63', 'Brussels', NULL, 'Belgium', '1000', 5.94),
(4, 14, '2009-01-06 00:00:00', '8210 111 ST NW', 'Edmonton', 'AB', 'Canada', 'T6G 2C7', 8.91),
(5, 23, '2009-01-11 00:00:00', '69 Salem Street', 'Boston', 'MA', 'USA', '2113', 13.86),
(6, 37, '2009-01-19 00:00:00', 'Berger Straße 10', 'Frankfurt', NULL, 'Germany', '60316', 0.99),
(7, 38, '2009-02-01 00:00:00', 'Barbarossastraße 19', 'Berlin', NULL, 'Germany', '10779', 1.98),
(8, 40, '2009-02-01 00:00:00', '8, Rue Hanovre', 'Paris', NULL, 'France', '75002', 1.98),
(9, 42, '2009-02-02 00:00:00', '9, Place Louis Barthou', 'Bordeaux', NULL, 'France', '33000', 3.96),
(10, 46, '2009-02-03 00:00:00', '3 Chatham Street', 'Dublin', 'Dublin', 'Ireland', NULL, 5.94),
(11, 52, '2009-02-06 00:00:00', '202 Hoxton Street', 'London', NULL, 'United Kingdom', 'N1 5LH', 8.91),
(12, 2, '2009-02-11 00:00:00', 'Theodor-Heuss-Straße 34', 'Stuttgart', NULL, 'Germany', '70174', 13.86),
(13, 16, '2009-02-19 00:00:00', '1600 Amphitheatre Parkway', 'Mountain View', 'CA', 'USA', '94043-1351', 0.99),
(14, 17, '2009-03-04 00:00:00', '1 Microsoft Way', 'Redmond', 'WA', 'USA', '98052-8300', 1.98),
(15, 19, '2009-03-04 00:00:00', '1 Infinite Loop', 'Cupertino', 'CA', 'USA', '95014', 1.98),
(16, 21, '2009-03-05 00:00:00', '801 W 4th Street', 'Reno', 'NV', 'USA', '89503', 3.96),
(17, 25, '2009-03-06 00:00:00', '319 N. Frances Street', 'Madison', 'WI', 'USA', '53703', 5.94),
(18, 31, '2009-03-09 00:00:00', '194A Chain Lake Drive', 'Halifax', 'NS', 'Canada', 'B3S 1C5', 8.91),
(19, 40, '2009-03-14 00:00:00', '8, Rue Hanovre', 'Paris', NULL, 'France', '75002', 13.86),
(20, 54, '2009-03-22 00:00:00', '110 Raeburn Pl', 'Edinburgh ', NULL, 'United Kingdom', 'EH4 1HH', 0.99),
(21, 55, '2009-04-04 00:00:00', '421 Bourke Street', 'Sidney', 'NSW', 'Australia', '2010', 1.98),
(22, 57, '2009-04-04 00:00:00', 'Calle Lira, 198', 'Santiago', NULL, 'Chile', NULL, 1.98),
(23, 59, '2009-04-05 00:00:00', '3,Raj Bhavan Road', 'Bangalore', NULL, 'India', '560001', 3.96),
(24, 4, '2009-04-06 00:00:00', 'Ullevålsveien 14', 'Oslo', NULL, 'Norway', '0171', 5.94),
(25, 10, '2009-04-09 00:00:00', 'Rua Dr. Falcão Filho, 155', 'São Paulo', 'SP', 'Brazil', '01007-010', 8.91),
(26, 19, '2009-04-14 00:00:00', '1 Infinite Loop', 'Cupertino', 'CA', 'USA', '95014', 13.86),
(27, 33, '2009-04-22 00:00:00', '5112 48 Street', 'Yellowknife', 'NT', 'Canada', 'X1A 1N6', 0.99),
(28, 34, '2009-05-05 00:00:00', 'Rua da Assunção 53', 'Lisbon', NULL, 'Portugal', NULL, 1.98),
(29, 36, '2009-05-05 00:00:00', 'Tauentzienstraße 8', 'Berlin', NULL, 'Germany', '10789', 1.98),
(30, 38, '2009-05-06 00:00:00', 'Barbarossastraße 19', 'Berlin', NULL, 'Germany', '10779', 3.96),
(31, 42, '2009-05-07 00:00:00', '9, Place Louis Barthou', 'Bordeaux', NULL, 'France', '33000', 5.94),
(32, 48, '2009-05-10 00:00:00', 'Lijnbaansgracht 120bg', 'Amsterdam', 'VV', 'Netherlands', '1016', 8.91),
(33, 57, '2009-05-15 00:00:00', 'Calle Lira, 198', 'Santiago', NULL, 'Chile', NULL, 13.86),
(34, 12, '2009-05-23 00:00:00', 'Praça Pio X, 119', 'Rio de Janeiro', 'RJ', 'Brazil', '20040-020', 0.99),
(35, 13, '2009-06-05 00:00:00', 'Qe 7 Bloco G', 'Brasília', 'DF', 'Brazil', '71020-677', 1.98),
(36, 15, '2009-06-05 00:00:00', '700 W Pender Street', 'Vancouver', 'BC', 'Canada', 'V6C 1G8', 1.98),
(37, 17, '2009-06-06 00:00:00', '1 Microsoft Way', 'Redmond', 'WA', 'USA', '98052-8300', 3.96),
(38, 21, '2009-06-07 00:00:00', '801 W 4th Street', 'Reno', 'NV', 'USA', '89503', 5.94),
(39, 27, '2009-06-10 00:00:00', '1033 N Park Ave', 'Tucson', 'AZ', 'USA', '85719', 8.91),
(40, 36, '2009-06-15 00:00:00', 'Tauentzienstraße 8', 'Berlin', NULL, 'Germany', '10789', 13.86),
(41, 50, '2009-06-23 00:00:00', 'C/ San Bernardo 85', 'Madrid', NULL, 'Spain', '28015', 0.99),
(42, 51, '2009-07-06 00:00:00', 'Celsiusg. 9', 'Stockholm', NULL, 'Sweden', '11230', 1.98),
(43, 53, '2009-07-06 00:00:00', '113 Lupus St', 'London', NULL, 'United Kingdom', 'SW1V 3EN', 1.98),
(44, 55, '2009-07-07 00:00:00', '421 Bourke Street', 'Sidney', 'NSW', 'Australia', '2010', 3.96),
(45, 59, '2009-07-08 00:00:00', '3,Raj Bhavan Road', 'Bangalore', NULL, 'India', '560001', 5.94),
(46, 6, '2009-07-11 00:00:00', 'Rilská 3174/6', 'Prague', NULL, 'Czech Republic', '14300', 8.91),
(47, 15, '2009-07-16 00:00:00', '700 W Pender Street', 'Vancouver', 'BC', 'Canada', 'V6C 1G8', 13.86),
(48, 29, '2009-07-24 00:00:00', '796 Dundas Street West', 'Toronto', 'ON', 'Canada', 'M6J 1V1', 0.99),
(49, 30, '2009-08-06 00:00:00', '230 Elgin Street', 'Ottawa', 'ON', 'Canada', 'K2P 1L7', 1.98),
(50, 32, '2009-08-06 00:00:00', '696 Osborne Street', 'Winnipeg', 'MB', 'Canada', 'R3L 2B9', 1.98),
(51, 34, '2009-08-07 00:00:00', 'Rua da Assunção 53', 'Lisbon', NULL, 'Portugal', NULL, 3.96),
(52, 38, '2009-08-08 00:00:00', 'Barbarossastraße 19', 'Berlin', NULL, 'Germany', '10779', 5.94),
(53, 44, '2009-08-11 00:00:00', 'Porthaninkatu 9', 'Helsinki', NULL, 'Finland', '00530', 8.91),
(54, 53, '2009-08-16 00:00:00', '113 Lupus St', 'London', NULL, 'United Kingdom', 'SW1V 3EN', 13.86),
(55, 8, '2009-08-24 00:00:00', 'Grétrystraat 63', 'Brussels', NULL, 'Belgium', '1000', 0.99),
(56, 9, '2009-09-06 00:00:00', 'Sønder Boulevard 51', 'Copenhagen', NULL, 'Denmark', '1720', 1.98),
(57, 11, '2009-09-06 00:00:00', 'Av. Paulista, 2022', 'São Paulo', 'SP', 'Brazil', '01310-200', 1.98),
(58, 13, '2009-09-07 00:00:00', 'Qe 7 Bloco G', 'Brasília', 'DF', 'Brazil', '71020-677', 3.96),
(59, 17, '2009-09-08 00:00:00', '1 Microsoft Way', 'Redmond', 'WA', 'USA', '98052-8300', 5.94),
(60, 23, '2009-09-11 00:00:00', '69 Salem Street', 'Boston', 'MA', 'USA', '2113', 8.91),
(61, 32, '2009-09-16 00:00:00', '696 Osborne Street', 'Winnipeg', 'MB', 'Canada', 'R3L 2B9', 13.86),
(62, 46, '2009-09-24 00:00:00', '3 Chatham Street', 'Dublin', 'Dublin', 'Ireland', NULL, 0.99),
(63, 47, '2009-10-07 00:00:00', 'Via Degli Scipioni, 43', 'Rome', 'RM', 'Italy', '00192', 1.98),
(64, 49, '2009-10-07 00:00:00', 'Ordynacka 10', 'Warsaw', NULL, 'Poland', '00-358', 1.98),
(65, 51, '2009-10-08 00:00:00', 'Celsiusg. 9', 'Stockholm', NULL, 'Sweden', '11230', 3.96),
(66, 55, '2009-10-09 00:00:00', '421 Bourke Street', 'Sidney', 'NSW', 'Australia', '2010', 5.94),
(67, 2, '2009-10-12 00:00:00', 'Theodor-Heuss-Straße 34', 'Stuttgart', NULL, 'Germany', '70174', 8.91),
(68, 11, '2009-10-17 00:00:00', 'Av. Paulista, 2022', 'São Paulo', 'SP', 'Brazil', '01310-200', 13.86),
(69, 25, '2009-10-25 00:00:00', '319 N. Frances Street', 'Madison', 'WI', 'USA', '53703', 0.99),
(70, 26, '2009-11-07 00:00:00', '2211 W Berry Street', 'Fort Worth', 'TX', 'USA', '76110', 1.98),
(71, 28, '2009-11-07 00:00:00', '302 S 700 E', 'Salt Lake City', 'UT', 'USA', '84102', 1.98),
(72, 30, '2009-11-08 00:00:00', '230 Elgin Street', 'Ottawa', 'ON', 'Canada', 'K2P 1L7', 3.96),
(73, 34, '2009-11-09 00:00:00', 'Rua da Assunção 53', 'Lisbon', NULL, 'Portugal', NULL, 5.94),
(74, 40, '2009-11-12 00:00:00', '8, Rue Hanovre', 'Paris', NULL, 'France', '75002', 8.91),
(75, 49, '2009-11-17 00:00:00', 'Ordynacka 10', 'Warsaw', NULL, 'Poland', '00-358', 13.86),
(76, 4, '2009-11-25 00:00:00', 'Ullevålsveien 14', 'Oslo', NULL, 'Norway', '0171', 0.99),
(77, 5, '2009-12-08 00:00:00', 'Klanova 9/506', 'Prague', NULL, 'Czech Republic', '14700', 1.98),
(78, 7, '2009-12-08 00:00:00', 'Rotenturmstraße 4, 1010 Innere Stadt', 'Vienne', NULL, 'Austria', '1010', 1.98),
(79, 9, '2009-12-09 00:00:00', 'Sønder Boulevard 51', 'Copenhagen', NULL, 'Denmark', '1720', 3.96),
(80, 13, '2009-12-10 00:00:00', 'Qe 7 Bloco G', 'Brasília', 'DF', 'Brazil', '71020-677', 5.94),
(81, 19, '2009-12-13 00:00:00', '1 Infinite Loop', 'Cupertino', 'CA', 'USA', '95014', 8.91),
(82, 28, '2009-12-18 00:00:00', '302 S 700 E', 'Salt Lake City', 'UT', 'USA', '84102', 13.86),
(83, 42, '2009-12-26 00:00:00', '9, Place Louis Barthou', 'Bordeaux', NULL, 'France', '33000', 0.99),
(84, 43, '2010-01-08 00:00:00', '68, Rue Jouvence', 'Dijon', NULL, 'France', '21000', 1.98),
(85, 45, '2010-01-08 00:00:00', 'Erzsébet krt. 58.', 'Budapest', NULL, 'Hungary', 'H-1073', 1.98),
(86, 47, '2010-01-09 00:00:00', 'Via Degli Scipioni, 43', 'Rome', 'RM', 'Italy', '00192', 3.96),
(87, 51, '2010-01-10 00:00:00', 'Celsiusg. 9', 'Stockholm', NULL, 'Sweden', '11230', 6.94),
(88, 57, '2010-01-13 00:00:00', 'Calle Lira, 198', 'Santiago', NULL, 'Chile', NULL, 17.91),
(89, 7, '2010-01-18 00:00:00', 'Rotenturmstraße 4, 1010 Innere Stadt', 'Vienne', NULL, 'Austria', '1010', 18.86),
(90, 21, '2010-01-26 00:00:00', '801 W 4th Street', 'Reno', 'NV', 'USA', '89503', 0.99),
(91, 22, '2010-02-08 00:00:00', '120 S Orange Ave', 'Orlando', 'FL', 'USA', '32801', 1.98),
(92, 24, '2010-02-08 00:00:00', '162 E Superior Street', 'Chicago', 'IL', 'USA', '60611', 1.98),
(93, 26, '2010-02-09 00:00:00', '2211 W Berry Street', 'Fort Worth', 'TX', 'USA', '76110', 3.96),
(94, 30, '2010-02-10 00:00:00', '230 Elgin Street', 'Ottawa', 'ON', 'Canada', 'K2P 1L7', 5.94),
(95, 36, '2010-02-13 00:00:00', 'Tauentzienstraße 8', 'Berlin', NULL, 'Germany', '10789', 8.91),
(96, 45, '2010-02-18 00:00:00', 'Erzsébet krt. 58.', 'Budapest', NULL, 'Hungary', 'H-1073', 21.86),
(97, 59, '2010-02-26 00:00:00', '3,Raj Bhavan Road', 'Bangalore', NULL, 'India', '560001', 1.99),
(98, 1, '2010-03-11 00:00:00', 'Av. Brigadeiro Faria Lima, 2170', 'São José dos Campos', 'SP', 'Brazil', '12227-000', 3.98),
(99, 3, '2010-03-11 00:00:00', '1498 rue Bélanger', 'Montréal', 'QC', 'Canada', 'H2G 1A7', 3.98),
(100, 5, '2010-03-12 00:00:00', 'Klanova 9/506', 'Prague', NULL, 'Czech Republic', '14700', 3.96),
(101, 9, '2010-03-13 00:00:00', 'Sønder Boulevard 51', 'Copenhagen', NULL, 'Denmark', '1720', 5.94),
(102, 15, '2010-03-16 00:00:00', '700 W Pender Street', 'Vancouver', 'BC', 'Canada', 'V6C 1G8', 9.91),
(103, 24, '2010-03-21 00:00:00', '162 E Superior Street', 'Chicago', 'IL', 'USA', '60611', 15.86),
(104, 38, '2010-03-29 00:00:00', 'Barbarossastraße 19', 'Berlin', NULL, 'Germany', '10779', 0.99),
(105, 39, '2010-04-11 00:00:00', '4, Rue Milton', 'Paris', NULL, 'France', '75009', 1.98),
(106, 41, '2010-04-11 00:00:00', '11, Place Bellecour', 'Lyon', NULL, 'France', '69002', 1.98),
(107, 43, '2010-04-12 00:00:00', '68, Rue Jouvence', 'Dijon', NULL, 'France', '21000', 3.96),
(108, 47, '2010-04-13 00:00:00', 'Via Degli Scipioni, 43', 'Rome', 'RM', 'Italy', '00192', 5.94),
(109, 53, '2010-04-16 00:00:00', '113 Lupus St', 'London', NULL, 'United Kingdom', 'SW1V 3EN', 8.91),
(110, 3, '2010-04-21 00:00:00', '1498 rue Bélanger', 'Montréal', 'QC', 'Canada', 'H2G 1A7', 13.86),
(111, 17, '2010-04-29 00:00:00', '1 Microsoft Way', 'Redmond', 'WA', 'USA', '98052-8300', 0.99),
(112, 18, '2010-05-12 00:00:00', '627 Broadway', 'New York', 'NY', 'USA', '10012-2612', 1.98),
(113, 20, '2010-05-12 00:00:00', '541 Del Medio Avenue', 'Mountain View', 'CA', 'USA', '94040-111', 1.98),
(114, 22, '2010-05-13 00:00:00', '120 S Orange Ave', 'Orlando', 'FL', 'USA', '32801', 3.96),
(115, 26, '2010-05-14 00:00:00', '2211 W Berry Street', 'Fort Worth', 'TX', 'USA', '76110', 5.94),
(116, 32, '2010-05-17 00:00:00', '696 Osborne Street', 'Winnipeg', 'MB', 'Canada', 'R3L 2B9', 8.91),
(117, 41, '2010-05-22 00:00:00', '11, Place Bellecour', 'Lyon', NULL, 'France', '69002', 13.86),
(118, 55, '2010-05-30 00:00:00', '421 Bourke Street', 'Sidney', 'NSW', 'Australia', '2010', 0.99),
(119, 56, '2010-06-12 00:00:00', '307 Macacha Güemes', 'Buenos Aires', NULL, 'Argentina', '1106', 1.98),
(120, 58, '2010-06-12 00:00:00', '12,Community Centre', 'Delhi', NULL, 'India', '110017', 1.98),
(121, 1, '2010-06-13 00:00:00', 'Av. Brigadeiro Faria Lima, 2170', 'São José dos Campos', 'SP', 'Brazil', '12227-000', 3.96),
(122, 5, '2010-06-14 00:00:00', 'Klanova 9/506', 'Prague', NULL, 'Czech Republic', '14700', 5.94),
(123, 11, '2010-06-17 00:00:00', 'Av. Paulista, 2022', 'São Paulo', 'SP', 'Brazil', '01310-200', 8.91),
(124, 20, '2010-06-22 00:00:00', '541 Del Medio Avenue', 'Mountain View', 'CA', 'USA', '94040-111', 13.86),
(125, 34, '2010-06-30 00:00:00', 'Rua da Assunção 53', 'Lisbon', NULL, 'Portugal', NULL, 0.99),
(126, 35, '2010-07-13 00:00:00', 'Rua dos Campeões Europeus de Viena, 4350', 'Porto', NULL, 'Portugal', NULL, 1.98),
(127, 37, '2010-07-13 00:00:00', 'Berger Straße 10', 'Frankfurt', NULL, 'Germany', '60316', 1.98),
(128, 39, '2010-07-14 00:00:00', '4, Rue Milton', 'Paris', NULL, 'France', '75009', 3.96),
(129, 43, '2010-07-15 00:00:00', '68, Rue Jouvence', 'Dijon', NULL, 'France', '21000', 5.94),