Apr 11, 2024, 11:48 PM
Table: ps_customer, Row Count: 78015 Sample Data - ps_customer Spoiler
CREATE TABLE `ps_customer` (
`id_customer` int(10) unsigned NOT NULL AUTO_INCREMENT,
`id_shop_group` int(11) unsigned NOT NULL DEFAULT 1,
`id_shop` int(11) unsigned NOT NULL DEFAULT 1,
`id_gender` int(10) unsigned NOT NULL,
`id_default_group` int(10) unsigned NOT NULL DEFAULT 1,
`id_lang` int(10) unsigned DEFAULT NULL,
`id_risk` int(10) unsigned NOT NULL DEFAULT 1,
`company` varchar(64) DEFAULT NULL,
`siret` varchar(14) DEFAULT NULL,
`ape` varchar(5) DEFAULT NULL,
`firstname` varchar(32) NOT NULL,
`lastname` varchar(32) NOT NULL,
`email` varchar(128) NOT NULL,
`passwd` varchar(32) NOT NULL,
`last_passwd_gen` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
`birthday` date DEFAULT NULL,
`newsletter` tinyint(1) unsigned NOT NULL DEFAULT 0,
`ip_registration_newsletter` varchar(15) DEFAULT NULL,
`newsletter_date_add` datetime DEFAULT NULL,
`optin` tinyint(1) unsigned NOT NULL DEFAULT 0,
`website` varchar(128) DEFAULT NULL,
`outstanding_allow_amount` decimal(20,6) NOT NULL DEFAULT 0.000000,
`show_public_prices` tinyint(1) unsigned NOT NULL DEFAULT 0,
`max_payment_days` int(10) unsigned NOT NULL DEFAULT 60,
`secure_key` varchar(32) NOT NULL DEFAULT '-1',
`note` text DEFAULT NULL,
`active` tinyint(1) unsigned NOT NULL DEFAULT 0,
`is_guest` tinyint(1) NOT NULL DEFAULT 0,
`deleted` tinyint(1) NOT NULL DEFAULT 0,
`date_add` datetime NOT NULL,
`date_upd` datetime NOT NULL,
PRIMARY KEY (`id_customer`),
KEY `customer_email` (`email`),
KEY `customer_login` (`email`,`passwd`),
KEY `id_customer_passwd` (`id_customer`,`passwd`),
KEY `id_gender` (`id_gender`),
KEY `id_shop_group` (`id_shop_group`),
KEY `id_shop` (`id_shop`)
) ENGINE=InnoDB AUTO_INCREMENT=87888 DEFAULT CHARSET=utf8;
INSERT INTO `ps_customer` VALUES
('1','1','1','0','3','1','1',NULL,NULL,NULL,'CLIENTE DE CONTADO','','info@tamtampercusion.com','01d7bf511cc9c3ec353f872a597252fe','2014-10-01 15:48:02','0000-00-00','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','60','7c38779e2bd71ccbb2ea3483e71b90f6',NULL,'1','0','0','2014-10-01 17:48:02','2016-02-11 10:40:40'),
('2','1','1','0','3','1','1',NULL,NULL,NULL,'JUAN JOSÉ','SEVILLA CRISTO','thebestreasontoplaydrums@hotmail.com','c5acca27f2c252f6f34472e954a6397b','2014-10-01 15:48:02','0000-00-00','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','60','05c393b6473cbfe91584511beb417e0e',NULL,'1','0','0','2014-10-01 17:48:02','2021-11-15 14:53:30'),
('3','1','1','0','3','1','1',NULL,NULL,NULL,'Francisco Antonio','de León Rodríguez','kikko_de_leon@yahoo.es','ee9b41aa9fe30ce27cb1280178d2f789','2014-10-01 15:48:02','0000-00-00','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','60','8e50daf3fc3492d99013b5930afb6477',NULL,'1','0','0','2014-10-01 17:48:02','2021-11-15 14:53:30'),
('4','1','1','0','3','1','1',NULL,NULL,NULL,'Asociación Cultural','Lenguaje Musical Cantabile','rulasrules@Gmail.com','95c353e7ce0ab27f46baf8c20d281ff3','2016-12-06 14:39:09','0000-00-00','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','60','4aec29f0b17b4296daa20c598437b39f',NULL,'1','0','0','2014-10-01 17:48:03','2021-11-15 14:53:30'),
('5','1','1','0','3','1','1',NULL,NULL,NULL,'Sara','Moreno Jiménez','saramoreno1@telefonica.net','c5acca27f2c252f6f34472e954a6397b','2014-10-01 15:48:04','0000-00-00','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','60','659371017089996fbd05e5745aebec1a',NULL,'1','0','0','2014-10-01 17:48:04','2021-11-15 14:53:30'),
('6','1','1','0','3','1','1',NULL,NULL,NULL,'Richard','Mora','elmagnate123@yahoo.com','c5acca27f2c252f6f34472e954a6397b','2014-10-01 15:48:05','0000-00-00','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','60','17229ca4cddfda4dde64aafcd379576a',NULL,'1','0','0','2014-10-01 17:48:05','2021-11-16 10:00:31'),
('7','1','1','0','3','1','1',NULL,NULL,NULL,'Salvador','Esteve Verdú','salvalogos@yahoo.es','c5acca27f2c252f6f34472e954a6397b','2014-10-01 15:48:05','0000-00-00','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','60','76b994844b1c20c3e1527b7b372de618',NULL,'1','0','0','2014-10-01 17:48:05','2021-11-15 14:53:32'),
('8','1','1','0','3','1','1',NULL,NULL,NULL,'David','Menéndez Martínez','davidmenen@hotmail.com','c5acca27f2c252f6f34472e954a6397b','2014-10-01 15:48:06','0000-00-00','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','60','98dab6c1140a3a0cc166e8ed10ab67c1',NULL,'1','0','0','2014-10-01 17:48:06','2021-11-15 14:53:33'),
('9','1','1','0','3','1','1',NULL,NULL,NULL,'RAMÓN','GÓMEZ FERNÁNDEZ','ramongofer@hotmail.com','c5acca27f2c252f6f34472e954a6397b','2014-10-01 15:48:06','0000-00-00','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','60','9568b678ace75f47f27d4791584674a8',NULL,'1','0','0','2014-10-01 17:48:06','2021-11-15 14:53:32'),
('10','1','1','0','3','1','1',NULL,NULL,NULL,'Carlos','Lorente Díez','clorente_diez@hotmail.com','c5acca27f2c252f6f34472e954a6397b','2014-10-01 15:48:06','0000-00-00','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','60','0038acc03e61f7b677189669dd479d1c',NULL,'1','0','0','2014-10-01 17:48:06','2021-11-15 14:53:34'),
(' Sample Data - ps_employee Spoiler
CREATE TABLE `ps_employee` (
`id_employee` int(10) unsigned NOT NULL AUTO_INCREMENT,
`id_profile` int(10) unsigned NOT NULL,
`id_lang` int(10) unsigned NOT NULL DEFAULT 0,
`lastname` varchar(32) NOT NULL,
`firstname` varchar(32) NOT NULL,
`email` varchar(128) NOT NULL,
`passwd` varchar(32) NOT NULL,
`last_passwd_gen` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
`stats_date_from` date DEFAULT NULL,
`stats_date_to` date DEFAULT NULL,
`stats_compare_from` date DEFAULT NULL,
`stats_compare_to` date DEFAULT NULL,
`stats_compare_option` int(1) unsigned NOT NULL DEFAULT 1,
`preselect_date_range` varchar(32) DEFAULT NULL,
`bo_color` varchar(32) DEFAULT NULL,
`bo_theme` varchar(32) DEFAULT NULL,
`bo_css` varchar(64) DEFAULT NULL,
`default_tab` int(10) unsigned NOT NULL DEFAULT 0,
`bo_width` int(10) unsigned NOT NULL DEFAULT 0,
`bo_menu` tinyint(1) NOT NULL DEFAULT 1,
`active` tinyint(1) unsigned NOT NULL DEFAULT 0,
`optin` tinyint(1) unsigned NOT NULL DEFAULT 1,
`id_last_order` int(10) unsigned NOT NULL DEFAULT 0,
`id_last_customer_message` int(10) unsigned NOT NULL DEFAULT 0,
`id_last_customer` int(10) unsigned NOT NULL DEFAULT 0,
`last_connection_date` date DEFAULT '0000-00-00',
PRIMARY KEY (`id_employee`),
KEY `employee_login` (`email`,`passwd`),
KEY `id_employee_passwd` (`id_employee`,`passwd`),
KEY `id_profile` (`id_profile`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;
INSERT INTO `ps_employee` VALUES
('1','1','1','Dejavu','Admin','adminosc@dejavu.es','49eafcb5756b1281f28709f57c8ae116','2022-02-24 08:18:56','2019-01-01','2019-09-04','0000-00-00','0000-00-00','1','month',NULL,'default','admin-theme.css','1','0','1','1','0','34276','9289','70989','2022-02-24'),
('2','5','1','Manzanares','José','jose@tamtampercusion.com','8b0c0198509f77c75ad72f239d847941','2022-03-01 06:33:03','2021-01-01','2021-01-26','0000-00-00','0000-00-00','1',NULL,NULL,'default','admin-theme.css','1','0','1','1','1','55273','16830','80500','2022-03-01'),
('3','5','1','Dejavu','Pruebas','pruebas@dejavu.es','2cd5e8cbccf3a99dcef5a33334e2706d','2021-02-01 10:52:49','2016-06-08','2016-07-08','0000-00-00','0000-00-00','1',NULL,NULL,'default','admin-theme.css','1','0','1','0','1','62094','18658','83684','2021-02-01'),
('4','5','1','Donoso','Belén','belen@tamtampercusion.com','4f32be44fd2139a69d0f8292e51a1c00','2022-02-23 10:01:11','2016-09-04','2016-10-04','0000-00-00','0000-00-00','1',NULL,NULL,'default','admin-theme.css','1','0','1','1','1','55273','16830','80500','2022-02-23'),
('5','6','1','Manzanares','Víctor','Victor@tamtampercusion.com','32d9064855c5a837b07b6633c6526f8d','2019-06-04 11:45:47','2016-09-06','2016-10-06','0000-00-00','0000-00-00','1',NULL,NULL,'default','admin-theme.css','1','0','1','0','1','18634','4252','39767','2019-06-04'),
('6','6','1','García','Pablo','pablo@tamtampercusion.com','48714c73507b0d9b336678ffbecc179a','2016-10-06 08:22:20','2016-09-06','2016-10-06','0000-00-00','0000-00-00','1',NULL,NULL,'default','admin-theme.css','1','0','1','0','1','18634','4576','39767','2017-08-10'),
('7','6','1','Armelles','Pablo','pabloarmelles@tamtampercusion.com','2b187fb0f43e052f80d441375e3f7e36','2018-09-14 10:37:34','2016-09-06','2016-10-06','0000-00-00','0000-00-00','1',NULL,NULL,'default','admin-theme.css','1','0','1','0','1','29607','4252','39767','2019-01-04'),
('8','6','1','Mesa','Jorge','jorge@tamtampercusion.com','dd73f3624f95461ca0e77748dcfe0856','2016-10-06 08:23:57','2016-09-06','2016-10-06','0000-00-00','0000-00-00','1',NULL,NULL,'default','admin-theme.css','1','0','1','0','1','18634','4252','39767','2017-10-31'),
('9','6','1','Tam Tam','Miguel','javi@tamtampercusion.com','246548c79c866d84b8b59a4feb427451','2019-06-04 08:09:12','2016-10-15','2016-11-15','0000-00-00','0000-00-00','1',NULL,NULL,'default','admin-theme.css','1','0','1','0','1','42687','10985','74997','2019-06-04'),
('10','6','1','Tam Tam','Frank','frank@tamtampercusion.com','1faa91a05b0ac583c81956315d685d33','2016-11-15 02:03:20','2016-10-15','2016-11-15','0000-00-00','0000-00-00','1',NULL,NULL,'default','admin-theme.css','1','0','1','0','1','20197','4536','64443','0000-00-00'), Sample Data - ps_mail Spoiler
CREATE TABLE `ps_mail` (
`id_mail` int(11) unsigned NOT NULL AUTO_INCREMENT,
`recipient` varchar(126) NOT NULL,
`template` varchar(62) NOT NULL,
`subject` varchar(254) NOT NULL,
`id_lang` int(11) unsigned NOT NULL,
`date_add` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
PRIMARY KEY (`id_mail`),
KEY `recipient` (`recipient`(10))
) ENGINE=InnoDB AUTO_INCREMENT=393461 DEFAULT CHARSET=utf8;
('81','jose@tamtampercusion.com','password_query','[Tam Tam Percusión] Confirmación de contraseña','1','2016-11-04 06:29:16'),
('82','josetamtam@hotmail.com','password_query','[Tam Tam Percusión] Confirmación de contraseña','1','2016-11-04 06:31:01'),
('83','pruebas@dejavu.es','order_conf','[Tam Tam Percusión] Confirmación de pedido','1','2016-11-04 12:25:03'), Table Names + Row Count Spoiler
Table: ps_access, Row Count: 784
Table: ps_accessory, Row Count: 845
Table: ps_address, Row Count: 159672
Table: ps_address_format, Row Count: 244
Table: ps_advice, Row Count: 53
Table: ps_advice_lang, Row Count: 4
Table: ps_attachment, Row Count: 11
Table: ps_attachment_lang, Row Count: 108
Table: ps_attribute, Row Count: 180
Table: ps_attribute_group, Row Count: 11
Table: ps_attribute_group_lang, Row Count: 81
Table: ps_attribute_group_shop, Row Count: 11
Table: ps_attribute_impact, Row Count: 173
Table: ps_attribute_lang, Row Count: 1476
Table: ps_attribute_shop, Row Count: 180
Table: ps_badge, Row Count: 259
Table: ps_badge_lang, Row Count: 263
Table: ps_carrier, Row Count: 78
Table: ps_carrier_group, Row Count: 420
Table: ps_carrier_lang, Row Count: 612
Table: ps_carrier_shop, Row Count: 80
Table: ps_carrier_tax_rules_group_shop, Row Count: 76
Table: ps_carrier_zone, Row Count: 61
Table: ps_cart, Row Count: 2307
Table: ps_cart_cart_rule, Row Count: 2162
Table: ps_cart_options, Row Count: 45688
Table: ps_cart_product, Row Count: 246173
Table: ps_cart_rule, Row Count: 844
Table: ps_cart_rule_combination, Row Count: 429517
Table: ps_cart_rule_country, Row Count: 2
Table: ps_cart_rule_lang, Row Count: 7415
Table: ps_cart_rule_product_rule, Row Count: 137
Table: ps_cart_rule_product_rule_group, Row Count: 134
Table: ps_cart_rule_product_rule_value, Row Count: 65078
Table: ps_category, Row Count: 1374
Table: ps_category_group, Row Count: 5356
Table: ps_category_lang, Row Count: 12365
Table: ps_category_product, Row Count: 94919
Table: ps_category_product_bu_20200703, Row Count: 66161
Table: ps_category_product_bu_20200908, Row Count: 67980
Table: ps_category_shop, Row Count: 1374
Table: ps_cms, Row Count: 29
Table: ps_cms_category, Row Count: 2
Table: ps_cms_category_lang, Row Count: 18
Table: ps_cms_category_shop, Row Count: 2
Table: ps_cms_lang, Row Count: 15
Table: ps_cms_shop, Row Count: 29
Table: ps_condition, Row Count: 270
Table: ps_condition_advice, Row Count: 89
Table: ps_condition_badge, Row Count: 261
Table: ps_configuration, Row Count: 35182
Table: ps_configuration_kpi, Row Count: 35064
Table: ps_configuration_kpi_lang, Row Count: 8
Table: ps_configuration_lang, Row Count: 106
Table: ps_contact, Row Count: 2
Table: ps_contact_lang, Row Count: 12
Table: ps_contact_shop, Row Count: 2
Table: ps_country, Row Count: 244
Table: ps_country_lang, Row Count: 1836
Table: ps_country_shop, Row Count: 244
Table: ps_cronjobs, Row Count: 1
Table: ps_currency, Row Count: 1
Table: ps_currency_shop, Row Count: 1
Table: ps_customer, Row Count: 78015
Table: ps_customer_group, Row Count: 78104
Table: ps_customer_message, Row Count: 539
Table: ps_customer_thread, Row Count: 13970
Table: ps_customization, Row Count: 1216
Table: ps_customization_field, Row Count: 76
Table: ps_customization_field_lang, Row Count: 684
Table: ps_customized_data, Row Count: 11391
Table: ps_delivery, Row Count: 267
Table: ps_djv_calendar, Row Count: 2191
Table: ps_djv_manual_product_review, Row Count: 6
Table: ps_djv_manualreview, Row Count: 1
Table: ps_djv_poll, Row Count: 2
Table: ps_djv_poll_submission, Row Count: 1720
Table: ps_djv_productavailability, Row Count: 205
Table: ps_djv_productavailability2, Row Count: 183
Table: ps_djv_productavailability_bu_20201104, Row Count: 184
Table: ps_djv_productavailability_bu_20210121, Row Count: 183
Table: ps_djv_productavailability_bu_20210628, Row Count: 184
Table: ps_djv_productavailability_bu_20211115, Row Count: 185
Table: ps_djv_productavailability_bu_20220119, Row Count: 204
Table: ps_djv_productavailability_bu_20220131, Row Count: 205
Table: ps_djv_productform, Row Count: 1
Table: ps_djv_productform_submission, Row Count: 60
Table: ps_djv_productlists_list, Row Count: 47
Table: ps_djvappointment, Row Count: 17
Table: ps_djvenhancedreview, Row Count: 8228
Table: ps_djvenhancedreview_image, Row Count: 582
Table: ps_djvenhancedreview_sendedmails, Row Count: 31943
Table: ps_djvenhancedreview_shop, Row Count: 8228
Table: ps_djvgiftcard, Row Count: 36
Table: ps_djvhometabs, Row Count: 4
Table: ps_djvhometabs_lang, Row Count: 36
Table: ps_djvhometabs_product, Row Count: 21
Table: ps_djvlinksblock, Row Count: 221
Table: ps_djvlinksblock_image, Row Count: 212
Table: ps_djvnavigation_category, Row Count: 99
Table: ps_djvnavigation_filter, Row Count: 1
Table: ps_djvnavigation_filter_shop, Row Count: 1
Table: ps_djvnavigation_friendly_url, Row Count: 31659
Table: ps_djvnavigation_indexable_attribute_group, Row Count: 11
Table: ps_djvnavigation_indexable_attribute_group_lang_value, Row Count: 72
Table: ps_djvnavigation_indexable_attribute_lang_value, Row Count: 1404
Table: ps_djvnavigation_indexable_feature, Row Count: 8
Table: ps_djvnavigation_indexable_feature_lang_value, Row Count: 9
Table: ps_djvnavigation_price_index, Row Count: 23668
Table: ps_djvnavigation_search, Row Count: 43895
Table: ps_djvnewslettersegmentation, Row Count: 709
Table: ps_djvslider_slide, Row Count: 738
Table: ps_djvslider_slide_group, Row Count: 177
Table: ps_djvslider_slide_lang, Row Count: 6642
Table: ps_djvspecificpagetab, Row Count: 28
Table: ps_djvspecificpagetab_lang, Row Count: 253
Table: ps_djvspecificpagetab_product, Row Count: 162
Table: ps_djvthemeconfigurator, Row Count: 54
Table: ps_djvurldata, Row Count: 141
Table: ps_employee, Row Count: 20
Table: ps_employee_shop, Row Count: 20
Table: ps_feature, Row Count: 371
Table: ps_feature_lang, Row Count: 2229
Table: ps_feature_product, Row Count: 53614
Table: ps_feature_shop, Row Count: 371
Table: ps_feature_value, Row Count: 2706
Table: ps_feature_value_lang, Row Count: 16230
Table: ps_ganalytics, Row Count: 31625
Table: ps_gender, Row Count: 2
Table: ps_gender_lang, Row Count: 6
Table: ps_gmc_brands, Row Count: 222
Table: ps_gmc_categories, Row Count: 1344
Table: ps_gmc_taxonomy, Row Count: 5427
Table: ps_group, Row Count: 3
Table: ps_group_lang, Row Count: 9
Table: ps_group_shop, Row Count: 3
Table: ps_gshoppingflux, Row Count: 1311
Table: ps_gshoppingflux_lang, Row Count: 11609
Table: ps_gshoppingflux_lc, Row Count: 9
Table: ps_hook, Row Count: 213
Table: ps_hook_alias, Row Count: 88
Table: ps_hook_module, Row Count: 436
Table: ps_hook_module_exceptions, Row Count: 1
Table: ps_image, Row Count: 41409
Table: ps_image_lang, Row Count: 367302
Table: ps_image_shop, Row Count: 71792
Table: ps_image_type, Row Count: 10
Table: ps_lang, Row Count: 9
Table: ps_lang_shop, Row Count: 9
Table: ps_lgcookieslaw_lang, Row Count: 2
Table: ps_log, Row Count: 66791
Table: ps_loyalty, Row Count: 47538
Table: ps_loyalty_history, Row Count: 165154
Table: ps_loyalty_state, Row Count: 5
Table: ps_loyalty_state_lang, Row Count: 45
Table: ps_mail, Row Count: 393460
Table: ps_mailalert_customer_oos, Row Count: 2974
Table: ps_manufacturer, Row Count: 289
Table: ps_manufacturer_lang, Row Count: 2297
Table: ps_manufacturer_shop, Row Count: 289
Table: ps_mce_batch, Row Count: 1
Table: ps_mce_list, Row Count: 1
Table: ps_mce_sync, Row Count: 4
Table: ps_mce_sync_detail, Row Count: 94164
Table: ps_media, Row Count: 10290
Table: ps_media_product, Row Count: 10290
Table: ps_message, Row Count: 21887
Table: ps_meta, Row Count: 48
Table: ps_meta_lang, Row Count: 432
Table: ps_module, Row Count: 102
Table: ps_module_access, Row Count: 612
Table: ps_module_country, Row Count: 1422
Table: ps_module_currency, Row Count: 10
Table: ps_module_group, Row Count: 306
Table: ps_module_preference, Row Count: 19
Table: ps_module_shop, Row Count: 87
Table: ps_newsletter, Row Count: 3726
Table: ps_newsletter_mailchimp_failure, Row Count: 2865
Table: ps_oct8nehistory, Row Count: 2498
Table: ps_operating_system, Row Count: 7-
Download:
Buffer Overlord
Deploying Precision in Every Line.
PGP Fingerprint: C1F5 5935 4992 A77B 69E1 B626 7556 1F6B 453C B36F
https://pastebin.com/raw/6k1RJQie
Deploying Precision in Every Line.
PGP Fingerprint: C1F5 5935 4992 A77B 69E1 B626 7556 1F6B 453C B36F
https://pastebin.com/raw/6k1RJQie