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(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` 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,
INSERT INTO `ps_customer` VALUES
('1','1','1','1','3','1','0',NULL,NULL,NULL,'Anonymous','Anonymous','anonymous@psgdpr.com','prestashop','2019-09-20 09:17:35','0000-00-00','0',NULL,'0000-00-00 00:00:00','1',NULL,'0.000000','0','0','822e59698fc460caedccf3d6560fef5f',NULL,'0','0','0','2019-09-20 15:17:35','2019-09-20 15:17:35',NULL,'0000-00-00 00:00:00'),
('2','1','1','1','3','1','0',NULL,NULL,NULL,'John','DOE','pub@prestashop.com','c46e8661e560b27ce2bb86a344e18341','2019-09-20 09:18:06','1970-01-15','1',NULL,'2013-12-13 08:19:15','1',NULL,'0.000000','0','0','e0ae02858184847fe83ae33a2d2d40f6',NULL,'1','0','0','2019-09-20 15:18:06','2019-09-20 15:18:06',NULL,'0000-00-00 00:00:00'),
('3','1','1','0','3','2','0',NULL,NULL,NULL,'Aneta','Macudzinska','superantenka@wp.pl','$2y$10$fMJdV1A5Sg387Ud3ZcEoQOSAqaCvS4Uk.CrFqhJcWl0kkBImTSMUS','2019-10-28 05:07:39','0000-00-00','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','7c7d33f0f46fe72a1ab307a5baa771e7',NULL,'1','0','0','2019-10-28 11:07:39','2019-10-28 11:07:39',NULL,'0000-00-00 00:00:00'),
('4','1','1','1','2','2','0',NULL,NULL,NULL,'Adam','Kowalski','kosinskigroup@gmail.com','$2y$10$miLy6GJ.IvAN/AzePb.Yg.KmMBRlkOSrqmOEE.IYGuL3WuvQ9Nlpe','2019-10-29 09:41:57','0000-00-00','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','de7e2367bbe168cebb65a82dc2ce6ae3',NULL,'1','1','0','2019-10-29 15:41:57','2019-11-05 12:57:32',NULL,'0000-00-00 00:00:00'),
('5','1','1','1','2','2','0',NULL,NULL,NULL,'Artur','Kosiński','kosinskigroup+12@gmail.com','$2y$10$ttjKGU.kSC3s8PdWVtj1Ju/pH4GXd60BDH7o5rQnsCp/CeFayDrFC','2019-11-05 07:18:09','0000-00-00','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','0f0393828f19ef2aeeb60d558e40021e',NULL,'1','1','0','2019-11-05 13:18:09','2019-11-07 13:51:15',NULL,'0000-00-00 00:00:00'),
('6','1','1','1','2','2','0',NULL,NULL,NULL,'Artur','Kosiński','kosinskigroup@gmail.com','$2y$10$/A8tNr3dXeRKAUOl8682buS/91HndQdQ7C8bNHVLL0oqeFd.P9tG6','2019-11-07 05:56:39','0000-00-00','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','2d05872622f23f79e02c6303e2556b5a',NULL,'1','1','0','2019-11-07 11:56:39','2019-11-07 11:56:39',NULL,'0000-00-00 00:00:00'),
('7','1','1','1','2','2','0',NULL,NULL,NULL,'Artur','Kosiński','kosinskigroup+12@gmail.com','$2y$10$zWIzgucJ5sP2Gzivp/c6tebfOjM3kui3P8TjiLVAtEvbsrhdcrbGm','2019-11-07 08:04:38','0000-00-00','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','28141a7d294d0e974b12d43ffddf5e5a',NULL,'1','1','0','2019-11-07 14:04:38','2019-11-07 14:04:38',NULL,'0000-00-00 00:00:00'),
('8','1','1','0','3','2','0',NULL,NULL,NULL,'Artur','Kosinski','kosinskigroup@gmail.com','$2y$10$d.3KQFzbiGFvSAui8rW3bOHppkV5UYNygTEvoxPB7YrddxlaYDXTO','2019-11-07 08:31:46','0000-00-00','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','3b331b14fcbfa98e9ec32a692ccdf912',NULL,'1','0','0','2019-11-07 14:31:46','2019-11-28 09:36:39',NULL,'0000-00-00 00:00:00'),
('9','1','1','2','2','2','0',NULL,NULL,NULL,'Valentina ','Gennarelli','raffaelec_92@hotmail.it','$2y$10$7llTAOeFIAohDpmgjcvpGOi8HOeK0booVJ0bpm9YId7gfwnsNSoF.','2020-04-03 02:19:21','0000-00-00','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','90490b8a14a463ea654d5ccfc72f0234',NULL,'1','1','0','2020-04-03 08:19:21','2020-04-03 08:44:25',NULL,'0000-00-00 00:00:00'),
('10','1','1','1','2','2','0',NULL,NULL,NULL,'Stefano','Cuna','kunakubain@yahoo.it','$2y$10$oMzCJNjbvJra.d0cnj7X6OoNiN/t93zuJ0JV1e.qCmmNcYLGz4VXW','2020-04-16 06:24:56','0000-00-00','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','c68894792602cb997b77d5ba4cba40f5',NULL,'1','1','0','2020-04-16 12:24:56','2020-04-16 12:24:56',NULL,'0000-00-00 00:00:00'),
