-- phpMyAdmin SQL Dump
-- version 4.9.5deb2
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Jan 16, 2021 at 07:54 AM
-- Server version: 8.0.22
-- PHP Version: 7.4.3

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

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

--
-- Table structure for table `blog_post`
--

CREATE TABLE `blog_post` (
  `id` int NOT NULL,
  `title_name` varchar(350) NOT NULL,
  `description` text NOT NULL,
  `picture` varchar(500) NOT NULL,
  `created_by` varchar(100) NOT NULL,
  `created_at` varchar(100) NOT NULL,
  `updated_at` varchar(100) DEFAULT NULL,
  `label_cature_urgency` varchar(100) NOT NULL,
  `unique_key` varchar(100) NOT NULL,
  `querryname` varchar(100) NOT NULL,
  `formated_created_at` varchar(100) NOT NULL,
  `formated_diplay_created_at` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `blog_post`
--

INSERT INTO `blog_post` (`id`, `title_name`, `description`, `picture`, `created_by`, `created_at`, `updated_at`, `label_cature_urgency`, `unique_key`, `querryname`, `formated_created_at`, `formated_diplay_created_at`) VALUES
(1, 'Counselling Day', 'We are having a couselling day as cifoseti benin', 'uploads/blogs/news-208.23.16.jpeg', 'Cifoseti-Benin Admin', '2021-01-05 20:23:16', '2021-01-05 20:57:21pm', 'Urgent', 'EbkOvTsM', 'Counselling Day', '5th January 2021 20:23:16 pm', '5th January 2021'),
(2, 'Scholarship', 'We are helping international students get free scholarships.The students are required to have their original certificates which will be used as an evidence or reference of their qualifications.', 'uploads/blogs/admissions05.25.52.jpeg', 'Cifoseti-Benin Admin', '2021-01-05 20:27:47', '6th January 2021 06:25:52 am', 'Important and urgent', 'OBiZZ35W', 'Scholarship Admission', '5th January 2021 220:27:47pm', '5th January 2021'),
(3, 'Looking For Any admission in any University Abroad?', 'Have been suffering from deep thoughts? on where and which University to get admissions from abroad? Worry no more we as Cifoseti Benin are the bridge to your dream University.This season its your season ,we have got a couple of vacancies and opportunities in various best universities in the world', 'uploads/blogs/news-406.24.21.jpeg', 'Cifoseti-Benin Admin', '6th January 2021 06:24:21 am', NULL, 'Latest and Important', 'DHv4ERTQ', 'Looking For Any Admission In Any University Abroad?', '6th January 2021 06:24:21 am', '6th January 2021');

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `blog_post`
--
ALTER TABLE `blog_post`
  MODIFY `id` int 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 */;
