-- phpMyAdmin SQL Dump
-- version 4.9.2
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: Oct 13, 2023 at 06:56 PM
-- Server version: 10.4.10-MariaDB
-- PHP Version: 7.3.12

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

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

--
-- Table structure for table `about`
--

DROP TABLE IF EXISTS `about`;
CREATE TABLE IF NOT EXISTS `about` (
  `id` int(11) NOT NULL,
  `matter` varchar(10000) NOT NULL,
  `image` varchar(1000) NOT NULL,
  `candidate_message_matter` varchar(2000) NOT NULL,
  `candidate_message_image` varchar(1001) NOT NULL,
  `introduction_matter` varchar(2000) NOT NULL,
  `introduction_image` varchar(1000) NOT NULL,
  `personal_description_matter` varchar(2000) NOT NULL,
  `personal_description_image` varchar(1000) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `about`
--

INSERT INTO `about` (`id`, `matter`, `image`, `candidate_message_matter`, `candidate_message_image`, `introduction_matter`, `introduction_image`, `personal_description_matter`, `personal_description_image`) VALUES
(1, '<p>Test Data</p>', 'uploads/logo14603.jpg', '<p>Test data?&nbsp;</p>', 'uploads/logo14603.jpg', '<p>Test data</p>', 'uploads/logo14603.jpg', '<p>test data</p>', 'uploads/logo14603.jpg');

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

--
-- Table structure for table `ads`
--

DROP TABLE IF EXISTS `ads`;
CREATE TABLE IF NOT EXISTS `ads` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(200) NOT NULL,
  `image` varchar(200) NOT NULL,
  `status` int(11) NOT NULL,
  `add_date` datetime NOT NULL,
  `start_date` datetime NOT NULL,
  `end_date` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `area`
--

DROP TABLE IF EXISTS `area`;
CREATE TABLE IF NOT EXISTS `area` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `area`
--

INSERT INTO `area` (`id`, `name`, `status`) VALUES
(1, 'Alberta', 1),
(2, 'British Columbia', 1),
(3, 'Manitoba', 1),
(4, 'New Brunswick', 1),
(5, 'Newfoundland and Labrador', 1),
(6, 'Northwest Territories', 1),
(7, 'Nova Scotia', 1),
(8, 'Nunavut', 1),
(9, 'Ontario', 1),
(10, 'Prince Edward Island', 1),
(11, 'Quebec', 1),
(12, 'Saskatchewan', 1),
(13, 'Yukon', 1);

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

--
-- Table structure for table `blog`
--

DROP TABLE IF EXISTS `blog`;
CREATE TABLE IF NOT EXISTS `blog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(500) NOT NULL,
  `description` varchar(1000) NOT NULL,
  `image` varchar(300) NOT NULL,
  `status` int(11) NOT NULL,
  `language` int(11) NOT NULL,
  `add_date` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `chanel`
--

DROP TABLE IF EXISTS `chanel`;
CREATE TABLE IF NOT EXISTS `chanel` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `image` varchar(500) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `collages`
--

DROP TABLE IF EXISTS `collages`;
CREATE TABLE IF NOT EXISTS `collages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `collage_name` varchar(500) NOT NULL,
  `collage_image` varchar(5000) NOT NULL,
  `detail_link` varchar(500) NOT NULL,
  `area` varchar(200) NOT NULL,
  `status` int(11) NOT NULL,
  `date` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `contact`
--

DROP TABLE IF EXISTS `contact`;
CREATE TABLE IF NOT EXISTS `contact` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `email` varchar(200) NOT NULL,
  `phone` varchar(20) NOT NULL,
  `subject` varchar(200) NOT NULL,
  `message` varchar(300) NOT NULL,
  `date` datetime NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `course`
--

DROP TABLE IF EXISTS `course`;
CREATE TABLE IF NOT EXISTS `course` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(200) NOT NULL,
  `image` varchar(200) NOT NULL,
  `category` varchar(50) NOT NULL,
  `status` int(11) NOT NULL,
  `add_date` datetime NOT NULL,
  `description` varchar(3000) NOT NULL,
  `for_grade` int(11) NOT NULL,
  `maker_team_member` int(11) NOT NULL,
  `you_tube_playlist` varchar(1000) NOT NULL,
  `pdf1` varchar(400) NOT NULL,
  `pdf2` varchar(400) NOT NULL,
  `pdf3` varchar(400) NOT NULL,
  `pdf4` varchar(400) NOT NULL,
  `pdf5` varchar(400) NOT NULL,
  `pdf6` varchar(400) NOT NULL,
  `time` varchar(50) NOT NULL,
  `lectures` varchar(20) NOT NULL,
  `v1` varchar(200) NOT NULL,
  `v2` varchar(200) NOT NULL,
  `v3` varchar(200) NOT NULL,
  `v4` varchar(200) NOT NULL,
  `v5` varchar(200) NOT NULL,
  `v6` varchar(200) NOT NULL,
  `v7` varchar(200) NOT NULL,
  `v8` varchar(200) NOT NULL,
  `v9` varchar(200) NOT NULL,
  `v10` varchar(200) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `course_category`
--

DROP TABLE IF EXISTS `course_category`;
CREATE TABLE IF NOT EXISTS `course_category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `course_question_result`
--

DROP TABLE IF EXISTS `course_question_result`;
CREATE TABLE IF NOT EXISTS `course_question_result` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `question_id` int(11) NOT NULL,
  `submited_answer` varchar(200) NOT NULL,
  `right_answer` varchar(100) NOT NULL,
  `grade_cat` int(11) NOT NULL,
  `course_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `course_quizizz`
--

DROP TABLE IF EXISTS `course_quizizz`;
CREATE TABLE IF NOT EXISTS `course_quizizz` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `course_id` int(11) NOT NULL,
  `question` varchar(500) NOT NULL,
  `right_answer` varchar(200) NOT NULL,
  `option_1` varchar(200) NOT NULL,
  `option_2` varchar(200) NOT NULL,
  `option_3` varchar(200) NOT NULL,
  `option_4` varchar(200) NOT NULL,
  `status` int(11) NOT NULL,
  `add_date` datetime NOT NULL,
  `grade_cat` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `email_subscription`
--

DROP TABLE IF EXISTS `email_subscription`;
CREATE TABLE IF NOT EXISTS `email_subscription` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(500) NOT NULL,
  `zip` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

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

DROP TABLE IF EXISTS `gallery`;
CREATE TABLE IF NOT EXISTS `gallery` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(200) NOT NULL,
  `image` varchar(200) NOT NULL,
  `category` varchar(50) NOT NULL,
  `status` int(11) NOT NULL,
  `add_date` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `gallery_category`
--

DROP TABLE IF EXISTS `gallery_category`;
CREATE TABLE IF NOT EXISTS `gallery_category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `general_setting`
--

DROP TABLE IF EXISTS `general_setting`;
CREATE TABLE IF NOT EXISTS `general_setting` (
  `id` int(11) NOT NULL,
  `site_url` varchar(500) NOT NULL,
  `site_title` varchar(1000) NOT NULL,
  `site_slogan` varchar(1000) NOT NULL,
  `site_logo` varchar(1000) NOT NULL,
  `address` varchar(1000) NOT NULL,
  `phone` varchar(20) NOT NULL,
  `email` varchar(100) NOT NULL,
  `facebook_link` varchar(500) NOT NULL,
  `instagram_link` varchar(500) NOT NULL,
  `twitter_link` varchar(500) NOT NULL,
  `telegram_link` varchar(500) NOT NULL,
  `whatss_app` varchar(500) NOT NULL,
  `linkdin` varchar(500) NOT NULL,
  `you_tube` varchar(500) NOT NULL,
  `facebook_embed` varchar(2000) NOT NULL,
  `twitter_embed` varchar(2000) NOT NULL,
  `instagram_embed` varchar(2000) NOT NULL,
  `featured_project` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`,`site_url`,`site_title`) USING HASH
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `general_setting`
--

