����JFIF��`�`�����Viewing File: /home/u820193700/domains/throtllr.com/public_html/avahan_motors_export.sql
-- MariaDB dump 10.19  Distrib 10.4.32-MariaDB, for Win64 (AMD64)
--
-- Host: localhost    Database: avahan_motors
-- ------------------------------------------------------
-- Server version	10.4.32-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 `booking_addons`
--

DROP TABLE IF EXISTS `booking_addons`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `booking_addons` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `booking_id` int(11) NOT NULL,
  `addon_id` int(11) NOT NULL,
  `label` varchar(150) DEFAULT NULL,
  `price` decimal(10,2) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `booking_id` (`booking_id`),
  CONSTRAINT `booking_addons_ibfk_1` FOREIGN KEY (`booking_id`) REFERENCES `bookings` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `booking_addons`
--

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

--
-- Table structure for table `booking_passengers`
--

DROP TABLE IF EXISTS `booking_passengers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `booking_passengers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `booking_id` int(11) NOT NULL,
  `participant_type` enum('rider','passenger') DEFAULT 'passenger',
  `full_name` varchar(255) NOT NULL,
  `age` int(11) DEFAULT NULL,
  `gender` enum('male','female','other','prefer_not_to_say') DEFAULT NULL,
  `emergency_contact` varchar(20) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `booking_id` (`booking_id`),
  CONSTRAINT `booking_passengers_ibfk_1` FOREIGN KEY (`booking_id`) REFERENCES `bookings` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `booking_passengers`
--

