Forum Kurallarını Okumak İçin Lütfen Tıklayınız .

Database Inter-Branding.co.za [Full Dump] Shop Sql Hash © Chucky 

Sql Hash © Chucky Database Inter-Branding.co.za [Full Dump] Shop
Joined
Jun 7, 2021
Messages
4,299
Reaction score
55,973
#CR
110
Database inter-branding.co.za [Full Dump] SHOP

HTML:
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(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=2074 DEFAULT CHARSET=utf8;

INSERT INTO `ps_customer` VALUES
('1','1','1','1','3','1','0',NULL,NULL,NULL,'John','DOE','pub@prestashop.com','7d0f7fe2c87e46ad6279adbf1611185e','2017-05-24 08:02:48','1970-01-15','1',NULL,'2013-12-13 08:19:15','1',NULL,'0.000000','0','0','a04dc5b4f1d42da6494b90628a8326a0',NULL,'1','0','0','2017-05-24 14:02:48','2017-05-24 14:02:48'),
('2','1','1','0','3','1','0',NULL,NULL,NULL,'Jully','Test','jullytest123@gmail.com','bb8741d48e807acab85de4493add37b0','2017-07-28 21:05:25','0000-00-00','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','2dfdce65d1f3c52668dc60620c89c2a4',NULL,'1','0','0','2017-07-29 03:05:25','2017-09-29 03:01:27'),
('5','1','1','0','3','1','0',NULL,NULL,NULL,'Ahishillerma','AMoreWeiBDeeneST','quonahquee@bestmailonline.com','a83f741d2f2c89a86fbc86bff6b98a56','2017-09-07 12:37:51','1945-03-18','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','2e80f5112fc3147eae73a2b8a984c200',NULL,'1','0','0','2017-09-07 18:37:51','2017-09-07 18:37:51'),
('6','1','1','1','3','1','0',NULL,NULL,NULL,'Joseph','Moloantoa','moloantoa8.mj@gmail.com','a99aab09df95cb61b65b528aac4e3282','2017-09-20 10:19:10','1992-05-08','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','944cfe1eb67beb1c0717999358055048',NULL,'1','0','0','2017-09-20 16:19:10','2017-09-20 16:19:10'),
('7','1','1','2','3','1','0',NULL,NULL,NULL,'Rita','Ackermann','clubmightyblues@gmail.com','64e8cbab5ffa09c35febcf3a5e9d7daf','2017-09-21 06:00:12','0000-00-00','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','c3072eb858c77cca76e751a71a879680',NULL,'1','0','0','2017-09-21 12:00:12','2017-09-21 12:00:12'),
('8','1','1','2','3','1','0',NULL,NULL,NULL,'Kalyn','Brummer','kalynbrummer@yahoo.co.uk','48b7a0bb14e9f2ee3753795fd68c6d80','2017-10-09 07:42:09','0000-00-00','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','a2b22f688a74b69abfc5df768d68f123',NULL,'1','0','0','2017-09-22 09:37:22','2017-10-09 07:42:09'),
('9','1','1','2','3','1','0',NULL,NULL,NULL,'Nanga','Magadla','nanga@spf.co.za','394aa185276e664382fcd7a66593170b','2017-09-22 09:05:21','0000-00-00','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','5ac1aa83aad8fdd8f2dca4bc439eb599',NULL,'1','0','0','2017-09-22 15:05:21','2017-09-22 15:05:21'),
('10','1','1','1','3','1','0',NULL,NULL,NULL,'Njabulo Innocent','Mbambo','inombambo@gmail.com','c71e3ceccb8c1e61ada1e5b818a873e6','2017-09-24 07:34:48','1990-04-28','1','41.115.34.69','2017-09-24 13:34:48','1',NULL,'0.000000','0','0','4b5371c47c78d6a7c25cb377881e1a08',NULL,'1','0','0','2017-09-24 13:34:48','2017-09-24 13:34:48'),

----------------------------------------------------------------------------
|- Format: sql
|- Tables - 380
|- Link:
You do not have permission to view link Log in or register now.

|- Users: 1.4K
|- Size - 165MB


 
Last edited:

UPDATED LINKS TO DOWNLOAD THIS DATABASE.
SEE THE NEW URLS IN THE FIRST POST OF THIS TOPIC.
 
Database inter-branding.co.za [Full Dump] SHOP

HTML:
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(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=2074 DEFAULT CHARSET=utf8;

INSERT INTO `ps_customer` VALUES
('1','1','1','1','3','1','0',NULL,NULL,NULL,'John','DOE','pub@prestashop.com','7d0f7fe2c87e46ad6279adbf1611185e','2017-05-24 08:02:48','1970-01-15','1',NULL,'2013-12-13 08:19:15','1',NULL,'0.000000','0','0','a04dc5b4f1d42da6494b90628a8326a0',NULL,'1','0','0','2017-05-24 14:02:48','2017-05-24 14:02:48'),
('2','1','1','0','3','1','0',NULL,NULL,NULL,'Jully','Test','jullytest123@gmail.com','bb8741d48e807acab85de4493add37b0','2017-07-28 21:05:25','0000-00-00','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','2dfdce65d1f3c52668dc60620c89c2a4',NULL,'1','0','0','2017-07-29 03:05:25','2017-09-29 03:01:27'),
('5','1','1','0','3','1','0',NULL,NULL,NULL,'Ahishillerma','AMoreWeiBDeeneST','quonahquee@bestmailonline.com','a83f741d2f2c89a86fbc86bff6b98a56','2017-09-07 12:37:51','1945-03-18','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','2e80f5112fc3147eae73a2b8a984c200',NULL,'1','0','0','2017-09-07 18:37:51','2017-09-07 18:37:51'),
('6','1','1','1','3','1','0',NULL,NULL,NULL,'Joseph','Moloantoa','moloantoa8.mj@gmail.com','a99aab09df95cb61b65b528aac4e3282','2017-09-20 10:19:10','1992-05-08','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','944cfe1eb67beb1c0717999358055048',NULL,'1','0','0','2017-09-20 16:19:10','2017-09-20 16:19:10'),
('7','1','1','2','3','1','0',NULL,NULL,NULL,'Rita','Ackermann','clubmightyblues@gmail.com','64e8cbab5ffa09c35febcf3a5e9d7daf','2017-09-21 06:00:12','0000-00-00','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','c3072eb858c77cca76e751a71a879680',NULL,'1','0','0','2017-09-21 12:00:12','2017-09-21 12:00:12'),
('8','1','1','2','3','1','0',NULL,NULL,NULL,'Kalyn','Brummer','kalynbrummer@yahoo.co.uk','48b7a0bb14e9f2ee3753795fd68c6d80','2017-10-09 07:42:09','0000-00-00','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','a2b22f688a74b69abfc5df768d68f123',NULL,'1','0','0','2017-09-22 09:37:22','2017-10-09 07:42:09'),
('9','1','1','2','3','1','0',NULL,NULL,NULL,'Nanga','Magadla','nanga@spf.co.za','394aa185276e664382fcd7a66593170b','2017-09-22 09:05:21','0000-00-00','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','5ac1aa83aad8fdd8f2dca4bc439eb599',NULL,'1','0','0','2017-09-22 15:05:21','2017-09-22 15:05:21'),
('10','1','1','1','3','1','0',NULL,NULL,NULL,'Njabulo Innocent','Mbambo','inombambo@gmail.com','c71e3ceccb8c1e61ada1e5b818a873e6','2017-09-24 07:34:48','1990-04-28','1','41.115.34.69','2017-09-24 13:34:48','1',NULL,'0.000000','0','0','4b5371c47c78d6a7c25cb377881e1a08',NULL,'1','0','0','2017-09-24 13:34:48','2017-09-24 13:34:48'),

----------------------------------------------------------------------------
|- Format: sql
|- Tables - 380
|- Link:
You do not have permission to view link Log in or register now.

|- Users: 1.4K
|- Size - 165MB


*** Hidden text: cannot be quoted. ***
Thank you so much
 

Users who are viewing this thread

Home Register
Top Bottom