QdVN76e3

1drop table if exists ordershopline;
2drop table if exists ordershop;
3drop table if exists client;
4drop table if exists address;
5drop table if exists city;
6drop table if exists promotion;
7drop table if exists instrument;
8drop table if exists equivalentcharacteristic;
9drop table if exists equivalentcategory;
10drop table if exists equivalentdescription;
11drop table if exists model;
12drop table if exists musicalcharacteristic;
13drop table if exists category;
14drop table if exists language;
15drop table if exists brand;
16drop table if exists country;
17drop table if exists description;
18
19create table country
20(
21	idcountry int not null auto_increment,
22    countryname varchar(50) not null,
23    constraint pk_country primary key (idcountry)
24);
25
26create table language
27(
28	idlanguage int not null auto_increment,
29	namelanguage varchar(50) not null unique,
30    constraint pk_language primary key (idlanguage)
31);
32
33create table musicalcharacteristic
34(
35	idtype int not null auto_increment, 
36    constraint pk_musicalcharacteristic primary key (idtype)
37);
38
39create table category
40(
41	idcategory int not null auto_increment, 
42    constraint pk_category primary key (idcategory)
43);
44
45create table description
46(
47	iddescription int not null auto_increment,
48	constraint pk_description primary key (iddescription)
49);
50
51create table equivalentcharacteristic
52(
53	idequivalentcharacteristic int not null auto_increment, 
54	idtype int not null, 
55	idlanguage int not null,
56	namecharacteristic varchar(50) not null,
57	constraint pk_equivalentcharacteristic primary key (idequivalentcharacteristic),
58	constraint fk_equivalentcharacteristictype foreign key(idtype) references musicalcharacteristic(idtype),
59	constraint fk_equivalentcharacteristiclanguage foreign key(idlanguage) references language(idlanguage)
60);
61
62create table equivalentcategory
63(
64	idequivalentcategory int not null auto_increment,
65	idcategory int not null,
66    idlanguage int not null,
67    namecategory varchar(50) not null,
68    constraint pk_equivalentcategory primary key (idequivalentcategory),
69    constraint fk_equivalentcategorycategory foreign key(idcategory) references category(idcategory),
70    constraint fk_equivalentcategorylanguage foreign key (idlanguage) references language(idlanguage)
71);
72
73create table brand
74(
75	idbrand int not null auto_increment,
76	namebrand varchar(50) not null unique,
77	idcountry int not null,
78	constraint pk_brand primary key (idbrand),
79	constraint fk_brandcountry foreign key (idcountry) references country(idcountry)
80);
81
82create table model
83(
84	idmodel int not null auto_increment,
85	namemodel varchar(50) not null, 
86	fretless boolean not null,
87	nbstrings int not null check(nbstrings > 0),
88	price float not null check(price > 0),
89	idbrand int not null,
90    idtype int not null, 
91    idcategory int not null, 
92	iddescription int not null,
93	constraint pk_model primary key (idmodel),
94	constraint fk_modelbrand foreign key (idbrand) references brand(idbrand),
95    constraint fk_instrumentcategory foreign key (idcategory) references category(idcategory),
96    constraint fk_instrumenttype foreign key (idtype) references musicalcharacteristic(idtype),
97	constraint fk_instrumentdescription foreign key (iddescription) references description(iddescription)
98);
99
100create table equivalentdescription
101(
102	idequivalentdescription int not null auto_increment,
103	iddescription int not null, 
104	idlanguage int not null,
105	description varchar(450) not null,
106	constraint pk_equivalentdescription primary key (idequivalentdescription),
107	constraint fk_equivalentdescriptiondescription foreign key(iddescription) references description(iddescription),
108	constraint fk_equivalentdescriptionlanguage foreign key(idlanguage) references language(idlanguage)
109);
110
111create table promotion
112(
113	idpromotion int auto_increment,
114	idbrand int not null,
115	datebeginning date not null,
116	dateend date not null,
117	percentagereduction float not null check(percentagereduction > 0),
118	constraint pk_promotion primary key(idPromotion),
119	constraint fk_promotionbrand foreign key(idbrand) references brand(idbrand),
120    check (datebeginning < dateend)
121);
122
123create table client
124(
125	idclient int not null auto_increment,
126	email varchar(50) not null unique,
127    password varchar(65) not null, 
128    firstname varchar(50) not null,
129    lastname varchar(50) not null,
130    telephonenumber varchar(25) not null,
131    mobilenumber varchar(25),
132	streetname varchar(25) not null,
133	streetnumber varchar(8) not null,
134	zipcode varchar(8) not null,
135    city varchar(50) not null,
136    idcountry int not null,
137    constraint pk_client primary key (idclient),
138    constraint fk_clientcountry foreign key(idcountry) references country(idcountry)
139);
140
141create table ordershop
142(
143	numberordershop int not null auto_increment,
144	dateordershop date not null,
145	ordershopsent boolean not null,
146	idclient int not null,
147	typepayment varchar(20) not null,
148	paymentdone boolean not null,
149	constraint pk_ordershop primary key (numberordershop),
150	constraint fk_ordershopclient foreign key(idclient) references client(idclient)
151);
152
153create table ordershopline
154(
155	idordershopline int not null auto_increment,
156	numberline int not null,
157	numberordershop int not null,
158	quantity int not null,
159	realprice float not null, 
160	percentagediscount float not null,
161	idModel int not null,
162	constraint pk_lineordershop primary key(idordershopline),
163	constraint fk_lineordershop foreign key(numberordershop) references ordershop(numberordershop),
164	constraint fk_lineordershopinstrument foreign key(idModel) references model(idModel), 
165	constraint unique_lineordershop unique key(numberline, numberordershop)
166);
167
168insert into language (namelanguage)
169values
170
171('fr'),
172('en');
173
174insert into country (countryname)
175values 
176
177('France'),
178('Etats Unis'),
179('Japon'),
180('Belgique');
181
182insert into musicalcharacteristic values (default),(default),(default);
183
184insert into description values (default),(default),(default),(default),(default),(default),(default),(default),(default),(default),(default),(default),(default),(default),(default),(default),(default),(default),(default),(default),(default),(default),(default),(default),(default),(default),(default),(default),(default),(default),(default),(default),(default),(default),(default),(default),(default),(default),(default),(default),(default),(default),(default),(default),(default),(default),(default),(default),(default),(default),(default),(default),(default),(default),(default),(default),(default),(default),(default),(default),(default),(default),(default),(default);
185
186
187insert into equivalentcharacteristic (idtype,idlanguage,namecharacteristic)
188values
189(1,1,'Électrique'),
190(2,1,'Acoustique'),
191(3,1,'Semi-acoustique'),
192(1,2,'Electric'),
193(2,2,'Acoustic'),
194(3,2,'Semi acoustic');
195
196insert into category values (default),(default),(default);
197
198insert into equivalentcategory (idcategory,idlanguage,namecategory)
199values
200(1,1,'guitare'),
201(2,1,'basse'),
202(3,1,'ukulélé'),
203(1,2,'guitar'),
204(2,2,'bass'),
205(3,2,'ukulele');
206
207insert into brand (namebrand,idcountry)
208values
209('Lâg',1),
210('Stagg',4),
211('Yamaha',3),
212('BC Rich',2),
213('Fender',2),
214('Paul Reed Smith',2),
215('Schecter',2),
216('Ibanez',3),
217('Gibson',2);
218
219insert into model (namemodel,fretless,nbstrings,price,idbrand,idCategory,idType,iddescription)
220values
221('Arkane 201',false,6,259,1,1,1, 1),
222('Arkane 100',false,6,329,1,1,1, 2),
223('Arkane 3000',false,7,2699,1,1,1, 3),
224('Arkane 200',false,6,599,1,1,1, 4),
225('Arkane 66',false,6,199,1,1,1, 5),
226
227('Jazz gt black',false,6,352,2,1,1, 6),
228
229('Revstar',false,6,999,3,1,1, 7),
230('Pacifica',false,6,279,3,1,1, 8),
231('SA2200',false,6,1899,3,1,1, 9),
232('PA 311',false,6,349,3,1,1, 10),
233('RGX220',false,6,399,3,1,1, 11),
234
235('Mockingbird x',false,6,291,4,1,1, 12),
236('Pro x custom',false,6,973,4,1,1, 13),
237('Warlock',false,6,339,4,1,1, 14),
238('Warbeast',false,6,599,4,1,1, 15),
239
240('Modern',false,6,498,5,1,1, 16),
241('FSR Classic',false,6,599,5,1,1, 17),
242('Stratocaster',false,6,598,5,1,1, 18),
243('Standard',false,6,626,5,1,1, 19),
244('American Elite',false,6,1849,5,1,1, 20),
245('American Special',false,6,999,5,1,1, 21),
246
247('SE Custom 22',false,6,569,6,1,1, 22),
248('SE Custom 24',false,6,995,6,1,1, 23),
249('CE 24',false,6,2490,6,1,1, 24),
250('SE Mark Holcomb',false,6,949,6,1,1, 25),
251('S2 Singlecut',false,6,1799,6,1,1, 26),
252('SE Zach Myers',false,6,588,6,1,1, 27),
253
254('Omen 8',false,8,569,7,1,1, 28),
255('Hellraiser',false,6,1299,7,1,1, 29),
256('Omen 7',false,7,529,7,1,1, 30),
257('Synyster',false,6,1145,7,1,1, 31),
258('Damien Platinum',false,6,799,7,1,1, 32),
259('Black Jack',false,6,1199,7,1,1, 33),
260
261('GRG170DX',false,6,259,8,1,1, 34),
262('Gio Mikro',false,6,199,8,1,1, 35),
263('PS120SP',false,6,999,8,1,1, 36),
264('RG421',false,6,329,8,1,1, 37),
265('JEJMR',false,6,499,8,1,1, 38),
266('GRG121DX',false,6,219,8,1,1, 39),
267
268('Les Paul Standard',false,6,1595,9,1,1, 40),
269('SG Special Heritage',false,6,555,9,1,1, 41),
270('Midtown Standard',false,6,888,9,1,1, 42),
271('Les Paul Less+',false,6,975,9,1,1, 43),
272('Les Paul Traditional',false,6,1295,9,1,1, 44),
273('Les Paul Deluxe',false,6,1222,9,1,1, 45),
274('SG Standard',false,6,999,9,1,1, 46),
275
276/*Ukulélés*/
277('Mino Aka Koa',false,4,239,5,3,1, 47),
278('Mino Aka',false,4,159,5,3,1, 48),
279('Fender ukulele',false,4,199,5,3,1, 49),
280
281/*Guitares Acoustiques*/
282
283('CD-60',false,6,129,5,1,2, 50),
284('CD60CE',false,6,244,5,1,2, 51),
285('FG 800 M',false,6,229,3,1,2, 52),
286('J-45 Standard',false,6,1910,9,1,2, 53),
287
288/*Guitares semi acoustiques*/
289('AS53-TF',false,6,299,8,1,3, 54),
290('AS73-TBC',false,6,399,8,1,3, 55),
291('SA2200',false,6,1899,3,1,3, 56),
292
293/*Basses éléctriques*/
294('AS Nate Mendel',false,4,1129,5,2,1, 57),
295('SR305EBL-WK',false,5,349,8,2,1, 58),
296('Deluxe Active Jazz Bass',false,4,1239,5,2,1, 59),
297('SR306E-WK',false,6,399,8,2,1, 60),
298
299/*Basses acoustiques*/
300('CB-100CE',false,4,322,5,2,2, 61),
301('AEB8E',false,4,429,8,2,2, 62),
302('Kingman Bass SCE',false,4,499,5,2,2, 63),
303('PCBE 12 MH OPN',false,4,239,8,2,2, 64);
304
305
306
307insert into equivalentdescription(iddescription,idlanguage,description)
308values
309(1,2,"The Arkane 200 is equipped with two humbuckers from EMG and has an irreproachable finish. The experienced musician won't be mistaken with the Floyd Rose vibrato, high precision machine heads, locking nut, many elements that will confirm his choice."),
310(1,1,"L'arkane 200 est équipée avec deux humbuckers EMG et a une finition irréprochable. Le musicien expérimenté ne sera pas trompé grâce au floyd rose, mécaniques très précises, beaucoup d'éléments qui confirmeront son choix."),
311(2,2,"The Arkane improves upon a familiar body style with increased fingerboard access and exceptional playability. The A100 features a carved top body, 24 fret Rosewood fingerboard, fixed bridge system, and 2 Duncan Designed humbuckers pickups. Available in high gloss finishes."),
312(2,1,"L'arkane se retrouve dans une famille de corps avec un excellent accès aux frettes et une jouabilité exceptionnelle. La A100 comprends un corps incurbé, 24 frettes, bridge fixé et deux humbuckers Duncan. Disponible en finition brillantes"),
313(3,2,"Very attractive guitar, with savage look and wonderful class, straight out from Lâg made in France. To become an incredible onstage weapon for any exceptionnal guitarist."),
314(3,1,"Terriblement féline, c’est une guitare sauvage avec un look extrême et une classe folle, qui bondit hors de l’atelier LÂG made in France. pour devenir sur scène, une arme absolue entre les mains d’un guitariste exceptionnel."),
315(4,2,"The Arkane 200 is equipped with two humbuckers from EMG and has an irreproachable finish. The experienced musician won't be mistaken with the Floyd Rose vibrato, high precision machine heads, locking nut, many elements that will confirm his choice."),
316(4,1,"Ses 2 Humbuckers EMG HZ et son vibrato Floyd Rose Special confèrent à l’Arkane 200 les qualités indispensables à cette guitare Metal, élégante comme une princesse."),
317(5,1,"Après plus de trois décennies passées à l’écoute d’innombrables guitaristes Hard et Metal, Michel Lâg a su créer un modèle d’entrée de gamme répondant à toutes ses exigences."),
318(5,2,"The Arkane improves upon a familiar body style with increased fingerboard access and exceptional playability. The A66 features a body with body confort, 24 fret Rosewood fingerboard, smooth tremolo system, and a versatile compliment of a single humbucker and 2 single coil pickups. All of these features add up to a highly capable electric guitar for beginners. Available in high gloss finishes."),
319
320(6,1,"Guitare jazz motif tigré. Semi acoustique équipée de 2 humbuckers avec capot doré. 22 frettes."),
321(6,2,"Jazz-typed guitar with tiger look. Semi acoustic equipped with 2 humbuckers and golden front. 22 frets."),
322
323(7,1,"Inspired by the stylish lines and effortless performance of the Café Racer bikes that colored the streets of 1960 London."),
324(7,2,"Inspirée par les lignes stylisées et les performances des cafés bikers qui ont coloré les rues de Londres en 1960"),
325(8,1,"One of the best electric guitar values for over a decade, Yamaha Pacifica guitars are well known for great tone and outstanding playability."),
326(8,2,"Une des meilleures guitares éléctriques depuis plus de 10 ans, Yamaha Pacifica sont des guitares bien connues pour un très bon son et une jouabilité hors du commun."),
327(9,1,"Excellente guitare pour débutants et confirmés."),
328(9,2,"Excellent guitar both for beginners and confirmed players."),
329(10,1,"Intemporelle en temps et tradition. Nos artistes savent ce secret depuis des années"),
330(10,2,"Boundless in time and tradition. Our artists have known this secret for years."),
331(11,1,"Le design double cutaway, un manche rapide et un son très lourd produit par 2 humbuckers fait de la RGX220 un exemple parfait de l'accessibilité pour une guitare éléctrique moderne."),
332(11,2,"The Double Cutaway Design, a fast neck and fat sounds from 2 Humbuckers make the RGX 220 a perfect example for a affordable modern electric guitar."),
333
334(12,1,"Créée en 1976, la vénérable MockingBird a été classée comme la “guitare la plus cool de tous les temps” par le magazine Guitar World en 2010."),
335(12,2,"Designed in ‘76, the venerable Mockingbird was ranked as the “coolest guitar of all time” by Guitar World Magazine in 2010."),
336(13,1,"La BC Rich Pro X Custom est une édition limitée qui hérite fièrement de la célèbre forme de corps de la Mockingbird."),
337(13,2,"The B.C. Rich Pro X Custom electric guitar is a special limited edition that bows to its rich heritage featuring the famous and iconic Mockingbird body style"),
338(14,1,"Les guitares Warlock comprennent une disposition 3 pièces, un design neck-through, et un bois très solide."),
339(14,2,"Warlock guitars feature three piece, solid neck through construction, solid wood."),
340(15,1,"Un seul contrôle de volume avec trois possibilités de réglage."),
341(15,2,"Single volume/tone controls with Three way switching."),
342(16,1,"Un design unique qui rappelle tout le savoir-faire de Fender."),
343(16,2,"A unique design that reminds of the knowledge provided by Fender"),
344(17,1,"Arborée d'une finition Lilac, la FSR Classic est hauntée par les fantômes des années 60."),
345(17,2,"Adorned with a classic Lilac finish, the Fender FSR Classic '60s Stratocaster is haunted by the ghost of the wild 60s. "),
346(18,1,"L'incontournable de tous les fans de rock'n'roll des années 50."),
347(18,2,"A must-have for any 50's rock'n'roll fan. "),
348(19,1,"La Stratocaster Standard offre le son légendaire de la Fender avec une finition classique."),
349(19,2,"The Standard Stratocaster offers the legendary Fender Sound with Classic styling."),
350(20,1,"Les American Elite sont destinées aux guitaristes qui demandent toujours plus à leurs instruments. "),
351(20,2,"There is a passion within players at every level that fuels a never-ending pursuit of creativity and expression. The Fender Elite Series was born out of that same passion."),
352(21,1,"Expériences le look, la sensation et le son d'un instrument aussi unique que fiable."),
353(21,2,"Experience the look, feel and tone of an instrument that's as unique as it is reliable."),
354(22,1,"La Custom 22 est un cheval d'assaut avec toutes les sonorités que vous pourriez espérer de votre PRS."),
355(22,2,"The Custom 22 is a classic workhorse with all the tones you’ve come to expect from your PRS."),
356(23,1,"La Custom 24 est équipée avec le Floyd Rose original, testé par le temps."),
357(23,2,"The Core “Floyd” Custom 24 is equipped with the time-tested Floyd Rose “Original” tremolo system."),
358(24,1,"Cet instrument légendaire était le premier modèle que Paul Reed Smith a apporté au public du tout premier salon NAMM"),
359(24,2,"This iconic instrument was the first model that Paul Reed Smith brought to the public at PRS Guitars’ first Winter NAMM"),
360(25,1,"Le guitariste Mark Holcomb a pu trouver son son léthal avec la PRS à son nom, et ses Seymour Duncan alpha et omega."),
361(25,2,"Guitarist Mark Holcomb helps achieve this full, lethal sound with his PRS guitars and signature Seymour Duncan Alpha and Omega pickups."),
362(26,1,"La Singlecut offre un son acoustique brillant et une vaste variété de sons avec l'esthétique et le corps d'une single-cutaway."),
363(26,2,"The Singlecut Hollowbody II offers brilliant acoustics and a vast array of tones with the sleek aesthetic of a single-cutaway body shape."),
364(27,1,"La Zach Myers a assé de fonctionnalités pour satisfaire les musiciens les plus exigeants."),
365(27,2,"The SE Zach Myers has enough features to satisfy even the most demanding musicians."),
366(28,1,"Facile et abordable possibilité dans le monde des guitares 8 cordes !"),
367(28,2,"Easy and affordable entry into the world of 8-String guitars !"),
368(29,1,"Design solide et un son incroyable"),
369(29,2,"Solid design and wonderful tone"),
370(30,1,"La dernière version des Omen. Corps Maha avec manche rapide"),
371(30,2,"Last version of Omen series. Maha body with fast neck."),
372(31,1,"Guitare signature du guitariste principal d'Avenged Sevenfold"),
373(31,2,"Signature guitar from Avenged Sevenfold's guitarist"),
374(32,1,"Guitare équipée de mécaniques Tune-o-matic."),
375(32,2,"Guitar equipped with Tune-o-matic mechanics."),
376(33,1,"Guitare typée metal pour un son envoûtant et puissant."),
377(33,2,"Metal-typed guitar for an immersive and powerful sound."),
378
379(34,1,"Ibanez RG de la serie Gio avec un rapport qualité/prix imbattable"),
380(34,2,"Ibanez Gio Series RG with unbeatable Price/Performance Ratio! "),
381(35,1,"Un autre bon exemple que l'excellence peut être abordable."),
382(35,2,"Another good example that excellence can be affordable."),
383(36,1,"Modèle signature de Paul Stanley"),
384(36,2,"Signature model from Paul Stanley"),
385(37,1,"Corps typé mahogany en 3 pièces, manche en érable Wizard III profilé rosewood avec 24 frettes Jumbo"),
386(37,2,"Mahogany body 3-piece maple neck Wizard III neck profile rosewood fretboard 24 jumbo frets"),
387(38,1,"Modèle signature de Steve Vai"),
388(38,2,"Steve Vai signature model"),
389(39,1,"Une guitare n'a pas besoin de coûter une fortune pour sonner bien."),
390(39,2,"A guitar doesn't have to cost a bundle to sound good. "),
391(40,1,"La Les Paul Standard est le pilier de Gibson, et représente le parfait équilibre entre le design traditionnel et les fonctionnalités nouvelles."),
392(40,2,"The Les Paul Standard is the flagship of Gibson's electric guitar collection and represents the perfect balance between traditional design and modern features. "),
393(41,1,"Introduite en 1960 comme la successeuse de la légendaire Les Paul, la SG est vite devenue une alternative populaire pour beaucoup de musiciens rock."),
394(41,2,"Originally introduced in the 60s as the successor to the legendary Les Paul, the SG quickly developed into a popular alternative for many rock musicians. "),
395(42,1,"Guitare semi-acoustique équipée de deux pickups Gibson Burstbucker"),
396(42,2,"Semi-Hollow guitar equipped with two Gibson Burstbucker pickups."),
397(43,1,"Même les fabriquants traditionnels tels que Gibson veulent essayer quelque chose de nouveau, et donner à des modèles établis des nouvelles fonctionnalités flambant neuves à des guitares."),
398(43,2,"Even a traditional manufacturer such as Gibson is willing to try something new, to give established models brand new features suitable for modern guitars."),
399(44,1,"Grâce à une énorme livraison que nous avons reçu récemment, nous avons la possibilité d'offrir la Les Paul traditional à un prix incroyablement bas !"),
400(44,2,"Due to a huge shipment we received recently, we are able to offer original Gibson USA Guitars at unbelievably low prices!"),
401(45,1,"La Les Paul Deluxe a vu le jour pour la première fois en 1968 et est devenue le visage du rock classique des années 70. Excellent équilibre entre le vintage et le moderne"),
402(45,2,"The Les Paul Deluxe first saw the light of day in 1968 and today is the face of 70s Classic Rock a great balance between vintage and modern. "),
403(46,1,"Gibson présente une de ses meilleures offres actuelles, probablement la meilleure SG jamais faite"),
404(46,2,"Gibson is presenting one its best offers yet, quite possibly the best value SG ever."),
405
406(47,1,"Branchez, et amusez vous ! Le magnifique ukulélé Mino Aka (sourire en hawaïen)"),
407(47,2,"Plug in and get happy! Fender's delightful concert ukulele, the Mino'Aka (Hawaiian for 'smile'),"),
408(48,1,"Ukulélé de concert."),
409(48,2,"Ukulele for the stage"),
410(49,1,"Ukulélé avec un corps identique à une fender"),
411(49,2,"Ukulele with a fender body style"),
412
413(50,1,"La CD-60 acoustique offre un bon son et reste abordable pour les débutants"),
414(50,2,"The CD-60 dreadnought acoustic model features a nice sounding guitar while being affordable for beginners"),
415(51,1,"Unique dans son genre, l'excellence de Fender"),
416(51,2,"A one-of-a-kind ! The excellence made in Fender"),
417(52,1,"Paul Reed Smith lui-même a joué sur cette guitare à Woodstock II"),
418(52,2,"Paul Reed Smith himself played this guitar at Woodstock II"),
419(53,1,"Prix peu abordable, mais unique en son genre. Son métallique et puissant"),
420(53,2,"Less abordable price, but this guitar is unique and has a metallic and powerful sound"),
421(54,1,"Milieu de gamme efficace et de longue durée"),
422(54,1,"Middle-end guitar with efficience against time"),
423(55,1,"Manche en érable et frettes Jumbo"),
424(55,2,"Features a maple neck and jumbo frets"),
425(56,1,"La SA2200 a toujourd été le pinnacle de la perfection en matière de semi-acoustiques yamaha"),
426(56,2,"The SA2200 has always been the pinnacle of perfection in Yamaha semi-hollow archtops."),
427(57,1,"La Fender Nate Mendel Precision est une réplique de la Precision Bass de 1971 jouée par les Foo Fighter"),
428(57,2,"The Fender Nate Mendel Precision Bass is a replica of the original ’71 Precision Bass played by the Foo Fighter"),
429(58,1,"Actuellement en grande quantité en stock !"),
430(58,2,"Right now available in stocks"),
431(59,1,"Très peu d'exemplaires restants, dépêchez-vous !"),
432(59,2,"Only a few ones left, hurry up !"),
433(60,1,"Convient aux bassistes avancés"),
434(60,2,"Complies for advanced bassists"),
435(61,1,"Partageant le même design de corps que les séries AEL, son son lourd enchantera tous les bassistes"),
436(61,2,"Sharing the same body style with the AEL series guitars, its fat tone will endear the AEB8E to any bass player. "),
437(62,1,"Son acoustique unique, pas d'ampli nécessaire pour l'entraînement"),
438(62,2,"Unique acoustic sound, no amp needed to practice"),
439(63,1,"Avec son manche rapide, ses attaches pour sangle et ses mécaniques, le bassiste éléctrique se sentira comme à la maison"),
440(63,2,"From its Jazz Bass guitar headstock, neck shape, strap button, and machine heads, it feels like home to the electric bassist"),
441(64,1,"3 ans de garantie Rock N Shop, satisfait ou remboursé"),
442(64,2,"3 Years RockNShop Warranty, money back guarantee");
443
444insert into client (email,password,firstname,lastname,telephonenumber,mobilenumber,streetName,streetNumber,zipcode,city,idcountry) 
445
446values 
447("antoine@hotmail.com","68122c8038645ff477408a677245d23bc223f93c6bebf2e1b8f434a7e64ffffb","Antoine","Delarge",'08741125','0446597815',"Route de Paris","8","3480","Grenoble",1),
448("bill@hotmail.com","4267a741ec83ff34697838074632e01604a65c7e280dbd04ad1e446c4298cfa0","Bill","Bumgardner",'088459635','0421478950',"Garden Street","10","1405A","New York",2),
449("dinos@hotmail.com","a03f1423e47194ef34ab0426ce18e221a73195849e646f248138c17b5bdced26","Dinos","Costakis",'047588963','0478965289',"Kyoto Street","10","468A","Kyoto",3),
450("hervé@hotmail.com","d3f084340a37d27dbb43d9acb512227276d909031538365e0726be8d191f486f","Hervé","Marquis",'08147593','0471589300',"Avenue Albert Premier","140","1070","Bruxelles",4),
451("chad@hotmail.com","f9332c4861d85b57ea6ca32e3beb2e844deb48c4f5c7d665da4445cbc7ac789c","Chad","Bailey",'087599687','0498521780',"Rue des jardins","39","4500","Huy",4);
452/*
453Pour chacun des mots de passe, la construction en clair est : passwordprenom de l'utilisateur.
454ex pour antoine, le mot de passe est : passwordantoine
455*/
456
457insert into promotion(idBrand,dateBeginning,dateEnd,percentageReduction)
458values
459(2,str_to_date('01,12,2016',"%d,%m,%Y"),str_to_date('07,12,2016',"%d,%m,%Y"),0.25),
460(3,str_to_date('07,12,2016',"%d,%m,%Y"),str_to_date('14,01,2017',"%d,%m,%Y"),0.10),
461(1,str_to_date('14,01,2017',"%d,%m,%Y"),str_to_date('21,01,2017',"%d,%m,%Y"),0.40),
462(1,str_to_date('01,02,2017',"%d,%m,%Y"),str_to_date('19,03,2017',"%d,%m,%Y"),0.40),
463(6,str_to_date('05,04,2017',"%d,%m,%Y"),str_to_date('13,06,2017',"%d,%m,%Y"),0.40),
464(7,str_to_date('05,05,2017',"%d,%m,%Y"),str_to_date('21,05,2017',"%d,%m,%Y"),0.40),
465(5,str_to_date('21,05,2017',"%d,%m,%Y"),str_to_date('28,05,2016',"%d,%m,%Y"),0.20);