INSERT INTO `general_setting` (`id`, `site_url`, `site_title`, `site_slogan`, `site_logo`, `address`, `phone`, `email`, `facebook_link`, `instagram_link`, `twitter_link`, `telegram_link`, `whatss_app`, `linkdin`, `you_tube`, `facebook_embed`, `twitter_embed`, `instagram_embed`, `featured_project`) VALUES
(1, 'Congress', 'Efficient Quality Homes', 'Efficient Quality Homes', 'uploads/logo4634.png', '1384 Queens Bay,Rossland,British Columbia(test)', '+1 (780) 850-0073', 'info@efficientqualityhomes.ca', '#', '#', '#', '#', '#', '#', '#', '&amp;lt;iframe src=&amp;quot;https://www.facebook.com/plugins/page.php?href=https%3A%2F%2Fwww.facebook.com%2FSharanjitSinghDhillonofficial&amp;amp;tabs=timeline&amp;amp;width=340&amp;amp;height=500&amp;amp;small_header=true&amp;amp;adapt_container_width=true&amp;amp;hide_cover=false&amp;amp;show_facepile=true&amp;amp;appId&amp;quot; width=&amp;quot;340&amp;quot; height=&amp;quot;320&amp;quot; style=&amp;quot;border:none;overflow:hidden&amp;quot; scrolling=&amp;quot;no&amp;quot; frameborder=&amp;quot;0&amp;quot; allowfullscreen=&amp;quot;true&amp;quot; allow=&amp;quot;autoplay; clipboard-write; encrypted-media; picture-in-picture; web-share&amp;quot;&amp;gt;&amp;lt;/iframe&amp;gt;\r\n', '&amp;lt;a class=&amp;quot;twitter-timeline&amp;quot; href=&amp;quot;https://twitter.com/s_s_dhillon?ref_src=twsrc%5Etfw&amp;quot;  height=&amp;quot;320&amp;quot;&amp;gt;Tweets by s_s_dhillon&amp;lt;/a&amp;gt; &amp;lt;script async src=&amp;quot;https://platform.twitter.com/widgets.js&amp;quot; charset=&amp;quot;utf-8&amp;quot;&amp;gt;&amp;lt;/script&amp;gt;', '&amp;lt;div data-mc-src=&amp;quot;43fa549b-6dfa-4e76-92f8-bf666d2ae0b6#instagram&amp;quot;&amp;gt;&amp;lt;/div&amp;gt;\r\n        \r\n&amp;lt;script \r\n  src=&amp;quot;https://cdn2.woxo.tech/a.js#6135af225b3e0400164892a8&amp;quot; \r\n  async data-usrc&amp;gt;\r\n&amp;lt;/script&amp;gt;', 1);

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

