-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: May 24, 2026 at 03:34 PM
-- Server version: 10.11.17-MariaDB
-- PHP Version: 8.4.21

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: `demoshelltech_database`
--

DELIMITER $$
--
-- Procedures
--
CREATE DEFINER=`demoshelltech`@`localhost` PROCEDURE `sp_add_enrollment` (IN `p_entity_type` VARCHAR(20), IN `p_entity_id` INT, IN `p_name` VARCHAR(255), IN `p_phone` VARCHAR(20), IN `p_email` VARCHAR(255), IN `p_org` VARCHAR(255))   BEGIN
    INSERT INTO enrollments (
        entity_type,
        entity_id,
        name,
        phone,
        email,
        organization
    )
    VALUES (
        p_entity_type,
        p_entity_id,
        p_name,
        p_phone,
        p_email,
        p_org
    );
END$$

DELIMITER ;

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

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

CREATE TABLE `admins` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `role` varchar(50) DEFAULT 'admin',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `admins` (`id`, `name`, `email`, `password`, `role`, `created_at`) VALUES
(1, 'Super Admin', 'admin@pwdtraining.gov.bd', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'super_admin', '2026-05-09 09:34:02');

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

--
-- Table structure for table `certificates`
--

CREATE TABLE `certificates` (
  `id` int(11) NOT NULL,
  `certificate_no` varchar(100) NOT NULL,
  `trainee_id` int(11) NOT NULL,
  `training_id` int(11) NOT NULL,
  `issue_date` date NOT NULL,
  `status` enum('valid','revoked') DEFAULT 'valid',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `contact_messages`
--

CREATE TABLE `contact_messages` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `message` text NOT NULL,
  `is_read` tinyint(1) DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `employees`
--

CREATE TABLE `employees` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `designation` varchar(255) DEFAULT NULL,
  `department` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `img` text DEFAULT NULL,
  `joinDate` date DEFAULT NULL,
  `active` tinyint(4) DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `employees`
--

INSERT INTO `employees` (`id`, `name`, `designation`, `department`, `email`, `phone`, `img`, `joinDate`, `active`, `created_at`, `updated_at`) VALUES
(1, 'Md. Shahidul Islam', 'Librarian', 'Civil Division', 'shahidul@pwd.gov.bd', '+8801711111111', NULL, NULL, 1, '2026-05-20 11:06:28', '2026-05-20 11:35:53'),
(2, 'Md. Rafiqul Hasan', 'Accountant', 'Architecture Division', 'rafiq@pwd.gov.bd', '+8801722222222', NULL, NULL, 1, '2026-05-20 11:06:28', '2026-05-20 11:36:02'),
(3, 'Ms. Nasreen Akhter', 'Lab Attendant', 'Civil Division', 'nasreen@pwd.gov.bd', '+8801733333333', NULL, NULL, 1, '2026-05-20 11:06:28', '2026-05-20 11:36:12'),
(4, 'Md. Kamal Hossain', 'Computer Operator', 'Training Section', 'kamal@pwd.gov.bd', '+8801744444444', NULL, NULL, 1, '2026-05-20 11:06:28', '2026-05-20 11:36:35');

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

--
-- Table structure for table `enrollments`
--

CREATE TABLE `enrollments` (
  `id` int(11) NOT NULL,
  `entity_type` enum('training','testing') NOT NULL,
  `entity_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `organization` varchar(255) DEFAULT NULL,
  `status` enum('pending','approved','rejected','completed') DEFAULT 'pending',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `equipment`
--

CREATE TABLE `equipment` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `capacity` varchar(100) DEFAULT NULL,
  `standard` varchar(100) DEFAULT NULL,
  `image_url` varchar(500) DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `desc` text DEFAULT NULL,
  `model` varchar(255) DEFAULT NULL,
  `serial` varchar(255) DEFAULT NULL,
  `img` varchar(500) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `equipment`
--

INSERT INTO `equipment` (`id`, `name`, `capacity`, `standard`, `image_url`, `is_active`, `created_at`, `updated_at`, `desc`, `model`, `serial`, `img`) VALUES
(1, 'Universal Testing Machine (UTM)', '1000 kN', 'IS: 14858', 'https://picsum.photos/seed/utm/400/300.jpg', 1, '2026-05-09 09:13:16', '2026-05-09 09:13:16', NULL, NULL, NULL, NULL),
(2, 'Compression Testing Machine', '2000 kN', 'IS: 516', 'https://picsum.photos/seed/ctm/400/300.jpg', 1, '2026-05-09 09:13:16', '2026-05-09 09:13:16', NULL, NULL, NULL, NULL),
(3, 'Ultrasonic Pulse Velocity Meter', 'Up to 10m range', 'IS: 13311 Part 1', 'https://picsum.photos/seed/upvm/400/300.jpg', 1, '2026-05-09 09:13:16', '2026-05-09 09:13:16', NULL, NULL, NULL, NULL),
(4, 'Rebound Hammer', '10-70 N/mm²', 'IS: 13311 Part 2', 'https://picsum.photos/seed/rh/400/300.jpg', 1, '2026-05-09 09:13:16', '2026-05-09 09:13:16', NULL, NULL, NULL, NULL),
(5, 'Sieve Shaker', '200mm dia sieves', 'IS: 460', 'https://picsum.photos/seed/sieve/400/300.jpg', 1, '2026-05-09 09:13:16', '2026-05-09 09:13:16', NULL, NULL, NULL, NULL),
(6, 'Los Angeles Abrasion Machine', '5000g sample', 'IS: 2386 Part 4', 'https://picsum.photos/seed/la/400/300.jpg', 1, '2026-05-09 09:13:16', '2026-05-09 09:13:16', NULL, NULL, NULL, NULL);

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

--
-- Table structure for table `facilities`
--

CREATE TABLE `facilities` (
  `id` int(11) NOT NULL,
  `type` enum('classroom','computerlab','library','residential','swimmingpool','testinglab','gymnasium','playground') NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `image_url` varchar(500) DEFAULT NULL,
  `status` varchar(50) DEFAULT 'Active',
  `is_active` tinyint(1) DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `desc` text DEFAULT NULL,
  `capacity` int(11) DEFAULT 0,
  `area` int(11) DEFAULT 0,
  `features` text DEFAULT NULL,
  `img` varchar(500) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `facilities`
--

INSERT INTO `facilities` (`id`, `type`, `title`, `description`, `image_url`, `status`, `is_active`, `created_at`, `updated_at`, `desc`, `capacity`, `area`, `features`, `img`) VALUES
(2, 'classroom', 'Welcome to PWD Training Academy — a modern and professional learning environment designed for effective training and skill development.', 'Our classrooms are fully equipped with modern facilities, including comfortable seating capacity for 40 participants, air conditioning (AC), a digital sound system, digital whiteboard, multimedia projector, and other advanced training equipment to ensure an interactive and productive learning experience.', NULL, 'Active', 1, '2026-05-19 04:28:14', '2026-05-21 07:21:44', 'Our classrooms are fully equipped with modern facilities, including comfortable seating capacity for 40 participants, air conditioning (AC), a digital sound system, digital whiteboard, multimedia projector, and other advanced training equipment to ensure an interactive and productive learning experience.', 40, 0, 'Multimedia Projector,\nWhiteboard,\nAC,\nDigital sound System', 'uploads/6a0c40e6a03d8_1779187942.jpg'),
(3, 'computerlab', 'Our Computer Lab', NULL, NULL, 'Active', 1, '2026-05-19 04:59:28', '2026-05-21 07:25:56', 'PWD Training Academy features a modern computer lab with seating capacity for 25 trainees, equipped with UPS backup, high-configuration computers, high-speed internet, and all updated software to ensure smooth, practical, and technology-driven training sessions.', 25, 0, 'High Configuration Computer,\nHigh-speed Internet,\nUPS,\nEngineering Software', 'uploads/computer-lab.jpg'),
(14, 'library', 'Digital Library Zone', 'A quiet and modern digital library with online journals and e-books access.', NULL, 'Active', 1, '2026-05-21 07:29:17', '2026-05-21 07:37:14', 'Spacious reading environment with digital access and research support.', 30, 0, 'E-books Access,Silent Zone,WiFi,Research Support', 'uploads/library.jpg'),
(15, 'residential', 'Trainee Hostel', 'Safe and comfortable residential facility for trainees with all basic amenities.', NULL, 'Active', 1, '2026-05-21 07:29:17', '2026-05-21 07:33:18', 'PWD Training Academy offers comfortable dormitory facilities with a total capacity of 50 seats, featuring twin-sharing rooms, modern washrooms, AC, internet access, and dining facilities to ensure a safe and convenient stay for trainees.', 50, 0, 'AC Rooms,\nWi-Fi,\nDining Hall,\nModern Washroom', 'uploads/residential.jpg'),
(18, 'library', 'Research Corner', 'Dedicated research section with academic resources.', NULL, 'Active', 1, '2026-05-21 07:29:17', '2026-05-21 07:40:05', 'Focused area for thesis and project research. Dedicated research section with academic resources.', 20, 0, '5000+ Books,\nReading Area,\nDigital Catalog,\nJournal Access', 'uploads/library.jpg'),
(19, 'playground', 'Playground', '[value-4]', '', 'Active', 1, '0000-00-00 00:00:00', '2026-05-21 08:14:19', 'PWD Training Academy provides modern playground facilities, including a badminton court and running track, promoting fitness, recreation, and a healthy learning environment for trainees.', 0, 0, 'Running Track, Badminton Court', 'uploads/playground.jpg'),
(20, 'swimmingpool', 'Swimming Pool', '[value-4]', '[value-5]', '[value-6]', 1, '0000-00-00 00:00:00', '2026-05-21 08:14:15', 'PWD Training Academy offers a modern swimming pool facility with steam bath, juice corner, changing rooms, and professional lifeguard support to ensure a refreshing, safe, and relaxing experience for trainees.', 20, 0, 'Steam Bath,\nChanging Room,\nJuice Corner,Lifeguard', 'uploads/swimmingpool.jpg'),
(21, 'gymnasium', 'Fitness Gymnasium', '[value-4]', '[value-5]', '[value-6]', 1, '0000-00-00 00:00:00', '2026-05-21 08:14:12', 'PWD Training Academy features a modern gymnasium equipped with essential fitness facilities to support physical wellness, recreation, and a healthy lifestyle for trainees.', 10, 0, 'Treadmill,\nWeight Section,\nYoga Area,\nLocker Room', 'uploads/gymnasium.jpg'),
(22, 'testinglab', 'Material Testing Labratory', '[value-4]', '[value-5]', '[value-6]', 1, '0000-00-00 00:00:00', '2026-05-21 08:17:12', 'Advanced testing laboratory for concrete, soil, steel, and bitumen testing equipped with UTM, compression machines, and survey instruments.', 15, 0, 'UTM,\nSoil Testing Kit,\nCompression Machine,\nSafety Gear', 'uploads/testing-lab.jpg');

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

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

CREATE TABLE `gallery` (
  `id` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `category` varchar(100) DEFAULT NULL,
  `image_url` varchar(500) NOT NULL,
  `display_order` int(11) DEFAULT 0,
  `is_active` tinyint(1) DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `date` varchar(50) DEFAULT NULL,
  `img` varchar(500) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `gallery` (`id`, `title`, `category`, `image_url`, `display_order`, `is_active`, `created_at`, `updated_at`, `date`, `img`) VALUES
(1, 'Training Session - AutoCAD', 'Training', 'https://picsum.photos/seed/gal1/800/600.jpg', 1, 1, '2026-05-09 09:13:16', '2026-05-19 04:52:45', NULL, 'uploads/6a0c40fdeae2b_1779187965.jpg'),
(2, 'Laboratory Testing', 'Event', 'https://picsum.photos/seed/gal2/800/600.jpg', 2, 1, '2026-05-09 09:13:16', '2026-05-19 04:52:38', NULL, 'uploads/6a0c40f6915e2_1779187958.jpg'),
(3, 'Workshop on STAAD Pro', 'Training', 'https://picsum.photos/seed/gal3/800/600.jpg', 3, 1, '2026-05-09 09:13:16', '2026-05-19 04:52:22', NULL, 'uploads/6a0c40e6a03d8_1779187942.jpg'),
(4, 'Annual Ceremony 2025', 'Event', 'https://picsum.photos/seed/gal4/800/600.jpg', 4, 1, '2026-05-09 09:13:16', '2026-05-19 04:51:58', NULL, 'uploads/6a0c40ce4bb0c_1779187918.jpg'),
(5, 'Computer Lab', 'Event', 'https://picsum.photos/seed/gal5/800/600.jpg', 5, 1, '2026-05-09 09:13:16', '2026-05-19 04:51:41', NULL, 'uploads/6a0c40bd87b08_1779187901.jpg'),
(6, 'Library Section', 'Event', 'https://picsum.photos/seed/gal6/800/600.jpg', 6, 1, '2026-05-09 09:13:16', '2026-05-19 04:51:33', NULL, 'uploads/6a0c40b5826b1_1779187893.jpg');

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

--
-- Table structure for table `notices`
--

CREATE TABLE `notices` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `content` text DEFAULT NULL,
  `notice_date` date DEFAULT NULL,
  `type` enum('new','important','general') DEFAULT 'general',
  `category` varchar(100) DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `date` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `notices`
--

INSERT INTO `notices` (`id`, `title`, `content`, `notice_date`, `type`, `category`, `is_active`, `created_at`, `updated_at`, `date`) VALUES
(1, 'New Training Schedule Released', 'We are pleased to announce our training schedule for January-March 2026. Registration is now open for all courses.', '2026-01-05', 'important', 'Training', 1, '2026-05-09 09:13:16', '2026-05-09 09:13:16', NULL),
(2, 'Holiday Notice - Independence Day', 'Academy will remain closed on March 26, 2026 on the occasion of Independence Day.', '2026-03-20', 'new', 'Holiday', 1, '2026-05-09 09:13:16', '2026-05-09 09:13:16', NULL),
(3, 'Laboratory Maintenance Notice', 'Testing laboratory will be under maintenance from Feb 15-20, 2026. Please plan accordingly.', '2026-02-10', 'general', 'Laboratory', 1, '2026-05-09 09:13:16', '2026-05-09 09:13:16', NULL),
(4, 'Certificate Distribution Ceremony', 'Certificate distribution ceremony for completed courses will be held on January 30, 2026.', '2026-01-25', 'important', 'Event', 1, '2026-05-09 09:13:16', '2026-05-09 09:13:16', NULL);

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

--
-- Table structure for table `officers`
--

CREATE TABLE `officers` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `designation` varchar(255) DEFAULT NULL,
  `office` varchar(255) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `mobile` varchar(20) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `image_url` varchar(500) DEFAULT NULL,
  `display_order` int(11) DEFAULT 0,
  `is_active` tinyint(1) DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `department` varchar(255) DEFAULT NULL,
  `img` varchar(500) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `officers`
--

INSERT INTO `officers` (`id`, `name`, `designation`, `office`, `phone`, `mobile`, `email`, `image_url`, `display_order`, `is_active`, `created_at`, `updated_at`, `department`, `img`) VALUES
(65, 'Abu Zafar Mohammad Shafiul Hannan', 'Superintending Engineer/Director', 'PWD Training Academy & Testing Laboratory', '02-55023280', '01711589459', 'azms_h92@yahoo.com', NULL, 1, 1, '2026-05-21 05:34:04', '2026-05-21 05:39:38', NULL, 'uploads/6a0e9a9a900d0_1779341978.jpg'),
(66, 'Labannya Barua', 'Senior Instructor/Executive Engineer (Civil)', 'PWD Training Academy and Testing Laboratory, Dhaka', '02-55023280', '01722322448', 'smslabannya@yahoo.com', NULL, 2, 1, '2026-05-21 05:34:04', '2026-05-21 05:39:47', NULL, 'uploads/6a0e9aa380bd5_1779341987.jpeg'),
(67, 'Farhana Rahman', 'Executive Engineer (E/M)', 'PWD Training Academy and Testing Laboratory, Dhaka', '02-55023280', '01671591912', 'mistykuet@gmail.com', NULL, 3, 1, '2026-05-21 05:34:04', '2026-05-21 05:34:04', NULL, NULL),
(68, 'Bidhan Chandra Dey', 'Executive Engineer (On Reserve)', 'PWD Training Academy and Testing Laboratory, Dhaka', '02-55023280', '01732209292', 'bcd4job@gmail.com', NULL, 4, 1, '2026-05-21 05:34:04', '2026-05-21 05:34:04', NULL, NULL),
(69, 'Md. Reyazul Islam', 'Assistant Engineer (Civil)', 'PWD Training Academy and Testing Laboratory, Dhaka', NULL, '01767798074', 'reyazulislam.cuet@gmail.com', NULL, 5, 1, '2026-05-21 05:34:04', '2026-05-21 05:40:31', NULL, 'uploads/6a0e9acf4325c_1779342031.jpg'),
(70, 'Shah Jamal Khan', 'Assistant Engineer (E/M)', NULL, NULL, NULL, NULL, NULL, 6, 1, '2026-05-21 05:34:04', '2026-05-21 05:34:04', NULL, NULL),
(71, 'Mohammad Golam Rabbani', 'Assistant Engineer', NULL, NULL, NULL, NULL, NULL, 7, 1, '2026-05-21 05:34:04', '2026-05-21 05:34:04', NULL, NULL),
(72, 'Md. Shariar Hossain', 'Assistant Engineer (Civil)', NULL, NULL, '01614013015', 'siam15ce@gmail.com', NULL, 8, 1, '2026-05-21 05:34:04', '2026-05-21 05:40:11', NULL, 'uploads/6a0e9abb5a2a3_1779342011.jpeg');

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

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

CREATE TABLE `settings` (
  `id` int(11) NOT NULL DEFAULT 1,
  `site_name` varchar(255) DEFAULT 'PWD Training Academy',
  `phone` varchar(50) DEFAULT '',
  `email` varchar(255) DEFAULT '',
  `address` text DEFAULT NULL,
  `facebook` varchar(255) DEFAULT '',
  `youtube` varchar(255) DEFAULT '',
  `logo` varchar(255) DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `settings` (`id`, `site_name`, `phone`, `email`, `address`, `facebook`, `youtube`, `logo`) VALUES
(1, 'PWD Training Academy', '+880-2-818123444', 'info@pwdtraining.gov.bd', 'PWD, Sher-e-Bangla Nagar, Dhaka-1207', '', '', '');

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

--
-- Table structure for table `site_settings`
--

CREATE TABLE `site_settings` (
  `id` int(11) NOT NULL,
  `setting_key` varchar(100) NOT NULL,
  `setting_value` text DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `site_settings`
--

INSERT INTO `site_settings` (`id`, `setting_key`, `setting_value`, `updated_at`) VALUES
(1, 'academy_name', 'PWD Training Academy', '2026-05-09 09:13:16'),
(2, 'phone', '+880-2-8181234', '2026-05-09 09:13:16'),
(3, 'email', 'info@pwdtraining.gov.bd', '2026-05-09 09:13:16'),
(4, 'address', 'PWD, Sher-e-Bangla Nagar, Dhaka-1207', '2026-05-09 09:13:16'),
(5, 'facebook_url', 'https://facebook.com/pwdtraining', '2026-05-09 09:13:16'),
(6, 'youtube_url', 'https://youtube.com/pwdtraining', '2026-05-09 09:13:16');

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

--
-- Table structure for table `sliders`
--

CREATE TABLE `sliders` (
  `id` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `subtitle` varchar(500) DEFAULT NULL,
  `button_text` varchar(100) DEFAULT NULL,
  `button_link` varchar(255) DEFAULT NULL,
  `image_url` varchar(500) NOT NULL,
  `display_order` int(11) DEFAULT 0,
  `is_active` tinyint(1) DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `btnText` varchar(255) DEFAULT NULL,
  `btnLink` varchar(255) DEFAULT NULL,
  `order` int(11) DEFAULT 0,
  `active` tinyint(4) DEFAULT 1,
  `img` varchar(500) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `sliders`
--

INSERT INTO `sliders` (`id`, `title`, `subtitle`, `button_text`, `button_link`, `image_url`, `display_order`, `is_active`, `created_at`, `updated_at`, `btnText`, `btnLink`, `order`, `active`, `img`) VALUES
(1, 'Welcome to PWD Training Academy', 'Building Capacity for Nation\'s Infrastructure', 'Explore Programs', 'trainings', 'uploads/img_6a001a9d594a50.50319960.jpg', 1, 1, '2026-05-09 09:13:16', '2026-05-19 04:50:46', NULL, NULL, 0, 1, 'uploads/6a0c4086c8d3c_1779187846.jpg'),
(6, 'Building Skills for a Better Infrastructure', 'Providing world-class technical and professional training for engineers, officers, and staff', '', '', 'uploads/img_6a001a5c506a93.71480847.jpg', 0, 1, '2026-05-09 23:15:12', '2026-05-19 04:49:59', NULL, NULL, 0, 1, 'uploads/6a0c40574c2ec_1779187799.jpg'),
(9, 'Training Tomorrow’s Public Infrastructure Leaders', 'Providing world-class technical and professional training for engineers, officers, and staff', 'Start Learning', '', 'uploads/img_6a001abec87086.08676794.jpg', 0, 1, '2026-05-09 23:42:22', '2026-05-19 04:49:41', NULL, NULL, 0, 1, 'uploads/6a0c40459439b_1779187781.jpg'),
(10, 'Innovation, Training, Excellence', 'Developing skilled manpower for sustainable national infrastructure.', 'Join Training', '', 'uploads/img_6a001af559a1a0.33032844.jpg', 0, 1, '2026-05-09 23:43:17', '2026-05-19 04:48:40', NULL, NULL, 0, 1, 'uploads/6a0c40084c2cf_1779187720.jpg');

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

--
-- Table structure for table `testings`
--

CREATE TABLE `testings` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `test_type` varchar(255) DEFAULT '',
  `turnaround` varchar(100) DEFAULT NULL,
  `fee` decimal(10,2) DEFAULT 0.00,
  `image_url` varchar(500) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `desc` text DEFAULT NULL,
  `testType` varchar(100) DEFAULT NULL,
  `standard` varchar(50) DEFAULT 'BDS',
  `img` varchar(500) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `testings`
--

INSERT INTO `testings` (`id`, `title`, `description`, `test_type`, `turnaround`, `fee`, `image_url`, `created_at`, `updated_at`, `desc`, `testType`, `standard`, `img`) VALUES
(1, 'Sieve Analysis of Coarse Aggregate as per ASTM C136', NULL, 'Aggregate', '7-28 days', 500.00, 'https://picsum.photos/seed/cube/600/400.jpg', '2026-05-09 09:13:15', '2026-05-23 05:44:23', NULL, NULL, 'BDS', NULL),
(2, 'Fineness Modulous (FM) of Fine Aggregate as per ASTM C136', NULL, 'Aggregate', '3-5 days', 300.00, 'https://picsum.photos/seed/steel/600/400.jpg', '2026-05-09 09:13:15', '2026-05-23 05:44:48', NULL, NULL, 'BDS', NULL),
(3, 'Aggregate Crushing Value (ACV) as per BS 812-110', NULL, 'Aggregate', '1-2 days', 1000.00, 'https://picsum.photos/seed/upv/600/400.jpg', '2026-05-09 09:13:15', '2026-05-23 05:45:11', NULL, NULL, 'BDS', NULL),
(4, 'Ten Percent Fines Value (TFV) as per BS 812-111', NULL, 'Aggregate', 'Same day', 500.00, 'https://picsum.photos/seed/hammer/600/400.jpg', '2026-05-09 09:13:15', '2026-05-23 05:45:27', NULL, NULL, 'BDS', NULL),
(5, 'Aggregate Impact Value (AIV) as per BS 812-112', '', 'Aggregate', '3', 200.00, 'data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAWoAAABXCAYAAAAtSw8kAABa1ElEQVR42u29d5hcx3Hu/euTZmZzBBYbgEXOOZMgCYI5KJAiAEmkqEBKsleWbdm+vo73sT/b19fpWrKuYSVKlEiKBAjmnEAwgMg5EDksFlhswOYwc1J/f3QP9mC5IACSICl56nnmAXbmhO4+fd6qfqu6SvAplEcfbbJMUwz3fXldZ6f8bG+vnCklCcvmeE62eDsry3g0DOWGxYtL28hIRjKSkd9yEZ+2Bq1Y0ZQwTW5tb5e/s29/MGf3Hj+n/lSI70NermBYtcnkidbR6mHG47bNL32f3UuWlAaZR5mRjGQkA9SXWB57rCkRhkzs6ZHf2LvP/9yad/zyI0dDenslUvYdZ5pQXGQwfZqZmjnDereszPhZVpbxmO/LpsWLM4CdkYxkJAPUFy3LlzeddZ+lS0tl5DdDCLJsm5HJFLfW1QV3bt', '2026-05-09 09:13:15', '2026-05-23 05:45:48', NULL, NULL, 'BDS', NULL),
(6, 'Los Angeles Abration Test (LA) as per ASTM C131', NULL, 'Aggregate', NULL, 0.00, NULL, '2026-05-23 05:46:56', '2026-05-23 05:46:56', NULL, NULL, 'BDS', NULL),
(7, 'Angularity Number (AN) as per BS 812-1', NULL, 'Aggregate', NULL, 0.00, NULL, '2026-05-23 05:46:56', '2026-05-23 05:46:56', NULL, NULL, 'BDS', NULL),
(8, 'Flakiness Index (FI) as per BS 812-105.1', NULL, 'Aggregate', NULL, 0.00, NULL, '2026-05-23 05:47:40', '2026-05-23 05:47:40', NULL, NULL, 'BDS', NULL),
(9, 'Elongation Index (EI) as per BS 812-105.2', NULL, 'Aggregate', NULL, 0.00, NULL, '2026-05-23 05:47:40', '2026-05-23 05:47:40', NULL, NULL, 'BDS', NULL),
(10, 'Unit Weight of Coarse Aggregate as per ASTM C29', NULL, 'Aggregate', NULL, 0.00, NULL, '2026-05-23 05:48:41', '2026-05-23 05:48:41', NULL, NULL, 'BDS', NULL),
(11, 'Unit Weight of Fine Aggregate as per ASTM C29', NULL, 'Aggregate', NULL, 0.00, NULL, '2026-05-23 05:48:41', '2026-05-23 05:48:41', NULL, NULL, 'BDS', NULL),
(12, 'Voids in Coarse Aggregate as per ASTM C29', NULL, 'Aggregate', NULL, 0.00, NULL, '2026-05-23 05:50:29', '2026-05-23 05:50:29', NULL, NULL, 'BDS', NULL),
(13, 'Voids in Fine Aggregate as per ASTM C29', NULL, 'Aggregate', NULL, 0.00, NULL, '2026-05-23 05:50:29', '2026-05-23 05:50:29', NULL, NULL, 'BDS', NULL),
(14, 'Absorption and Specific Gravity/ Density of Coarse Aggregate as per ASTM C127', NULL, 'Aggregate', NULL, 0.00, NULL, '2026-05-23 05:50:29', '2026-05-23 05:50:29', NULL, NULL, 'BDS', NULL),
(15, 'Absorption and Specific Gravity/ Density of Fine Aggregate as per ASTM C128', NULL, 'Aggregate', NULL, 0.00, NULL, '2026-05-23 05:50:29', '2026-05-23 05:50:29', NULL, NULL, 'BDS', NULL),
(16, 'Field Density Test per spot by Sand Cone method and Relative Density of Cohesionless Soil by Modified Proctor Compaction Test (field Visit charge* to be added) ASTM D1556', NULL, 'Soil', NULL, 0.00, NULL, '2026-05-23 05:52:38', '2026-05-23 05:52:38', NULL, NULL, 'BDS', NULL),
(17, 'Crushing Strength of Bricks/ Blocks (1 set) as per BDS 208. Each test set shall consist of 5 numbers of bricks/ blocks specimens.', NULL, 'Bricks & Blocks', NULL, 0.00, NULL, '2026-05-23 05:52:38', '2026-05-23 05:52:38', NULL, NULL, 'BDS', NULL),
(18, 'Crushing Strength of Bricks/Blocks (1 set) as per ASTM C67. Each test set shall consist of 5 numbers of bricks/ blocks specimens.', NULL, 'Bricks & Blocks', NULL, 0.00, NULL, '2026-05-23 05:58:05', '2026-05-23 05:58:05', NULL, NULL, 'BDS', NULL),
(19, 'Absorption of Bricks/ Blocks (1 set) as per BDS 208. Each test set shall consist of 5 numbers of bricks/ blocks specimens.', NULL, 'Bricks & Blocks', NULL, 0.00, NULL, '2026-05-23 05:58:05', '2026-05-23 05:58:05', NULL, NULL, 'BDS', NULL),
(20, 'Absorption of Bricks/ Blocks (1 set) as per ASTM C67. Each test set shall consist of 5 numbers of bricks/ blocks specimens.', NULL, 'Bricks & Blocks', NULL, 0.00, NULL, '2026-05-23 05:58:05', '2026-05-23 05:58:05', NULL, NULL, 'BDS', NULL),
(21, 'Efflorescence of Brick (1 set) as per BDS 208. Each test set shall consist of 10 numbers of bricks/ blocks specimens.', NULL, 'Bricks & Blocks', NULL, 0.00, NULL, '2026-05-23 05:58:05', '2026-05-23 05:58:05', NULL, NULL, 'BDS', NULL),
(22, 'Efflorescence of Brick (1 set) as per ASTM C67. Each test set shall consist of 10 numbers of bricks/ blocks specimens.', NULL, 'Bricks & Blocks', NULL, 0.00, NULL, '2026-05-23 05:58:05', '2026-05-23 05:58:05', NULL, NULL, 'BDS', NULL),
(23, 'Strength of Concrete Cylinder per set (100mm ´ 200mm) as per ASTM C39. Each test set shall consist of 3 numbers of cylinder specimens.', NULL, 'Concrete', NULL, 0.00, NULL, '2026-05-23 05:58:05', '2026-05-23 05:58:05', NULL, NULL, 'BDS', NULL),
(24, 'Strength of Concrete Cylinder per set (150mm ´ 300mm) as per ASTM C39. Each test set shall consist of 2 numbers of cylinder specimens.', NULL, 'Concrete', NULL, 0.00, NULL, '2026-05-23 06:01:47', '2026-05-23 06:01:47', NULL, NULL, 'BDS', NULL),
(25, 'Strength of Concrete Cube per set (<200mm) as per BS EN 12390-2. Each test set shall consist of 3 numbers of cube specimens.\r\n', NULL, 'Concrete', NULL, 0.00, NULL, '2026-05-23 06:01:47', '2026-05-23 06:01:47', NULL, NULL, 'BDS', NULL),
(26, 'Strength of Concrete Cube per set (200mm-300mm) as per BS EN 12390-2. Each test set shall consist of 3 numbers of cube specimens.', NULL, 'Concrete', NULL, 0.00, NULL, '2026-05-23 06:01:47', '2026-05-23 06:01:47', NULL, NULL, 'BDS', NULL),
(27, 'Compressive Strength Test of Cement Mortar Cubes at any one specified age of 3 days, 7 days, or 28 days (one set for each age), conducted in accordance with ASTM C109/C109M. Each test set shall consist of 3 mortar cube specimens.', NULL, 'Cement', NULL, 0.00, NULL, '2026-05-23 06:01:47', '2026-05-23 06:01:47', NULL, NULL, 'BDS', NULL),
(28, 'Compressive Strength Test of Cement Mortar Cubes at any two specified ages from 3 days, 7 days, or 28 days (one set for each selected age), conducted in accordance with ASTM C109/C109M. Each test set shall consist of 3 mortar cube specimens.\r\n', NULL, 'Cement', NULL, 0.00, NULL, '2026-05-23 06:02:37', '2026-05-23 06:02:37', NULL, NULL, 'BDS', NULL),
(29, 'Compressive Strength Test of Cement Mortar Cubes at the ages of 3 days, 7 days, and 28 days (one set for each specified age), conducted in accordance with ASTM C109/C109M. Each test set shall consist of 3 mortar cube specimens.\r\n', NULL, 'Cement', NULL, 0.00, NULL, '2026-05-23 06:02:37', '2026-05-23 06:02:37', NULL, NULL, 'BDS', NULL),
(30, 'Compressive Strength Test of Cement Mortar Cubes at any one specified age of 2 days, 7 days, or 28 days (one set for each age), conducted in accordance with BS EN 196-1. Each test set shall consist of 3 mortar cube specimens.', NULL, 'Cement', NULL, 0.00, NULL, '2026-05-23 06:03:35', '2026-05-23 06:03:35', NULL, NULL, 'BDS', NULL),
(31, 'Compressive Strength Test of Cement Mortar Cubes at any two specified ages from 2 days, 7 days, or 28 days (one set for each selected age), conducted in accordance with BS EN 196-1. Each test set shall consist of 3 mortar cube specimens.', NULL, 'Cement', NULL, 0.00, NULL, '2026-05-23 06:03:35', '2026-05-23 06:03:35', NULL, NULL, 'BDS', NULL),
(32, 'Compressive Strength Test of Cement Mortar Cubes at the ages of 2 days, 7 days, and 28 days (one set for each specified age), conducted in accordance with BS EN 196-1. Each test set shall consist of 3 mortar cube specimens.\r\n', NULL, 'Cement', NULL, 0.00, NULL, '2026-05-23 06:04:25', '2026-05-23 06:04:25', NULL, NULL, 'BDS', NULL),
(33, 'Setting Time and as per ASTM C191', NULL, 'Cement', NULL, 0.00, NULL, '2026-05-23 06:06:12', '2026-05-23 06:06:24', NULL, NULL, 'BDS', NULL),
(34, 'Normal Consistency of Cement as per ASTM C187', NULL, 'Cement', NULL, 0.00, NULL, '2026-05-23 06:06:12', '2026-05-23 06:06:55', NULL, NULL, 'BDS', NULL),
(35, 'Soundness of Cement by Autocalve method as per ASTM C151', NULL, 'Cement', NULL, 0.00, NULL, '2026-05-23 06:06:12', '2026-05-23 06:06:37', NULL, NULL, 'BDS', NULL),
(36, 'Soundness of Cement by Le chatelier bath as per EN 196-3', NULL, 'Cement', NULL, 0.00, NULL, '2026-05-23 06:06:12', '2026-05-23 06:06:40', NULL, NULL, 'BDS', NULL),
(37, 'Soundness of Cement  by stored in water as per ASTM C1038', NULL, 'Cement', NULL, 0.00, NULL, '2026-05-23 06:06:12', '2026-05-23 06:11:26', NULL, NULL, 'BDS', NULL),
(38, 'Fineness of Cement as per ASTM C204', NULL, 'Cement', NULL, 0.00, NULL, '2026-05-23 06:07:07', '2026-05-23 06:11:29', NULL, NULL, 'BDS', NULL),
(39, 'Tesnsion Test including wt. and Elonggation per set (upto 25mm) as  per ASTM A370 or BDS ISO 6935-2. Each test set shall consist of 3 numbers of rebar specimens.', '', 'Rebar', NULL, 0.00, NULL, '2026-05-23 06:14:29', '2026-05-23 06:15:27', NULL, NULL, 'BDS', NULL),
(40, 'Tesnsion Test including wt. and Elonggation per set (above 25mm & upto 32mm) as  per ASTM A370 or BDS ISO 6935-2. Each test set shall consist of 3 numbers of rebar specimens.', NULL, 'Rebar', NULL, 0.00, NULL, '2026-05-23 06:14:29', '2026-05-23 06:15:32', NULL, NULL, 'BDS', NULL),
(41, 'Bend Test per set (upto 25mm) as per ASTM A370 or BDS ISO 6935-2. Each test set shall consist of 3 numbers of rebar specimens.', NULL, 'Rebar', NULL, 0.00, NULL, '2026-05-23 06:14:29', '2026-05-23 06:15:40', NULL, NULL, 'BDS', NULL),
(42, 'Bend Test per set (above 25mm & upto 32mm) as per ASTM A370 or BDS ISO 6935-2. Each test set shall consist of 3 numbers of rebar specimens.', NULL, 'Rebar', NULL, 0.00, NULL, '2026-05-23 06:14:29', '2026-05-23 06:15:45', NULL, NULL, 'BDS', NULL),
(43, 'Rebend Test per set (upto 25mm) as per ASTM A370 or BDS ISO 6935-2. Each test set shall consist of 3 numbers of rebar specimens.', NULL, 'Rebar', NULL, 0.00, NULL, '2026-05-23 06:14:29', '2026-05-23 06:15:42', NULL, NULL, 'BDS', NULL),
(44, 'Rebend Test per set (above 25mm & upto 32mm) as per ASTM A370 or BDS ISO 6935-2. Each test set shall consist of 3 numbers of rebar specimens.', NULL, 'Rebar', NULL, 0.00, NULL, '2026-05-23 06:14:29', '2026-05-23 06:15:35', NULL, NULL, 'BDS', NULL);

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

--
-- Table structure for table `trainees`
--

CREATE TABLE `trainees` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `organization` varchar(255) DEFAULT NULL,
  `designation` varchar(255) DEFAULT NULL,
  `status` enum('active','inactive','graduated') DEFAULT 'active',
  `enrollment_date` date DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `org` varchar(255) DEFAULT NULL,
  `training` varchar(255) DEFAULT NULL,
  `date` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `trainees`
--

INSERT INTO `trainees` (`id`, `user_id`, `name`, `email`, `phone`, `organization`, `designation`, `status`, `enrollment_date`, `created_at`, `updated_at`, `org`, `training`, `date`) VALUES
(1, NULL, 'Engr. Rahim Uddin', 'rahim@example.com', '+8801712345678', 'PWD Dhaka', 'Sub-Assistant Engineer', 'active', '2026-01-10', '2026-05-09 09:13:16', '2026-05-09 09:13:16', NULL, NULL, NULL),
(2, NULL, 'Engr. Karim Hossain', 'karim@example.com', '+8801798765432', 'PWD Chittagong', 'Assistant Engineer', 'active', '2026-01-12', '2026-05-09 09:13:16', '2026-05-09 09:13:16', NULL, NULL, NULL),
(3, NULL, 'Engr. Salma Akter', 'salma@example.com', '+8801654321098', 'PWD Rajshahi', 'Executive Engineer', 'graduated', '2025-11-05', '2026-05-09 09:13:16', '2026-05-09 09:13:16', NULL, NULL, NULL),
(4, 3, 'Akash', 'akash@pwd.gov.bd', '01716015261', 'PWD', 'Computer Operator', 'active', '2026-05-23', '2026-05-23 10:46:52', '2026-05-23 10:46:52', NULL, NULL, NULL),
(5, 4, 'Akash', 'mywebmail@pwd.gov.bd', '01521403191', 'PWD', 'Sub-Assistant Engineer', 'active', '2026-05-24', '2026-05-24 04:34:46', '2026-05-24 04:34:46', NULL, NULL, NULL);

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

--
-- Table structure for table `trainings`
--

CREATE TABLE `trainings` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `category` enum('Short Course','Workshop','Seminar','Long Course') DEFAULT 'Short Course',
  `status` enum('upcoming','ongoing','completed') DEFAULT 'upcoming',
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `fee` decimal(10,2) DEFAULT 0.00,
  `duration` varchar(100) DEFAULT NULL,
  `image_url` varchar(500) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `desc` text DEFAULT NULL,
  `capacity` int(11) DEFAULT 30,
  `venue` varchar(255) DEFAULT NULL,
  `img` varchar(500) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `trainings`
--

INSERT INTO `trainings` (`id`, `title`, `description`, `category`, `status`, `start_date`, `end_date`, `fee`, `duration`, `image_url`, `created_at`, `updated_at`, `desc`, `capacity`, `venue`, `img`) VALUES
(69, 'Geotechnical Investigation and Construction Practices of Foundation for Buildings', 'Training on geotechnical investigation and foundation construction practices for buildings.', 'Short Course', 'upcoming', '2026-01-10', '2026-01-20', 4500.00, '10 Days', 'https://picsum.photos/seed/geotech/600/400', '2026-05-19 00:37:50', '2026-05-19 05:35:56', 'This training focuses on soil investigation, foundation analysis, site testing methods, and safe foundation construction practices for modern buildings.', 40, 'PWD Training Academy, Dhaka', 'https://images.unsplash.com/photo-1504307651254-35680f356dfd?q=80&w=1200&auto=format&fit=crop'),
(70, 'Retrofit Construction and Supervision', 'Training on retrofit construction techniques and supervision methods.', 'Short Course', 'completed', '2026-02-05', '2026-02-15', 4000.00, '10 Days', 'https://picsum.photos/seed/retrofit/600/400', '2026-05-19 00:37:50', '2026-05-19 05:35:56', 'Participants will learn retrofit techniques, structural strengthening methods, repair supervision, and renovation management of existing buildings.', 35, 'Engineering Staff College, Dhaka', 'https://images.unsplash.com/photo-1517048676732-d65bc937f952?q=80&w=1200&auto=format&fit=crop'),
(71, 'Pile Construction, Pile Driving and Load Test of Pile', 'Comprehensive course on pile construction, pile driving, and load testing.', 'Workshop', 'ongoing', '2026-03-01', '2026-03-12', 6500.00, '12 Days', 'https://picsum.photos/seed/pile/600/400', '2026-05-19 00:37:50', '2026-05-19 05:35:56', 'Practical training on pile construction, pile driving systems, foundation safety, and pile load testing procedures.', 45, 'PWDTA Foundation Lab', 'https://images.unsplash.com/photo-1503387762-592deb58ef4e?q=80&w=1200&auto=format&fit=crop'),
(72, 'Plumbing Technology and Rainwater Harvesting System', 'Training on plumbing technology and rainwater harvesting systems.', 'Workshop', 'upcoming', '2026-03-15', '2026-03-22', 3500.00, '7 Days', 'https://picsum.photos/seed/plumbing/600/400', '2026-05-19 00:37:50', '2026-05-19 05:35:56', 'Hands-on training covering plumbing systems, pipe fittings, water supply management, and rainwater harvesting solutions.', 30, 'PWD Plumbing Workshop Center', 'https://images.unsplash.com/photo-1585704032915-c3400ca199e7?q=80&w=1200&auto=format&fit=crop'),
(73, 'Land Management', 'Training on land management systems and practices.', 'Seminar', 'completed', '2026-04-02', '2026-04-05', 2500.00, '3 Days', 'https://picsum.photos/seed/land/600/400', '2026-05-19 00:37:50', '2026-05-19 05:35:56', 'Learn modern land management systems, land records, acquisition procedures, and digital land administration methods.', 50, 'Land Management Institute, Dhaka', 'https://images.unsplash.com/photo-1506744038136-46273834b3fb?q=80&w=1200&auto=format&fit=crop'),
(74, 'Generator, Lift and Substation Installation, Operation & Maintenance', 'Training on installation, operation, and maintenance of generators, lifts, and substations.', 'Long Course', 'upcoming', '2026-04-10', '2026-05-05', 12000.00, '25 Days', 'https://picsum.photos/seed/generator/600/400', '2026-05-19 00:37:50', '2026-05-19 05:35:56', 'Comprehensive course on generator systems, lift installation, electrical substations, and maintenance operations.', 32, 'E/M Training Complex, Dhaka', 'https://images.unsplash.com/photo-1494412519320-aa613dfb7738?q=80&w=1200&auto=format&fit=crop'),
(75, 'Civil Suit Management & Civil Law Procedures', 'Course on civil suit management and civil law procedures.', 'Seminar', 'ongoing', '2026-05-01', '2026-05-06', 3000.00, '5 Days', 'https://picsum.photos/seed/civillaw/600/400', '2026-05-19 00:37:50', '2026-05-19 05:35:56', 'Training on civil litigation procedures, case management systems, documentation, and legal compliance processes.', 28, 'PWD Conference Hall', 'https://images.unsplash.com/photo-1521791136064-7986c2920216?q=80&w=1200&auto=format&fit=crop'),
(76, 'Judicial Procedure and Development Management', 'Training on judicial procedures and development management.', 'Seminar', 'upcoming', '2026-05-15', '2026-05-20', 3200.00, '5 Days', 'https://picsum.photos/seed/judicial/600/400', '2026-05-19 00:37:50', '2026-05-19 05:35:56', 'Participants will gain knowledge about judicial procedures, project governance, and public sector development management.', 36, 'Judicial Administration Center', 'https://images.unsplash.com/photo-1454165804606-c3d57bc86b40?q=80&w=1200&auto=format&fit=crop'),
(77, 'Cost Estimation of Construction Project using Estimating Software of PWD', 'Training on project cost estimation using PWD estimating software.', 'Workshop', 'upcoming', '2026-06-01', '2026-06-10', 7000.00, '10 Days', 'https://picsum.photos/seed/cost/600/400', '2026-05-19 00:37:50', '2026-05-19 05:35:56', 'Learn construction cost estimation techniques using official PWD estimating software with real project examples.', 40, 'Computer Lab - PWDTA', 'https://images.unsplash.com/photo-1554224155-6726b3ff858f?q=80&w=1200&auto=format&fit=crop'),
(78, 'Construction Project Monitoring using Project Monitoring Software of PWD', 'Training on construction project monitoring using PWD software.', 'Workshop', 'completed', '2026-06-15', '2026-06-22', 6800.00, '7 Days', 'https://picsum.photos/seed/monitoring/600/400', '2026-05-19 00:37:50', '2026-05-19 05:35:56', 'Training on monitoring construction progress, reporting systems, and project tracking using PWD monitoring software.', 38, 'Monitoring & ICT Lab', 'https://images.unsplash.com/photo-1497366754035-f200968a6e72?q=80&w=1200&auto=format&fit=crop'),
(79, 'Basics of Internal Electric Wiring of Buildings', 'Basic training on internal electrical wiring systems for buildings.', 'Short Course', 'upcoming', '2026-07-01', '2026-07-08', 3500.00, '7 Days', 'https://picsum.photos/seed/wiring/600/400', '2026-05-19 00:37:50', '2026-05-19 05:35:56', 'Basic practical course on electrical wiring systems, safety measures, and internal building electrification.', 30, 'Electrical Workshop Unit', 'https://images.unsplash.com/photo-1621905252507-b35492cc74b4?q=80&w=1200&auto=format&fit=crop'),
(80, 'Fire Safety Assessment, Fire Fighting and Detection System For Building', 'Training on fire safety assessment, fire fighting, and detection systems.', 'Workshop', 'ongoing', '2026-07-10', '2026-07-18', 5000.00, '8 Days', 'https://picsum.photos/seed/fire/600/400', '2026-05-19 00:37:50', '2026-05-19 05:35:56', 'Specialized training on fire safety inspection, firefighting systems, smoke detection, and emergency response planning.', 42, 'Fire Safety Training Center', 'https://images.unsplash.com/photo-1517048676732-d65bc937f952?q=80&w=1200&auto=format&fit=crop'),
(81, 'Lightning Protection, Renewable Energy, CCTV Camera and other E/M Equipment', 'Training on lightning protection, renewable energy systems, CCTV, and E/M equipment.', 'Workshop', 'upcoming', '2026-08-01', '2026-08-10', 6000.00, '10 Days', 'https://picsum.photos/seed/cctv/600/400', '2026-05-19 00:37:50', '2026-05-19 05:35:56', 'Course on lightning protection systems, solar power solutions, CCTV installation, and E/M equipment maintenance.', 35, 'Renewable Energy Lab', 'https://images.unsplash.com/photo-1509395176047-4a66953fd231?q=80&w=1200&auto=format&fit=crop'),
(82, 'Understanding HVAC System, Operation & Maintenance', 'Training on HVAC systems, operation, and maintenance.', 'Long Course', 'upcoming', '2026-08-15', '2026-09-05', 15000.00, '20 Days', 'https://picsum.photos/seed/hvac/600/400', '2026-05-19 00:37:50', '2026-05-19 05:35:56', 'Detailed understanding of HVAC systems, air conditioning operations, ventilation systems, and maintenance procedures.', 30, 'HVAC Simulation Lab', 'https://images.unsplash.com/photo-1581092580497-e0d23cbdf1dc?q=80&w=1200&auto=format&fit=crop'),
(83, 'Green Buildings: Concepts and Ratings Procedure', 'Course on green building concepts and rating procedures.', 'Seminar', 'completed', '2026-09-10', '2026-09-13', 2800.00, '3 Days', 'https://picsum.photos/seed/green/600/400', '2026-05-19 00:37:50', '2026-05-19 05:35:56', 'Seminar on sustainable green building concepts, environmental ratings, energy efficiency, and eco-friendly designs.', 60, 'Green Building Resource Center', 'https://images.unsplash.com/photo-1486406146926-c627a92ad1ab?q=80&w=1200&auto=format&fit=crop'),
(84, 'Public Procurement Rules (PPR) - 2008 with Latest Changes', 'Training on Public Procurement Rules (PPR) with latest updates.', 'Seminar', 'ongoing', '2026-09-20', '2026-09-25', 4500.00, '5 Days', 'https://picsum.photos/seed/ppr/600/400', '2026-05-19 00:37:50', '2026-05-19 05:35:56', 'Training covering latest Public Procurement Rules (PPR), tender procedures, procurement ethics, and compliance.', 55, 'PWD Procurement Hall', 'https://images.unsplash.com/photo-1450101499163-c8848c66ca85?q=80&w=1200&auto=format&fit=crop'),
(85, 'Electronic Government Procurement (e-GP)', 'Training on electronic government procurement systems.', 'Workshop', 'upcoming', '2026-10-01', '2026-10-07', 5000.00, '6 Days', 'https://picsum.photos/seed/egp/600/400', '2026-05-19 00:37:50', '2026-05-19 05:35:56', 'Hands-on workshop on e-GP system operation, tender submission, evaluation process, and procurement management.', 45, 'ICT Procurement Lab', 'https://images.unsplash.com/photo-1516321318423-f06f85e504b3?q=80&w=1200&auto=format&fit=crop'),
(86, 'AutoCAD-2D', 'Training on AutoCAD 2D drafting and design.', 'Short Course', 'ongoing', '2026-10-10', '2026-10-20', 5500.00, '10 Days', 'https://picsum.photos/seed/autocad2d/600/400', '2026-05-19 00:37:50', '2026-05-19 05:35:56', 'Practical AutoCAD 2D drafting course for engineering drawings, floor plans, and technical design documentation.', 40, 'CAD Lab - PWDTA', 'https://images.unsplash.com/photo-1504384308090-c894fdcc538d?q=80&w=1200&auto=format&fit=crop'),
(87, 'Training on National Integrity Strategy (NIS)', 'Training on National Integrity Strategy (NIS).', 'Seminar', 'upcoming', '2026-11-01', '2026-11-03', 2000.00, '2 Days', 'https://picsum.photos/seed/nis/600/400', '2026-05-19 00:37:50', '2026-05-19 05:35:56', 'Awareness training on National Integrity Strategy, ethical governance, transparency, and accountability practices.', 70, 'PWD Seminar Hall', 'https://images.unsplash.com/photo-1522202176988-66273c2fd55f?q=80&w=1200&auto=format&fit=crop'),
(88, 'Training on Right to Information (RTI)', 'Training on Right to Information (RTI) practices.', 'Seminar', 'completed', '2026-11-05', '2026-11-07', 2200.00, '2 Days', 'https://picsum.photos/seed/rti/600/400', '2026-05-19 00:37:50', '2026-05-19 05:35:56', 'Training on Right to Information Act, citizen rights, public service transparency, and information disclosure systems.', 55, 'Information Resource Center', 'https://images.unsplash.com/photo-1516321165247-4aa89a48be28?q=80&w=1200&auto=format&fit=crop'),
(89, 'Training on Grievance Redress System (GRS)', 'Training on grievance redress system procedures.', 'Seminar', 'upcoming', '2026-11-10', '2026-11-12', 1800.00, '2 Days', 'https://picsum.photos/seed/grs/600/400', '2026-05-19 00:37:50', '2026-05-19 05:35:56', 'Course on grievance redress procedures, complaint management systems, and citizen service improvement.', 50, 'GRS Training Room', 'https://images.unsplash.com/photo-1552664730-d307ca884978?q=80&w=1200&auto=format&fit=crop'),
(90, 'Training on Service Delivery Commitment', 'Course on service delivery commitment and implementation.', 'Seminar', 'upcoming', '2026-11-15', '2026-11-17', 1800.00, '2 Days', 'https://picsum.photos/seed/service/600/400', '2026-05-19 00:37:50', '2026-05-19 05:35:56', 'Training on public service commitment, service standards, customer satisfaction, and performance improvement.', 50, 'Service Excellence Center', 'https://images.unsplash.com/photo-1521737604893-d14cc237f11d?q=80&w=1200&auto=format&fit=crop'),
(91, 'Project Management, Financial Management, MTBF, SDG, Five Yearly Plan & APA', 'Training on project and financial management along with MTBF, SDG, APA.', 'Long Course', 'upcoming', '2026-12-01', '2026-12-20', 14000.00, '20 Days', 'https://picsum.photos/seed/project/600/400', '2026-05-19 00:37:50', '2026-05-19 05:35:56', 'Advanced management course covering project management, MTBF, SDG implementation, APA, and financial planning.', 35, 'Project Management Institute', 'https://images.unsplash.com/photo-1504384308090-c894fdcc538d?q=80&w=1200&auto=format&fit=crop'),
(92, 'Construction Project Site Management, Specification of Works and Construction Practices in Superstructures', 'Training on site management and construction practices in superstructures.', 'Long Course', 'ongoing', '2026-12-05', '2026-12-28', 13500.00, '23 Days', 'https://picsum.photos/seed/site/600/400', '2026-05-19 00:37:50', '2026-05-19 05:35:56', 'Comprehensive training on construction site supervision, specifications, safety, and superstructure practices.', 40, 'Construction Site Management Center', 'https://images.unsplash.com/photo-1541888946425-d81bb19240f5?q=80&w=1200&auto=format&fit=crop'),
(93, 'Orientation Course for Assistant Engineers (Civil & E/M)', 'Orientation course for assistant engineers in Civil and E/M.', 'Short Course', 'upcoming', '2027-01-05', '2027-01-12', 4000.00, '7 Days', 'https://picsum.photos/seed/orientation/600/400', '2026-05-19 00:37:50', '2026-05-19 05:35:56', 'Orientation program for newly appointed assistant engineers covering technical, administrative, and field activities.', 45, 'PWD Orientation Hall', 'https://images.unsplash.com/photo-1522202176988-66273c2fd55f?q=80&w=1200&auto=format&fit=crop'),
(94, 'Quality Control and Assurance in Building Construction Project', 'Training on quality control and assurance in construction projects.', 'Workshop', 'upcoming', '2027-01-15', '2027-01-22', 5500.00, '7 Days', 'https://picsum.photos/seed/quality/600/400', '2026-05-19 00:37:50', '2026-05-19 05:35:56', 'Training on quality assurance systems, construction material testing, and project quality control standards.', 38, 'Quality Assurance Laboratory', 'https://images.unsplash.com/photo-1504307651254-35680f356dfd?q=80&w=1200&auto=format&fit=crop'),
(95, 'Detail Estimate Preparation Course for SAES', 'Training on detailed estimate preparation for SAES.', 'Workshop', 'completed', '2027-02-01', '2027-02-08', 6000.00, '7 Days', 'https://picsum.photos/seed/estimate/600/400', '2026-05-19 00:37:50', '2026-05-19 05:35:56', 'Workshop on preparation of detailed engineering estimates, BOQ creation, and cost calculation methods.', 34, 'Estimation & Costing Lab', 'https://images.unsplash.com/photo-1554224154-26032ffc0d07?q=80&w=1200&auto=format&fit=crop'),
(96, 'Project Planning and Management Using MS Project', 'Training on project planning and management using MS Project.', 'Workshop', 'upcoming', '2027-02-10', '2027-02-18', 6500.00, '8 Days', 'https://picsum.photos/seed/msproject/600/400', '2026-05-19 00:37:50', '2026-05-19 05:35:56', 'Hands-on training using MS Project for project scheduling, resource management, and progress tracking.', 40, 'Project Software Lab', 'https://images.unsplash.com/photo-1516321318423-f06f85e504b3?q=80&w=1200&auto=format&fit=crop'),
(97, 'Refresher Training on Construction Practices and Quality Control', 'Refresher course on construction practices and quality control.', 'Workshop', 'ongoing', '2027-03-01', '2027-03-07', 4500.00, '6 Days', 'https://picsum.photos/seed/refresher/600/400', '2026-05-19 00:37:50', '2026-05-19 05:35:56', 'Refresher training on updated construction methods, site supervision, and quality assurance practices.', 36, 'Construction Refresher Center', 'https://images.unsplash.com/photo-1504307651254-35680f356dfd?q=80&w=1200&auto=format&fit=crop'),
(98, 'Refresher Course on Electronic Government Procurement (e-GP)', 'Refresher course on electronic government procurement.', 'Workshop', 'upcoming', '2027-03-10', '2027-03-15', 4200.00, '5 Days', 'https://picsum.photos/seed/refegp/600/400', '2026-05-19 00:37:50', '2026-05-19 05:35:56', 'Refresher course on e-GP operations, tender workflow updates, and procurement system best practices.', 42, 'e-GP Computer Lab', 'https://images.unsplash.com/photo-1516321318423-f06f85e504b3?q=80&w=1200&auto=format&fit=crop'),
(99, 'Training on Financial Management', 'Training on financial management practices.', 'Seminar', 'completed', '2027-03-20', '2027-03-24', 3000.00, '4 Days', 'https://picsum.photos/seed/finance/600/400', '2026-05-19 00:37:50', '2026-05-19 05:35:56', 'Training on budgeting, accounting systems, audit preparation, and financial reporting in government projects.', 48, 'Finance Management Hall', 'https://images.unsplash.com/photo-1554224155-6726b3ff858f?q=80&w=1200&auto=format&fit=crop'),
(100, 'Audit Procedure: Objection and Disposal', 'Training on audit procedures, objection handling, and disposal.', 'Seminar', 'upcoming', '2027-04-01', '2027-04-05', 2800.00, '4 Days', 'https://picsum.photos/seed/audit/600/400', '2026-05-19 00:37:50', '2026-05-19 05:35:56', 'Course covering audit objection handling, disposal methods, and government audit procedures.', 45, 'Audit & Compliance Center', 'https://images.unsplash.com/photo-1454165804606-c3d57bc86b40?q=80&w=1200&auto=format&fit=crop'),
(101, 'Office Management', 'Training on office management and administration.', 'Short Course', 'upcoming', '2027-04-10', '2027-04-15', 2500.00, '5 Days', 'https://picsum.photos/seed/office/600/400', '2026-05-19 00:37:50', '2026-05-19 05:35:56', 'Office administration training including communication, file management, documentation, and workplace efficiency.', 50, 'Administrative Training Room', 'https://images.unsplash.com/photo-1497366754035-f200968a6e72?q=80&w=1200&auto=format&fit=crop'),
(102, 'Computer Training on Operating System, MS Office, Internet Browsing, e-Mail etc.', 'Basic computer training including OS, MS Office, internet, and email.', 'Short Course', 'ongoing', '2027-04-20', '2027-04-30', 3500.00, '10 Days', 'https://picsum.photos/seed/computer/600/400', '2026-05-19 00:37:50', '2026-05-19 05:35:56', 'Basic computer literacy course covering operating systems, MS Office, internet browsing, and email communication.', 60, 'Computer Training Lab', 'https://images.unsplash.com/photo-1516321318423-f06f85e504b3?q=80&w=1200&auto=format&fit=crop'),
(103, 'Occupational Health and Safety in Building Construction Project', 'Training on occupational health and safety in construction projects.', 'Workshop', 'upcoming', '2027-05-05', '2027-05-12', 4800.00, '7 Days', 'https://picsum.photos/seed/safety/600/400', '2026-05-19 00:37:50', '2026-05-19 05:35:56', 'Training on occupational health, construction safety practices, PPE usage, and accident prevention systems.', 38, 'Health & Safety Center', 'https://images.unsplash.com/photo-1581092921461-eab62e97a780?q=80&w=1200&auto=format&fit=crop'),
(104, 'Dynamic Analysis of Structures', 'Advanced training on dynamic structural analysis.', 'Long Course', 'upcoming', '2027-05-15', '2027-06-05', 16000.00, '20 Days', 'https://picsum.photos/seed/dynamic/600/400', '2026-05-19 00:37:50', '2026-05-19 05:35:56', 'Advanced engineering course on dynamic structural behavior, earthquake analysis, and vibration systems.', 28, 'Structural Engineering Lab', 'https://images.unsplash.com/photo-1503387762-592deb58ef4e?q=80&w=1200&auto=format&fit=crop'),
(105, 'Design of Steel Structures: Theory and Modeling Using Software', 'Training on steel structure design and software modeling.', 'Long Course', 'ongoing', '2027-06-10', '2027-06-30', 17000.00, '20 Days', 'https://picsum.photos/seed/steel/600/400', '2026-05-19 00:37:50', '2026-05-19 05:35:56', 'Training on steel structure design principles, analysis methods, and software-based modeling techniques.', 30, 'Steel Design Research Lab', 'https://images.unsplash.com/photo-1517048676732-d65bc937f952?q=80&w=1200&auto=format&fit=crop'),
(106, 'Deep Excavation and Top Down Construction Method', '', 'Workshop', 'upcoming', '2027-07-05', '2027-07-12', 7200.00, '7 Days', '', '2026-05-19 00:37:50', '2026-05-19 05:35:56', 'Specialized workshop on deep excavation systems, retaining structures, and top-down construction methodology.', 32, 'Advanced Construction Training Ground', 'https://images.unsplash.com/photo-1541888946425-d81bb19240f5?q=80&w=1200&auto=format&fit=crop');

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `organization` varchar(255) DEFAULT NULL,
  `designation` varchar(255) DEFAULT NULL,
  `role` enum('user','admin') DEFAULT 'user',
  `status` enum('active','inactive') DEFAULT 'active',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `name`, `email`, `password`, `phone`, `organization`, `designation`, `role`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Super Admin', 'admin@pwdtraining.gov.bd', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', NULL, NULL, NULL, 'admin', 'active', '2026-05-09 09:13:15', '2026-05-09 09:13:15'),
(2, 'Admin', 'admin@pwd.gov.bd', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', NULL, NULL, NULL, 'admin', 'active', '2026-05-19 03:56:25', '2026-05-19 03:56:25'),
(3, 'Akash', 'akash@pwd.gov.bd', '$2y$10$K8P.T6lycnIEd.DSH2iPUOZBzwaWzZHKhnT/LvACHmcfBWwK2EHku', '01716015261', 'PWD', 'Computer Operator', 'user', 'active', '2026-05-23 10:46:52', '2026-05-23 10:46:52'),
(4, 'Akash', 'mywebmail@pwd.gov.bd', '$2y$10$VkKL8wK51LQv4KeDaHEZgeZvKGrJbG6V9kHk5MErkAFavu8iFSjzC', '01521403191', 'PWD', 'Sub-Assistant Engineer', 'user', 'active', '2026-05-24 04:34:46', '2026-05-24 04:34:46');

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

--
-- Table structure for table `videos`
--

CREATE TABLE `videos` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `url` varchar(500) NOT NULL,
  `thumbnail_url` varchar(500) DEFAULT NULL,
  `display_order` int(11) DEFAULT 0,
  `is_active` tinyint(1) DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `desc` text DEFAULT NULL,
  `thumb` varchar(500) DEFAULT NULL,
  `category` varchar(100) DEFAULT NULL,
  `duration` int(11) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `videos`
--

INSERT INTO `videos` (`id`, `title`, `url`, `thumbnail_url`, `display_order`, `is_active`, `created_at`, `updated_at`, `desc`, `thumb`, `category`, `duration`) VALUES
(1, 'Academy Introduction Tour', 'https://youtu.be/B8uVat71pl0?si=oM3wyL8xtAhSS4BR', 'https://picsum.photos/seed/vid1/400/250.jpg', 1, 1, '2026-05-09 09:13:16', '2026-05-21 09:52:56', 'This is demo', 'https://demo.shelltechnologiesbd.com//pwdta/uploads/thumbnail/mainbuilding_side.jpeg', 'Training', 2),
(2, 'AutoCAD Training Highlights', 'https://youtu.be/B8uVat71pl0?si=HAfXDxFTcMhivM1_', 'https://picsum.photos/seed/vid2/400/250.jpg', 2, 1, '2026-05-09 09:13:16', '2026-05-21 09:53:16', NULL, 'https://demo.shelltechnologiesbd.com//pwdta/uploads/thumbnail/main_building_front.jpeg', 'Training', 0),
(3, 'Concrete Testing Demonstration', 'https://youtu.be/RthaAj3q1FA?si=c7Flv209t7C9guzX', 'https://picsum.photos/seed/vid3/400/250.jpg', 3, 1, '2026-05-09 09:13:16', '2026-05-21 06:48:12', NULL, 'https://demo.shelltechnologiesbd.com/pwdta/uploads/thumbnail/class.jpeg', 'Training', 0);

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `certificates`
--
ALTER TABLE `certificates`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `certificate_no` (`certificate_no`),
  ADD KEY `idx_trainee` (`trainee_id`);

--
-- Indexes for table `contact_messages`
--
ALTER TABLE `contact_messages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_read` (`is_read`);

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

--
-- Indexes for table `enrollments`
--
ALTER TABLE `enrollments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_entity` (`entity_type`,`entity_id`),
  ADD KEY `idx_status` (`status`);

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

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

--
-- Indexes for table `gallery`
--
ALTER TABLE `gallery`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_category` (`category`);

--
-- Indexes for table `notices`
--
ALTER TABLE `notices`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_type` (`type`),
  ADD KEY `idx_date` (`notice_date`);

--
-- Indexes for table `officers`
--
ALTER TABLE `officers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_order` (`display_order`);

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

--
-- Indexes for table `site_settings`
--
ALTER TABLE `site_settings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `setting_key` (`setting_key`);

--
-- Indexes for table `sliders`
--
ALTER TABLE `sliders`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_order` (`display_order`);

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

--
-- Indexes for table `trainees`
--
ALTER TABLE `trainees`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `idx_email` (`email`),
  ADD KEY `idx_status` (`status`);

--
-- Indexes for table `trainings`
--
ALTER TABLE `trainings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_status` (`status`),
  ADD KEY `idx_category` (`category`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `email` (`email`),
  ADD KEY `idx_role` (`role`);

--
-- Indexes for table `videos`
--
ALTER TABLE `videos`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_order` (`display_order`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `admins`
--
ALTER TABLE `admins`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `certificates`
--
ALTER TABLE `certificates`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `contact_messages`
--
ALTER TABLE `contact_messages`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `employees`
--
ALTER TABLE `employees`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `enrollments`
--
ALTER TABLE `enrollments`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `equipment`
--
ALTER TABLE `equipment`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `facilities`
--
ALTER TABLE `facilities`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--
-- AUTO_INCREMENT for table `gallery`
--
ALTER TABLE `gallery`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `notices`
--
ALTER TABLE `notices`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `officers`
--
ALTER TABLE `officers`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=73;

--
-- AUTO_INCREMENT for table `site_settings`
--
ALTER TABLE `site_settings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

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

--
-- AUTO_INCREMENT for table `testings`
--
ALTER TABLE `testings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=45;

--
-- AUTO_INCREMENT for table `trainees`
--
ALTER TABLE `trainees`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `trainings`
--
ALTER TABLE `trainings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=107;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `videos`
--
ALTER TABLE `videos`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
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 */;
