Database Emotis.fr [Full Dump Shop] 35K Customer
| Format: sql Tables - 300 Link: Emotis.fr Users: 35k Size - 87mb Leaked db |
| 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, `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, INSERT INTO `ps_customer` VALUES ('1','1','1','1','3','1','0',NULL,NULL,NULL,'John','DOE','[email protected]','44ba5336dfb4b9e3f36cec797e5d9af9','2015-03-25 05:39:55','1970-01-15','1',NULL,'2013-12-13 08:19:15','1',NULL,'0.000000','0','0','6c6e0a19ef123b315299ad523f27118f',NULL,'1','0','0','2015-03-25 11:39:55','2015-03-25 11:39:55'), ('2','1','1','2','3','1','0',NULL,NULL,NULL,'Geraldine','MATTHEY','[email protected]','f6414d2acdfd26e5cd285a8d26c59044','2015-04-13 11:49:14','1967-06-17','1',NULL,'2019-11-28 11:38:50','0',NULL,'0.000000','0','0','fbaa5db3691a0c72cdd0da822dce0750',NULL,'1','0','0','2015-04-13 17:49:14','2019-11-28 11:38:50'), ('3','1','1','0','3','1','0',NULL,NULL,NULL,'Sylvain','Luong','[email protected]','44ba5336dfb4b9e3f36cec797e5d9af9','2015-04-27 06:22:05','0000-00-00','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','8915a90af53caa08a10901351f3bc9a2',NULL,'1','0','0','2015-04-27 12:22:05','2016-12-05 16:50:01'), ('4','1','1','1','3','2','0',NULL,NULL,NULL,'Markus','Müller','[email protected]','b6b3cb366cf90cea3494e9fdce08a4f1','2015-04-30 01:38:50','1963-05-12','1','217.133.58.125','2015-04-30 07:38:50','0',NULL,'0.000000','0','0','7e50c89a537d667e795f62c2ab75912c',NULL,'1','0','0','2015-04-30 07:38:50','2015-04-30 07:42:28'), ('5','1','1','2','3','1','0',NULL,NULL,NULL,'Patricia','Mamode','[email protected]','4527d29b99929e3eab2d5881a7500040','2015-05-11 07:17:14','1962-11-09','1','80.11.174.163','2015-05-11 13:17:14','1',NULL,'0.000000','0','0','86e54ac9cebe56999d27ec7e800a4198',NULL,'1','0','0','2015-05-11 13:17:14','2021-12-08 11:04:39'), ('6','1','1','2','3','1','0',NULL,NULL,NULL,'Edwige','ROBIN','[email protected]','6d244559b5f3626505585e1255bc0a34','2015-10-18 11:28:00','1982-06-09','1',NULL,'2019-11-28 11:38:59','1',NULL,'0.000000','0','0','22a1a97a010ea8ac9dc99bb3fb776a12',NULL,'1','0','0','2015-10-18 17:28:00','2021-12-08 11:04:46'), ('7','1','1','2','3','1','0',NULL,NULL,NULL,'Gaëlle','LEGLISE','[email protected]','aac653b437238222dd1206270a3d4e86','2015-11-23 06:10:32','1963-06-25','1','84.14.196.121','2015-11-23 12:10:32','1',NULL,'0.000000','0','0','e74b6f13f8b1e9757e455027efb06fd7',NULL,'1','0','0','2015-11-23 12:10:32','2015-11-23 12:10:32'), ('8','1','1','2','3','1','0',NULL,NULL,NULL,'Anja','FOURDIN','[email protected]','87fceae7e0146eacd7eb2522302129b9','2015-11-26 11:11:57','1969-07-16','1',NULL,'2015-11-26 17:13:07','0',NULL,'0.000000','0','0','335348fcc1e0d2e45aac7c260f4a7c7b',NULL,'1','0','0','2015-11-26 17:11:57','2015-11-26 17:13:07'), ('9','1','1','1','3','1','0',NULL,NULL,NULL,'Didier','Giraud','[email protected]','11fa7408a6cc5645a7b17d4ca2a1b107','2015-12-11 05:55:27','1959-12-26','1',NULL,'2019-11-28 11:39:03','0',NULL,'0.000000','0','0','210ccaaf70b3b877eba158f0f53a297e',NULL,'1','0','0','2015-12-11 11:55:27','2019-11-28 11:39:03'), ('10','1','1','2','3','1','0',NULL,NULL,NULL,'Nathalie','de la Kethulle','[email protected]','e4d1ee024f5d7de255b9f11c897d27b2','2015-12-11 15:31:54','1965-09-28','1','109.88.167.30','2015-12-11 21:31:54','0',NULL,'0.000000','0','0','8a79c7d6592a090d2398bc866439fbdc',NULL,'1','0','0','2015-12-11 21:31:54','2015-12-11 21:31:54'), ('11','1','1','2','3','1','0',NULL,NULL,NULL,'Renée','RIVAL','[email protected]','55991b1fb4d578bd04b7fc61be2bed15','2015-12-16 04:00:58','1942-05-24','1','109.213.46.29','2015-12-16 10:00:58','0',NULL,'0.000000','0','0','daadb8ecaa24cdcc5349c12669778e91',NULL,'1','0','0','2015-12-16 10:00:58','2015-12-16 10:00:58'), ('12','1','1','1','3','1','0',NULL,NULL,NULL,'Nicolas','bernard','[email protected]','390cc65d0d8924ae2b9a7343e22c265a','2015-12-18 08:04:22','1973-06-17','1',NULL,'2019-11-28 11:39:08','0',NULL,'0.000000','0','0','b23b12b07c06d211ef8a869a8e439e85',NULL,'1','0','0','2015-12-18 14:04:22','2019-11-28 11:39:08'), |