prueba.farmagranada.es
SQL DUMP
farmagra_tienda tables
farmagranada_prueba tables
SQL files ~1GB
Dump Data 08.2024
( fg_mail) unique e-mails ~300K
( fg_customer ) ~48K lines
and other info...
SQL DUMP
farmagra_tienda tables
farmagranada_prueba tables
SQL files ~1GB
Dump Data 08.2024
( fg_mail) unique e-mails ~300K
( fg_customer ) ~48K lines
and other info...
INSERT INTO
(333798, 'farmacia@farmagranada.com', 'payment', '[Farmagranada] Pago aceptado', 1, '2024-08-27 06:31:41'),
(333799, 'carmaynes@hotmail.com', 'order_conf', '[Farmagranada] Confirmación de pedido', 1, '2024-08-27 06:31:43'),
(333800, '1975vanessapereira@gmail.com', 'order_canceled', '[Farmagranada] Cancelado', 2, '2024-08-27 06:39:17'),
(333801, 'inesfmoliveira@gmail.com', 'order_canceled', '[Farmagranada] Cancelado', 2, '2024-08-27 06:43:21'),
(333802, 'juanmperez@farmagranada.com', 'productoutofstock', '[Farmagranada] Producto fuera de stock', 1, '2024-08-27 06:43:31'),
INSERT INTO
(45173, 1, 1, 0, 3, 1, 0, NULL, NULL, NULL, 'NГєria', 'Trujillo Miquel', 'trujillonuri@gmail.com', '2156295c61714ebf161e1b0691e7e84d', '2024-05-18 18:25:10', '0000-00-00', 0, NULL, '0000-00-00 00:00:00', 0, NULL, '0.000000', 0, 0, 'c0a257deacbf33ef8211b2b63e5481a8', NULL, 1, 0, 0, '2024-05-19 02:25:10', '2024-05-19 02:28:39', NULL, '0000-00-00 00:00:00'),
(45174, 1, 1, 0, 3, 1, 0, NULL, NULL, NULL, 'Ana', 'Moreno Herrero', 'anamorenoh@hotmail.co.uk', '536d9f192a5f1a4542d8a843f7674682', '2024-05-19 02:05:49', '0000-00-00', 1, NULL, '2024-05-19 10:05:49', 0, NULL, '0.000000', 0, 0, '0ce036264f9afd0373d464184cce6b54', NULL, 1, 0, 0, '2024-05-19 10:05:49', '2024-05-19 10:06:14', NULL, '0000-00-00 00:00:00'),
(45175, 1, 1, 0, 2, 1, 0, NULL, NULL, NULL, 'Paulo', 'Reis', 'olgamdfernandes@hotmail.com', 'a35507d327b474c911b03933d3babfd3', '2024-05-19 02:52:14', '0000-00-00', 1, NULL, '2024-05-19 10:52:14', 0, NULL, '0.000000', 0, 0, '542566d117a27243967c1ffcd06fbd8e', NULL, 1, 1, 0, '2024-05-19 10:52:15', '2024-05-19 11:03:19', NULL, '0000-00-00 00:00:00'),
fg_mail (id_mail, recipient, template, subject, id_lang, date_add) VALUES(333798, 'farmacia@farmagranada.com', 'payment', '[Farmagranada] Pago aceptado', 1, '2024-08-27 06:31:41'),
(333799, 'carmaynes@hotmail.com', 'order_conf', '[Farmagranada] Confirmación de pedido', 1, '2024-08-27 06:31:43'),
(333800, '1975vanessapereira@gmail.com', 'order_canceled', '[Farmagranada] Cancelado', 2, '2024-08-27 06:39:17'),
(333801, 'inesfmoliveira@gmail.com', 'order_canceled', '[Farmagranada] Cancelado', 2, '2024-08-27 06:43:21'),
(333802, 'juanmperez@farmagranada.com', 'productoutofstock', '[Farmagranada] Producto fuera de stock', 1, '2024-08-27 06:43:31'),
INSERT INTO
fg_customer (id_customer, id_shop_group, id_shop, id_gender, id_default_group, id_lang, id_risk, company, siret, ape, firstname, lastname, email, passwd, last_passwd_gen, birthday, newsletter, ip_registration_newsletter, newsletter_date_add, optin, website, outstanding_allow_amount, show_public_prices, max_payment_days, secure_key, note, active, is_guest, deleted, date_add, date_upd, reset_password_token, reset_password_validity) VALUES(45173, 1, 1, 0, 3, 1, 0, NULL, NULL, NULL, 'NГєria', 'Trujillo Miquel', 'trujillonuri@gmail.com', '2156295c61714ebf161e1b0691e7e84d', '2024-05-18 18:25:10', '0000-00-00', 0, NULL, '0000-00-00 00:00:00', 0, NULL, '0.000000', 0, 0, 'c0a257deacbf33ef8211b2b63e5481a8', NULL, 1, 0, 0, '2024-05-19 02:25:10', '2024-05-19 02:28:39', NULL, '0000-00-00 00:00:00'),
(45174, 1, 1, 0, 3, 1, 0, NULL, NULL, NULL, 'Ana', 'Moreno Herrero', 'anamorenoh@hotmail.co.uk', '536d9f192a5f1a4542d8a843f7674682', '2024-05-19 02:05:49', '0000-00-00', 1, NULL, '2024-05-19 10:05:49', 0, NULL, '0.000000', 0, 0, '0ce036264f9afd0373d464184cce6b54', NULL, 1, 0, 0, '2024-05-19 10:05:49', '2024-05-19 10:06:14', NULL, '0000-00-00 00:00:00'),
(45175, 1, 1, 0, 2, 1, 0, NULL, NULL, NULL, 'Paulo', 'Reis', 'olgamdfernandes@hotmail.com', 'a35507d327b474c911b03933d3babfd3', '2024-05-19 02:52:14', '0000-00-00', 1, NULL, '2024-05-19 10:52:14', 0, NULL, '0.000000', 0, 0, '542566d117a27243967c1ffcd06fbd8e', NULL, 1, 1, 0, '2024-05-19 10:52:15', '2024-05-19 11:03:19', NULL, '0000-00-00 00:00:00'),
