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 /* mariadb-5.3 */ 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 /* mariadb-5.3 */ 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 /* mariadb-5.3 */ NOT NULL,
  `date_upd` datetime /* mariadb-5.3 */ 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=13746 DEFAULT CHARSET=utf8;

INSERT INTO `ps_customer` VALUES
('1','1','1','1','3','1','0',NULL,NULL,NULL,'John','DOE','[email protected]','20816c8ed3f9ce96babdd0b50c3ce418','2015-12-08 01:22:37','1970-01-15','1',NULL,'2013-12-13 08:19:15','1',NULL,'0.000000','0','0','be3c4e72af6c64eca0c9ff6e9768cae3',NULL,'1','0','0','2015-12-08 07:22:37','2015-12-08 07:22:37'),
('2','1','1','1','3','1','0',NULL,NULL,NULL,'Кцыуавпкпупкупку','цкпкцпццупкцп','[email protected]','1bc16eb19097f33487ee17fc8455661e','2018-03-31 10:19:25','1971-06-13','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','edae85062e85feb4bce5ba93dbae655a',NULL,'1','0','0','2018-03-31 16:19:25','2018-03-31 16:19:25'),
('3','1','1','0','3','1','0',NULL,NULL,NULL,'Asd','dsa','[email protected]','215ccb81055c8e8c17d730aac6ce0187','2019-04-18 21:07:44','0000-00-00','1','81.171.58.120','2019-04-19 03:07:44','1',NULL,'0.000000','0','0','c7aa7ac3c1650917c09883c6738ca1d5',NULL,'1','0','0','2019-04-19 03:07:44','2019-04-19 03:07:44'),
('4','1','1','0','3','1','0',NULL,NULL,NULL,'Pretty Camille Waiting For You','www.xurl.es/ejkoo','[email protected]','a958910459b99426e153b13b3d567ddc','2019-04-19 11:23:20','0000-00-00','1','46.22.220.10','2019-04-19 17:23:20','1',NULL,'0.000000','0','0','0c1483870d880d631df24b27b0833051',NULL,'1','0','0','2019-04-19 17:23:20','2019-04-19 17:23:20'),
('5','1','1','0','3','1','0',NULL,NULL,NULL,'Hot Natalie Waiting For You','www.cutt.us/lAGOH','[email protected]','b68510b90dc27a0d6e063c42ea5ade05','2019-04-19 11:58:27','0000-00-00','1','46.22.220.10','2019-04-19 17:58:27','1',NULL,'0.000000','0','0','90672ec2e218ccd026bdd06f99946bf4',NULL,'1','0','0','2019-04-19 17:58:27','2019-04-19 17:58:27'),
('6','1','1','0','3','1','0',NULL,NULL,NULL,'Hot Susan Waiting For You','www.cutt.us/CGaxM','[email protected]','ddd8a094c4e6e7056329e5dbb9d6cac7','2019-04-19 12:45:55','0000-00-00','1','46.22.220.10','2019-04-19 18:45:55','1',NULL,'0.000000','0','0','8da8c2fd5b1ce4439ee5e07c6b722489',NULL,'1','0','0','2019-04-19 18:45:55','2019-04-19 18:45:55'),
('7','1','1','0','3','1','0',NULL,NULL,NULL,'Hot Michele Wants To Date','www.cutt.us/AUUwf','[email protected]','e4b759af47cbd48d8e52afce71acc19e','2019-04-19 14:03:38','0000-00-00','1','46.22.220.10','2019-04-19 20:03:38','1',NULL,'0.000000','0','0','9dcb441fb847f822b3889ba059914074',NULL,'1','0','0','2019-04-19 20:03:38','2019-04-19 20:03:38'),
('8','1','1','0','3','1','0',NULL,NULL,NULL,'Pretty Debbie Waiting For You','www.xurl.es/zapqz','[email protected]','39d27dd3664c9ab4751f81718dc710c5','2019-04-19 14:37:15','0000-00-00','1','46.22.220.10','2019-04-19 20:37:15','1',NULL,'0.000000','0','0','680a1ff5ec44d5645fd06d164550e75f',NULL,'1','0','0','2019-04-19 20:37:15','2019-04-19 20:37:15'),
('9','1','1','0','3','1','0',NULL,NULL,NULL,'Hot Cindy Waiting For You','www.cutt.us/MxwBj','[email protected]','d62ea2eee0773603f0213b37cb1a077a','2019-04-19 15:39:29','0000-00-00','1','46.22.220.10','2019-04-19 21:39:29','1',NULL,'0.000000','0','0','f00c1aeb86e74a641ba2aa9b3fbeaff4',NULL,'1','0','0','2019-04-19 21:39:29','2019-04-19 21:39:29'),
('10','1','1','0','3','1','0',NULL,NULL,NULL,'Hot Stephanie Wants To Date','www.cutt.us/qRqeQ','[email protected]','e52d4a52470b1f5810b710c2361f36f8','2019-04-19 17:00:06','0000-00-00','1','46.22.220.10','2019-04-19 23:00:06','1',NULL,'0.000000','0','0','31bbd08f0b580a550ef838b78e18aa63',NULL,'1','0','0','2019-04-19 23:00:06','2019-04-19 23:00:06'),
('11','1','1','0','3','1','0',NULL,NULL,NULL,'Beautiful Alexa Waiting For You','www.xurl.es/rxtyj','[email protected]','43509cd6bed230a5f4d6d468f6dd6eb3','2019-04-19 17:50:26','0000-00-00','1','46.22.220.10','2019-04-19 23:50:26','1',NULL,'0.000000','0','0','d73fb875330c81588c1d087f159574af',NULL,'1','0','0','2019-04-19 23:50:26','2019-04-19 23:50:26'),