/*M!999999\- enable the sandbox mode */ -- MariaDB dump 10.19 Distrib 10.11.18-MariaDB, for Linux (x86_64) -- -- Host: localhost Database: digitalv_billing_db -- ------------------------------------------------------ -- Server version 10.11.18-MariaDB /*!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 */; /*!40101 SET NAMES utf8mb4 */; /*!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 */; -- -- Table structure for table `activity_log` -- DROP TABLE IF EXISTS `activity_log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `activity_log` ( `id` int(11) NOT NULL AUTO_INCREMENT, `action` varchar(100) DEFAULT NULL, `table_name` varchar(100) DEFAULT NULL, `record_id` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT current_timestamp(), PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `activity_log` -- LOCK TABLES `activity_log` WRITE; /*!40000 ALTER TABLE `activity_log` DISABLE KEYS */; /*!40000 ALTER TABLE `activity_log` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `customers` -- DROP TABLE IF EXISTS `customers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `customers` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `phone` varchar(50) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `address` text DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `customers` -- LOCK TABLES `customers` WRITE; /*!40000 ALTER TABLE `customers` DISABLE KEYS */; INSERT INTO `customers` VALUES (10,'Deepak Choudhary','deepaksc@gmail.com','9930314707','2026-04-01 04:35:28','B-806 Pinnacle CHS \r\nVasant Oscar \r\nLBS marg \r\nMulund west \r\nMumbai 400080'), (11,'Anurag Golipkar','anurag.golipkar@gmail.com','9890083830','2026-04-01 08:37:17','Mumbai'), (12,'Swati Indulkar','swati@adhyay.in','9820415915','2026-04-01 09:33:25','Mulund'), (13,'Bhavin Sharma','Info@srishchem.com','8692017589','2026-04-01 09:41:58','B 39, Meghdhara Market Railway Station Road, Anjurphata, Bhiwandi, Dist.Thane, Maharashtra 421302'), (14,'Raman Shreeram Shipping','raman@shreeramshipping.com','9137738563','2026-04-01 12:40:29','Thane'), (15,'Jagdish Ahuja','info@japsandassociates.in','9323144390','2026-04-01 12:42:56','301, 3rd Floor, ARK 7, B Wing, Raghoba Shankar Cross Road, Behind American Watch Company, Thane West, Pin -400601'), (16,'Subharao','subbarao@capitalconsulting.co.in','9820844965','2026-04-03 08:06:59','Delhi'), (18,'Raghav Rao','thinkdirectindia@gmail.com','9819491489','2026-04-03 09:29:33','Thane'), (19,'Nitesh Saxena','aritradigimedia@gmail.com','8591099253','2026-04-17 08:01:12','Address: FLAT-C-903, Niharika Absolute, Plot-A-10, Sect-39A , Kharghar, Kharghar (CT) Ta:PANVEL Di:RAIGAD 410210.'), (20,'Gaurav Gupte','gaurav@g4i.in','9619571723','2026-04-22 07:23:06','Office No. 23, Bharat Industrial Premises, LBS Rd, Rajiv Gandhi Nagar, Bhandup West, Mumbai.'), (21,'Prem Bhange','prem@alliancegroups.in','8080819009','2026-04-24 06:15:10','411, Jaydeep Emphasis,\r\nNear, LBS Rd, opp.\r\nPunjab National Bank,\r\nWagle Estate, Thane\r\nWest, Mumbai,\r\nMaharashtra 400604'); /*!40000 ALTER TABLE `customers` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `expenses` -- DROP TABLE IF EXISTS `expenses`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `expenses` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) DEFAULT NULL, `amount` decimal(10,2) DEFAULT NULL, `expense_date` date DEFAULT NULL, `customer_id` int(11) DEFAULT NULL, `service_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `expenses` -- LOCK TABLES `expenses` WRITE; /*!40000 ALTER TABLE `expenses` DISABLE KEYS */; INSERT INTO `expenses` VALUES (1,'Purchsae G Suite for srishchem.com monthly billing',1364.00,'2026-04-01',NULL,NULL); /*!40000 ALTER TABLE `expenses` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `invoice_items` -- DROP TABLE IF EXISTS `invoice_items`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `invoice_items` ( `id` int(11) NOT NULL AUTO_INCREMENT, `invoice_id` int(11) DEFAULT NULL, `service_id` int(11) DEFAULT NULL, `description` varchar(255) DEFAULT NULL, `amount` decimal(10,2) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `invoice_items` -- LOCK TABLES `invoice_items` WRITE; /*!40000 ALTER TABLE `invoice_items` DISABLE KEYS */; INSERT INTO `invoice_items` VALUES (1,2,2,'hosting',3500.00), (7,7,9,NULL,8000.00), (8,4,7,'weaverbird maintenance',3000.00), (9,3,5,NULL,5000.00), (10,3,6,NULL,3000.00), (11,8,10,'The knowledge Worker monthly maintenance',10000.00), (14,11,11,'shreeramshipping.com domain renewal',2000.00), (19,14,14,'aritradigimedia.com',2500.00), (20,15,15,'AMC for Loc india',4500.00), (21,16,12,'japsandassociates.in Domain Renewal',1500.00), (22,16,13,'japsandassociates.in (Hosting)',2500.00), (23,17,8,'adhyayfoundation.org',1700.00), (26,19,16,'gfalliance.net',2200.00), (27,19,17,'gfalliance.net',8000.00); /*!40000 ALTER TABLE `invoice_items` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `invoices` -- DROP TABLE IF EXISTS `invoices`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `invoices` ( `id` int(11) NOT NULL AUTO_INCREMENT, `customer_id` int(11) DEFAULT NULL, `total` decimal(10,2) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `status` enum('paid','unpaid') DEFAULT 'unpaid', `invoice_date` date DEFAULT NULL, `due_date` date DEFAULT NULL, `payment_status` enum('pending','paid') DEFAULT 'pending', `invoice_no` varchar(20) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `invoices` -- LOCK TABLES `invoices` WRITE; /*!40000 ALTER TABLE `invoices` DISABLE KEYS */; INSERT INTO `invoices` VALUES (3,10,8000.00,'2026-04-01 04:44:21','unpaid','2026-04-01','2026-04-01','paid',NULL), (4,11,3000.00,'2026-04-01 09:21:17','unpaid','2026-04-01','2026-04-01','paid',NULL), (7,13,8000.00,'2026-04-01 09:43:10','unpaid','2026-04-01','2026-04-01','paid',NULL), (8,16,10000.00,'2026-04-03 08:08:22','unpaid','2026-04-01','2026-04-01','paid',NULL), (11,14,2000.00,'2026-04-03 09:11:20','unpaid','2026-04-15','2026-04-29','paid',NULL), (14,19,2500.00,'2026-04-17 08:02:45','unpaid','2026-04-17','2026-05-02','paid',NULL), (15,20,4500.00,'2026-04-22 07:24:39','unpaid','2026-04-22','2026-04-22','paid',NULL), (16,15,4000.00,'2026-04-23 13:04:45','unpaid','2026-04-23','2026-04-29','paid',NULL), (17,12,1700.00,'2026-04-24 06:11:54','unpaid','2026-04-24','2026-04-29','paid',NULL), (19,21,10200.00,'2026-04-24 06:18:41','unpaid','2026-04-24','2026-04-29','paid',NULL); /*!40000 ALTER TABLE `invoices` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `payments` -- DROP TABLE IF EXISTS `payments`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `payments` ( `id` int(11) NOT NULL AUTO_INCREMENT, `invoice_id` int(11) DEFAULT NULL, `amount` decimal(10,2) DEFAULT NULL, `payment_date` date DEFAULT NULL, `method` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `payments` -- LOCK TABLES `payments` WRITE; /*!40000 ALTER TABLE `payments` DISABLE KEYS */; INSERT INTO `payments` VALUES (1,7,8000.00,'2026-04-01','Bank'), (2,4,3000.00,'2026-04-02','Bank'), (3,8,10000.00,'2026-04-02','UPI'), (4,14,2500.00,'2026-04-17','UPI'), (5,3,8000.00,'2026-04-18','UPI'), (6,15,4500.00,'2026-04-22','Bank'), (7,16,4000.00,'2026-04-23','Bank'), (8,17,1700.00,'2026-04-24','UPI'), (9,19,10200.00,'2026-04-24','Bank'), (10,11,2000.00,'2026-04-30','Bank'); /*!40000 ALTER TABLE `payments` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `services` -- DROP TABLE IF EXISTS `services`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `services` ( `id` int(11) NOT NULL AUTO_INCREMENT, `customer_id` int(11) DEFAULT NULL, `service_name` varchar(255) DEFAULT NULL, `type` enum('domain','hosting','amc','other') DEFAULT NULL, `description` text DEFAULT NULL, `amount` decimal(10,2) DEFAULT NULL, `start_date` date DEFAULT NULL, `renewal_date` date DEFAULT NULL, `status` enum('active','expired') DEFAULT 'active', `last_billed` date DEFAULT NULL, `cost` decimal(10,2) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `services` -- LOCK TABLES `services` WRITE; /*!40000 ALTER TABLE `services` DISABLE KEYS */; INSERT INTO `services` VALUES (5,10,'AMC for thekidwhotravelled.com','amc','AMC',5000.00,'2026-04-01','2027-03-31','active',NULL,0.00), (6,10,'Hosting for thekidwhotravelled.com','hosting','Hosting',3000.00,'2026-04-01','2027-03-31','active',NULL,0.00), (7,11,'weaverbird maintenance','amc','weaverbird maintenance',3000.00,'2026-04-01','2027-03-31','active','2026-04-01',0.00), (8,12,'adhyayfoundation.org','domain','adhyayfoundation.org',1700.00,'2026-04-07','2027-04-06','active','2026-04-24',1580.00), (9,13,'G Suite Renewal','other','G Suite',8000.00,'2026-04-01','2027-04-01','active','2026-04-01',7000.00), (10,16,'The knowledge Worker monthly maintenance','amc',NULL,10000.00,'2026-04-01','2026-05-01','active','2026-04-01',0.00), (11,14,'shreeramshipping.com domain renewal','domain',NULL,2000.00,'2026-04-15','2027-04-29','active','2026-04-15',1356.00), (12,15,'japsandassociates.in Domain Renewal','domain',NULL,1500.00,'2026-04-15','2027-04-28','active','2026-04-23',884.00), (13,15,'japsandassociates.in (Hosting)','hosting',NULL,2500.00,'2026-04-15','2027-04-28','active','2026-04-23',0.00), (14,19,'aritradigimedia.com','hosting',NULL,2500.00,'2026-04-17','2027-05-02','active','2026-04-17',0.00), (15,20,'AMC for Loc india','amc',NULL,4500.00,'2026-04-01','2027-04-01','active','2026-04-22',0.00), (16,21,'gfalliance.net (Domain)','domain',NULL,2200.00,'2026-04-24','2027-04-29','active','2026-04-24',1669.00), (17,21,'gfalliance.net (Hosting)','hosting',NULL,8000.00,'2026-04-24','2027-04-29','active','2026-04-24',0.00); /*!40000 ALTER TABLE `services` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `users` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(100) DEFAULT NULL, `password` varchar(255) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `remember_token` varchar(255) DEFAULT NULL, `reset_token` varchar(255) DEFAULT NULL, `reset_expire` datetime DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `username` (`username`) ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `users` -- LOCK TABLES `users` WRITE; /*!40000 ALTER TABLE `users` DISABLE KEYS */; INSERT INTO `users` VALUES (5,'admin','$2y$10$n.64Tfz57SZllMwbr6NTMuHIY6C7tvf9zatfJHzAaJxBbB8Lr3hja','2026-03-31 11:09:06',NULL,NULL,NULL); /*!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 2026-05-29 14:39:51