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,
  `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',
  `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,
  `id_risk` int(10) unsigned NOT NULL DEFAULT '1',
  `company` varchar(64) DEFAULT NULL,
  `siret` varchar(14) DEFAULT NULL,
  `ape` varchar(5) DEFAULT NULL,
  `website` varchar(128) DEFAULT NULL,
  `outstanding_allow_amount` decimal(10,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',
  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_group_shop` (`id_shop_group`),
  KEY `id_shop` (`id_shop`,`date_add`)
) ENGINE=InnoDB AUTO_INCREMENT=2336 DEFAULT CHARSET=utf8;

INSERT INTO `ps_customer` VALUES
('1','1','1','0','1','2','Virginie','BEILLEVERT','[email protected]','370d5148e124d25f8e7175821f93cfc4','2017-01-31 10:55:10','0000-00-00','1',NULL,'2017-01-31 16:55:10','0','20babd3af2d78e15d70f15f71cef5477',NULL,'0','0','0','2017-01-31 16:55:10','2017-01-31 16:55:10','0',NULL,NULL,NULL,NULL,'0.000000','0','0'),
('2','1','1','0','1','2','Veronique','ESPOSITO','[email protected]','370d5148e124d25f8e7175821f93cfc4','2017-01-31 10:55:10','0000-00-00','1',NULL,'2017-01-31 16:55:10','0','715b000426df594a6c3b1846105ba5aa',NULL,'0','0','0','2017-01-31 16:55:10','2017-01-31 16:55:10','0',NULL,NULL,NULL,NULL,'0.000000','0','0'),
('3','1','1','0','1','2','Samir','HILALI','[email protected]','370d5148e124d25f8e7175821f93cfc4','2017-01-31 10:55:10','0000-00-00','1',NULL,'2017-01-31 16:55:10','0','eefdf08596e03901cc90f329c2b50d3f',NULL,'0','0','0','2017-01-31 16:55:10','2017-01-31 16:55:10','0',NULL,NULL,NULL,NULL,'0.000000','0','0'),
('4','1','1','0','1','2','Adeline','CASTA','[email protected]','370d5148e124d25f8e7175821f93cfc4','2017-01-31 10:55:10','0000-00-00','1',NULL,'2017-01-31 16:55:10','0','9b528ad0cbe00bcbfe38d51e6625ab48',NULL,'0','0','0','2017-01-31 16:55:10','2017-01-31 16:55:10','0',NULL,NULL,NULL,NULL,'0.000000','0','0'),
('5','1','1','1','1','2','Vianney','ROLLAND','[email protected]','133db533e9bd930423d026d037f9a5cb','2020-01-10 14:40:38','0000-00-00','0',NULL,'2017-01-31 16:55:10','0','52b8684faa21142a9a9b1a4d178f5bb5',NULL,'1','0','0','2017-01-31 16:55:10','2020-01-10 14:40:38','0',NULL,NULL,NULL,NULL,'0.000000','0','0'),
('6','1','1','0','1','2','Arnaud','ABRY','[email protected]','370d5148e124d25f8e7175821f93cfc4','2017-01-31 10:55:10','0000-00-00','1',NULL,'2017-01-31 16:55:10','0','2fbd97178bfd835e5dd643f6a87dc6c7',NULL,'0','0','0','2017-01-31 16:55:10','2017-01-31 16:55:14','0',NULL,NULL,NULL,NULL,'0.000000','0','0'),
('7','1','1','0','1','2','Steeven','ADAM','[email protected]','370d5148e124d25f8e7175821f93cfc4','2017-01-31 10:55:10','0000-00-00','1',NULL,'2017-01-31 16:55:10','0','f61049867cc3040b4ee744e27492eb21',NULL,'0','0','0','2017-01-31 16:55:10','2017-01-31 16:55:15','0',NULL,NULL,NULL,NULL,'0.000000','0','0'),
('8','1','1','0','1','2','Audrey','AILHAS','[email protected]','370d5148e124d25f8e7175821f93cfc4','2017-01-31 10:55:10','0000-00-00','1',NULL,'2017-01-31 16:55:10','0','35e2a31aabd78cb410f7698e64cae477',NULL,'0','0','0','2017-01-31 16:55:10','2017-01-31 16:55:10','0',NULL,NULL,NULL,NULL,'0.000000','0','0'),
('9','1','1','0','1','2','Raymond','ALARCOR','[email protected]','370d5148e124d25f8e7175821f93cfc4','2017-01-31 10:55:10','0000-00-00','1',NULL,'2017-01-31 16:55:10','0','a7e7f0418ef84263bcc1573ad03c2114',NULL,'0','0','0','2017-01-31 16:55:10','2017-01-31 16:55:12','0',NULL,NULL,NULL,NULL,'0.000000','0','0'),
('10','1','1','0','1','2','Sylvie','ALINE','[email protected]','370d5148e124d25f8e7175821f93cfc4','2017-01-31 10:55:10','0000-00-00','1',NULL,'2017-01-31 16:55:10','0','610a5f816f59bad800e322600d5fe0e1',NULL,'0','0','0','2017-01-31 16:55:10','2017-01-31 16:55:15','0',NULL,NULL,NULL,NULL,'0.000000','0','0'),
('11','1','1','0','1','2','Jack','ALLONNEAU','[email protected]','370d5148e124d25f8e7175821f93cfc4','2017-01-31 10:55:10','0000-00-00','1',NULL,'2017-01-31 16:55:10','0','0dc701068d74e13298ea7412772c4a5e',NULL,'0','0','0','2017-01-31 16:55:10','2017-01-31 16:55:10','0',NULL,NULL,NULL,NULL,'0.000000','0','0'),
('12','1','1','0','1','2','Maryse','ALPI','[email protected]','370d5148e124d25f8e7175821f93cfc4','2017-01-31 10:55:10','0000-00-00','1',NULL,'2017-01-31 16:55:10','0','351f1ebae3032fda56006601f50e5f6c',NULL,'0','0','0','2017-01-31 16:55:10','2017-01-31 16:55:10','0',NULL,NULL,NULL,NULL,'0.000000','0','0'),
('13','1','1','0','1','2','Aline','ALTMEYER','[email protected]','370d5148e124d25f8e7175821f93cfc4','2017-01-31 10:55:10','0000-00-00','1',NULL,'2017-01-31 16:55:10','0','ad19ac945d83ad01497eddd0f5447366',NULL,'0','0','0','2017-01-31 16:55:10','2017-01-31 16:55:10','0',NULL,NULL,NULL,NULL,'0.000000','0','0'),