-- phpMyAdmin SQL Dump
-- version 4.8.4
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jun 15, 2026 at 06:23 PM
-- Server version: 10.1.37-MariaDB
-- PHP Version: 7.3.0

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
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: `latestconf`
--

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

--
-- Table structure for table `conference_registrations`
--

CREATE TABLE `conference_registrations` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `first_name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `country` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `cell_no` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `whatsapp_number` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `category` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `category_two` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ahpc_reg_number` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `institute` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `id_card_number` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `student_document` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `event_type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `workshop_type` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `registration_type` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `package` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `event_field` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `registration_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `is_finalized` tinyint(4) DEFAULT '0',
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `conference_registrations`
--

INSERT INTO `conference_registrations` (`id`, `user_id`, `first_name`, `last_name`, `email`, `country`, `cell_no`, `whatsapp_number`, `address`, `category`, `category_two`, `ahpc_reg_number`, `institute`, `id_card_number`, `student_document`, `event_type`, `workshop_type`, `registration_type`, `package`, `event_field`, `registration_date`, `is_finalized`, `updated_at`) VALUES
(4, 2, 'sadaf', 'naz', 'nazo.satti99@gmail.com', 'Iraq', '34564354645', '03436782021', '', 'Student', 'Individual', '', 'abc', '61101-1968129-2', 'uploads/student_docs/student_2_1781452758_1781452758.jpg', 'Gala Dinner', '', '', NULL, NULL, '2026-06-14 15:59:18', 0, '2026-06-14 15:59:18'),
(3, 2, 'sadaf', 'naz', 'nazo.satti99@gmail.com', 'Pakistan', '34564354645', '12341233243', 'student individual conference registration', 'Student', 'Individual', '', 'zdsfas', '61101-1968129-2', 'uploads/student_docs/student_2_1781452548_1781452548.jpg', 'Conference Registration', '', '', NULL, NULL, '2026-06-14 15:55:48', 0, '2026-06-14 16:04:15'),
(5, 2, 'sadaf', 'naz', 'nazo.satti99@gmail.com', 'Pakistan', '34564354645', '12341233243', 'House # 03, St # O3, New  Abadi, Alipur, Islamabad', 'Professional', 'Package', '6723423', 'zdsfas', '61101-1968129-2', '', 'Conference Registration', '', 'Group Discount (5 Person)', NULL, NULL, '2026-06-14 16:40:56', 0, '2026-06-15 06:58:45'),
(6, 2, 'sadaf', 'naz', 'nazo.satti99@gmail.com', 'Pakistan', '34564354645', '123412332436', 'House # 03, St # O3, New  Abadi, Alipur, Islamabad', 'Professional', 'Package', '', 'abc', '61101-1968129-2', '', 'Conference Registration', '', 'Group Discount (5 Person)', NULL, NULL, '2026-06-15 04:38:20', 0, '2026-06-15 05:23:50'),
(7, 2, 'sadaf', 'naz', 'nazo.satti99@gmail.com', 'Pakistan', '34564354645', '12341233243', 'House # 03, St # O3, New  Abadi, Alipur, Islamabad', 'Professional', 'Package', '6723423', 'abc', '61101-1968129-2', '', 'Conference Registration', '', 'Group Discount (5 Person)', NULL, NULL, '2026-06-15 07:23:45', 0, '2026-06-15 07:23:45'),
(8, 2, 'sadaf', 'naz', 'nazo.satti99@gmail.com', 'Pakistan', '34564354645', '12341233243', '', 'Student', 'Individual', '', 'abc', '61101-1968129-2', 'uploads/student_docs/student_2_1781508477_1781508477.png', 'Workshop Registration', 'International', '', NULL, NULL, '2026-06-15 07:27:57', 0, '2026-06-15 07:27:57');

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

--
-- Table structure for table `papers`
--

