/* CUSTOM VARS START */
/* REAL_TABLE_NAME: `wpk9bt_wc_customer_lookup`; */
/* PRE_TABLE_NAME: `1741599259_wpk9bt_wc_customer_lookup`; */
/* CUSTOM VARS END */

CREATE TABLE IF NOT EXISTS `1741599259_wpk9bt_wc_customer_lookup` ( `customer_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint(20) unsigned DEFAULT NULL, `username` varchar(60) NOT NULL DEFAULT '', `first_name` varchar(255) NOT NULL, `last_name` varchar(255) NOT NULL, `email` varchar(100) DEFAULT NULL, `date_last_active` timestamp NULL DEFAULT NULL, `date_registered` timestamp NULL DEFAULT NULL, `country` char(2) NOT NULL DEFAULT '', `postcode` varchar(20) NOT NULL DEFAULT '', `city` varchar(100) NOT NULL DEFAULT '', `state` varchar(100) NOT NULL DEFAULT '', PRIMARY KEY (`customer_id`), UNIQUE KEY `user_id` (`user_id`), KEY `email` (`email`)) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
INSERT INTO `1741599259_wpk9bt_wc_customer_lookup` (`customer_id`, `user_id`, `username`, `first_name`, `last_name`, `email`, `date_last_active`, `date_registered`, `country`, `postcode`, `city`, `state`) VALUES (1,4,'Mah@raj@590246SL','Sunaina','Lutchmiah','marketing@maharajasspices.co.za','2025-03-07 06:52:16','2023-07-03 13:31:37','','','',''),(2,NULL,'','Jordache','Naicker','jordache.naicker01@gmail.com','2025-02-26 11:53:06',NULL,'ZA',4068,'Phoenix','KZN'),(3,NULL,'','Thando','Hlomuka','thandohlomuka8@gmail.com','2025-03-07 09:12:14',NULL,'ZA',1818,'Johannesburg','KZN'),(4,5,'Jordache','Jordache','Naicker','jordache.naicker@maharajasspices.co.za','2025-03-03 13:51:35','2025-03-03 13:44:39','ZA',4068,'Phoenix','KZN');
