-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathlebakery.sql
155 lines (133 loc) · 8.16 KB
/
lebakery.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
insert into empleados (Email, Nombre, Apellido1, Apellido2) values
('[email protected]','Dafnée', 'Lacoste', 'Penas'),
('[email protected]', 'Gaïa', 'Cannam', 'Cicutto'),
('[email protected]', 'Angèle', 'Duncombe', 'McKinna'),
('[email protected]', 'Adèle', 'Draper', 'Kornes');
insert into empleados (Email, UserPassword) values
('[email protected]', '3bqOowtU7z'),
('[email protected]', 'kXOnd3dnSdL'),
('[email protected]', 'wdOgex7tF'),
('[email protected]', 'iFfw9sXfg9y'),
('[email protected]', 'jLMsQWA'),
('[email protected]', 'aGQu3IzC'),
('[email protected]', 'b0kEtD8l'),
('[email protected]', 'fH7HWCc4qB6'),
('[email protected]', 'bQ6F7eGKV'),
('[email protected]', 'KDtXLEsAbq'),
('[email protected]', 'SbnXE5xUo'),
('[email protected]', 'a6gUz4qOI'),
('[email protected]', 'BGheFQZP'),
('[email protected]', 'RisXNyImrhqU'),
('[email protected]', 'rokd40Jy'),
('[email protected]', 'ZAPvuKgH'),
('[email protected]', 'u0I98H2tgFno'),
('[email protected]', 'PQh9tzOg'),
('[email protected]', 'U30pG9K'),
('[email protected]', 'tdHUk2');
insert into clientes (Email, DNI, Nombre, Apellido1, Apellido2, Telefono, Direccion, CodigoPostal, Ciudad, PoliticaDePriv) values
('[email protected]', "65189837V", 'Noëlla', 'Sheldon', 'Lauritsen', '434583333', 'Canio n23', 27705, 'Durham', TRUE),
('[email protected]', "80016033E", 'Angélique', 'Wayne', 'Fasson', '238783991', 'Bellavista n25', 32083, 'Balice', TRUE),
('[email protected]', "05338968R", 'Loïs', 'Dulake', 'Mersh', '306922417', 'Inglaterra n34', 94242, 'Nueva Esperanza', TRUE),
('[email protected]', "75418262C", 'Björn', 'Feighney', 'Covotti', '926993642', 'Hernan Cortes n96', 44015, 'Qiting', TRUE),
('[email protected]', "98495126H", 'Björn', 'Logie', 'Ferraraccio', '608772985', 'Arana n32', 33189, 'Áthyra', TRUE),
('[email protected]', "81439849T", 'Åke', 'Gonin', 'Jubert', '3268333723', "Cadiz n46", 6811, 'Giporlos', TRUE),
('[email protected]', "95177999C", 'Anaïs', 'Blagdon', 'Quinney', '3092147958', 'Carretera 68', 33480, 'Ylöjärvi', TRUE),
('[email protected]', "92373302N", 'Maëlann', 'Clixby', 'Olliar', '1533379451', 'Domingo Beltran n12', 21325, 'Tučepi', TRUE),
('[email protected]', "05021722V", 'Annotée', 'Vaneschi', 'Devinn', '9947988942', 'Paraguary n46', 53374, 'Horní Jelení', TRUE),
('[email protected]', "89613164N", 'Aurélie', 'Burnhams', 'Gaule', '3105800184', 'Zumalakarregi Etorbidea n45', 1066, 'Taypano', TRUE),
('[email protected]', "73556181L", 'Mélodie', 'Wathen', 'Gobourn', '2145604640', 'Paraguay n41', 75062, 'Irving', TRUE),
('[email protected]', "98644666N", 'André', 'Spens', 'Betty', '2905488226', 'Rua Olmos n86', 94463, 'Buenavista', TRUE),
('[email protected]', "66608008P", 'Rachèle', 'Feechum', 'Georgievski', '1548349955', 'Benito Guinea n84', 38-324, 'Siedliska', TRUE),
('[email protected]', "91836336G", 'Anaé', 'Fairburne', 'Eves', '1949431898', 'La Fontanilla n20', 34432, 'Ostrowsko', TRUE),
('[email protected]', "47016860F", 'Kallisté', 'Deavin', 'Bome', '5373845119', 'Salamanca n13', 1275, 'Baculongan', TRUE),
('[email protected]', "53956522V", 'Vérane', 'Monini', 'Kiehl', '6321248790', 'Carril de la Fuente n32', 937814, 'Ishigaki', TRUE);
INSERT INTO pedidos (Subtotal, Descuento, Total) VALUES
(60.98, 5, ((60.98 * 0.20) + 60.98) - (60.98 * 0.05)),
(60.98, 5, ((60.98 * 0.20) + 60.98) - (60.98 * 0.05)),
(14.25, 0, ((14.25 * 0.20) + 14.25) - (14.25 * 0)),
(19.56, 0, ((19.56 * 0.20) + 19.56) - (19.56 * 0)),
(36.70, 10, ((36.70 * 0.20) + 36.70) - (36.70 * 0.10)),
(36.72, 10, ((36.72 * 0.20) + 36.72) - (36.72 * 0.10)),
(130.50, 22, ((130.50 * 0.20) + 130.50) - (130.50 * 0.22));
INSERT INTO clientes_productos VALUES
(1, 1, "La mejor tarta de red velvet. Vale su precio y mas", "2022-11-06"),
(1, 2, "Deiliciosos como todo lo de la carta", "2022-11-06"),
(1, 3, "Calidad-precio inmejorable", "2022-11-06"),
(3, 9, NULL, "2022-11-06"),
(5, 20, NULL, "2022-11-06"),
(5, 26, "Tan frescos como de costumbre", "2022-11-06"),
(7, 16, "Se nota la calidad de los alimentos", "2022-11-06"),
(7, 28, "Muy buena la calidad de los productos", "2022-11-06"),
(11, 18, "Gran postre asiático que recuerda a los originales", "2022-11-06"),
(11, 7, "Cremoso y fresco. Ideal para el verano", "2022-11-06"),
(14, 22, NULL, "2022-11-06");
--Cli Prod Com Fec
INSERT INTO carrito (IDProducto, IDPedido, Precioventa, Unidades) VALUES
(1, 2, 35, 1),
(2, 2, 22, 1),
(4, 2, 3.98, 1),
(9, 3, 4.75, 3),
(20, 4, 0.45, 20),
(26, 4, 1.32, 8),
(16, 5, 18.97, 1),
(28, 5, 5.7, 3),
(18, 6, 2.35, 8),
(7, 6, 4.48, 4),
(22, 7, 14.50, 9);
INSERT INTO productos (Nombre, PrecioDeCoste, Categoria, Stock, Imagen) VALUES
("Red Velvet", 35, "Tartas", 15, 'static/resources/img/upload/products/red_velvet.png'),
("Tarta Vianner", 22, "Tartas", 8, 'static/resources/img/upload/products/red_velvet.png'),
("Gelato", 7.59, "Helados", 35, 'static/resources/img/upload/products/red_velvet.png'),
("Tiramisu", 3.98, "Dulces", 20, 'static/resources/img/upload/products/red_velvet.png'),
("Panna Cotta", 3.29, "Dulces", 11, 'static/resources/img/upload/products/red_velvet.png'),
("Pavlola", 28.99, "Tartas", 5, 'static/resources/img/upload/products/red_velvet.png'),
("Crema de papaya", 4.48, "Cremosos", 9, 'static/resources/img/upload/products/red_velvet.png'),
("Buñuelos de viento", 0.98, "Dulces", 50, 'static/resources/img/upload/products/red_velvet.png'),
("Milhojas", 4.75, "Dulces", 23, 'static/resources/img/upload/products/red_velvet.png'),
("Crepe", 2.85, "Dulces", 12, 'static/resources/img/upload/products/red_velvet.png'),
("Mousse de fresa", 2.91, "Cremosos", 15, 'static/resources/img/upload/products/red_velvet.png'),
("Mousse de chocolate", 2.95, "Cremosos", 19, 'static/resources/img/upload/products/red_velvet.png'),
("Mousse de cholate blanco", 2.91, "Cremosos", 15, 'static/resources/img/upload/products/red_velvet.png'),
("Caballeros Pobres", 1.20, "Dulces", 8, 'static/resources/img/upload/products/red_velvet.png'),
("Alfajores", 1.75, "Dulces", 20, 'static/resources/img/upload/products/red_velvet.png'),
("Tarta Saint Honore", 18.97, "Tartas", 5, 'static/resources/img/upload/products/red_velvet.png'),
("Baklava", 2.45, "Dulces", 11, 'static/resources/img/upload/products/red_velvet.png'),
("Dragon Beard Candy", 2.35, "Dulces", 18, 'static/resources/img/upload/products/red_velvet.png'),
("Beijinhos", 3.20, "Dulces", 21, 'static/resources/img/upload/products/red_velvet.png'),
("Churros", 0.45, "Salados", 40, 'static/resources/img/upload/products/red_velvet.png'),
("Suspiro limeño", 5.90, "Cremosos", 6, 'static/resources/img/upload/products/red_velvet.png'),
("Crema catalana", 4.78, "Cremosos", 3, 'static/resources/img/upload/products/red_velvet.png'),
("Cheesecake", 14.50, "Tartas", 25, 'static/resources/img/upload/products/red_velvet.png'),
("Cheesecake 'Le Bakerys'", 14.50, "Tartas", 25, 'static/resources/img/upload/products/red_velvet.png'),
("Fondant au chocolat", 5.10, "Dulces", 9, 'static/resources/img/upload/products/red_velvet.png'),
("Macarons", 1.32, "Dulces", 15, 'static/resources/img/upload/products/red_velvet.png'),
("Tarta del Principe Regente", 19.98, "Dulces", 7, 'static/resources/img/upload/products/red_velvet.png'),
("Sandwich 'Le Bakerys'", 5.70, "Salados", 5, 'static/resources/img/upload/products/red_velvet.png'),
("Croissant", 1.45, "Dulces", 20),
("Croissant 'Le Bakerys'", 1.45, "Dulces", 20, 'static/resources/img/upload/products/red_velvet.png');
INSERT INTO pedidos_empleados VALUES
(1, 2, "2022-11-06"),
(2, 2, "2022-11-06"),
(3, 5, "2022-11-06"),
(4, 4, "2022-11-06"),
(5, 3, "2022-11-06"),
(6, 5, "2022-11-06"),
(7, 4, "2022-11-06"),
(8, 3, "2022-11-06");
-- IDPed IDEmp Fec
INSERT INTO pedidos_clientes_empleados VALUES
(1, 1, 2, "2022-11-06"),
(2, 3, 5, "2022-11-06"),
(3, 5, 4, "2022-11-06"),
(4, 7, 3, "2022-11-06"),
(5, 11, 4, "2022-11-06"),
(6, 14, 3, "2022-11-06");
-- IDPed IDCLi IDEmp Fech
INSERT INTO facturas VALUES
(1),
(2),
(3),
(4),
(5),
(6),
(7);