--
-- Host: localhost    Database: abduzoib_userinfo
-- ------------------------------------------------------


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

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;

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

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');

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

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;

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


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

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;

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

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);

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

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;

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

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');

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

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;

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

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');

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

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;

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

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');

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

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;

--
-- Dumping data for table `persional_info`
--

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');

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

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;

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

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');

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

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=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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);

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

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;

--
-- Dumping data for table `skills`
--

INSERT INTO `skills` VALUES
(1,'Ms Office','Intermediate','2026-05-01 04:26:20','alihaidermalik1412@gmail.com');

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

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;

--
-- Dumping data for table `tasks`
--

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');

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

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;

--
-- Dumping data for table `user_connect`
--

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');