--
-- Table structure for table `joined_course`
--

DROP TABLE IF EXISTS `joined_course`;
CREATE TABLE IF NOT EXISTS `joined_course` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `course_id` int(11) NOT NULL,
  `join_date` datetime NOT NULL,
  `quiz_number` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `literature`
--

DROP TABLE IF EXISTS `literature`;
CREATE TABLE IF NOT EXISTS `literature` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(500) NOT NULL,
  `pdf` varchar(500) NOT NULL,
  `status` int(11) NOT NULL,
  `add_date` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `menu`
--

DROP TABLE IF EXISTS `menu`;
CREATE TABLE IF NOT EXISTS `menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(200) NOT NULL,
  `description` varchar(500) NOT NULL,
  `image` varchar(200) NOT NULL,
  `price` int(11) NOT NULL,
  `category` varchar(50) NOT NULL,
  `status` int(11) NOT NULL,
  `add_date` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `menu_category`
--

DROP TABLE IF EXISTS `menu_category`;
CREATE TABLE IF NOT EXISTS `menu_category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `news`
--

DROP TABLE IF EXISTS `news`;
CREATE TABLE IF NOT EXISTS `news` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(1000) NOT NULL,
  `news_print_link` varchar(1000) NOT NULL,
  `news_digital_link` varchar(2000) NOT NULL,
  `image` varchar(500) NOT NULL,
  `chanel` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `add_date` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `other_page`
--

DROP TABLE IF EXISTS `other_page`;
CREATE TABLE IF NOT EXISTS `other_page` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `main_slogan` varchar(1000) NOT NULL,
  `content` varchar(2000) NOT NULL,
  `image` varchar(1000) NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `project`
--

DROP TABLE IF EXISTS `project`;
CREATE TABLE IF NOT EXISTS `project` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(200) NOT NULL,
  `image` varchar(200) NOT NULL,
  `image1` varchar(200) NOT NULL,
  `image2` varchar(200) NOT NULL,
  `image3` varchar(200) NOT NULL,
  `image4` varchar(200) NOT NULL,
  `image5` varchar(200) NOT NULL,
  `image6` varchar(200) NOT NULL,
  `floor_plans` varchar(200) NOT NULL,
  `floor_plans2` varchar(500) NOT NULL,
  `video_link` varchar(200) NOT NULL,
  `category` varchar(50) NOT NULL,
  `project_by` varchar(500) NOT NULL,
  `publish_date` varchar(50) NOT NULL,
  `client` varchar(500) NOT NULL,
  `working` varchar(500) NOT NULL,
  `link` varchar(500) NOT NULL,
  `project_status` varchar(500) NOT NULL,
  `address` varchar(500) NOT NULL,
  `city` varchar(500) NOT NULL,
  `main_intersection` varchar(500) NOT NULL,
  `property_type` varchar(500) NOT NULL,
  `number_of_units` varchar(500) NOT NULL,
  `neighborhood` varchar(500) NOT NULL,
  `price` varchar(500) NOT NULL,
  `description` varchar(3000) NOT NULL,
  `status` int(11) NOT NULL,
  `add_date` datetime NOT NULL,
  `location` varchar(1000) NOT NULL,
  `bath` varchar(50) NOT NULL,
  `bed` varchar(50) NOT NULL,
  `sq` varchar(50) NOT NULL,
  `short_description` varchar(200) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `project_category`
--

DROP TABLE IF EXISTS `project_category`;
CREATE TABLE IF NOT EXISTS `project_category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `image_icon` varchar(600) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `project_images`
--

DROP TABLE IF EXISTS `project_images`;
CREATE TABLE IF NOT EXISTS `project_images` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `project_id` int(11) NOT NULL,
  `image` varchar(200) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `question_result`
--

DROP TABLE IF EXISTS `question_result`;
CREATE TABLE IF NOT EXISTS `question_result` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `question_id` int(11) NOT NULL,
  `submited_answer` varchar(200) NOT NULL,
  `right_answer` varchar(100) NOT NULL,
  `grade_cat` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=213 DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `review`
--

DROP TABLE IF EXISTS `review`;
CREATE TABLE IF NOT EXISTS `review` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `email` varchar(200) NOT NULL,
  `phone` int(20) NOT NULL,
  `ratting` int(11) NOT NULL,
  `review` varchar(1000) NOT NULL,
  `add_date` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `service`
--

DROP TABLE IF EXISTS `service`;
CREATE TABLE IF NOT EXISTS `service` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(999) NOT NULL,
  `description` varchar(1000) NOT NULL,
  `image` varchar(1000) NOT NULL,
  `add_date` datetime NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `setting`
--

DROP TABLE IF EXISTS `setting`;
CREATE TABLE IF NOT EXISTS `setting` (
  `setting_id` int(11) NOT NULL AUTO_INCREMENT,
  `locking` int(11) NOT NULL,
  PRIMARY KEY (`setting_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `setting`
--

INSERT INTO `setting` (`setting_id`, `locking`) VALUES
(1, 0);

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

--
-- Table structure for table `slider`
--

DROP TABLE IF EXISTS `slider`;
CREATE TABLE IF NOT EXISTS `slider` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `main_slogan` varchar(500) NOT NULL,
  `sub_slogan` varchar(600) NOT NULL,
  `image` varchar(1000) NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `slider`
