Sql © Chucky Credits Database lilovino.com [SHOP] 17K Users
HTML:
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(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,
`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`,`date_add`)
) ENGINE=InnoDB AUTO_INCREMENT=17151 DEFAULT CHARSET=utf8;
INSERT INTO `ps_customer` VALUES
('1','1','1','1','3','1','0',NULL,NULL,NULL,'Matthieu','cauvin','cauvin.matthieu@orange.fr','10e88ba70b8d8b4c3b39a0d3e98d8f5e','2017-06-12 09:00:33','0000-00-00','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','4b31a22bb2de5fc0c6bc5241740a723c',NULL,'1','0','0','2017-06-12 15:00:33','2017-07-27 11:41:41'),
('3','1','1','1','3','1','0',NULL,NULL,NULL,'Sébastien','POUBELLE','poubells@gmail.com','1e08a53534ade6c0e5023f82de40f96e','2022-01-24 11:50:20','1978-04-10','0','109.190.82.76','2021-06-16 15:06:31','0',NULL,'0.000000','0','0','3f89a13a18608df0ce70e28efe6e0857',NULL,'0','0','0','2017-06-12 15:00:33','2022-01-24 11:52:28'),
('4','1','1','2','3','1','0',NULL,NULL,NULL,'Catherine','decamps','catherine.decamps@hotmail.com','11e6097ca841314e76de62b79b01c6e9','2017-06-12 09:00:33','0000-00-00','1',NULL,'2017-08-01 12:26:12','0',NULL,'0.000000','0','0','be5384495749b11896b76d481d49f315',NULL,'1','0','0','2017-06-12 15:00:33','2017-08-01 12:26:12'),
('5','1','1','1','3','1','0',NULL,NULL,NULL,'Sébastien','POUBELLE','sebastien@restaurantsdelille.com','28426844a8dd15365f1c86f73bf103bb','2017-06-12 09:00:33','0000-00-00','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','1ee9c88c3c5678942015ebfc88a8e866',NULL,'0','0','0','2017-06-12 15:00:33','2022-01-24 11:58:11'),
('6','1','1','1','3','1','0',NULL,NULL,NULL,'Mickael','DESCAMPS','lenviedunepause@live.fr','0333bd9dac9a79d84229ffd33d36f2c7','2017-06-12 09:00:33','0000-00-00','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','22985c0f8d512a46807b6e96f614323c',NULL,'0','0','0','2017-06-12 15:00:33','2017-06-12 15:00:33'),
('7','1','1','2','3','1','0',NULL,NULL,NULL,'Audrey','vandamme','audrex02@hotmail.fr','b3d22972aef8a7d2335e4861f1b80fc0','2017-06-12 09:00:33','0000-00-00','1',NULL,'2017-08-01 12:26:09','0',NULL,'0.000000','0','0','c7b04257bece76f353002d5be72dcc16',NULL,'1','0','0','2017-06-12 15:00:33','2017-08-01 12:26:09'),
('8','1','1','2','3','1','0',NULL,NULL,NULL,'Elodie','dekens','elodie59000lille@hotmail.fr','d3c9c3052ef1d0a607bc6323723697de','2017-06-12 09:00:33','0000-00-00','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','1def81f63cb125f0ee8424bfe3142225',NULL,'0','0','0','2017-06-12 15:00:33','2017-06-12 15:00:33'),
('9','1','1','1','3','1','0',NULL,NULL,NULL,'Alexandre','Parent','parentalex@gmail.com','bd45d5452e240319c32a5dfe167dd4d4','2017-06-12 09:00:33','0000-00-00','1',NULL,'2017-08-01 12:26:48','0',NULL,'0.000000','0','0','f0b167e6b460ce56585f60aad348e028',NULL,'1','0','0','2017-06-12 15:00:33','2017-08-01 12:26:48'),
('10','1','1','2','3','1','0',NULL,NULL,NULL,'Amandine','BARBIEUX','di-75@live.fr','4d017c7cedaab6459be681ae18c31efc','2017-06-12 09:00:33','0000-00-00','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','b3cfee505991dbf6a4e97ec121aae6bb',NULL,'0','0','0','2017-06-12 15:00:33','2017-06-12 15:00:33'),
('46','1','1','2','3','1','0',NULL,NULL,NULL,'natalie','watine','edwige.lelieur@hotmail.fr','421082a4c735ae0c42d2266c4ea096f4','2017-06-12 09:00:33','0000-00-00','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','855f241aa555370d35532f63c639f7e3',NULL,'1','0','0','2017-06-12 15:00:33','2017-06-12 15:00:33'),
('47','1','1','1','3','1','0',NULL,NULL,NULL,'gerard','le caloch','gerard.le-caloch@orange.fr','6268636c992bd161cb53e96770a3c2c9','2017-08-19 19:18:48','0000-00-00','1',NULL,'2017-08-01 12:26:28','0',NULL,'0.000000','0','0','d2fc23ea5881929d01f7016ac2c4d2f0',NULL,'1','0','0','2017-06-12 15:00:33','2017-08-19 19:18:48'),
('49','1','1','1','3','1','0',NULL,NULL,NULL,'Pierre','duchateau','pierreduchateau@wanadoo.fr','dcb5ba96bdc6687ebd874def9cdc2d28','2017-06-12 09:00:33','0000-00-00','1',NULL,'2017-08-01 12:26:51','0',NULL,'0.000000','0','0','6f31b40eaa4d852de9c4c96746205f2e',NULL,'1','0','0','2017-06-12 15:00:33','2017-08-01 12:26:51'),
('51','1','1','1','3','1','0',NULL,NULL,NULL,'Tony','LAMBRET','galibot77@aol.com','933d41c7b605bacb73ed338f4fb41d1c','2017-06-12 09:00:33','0000-00-00','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','ceda7b3807c0c8e6b8ed5d80760a1785',NULL,'1','0','0','2017-06-12 15:00:33','2017-06-12 15:00:33'),
('57','1','1','1','3','1','0',NULL,NULL,NULL,'Xavier','NOEBES','xavier.noebes@ieseg.fr','e6167433a5df188635d73759da16172d','2017-06-12 09:00:33','0000-00-00','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','1a3f88f2b15a96a2908db5328f0a64d4',NULL,'1','0','0','2017-06-12 15:00:33','2017-06-12 15:00:33'),
('58','1','1','1','3','1','0',NULL,NULL,NULL,'Christian','lempereur','lempereurfamily@orange.fr','c6fd5a7d1f74eadf1ea1df4e1a21ab55','2017-06-12 09:00:33','0000-00-00','1',NULL,'2017-08-01 12:26:40','0',NULL,'0.000000','0','0','d98228bdd35acb2fd8c6f3255c19acf7',NULL,'1','0','0','2017-06-12 15:00:33','2017-08-01 12:26:40'),
('59','1','1','1','3','1','0',NULL,NULL,NULL,'Stéphane','ROCHAIX','contact @fbi_gov @sr77.fr','230cf0361456836190b3410476e67270','2017-06-12 09:00:33','0000-00-00','0',NULL,'2017-08-04 13:49:06','0',NULL,'0.000000','0','0','620423507e26387363dac384d331902b',NULL,'1','0','0','2017-06-12 15:00:33','2017-08-04 13:49:06'),
----------------------------------------------------------------------------
|- Format - .SQL
|- Rows 100k+ / 17k users
|- Size - 44mb
|- Date - 16.08.2022
|- Login page -
You do not have permission to view link
Log in or register now.
|
-----------------
(c) Chucky |---------------------------------------------------------
-----------------