DROP TABLE IF EXISTS `mod659_customer`;
CREATE TABLE `mod659_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(255) DEFAULT NULL,
  `siret` varchar(14) DEFAULT NULL,
  `ape` varchar(5) DEFAULT NULL,
  `firstname` varchar(255) NOT NULL,
  `lastname` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `passwd` varchar(255) 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` mediumtext 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 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=1487 DEFAULT CHARSET=utf8mb4;

INSERT INTO `mod659_customer` VALUES
('5','1','1','1','3','1','0',NULL,NULL,NULL,'JEREMY','PEREZ','[email protected]','$2y$10$8OVKgNZ4rp6C9yBDSF4ijOAsIjljCYI46/m9nkbicsH9szEBPh826','2020-05-19 22:14:30','1987-06-17','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','c2b9370a8f941ad981a20dc80846e9ee',NULL,'1','0','0','2020-05-08 10:57:26','2021-01-29 22:40:55','1bca3023f326186863805e043d6244cd0909f362','2021-01-30 22:40:55'),
('6','1','1','1','3','1','0',NULL,NULL,NULL,'Yoann','Novo','[email protected]','$2y$10$Bkpq0BOqfQnQH1mUCw3yBOHhCAuU9A8e3MiV76hkn/UMhfKlErbYC','2020-06-25 21:34:34','1989-03-02','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','2a6c4ed8c2ac3a07588f55e5d43537e2','8J0062239925 4 : coque','1','0','0','2020-05-08 11:00:52','2020-06-25 21:34:34',NULL,'0000-00-00 00:00:00'),
('9','1','1','1','3','1','0',NULL,NULL,NULL,'guillaume','courtillet','[email protected]','$2y$10$fpgNUn.7Seh/BEJVD4ByJOAbWfskpfanAlP2sHsGJKO7C09ezf73i','2020-05-19 08:10:54','1982-05-08','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','86423aee2a66d44cc98a237bdee30791',NULL,'1','0','0','2020-05-19 14:10:54','2020-05-19 14:10:54',NULL,'0000-00-00 00:00:00'),
('10','1','1','1','3','1','0',NULL,NULL,NULL,'maxence','sappen','[email protected]','$2y$10$PxEb.FiMDBCoLUu9SiK7RuWkA6uF.u0b2IQN82UPSlMN7qd1DnfkS','2020-05-19 08:59:22','1086-05-09','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','fd1c03f26c3e7027cf09e7ecd37989cc',NULL,'1','0','0','2020-05-19 14:59:22','2020-05-19 17:37:28',NULL,'0000-00-00 00:00:00'),
('11','1','1','1','3','1','0',NULL,NULL,NULL,'Robert','Griffiths','[email protected]','$2y$10$2weOTnPIMhj6UJp1vhDqI.bzlGiT49C7rWi2ym7EjpK4cQiFR6CXG','2020-05-21 06:08:55','1988-08-08','0',NULL,'0000-00-00 00:00:00','1',NULL,'0.000000','0','0','2f19f3c2e231e8924a8f0f907f6291d6',NULL,'1','0','0','2020-05-21 12:08:55','2020-05-21 12:08:55',NULL,'0000-00-00 00:00:00'),
('12','1','1','1','3','1','0',NULL,NULL,NULL,'ROMAIN','ROY','[email protected]','$2y$10$AiKRsiUV3eMlmn6SPy1J6OwwkGDnpm4Tsd9WlRtsi5hC3CYcRUIIO','2020-05-21 11:05:11','1988-05-22','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','6b579f9ac559b03a5d6a30a3a88dfc1b',NULL,'1','0','0','2020-05-21 17:05:11','2020-05-21 17:05:11',NULL,'0000-00-00 00:00:00'),
('13','1','1','1','3','1','0',NULL,NULL,NULL,'kevin','bouillé','[email protected]','$2y$10$3DoIWPA0CW/c03qHgfNvTu/V3pvWxQvd85VDPV/MjxLSp9M40mVVy','2020-05-23 06:19:27','1990-02-02','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','f11206916a5255075df25f8d7da30d77','Guidon envoyé : XU701981516FR','1','0','0','2020-05-23 12:19:27','2020-05-25 18:46:29',NULL,'0000-00-00 00:00:00'),
('14','1','1','1','3','1','0',NULL,NULL,NULL,'lucas','woog','[email protected]','$2y$10$UUBHDlcK51Bs397LoEBe3u.Gui6g10vslsc8B0GM5AkX5A7ZozJmC','2020-05-26 06:45:43','1993-11-13','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','7fc6d94aaf3cbcca31cc128d251ed3c6',NULL,'1','0','0','2020-05-26 12:45:43','2020-05-26 12:45:43',NULL,'0000-00-00 00:00:00'),
('15','1','1','1','3','1','0',NULL,NULL,NULL,'Robin','Cornet','[email protected]','$2y$10$yCt99D4g4tlyh.6WcN8euugeUqkoyow.Lp8WHWxT85aTfIastA7KW','2020-06-01 12:02:53','1993-10-23','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','94366414827bbd044621759ff624109b',NULL,'1','0','0','2020-06-01 18:02:53','2020-06-01 18:02:53',NULL,'0000-00-00 00:00:00'),
('16','1','1','1','3','1','0',NULL,NULL,NULL,'Jonathan','Serneels','[email protected]','$2y$10$rqBprLpckkLASS2JNPXxreM7R9OOLsaPjiQxiSBhizohv5G01p5.q','2020-06-02 14:20:52','1984-03-24','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','4f8ce2decc78c10e7159bf42d2294d77',NULL,'1','1','0','2020-06-02 20:20:52','2020-06-06 20:51:46',NULL,'0000-00-00 00:00:00'),