DROP TABLE IF EXISTS `fitosystemps_customer`;
CREATE TABLE `fitosystemps_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=1006 DEFAULT CHARSET=utf8;

INSERT INTO `fitosystemps_customer` VALUES
('1','1','1','0','3','1','1',NULL,NULL,NULL,'OPC PTS Not Delete','OPC PTS Not Delete','[email protected]','9c2c4f8b5b532317cccfbb6b1e6cc6b0','2018-10-04 13:03:34','0000-00-00','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','60','5b6cae8d9a9e72c6b454a9fd14ceb5c4',NULL,'0','0','1','2018-10-04 13:03:34','2019-11-19 14:58:19'),
('2','1','1','0','3','1','0',NULL,NULL,NULL,'giuseppe','vennditto','[email protected]','7861b2a4c904b58891f6b046e855df63','2021-01-09 13:53:23','0000-00-00','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','0d2f98aa02f557cd5d32359a50464746',NULL,'1','0','0','2018-10-04 14:42:08','2021-01-09 13:53:23'),
('3','1','1','0','3','1','0',NULL,NULL,NULL,'Deborah','Lenzi','[email protected]','444df1e4c7105efa74a9f7c24c2b28e1','2018-10-05 01:25:46','0000-00-00','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','9bc7ce9d8d8e5a2b4984721817a46808',NULL,'1','0','0','2018-10-05 07:25:46','2020-03-04 12:56:34'),
('4','1','1','0','3','1','0',NULL,NULL,NULL,'Vincenzo','Lagalante','[email protected]','5163327a77fa49bb61c1edafa93c343b','2020-10-18 13:58:57','0000-00-00','1','5.90.188.110','2020-10-18 14:02:03','0',NULL,'0.000000','0','0','ca0a5f79a0d0c1fc42358f8b8c9bf9ea',NULL,'1','0','0','2018-10-06 19:47:01','2020-10-18 14:02:38'),
('5','1','1','2','3','1','0',NULL,NULL,NULL,'Sara','Palermo','[email protected]','9d429172b72bc4b9770fd150a4efe089','2018-10-08 03:12:59','1994-01-14','1','93.47.228.244','2018-10-08 09:12:59','1',NULL,'0.000000','0','0','2e6db9f3fd191e750870e954953b0b30',NULL,'1','0','0','2018-10-08 09:12:59','2020-03-04 12:56:34'),
('6','1','1','0','3','1','0',NULL,NULL,NULL,'Maria','Di iorio','[email protected]','29595e40551d3a3c317cb42c742c4ea9','2018-10-08 06:44:49','0000-00-00','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','a627ab0292a3282a3900055bedcaabac',NULL,'1','0','0','2018-10-08 12:44:49','2020-03-04 12:56:33'),
('7','1','1','0','3','1','0',NULL,NULL,NULL,'Vito','Martone','[email protected]','6778a87e6e5c83e909e38ef38fa64b21','2018-12-13 13:51:25','0000-00-00','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','874ce10b5525cccefb11903fd0d235ae',NULL,'1','0','0','2018-10-09 23:54:24','2020-03-04 12:56:33'),
('8','1','1','0','3','1','0',NULL,NULL,NULL,'Ale','Rossi','[email protected]','e9561ee503655f5c8018eb4b5911ed31','2018-10-14 03:18:33','0000-00-00','0','87.27.22.252','2019-02-19 13:31:25','0',NULL,'0.000000','0','0','3100f6d1b213fc669ab5f93c90d20c66',NULL,'1','0','0','2018-10-14 09:18:33','2020-03-04 12:56:33'),