Database Pmeurope.com [1K Customers] SHOP Sql © Chucky Credits

[Chucky]

Database Pmeurope.com [1K Customers] SHOP

Spoiler: Sample

DROP TABLE IF EXISTS `ps_customer`;
CREATE TABLE `ps_customer` (
  `id_customer` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_gender` int(10) unsigned NOT NULL,
  `id_default_group` int(10) unsigned NOT NULL DEFAULT '1',
  `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,
  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`)
) ENGINE=InnoDB AUTO_INCREMENT=938 DEFAULT CHARSET=utf8;

INSERT INTO `ps_customer` VALUES
('1','1','1','John','DOE','pub@prestashop.com','3ed64948715d846765a697787cc5362c','2011-10-16 13:35:14','1970-01-15','1',NULL,NULL,'1','47ce86627c1f3c792a80773c5d2deaf8',NULL,'1','0','0','2011-10-16 08:35:14','2011-10-16 08:35:14'),
('2','1','1','Gerrit','Nulens','gerrit.nulens@telenet.be','ec92a6de92dffe5820e2405f94b80d6d','2011-11-14 17:41:46','1972-02-16','1','84.193.34.28','2011-10-17 13:34:56','0','33c5be28ee9b12d2c9e926cc4659ad43',NULL,'1','0','0','2011-10-17 13:34:56','2011-11-14 11:41:46'),
('3','1','1','Bernard','Grodos','bgrodos@hotmail.com','5c89d4845eea639a35288dfd58108f6e','2011-10-21 15:03:19','1986-01-24','0',NULL,NULL,'0','6bf1876c2935488351583111496a362b',NULL,'1','0','0','2011-10-21 16:03:19','2011-10-21 16:03:19'),
('4','1','1','Leonardo','Sousa','hookperc@yahoo.com.br','61ee4bbefd052930ab924c320bdbd964','2012-01-22 03:16:46','1979-06-20','0',NULL,NULL,'0','50811e0fdb7b4c642cde94d49131cc36',NULL,'1','0','0','2011-10-25 04:44:27','2012-01-21 21:16:46'),
('5','1','1','Bouke ','Hofma','drumbouke@hotmail.com','5aab37025cdeb88b1f1700a77f2ec818','2011-10-28 10:46:10','1989-03-22','0',NULL,NULL,'0','8269e2ec98142070e7597706e2b94200',NULL,'1','0','0','2011-10-28 11:46:10','2011-10-28 11:46:10'),
('6','1','1','Mateus','Araujo','teusaraujo@live.com','79443bbf32f0ff0e91ef646be1cadd87','2011-10-30 12:38:54','1991-05-25','0',NULL,NULL,'0','c454c9edc9178230b19064bfa0db38a2',NULL,'1','0','0','2011-10-30 13:38:54','2011-10-30 13:38:54'),

----------------------------------------------------------------------------
|- Format: sql
|- Tables - 174
|- Link:

You do not have permission to view link Log in or register now.

|- Users: 1K
|- Size - 25MB
----------------------------------------------------------------------------
-| Leaked db By Chucky |-
----------------------------------------------------------------------------

 

[JessYc]

I hope u keep do like that We support u