--

INSERT INTO `slider` (`id`, `main_slogan`, `sub_slogan`, `image`, `status`) VALUES
(1, '', '', 'uploads/slider/slider1235.jpg', 0),
(2, '', '', 'uploads/slider/slider7106.jpg', 0),
(3, '', '', 'uploads/slider/slider8023.jpg', 0);

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

--
-- Table structure for table `social_media`
--

DROP TABLE IF EXISTS `social_media`;
CREATE TABLE IF NOT EXISTS `social_media` (
  `id` int(11) NOT NULL,
  `instagram_link` varchar(1000) NOT NULL,
  `facebook_link` varchar(1000) NOT NULL,
  `twitter_link` varchar(1000) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `social_media`
--

INSERT INTO `social_media` (`id`, `instagram_link`, `facebook_link`, `twitter_link`) VALUES
(1, '<iframe src=\"https://www.facebook.com/plugins/post.php?href=https%3A%2F%2Fwww.facebook.com%2Fjbtechz%2Fposts%2F399498818455539&show_text=true&width=500\" width=\"500\" height=\"498\" style=\"border:none;overflow:hidden\"  frameborder=\"0\" allowfullscreen=\"true\" allow=\"autoplay; clipboard-write; encrypted-media; picture-in-picture; web-share\"></iframe>', '<iframe src=\"https://www.facebook.com/plugins/post.php?href=https%3A%2F%2Fwww.facebook.com%2Fjbtechz%2Fposts%2F399498818455539&show_text=true&width=500\" width=\"500\" height=\"498\" style=\"border:none;overflow:hidden\"  frameborder=\"0\" allowfullscreen=\"true\" allow=\"autoplay; clipboard-write; encrypted-media; picture-in-picture; web-share\"></iframe>', '<iframe src=\"https://www.facebook.com/plugins/post.php?href=https%3A%2F%2Fwww.facebook.com%2Fjbtechz%2Fposts%2F399498818455539&show_text=true&width=500\" width=\"500\" height=\"498\" style=\"border:none;overflow:hidden\"  frameborder=\"0\" allowfullscreen=\"true\" allow=\"autoplay; clipboard-write; encrypted-media; picture-in-picture; web-share\"></iframe>');

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

--
-- Table structure for table `student_enquiry`
--

DROP TABLE IF EXISTS `student_enquiry`;
CREATE TABLE IF NOT EXISTS `student_enquiry` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `email` varchar(500) NOT NULL,
  `phone` varchar(50) NOT NULL,
  `subject` varchar(500) NOT NULL,
  `message` varchar(1000) NOT NULL,
  `add_date` datetime NOT NULL,
  `status` int(11) NOT NULL,
  `address` varchar(500) NOT NULL,
  `matriculation` varchar(1000) NOT NULL,
  `intermediate` varchar(1000) NOT NULL,
  `graduation` varchar(1000) NOT NULL,
  `ielts` varchar(1000) NOT NULL,
  `other` varchar(1000) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `student_pdf`
--

DROP TABLE IF EXISTS `student_pdf`;
CREATE TABLE IF NOT EXISTS `student_pdf` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `phone` varchar(25) NOT NULL,
  `email` varchar(100) NOT NULL,
  `student_pdf` varchar(1000) NOT NULL,
  `status` int(11) NOT NULL,
  `add_date` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `team`
--

DROP TABLE IF EXISTS `team`;
CREATE TABLE IF NOT EXISTS `team` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `designation` varchar(100) NOT NULL,
  `image` varchar(300) NOT NULL,
  `status` int(11) NOT NULL,
  `biography` varchar(1500) NOT NULL,
  `experience` varchar(50) NOT NULL,
  `email` varchar(100) NOT NULL,
  `phone` int(11) NOT NULL,
  `facebook` varchar(500) NOT NULL,
  `twitter` varchar(500) NOT NULL,
  `instagram` varchar(500) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `testimonial`
--

DROP TABLE IF EXISTS `testimonial`;
CREATE TABLE IF NOT EXISTS `testimonial` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `description` varchar(700) NOT NULL,
  `designation` varchar(150) NOT NULL,
  `image` varchar(500) NOT NULL,
  `add_date` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tutorial_quizizz`
--

DROP TABLE IF EXISTS `tutorial_quizizz`;
CREATE TABLE IF NOT EXISTS `tutorial_quizizz` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `question` varchar(500) NOT NULL,
  `right_answer` varchar(200) NOT NULL,
  `option_1` varchar(200) NOT NULL,
  `option_2` varchar(200) NOT NULL,
  `option_3` varchar(200) NOT NULL,
  `option_4` varchar(200) NOT NULL,
  `status` int(11) NOT NULL,
  `add_date` datetime NOT NULL,
  `grade_cat` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `tutorial_quizizz_dummy`
--

DROP TABLE IF EXISTS `tutorial_quizizz_dummy`;
CREATE TABLE IF NOT EXISTS `tutorial_quizizz_dummy` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `question` varchar(500) NOT NULL,
  `right_answer` varchar(200) NOT NULL,
  `option_1` varchar(200) NOT NULL,
  `option_2` varchar(200) NOT NULL,
  `option_3` varchar(200) NOT NULL,
  `option_4` varchar(200) NOT NULL,
  `status` int(11) NOT NULL,
  `add_date` datetime NOT NULL,
  `grade_cat` varchar(50) NOT NULL,
  `for_user` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `updates`
--

DROP TABLE IF EXISTS `updates`;
CREATE TABLE IF NOT EXISTS `updates` (
  `update_id` int(11) NOT NULL AUTO_INCREMENT,
  `update_type` tinyint(4) NOT NULL,
  `update_title` varchar(256) NOT NULL,
  `update_desc` blob NOT NULL,
  `update_img` varchar(256) NOT NULL,
  `update_start_date` date NOT NULL,
  `update_end_date` date NOT NULL,
  `update_priority` tinyint(4) NOT NULL,
  `update_status` tinyint(1) NOT NULL,
  `update_add_time` int(11) NOT NULL,
  PRIMARY KEY (`update_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `user`
--

DROP TABLE IF EXISTS `user`;
CREATE TABLE IF NOT EXISTS `user` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_login_id` varchar(2000) NOT NULL,
  `user_pass` varchar(20) NOT NULL,
  `user_role` tinyint(1) NOT NULL DEFAULT 2,
  `user_gender` varchar(20) NOT NULL,
  `user_name` varchar(128) NOT NULL,
  `user_pic` varchar(2000) NOT NULL,
  `user_fname` varchar(128) NOT NULL,
  `user_address` tinytext NOT NULL,
  `user_city` varchar(256) NOT NULL,
  `user_district` varchar(256) NOT NULL,
  `user_state` varchar(128) NOT NULL,
  `user_country` varchar(256) NOT NULL,
  `user_phone_no` varchar(20) NOT NULL,
  `user_alt_phone_no` varchar(20) NOT NULL,
  `user_email` varchar(2000) NOT NULL,
  `postal_code` varchar(2000) NOT NULL,
  `user_status` tinyint(1) NOT NULL DEFAULT 1,
  `user_language` int(11) NOT NULL,
  `doj` datetime NOT NULL,
  `study_detail` varchar(1000) NOT NULL,
  `nominee_name1` varchar(200) NOT NULL,
  `nominee_number1` varchar(50) NOT NULL,
  `nominee_name2` varchar(200) NOT NULL,
  `nominee_number2` varchar(50) NOT NULL,
  `do_work` varchar(500) NOT NULL,
  `expert_in` varchar(200) NOT NULL,
  `join_date` datetime NOT NULL DEFAULT current_timestamp(),
  `expiry_date` datetime NOT NULL DEFAULT current_timestamp(),
  `expiry_status` int(11) NOT NULL,
  `blood_group` varchar(20) NOT NULL,
  `qr_code` varchar(2500) NOT NULL,
  `designation` varchar(200) NOT NULL,
  `quiz_number` int(11) NOT NULL,
  `grade1` int(11) NOT NULL,
  `grade2` int(11) NOT NULL,
  `grade3` int(11) NOT NULL,
  `overall_grade` int(11) NOT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user`
--

INSERT INTO `user` (`user_id`, `user_login_id`, `user_pass`, `user_role`, `user_gender`, `user_name`, `user_pic`, `user_fname`, `user_address`, `user_city`, `user_district`, `user_state`, `user_country`, `user_phone_no`, `user_alt_phone_no`, `user_email`, `postal_code`, `user_status`, `user_language`, `doj`, `study_detail`, `nominee_name1`, `nominee_number1`, `nominee_name2`, `nominee_number2`, `do_work`, `expert_in`, `join_date`, `expiry_date`, `expiry_status`, `blood_group`, `qr_code`, `designation`, `quiz_number`, `grade1`, `grade2`, `grade3`, `overall_grade`) VALUES
(1, 'admin', 'admin', 1, 'Male', 'Admin', 'uploads/profile_pic/1-admin.png', 'Admin', 'test', 'test', 'test', 'test', 'test', '1231231232', '', 'admin', 'test', 1, 0, '2020-09-22 18:24:39', '', '', '', '', '', '', '', '2020-10-14 22:41:23', '2020-10-14 22:41:23', 1, '', '', '', 20, 0, 0, 0, 1);

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

--
-- Table structure for table `user_cat`
--

DROP TABLE IF EXISTS `user_cat`;
CREATE TABLE IF NOT EXISTS `user_cat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `u_action`
--

DROP TABLE IF EXISTS `u_action`;
CREATE TABLE IF NOT EXISTS `u_action` (
  `action_id` int(11) NOT NULL AUTO_INCREMENT,
  `panel_name` varchar(200) NOT NULL,
  `action_name` varchar(128) NOT NULL,
  `module` varchar(128) NOT NULL,
  `url` varchar(256) NOT NULL,
  `access_type` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`action_id`)
) ENGINE=MyISAM AUTO_INCREMENT=266 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `u_action`
--

INSERT INTO `u_action` (`action_id`, `panel_name`, `action_name`, `module`, `url`, `access_type`) VALUES
(176, 'backend', 'Add Question', 'Tutorial Quizizz', 'tutorial/add_question/(:any)', 1),
(175, 'backend', 'Manage Gallery', 'Image Gallery', 'gallery/manage_image/(:any)', 1),
(174, 'backend', 'Delete Gallery', 'Image Gallery', 'gallery/delete_image/(:any)', 1),
(173, 'backend', 'Edit Gallery', 'Image Gallery', 'gallery/edit_image/(:any)', 1),
(172, 'backend', 'Add Gallery', 'Image Gallery', 'gallery/add_image/(:any)', 1),
(171, 'backend', 'Delete Team', 'Team', 'team/delete_team/(:any)', 1),
(170, 'backend', 'Edit Team', 'Team', 'team/edit_team/(:any)', 1),
(13, 'backend', 'Login', 'Dashboard', '', 0),
(14, 'backend', 'Forgot Password', 'Dashboard', 'forgot_password', 0),
(15, 'backend', 'Dashboard', 'Dashboard', 'dashboard', 1),
(16, 'backend', 'Add', 'Application Panel', 'user_application_panel/add', 1),
(17, 'backend', 'Manage', 'Application Panel', 'user_application_panel/manage', 1),
(18, 'backend', 'Edit', 'Application Panel', 'user_application_panel/edit/(:any)', 1),
(19, 'backend', 'Delete', 'Application Panel', 'user_application_panel/delete/(:any)', 1),
(20, 'backend', 'Add', 'Actions', 'user_action/add', 1),
(21, 'backend', 'Manage', 'Actions', 'user_action/manage', 1),
(22, 'backend', 'Edit', 'Actions', 'user_action/edit/(:any)', 1),
(23, 'backend', 'Delete', 'Actions', 'user_action/delete/(:any)', 1),
(24, 'backend', 'Add', 'User Roles', 'user_role/add', 1),
(25, 'backend', 'Manage', 'User Roles', 'user_role/manage', 1),
(26, 'backend', 'Edit', 'User Roles', 'user_role/edit/(:any)', 1),
(27, 'backend', 'Delete', 'User Roles', 'user_role/delete/(:any)', 1),
(169, 'backend', 'Manage Team', 'Team', 'team/manage_team/(:any)', 1),
(168, 'backend', 'Add Team', 'Team', 'team/add_team/(:any)', 1),
(47, 'backend', 'Application', 'Settings', 'setting/app', 1),
(167, 'backend', 'Finacial Detail', 'User', 'user/financial', 1),
(166, 'backend', 'Change Password', 'User', 'user/reset_password', 1),
(165, 'backend', 'User Profile', 'User', 'user/profile', 1),
(51, 'backend', 'Update Role - Actions', 'User Roles', 'user_role/update_actions/(:any)', 1),
(53, 'backend', 'Logout', 'Dashboard', 'logout', 0),
(54, 'backend', 'Check Valid User ID (ajax)', 'User', 'user/valid_user_id/(:any)', 0),
(55, 'backend', 'User ID Exists (ajax)', 'User', 'user/user_id_exists/(:any)', 0),
(73, 'backend', 'Blank Link', 'User', '#', 0),
(146, 'backend', 'User List', 'User', 'user/user_list/(:any)', 1),
(164, 'backend', 'User Qr Code', 'User', 'user/qr_code/(:any)', 1),
(163, 'backend', 'Download Id Card', 'User', 'user/id_card/(:any)', 0),
(162, 'backend', 'Signup', 'Dashboard', 'signup', 0),
(177, 'backend', 'Manage Question', 'Tutorial Quizizz', 'tutorial/manage_question/(:any)', 1),
(178, 'backend', 'Edit Question', 'Tutorial Quizizz', 'tutorial/edit_question/(:any)', 1),
(179, 'backend', 'Delete Question', 'Tutorial Quizizz', 'tutorial/delete_question/(:any)', 1),
(180, 'backend', 'Add Blog', 'Blog', 'blog/add_blog/(:any)', 1),
(181, 'backend', 'Manage Blog', 'Blog', 'blog/manage_blog/(:any)', 1),
(182, 'backend', 'Delete Blog', 'Blog', 'blog/delete_blog/(:any)', 1),
(183, 'backend', 'Edit Blog', 'Blog', 'blog/edit_blog/(:any)', 1),
(184, 'backend', 'Add Literature', 'Literature', 'literature/add_literature/(:any)', 1),
(185, 'backend', 'Manage Literature', 'Literature', 'literature/manage_literature/(:any)', 1),
(186, 'backend', 'Delete Literature', 'Literature', 'literature/delete_literature/(:any)', 1),
(187, 'backend', 'Edit Literature', 'Literature', 'literature/edit_literature/(:any)', 1),
(188, 'backend', 'Manage ads', 'Ads', 'ads/manage_ads/(:any)', 1),
(189, 'backend', 'Delete ads', 'Ads', 'ads/delete_ads/(:any)', 1),
(190, 'backend', 'Edit ads', 'Ads', 'ads/edit_ads/(:any)', 1),
(191, 'backend', 'Add ads', 'Ads', 'ads/add_ads/(:any)', 1),
(192, 'backend', 'Add Video', 'Video', 'video/add_video/(:any)', 1),
(193, 'backend', 'Edit Video', 'Video', 'video/edit_video/(:any)', 1),
(194, 'backend', 'Delete Video', 'Video', 'video/delete_video/(:any)', 1),
(195, 'backend', 'Manage Video', 'Video', 'video/manage_video/(:any)', 1),
(196, 'backend', 'Add Gallery Category', 'Image Gallery', 'gallery/add_image_category/(:any)', 1),
(197, 'backend', 'Edit Gallery Category', 'Image Gallery', 'gallery/edit_image_category/(:any)', 1),
(198, 'backend', 'Manage Gallery Category', 'Image Gallery', 'gallery/manage_image_category/(:any)', 1),
(199, 'backend', 'Add Menu', 'Menu', 'menu_con/add_menu/(:any)', 1),
(200, 'backend', 'Edit Menu', 'Menu', 'menu_con/edit_menu/(:any)', 1),
(201, 'backend', 'Delete Menu', 'Menu', 'menu_con/delete_menu/(:any)', 1),
(202, 'backend', 'Manage Menu', 'Menu', 'menu_con/manage_menu/(:any)', 1),
(203, 'backend', 'Add Menu Category', 'Menu', 'menu_con/add_menu_category/(:any)', 1),
(204, 'backend', 'Edit Menu Category', 'Menu', 'menu_con/edit_menu_category/(:any)', 1),
(205, 'backend', 'Manage Menu Category', 'Menu', 'menu_con/manage_menu_category/(:any)', 1),
(206, 'backend', 'General Setting', 'General Setting', 'general_setting/add_setting/(:any)', 1),
(207, 'backend', 'Contact Enquery', 'User', 'user/contact_enquery/(:any)', 1),
(208, 'backend', 'Review', 'User', 'user/review/(:any)', 1),
(209, 'backend', 'Add Project', 'Project', 'project/add_project/(:any)', 1),
(210, 'backend', 'Edit Project', 'Project', 'project/edit_project/(:any)', 1),
(211, 'backend', 'Delete Project', 'Project', 'project/delete_project/(:any)', 1),
(212, 'backend', 'Manage Project', 'Project', 'project/manage_project/(:any)', 1),
(213, 'backend', 'Add Project Category', 'Project', 'project/add_project_category/(:any)', 1),
(214, 'backend', 'Edit Project Category', 'Project', 'project/edit_project_category/(:any)', 1),
(215, 'backend', 'Manage Project Category', 'Project', 'project/manage_project_category/(:any)', 1),
(216, 'backend', 'Add Slider', 'Slider', 'slider/add_slider/(:any)', 1),
(217, 'backend', 'Manage Slider', 'Slider', 'slider/manage_slider/(:any)', 1),
(218, 'backend', 'Edit Slider', 'Slider', 'slider/edit_slider/(:any)', 1),
(219, 'backend', 'Delete Slider', 'Slider', 'slider/delete_slider/(:any)', 1),
(220, 'backend', 'Add News Chanel', 'News Chanel', 'media/add_chanel/(:any)', 1),
(221, 'backend', 'Edit News Chanel', 'News Chanel', 'media/edit_chanel/(:any)', 1),
(222, 'backend', 'Manage News Chanel', 'News Chanel', 'media/manage_chanel/(:any)', 1),
(223, 'backend', 'Manage News', 'News', 'media/manage_news/(:any)', 1),
(224, 'backend', 'Delete News', 'News', 'media/delete_news/(:any)', 1),
(225, 'backend', 'Edit News', 'News', 'media/edit_news/(:any)', 1),
(226, 'backend', 'Add News', 'News', 'media/add_news/(:any)', 1),
(227, 'backend', 'About Page Setting', 'General Setting', 'general_setting/about_setting/(:any)', 1),
(228, 'backend', 'Social Media Setting', 'General Setting', 'general_setting/social_media/(:any)', 1),
(229, 'backend', 'Add Page', 'Other Page', 'other_page/add_page/(:any)', 1),
(230, 'backend', 'Manage Page', 'Other Page', 'other_page/manage_page/(:any)', 1),
(231, 'backend', 'Edit page', 'Other Page', 'other_page/edit_page/(:any)', 1),
(232, 'backend', 'Delete Page', 'Other Page', 'other_page/delete_page/(:any)', 1),
(233, 'backend', 'Volunteer Request', 'Volunteer Request', 'user/volunteer_request/(:any)', 1),
(234, 'backend', 'Add service', 'service', 'service/add_service/(:any)', 1),
(235, 'backend', 'Edit service', 'service', 'service/edit_service/(:any)', 1),
(236, 'backend', 'Delete service', 'service', 'service/delete_service/(:any)', 1),
(237, 'backend', 'Manage service', 'service', 'service/manage_service/(:any)', 1),
(238, 'backend', 'Add Collages', 'Collages', 'collages/add_collages/(:any)', 1),
(239, 'backend', 'Manage Collages', 'Collages', 'collages/manage_collages/(:any)', 1),
(240, 'backend', 'Edit Collages', 'Collages', 'collages/edit_collages/(:any)', 1),
(241, 'backend', 'Delete Collages', 'Collages', 'team/delete_team/(:any)', 1),
(242, 'backend', 'Student Form Enquiry', 'User', 'user/student_enquiry/(:any)', 1),
(243, 'backend', 'Student PDF Enquiry', 'User', 'user/student_pdf_upload/(:any)', 1),
(244, 'backend', 'User List Pending Req', 'User', 'user/user_list_pending/(:any)', 1),
(245, 'backend', 'Add Course Category', 'Course', 'course/add_course_category/(:any)', 1),
(246, 'backend', 'Edit Course Category', 'Course', 'course/edit_course_category/(:any)', 1),
(247, 'backend', 'Manage Course Category', 'Course', 'course/manage_course_category/(:any)', 1),
(248, 'backend', 'Add Course', 'Course', 'course/add_course/(:any)', 1),
(249, 'backend', 'Edit Course', 'Course', 'course/edit_course/(:any)', 1),
(250, 'backend', 'Delete Course', 'Course', 'course/delete_course/(:any)', 1),
(251, 'backend', 'Manage Course', 'Course', 'course/manage_course/(:any)', 1),
(252, 'backend', 'Add Question', 'Course Quizizz', 'course_quiz/add_question/(:any)', 1),
(253, 'backend', 'Manage Question', 'Course Quizizz', 'course_quiz/manage_question/(:any)', 1),
(254, 'backend', 'Edit Question', 'Course Quizizz', 'course_quiz/edit_question/(:any)', 1),
(255, 'backend', 'Delete Question', 'Course Quizizz', 'course_quiz/delete_question/(:any)', 1),
(256, 'backend', 'Show Course', 'Course Quizizz', 'course_quiz/show_course/(:any)', 1),
(257, 'backend', 'Manage testimonial', 'testimonial', 'testimonial/manage_testimonial/(:any)', 1),
(258, 'backend', 'Delete testimonial', 'testimonial', 'testimonial/delete_testimonial/(:any)', 1),
(259, 'backend', 'Edit testimonial', 'testimonial', 'testimonial/edit_testimonial/(:any)', 1),
(260, 'backend', 'Add testimonial', 'testimonial', 'testimonial/add_testimonial/(:any)', 1),
(261, 'backend', 'User Joined Courses', 'User', 'user/joined_courses/(:any)', 1),
(262, 'backend', 'Add Project images', 'Project', 'project/add_project_images/(:any)', 1),
(263, 'backend', 'Edit Project images', 'Project', 'project/edit_project_images/(:any)', 1),
(264, 'backend', 'Manage Project images', 'Project', 'project/manage_project_images/(:any)', 1),
(265, 'backend', 'Delete Project images', 'Project', 'project/delete_project_images/(:any)', 1);

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

--
-- Table structure for table `u_application_panel`
--

DROP TABLE IF EXISTS `u_application_panel`;
CREATE TABLE IF NOT EXISTS `u_application_panel` (
  `panel_id` int(11) NOT NULL AUTO_INCREMENT,
  `panel_name` varchar(256) NOT NULL,
  `slug` varchar(128) NOT NULL,
  PRIMARY KEY (`panel_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `u_application_panel`
--

INSERT INTO `u_application_panel` (`panel_id`, `panel_name`, `slug`) VALUES
(1, 'Backend', 'backend'),
(2, 'Frontend', '');

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

--
-- Table structure for table `u_role`
--

DROP TABLE IF EXISTS `u_role`;
CREATE TABLE IF NOT EXISTS `u_role` (
  `role_id` int(11) NOT NULL AUTO_INCREMENT,
  `role_name` varchar(128) NOT NULL,
  PRIMARY KEY (`role_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `u_role`
--

INSERT INTO `u_role` (`role_id`, `role_name`) VALUES
(1, 'Administrator'),
(2, 'User');

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

--
-- Table structure for table `u_role_action_mapping`
--

DROP TABLE IF EXISTS `u_role_action_mapping`;
CREATE TABLE IF NOT EXISTS `u_role_action_mapping` (
  `role_id` int(11) NOT NULL,
  `action_id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `u_role_action_mapping`
--

INSERT INTO `u_role_action_mapping` (`role_id`, `action_id`) VALUES
(2, 165),
(2, 55),
(2, 167),
(2, 163),
(2, 54),
(2, 166),
(2, 73),
(2, 162),
(2, 53),
(2, 13),
(2, 14),
(2, 15),
(1, 164),
(1, 167),
(1, 207),
(1, 166),
(1, 257),
(1, 259),
(1, 258),
(1, 260),
(1, 169),
(1, 170),
(1, 171),
(1, 168),
(1, 217),
(1, 218),
(1, 219),
(1, 216),
(1, 264),
(1, 215),
(1, 212),
(1, 263),
(1, 214),
(1, 210),
(1, 265),
(1, 211),
(1, 262),
(1, 213),
(1, 209),
(1, 175),
(1, 173),
(1, 174),
(1, 172),
(1, 206),
(1, 162),
(1, 53),
(1, 13),
(1, 14),
(1, 15),
(1, 181),
(1, 183),
(1, 182),
(1, 180),
(1, 22),
(1, 24),
(1, 27),
(1, 26),
(1, 25),
(1, 51);

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

--
-- Table structure for table `video`
--

DROP TABLE IF EXISTS `video`;
CREATE TABLE IF NOT EXISTS `video` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(200) NOT NULL,
  `video_link` varchar(200) NOT NULL,
  `status` int(11) NOT NULL,
  `add_date` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `volunteer_request`
--

DROP TABLE IF EXISTS `volunteer_request`;
CREATE TABLE IF NOT EXISTS `volunteer_request` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `email` varchar(200) NOT NULL,
  `phone` varchar(20) NOT NULL,
  `message` varchar(300) NOT NULL,
  `address` varchar(1000) NOT NULL,
  `date` datetime NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;
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 */;