text: -- phpMyAdmin SQL Dump
  -- version 4.6.6deb5
  -- https://www.phpmyadmin.net/
  --
  -- Host: localhost:3306
  -- Generation Time: Nov 26, 2018 at 11:42 AM
  -- Server version: 5.7.24-0ubuntu0.18.04.1
  -- PHP Version: 7.2.10-0ubuntu0.18.04.1
  
  SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  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: `culinary_college`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `aboutus`
  --
  
  CREATE TABLE `aboutus` (
    `id` int(11) NOT NULL,
    `company_name` varchar(100) NOT NULL,
    `address` varchar(100) NOT NULL,
    `phone1` varchar(15) NOT NULL,
    `phone2` varchar(15) DEFAULT NULL,
    `email` varchar(100) NOT NULL,
    `secondary_email` varchar(100) DEFAULT NULL,
    `opening_time` varchar(10) NOT NULL,
    `closing_time` varchar(10) NOT NULL,
    `fax` int(11) DEFAULT NULL,
    `facebook` varchar(100) DEFAULT NULL,
    `twitter` varchar(100) DEFAULT NULL,
    `instagram` varchar(100) DEFAULT NULL,
    `logo` varchar(100) NOT NULL,
    `description` text NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `alumni`
  --
  
  CREATE TABLE `alumni` (
    `id` int(11) NOT NULL,
    `batch` int(11) NOT NULL,
    `image` varchar(100) NOT NULL,
    `status` tinyint(4) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `alumni_meta`
  --
  
  CREATE TABLE `alumni_meta` (
    `id` int(11) NOT NULL,
    `alumni_id` int(11) NOT NULL,
    `student_name` varchar(100) NOT NULL,
    `address` varchar(100) NOT NULL,
    `phone` int(11) NOT NULL,
    `percentage` float NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `color_management`
  --
  
  CREATE TABLE `color_management` (
    `id` int(11) NOT NULL,
    `navbar_color` varchar(15) NOT NULL,
    `navbar_border` varchar(15) NOT NULL,
    `navbar_font` varchar(15) NOT NULL,
    `footer_color` varchar(15) NOT NULL,
    `footer_font` varchar(15) NOT NULL,
    `hover_color` varchar(15) NOT NULL,
    `second_footer_color` varchar(15) NOT NULL,
    `second_footer_font` varchar(15) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `course`
  --
  
  CREATE TABLE `course` (
    `id` int(11) NOT NULL,
    `course_name` varchar(100) NOT NULL,
    `description` text,
    `status` int(1) NOT NULL COMMENT 'active=1 inactive=0',
    `department_head_id` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `course_meta`
  --
  
  CREATE TABLE `course_meta` (
    `id` int(11) NOT NULL,
    `course_id` int(11) NOT NULL,
    `image` varchar(100) NOT NULL,
    `status` int(1) NOT NULL COMMENT 'active=1 inactive=0 pending=3'
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `download`
  --
  
  CREATE TABLE `download` (
    `id` int(11) NOT NULL,
    `document_title` varchar(100) NOT NULL,
    `document` varchar(100) NOT NULL,
    `status` int(1) NOT NULL COMMENT 'active=1 inactive=0'
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `facility`
  --
  
  CREATE TABLE `facility` (
    `id` int(11) NOT NULL,
    `facility_name` varchar(50) NOT NULL,
    `description` text,
    `status` int(1) NOT NULL COMMENT 'active=1 inactive=0 pending=3'
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `facility_meta`
  --
  
  CREATE TABLE `facility_meta` (
    `id` int(11) NOT NULL,
    `facility_id` int(11) NOT NULL,
    `image` varchar(200) NOT NULL,
    `status` int(1) NOT NULL COMMENT 'active=1 inactive=0'
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `faq_answer`
  --
  
  CREATE TABLE `faq_answer` (
    `id` int(11) NOT NULL,
    `answer` varchar(100) NOT NULL,
    `status` int(1) NOT NULL COMMENT '1=active 0=inactive',
    `question_id` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `faq_question`
  --
  
  CREATE TABLE `faq_question` (
    `id` int(11) NOT NULL,
    `question` varchar(100) NOT NULL,
    `status` int(1) NOT NULL COMMENT '1=active 0=inactive,3=>answered',
    `name` varchar(255) NOT NULL,
    `email` varchar(255) NOT NULL,
    `phone` varchar(15) NOT NULL,
    `address` varchar(255) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `gallery`
  --
  
  CREATE TABLE `gallery` (
    `id` int(11) NOT NULL,
    `type_id` int(11) NOT NULL COMMENT '1=>new&event,2=>facility,3=>course',
    `reference_id` int(11) NOT NULL,
    `status` tinyint(1) NOT NULL,
    `image` varchar(255) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `goal`
  --
  
  CREATE TABLE `goal` (
    `id` int(11) NOT NULL,
    `goal` varchar(1000) NOT NULL,
    `status` tinyint(1) NOT NULL COMMENT '1=active 0=inactive'
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `member`
  --
  
  CREATE TABLE `member` (
    `id` int(11) NOT NULL,
    `full_name` varchar(100) NOT NULL,
    `type_id` int(11) NOT NULL,
    `permanent_add` varchar(100) NOT NULL,
    `temporary_add` varchar(100) DEFAULT NULL,
    `phone1` varchar(15) NOT NULL,
    `phone2` varchar(15) DEFAULT NULL,
    `email` varchar(100) DEFAULT NULL,
    `image` varchar(100) DEFAULT NULL,
    `status` int(1) NOT NULL COMMENT '1=active 0=inactive'
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `member_type`
  --
  
  CREATE TABLE `member_type` (
    `id` int(11) NOT NULL,
    `type_name` varchar(100) NOT NULL,
    `status` int(11) NOT NULL COMMENT '1=active 0=inactive'
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `message`
  --
  
  CREATE TABLE `message` (
    `id` int(11) NOT NULL,
    `member_id` int(11) NOT NULL,
    `message` text NOT NULL,
    `status` tinyint(4) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `mission`
  --
  
  CREATE TABLE `mission` (
    `id` int(11) NOT NULL,
    `mission` varchar(1000) NOT NULL,
    `status` int(1) NOT NULL COMMENT '1=active 0=inactive'
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `news`
  --
  
  CREATE TABLE `news` (
    `id` int(11) NOT NULL,
    `date` int(11) NOT NULL,
    `title` varchar(10000) NOT NULL,
    `description` text NOT NULL,
    `status` tinyint(1) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `news_meta`
  --
  
  CREATE TABLE `news_meta` (
    `id` int(11) NOT NULL,
    `news_id` int(11) NOT NULL,
    `image` varchar(100) NOT NULL,
    `status` tinyint(4) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `slider`
  --
  
  CREATE TABLE `slider` (
    `id` int(11) NOT NULL,
    `slider_title` varchar(100) NOT NULL,
    `image` varchar(100) NOT NULL,
    `status` int(1) NOT NULL COMMENT 'active=1 inactive=0'
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `testimonials`
  --
  
  CREATE TABLE `testimonials` (
    `id` int(11) NOT NULL,
    `full_name` varchar(100) NOT NULL,
    `address` varchar(100) NOT NULL,
    `review` text NOT NULL,
    `image` varchar(255) DEFAULT NULL,
    `status` tinyint(1) NOT NULL COMMENT 'active=1 inactive=0'
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `vision`
  --
  
  CREATE TABLE `vision` (
    `id` int(11) NOT NULL,
    `vision` varchar(1000) NOT NULL,
    `status` int(1) NOT NULL COMMENT '1=active 0=inactive'
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `why_we`
  --
  
  CREATE TABLE `why_we` (
    `id` int(11) NOT NULL,
    `reason` varchar(10000) NOT NULL,
    `status` tinyint(1) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Indexes for dumped tables
  --
  
  --
  -- Indexes for table `aboutus`
  --
  ALTER TABLE `aboutus`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `alumni`
  --
  ALTER TABLE `alumni`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `alumni_meta`
  --
  ALTER TABLE `alumni_meta`
    ADD PRIMARY KEY (`id`),
    ADD KEY `alumni_id` (`alumni_id`);
  
  --
  -- Indexes for table `color_management`
  --
  ALTER TABLE `color_management`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `course`
  --
  ALTER TABLE `course`
    ADD PRIMARY KEY (`id`),
    ADD KEY `department_head_id` (`department_head_id`);
  
  --
  -- Indexes for table `course_meta`
  --
  ALTER TABLE `course_meta`
    ADD PRIMARY KEY (`id`),
    ADD KEY `course_id` (`course_id`);
  
  --
  -- Indexes for table `download`
  --
  ALTER TABLE `download`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `facility`
  --
  ALTER TABLE `facility`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `facility_meta`
  --
  ALTER TABLE `facility_meta`
    ADD PRIMARY KEY (`id`),
    ADD KEY `facility_id` (`facility_id`);
  
  --
  -- Indexes for table `faq_answer`
  --
  ALTER TABLE `faq_answer`
    ADD PRIMARY KEY (`id`),
    ADD KEY `question_id` (`question_id`);
  
  --
  -- Indexes for table `faq_question`
  --
  ALTER TABLE `faq_question`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `gallery`
  --
  ALTER TABLE `gallery`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `goal`
  --
  ALTER TABLE `goal`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `member`
  --
  ALTER TABLE `member`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `member_type`
  --
  ALTER TABLE `member_type`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `message`
  --
  ALTER TABLE `message`
    ADD PRIMARY KEY (`id`),
    ADD KEY `member_id` (`member_id`);
  
  --
  -- Indexes for table `mission`
  --
  ALTER TABLE `mission`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `news`
  --
  ALTER TABLE `news`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `news_meta`
  --
  ALTER TABLE `news_meta`
    ADD PRIMARY KEY (`id`),
    ADD KEY `news_id` (`news_id`);
  
  --
  -- Indexes for table `slider`
  --
  ALTER TABLE `slider`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `testimonials`
  --
  ALTER TABLE `testimonials`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `vision`
  --
  ALTER TABLE `vision`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `why_we`
  --
  ALTER TABLE `why_we`
    ADD PRIMARY KEY (`id`);
  
  --
  -- AUTO_INCREMENT for dumped tables
  --
  
  --
  -- AUTO_INCREMENT for table `aboutus`
  --
  ALTER TABLE `aboutus`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  --
  -- AUTO_INCREMENT for table `alumni`
  --
  ALTER TABLE `alumni`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  --
  -- AUTO_INCREMENT for table `alumni_meta`
  --
  ALTER TABLE `alumni_meta`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT for table `color_management`
  --
  ALTER TABLE `color_management`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  --
  -- AUTO_INCREMENT for table `course`
  --
  ALTER TABLE `course`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
  --
  -- AUTO_INCREMENT for table `course_meta`
  --
  ALTER TABLE `course_meta`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  --
  -- AUTO_INCREMENT for table `download`
  --
  ALTER TABLE `download`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  --
  -- AUTO_INCREMENT for table `facility`
  --
  ALTER TABLE `facility`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  --
  -- AUTO_INCREMENT for table `facility_meta`
  --
  ALTER TABLE `facility_meta`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  --
  -- AUTO_INCREMENT for table `faq_answer`
  --
  ALTER TABLE `faq_answer`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  --
  -- AUTO_INCREMENT for table `faq_question`
  --
  ALTER TABLE `faq_question`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  --
  -- AUTO_INCREMENT for table `gallery`
  --
  ALTER TABLE `gallery`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
  --
  -- AUTO_INCREMENT for table `goal`
  --
  ALTER TABLE `goal`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  --
  -- AUTO_INCREMENT for table `member`
  --
  ALTER TABLE `member`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
  --
  -- AUTO_INCREMENT for table `member_type`
  --
  ALTER TABLE `member_type`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
  --
  -- AUTO_INCREMENT for table `message`
  --
  ALTER TABLE `message`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  --
  -- AUTO_INCREMENT for table `mission`
  --
  ALTER TABLE `mission`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  --
  -- AUTO_INCREMENT for table `news`
  --
  ALTER TABLE `news`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
  --
  -- AUTO_INCREMENT for table `news_meta`
  --
  ALTER TABLE `news_meta`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
  --
  -- AUTO_INCREMENT for table `slider`
  --
  ALTER TABLE `slider`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
  --
  -- AUTO_INCREMENT for table `testimonials`
  --
  ALTER TABLE `testimonials`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
  --
  -- AUTO_INCREMENT for table `vision`
  --
  ALTER TABLE `vision`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  --
  -- AUTO_INCREMENT for table `why_we`
  --
  ALTER TABLE `why_we`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;
  --
  -- Constraints for dumped tables
  --
  
  --
  -- Constraints for table `faq_answer`
  --
  ALTER TABLE `faq_answer`
    ADD CONSTRAINT `faq_answer_ibfk_1` FOREIGN KEY (`question_id`) REFERENCES `faq_question` (`id`);
  
  --
  -- Constraints for table `message`
  --
  ALTER TABLE `message`
    ADD CONSTRAINT `message_ibfk_1` FOREIGN KEY (`member_id`) REFERENCES `member` (`id`);
  
  --
  -- Constraints for table `news_meta`
  --
  ALTER TABLE `news_meta`
    ADD CONSTRAINT `news_meta_ibfk_1` FOREIGN KEY (`news_id`) REFERENCES `news` (`id`);
  
  /*!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 */;
  