gcc_office_dump_project_files/Dump20250423.sql

-- MySQL dump 10.13  Distrib 8.0.40, for Win64 (x86_64)
--
-- Host: localhost    Database: dumpwastecollector
-- ------------------------------------------------------
-- Server version	8.0.40

/*!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 */;

--
-- Table structure for table `dumping_location`
--

DROP TABLE IF EXISTS `dumping_location`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `dumping_location` (
  `id` int NOT NULL AUTO_INCREMENT,
  `location` varchar(255) DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT '1',
  `is_delete` tinyint(1) DEFAULT '0',
  `cdate` datetime DEFAULT CURRENT_TIMESTAMP,
  `quantity_id` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `dumping_location`
--

LOCK TABLES `dumping_location` WRITE;
/*!40000 ALTER TABLE `dumping_location` DISABLE KEYS */;
INSERT INTO `dumping_location` VALUES (1,'Kodungaiyur',1,0,'2025-03-25 15:24:21','2'),(2,'perungudi',1,0,'2025-03-25 15:24:21','2'),(3,'Buckingam canal road, Sathangadu, Thiruvottriyur. (Adjacent to lorry station, Zone-1)',1,0,'2025-04-03 16:13:19','1'),(4,'Unit-5, Kamaraj Salai (Near zonal office)',1,0,'2025-04-03 16:13:19','1'),(5,'CMDA Truck Terminal near Night Shelter (Back side of Madhavaram Bus Terminus)',1,0,'2025-04-03 16:13:19','1'),(6,'Kodungaiyur Dumping ground, Tondiarpet High Road (3rd gate)',1,0,'2025-04-03 16:13:19','1'),(7,'Part of old Cattle depot, Avadhanam Pappier Road, Choolai (Opposite to Corporation School)',1,0,'2025-04-03 16:13:19','1'),(8,'Part of old Cattle depot, Avadhanam Pappier Road, Choolai (Opposite to Corporation School)',0,1,'2025-04-03 16:13:19','1'),(9,'Vanagaram Road, Athipet dumping yard',1,0,'2025-04-03 16:13:19','1'),(10,'1st Main Road, Shenoy Nagar (Near Gajalakshmi Colony)',1,0,'2025-04-03 16:13:19','1'),(11,'Lloyds Colony (Near Corporation ITI Institute)',1,0,'2025-04-03 16:13:19','1'),(12,'Gurusiva Street, S.M Block, Jafferkhanpet, Kodambakkam (Near R-10 MGR Nagar Police Station)',1,0,'2025-04-03 16:13:19','1'),(13,'Nolambur Phase II, 2nd main road (Near Madhuravoyal Taluk office)',1,0,'2025-04-03 16:13:19','1'),(14,'Nandambakkam TPF near Adyar river bund in Dn - 158',1,0,'2025-04-03 16:13:19','1'),(15,'Velechery Main Road, Near to Gurunanak college, Velecherry Burial Ground',1,0,'2025-04-03 16:13:19','1'),(16,'200 Ft Radial Road, Perungudi Dumping Ground',1,0,'2025-04-03 16:13:19','1'),(17,'Gangaiamman Kovil Street extn., Karapakkam (Near to Tamilnadu Teacher Education University)',1,0,'2025-04-03 16:13:19','1'),(18,'Kodungaiyur',1,0,'2025-04-04 13:28:42','3'),(19,'perungudi',1,0,'2025-04-04 13:28:42','3'),(100,'aLL',0,1,'2025-04-04 13:28:42','1');
/*!40000 ALTER TABLE `dumping_location` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `order_log`
--

DROP TABLE IF EXISTS `order_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `order_log` (
  `id` int NOT NULL AUTO_INCREMENT,
  `order_info` varchar(1000) DEFAULT NULL,
  `order_id` varchar(45) DEFAULT NULL,
  `ref_id` varchar(45) DEFAULT NULL,
  `cdate` datetime DEFAULT CURRENT_TIMESTAMP,
  `order_status` varchar(45) DEFAULT NULL,
  `pay_attempt` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `order_log`
--

LOCK TABLES `order_log` WRITE;
/*!40000 ALTER TABLE `order_log` DISABLE KEYS */;
/*!40000 ALTER TABLE `order_log` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `payment`
--

DROP TABLE IF EXISTS `payment`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `payment` (
  `id` int NOT NULL AUTO_INCREMENT,
  `mobile_no` varchar(25) DEFAULT NULL,
  `order_id` varchar(100) DEFAULT NULL,
  `payment_id` varchar(100) DEFAULT NULL,
  `paymentstatus` varchar(45) DEFAULT NULL,
  `payment_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `ref_id` varchar(45) DEFAULT NULL,
  `amount` double DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `payment`
--

LOCK TABLES `payment` WRITE;
/*!40000 ALTER TABLE `payment` DISABLE KEYS */;
/*!40000 ALTER TABLE `payment` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `payment_failure_log`
--

DROP TABLE IF EXISTS `payment_failure_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `payment_failure_log` (
  `id` int NOT NULL AUTO_INCREMENT,
  `payment_id` varchar(100) DEFAULT NULL,
  `order_id` varchar(100) DEFAULT NULL,
  `ref_id` varchar(45) DEFAULT NULL,
  `reason` varchar(45) DEFAULT NULL,
  `cdate` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `payment_failure_log`
--

LOCK TABLES `payment_failure_log` WRITE;
/*!40000 ALTER TABLE `payment_failure_log` DISABLE KEYS */;
/*!40000 ALTER TABLE `payment_failure_log` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `quantity_master`
--

DROP TABLE IF EXISTS `quantity_master`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `quantity_master` (
  `id` int NOT NULL AUTO_INCREMENT,
  `quantity` varchar(255) DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT '1',
  `is_delete` tinyint(1) DEFAULT '0',
  `cdate` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `quantity_master`
--

LOCK TABLES `quantity_master` WRITE;
/*!40000 ALTER TABLE `quantity_master` DISABLE KEYS */;
INSERT INTO `quantity_master` VALUES (1,'Less Than 1 Ton',1,0,'2025-03-25 15:26:18'),(2,'1 Ton to 20 Ton',1,0,'2025-03-25 15:26:18'),(3,'More Than 20 Ton',1,0,'2025-03-25 15:26:18');
/*!40000 ALTER TABLE `quantity_master` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `refund_info`
--

DROP TABLE IF EXISTS `refund_info`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `refund_info` (
  `id` int NOT NULL AUTO_INCREMENT,
  `ref_id` varchar(255) DEFAULT NULL,
  `refund_amt` double DEFAULT NULL,
  `balance_amt` double DEFAULT NULL,
  `pid` int DEFAULT NULL,
  `refund_id` varchar(255) DEFAULT NULL,
  `refund_status` varchar(100) DEFAULT NULL,
  `cdate` datetime DEFAULT CURRENT_TIMESTAMP,
  `r_desc` varchar(2000) DEFAULT NULL,
  `rrn` varchar(55) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `refund_info`
--

LOCK TABLES `refund_info` WRITE;
/*!40000 ALTER TABLE `refund_info` DISABLE KEYS */;
/*!40000 ALTER TABLE `refund_info` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `vehicle_master`
--

DROP TABLE IF EXISTS `vehicle_master`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `vehicle_master` (
  `id` int NOT NULL AUTO_INCREMENT,
  `vehicle_name` varchar(255) DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT '1',
  `is_delete` tinyint(1) DEFAULT '0',
  `cdate` datetime DEFAULT CURRENT_TIMESTAMP,
  `quantity_id` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `vehicle_master`
--

LOCK TABLES `vehicle_master` WRITE;
/*!40000 ALTER TABLE `vehicle_master` DISABLE KEYS */;
INSERT INTO `vehicle_master` VALUES (1,'GCC Service',1,0,'2025-04-03 22:01:45',1),(2,'GCC Authorized C&D Waste Collectors',1,0,'2025-04-03 22:01:45',2),(3,'Self Arranged Vehicles',1,0,'2025-04-03 22:01:45',1),(4,'GCC Service',1,0,'2025-04-04 13:18:37',2),(5,'Self Arranged Vehicles',1,0,'2025-04-04 13:18:37',2),(6,'GCC Authorized C&D Waste Collectors',1,0,'2025-04-04 13:18:37',3),(7,'Self Arranged Vehicles',1,0,'2025-04-04 13:18:37',3);
/*!40000 ALTER TABLE `vehicle_master` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `wards`
--

DROP TABLE IF EXISTS `wards`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `wards` (
  `id` int NOT NULL AUTO_INCREMENT,
  `ward_name` varchar(50) DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT '1',
  `is_delete` tinyint(1) DEFAULT '0',
  `cdate` datetime DEFAULT CURRENT_TIMESTAMP,
  `zone_id` int DEFAULT NULL,
  `zone_name` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=144 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `wards`
--

LOCK TABLES `wards` WRITE;
/*!40000 ALTER TABLE `wards` DISABLE KEYS */;
INSERT INTO `wards` VALUES (1,'001',1,0,'2025-04-12 16:55:46',1,'01'),(2,'002',1,0,'2025-04-12 16:55:46',1,'01'),(3,'003',1,0,'2025-04-12 16:55:46',1,'01'),(4,'004',1,0,'2025-04-15 01:14:30',1,'01'),(5,'005',1,0,'2025-04-15 01:14:30',1,'01'),(6,'006',1,0,'2025-04-15 01:14:30',1,'01'),(7,'007',1,0,'2025-04-15 01:14:30',1,'01'),(8,'008',1,0,'2025-04-15 01:14:30',1,'01'),(9,'009',1,0,'2025-04-15 01:14:30',1,'01'),(10,'010',1,0,'2025-04-15 01:14:30',1,'01'),(11,'011',1,0,'2025-04-15 01:14:30',1,'01'),(12,'012',1,0,'2025-04-15 01:14:30',1,'01'),(13,'013',1,0,'2025-04-15 01:14:30',1,'01'),(14,'014',1,0,'2025-04-15 01:14:30',1,'01'),(15,'015',1,0,'2025-04-15 01:14:30',2,'02'),(16,'016',1,0,'2025-04-15 01:14:30',2,'02'),(17,'017',1,0,'2025-04-15 01:14:30',2,'02'),(18,'018',1,0,'2025-04-15 01:14:30',2,'02'),(19,'019',1,0,'2025-04-15 01:14:30',2,'02'),(20,'020',1,0,'2025-04-15 01:14:30',2,'02'),(21,'021',1,0,'2025-04-15 01:14:30',2,'02'),(22,'022',1,0,'2025-04-15 01:14:30',2,'02'),(23,'023',1,0,'2025-04-15 01:14:30',3,'03'),(24,'024',1,0,'2025-04-15 01:14:30',3,'03'),(25,'025',1,0,'2025-04-15 01:14:30',3,'03'),(26,'026',1,0,'2025-04-15 01:14:30',3,'03'),(27,'027',1,0,'2025-04-15 01:14:30',3,'03'),(28,'028',1,0,'2025-04-15 01:14:30',3,'03'),(29,'029',1,0,'2025-04-15 01:14:30',3,'03'),(30,'030',1,0,'2025-04-15 01:14:30',3,'03'),(31,'031',1,0,'2025-04-15 01:14:30',3,'03'),(32,'032',1,0,'2025-04-15 01:14:30',3,'03'),(33,'033',1,0,'2025-04-15 01:14:30',3,'03'),(34,'034',1,0,'2025-04-15 01:14:30',4,'04'),(35,'035',1,0,'2025-04-15 01:14:30',4,'04'),(36,'036',1,0,'2025-04-15 01:14:30',4,'04'),(37,'037',1,0,'2025-04-15 01:14:30',4,'04'),(38,'038',1,0,'2025-04-15 01:14:30',4,'04'),(39,'039',1,0,'2025-04-15 01:14:30',4,'04'),(40,'040',1,0,'2025-04-15 01:14:30',4,'04'),(41,'041',1,0,'2025-04-15 01:14:30',4,'04'),(42,'042',1,0,'2025-04-15 01:14:30',4,'04'),(43,'043',1,0,'2025-04-15 01:14:30',4,'04'),(44,'044',1,0,'2025-04-15 01:14:30',4,'04'),(45,'045',1,0,'2025-04-15 01:14:30',4,'04'),(46,'046',1,0,'2025-04-15 01:14:30',4,'04'),(47,'047',1,0,'2025-04-15 01:14:30',4,'04'),(48,'048',1,0,'2025-04-15 01:14:30',4,'04'),(49,'049',1,0,'2025-04-15 01:14:30',5,'04'),(50,'050',1,0,'2025-04-15 01:14:30',5,'05'),(51,'051',1,0,'2025-04-15 01:14:30',5,'05'),(52,'052',1,0,'2025-04-15 01:14:30',5,'05'),(53,'053',1,0,'2025-04-15 01:14:30',5,'05'),(54,'054',1,0,'2025-04-15 01:14:30',5,'05'),(55,'055',1,0,'2025-04-15 01:14:30',5,'05'),(56,'056',1,0,'2025-04-15 01:14:30',5,'05'),(57,'057',1,0,'2025-04-15 01:14:30',5,'05'),(58,'058',1,0,'2025-04-15 01:14:30',5,'05'),(59,'059',1,0,'2025-04-15 01:14:30',5,'05'),(60,'060',1,0,'2025-04-15 01:14:30',5,'05'),(61,'061',1,0,'2025-04-15 01:14:30',5,'05'),(62,'062',1,0,'2025-04-15 01:14:30',5,'05'),(63,'063',1,0,'2025-04-15 01:14:30',5,'05'),(64,'064',1,0,'2025-04-15 01:14:30',6,'06'),(65,'065',1,0,'2025-04-15 01:14:30',6,'06'),(66,'066',1,0,'2025-04-15 01:14:30',6,'06'),(67,'067',1,0,'2025-04-15 01:14:30',6,'06'),(68,'068',1,0,'2025-04-15 01:14:30',6,'06'),(69,'069',1,0,'2025-04-15 01:14:30',6,'06'),(70,'070',1,0,'2025-04-15 01:14:30',6,'06'),(71,'071',1,0,'2025-04-15 01:14:30',6,'06'),(72,'072',1,0,'2025-04-15 01:14:30',6,'06'),(73,'073',1,0,'2025-04-15 01:14:30',6,'06'),(74,'074',1,0,'2025-04-15 01:14:30',6,'06'),(75,'075',1,0,'2025-04-15 01:14:30',6,'06'),(76,'076',1,0,'2025-04-15 01:14:30',6,'06'),(77,'077',1,0,'2025-04-15 01:14:30',6,'06'),(78,'078',1,0,'2025-04-15 01:14:30',6,'06'),(79,'079',1,0,'2025-04-15 01:14:30',7,'07'),(80,'080',1,0,'2025-04-15 01:14:30',7,'07'),(81,'081',1,0,'2025-04-15 01:14:30',7,'07'),(82,'082',1,0,'2025-04-15 01:14:30',7,'07'),(83,'083',1,0,'2025-04-15 01:14:30',7,'07'),(84,'084',1,0,'2025-04-15 01:14:30',7,'07'),(85,'085',1,0,'2025-04-15 01:14:30',7,'07'),(86,'086',1,0,'2025-04-15 01:14:30',7,'07'),(87,'087',1,0,'2025-04-15 01:14:30',7,'07'),(88,'088',1,0,'2025-04-15 01:14:30',7,'07'),(89,'089',1,0,'2025-04-15 01:14:30',7,'07'),(90,'090',1,0,'2025-04-15 01:14:30',7,'07'),(91,'091',1,0,'2025-04-15 01:14:30',7,'07'),(92,'092',1,0,'2025-04-15 01:14:30',7,'07'),(93,'093',1,0,'2025-04-15 01:
/*!40000 ALTER TABLE `wards` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `waste_collection_charges`
--

DROP TABLE IF EXISTS `waste_collection_charges`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `waste_collection_charges` (
  `id` int NOT NULL AUTO_INCREMENT,
  `amount_type` varchar(45) DEFAULT NULL,
  `amount` double DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT '1',
  `is_delete` tinyint(1) DEFAULT '0',
  `cdate` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `waste_collection_charges`
--

LOCK TABLES `waste_collection_charges` WRITE;
/*!40000 ALTER TABLE `waste_collection_charges` DISABLE KEYS */;
INSERT INTO `waste_collection_charges` VALUES (1,'Processing Charges per ton',800,1,0,'2025-04-04 11:12:18'),(2,'Waste Collection Charges per ton',2500,1,0,'2025-04-04 11:12:18'),(3,'Mixed Waste Charges per ton',3802,1,0,'2025-04-04 11:12:18');
/*!40000 ALTER TABLE `waste_collection_charges` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `waste_collectors_request`
--

DROP TABLE IF EXISTS `waste_collectors_request`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `waste_collectors_request` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `mobile_no` varchar(15) DEFAULT NULL,
  `zone` varchar(20) DEFAULT NULL,
  `ward` varchar(20) DEFAULT NULL,
  `waste_quantity_id` int DEFAULT NULL,
  `dump_location_id` int DEFAULT NULL,
  `waste_type_id` int DEFAULT NULL,
  `vehicle_id` int DEFAULT NULL,
  `upload_image_url` varchar(255) DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT '1',
  `is_delete` tinyint(1) DEFAULT '0',
  `cdate` datetime DEFAULT CURRENT_TIMESTAMP,
  `payment_status` varchar(45) DEFAULT NULL,
  `refid` varchar(50) DEFAULT NULL,
  `actual_weight` varchar(45) DEFAULT NULL,
  `payment_type` varchar(45) DEFAULT NULL,
  `processing_charge` double DEFAULT NULL,
  `waste_collection_charge` double DEFAULT NULL,
  `total_charge` double DEFAULT NULL,
  `payment_mobile_no` varchar(45) DEFAULT NULL,
  `door_number` varchar(45) DEFAULT NULL,
  `street_name` varchar(50) DEFAULT NULL,
  `area` varchar(50) DEFAULT NULL,
  `city` varchar(45) DEFAULT NULL,
  `pincode` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `waste_collectors_request`
--

LOCK TABLES `waste_collectors_request` WRITE;
/*!40000 ALTER TABLE `waste_collectors_request` DISABLE KEYS */;
/*!40000 ALTER TABLE `waste_collectors_request` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `waste_type_master`
--

DROP TABLE IF EXISTS `waste_type_master`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `waste_type_master` (
  `id` int NOT NULL AUTO_INCREMENT,
  `waste_type` varchar(45) DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT '1',
  `is_delete` tinyint(1) DEFAULT '0',
  `cdate` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `waste_type_master`
--

LOCK TABLES `waste_type_master` WRITE;
/*!40000 ALTER TABLE `waste_type_master` DISABLE KEYS */;
INSERT INTO `waste_type_master` VALUES (1,'Concrete',1,0,'2025-04-03 17:10:17'),(2,'Wood & Plastic ',0,1,'2025-04-03 17:10:17'),(3,'Bricks and Mortars',1,0,'2025-04-03 17:10:17'),(4,'Mixed Waste',1,0,'2025-04-12 20:35:11');
/*!40000 ALTER TABLE `waste_type_master` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `zones`
--

DROP TABLE IF EXISTS `zones`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `zones` (
  `id` int NOT NULL AUTO_INCREMENT,
  `zone_name` varchar(50) DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT '1',
  `is_delete` tinyint(1) DEFAULT '0',
  `cdate` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `zones`
--

LOCK TABLES `zones` WRITE;
/*!40000 ALTER TABLE `zones` DISABLE KEYS */;
INSERT INTO `zones` VALUES (1,'01',1,0,'2025-04-12 16:53:38'),(2,'02',1,0,'2025-04-12 16:53:38'),(3,'03',1,0,'2025-04-15 00:57:19'),(4,'04',1,0,'2025-04-15 00:57:19'),(5,'05',1,0,'2025-04-15 00:57:19'),(6,'06',1,0,'2025-04-15 00:57:19'),(7,'07',1,0,'2025-04-15 00:57:19'),(8,'08',1,0,'2025-04-15 00:57:19'),(9,'09',1,0,'2025-04-15 00:57:19'),(10,'10',1,0,'2025-04-15 00:57:19'),(11,'11',1,0,'2025-04-15 00:57:19'),(12,'12',1,0,'2025-04-15 00:57:19'),(13,'13',1,0,'2025-04-15 00:57:19'),(14,'14',1,0,'2025-04-15 00:57:19'),(15,'15',1,0,'2025-04-15 00:57:19');
/*!40000 ALTER TABLE `zones` 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 2025-04-23 12:51:34