LOCK TABLES `booking_passengers` WRITE;
/*!40000 ALTER TABLE `booking_passengers` DISABLE KEYS */;
INSERT INTO `booking_passengers` VALUES (4,4,'rider','Srujan K A',24,'male','8618350438','2026-03-18 07:02:28'),(5,5,'rider','Srujan K A',24,'male','8618350438','2026-03-18 07:02:35'),(6,6,'rider','Srujan',20,'male','9480716278','2026-03-18 07:46:52'),(7,7,'rider','Srujan',24,'male','8618350438','2026-03-18 08:11:12'),(8,8,'rider','Srujan K A',24,'male','9480716278','2026-03-24 05:19:02'),(9,9,'rider','Sruja',24,'male','8618350438','2026-03-24 08:06:52'),(10,10,'rider','Sruja',24,'male','8618350438','2026-03-24 08:13:47'),(11,11,'rider','Sruja',24,'male','9480716278','2026-03-24 08:19:06');
/*!40000 ALTER TABLE `booking_passengers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `bookings`
--

DROP TABLE IF EXISTS `bookings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bookings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tour_id` int(11) NOT NULL,
  `rider_id` int(11) NOT NULL,
  `payment_status` enum('pending','completed','failed','refunded') DEFAULT 'pending',
  `rider_type` enum('single','with_passenger','only_passenger') NOT NULL DEFAULT 'single',
  `solo_count` int(11) DEFAULT 1,
  `passenger_count` int(11) DEFAULT 0,
  `total_amount` decimal(10,2) DEFAULT 0.00,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `tour_id` (`tour_id`),
  KEY `rider_id` (`rider_id`),
  KEY `idx_bookings_payment_status` (`payment_status`),
  CONSTRAINT `bookings_ibfk_1` FOREIGN KEY (`tour_id`) REFERENCES `tours` (`id`) ON DELETE CASCADE,
  CONSTRAINT `bookings_ibfk_2` FOREIGN KEY (`rider_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `bookings`
--

LOCK TABLES `bookings` WRITE;
/*!40000 ALTER TABLE `bookings` DISABLE KEYS */;
INSERT INTO `bookings` VALUES (4,49,1,'pending','single',1,0,30000.00,'2026-03-18 07:02:28'),(5,49,1,'pending','single',1,0,30000.00,'2026-03-18 07:02:35'),(6,49,1,'completed','single',1,0,30000.00,'2026-03-18 07:46:52'),(7,49,21,'completed','single',1,0,30000.00,'2026-03-18 08:11:12'),(8,49,21,'completed','single',1,0,30000.00,'2026-03-24 05:19:02'),(9,49,21,'completed','single',1,0,30000.00,'2026-03-24 08:06:52'),(10,49,21,'completed','single',1,0,30000.00,'2026-03-24 08:13:47'),(11,49,21,'completed','single',1,0,30000.00,'2026-03-24 08:19:06');
/*!40000 ALTER TABLE `bookings` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `community_members`
--

DROP TABLE IF EXISTS `community_members`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `community_members` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `bike_model` varchar(255) DEFAULT NULL,
  `experience` varchar(100) DEFAULT NULL,
  `message` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `gender` enum('male','female','other','prefer_not_to_say') DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `community_members`
--

LOCK TABLES `community_members` WRITE;
/*!40000 ALTER TABLE `community_members` DISABLE KEYS */;
INSERT INTO `community_members` VALUES (1,'Madesh','madesh@gmail.com','3245328750','Continental GT','Beginner','sdvofekvmfekove','2026-02-27 07:58:06',NULL),(2,'Mahadesh','madesh1@gmail.com','12332535436','Classic 350','Intermediate','','2026-02-27 10:51:30',NULL),(4,'Test User','test@test.com','1234567890','Test Bike','Test Exp','Test MSG','2026-03-09 06:12:41',NULL),(5,'mahesh','mahesh@gmail.com','1234567890','Hunter 350','Intermediate','veoi;kvle','2026-03-18 11:04:43','male'),(7,'Srujan K A','srujankesare@gmail.com','6366091014','Classic 350','Beginner','skjvcs','2026-03-24 09:08:23','male');
/*!40000 ALTER TABLE `community_members` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `dealer_wallets`
--

DROP TABLE IF EXISTS `dealer_wallets`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dealer_wallets` (
  `dealer_id` int(11) NOT NULL,
  `total_earned` decimal(10,2) DEFAULT 0.00,
  `total_paid` decimal(10,2) DEFAULT 0.00,
  `balance` decimal(10,2) DEFAULT 0.00,
  PRIMARY KEY (`dealer_id`),
  CONSTRAINT `dealer_wallets_ibfk_1` FOREIGN KEY (`dealer_id`) REFERENCES `dealers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `dealer_wallets`
--

LOCK TABLES `dealer_wallets` WRITE;
/*!40000 ALTER TABLE `dealer_wallets` DISABLE KEYS */;
INSERT INTO `dealer_wallets` VALUES (1,0.00,0.00,0.00),(2,0.00,0.00,0.00),(32,0.00,0.00,0.00);
/*!40000 ALTER TABLE `dealer_wallets` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `dealers`
--

DROP TABLE IF EXISTS `dealers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dealers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `showroom_name` varchar(255) NOT NULL,
  `location` varchar(255) NOT NULL,
  `commission_rate` decimal(5,2) DEFAULT 10.00,
  `status` enum('active','inactive') DEFAULT 'active',
  `upi_id` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `dealers_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `dealers`
--

LOCK TABLES `dealers` WRITE;
/*!40000 ALTER TABLE `dealers` DISABLE KEYS */;
INSERT INTO `dealers` VALUES (1,1,'AVAHAN MOTORS Pvt. Ltd','HRBR Layout, Kalyan Nagar, Bengaluru, 560043 ',0.00,'active','automated_subagent@ybl'),(2,1,'AVAHAN MOTORS Pvt Ltd','Loc',0.00,'active','testapicurl@upi'),(3,1,'CVS Motors','Sadashivanagar, Bengaluru, 560080',0.00,'active',NULL),(4,1,'ACCLAIM MOTORS RE','Neharu Nagar, Bengaluru, 560064',0.00,'active',NULL),(5,1,'TEKNIK ROYAL ENFIELD','HAL 2nd Stage, Bengaluru, 560038',0.00,'active',NULL),(6,1,'HSR Services','Rajajinagar, Bengaluru, 560010',0.00,'active',NULL),(7,1,'CVS Motors','Kalyan Nagar, Bengaluru, 560043',0.00,'active',NULL),(8,1,'ACCELERATE MOTORS','Mysore Road, Kengeri, Bengaluru, 560060',0.00,'active',NULL),(9,1,'ROYAL ENFIELD BRAND STORE','BTM layout, Bengaluru, 560076',0.00,'active',NULL),(10,1,'ROYAL ENFIELD COMPANY STORE ','Malleshwaram, Bengaluru, 560003',0.00,'active',NULL),(11,1,'TEKNIK MOTORS','Shiva Garden, Hoskote, Bengaluru, 560017',0.00,'active',NULL),(12,1,'BOMMASANDRA MOTORS','Hosur Road, Bengaluru, 560099',0.00,'active',NULL),(13,1,'CVS MOTORS','Hebbal, Bengaluru, 560094',0.00,'active',NULL),(14,1,'SAI RAM AUTOCRAFT','B Narayanpura, DV Nagar, Bengaluru, 560016',0.00,'active',NULL),(15,1,'WHITEFIELD MOTORS','Sadaramangala Village, KR Puram, Bengaluru, 560066',0.00,'active',NULL),(16,1,'ACCELERATE MOTORS','Rajarajeshwari, Bengaluru, 560098',0.00,'active',NULL),(17,1,'SAI SADGURU SAI MOTORS','Tumkur Road, Dasarahalli, Bengaluru, 560057',0.00,'active',NULL),(18,1,'ROYAL ENFIELD COMPANY STORE ','East End \"A\" Main, 9th Block, Bengaluru, 560069',0.00,'active',NULL),(19,1,'HSR SERVICES','Sudhama Nagar, Bengaluru, 560027',0.00,'active',NULL),(20,1,'TEKNIK MOTORCYCLES','Sarjapur Road, Bengaluru, 560102',0.00,'active',NULL),(21,1,'ELECTRONIC CITY MOTORS','Sinda Sandra, Hosur Road, Bengaluru, 560068',0.00,'active',NULL),(22,1,'KORAMANGALAMOTORS','Hosur Main Road, Krishnanagar Ind Area, Bengaluru, 560029',0.00,'active',NULL),(23,1,'HSR SERVICES','Banashankari stage 2, Bengaluru, 560070',0.00,'active',NULL),(24,1,'SAI SADGURU SAI MOTORS','Nelamangala, Bengaluru, 562123',0.00,'active',NULL),(25,1,'ROYAL ENFIELD BRAND STORE ','Jayanagar 9th Block, Bengaluru, 560069',0.00,'active',NULL),(26,1,'TORQUA','Papa Reddy Palya, Bengaluru, 560072',0.00,'active',NULL),(27,1,'HSR ENTERPRISES','Kamakshipalya, Magadi Main Road, Bengaluru, 560079',0.00,'active',NULL),(28,1,'SAI SADHGURU SAI MOTORS','Dodaballapur, Bengaluru, 561203',0.00,'active',NULL),(29,1,'CVS Motors','Kothanur, Hennur Main Road, Bengaluru, 560077',0.00,'active',NULL),(30,1,'','',0.00,'inactive',NULL),(32,1,'Avahan Official','Headquarters',0.00,'active',NULL),(36,24,'Royal Enfield','Doddanakkundi',10.00,'active','');
/*!40000 ALTER TABLE `dealers` 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 = utf8 */;
CREATE TABLE `payments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `booking_id` int(11) NOT NULL,
  `razorpay_payment_id` varchar(255) DEFAULT NULL,
  `razorpay_order_id` varchar(255) DEFAULT NULL,
  `razorpay_signature` varchar(255) DEFAULT NULL,
  `amount` decimal(10,2) NOT NULL,
  `commission` decimal(10,2) NOT NULL,
  `dealer_amount` decimal(10,2) NOT NULL,
  `status` varchar(50) DEFAULT 'successful',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `booking_id` (`booking_id`),
  KEY `idx_payments_status` (`status`),
  CONSTRAINT `payments_ibfk_1` FOREIGN KEY (`booking_id`) REFERENCES `bookings` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `payments`
--

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

--
-- Table structure for table `registration_otps`
--

DROP TABLE IF EXISTS `registration_otps`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `registration_otps` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(255) NOT NULL,
  `otp` varchar(10) NOT NULL,
  `expiry` datetime NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `attempts` int(11) DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `idx_reg_email` (`email`),
  KEY `idx_reg_expiry` (`expiry`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `registration_otps`
--

LOCK TABLES `registration_otps` WRITE;
/*!40000 ALTER TABLE `registration_otps` DISABLE KEYS */;
INSERT INTO `registration_otps` VALUES (3,'testrider@example.com','474142','2026-03-24 08:04:33','2026-03-24 06:49:33',0),(6,'pavan@harwaredepo.in','110171','2026-03-24 08:17:20','2026-03-24 07:02:20',0),(8,'testrider2@example.com','668646','2026-03-24 08:27:22','2026-03-24 07:12:22',0),(13,'testrider_final@example.com','766203','2026-03-24 13:19:03','2026-03-24 07:34:03',0),(14,'subagent_test@example.com','148198','2026-03-24 13:20:41','2026-03-24 07:35:41',0),(20,'test@example.com','846167','2026-03-24 14:19:01','2026-03-24 08:34:01',0);
/*!40000 ALTER TABLE `registration_otps` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `road_diaries`
--

DROP TABLE IF EXISTS `road_diaries`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `road_diaries` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rider_id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `media_type` varchar(50) NOT NULL,
  `media_url` varchar(255) NOT NULL,
  `status` enum('pending','approved','rejected') DEFAULT 'pending',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `rider_id` (`rider_id`),
  CONSTRAINT `road_diaries_ibfk_1` FOREIGN KEY (`rider_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `road_diaries`
