-- phpMyAdmin SQL Dump
-- version 4.6.6deb5
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Aug 20, 2019 at 04:09 AM
-- Server version: 5.7.27-0ubuntu0.18.04.1
-- PHP Version: 7.2.20-2+ubuntu18.04.1+deb.sury.org+1

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

--
-- Database: `jobayan_db`
--

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

--
-- Table structure for table `notification`
--

CREATE TABLE `notification` (
  `notification_id` int(10) UNSIGNED NOT NULL,
  `notification_active` int(1) UNSIGNED NOT NULL DEFAULT '1',
  `notification_created` datetime NOT NULL,
  `notification_updated` datetime NOT NULL,
  `notification_title` varchar(255) DEFAULT NULL,
  `notification_body` text,
  `notification_type` varchar(255) DEFAULT NULL,
  `notification_meta` json DEFAULT NULL,
  `notification_flag` int(1) UNSIGNED DEFAULT '0',
  `notification_seen` int(1) NOT NULL DEFAULT '0',
  `notification_read_date` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `notification`
--
ALTER TABLE `notification`
  ADD PRIMARY KEY (`notification_id`),
  ADD KEY `notification_active` (`notification_active`),
  ADD KEY `notification_created` (`notification_created`),
  ADD KEY `notification_updated` (`notification_updated`),
  ADD KEY `notification_title` (`notification_title`),
  ADD KEY `notification_type` (`notification_type`),
  ADD KEY `notification_flag` (`notification_flag`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `notification`
--
ALTER TABLE `notification`
  MODIFY `notification_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;