-- MySQL dump 10.13 Distrib 8.0.25, for Linux (x86_64) -- -- Host: localhost Database: bpdadmin -- ------------------------------------------------------ -- Server version 8.0.25 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!50503 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Dumping data for table `charges` -- LOCK TABLES `charges` WRITE; /*!40000 ALTER TABLE `charges` DISABLE KEYS */; INSERT INTO `charges` VALUES (1,'07505ff8-939b-45f6-a8d5-abb80c4134ad','Afrihost','2021-07-08 09:17:35','2021-07-08 09:17:35',NULL); /*!40000 ALTER TABLE `charges` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `clients_dev` -- LOCK TABLES `clients_dev` WRITE; /*!40000 ALTER TABLE `clients_dev` DISABLE KEYS */; INSERT INTO `clients_dev` VALUES (1,'1c4f21a8-a765-431e-b823-437b62361b58','African Corporate Cleaning','699 Rubenstein Drive, Moreleta Park, Pretoria','Gavin Green',NULL,'+27834594743','admin@africancorporatecleaning.co.za','300','Monthly','July','2021-07-09 09:15:46','2021-07-09 09:41:44',NULL),(2,'1754905d-649c-40c1-971b-59f72efb38af','MBBC','409 Somhlolo Road, Mbabane, Eswatini','Bandile Marrime','Director','76658800','mbbcsd@gmail.com','700','Annually','January','2021-07-09 09:19:32','2021-07-09 09:19:32',NULL),(3,'f3652951-b3b9-4bbd-a8c6-c0abe071101c','EPDAWU','Mbabane, Eswatini','Zanele Khoza',NULL,'76554583','epdawu@gmail.com','800','Annually','April','2021-07-09 09:23:30','2021-07-09 09:23:30',NULL),(4,'f822d96b-3ea6-4a64-92b2-02c7a0854a6d','Luphohlo Commodities','Lenhle Complex, Sidwashini, Eswatini','Nathi Van Zuydam','Director','76173635','nathi@luphohlo.com','2000','Once','July','2021-07-09 09:26:35','2021-07-09 09:26:35',NULL),(5,'9cbb1212-5a16-413f-854b-87ca579f9e90','Eco-Rev','Mbabane, Eswatini','Dumisa Gwebu','Director','76049859','dumisa.gwebu@ecorevsd.com','100','Monthly','July','2021-07-09 09:28:41','2021-07-09 09:28:41',NULL),(6,'5e766424-50ec-42d9-be6f-c52f337871a6','Eco-Freight','Mbabane, Eswatini','Sicelo Dlamini','Director','76567626','info@ecofreight.org','100','Monthly','July','2021-07-09 09:31:37','2021-07-09 09:31:37',NULL),(7,'73c0f7c2-818e-4bef-9c11-98a7b37bc7ed','Eco-Freight','Mbabane, Eswatini','Sicelo Dlamini','Director','76567626','info@ecofreight.org','100','Monthly','July','2021-07-09 09:32:03','2021-07-09 09:41:58','2021-07-09 09:41:58'),(8,'d1abde8e-c361-4a50-947e-4ad2352bf255','Siyaphila Natural Medicines','Mbabane, Eswatini','Mandla Mdluli','Director','79779520','siyaphila@swazi.net','54','Monthly','July','2021-07-09 13:52:05','2021-07-09 13:52:05',NULL); /*!40000 ALTER TABLE `clients_dev` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `clients_fmk` -- LOCK TABLES `clients_fmk` WRITE; /*!40000 ALTER TABLE `clients_fmk` DISABLE KEYS */; INSERT INTO `clients_fmk` VALUES (1,'2235eac2-ceab-451f-9882-e9c190ba933b','Phumzile','Mhlanga','Judah','76950495',NULL,'Beverly Hills','Kidzville','5',NULL,NULL,NULL,NULL,'400','Monthly','August','2021-07-09 08:50:18','2021-07-09 08:50:18',NULL),(2,'86ac767f-051c-4f35-8195-daec348679cc','Karien','Swanepoel','Utah','76552873',NULL,'Beverly Hills','Evergreen','5','Steed Swanepoel','78061001','Wendy',NULL,'400','Monthly','August','2021-07-09 08:54:36','2021-07-09 08:54:36',NULL),(3,'feb4c6d1-4945-432b-a710-a050b6050c8c','Bahle','M','Ayathandwa','76782600',NULL,'Nkoyoyo','Evergreen','8','GrandMa','76089110','Nozipho Khumalo','76639128','600','Monthly','July','2021-07-09 08:58:33','2021-07-09 08:58:33',NULL),(4,'e5498798-0318-4504-9a38-201cc08cb6ef','Natasha','Dukes','Staff','76188011',NULL,'Evergreen','Town','10','Teacher','76964101',NULL,NULL,'800','Monthly','July','2021-07-09 09:01:31','2021-07-09 09:01:31',NULL); /*!40000 ALTER TABLE `clients_fmk` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `expenses` -- LOCK TABLES `expenses` WRITE; /*!40000 ALTER TABLE `expenses` DISABLE KEYS */; /*!40000 ALTER TABLE `expenses` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `failed_jobs` -- LOCK TABLES `failed_jobs` WRITE; /*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */; /*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `incomes` -- LOCK TABLES `incomes` WRITE; /*!40000 ALTER TABLE `incomes` DISABLE KEYS */; /*!40000 ALTER TABLE `incomes` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `migrations` -- LOCK TABLES `migrations` WRITE; /*!40000 ALTER TABLE `migrations` DISABLE KEYS */; INSERT INTO `migrations` VALUES (1,'2014_10_12_000000_create_users_table',1),(2,'2014_10_12_100000_create_password_resets_table',1),(3,'2019_08_19_000000_create_failed_jobs_table',1),(4,'2021_07_05_061500_create_payment_methods_table',1),(5,'2021_07_05_061529_create_charges_table',1),(6,'2021_07_05_062124_create_expenses_table',1),(7,'2021_07_08_140211_create_clients_dev_table',2),(8,'2021_07_08_140221_create_clients_fmk_table',2),(9,'2021_07_08_182617_create_roles_table',3),(10,'2021_07_08_194816_create_staff_table',3),(11,'2021_07_08_201146_create_incomes_table',3); /*!40000 ALTER TABLE `migrations` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `password_resets` -- LOCK TABLES `password_resets` WRITE; /*!40000 ALTER TABLE `password_resets` DISABLE KEYS */; /*!40000 ALTER TABLE `password_resets` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `payment_methods` -- LOCK TABLES `payment_methods` WRITE; /*!40000 ALTER TABLE `payment_methods` DISABLE KEYS */; INSERT INTO `payment_methods` VALUES (1,'16995ede-aaeb-4890-8538-a90e1e941978','Cash','2021-07-09 09:44:15','2021-07-09 09:44:15',NULL),(2,'69310c15-ae7d-4f7c-bff2-9d7c6ed90d02','EFT','2021-07-09 09:44:22','2021-07-09 09:44:22',NULL); /*!40000 ALTER TABLE `payment_methods` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `roles` -- LOCK TABLES `roles` WRITE; /*!40000 ALTER TABLE `roles` DISABLE KEYS */; /*!40000 ALTER TABLE `roles` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `staff` -- LOCK TABLES `staff` WRITE; /*!40000 ALTER TABLE `staff` DISABLE KEYS */; /*!40000 ALTER TABLE `staff` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `users` -- LOCK TABLES `users` WRITE; /*!40000 ALTER TABLE `users` DISABLE KEYS */; /*!40000 ALTER TABLE `users` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2021-07-09 19:09:41