CREATE TABLE `papers` (
  `id` int(11) NOT NULL,
  `author_name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `pdf_file` varchar(255) NOT NULL,
  `status` varchar(200) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `papers`
--

INSERT INTO `papers` (`id`, `author_name`, `email`, `pdf_file`, `status`, `created_at`) VALUES
(1, 'Sadaf Usman', 'usmanmasood021@gmail.com', '1781501361_Abstract submission template.docx', 'Approved', '2026-06-15 05:33:30'),
(4, 'sadaf naz', 'sadaf.naz@fui.edu.pk', '1781509395_Abstractsubmissiontemplate (3).docx', 'Approved', '2026-06-15 07:44:21');

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

--
-- Table structure for table `sponsorship`
--

CREATE TABLE `sponsorship` (
  `id` int(11) NOT NULL,
  `event_name` varchar(255) NOT NULL,
  `full_name` varchar(255) NOT NULL,
  `location` varchar(255) NOT NULL,
  `institute` varchar(255) NOT NULL,
  `id_card_number` varchar(50) NOT NULL,
  `country_state` varchar(250) NOT NULL,
  `cell_number` varchar(20) NOT NULL,
  `whatsapp_number` varchar(20) NOT NULL,
  `email` varchar(20) NOT NULL,
  `address` text NOT NULL,
  `ahpc_number` varchar(100) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sponsorship`
--

INSERT INTO `sponsorship` (`id`, `event_name`, `full_name`, `location`, `institute`, `id_card_number`, `country_state`, `cell_number`, `whatsapp_number`, `email`, `address`, `ahpc_number`, `created_at`) VALUES
(1, 'Conference', 'Usman Masood', 'asdfsdf', 'abc', '61101-1968129-2', 'Pakistan', '978126341324', '12341233243', 'usmanmasood021@gmail', 'House # 03, St # O3, New  Abadi, Alipur, Islamabad', '3452345', '2026-06-15 05:58:28');

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

--
-- Table structure for table `team_members`
--

CREATE TABLE `team_members` (
  `id` int(11) NOT NULL,
  `registration_id` int(11) NOT NULL,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `team_members`
--

INSERT INTO `team_members` (`id`, `registration_id`, `name`, `email`, `phone`, `created_at`) VALUES
(1, 1, 'Usman Masood', 'usmanmasood021@gmail.com', '03430560836', '2026-06-14 15:52:31'),
(2, 1, 'Usman Masood', 'usmanmasood021@gmail.com', '03430560836', '2026-06-14 15:52:31'),
(3, 1, 'Usman Masood', 'usmanmasood021@gmail.com', '03430560836', '2026-06-14 15:52:31'),
(4, 1, 'Usman Masood', 'usmanmasood021@gmail.com', '03430560836', '2026-06-14 15:52:31'),
(5, 1, 'Usman Masood', 'usmanmasood021@gmail.com', '03430560836', '2026-06-14 15:52:31'),
(55, 5, 'Usman Masood', 'usmanmasood021@gmail.com', '03430560836', '2026-06-15 06:58:51'),
(54, 5, 'Usman Masood', 'usmanmasood021@gmail.com', '03430560836', '2026-06-15 06:58:51'),
(53, 5, 'Usman Masood', 'usmanmasood021@gmail.com', '03430560836', '2026-06-15 06:58:51'),
(52, 5, 'Usman Masood', 'usmanmasood021@gmail.com', '03430560836', '2026-06-15 06:58:51'),
(51, 5, 'Usman Masood', 'usmanmasood021@gmail.com', '03430560836', '2026-06-15 06:58:51'),
(35, 6, 'Usma', 'usmanmasood021@gmail.com', '03430560836', '2026-06-15 05:23:50'),
(34, 6, 'Us', 'usmanmasood021@gmail.com', '03430560836', '2026-06-15 05:23:50'),
(33, 6, 'Usm', 'usmanmasood021@gmail.com', '03430560836', '2026-06-15 05:23:50'),
(32, 6, 'Usman m', 'usmanmasood021@gmail.com', '03430560836', '2026-06-15 05:23:50'),
(31, 6, 'Usman satti', 'usmanmasood021@gmail.com', '03430560836', '2026-06-15 05:23:50'),
(56, 7, 'sadaf', 'usmanmasood021@gmail.com', '03430560836', '2026-06-15 07:23:45'),
(57, 7, 'Usman Masood', 'usmanmasood021@gmail.com', '03430560836', '2026-06-15 07:23:45'),
(58, 7, 'Usman Masood', 'usmanmasood021@gmail.com', '03430560836', '2026-06-15 07:23:45'),
(59, 7, 'Usman Masood', 'usmanmasood021@gmail.com', '03430560836', '2026-06-15 07:23:45'),
(60, 7, 'Usman Masood', 'usmanmasood021@gmail.com', '03430560836', '2026-06-15 07:23:45');

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

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

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `first_name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `users` (`id`, `first_name`, `last_name`, `email`, `password`, `created_at`) VALUES
(2, 'sadaf', 'naz', 'nazo.satti99@gmail.com', '$2y$10$pEUPTGAI99Sfz1J4XD7qGuPj7FzDuabqJAosuN0s1wUrRzmWYX0Ie', '2026-06-14 15:55:08');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `conference_registrations`
--
ALTER TABLE `conference_registrations`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`);

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

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

--
-- Indexes for table `team_members`
--
ALTER TABLE `team_members`
  ADD PRIMARY KEY (`id`),
  ADD KEY `registration_id` (`registration_id`);

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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