--

LOCK TABLES `road_diaries` WRITE;
/*!40000 ALTER TABLE `road_diaries` DISABLE KEYS */;
INSERT INTO `road_diaries` VALUES (1,1,'Avahan Motors','Avahan motors old video','video','https://www.youtube.com/watch?v=fOwb4cbSqio','approved','2026-03-03 05:22:25'),(4,1,'Test','Testing','video','https://www.youtube.com/watch?v=_UlaA10_dRg','approved','2026-03-03 10:26:52'),(5,1,'Test1','Description','image','uploads/diaries/1772534237_WhatsApp_Image_2025_11_29_at_10.54.18_AM.jpeg','approved','2026-03-03 10:37:17'),(7,21,'Testing Road diaries','TEst','image','uploads/diaries/1773830697_e956cbdce35a4c06.jpg','approved','2026-03-18 10:44:57'),(8,21,'Test Ride','vjff fr lge mo','image','uploads/diaries/1774330739_321f7c471d53c26c.jpg','approved','2026-03-24 05:38:59'),(9,21,'Test video','vmrbpoirmrp','video','uploads/diaries/1774330775_e4a020a606dede8e.mp4','approved','2026-03-24 05:39:35'),(10,1,'Test Video','vskjvdcs','video','uploads/diaries/1774330910_734ffb31ddac65d0.mp4','approved','2026-03-24 05:41:50');
/*!40000 ALTER TABLE `road_diaries` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `simulated_emails`
--

DROP TABLE IF EXISTS `simulated_emails`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `simulated_emails` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `booking_id` int(11) DEFAULT NULL,
  `recipient` varchar(255) DEFAULT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `body` text DEFAULT NULL,
  `status` varchar(50) DEFAULT NULL,
  `sent_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `simulated_emails`
--

LOCK TABLES `simulated_emails` WRITE;
/*!40000 ALTER TABLE `simulated_emails` DISABLE KEYS */;
INSERT INTO `simulated_emails` VALUES (1,47,'srujankesare@gmail.com','Booking Confirmed: Delhi Long Road','Hi Srujan K A,\n\nYour booking for Delhi Long Road has been successfully confirmed!\n\nBooking ID: #47\nTotal Amount: ₹26,996.00\n\nWe are excited to have you on board.\n\nBest Regards,\nTHROTLLR',NULL,'2026-03-17 06:44:26'),(2,49,'srujankesare@gmail.com','Booking Confirmed: Delhi Long Road','Hi Srujan K A,\n\nGreat news! Your expedition with Throtllr is officially confirmed.\n\n--- BOOKING DETAILS ---\nExpedition: Delhi Long Road\nDeparture Date: 16 Mar, 2026\nBooking ID: #49\nBooking Time: 17 Mar, 2026 | 13:15\nTotal Amount: ₹26,996.00\n\n--- ATTENDEES ---\nSolo Riders: 1\nPassengers: 0\n\n\n📲 JOIN WHATSAPP GROUP:\nhttps://chat.whatsapp.com/IBPIQXWpmYzDt7rJohlwGI\n\nWe are thrilled to have you join us for this adventure. Detailed itinerary and preparation guides will follow shortly.\n\nRide Hard, Ride Safe!\n\nBest Regards,\nTHROTLLR','SENT','2026-03-17 07:45:38'),(3,50,'emgowda85@gmail.com','Booking Confirmed: Delhi Long Road','Hi Madesh E,\n\nGreat news! Your expedition with Throtllr is officially confirmed.\n\n--- BOOKING DETAILS ---\nExpedition: Delhi Long Road\nDeparture Date: 16 Mar, 2026\nBooking ID: #50\nBooking Time: 17 Mar, 2026 | 13:26\nTotal Amount: ₹46,493.20\n\n--- ATTENDEES ---\nSolo Riders: 0\nPassengers: 1\n\n\n📲 JOIN WHATSAPP GROUP:\nhttps://chat.whatsapp.com/IBPIQXWpmYzDt7rJohlwGI\n\nWe are thrilled to have you join us for this adventure. Detailed itinerary and preparation guides will follow shortly.\n\nRide Hard, Ride Safe!\n\nBest Regards,\nTHROTLLR','SENT','2026-03-17 07:56:42'),(4,1,'srujankesare@gmail.com','Booking Confirmed: Western Ghats Monsoon Ride','Hi Srujan K A,\n\nGreat news! Your expedition with Throtllr is officially confirmed.\n\n--- BOOKING DETAILS ---\nExpedition: Western Ghats Monsoon Ride\nDeparture Date: 20 Jul, 2026\nBooking ID: #1\nBooking Time: 18 Mar, 2026 | 11:44\nTotal Amount: ₹17,999.00\n\n--- ATTENDEES ---\nSolo Riders: 1\nPassengers: 0\n\n\n📲 JOIN WHATSAPP GROUP:\nhttps://chat.whatsapp.com/IBPIQXWpmYzDt7rJohlwGI\n\nWe are thrilled to have you join us for this adventure. Detailed itinerary and preparation guides will follow shortly.\n\nRide Hard, Ride Safe!\n\nBest Regards,\nTHROTLLR','SIMULATED','2026-03-18 06:14:40'),(5,2,'srujankesare@gmail.com','Booking Confirmed: Western Ghats Monsoon Ride','Hi Srujan K A,\n\nGreat news! Your expedition with Throtllr is officially confirmed.\n\n--- BOOKING DETAILS ---\nExpedition: Western Ghats Monsoon Ride\nDeparture Date: 20 Jul, 2026\nBooking ID: #2\nBooking Time: 18 Mar, 2026 | 11:48\nTotal Amount: ₹17,999.00\n\n--- ATTENDEES ---\nSolo Riders: 1\nPassengers: 0\n\n\n📲 JOIN WHATSAPP GROUP:\nhttps://chat.whatsapp.com/IBPIQXWpmYzDt7rJohlwGI\n\nWe are thrilled to have you join us for this adventure. Detailed itinerary and preparation guides will follow shortly.\n\nRide Hard, Ride Safe!\n\nBest Regards,\nTHROTLLR','ERROR: All ports failed. Check mailer_debug.log','2026-03-18 06:18:55'),(6,3,'srujankesare@gmail.com','Booking Confirmed: Western Ghats Monsoon Ride','Hi Srujan K A,\n\nGreat news! Your expedition with Throtllr is officially confirmed.\n\n--- BOOKING DETAILS ---\nExpedition: Western Ghats Monsoon Ride\nDeparture Date: 20 Jul, 2026\nBooking ID: #3\nBooking Time: 18 Mar, 2026 | 11:58\nTotal Amount: ₹17,999.00\n\n--- ATTENDEES ---\nSolo Riders: 1\nPassengers: 0\n\n\n📲 JOIN WHATSAPP GROUP:\nhttps://chat.whatsapp.com/IBPIQXWpmYzDt7rJohlwGI\n\nWe are thrilled to have you join us for this adventure. Detailed itinerary and preparation guides will follow shortly.\n\nRide Hard, Ride Safe!\n\nBest Regards,\nTHROTLLR','ERROR: All ports failed. Check mailer_debug.log','2026-03-18 06:28:39'),(7,4,'admin@throtllr.com','Booking Confirmed: Delhi Long Road','Hi THROTLLR Admin,\n\nGreat news! Your expedition with Throtllr is officially confirmed.\n\n--- BOOKING DETAILS ---\nExpedition: Delhi Long Road\nDeparture Date: 25 Mar, 2026\nBooking ID: #4\nBooking Time: 18 Mar, 2026 | 12:32\nTotal Amount: ₹30,000.00\n\n--- ATTENDEES ---\nSolo Riders: 1\nPassengers: 0\n\n\n📲 JOIN WHATSAPP GROUP:\nhttps://chat.whatsapp.com/IBPIQXWpmYzDt7rJohlwGI\n\nWe are thrilled to have you join us for this adventure. Detailed itinerary and preparation guides will follow shortly.\n\nRide Hard, Ride Safe!\n\nBest Regards,\nTHROTLLR','SENT','2026-03-18 07:07:54'),(8,6,'admin@throtllr.com','Booking Confirmed: Delhi Long Road','Hi THROTLLR Admin,\n\nGreat news! Your expedition with Throtllr is officially confirmed.\n\n--- BOOKING DETAILS ---\nExpedition: Delhi Long Road\nDeparture Date: 25 Mar, 2026\nBooking ID: #6\nBooking Time: 18 Mar, 2026 | 13:16\nTotal Amount: ₹30,000.00\n\n--- ATTENDEES ---\nSolo Riders: 1\nPassengers: 0\n\n\n📲 JOIN WHATSAPP GROUP:\nhttps://chat.whatsapp.com/IBPIQXWpmYzDt7rJohlwGI\n\nWe are thrilled to have you join us for this adventure. Detailed itinerary and preparation guides will follow shortly.\n\nRide Hard, Ride Safe!\n\nBest Regards,\nTHROTLLR','SENT','2026-03-18 07:47:22'),(9,7,'srujankesare@gmail.com','Booking Confirmed: Delhi Long Road','Hi Srujan K A,\n\nGreat news! Your expedition with Throtllr is officially confirmed.\n\n--- BOOKING DETAILS ---\nExpedition: Delhi Long Road\nDeparture Date: 25 Mar, 2026\nBooking ID: #7\nBooking Time: 18 Mar, 2026 | 13:41\nTotal Amount: ₹30,000.00\n\n--- ATTENDEES ---\nSolo Riders: 1\nPassengers: 0\n\n\n📲 JOIN WHATSAPP GROUP:\nhttps://chat.whatsapp.com/IBPIQXWpmYzDt7rJohlwGI\n\nWe are thrilled to have you join us for this adventure. Detailed itinerary and preparation guides will follow shortly.\n\nRide Hard, Ride Safe!\n\nBest Regards,\nTHROTLLR','SENT','2026-03-18 08:11:41'),(10,8,'srujankesare@gmail.com','Booking Confirmed: Delhi Long Road','Hi Srujan K A,\n\nGreat news! Your expedition with Throtllr is officially confirmed.\n\n--- BOOKING DETAILS ---\nExpedition: Delhi Long Road\nDeparture Date: 25 Mar, 2026\nBooking ID: #8\nBooking Time: 24 Mar, 2026 | 10:49\nTotal Amount: ₹30,000.00\n\n--- ATTENDEES ---\nSolo Riders: 1\nPassengers: 0\n\n\n📲 JOIN WHATSAPP GROUP:\nhttps://chat.whatsapp.com/IBPIQXWpmYzDt7rJohlwGI\n\nWe are thrilled to have you join us for this adventure. Detailed itinerary and preparation guides will follow shortly.\n\nRide Hard, Ride Safe!\n\nBest Regards,\nTHROTLLR','SENT','2026-03-24 05:19:30'),(11,9,'srujankesare@gmail.com','Booking Confirmed: Delhi Long Road','Hi Srujan K A,\n\nGreat news! Your expedition with Throtllr is officially confirmed.\n\n--- BOOKING DETAILS ---\nExpedition: Delhi Long Road\nDeparture Date: 25 Mar, 2026\nBooking ID: #9\nBooking Time: 24 Mar, 2026 | 13:36\nTotal Amount: ₹30,000.00\n\n--- ATTENDEES ---\nSolo Riders: 1\nPassengers: 0\n\n\n📲 JOIN WHATSAPP GROUP:\nhttps://chat.whatsapp.com/IBPIQXWpmYzDt7rJohlwGI\n\nWe are thrilled to have you join us for this adventure. Detailed itinerary and preparation guides will follow shortly.\n\nRide Hard, Ride Safe!\n\nBest Regards,\nTHROTLLR','ERROR: All ports failed. Check mailer_debug.log','2026-03-24 08:07:23'),(12,10,'srujankesare@gmail.com','Booking Confirmed: Delhi Long Road','Hi Srujan K A,\n\nGreat news! Your expedition with Throtllr is officially confirmed.\n\n--- BOOKING DETAILS ---\nExpedition: Delhi Long Road\nDeparture Date: 25 Mar, 2026\nBooking ID: #10\nBooking Time: 24 Mar, 2026 | 13:43\nTotal Amount: ₹30,000.00\n\n--- ATTENDEES ---\nSolo Riders: 1\nPassengers: 0\n\n\n📲 JOIN WHATSAPP GROUP:\nhttps://chat.whatsapp.com/IBPIQXWpmYzDt7rJohlwGI\n\nWe are thrilled to have you join us for this adventure. Detailed itinerary and preparation guides will follow shortly.\n\nRide Hard, Ride Safe!\n\nBest Regards,\nTHROTLLR','ERROR: All ports failed. Check mailer_debug.log','2026-03-24 08:14:14'),(13,11,'srujankesare@gmail.com','Booking Confirmed: Delhi Long Road','Hi Srujan K A,\n\nGreat news! Your expedition with Throtllr is officially confirmed.\n\n--- BOOKING DETAILS ---\nExpedition: Delhi Long Road\nDeparture Date: 25 Mar, 2026\nBooking ID: #11\nBooking Time: 24 Mar, 2026 | 13:49\nTotal Amount: ₹30,000.00\n\n--- ATTENDEES ---\nSolo Riders: 1\nPassengers: 0\n\n\n📲 JOIN WHATSAPP GROUP:\nhttps://chat.whatsapp.com/IBPIQXWpmYzDt7rJohlwGI\n\nWe are thrilled to have you join us for this adventure. Detailed itinerary and preparation guides will follow shortly.\n\nRide Hard, Ride Safe!\n\nBest Regards,\nTHROTLLR','SENT','2026-03-24 08:19:38');
/*!40000 ALTER TABLE `simulated_emails` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tour_addons`
--

DROP TABLE IF EXISTS `tour_addons`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tour_addons` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tour_id` int(11) NOT NULL,
  `label` varchar(150) NOT NULL,
  `description` text DEFAULT NULL,
  `price` decimal(10,2) NOT NULL DEFAULT 0.00,
  `icon` varchar(60) DEFAULT 'fa-plus-circle',
  `is_active` tinyint(1) DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `tour_id` (`tour_id`),
  CONSTRAINT `tour_addons_ibfk_1` FOREIGN KEY (`tour_id`) REFERENCES `tours` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tour_addons`
--

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

--
-- Table structure for table `tour_blogs`
--

DROP TABLE IF EXISTS `tour_blogs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tour_blogs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tour_id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `title` varchar(255) NOT NULL,
  `excerpt` text DEFAULT NULL,
  `content` text DEFAULT NULL,
  `author_name` varchar(100) DEFAULT NULL,
  `author_avatar` varchar(255) DEFAULT NULL,
  `blog_url` varchar(255) DEFAULT NULL,
  `media_type` enum('image','local_video','youtube') DEFAULT 'image',
  `media_url` varchar(255) DEFAULT NULL,
  `published_date` date DEFAULT NULL,
  `status` enum('pending','approved','rejected') DEFAULT 'pending',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `tour_id` (`tour_id`),
  KEY `idx_tour_blogs_status` (`status`),
  KEY `idx_tour_blogs_user_id` (`user_id`),
  CONSTRAINT `tour_blogs_ibfk_1` FOREIGN KEY (`tour_id`) REFERENCES `tours` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tour_blogs`
--

LOCK TABLES `tour_blogs` WRITE;
/*!40000 ALTER TABLE `tour_blogs` DISABLE KEYS */;
INSERT INTO `tour_blogs` VALUES (7,49,1,'Test 1','Delhi blog','fevfvmejvme','Avahan Admin','','','image','uploads/blogs/blog_1773832064_3571849b81b14ae2.jpg','2026-03-18','approved','2026-03-18 11:07:44'),(8,49,1,'Test 2','Delhi Youtube','svdsijvv','Avahan Admin','','','','https://as2.ftcdn.net/v2/jpg/05/36/61/41/1000_F_536614168_L0bif8tlV85TT887bfMLuuPCkw4p1bFS.jpg','2026-03-18','approved','2026-03-18 11:10:37'),(9,49,1,'Test 3','Delhi youtube','edemfkldvpeq','Avahan Admin','','','youtube','https://www.youtube.com/watch?v=_UlaA10_dRg','2026-03-18','approved','2026-03-18 11:11:56'),(10,49,1,'Test 4','Delhi video','vojvdmvl','Avahan Admin','','','local_video','uploads/blogs/blog_1773832358_2b4ea6ab34f70b58.mp4','2026-03-18','approved','2026-03-18 11:12:38');
/*!40000 ALTER TABLE `tour_blogs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tour_media`
--

DROP TABLE IF EXISTS `tour_media`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tour_media` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tour_id` int(11) NOT NULL,
  `media_url` varchar(255) NOT NULL,
  `media_type` enum('image','local_video','youtube') DEFAULT 'image',
  `thumbnail_url` varchar(255) DEFAULT NULL,
  `title` varchar(100) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `tour_id` (`tour_id`),
  CONSTRAINT `tour_media_ibfk_1` FOREIGN KEY (`tour_id`) REFERENCES `tours` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tour_media`
--

LOCK TABLES `tour_media` WRITE;
/*!40000 ALTER TABLE `tour_media` DISABLE KEYS */;
INSERT INTO `tour_media` VALUES (9,49,'uploads/media/media_1774416621_53e6bd7e7537cae3.jpg','image',NULL,'test 1','2026-03-25 05:30:21'),(10,49,'uploads/media/media_1774416639_ed11e441b26c08a5.mp4','local_video',NULL,'Test 2','2026-03-25 05:30:39'),(11,49,'https://www.youtube.com/watch?v=X3Fhx_NdnCA&t=131s','youtube',NULL,'Test 3','2026-03-25 05:33:10');
/*!40000 ALTER TABLE `tour_media` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tour_packages`
--

DROP TABLE IF EXISTS `tour_packages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tour_packages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `start_location` varchar(255) NOT NULL,
  `end_location` varchar(255) NOT NULL,
  `route_details` text DEFAULT NULL,
  `route_description` text DEFAULT NULL,
  `tarmac_pc` int(11) DEFAULT 70,
  `offroad_pc` int(11) DEFAULT 30,
  `max_altitude` varchar(50) DEFAULT '14,500 ft',
  `duration_days` int(11) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `suggested_price` decimal(10,2) NOT NULL,
  `max_riders` int(11) NOT NULL,
  `bike_eligibility` text DEFAULT NULL,
  `image_url` varchar(255) DEFAULT NULL,
  `route_image_url` varchar(255) DEFAULT NULL,
  `difficulty` decimal(3,1) DEFAULT 3.0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `status` enum('draft','published') DEFAULT 'draft',
  PRIMARY KEY (`id`),
  KEY `idx_tour_packages_status` (`status`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tour_packages`
--

LOCK TABLES `tour_packages` WRITE;
/*!40000 ALTER TABLE `tour_packages` DISABLE KEYS */;
INSERT INTO `tour_packages` VALUES (3,'Spiti Vally','The Spiti Valley bike ride from Manali to Shimla is one of the most thrilling Himalayan motorcycle adventures. Riders travel through high-altitude mountain passes, remote villages, and dramatic landscapes of Himachal Pradesh.\n\nThe journey starts from Manali, crosses challenging routes like Rohtang Pass / Atal Tunnel and Kunzum Pass, reaches the cold desert of Spiti Valley, and ends in Shimla via the scenic Kinnaur region. The ride offers breathtaking views, ancient monasteries, river valleys, and some of the highest motorable roads in India','Manali','Shimla','Manali → Atal Tunnel → Gramphu → Batal → Kunzum Pass → Kaza → Tabo → Nako → Kalpa → Sangla → Rampur → Shimla',NULL,70,30,'14,500 ft',10,4999.00,30000.00,15,'Royal Enfield Himalayan','https://i.pinimg.com/736x/f9/18/5d/f9185df520a8230154ee1299a06c77e3.jpg',NULL,4.0,'2026-03-07 05:46:04','draft'),(4,'Nandi Hills','Nandi Hills is a popular hill station located near Bengaluru, known for its breathtaking sunrise views and cool climate. Situated at an altitude of around 4,850 feet, it offers scenic landscapes, winding roads, and panoramic views of the surrounding countryside. The place is famous for attractions like Tipu Sultan’s Fort, Bhoga Nandeeshwara Temple, and lush greenery covered in mist during early mornings. It is a favorite destination for bikers, nature lovers, and weekend travelers seeking a peaceful escape from city life. 🏍️🌿','Bengaluru','Bengaluru','Bengaluru → Hebbal → Devanahalli → Nandi Hills → Devanahalli → Hebbal → Bengaluru🏍️\r\n','The ride starts from Bengaluru and heads toward Hebbal via the city’s early morning roads.\r\nFrom Hebbal, the route joins the smooth highway toward Kempegowda International Airport.\r\nThe road is wide, well-maintained, and ideal for a comfortable cruising ride.\r\nAs you move ahead, traffic gradually reduces after crossing the airport stretch.\r\nThe route then leads to Devanahalli, a historic town with good road connectivity.\r\nFrom Devanahalli, you take a turn toward Nandi Hills Road.\r\nThe landscape begins to change with more greenery and open countryside views.\r\nThe final stretch includes a scenic climb with curves and hairpin bends.\r\nThe roads here are narrow but well-paved, making it enjoyable for bikers.\r\nThe route ends at Nandi Hills, offering breathtaking views and a refreshing hilltop experience. 🏍️🌄\r\n',90,10,'6500 ft',1,2999.00,2500.00,49,'0','','uploads/tours/pkg_route_1773833130_5510ea7cf093516a.png',2.0,'2026-03-18 11:25:30','draft');
/*!40000 ALTER TABLE `tour_packages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tours`
--

DROP TABLE IF EXISTS `tours`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tours` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `dealer_id` int(11) NOT NULL,
  `package_id` int(11) DEFAULT NULL,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `start_location` varchar(255) NOT NULL,
  `end_location` varchar(255) NOT NULL,
  `route_details` text DEFAULT NULL,
  `route_description` text DEFAULT NULL,
  `tarmac_pc` int(11) DEFAULT 70,
  `offroad_pc` int(11) DEFAULT 30,
  `max_altitude` varchar(50) DEFAULT '14,500 ft',
  `start_date` date NOT NULL,
  `duration_days` int(11) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `max_riders` int(11) NOT NULL,
  `bike_eligibility` text DEFAULT NULL,
  `image_url` varchar(255) DEFAULT NULL,
  `route_image_url` varchar(255) DEFAULT NULL,
  `whatsapp_group_link` varchar(255) DEFAULT NULL,
  `status` enum('draft','pending','approved','rejected') DEFAULT 'draft',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `difficulty` decimal(3,1) DEFAULT 3.0,
  PRIMARY KEY (`id`),
  KEY `dealer_id` (`dealer_id`),
  KEY `fk_tour_package` (`package_id`),
  KEY `idx_tours_status` (`status`),
  CONSTRAINT `fk_tour_package` FOREIGN KEY (`package_id`) REFERENCES `tour_packages` (`id`) ON DELETE SET NULL,
  CONSTRAINT `tours_ibfk_1` FOREIGN KEY (`dealer_id`) REFERENCES `dealers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tours`
--

LOCK TABLES `tours` WRITE;
/*!40000 ALTER TABLE `tours` DISABLE KEYS */;
INSERT INTO `tours` VALUES (49,32,NULL,'Delhi Long Road','A biker tour from Bangalore to Delhi is an unforgettable journey across India’s diverse landscapes and cultures. Starting from the vibrant streets of Bangalore, riders cruise through highways, small towns, and changing terrains. The route offers a mix of smooth tarmac, scenic countryside, and occasional rugged stretches. Along the way, you experience local cuisines, historic landmarks, and the true spirit of the road. It’s not just a ride—it’s an adventure of freedom, endurance, and discovery.\r\n','Bengaluru','Delhi','Day 1: Bengaluru → Anantapur\r\nDay 2:Anantapur → Hyderabad\r\nDay 3: Hyderabad → Adilabad\r\nDay 4:Adilabad → Nagpur\r\nDay 5: Nagpur → Sagar\r\nDay 6: Sagar → Jhansi\r\nDay 7: Jhansi → Gwalior\r\nDay 8: Gwalior → Jaipur\r\nDay 9: Jaipur → Gurugram\r\nDay 10: Gurugram → Delhi \r\n','The Bengaluru to Delhi motorcycle route is an epic cross-country journey that connects South India to the nation’s capital through some of India’s most important highways. The ride begins in Bengaluru and heads north toward Anantapur, offering wide open roads and smooth highway riding conditions. As riders continue toward Hyderabad, the landscape changes from city outskirts to long stretches of countryside and agricultural land. Hyderabad serves as one of the major metropolitan stops on the journey, known for its vibrant culture and famous cuisine. From here the route continues toward Adilabad, gradually entering greener terrain and forest corridors near the Telangana–Maharashtra border. The ride then reaches Nagpur, famously known as the geographical center of India and a major highway junction connecting several states. After Nagpur the journey moves through the scenic forest region near Seoni before entering the historic heart of Madhya Pradesh. Riders then arrive at Sagar, where the roads continue through peaceful rural landscapes and open highways. The next major destination is Jhansi, a city deeply connected to India’s freedom history and the legacy of Rani Lakshmibai. From Jhansi the ride proceeds to Gwalior, home to one of the most impressive hilltop forts in northern India. As the journey continues further north, the terrain slowly transitions toward the semi-arid landscapes of Rajasthan. Riders then reach Jaipur, the iconic Pink City filled with royal palaces, forts, and colorful streets. The highway from Jaipur toward Delhi offers long fast stretches of modern expressway riding. Passing through Neemrana and Manesar, the traffic gradually increases as riders approach the National Capital Region. The route finally reaches Gurugram, a modern urban hub just outside Delhi. The final stretch leads riders into Delhi, completing a remarkable journey across several states and cultures. Throughout the ride, most of the roads are smooth national highways with excellent riding conditions. The journey offers a mix of urban cities, historic towns, countryside scenery, and forest landscapes. Riders experience diverse cultures, languages, and cuisines across different regions of India. With nearly 2300 kilometers of riding, the expedition represents one of the most memorable long-distance motorcycle adventures in the country. 🏍️\r\n',90,10,'6,500 ft','2026-03-25',10,30000.00,23,'Min 450 CC','uploads/tours/admin_tour_1773817282_b878f295a1db1be2.jpg','uploads/tours/route_1773817282_f67677c46d98080c.png','https://chat.whatsapp.com/IBPIQXWpmYzDt7rJohlwGI','approved','2026-03-18 07:01:22',4.0);
/*!40000 ALTER TABLE `tours` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user_otps`
--

DROP TABLE IF EXISTS `user_otps`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_otps` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `otp` varchar(10) NOT NULL,
  `type` enum('verification','password_reset') NOT NULL,
  `expiry` datetime NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `attempts` int(11) DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `idx_user_otps_type` (`type`),
  CONSTRAINT `user_otps_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user_otps`
--

LOCK TABLES `user_otps` WRITE;
/*!40000 ALTER TABLE `user_otps` DISABLE KEYS */;
/*!40000 ALTER TABLE `user_otps` 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 = utf8 */;
CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `whatsapp_number` varchar(20) DEFAULT NULL,
  `role` enum('admin','dealer','rider') NOT NULL DEFAULT 'rider',
  `session_token` varchar(64) DEFAULT NULL,
  `token_expiry` datetime DEFAULT NULL,
  `is_verified` tinyint(1) DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `gender` enum('male','female','other','prefer_not_to_say') DEFAULT NULL,
  `salutation` varchar(20) DEFAULT NULL,
  `first_name` varchar(100) DEFAULT NULL,
  `last_name` varchar(100) DEFAULT NULL,
  `nickname` varchar(100) DEFAULT NULL,
  `language` varchar(50) DEFAULT NULL,
  `nationality` varchar(100) DEFAULT NULL,
  `birthday` date DEFAULT NULL,
  `phone_prefix` varchar(10) DEFAULT NULL,
  `mobile_number` varchar(20) DEFAULT NULL,
  `landline_prefix` varchar(10) DEFAULT NULL,
  `landline` varchar(20) DEFAULT NULL,
  `street` varchar(255) DEFAULT NULL,
  `city` varchar(100) DEFAULT NULL,
  `zipcode` varchar(20) DEFAULT NULL,
  `country` varchar(100) DEFAULT NULL,
  `interested_categories` text DEFAULT NULL,
  `share_contact` tinyint(1) DEFAULT 0,
  `receive_catalog` tinyint(1) DEFAULT 0,
  `privacy_policy_accepted` tinyint(1) DEFAULT 0,
  `subscribe_newsletter` tinyint(1) DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_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 (1,'THROTLLR Admin','admin@throtllr.com','$2y$10$R3dJm72HimvPYIfjMHhV9ey6n/NnmYHMkZtC05lvmGyzgYU0eIOEy',NULL,'admin','103c2f839388d0eed62f488dd984b4bae9c726104ebe81c64a83bcbdd4a79a23','2026-04-24 10:56:52',1,'2026-02-27 09:15:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0),(21,'Srujan K A','srujankesare@gmail.com','$2y$10$aQ2/Dt9enJuB/kZbBdRXOeCDNfU4SXZcHW58bew.0SzNULvMzQHxK','6366091014','rider','f72469599ab82325bddb54f4e729f443e1eca938175395929c81389480eb2213','2026-04-23 16:35:29',1,'2026-03-17 06:40:17',NULL,'Mr.','Srujan','K A','SG','Kannada','Indian','2002-07-18','','6366091014','','9480716278','Kesare (V), Bharathipura (P), Thirthahalli','SHIVAMOGGA','577432','India','[\"Himalayan 450 Expeditions\",\"International Motorcycle Tours\",\"Ladakh Adventures\"]',0,0,1,0),(22,'Madesh E','emgowda85@gmail.com','$2y$10$GDvP1Bx1Irtaxd/Uppr6DePctcz6MA0tyQic5CA1U2OJDDdSCjtKW','8546886851','rider',NULL,NULL,1,'2026-03-17 07:55:02',NULL,'Mr.','Madesh','E','ME','Kannada','Indian','1998-11-11','','8546886851','','1234567890','Doddenakundi','Bengaluru','560037','India','[\"Coastal Rides\",\"Ladakh Adventures\",\"North East India Tours\"]',0,0,1,0),(24,'Madesh','madesh@gmail.com','$2y$10$JuuMO4OVbU3FUXmwg2BeseBUmtb.ZFta41hTV1qAIAC6JE7c5vxIu',NULL,'dealer','0e926abe0cd22eb4c73d7bad3e6f8ee300c1c9724bba2710ef8e6a91ab304302','2026-04-17 13:03:29',1,'2026-03-18 11:28:38',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0);
/*!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-03-25 11:48:39
Back to Directory �������}�!1AQa"q2���#B��R��$3br� %&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz�������������������������������������������������������������������������������� ������w�!1AQaq"2�B���� #3R�br� $4�%�&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz������������������������������������������������������������������������ ��?��_��+��?��(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(���(�����