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,
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=1959 DEFAULT CHARSET=utf8;
INSERT INTO `ps_customer` VALUES
('1','1','1','2','3','1','0',NULL,NULL,NULL,'Raquel','LГіpez ГЃlvarez','raquel@alfombraspaso.com','$2y$10$HxVPocK.hHyX4fHJxf4TgeV1c0GYUgR4a7E1QcnRRRunP98zoq9aS','2018-05-03 06:48:02','0000-00-00','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','31dee7db98625edfd164d0841d1f73ae',NULL,'1','0','0','2018-05-03 12:48:02','2018-05-03 12:48:02',NULL,'0000-00-00 00:00:00'),
('2','1','1','0','3','1','0',NULL,NULL,NULL,'Roman','Rodriguez','rodriguezgijon@gmail.com','$2y$10$nwFSaTmI43Z4aUScQnj6G.w18xE.7kXq54m2sxjn/NEFgETbDGSYK','2018-05-12 04:52:49','0000-00-00','1',NULL,'2018-05-12 10:52:49','1',NULL,'0.000000','0','0','b1bd8f023637f0c2374802aa43badbe9',NULL,'1','0','0','2018-05-12 10:52:49','2019-04-24 09:51:44','1aaa07bb4c17c086330c41afeed0bdf977e82cc7','2019-04-25 09:51:44'),
('3','1','1','2','2','1','0',NULL,NULL,NULL,'Maria Victoria','Carril Avello','victoriacarril@hotmail.com','$2y$10$dzjV4aJaHOh.yThUj11ONObYK95Qh30SHoXYkshMwJKSeJwVjjZxu','2018-05-14 16:28:58','0000-00-00','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','6308ded6531cb6377459e8b48f07f003',NULL,'1','1','0','2018-05-14 22:28:58','2018-05-14 22:28:58',NULL,'0000-00-00 00:00:00'),
('4','1','1','1','3','1','0',NULL,NULL,NULL,'David','Mon Bianco','dmon1990@gmail.com','$2y$10$xxIl9wj.IB10YNs25/2YYOjrKSbawAWdoDgrduWxJ.ITNSe0ZU.y2','2018-05-15 05:06:17','0000-00-00','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','9269177495c478020c02a65bf24920f0',NULL,'1','0','0','2018-05-15 11:06:17','2018-05-15 11:06:17',NULL,'0000-00-00 00:00:00'),
('6','1','1','1','3','1','0',NULL,NULL,NULL,'Antonia','Ruiz MartГnez ','peneloperuiz50@gmail.com','$2y$10$SR/y2t6ialZx4yYXuiGoMuPaI.J152BuCAsB87In6VlSqiEjWAON.','2018-05-17 13:13:47','0000-00-00','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','a9ac1493c4673590270fac1aa85931ce',NULL,'1','0','0','2018-05-17 19:13:47','2018-05-17 19:13:47',NULL,'0000-00-00 00:00:00'),
('7','1','1','2','2','1','0',NULL,NULL,NULL,'Montse','LГіpez MenГ©ndez','montse_lo_lugo@hotmail.es','$2y$10$gIAwiie/LfDprfMTVqY4sObBRWD3oRa/vCozVq.gHk4Bp05LR7wGa','2018-05-19 07:23:31','0000-00-00','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','aad2e61d369e347b35c296aa5f85cad5',NULL,'1','1','0','2018-05-19 13:23:31','2018-05-19 13:23:31',NULL,'0000-00-00 00:00:00'),
('8','1','1','2','2','1','0',NULL,NULL,NULL,'Iurdana','Gutierrez','iur88@hotmail.com','$2y$10$jJ96.DZEi6XEZ19CSm5MpOVZjkU1q5crsZaUK6x7F2vzB6qgCt8tG','2018-05-21 03:43:53','0000-00-00','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','1ae38d76994ae8a5bba8ca1eeef3dbb7',NULL,'1','1','0','2018-05-21 09:43:53','2018-05-21 09:43:53',NULL,'0000-00-00 00:00:00'),
('9','1','1','0','3','1','0',NULL,NULL,NULL,'WEB METRO ','.','INFO@METRO2.COM','$2y$10$PSLlqc.pzCUUlv4y/iVUKewdfYXKrb9gMK6JZK8I2Vaccqcaoi84K','2018-05-21 04:25:33','0000-00-00','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','665e0601b263011e42c9b447fea00015',NULL,'1','0','0','2018-05-21 10:25:33','2018-05-21 10:25:33',NULL,'0000-00-00 00:00:00'),
