Database Viandas.shop [20K Customers] Sql © Chucky Credits

[Chucky]

Database Viandas.shop [20K Customers] SHOP

Spoiler: Sample

DROP TABLE IF EXISTS `ps_customer`;
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(255) NOT NULL,
  `lastname` varchar(255) NOT NULL,
  `email` varchar(128) NOT NULL,
  `passwd` varchar(60) NOT NULL,
  `last_passwd_gen` timestamp NOT NULL DEFAULT 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,
  `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,
  `reset_password_token` varchar(40) DEFAULT NULL,
  `reset_password_validity` datetime DEFAULT NULL,
  `navision_id` varchar(250) DEFAULT NULL,
  `related_employee` varchar(50) NOT NULL,

INSERT INTO `ps_customer` VALUES
('1','1','1','1','3','1','0',NULL,NULL,NULL,'John','DOE','pub@prestashop.com','e34d51e91597e344311fb35aeeede513','2018-11-12 06:39:27','1970-01-15','1',NULL,'2013-12-13 08:19:15','1',NULL,'0.000000','0','0','0b3130f3c4d201603a56163afa3f6910',NULL,'1','0','0','2018-11-12 12:39:27','2018-11-12 12:39:27',NULL,'0000-00-00 00:00:00','VCB0000001',''),
('3','1','1','1','3','1','0',NULL,NULL,NULL,'sdasdasd','sdasd','asdasdasd@dfsdfs.com','$2y$10$xJa.J5EVvPkatI4L5paxp.AJYfjCRtdyVewa6G/MXavFe18x6czBW','2018-11-21 03:14:03','0000-00-00','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','231d26b2e98f7eb353bdf35095088ed5',NULL,'1','0','0','2018-11-21 09:14:03','2018-11-21 09:14:03',NULL,'0000-00-00 00:00:00',NULL,''),
('4','1','1','0','3','1','0',NULL,NULL,NULL,'asdfas','dfasdf','asdfasdfasdf@visualweb.es','$2y$10$pSbic/Vb8EJX3AwCy1uJdOHa1f6cRPGeOCdEXkQokjbznTCMXTyc2','2018-12-04 09:06:04','0000-00-00','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','5349acf2b908792c08beba243cb17b24',NULL,'1','0','0','2018-12-04 15:06:04','2018-12-04 15:06:04',NULL,'0000-00-00 00:00:00',NULL,''),
('5','1','1','1','10','1','0',NULL,NULL,NULL,'Borja','Gonzalez','bgonzalez@visualweb.es','$2y$10$2TjEO5NOw6zOF4taD9MsbemyxIARsSEvlbBUTlENLpo3flFpprjse','2019-06-20 09:05:48','1986-01-10','0',NULL,'2018-12-13 11:25:08','0',NULL,'0.000000','0','0','f25ced667a6af7883606a81b0c01daa3',NULL,'1','0','0','2018-12-10 10:30:02','2019-06-20 09:05:48',NULL,'0000-00-00 00:00:00','VCB0000005',''),
('9','1','1','1','3','1','0',NULL,NULL,NULL,'Miguelito','del Ebro','miquel@visualweb.es','$2y$10$ntuUGG/.TwvneTguccsWZeJgoptNrXZrzHVPt53muxvgqczmNdjNC','2018-12-17 09:15:21','1990-11-12','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','b1caf9817f6bd998e902a50016bf6660',NULL,'1','0','0','2018-12-17 15:15:21','2021-02-02 12:51:38',NULL,'0000-00-00 00:00:00','VCW0006179',''),
('11','1','1','1','4','1','0',NULL,NULL,NULL,'Alexander','Paradiso','aparadiso@haciendazorita.com','$2y$10$h3hwgHeXxaxeUzVlCh0I7usF6w1O2Q2v5PjRnmKsRkKzb3Irvey.m','2019-01-21 09:48:23','1986-04-14','1',NULL,'2018-12-18 12:02:08','1',NULL,'0.000000','0','0','2978476512978f24155e5e88bb648783',NULL,'1','0','0','2018-12-18 12:02:08','2021-12-30 15:26:53','0e3a02952fadfe7b26a8efda73fe5adf7fe219be','2021-04-28 10:46:15','VCW0004279',''),
('12','1','1','1','4','10','0',NULL,NULL,NULL,'Zxczxc','Vzxcvzxcv','soporte@visualweb.es','$2y$10$9qzQfRzoWMa7sduoEzNWXOVeRIu72KlCrOvpG5EXXPX1Ilikxbcra','2022-04-21 15:15:35','0000-00-00','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','9a4c4b3ec98aa4291eac6e5316686f01',NULL,'1','0','0','2018-12-18 17:56:11','2022-06-08 21:20:58',NULL,'0000-00-00 00:00:00','VCB0000012',''),
('13','1','1','1','3','1','0',NULL,NULL,NULL,'Aitor','Ferreira','info@helloshopping.es','$2y$10$5g.C8rNc/xgAOgt6Vl/7QeEJ4RZXfed.TIvRKyM4NumK7A597/ux.','2018-12-18 12:25:32','1978-05-31','1',NULL,'2018-12-18 18:25:32','1',NULL,'0.000000','0','0','ce50b5def126c83f172dd2977b682485',NULL,'1','0','0','2018-12-18 18:25:32','2018-12-18 18:25:32',NULL,'0000-00-00 00:00:00',NULL,''),

----------------------------------------------------------------------------
|- Format: sql
|- Tables - 205
|- Link:

You do not have permission to view link Log in or register now.

|- Users: 20K
|- Size - 385MB
----------------------------------------------------------------------------
-| Leaked db By Chucky |-
----------------------------------------------------------------------------

To view the content, you need to Sign In or Register.

 

[ufologistiks]

Судя по содержанию сайта, база неплохая, надо срочно брать под свои нужды)))

 

[Yomi]

NICE WORK