-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Oct 24, 2025 at 11:48 AM
-- Server version: 10.4.32-MariaDB
-- PHP Version: 8.0.30

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


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

--
-- Database: `vc_dashboard`
--

-- --------------------------------------------------------

--
-- Table structure for table `engagements`
--

CREATE TABLE `engagements` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `meeting_date` date NOT NULL,
  `meeting_time` time NOT NULL,
  `venue` varchar(255) DEFAULT NULL,
  `organized_by` varchar(255) DEFAULT NULL,
  `contact_info` varchar(100) DEFAULT NULL,
  `meeting_type` varchar(100) DEFAULT NULL,
  `status` varchar(50) DEFAULT NULL,
  `added_by` varchar(50) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `engagements`
--

INSERT INTO `engagements` (`id`, `title`, `meeting_date`, `meeting_time`, `venue`, `organized_by`, `contact_info`, `meeting_type`, `status`, `added_by`, `description`, `created_at`) VALUES
(4, 'Lieutenant colonel Waqar Azam', '2025-10-15', '12:30:00', 'VC Office', 'SVC', '', 'Physical', 'completed', NULL, '', '2025-10-14 10:07:10'),
(5, 'World Food Day', '2025-10-16', '11:00:00', 'Room no 110 Acdemic Block', 'Dr. Shabaz ', '', 'Physical', 'completed', NULL, '', '2025-10-14 10:09:57'),
(7, 'Visit of Chinese Delegation At MNSUAM', '2025-10-21', '09:00:00', 'Syndicate Hall', 'Dr. Junaid', '', 'Physical', 'completed', NULL, 'Full Day', '2025-10-14 10:12:28'),
(9, 'Invitation as a Speaker on Seminar on Agriculture Sector in Pakistan', '2025-10-30', '11:30:00', 'NDU', 'NDU', '', 'Physical', 'Scheduled', NULL, '', '2025-10-14 10:14:29'),
(11, 'Mr. Muhammad Mushtaq Conference', '2025-11-04', '00:00:00', 'Mardan', 'Mr. Muhammad Mushtaq ', '', 'Physical', 'Scheduled', NULL, '', '2025-10-14 10:16:48'),
(15, 'Job Fair MNSUAM', '2025-10-16', '10:00:00', 'Guest House Back Yard', 'Dr. Usman Jamshaid', '', 'Physical', 'completed', NULL, '', '2025-10-16 06:34:12'),
(16, 'Wheat Campain  ', '2025-10-17', '10:30:00', 'Room no 110 Acdemic Block', 'Dr. Mohakam ', '', 'Physical', 'completed', NULL, '', '2025-10-16 08:35:02'),
(18, 'Governor House Meeting', '2025-10-20', '12:00:00', 'Governor House Lahore', '', '', 'Physical', 'completed', NULL, '', '2025-10-16 08:36:21'),
(21, 'Muhammad hussnain Dhairh', '2025-10-17', '11:30:00', 'VC Office', 'Dr. Abdul Gaffar', '', 'Physical', 'completed', NULL, '', '2025-10-16 11:11:00'),
(25, 'Olive Standard Meeting ', '2025-10-23', '15:00:00', 'Online', 'NSDRA', '', 'Online', 'completed', NULL, '', '2025-10-22 09:59:13'),
(27, 'Consultative Session On Mango Nursery Registration and Certification System in Pakistan', '2025-10-23', '11:00:00', 'Committee Room VC Office', 'Dr. Kashif Razzaq', '', 'Physical', 'completed', NULL, '', '2025-10-22 10:01:10'),
(28, 'Arrival of Dr. Neil and Munwar Kazmi ', '2025-10-30', '00:00:00', 'MNSUAM', 'Dr. Irfan Baig', '', 'Physical', 'Scheduled', NULL, 'They will be in MNSUAM till 01-11-2025 ', '2025-10-22 10:02:11'),
(29, 'Pluses Strategies NSDRA Staff Meeting', '2025-10-22', '10:30:00', 'Online', 'NSDRA', '', 'Physical', 'completed', NULL, '', '2025-10-22 10:26:24'),
(31, 'Director Live stock Multan', '2025-10-23', '14:00:00', 'VC Office', 'Dr. junaid', '', 'Physical', 'completed', NULL, 'Sheild Distribution', '2025-10-23 07:06:09'),
(32, 'mango meeting ', '2025-10-22', '14:00:00', 'Committee Room VC Office', 'Dr junaid', '', 'Physical', 'completed', NULL, '', '2025-10-23 07:11:27'),
(33, 'Green Pakistan Initiative ', '2025-10-24', '11:00:00', 'Committee Room VC Office', '', '', 'Online', 'Scheduled', NULL, '', '2025-10-23 07:53:53'),
(34, 'test', '2025-10-22', '12:00:00', '', '', '', 'Physical', 'completed', NULL, '', '2025-10-23 08:06:38'),
(36, 'Wheel Chair Distribution Ceremony at JPP', '2025-10-25', '10:00:00', 'Jalalpur Pirwala', 'Dr. Usman Jamshaid', '', 'Physical', 'Scheduled', NULL, '', '2025-10-23 08:56:59'),
(37, 'Meeting with Mis Noshaba Assistant Director Civil Defence ', '2025-10-24', '10:00:00', '', 'Dr. Umar Ijaz', '', 'Physical', 'Scheduled', NULL, '', '2025-10-23 08:57:23'),
(38, 'UNESCO Chair Meeting', '2025-11-18', '09:00:00', 'MNSUAM', 'Dr. Irfan Baig', '', 'Physical', 'Scheduled', NULL, '1st Half Meeting and Second Half Conference', '2025-10-23 08:58:54'),
(39, 'SoS Committee Meeting', '2025-11-06', '10:00:00', 'DHA Multan', 'SoS', '', 'Physical', 'Scheduled', NULL, '', '2025-10-23 09:00:16'),
(40, 'Truth in Labeling ', '2025-10-23', '16:30:00', 'Committee Room VC Office', 'Dr. Irfan Baig', '', 'Online', 'completed', NULL, '', '2025-10-23 09:03:51');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `engagements`
--
ALTER TABLE `engagements`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `engagements`
--
ALTER TABLE `engagements`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=42;
COMMIT;

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