Database Gplusdistribution.com [Full Dump - SHOP] 15k Sql © Chucky Credits

[Chucky]

Database Gplusdistribution.com [Full Dump - SHOP] 15k

Spoiler: Sample

DROP TABLE IF EXISTS `psgplus_customer`;
CREATE TABLE `psgplus_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 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,
  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=15151 DEFAULT CHARSET=utf8;

INSERT INTO `psgplus_customer` VALUES
('42','1','1','1','3','5','0',NULL,NULL,NULL,'Jérémy','Le Fellic','jeremy.test1@juliana.fr','3b46b9e73c7db0c431c207149c02a606','2014-01-15 13:34:04','0000-00-00','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','e7a5589e80a11b98be5760d6f969c846',NULL,'1','0','0','2014-01-15 14:34:04','2014-01-15 14:34:04'),
('43','1','1','1','3','5','0',NULL,NULL,NULL,'adrien','fuchs','fuchs.adrien11@gmail.com','9e9767c2136e92b538f347026fe82b94','2014-01-15 13:55:35','0000-00-00','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','1ed92b8e679387a91d447304e293cef4',NULL,'1','0','0','2014-01-15 14:55:35','2014-01-15 14:55:35'),
('44','1','1','1','3','5','0',NULL,NULL,NULL,'zaergztg','zef','test@testtesttest.fr','82a2d4350d602d20f79eaec883d8119b','2014-01-15 15:23:38','0000-00-00','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','5625fc79a60fd5f5f425cd0af9408208',NULL,'1','0','0','2014-01-15 16:23:38','2014-01-15 16:23:38'),
('45','1','1','1','3','5','0',NULL,NULL,NULL,'Philippe','MASSE','philippe.masse@freesbee.fr','87a505f408b88c45c1a64e0c9cd9c21b','2018-07-08 09:44:17','0000-00-00','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','24d8c6e31e36e65e0d78513f652d5d39',NULL,'1','0','0','2014-01-15 16:45:19','2018-07-08 11:44:17'),
('46','1','1','1','3','5','0',NULL,NULL,NULL,'Charles','Ouzilleau','agence.creadol@gmail.com','745cdb57aca18e99fdb8b4ffd8bc9a95','2018-04-08 13:09:41','0000-00-00','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','4b70ed847156c49d189543b4034fa563',NULL,'1','0','0','2014-01-15 19:11:20','2018-04-08 15:09:41'),
('47','1','1','2','3','5','0',NULL,NULL,NULL,'Claudine','TASSY','clocris29@orange.fr','af9c3a0105d1ae5f0e6216cb823b8163','2014-01-15 18:42:41','0000-00-00','1','2.10.98.200','2014-01-15 19:42:41','0',NULL,'0.000000','0','0','e8c11da2a66eb5e790a6828c7d018472',NULL,'1','0','0','2014-01-15 19:42:41','2014-01-15 19:42:41'),
('48','1','1','2','3','5','0','camping des cerisiers','75302179900014','5530z','nathalie','thimouy','josselincamping@hotmail.com','63dbd52eb2dbd2f47e96872c66d8eb9e','2014-01-15 18:56:00','0000-00-00','0',NULL,'0000-00-00 00:00:00','0','www.josselincamping.com','0.000000','0','0','710f1f1b9bf7c0887c5510dd42a150fa',NULL,'1','0','0','2014-01-15 19:56:00','2014-01-15 19:56:00'),
('49','1','1','1','3','5','0','sarl lavo-mag','51337832300010','961B','jean-louis','Gatti','lesbressanes@free.fr','40cc7b5c3596acb53ef933d86f3bb538','2020-05-23 16:05:55','0000-00-00','0',NULL,'0000-00-00 00:00:00','0','www.lesbressanes.com','0.000000','0','0','5a1fd56db9ff751b254adabd6a242c53',NULL,'1','0','0','2014-01-15 22:52:15','2020-05-23 16:05:55'),
('50','1','1','1','3','5','0','CLUB CULTUREL DES ECLAIREURS','43426228300014',NULL,'LIONEL','MARIN','cce.secretariat@free.fr','66a83767ec2f49c13ad25cb6c03cb7d2','2014-01-16 17:49:04','0000-00-00','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','d13a35b97d02b4ecb69e349f49f27a00',NULL,'1','0','0','2014-01-16 18:49:04','2014-01-16 18:49:04'),
('51','1','1','2','3','5','0','fontisson','38227941200011','5530Z','bosc','sophie','info@campingfontisson.com','5d350c7d1fb9bcaafd791be7f197761c','2014-01-16 21:38:37','0000-00-00','0',NULL,'0000-00-00 00:00:00','0','www.campingfontisson.com','0.000000','0','0','b1811b2be99bf56eb4809eeb5434da7f',NULL,'1','0','0','2014-01-16 22:38:37','2014-01-16 22:38:37'),
('52','1','1','2','3','5','0','SARL CORMETOUR','49692036400015','5530Z','Anita ','DECOMBLE','info@campingdesnacres.fr','4dc28f9d564c0e330b223f3ed8dc002d','2017-01-13 13:19:30','0000-00-00','0',NULL,'0000-00-00 00:00:00','0','www.campingdesnacres.fr','0.000000','0','0','b0c2798c6aca29739b141304ff0b0c29',NULL,'1','0','0','2014-01-17 10:09:52','2017-01-13 14:19:30'),
('53','1','1','2','3','5','0','DIHO','79145806000013','5510Z','Laetitia','Diep','contact @fbi_gov @dwinhotel.com','4bec59edaf51f214b6f8c1564c571e68','2014-01-17 11:32:36','0000-00-00','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','479dcdc12a73c33c457c22d4aa10fc2f',NULL,'1','0','0','2014-01-17 12:32:36','2014-01-17 12:32:36'),
('54','1','1','2','3','5','0','SARL LA ROQUETTE','75313218200027','5530Z','Aurélia','BOIRAL','campinglaroquette@orange.fr','f011752c151bb26083cafe746e5c9ad8','2014-01-17 12:21:31','0000-00-00','1','90.37.246.147','2014-01-17 13:21:31','0','www.camping-la-roquette.com','0.000000','0','0','dc1467f5f28f92e9e868ee932165e565',NULL,'1','0','0','2014-01-17 13:21:31','2014-01-17 13:21:31'),
('55','1','1','1','3','5','0','le flore habitat jeunes','78632691800012','5590Z','marc','manceau','direction@leflore.info','093f6754f75ba95ec90a0f6cc4d3ea00','2016-05-11 13:47:46','0000-00-00','0',NULL,'0000-00-00 00:00:00','0','http://flore-habitatjeunes.org/','0.000000','0','0','de628dc0965258a530c4104effade7d9',NULL,'1','0','0','2014-01-17 14:07:48','2016-05-11 09:47:46'),
('56','1','1','2','3','5','0',NULL,NULL,NULL,'Judith','Marsh','judimarsh@hotmail.co.uk','fbb20651962da4a9d8a98ce3398e2f85','2019-03-04 10:22:48','0000-00-00','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','b2b50db25470f67f6e244400d69104c0',NULL,'1','0','0','2014-01-17 18:44:14','2019-03-04 11:22:48'),

----------------------------------------------------------------------------
|- Format: sql
|- Tables - 220
|- Link: You must be logged in to see this link.
|- Users: 15K
|- Size - 71MB
----------------------------------------------------------------------------
-| Leaked db By Chucky |-
----------------------------------------------------------------------------