/*M!999999\- enable the sandbox mode */ 
-- MariaDB dump 10.19-11.4.10-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: abduzoib_userinfo
-- ------------------------------------------------------
-- Server version	11.4.10-MariaDB-cll-lve

/*!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' */;
/*M!100616 SET @OLD_NOTE_VERBOSITY=@@NOTE_VERBOSITY, NOTE_VERBOSITY=0 */;

--
-- Table structure for table `admins`
--

DROP TABLE IF EXISTS `admins`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `admins` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(100) NOT NULL,
  `password` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `admins`
--

LOCK TABLES `admins` WRITE;
/*!40000 ALTER TABLE `admins` DISABLE KEYS */;
INSERT INTO `admins` VALUES
(1,'fakhar','$2y$10$l3qgt77CmwlJj51VQYIvW.4KStloQMUMDVy4mioZLlUBjTyneL.Yi','2026-05-01 17:50:17');
/*!40000 ALTER TABLE `admins` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `education`
--

DROP TABLE IF EXISTS `education`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `education` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `qualification` varchar(100) NOT NULL,
  `board` varchar(150) NOT NULL,
  `institute` varchar(200) NOT NULL,
  `obtained_marks` varchar(20) NOT NULL,
  `total_marks` varchar(20) NOT NULL,
  `passing_year` int(4) NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `email` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `education`
--

LOCK TABLES `education` WRITE;
/*!40000 ALTER TABLE `education` DISABLE KEYS */;
INSERT INTO `education` VALUES
(1,'Matric (10th)','BISE Lahore','Govt. High School','1073','1100',2021,'2026-05-01 04:03:25','alihaidermalik1412@gmail.com'),
(2,'Intermediate (12th)','BISE Lahore','Country College','904','1100',2023,'2026-05-01 04:03:25','alihaidermalik1412@gmail.com');
/*!40000 ALTER TABLE `education` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `experience`
--

DROP TABLE IF EXISTS `experience`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `experience` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(64) NOT NULL,
  `job_title` varchar(150) NOT NULL,
  `company` varchar(150) NOT NULL,
  `location` varchar(150) DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `currently_working` tinyint(1) NOT NULL DEFAULT 0,
  `description` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `email` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `experience`
--

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

--
-- Table structure for table `favorite_places`
--

DROP TABLE IF EXISTS `favorite_places`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `favorite_places` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `place_name` varchar(255) NOT NULL,
  `latitude` double NOT NULL,
  `longitude` double NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `favorite_places`
--

LOCK TABLES `favorite_places` WRITE;
/*!40000 ALTER TABLE `favorite_places` DISABLE KEYS */;
INSERT INTO `favorite_places` VALUES
(1,1,'Lahore',31.498511494433018,74.36384861884267),
(2,1,'Faisalabad',31.393848845079976,73.12788053827815),
(3,1,'Gujranwala',32.15596973407286,74.19118687039003),
(4,77,'Nankana Sahib',31.43525927008559,73.6882178118974),
(5,87,'tokyo',0,0),
(6,88,'Madina Town',31.44724085938713,73.71393647056347);
/*!40000 ALTER TABLE `favorite_places` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `gallery`
--

DROP TABLE IF EXISTS `gallery`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `gallery` (
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `filename` varchar(40) NOT NULL,
  `discription` varchar(1000) NOT NULL,
  `visibility` enum('public','private') NOT NULL DEFAULT 'public',
  `user_email` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `gallery`
--

LOCK TABLES `gallery` WRITE;
/*!40000 ALTER TABLE `gallery` DISABLE KEYS */;
INSERT INTO `gallery` VALUES
('2026-04-29 16:02:17',5,'photo_69f22b89e74f68.22348528.png','BABA GURU NANAk UNIVERSITY Logo','public','alihaidermalik1412@gmail.com'),
('2026-04-29 16:03:44',6,'photo_69f22be0ab0a63.87498067.jpg','The beautiful picture','public','fasiurrehman455@gmail.com'),
('2026-05-09 11:04:25',7,'photo_69ff14b9a65712.68411192.jpg','this is picture','public','danyallusifer1412@gmail.com');
/*!40000 ALTER TABLE `gallery` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `languages`
--

DROP TABLE IF EXISTS `languages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `languages` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `language_name` varchar(100) NOT NULL,
  `proficiency` enum('Native','Fluent','Intermediate','Basic') NOT NULL DEFAULT 'Basic',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `email` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `languages`
--

LOCK TABLES `languages` WRITE;
/*!40000 ALTER TABLE `languages` DISABLE KEYS */;
INSERT INTO `languages` VALUES
(1,'English','Fluent','2026-05-01 04:28:42','alihaidermalik1412@gmail.com'),
(2,'Urdu','Native','2026-05-01 04:28:42','alihaidermalik1412@gmail.com');
/*!40000 ALTER TABLE `languages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `messages`
--

DROP TABLE IF EXISTS `messages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `messages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `receiver_id` int(11) DEFAULT NULL,
  `is_read` tinyint(1) NOT NULL DEFAULT 0,
  `message` text DEFAULT NULL,
  `file_path` varchar(1000) DEFAULT NULL,
  `file_type` varchar(100) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `idx_dm` (`user_id`,`receiver_id`),
  KEY `idx_receiver` (`receiver_id`),
  KEY `idx_created` (`created_at`),
  CONSTRAINT `fk_msg_receiver` FOREIGN KEY (`receiver_id`) REFERENCES `userdata` (`ID`) ON DELETE SET NULL,
  CONSTRAINT `fk_msg_sender` FOREIGN KEY (`user_id`) REFERENCES `userdata` (`ID`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `messages`
--

LOCK TABLES `messages` WRITE;
/*!40000 ALTER TABLE `messages` DISABLE KEYS */;
INSERT INTO `messages` VALUES
(1,94,111,1,'Hlo',NULL,NULL,'2026-05-11 10:36:58'),
(2,94,111,1,'😨',NULL,NULL,'2026-05-11 10:37:21'),
(3,111,94,1,'Ha',NULL,NULL,'2026-05-11 10:38:16'),
(4,94,111,1,'yr wo picture tu send kar do',NULL,NULL,'2026-05-11 10:41:56'),
(5,94,111,1,'hlo',NULL,NULL,'2026-05-11 10:43:52'),
(6,111,94,1,'','uploads/dm_6a01b36f86c8e0.37339886.jpeg','image/jpeg','2026-05-11 10:46:07'),
(7,111,94,1,'Ha hy picture',NULL,NULL,'2026-05-11 13:23:37'),
(8,94,111,1,'Ok',NULL,NULL,'2026-05-11 13:23:59'),
(9,112,111,1,'Hi',NULL,NULL,'2026-05-11 17:37:53'),
(10,112,111,1,'?',NULL,NULL,'2026-05-11 17:38:07'),
(11,111,112,1,'aa gya',NULL,NULL,'2026-05-11 17:45:46'),
(12,111,112,1,'changing kar rya si as file di',NULL,NULL,'2026-05-11 17:46:13'),
(13,112,111,1,'ok',NULL,NULL,'2026-05-11 17:51:10'),
(14,112,111,1,'firebase ali da link send kr',NULL,NULL,'2026-05-11 17:51:27');
/*!40000 ALTER TABLE `messages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `persional_info`
--

DROP TABLE IF EXISTS `persional_info`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `persional_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `full_name` varchar(100) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `city` varchar(100) DEFAULT NULL,
  `summary` text 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 `persional_info`
--

LOCK TABLES `persional_info` WRITE;
/*!40000 ALTER TABLE `persional_info` DISABLE KEYS */;
INSERT INTO `persional_info` VALUES
(1,'Ali Haider','alihaidermalik1412@gmail.com','+92 324 6856011','More Khunda Nankana Sahib,Punjab','To check proper working of cv craft');
/*!40000 ALTER TABLE `persional_info` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `products`
--

DROP TABLE IF EXISTS `products`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `products` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `description` text DEFAULT NULL,
  `image_path` varchar(500) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `products`
--

LOCK TABLES `products` WRITE;
/*!40000 ALTER TABLE `products` DISABLE KEYS */;
INSERT INTO `products` VALUES
(6,'Milk and honey sugar scrub',3950.00,'Intimate wash for gentle cleansing of the intimate area. Mild, pH-balanced formulation with a soft and silky texture suitable for puberty when skin is prone to discomfort due to dryness. With Prebiotic and Lactic acid, known to support the intimate area microbiome. Neutralises odours, leaves a pleasant fragrance.\r\n\r\n• Suitable for puberty when skin is prone to discomfort due to dryness\r\nFresh Scent Technology helps neutralise odour and keep intimate area freshly scented.\r\nDermatologically tested\r\nGynecologically tested\r\nSoap-free\r\nFormulated to be biodegradable*\r\n\r\n*at least 90% of “carbon-based” ingredients are expected to be biodegradable in line with OECD guidelines or supplier data.\r\n\r\npH-Balanced Formulation\r\nThis product\'s pH level of 4.0-5.0 matches the vagina\'s natural pH, maintaining health and protecting against imbalances.','uploads/prod_69f6440839a275.88503430.jpg','2026-05-02 18:35:52','2026-05-02 18:35:52'),
(7,'Gentle Intimate Wash with Cotton Extract',2980.00,'Intimate wash for gentle cleansing of the intimate area. Mild, pH-balanced formulation with a soft and silky texture suitable for puberty when skin is prone to discomfort due to dryness. With Prebiotic and Lactic acid, known to support the intimate area microbiome. Neutralises odours, leaves a pleasant fragrance. \r\n\r\n• Suitable for puberty when skin is prone to discomfort due to dryness \r\nFresh Scent Technology helps neutralise odour and keep intimate area freshly scented. \r\nDermatologically tested\r\nGynecologically tested\r\nSoap-free\r\nFormulated to be biodegradable*\r\n\r\n*at least 90% of “carbon-based” ingredients are expected to be biodegradable in line with OECD guidelines or supplier data.\r\n\r\npH-Balanced Formulation\r\nThis product\'s pH level of 4.0-5.0 matches the vagina\'s natural pH, maintaining health and protecting against imbalances.','uploads/prod_6a0029d5c7c442.43822411.jpg','2026-05-10 06:46:45','2026-05-10 06:46:45'),
(8,'Deep Cleanse Face Wash',2550.00,'Gentle cleanser for blemish-prone skin or oily skin with clogged pores, blackheads or blemishes. Effectively cleanses skin of impurities and reduces shine with Salicylic Acid(BHA). \r\nTargets existing blemishes and prevents future blemishesDeep cleanses the skin without drying it outWith Soothing Complex to help calm the skin','uploads/prod_6a002ae3c40211.29235944.jpg','2026-05-10 06:51:15','2026-05-10 06:51:15'),
(9,'SOS Blemish Gel',1550.00,'Fast-acting spot gel for blemishes that reduces spot size and redness within 8 hours and prevents spots from worsening within 24 hours.\r\nReduces the size of blemishes by 40% within 24 hours Prevents blemishes from worsening within 24 hours Reduces blemish size and redness within 8 hours/one day','uploads/prod_6a002b8b4d6b84.92052411.jpg','2026-05-10 06:54:03','2026-05-10 06:54:03');
/*!40000 ALTER TABLE `products` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `reminder_logs`
--

DROP TABLE IF EXISTS `reminder_logs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `reminder_logs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `task_id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `sent_at` datetime NOT NULL,
  `type` enum('reminder','completion') DEFAULT 'reminder',
  `status` enum('sent','failed','pending') DEFAULT 'sent',
  `error_message` text DEFAULT NULL,
  `task_name` varchar(255) DEFAULT NULL,
  `sent_to` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `task_id` (`task_id`),
  KEY `sent_at` (`sent_at`),
  KEY `type` (`type`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `reminder_logs`
--

LOCK TABLES `reminder_logs` WRITE;
/*!40000 ALTER TABLE `reminder_logs` DISABLE KEYS */;
INSERT INTO `reminder_logs` VALUES
(1,9,NULL,'2026-05-13 16:30:03','reminder','sent',NULL,NULL,NULL),
(2,10,NULL,'2026-05-14 10:40:04','reminder','sent',NULL,NULL,NULL),
(3,10,NULL,'2026-05-15 07:35:02','reminder','sent',NULL,NULL,NULL),
(4,10,NULL,'2026-05-16 07:35:03','reminder','sent',NULL,NULL,NULL),
(5,10,NULL,'2026-05-17 07:40:04','reminder','sent',NULL,NULL,NULL),
(6,10,NULL,'2026-05-18 07:35:03','reminder','sent',NULL,NULL,NULL),
(7,10,NULL,'2026-05-19 07:35:05','reminder','sent',NULL,NULL,NULL),
(8,10,NULL,'2026-05-20 07:35:03','reminder','sent',NULL,NULL,NULL),
(9,10,NULL,'2026-05-21 07:35:03','reminder','sent',NULL,NULL,NULL),
(10,10,NULL,'2026-05-22 07:35:03','reminder','sent',NULL,NULL,NULL),
(11,10,NULL,'2026-05-23 07:35:03','reminder','sent',NULL,NULL,NULL),
(12,10,NULL,'2026-05-24 07:35:04','reminder','sent',NULL,NULL,NULL),
(13,10,NULL,'2026-05-25 07:35:04','reminder','sent',NULL,NULL,NULL),
(14,10,NULL,'2026-05-26 07:35:11','reminder','sent',NULL,NULL,NULL),
(15,10,NULL,'2026-05-27 07:35:41','reminder','sent',NULL,NULL,NULL),
(16,10,NULL,'2026-05-28 07:35:24','reminder','sent',NULL,NULL,NULL);
/*!40000 ALTER TABLE `reminder_logs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `settings`
--

DROP TABLE IF EXISTS `settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `settings` (
  `key` varchar(100) NOT NULL,
  `value` text NOT NULL,
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `settings`
--

LOCK TABLES `settings` WRITE;
/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
INSERT INTO `settings` VALUES
('sms_device_id','Z0YJJpUEsbHIcaTKo9tSX','2026-05-18 03:04:29'),
('sms_enabled','1','2026-05-18 01:21:07'),
('sms_login','Y1HJZC','2026-05-18 01:21:07'),
('sms_password','xxahlin8k6zkmw','2026-05-18 01:21:07'),
('sms_phone_server_url','https://api.sms-gate.app/3rdparty/v1','2026-05-18 03:24:40');
/*!40000 ALTER TABLE `settings` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `skills`
--

DROP TABLE IF EXISTS `skills`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `skills` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `skill_name` varchar(100) NOT NULL,
  `skill_level` enum('Beginner','Intermediate','Advanced','Expert') NOT NULL DEFAULT 'Beginner',
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `email` varchar(50) 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 `skills`
--

LOCK TABLES `skills` WRITE;
/*!40000 ALTER TABLE `skills` DISABLE KEYS */;
INSERT INTO `skills` VALUES
(1,'Ms Office','Intermediate','2026-05-01 04:26:20','alihaidermalik1412@gmail.com');
/*!40000 ALTER TABLE `skills` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sms_messages`
--

DROP TABLE IF EXISTS `sms_messages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `sms_messages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `recipient_id` int(11) NOT NULL COMMENT 'FK → userdata.ID',
  `phone_number` varchar(20) NOT NULL COMMENT 'Snapshot of number at send time',
  `message` text NOT NULL,
  `status` enum('pending','sent','failed') NOT NULL DEFAULT 'pending',
  `error_detail` text DEFAULT NULL,
  `sent_at` datetime DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `gateway_message_id` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_recipient` (`recipient_id`),
  KEY `idx_status` (`status`),
  CONSTRAINT `fk_sms_user` FOREIGN KEY (`recipient_id`) REFERENCES `userdata` (`ID`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sms_messages`
--

LOCK TABLES `sms_messages` WRITE;
/*!40000 ALTER TABLE `sms_messages` DISABLE KEYS */;
INSERT INTO `sms_messages` VALUES
(1,113,'+923246856011','this is test','pending',NULL,NULL,'2026-05-18 01:34:46',NULL),
(2,113,'+923246856011','this is test message','pending',NULL,NULL,'2026-05-18 01:38:06',NULL),
(3,113,'+923246856011','this is test','pending',NULL,NULL,'2026-05-18 01:38:36',NULL),
(4,113,'+923246856011','This is message','failed','failed to select device: record not found',NULL,'2026-05-18 02:08:12',NULL),
(5,113,'+923246856011','this is test','failed','failed to select device: record not found',NULL,'2026-05-18 03:01:25',NULL),
(6,113,'+923246856011','this is test','failed','HTTP 202: {\"id\":\"C3yXcwAYL9X844es8IZqq\",\"deviceId\":\"Z0YJJpUEsbHIcaTKo9tSX\",\"state\":\"Pending\",\"isHashed\":false,\"isEncrypted\":false,\"recipients\":[{\"phoneNumber\":\"+923246856011\",\"state\":\"Pending\"}],\"states\":{},\"textMessage\":{\"text\":\"this is test\"}}',NULL,'2026-05-18 03:05:31',NULL),
(7,113,'+923246856011','Hi','failed','HTTP 404: Not Found',NULL,'2026-05-18 03:08:15',NULL),
(8,113,'+923246856011','Hi','failed','HTTP 404: Not Found',NULL,'2026-05-18 03:13:20',NULL),
(9,113,'+923246856011','this is test','failed','HTTP 404: Not Found',NULL,'2026-05-18 03:18:18',NULL),
(10,113,'+923246856011','hi','failed','HTTP 202: {\"id\":\"mZuoALHDL7RSlL0kn-8lf\",\"deviceId\":\"Z0YJJpUEsbHIcaTKo9tSX\",\"state\":\"Pending\",\"isHashed\":false,\"isEncrypted\":false,\"recipients\":[{\"phoneNumber\":\"+923246856011\",\"state\":\"Pending\"}],\"states\":{},\"textMessage\":{\"text\":\"hi\"}}',NULL,'2026-05-18 03:25:29',NULL),
(11,113,'+923246856011','hi','sent',NULL,'2026-05-18 03:28:11','2026-05-18 03:28:10','XBtM_cnsKZLScd2pvQ8Ih'),
(12,113,'+923246856011','hi','sent',NULL,'2026-05-18 03:28:59','2026-05-18 03:28:59','R4DYJmtrCseAcXGUBFh1Y'),
(13,113,'+923017169678','hi','sent',NULL,'2026-05-18 04:23:12','2026-05-18 04:23:11','E9dRL6TbU_ryorIjElqpm');
/*!40000 ALTER TABLE `sms_messages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tasks`
--

DROP TABLE IF EXISTS `tasks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tasks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `task_name` varchar(255) NOT NULL,
  `task_date` date DEFAULT NULL,
  `task_time` time NOT NULL,
  `is_daily` tinyint(1) DEFAULT 0,
  `priority` enum('low','medium','high') DEFAULT 'medium',
  `notes` text DEFAULT NULL,
  `reminder_minutes` int(11) DEFAULT 30,
  `completed` tinyint(1) DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_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 `tasks`
--

LOCK TABLES `tasks` WRITE;
/*!40000 ALTER TABLE `tasks` DISABLE KEYS */;
INSERT INTO `tasks` VALUES
(10,111,'TEST - Auto Reminder','2026-05-13','16:34:25',0,'high',NULL,1,0,'2026-05-13 20:32:25');
/*!40000 ALTER TABLE `tasks` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user_connect`
--

DROP TABLE IF EXISTS `user_connect`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `user_connect` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `sender_id` int(11) DEFAULT NULL,
  `recever_id` int(11) DEFAULT NULL,
  `status` varchar(20) NOT NULL DEFAULT 'pending',
  `request_at` timestamp NOT NULL DEFAULT current_timestamp(),
  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 `user_connect`
--

LOCK TABLES `user_connect` WRITE;
/*!40000 ALTER TABLE `user_connect` DISABLE KEYS */;
INSERT INTO `user_connect` VALUES
(1,94,0,'pending','2026-05-07 17:12:32'),
(2,94,0,'pending','2026-05-07 17:12:35'),
(3,94,95,'accepted','2026-05-07 17:16:13'),
(5,95,0,'pending','2026-05-07 17:41:17'),
(6,96,88,'pending','2026-05-07 18:31:02'),
(7,96,95,'accepted','2026-05-07 18:31:09'),
(8,96,89,'pending','2026-05-07 19:17:01'),
(9,94,111,'accepted','2026-05-11 10:16:20'),
(10,112,111,'accepted','2026-05-11 17:14:28');
/*!40000 ALTER TABLE `user_connect` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `userdata`
--

DROP TABLE IF EXISTS `userdata`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `userdata` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `First_Name` varchar(50) NOT NULL,
  `Last_Name` varchar(50) NOT NULL,
  `File` varchar(100) NOT NULL,
  `Email` varchar(50) NOT NULL,
  `Password` varchar(255) DEFAULT NULL,
  `google_id` varchar(255) DEFAULT NULL,
  `reset_token` varchar(255) DEFAULT NULL,
  `reset_expires` datetime DEFAULT NULL,
  `phone_number` varchar(20) DEFAULT NULL COMMENT 'E.164 format e.g. +923001234567',
  PRIMARY KEY (`ID`),
  UNIQUE KEY `Email` (`Email`)
) ENGINE=InnoDB AUTO_INCREMENT=114 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `userdata`
--

LOCK TABLES `userdata` WRITE;
/*!40000 ALTER TABLE `userdata` DISABLE KEYS */;
INSERT INTO `userdata` VALUES
(88,'Farhan','Ali','images/Farhan (1).jpeg','f@gmail.com','12345678',NULL,NULL,NULL,NULL),
(89,'Akber','Ali','images/Screenshot 2026-05-04 005255.png','alimmyasir34567@gmail.com','123456789',NULL,NULL,NULL,NULL),
(94,'Ali','Hamza','https://lh3.googleusercontent.com/a/ACg8ocIznXsguiqGZQ-mgvjxEZGIPkNhB5ZyTpuMAVQyZMGFGwY-nI31=s96-c','noorekoh3@gmail.com','','111971732187820163655',NULL,NULL,'+923246856011'),
(111,'BSCSF24M23','Haider','https://lh3.googleusercontent.com/a/ACg8ocIqGrfDajidKsVaaVjMiirdioGiHdlITD6vyWP5dOlzICgFgA=s96-c','danyallusifer1412@gmail.com','$2y$10$YxIj3OJHua28GD7vuYKAPO6gfcMdHPKL43pW/KXd.c76aL1PRnbnm','114341152078139402531',NULL,NULL,NULL),
(112,'Mikey','Madison','https://lh3.googleusercontent.com/a/ACg8ocLLFI0ve3UfFxStd_WSnNMJkvgM9Ek7SLSF8LZX_HaJzfPnvQ=s96-c','mikeymadison.mm@gmail.com','$2y$10$dNt2xCse8DchxCSiSBBnsuM7X6B.n/.ZQANCEWgy.Ijh80O8H1nEy','102292720541715897173',NULL,NULL,NULL),
(113,'Ali','Haider Malik','https://lh3.googleusercontent.com/a/ACg8ocJ8lU4pr2nwe5UHeuBaKUqUPUnQyaD58h4NdZsunGjaH0ZEp5I=s96-c','alihaidermalik1412@gmail.com','','109280757811948498024',NULL,NULL,'+923017169678');
/*!40000 ALTER TABLE `userdata` 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 */;
/*M!100616 SET NOTE_VERBOSITY=@OLD_NOTE_VERBOSITY */;

-- Dump completed on 2026-05-28 15:15:17