[Tanaka]

Database inter-branding.co.za 

inter-branding.co.za  SHOP
From our customer call centre based in Hermanus, Western Cape to our  distribution warehouses and branding facilities in all major cities across South Africa. Johannesburg to Durban down to Port Elizabeth through to Cape Town and back up to Bloemfontein we have the entire SA covered.

Link: inter-branding.co.za

Format: sql
Size: 165MB
date: 022-06-03
rows: 2086894 (not all useful)
Users: 1.4K


Content: name , email address, address, phone, hased password

Hidden Content

You must register or login to view this content.

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;

SAMPLE

INSERT INTO `ps_customer` VALUES
('1','1','1','1','3','1','0',NULL,NULL,NULL,'John','DOE','[email protected]','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','[email protected]','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','[email protected]','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','[email protected]','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','[email protected]','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','[email protected]','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','[email protected]','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','[email protected]','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'),
('11','1','1','1','3','1','0',NULL,NULL,NULL,'Reuben','Mein','[email protected]','5c004e409ad38b73c1873f6c9df332e0','2017-09-25 03:49:49','1985-06-27','1','105.227.112.104','2017-09-25 09:49:49','1',NULL,'0.000000','0','0','6e4933a58eca2f5a7168c51772df40b6',NULL,'1','0','0','2017-09-25 09:49:49','2017-09-25 09:49:49'),
('12','1','1','1','3','1','0',NULL,NULL,NULL,'Herman','Lambert','[email protected]','608652ef0a20217261c90de9496f4955','2017-09-25 08:32:01','0000-00-00','0',NULL,'0000-00-00


('12','30','0','4','0','0','0','My address',NULL,'Mein','Reuben','10 Bergsig Estate ','Bergsig street','7220','Hermanus',NULL,'875502529','0875502529',NULL,NULL,'2017-08-23 11:01:10','2017-08-23 11:01:10','1','0'),
('13','30','0','7','0','0','0','Delivery Address',NULL,'Ackermann','Rita','533 Rembrandt Avenue','Faerie Glen','0043','Pretoria',NULL,'012 991 7458','082 977 7242',NULL,NULL,'2017-09-21 12:05:54','2017-09-21 12:05:54','1','0'),
('14','30','0','8','0','0','0','Delivery Address',NULL,'Brummer','Kalyn','4 Silver Place, Eastway Centre','Cnr Lynwood and Boschkop Roads, Lynnwood East','0153','Wingate Park, Gauteng',NULL,'012 809 8923','071 688 5446',NULL,NULL,'2017-09-22 09:56:40','2017-09-22 09:56:40','1','0'),
('15','30','0','8','0','0','0','Billing Address','Kattleya Seamless','Brummer','Kalyn','98 Greenstone Ridge','Cnr Stoneridge Drive and Hereford Road','1609','Edenvale',NULL,'012 809 8923','071 688 5446',NULL,NULL,'2017-09-22 10:04:58','2017-09-22 10:04:58','1','0'),
('16','30','0','9','0','0','0','Delivery Address',NULL,'Magadla','Nanga','5 St. James Road','Southernwood','5201','East London',NULL,'043 743 9592','082 894 6133',NULL,NULL,'2017-09-22 15:16:43','2017-09-22 15:16:43','1','0'),
('17','30','0','10','0','0','0','My address','Future Tone Musiq','Mbambo','Njabulo','Ngunjini Reserve KWa-Dlangezwa',NULL,'3886','Empangeni',NULL,'0605599986','0605599986',NULL,NULL,'2017-09-24 13:39:51','2017-09-24 13:39:51','1','0'),
('18','30','0','11','0','0','0','Test Address',NULL,'Mein','Reuben','Test Test','Test Street','7220','Test City','Test Test 982','082 0404 774 ','082 0404 774',NULL,NULL,'2017-09-25 14:04:02','2017-09-25 14:04:02','1','0'),
('19','30','0','12','0','0','0','Billing Address',NULL,'Lambert','Herman','P. O. Box 106',NULL,'9190','Walvis Bay',NULL,'+264 64 274 305','+264 81 127 9255',NULL,NULL,'2017-09-25 14:36:10','2017-09-25 14:36:10','1','0'),

[Troubled]

Great share , thanks for adding it here