-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `lotus`
--

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

--
-- Table structure for table `tbl_event`
--

CREATE TABLE `tbl_event` (
  `id` int(11) NOT NULL,
  `post_category_id` int(11) NOT NULL,
  `event_title` varchar(255) NOT NULL,
  `event_description` text NOT NULL,
  `event_title_image` varchar(255) NOT NULL,
  `event_images` varchar(255) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `tbl_game`
--

CREATE TABLE `tbl_game` (
  `id` int(11) NOT NULL,
  `game_title` varchar(255) NOT NULL,
  `game_category_id` int(11) NOT NULL,
  `title_photo` varchar(255) NOT NULL,
  `game_photos` varchar(255) NOT NULL,
  `game_video` varchar(255) NOT NULL,
  `game_description` text NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `tbl_game_category`
--

CREATE TABLE `tbl_game_category` (
  `id` int(11) NOT NULL,
  `game_category_name` varchar(255) NOT NULL,
  `game_category_color` varchar(100) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `tbl_noti`
--

CREATE TABLE `tbl_noti` (
  `id` int(11) NOT NULL,
  `post_category_id` int(11) NOT NULL,
  `noti_photo` varchar(255) NOT NULL,
  `noti_title` varchar(255) NOT NULL,
  `noti_description` text NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbl_noti`
--

INSERT INTO `tbl_noti` (`id`, `post_category_id`, `noti_photo`, `noti_title`, `noti_description`, `created_at`, `updated_at`) VALUES
(6, 1, 'upload/noti/2022/Apr/activ_photos_02_6248270ed7eca.jpg', 'test', '<p>afsd sdfsdf sdfs </p>', '2022-04-02 10:35:58', '2022-04-02 10:35:58');

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

--
-- Table structure for table `tbl_post_category`
--

CREATE TABLE `tbl_post_category` (
  `id` int(11) NOT NULL,
  `post_category_name` varchar(255) NOT NULL,
  `post_category_color` varchar(100) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbl_post_category`
--

INSERT INTO `tbl_post_category` (`id`, `post_category_name`, `post_category_color`, `created_at`, `updated_at`) VALUES
(1, 'News', '#ff0000', '2022-04-01 11:51:45', '2022-04-01 11:51:57');

--
-- Indexes for dumped tables
--

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `tbl_event`
--
ALTER TABLE `tbl_event`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_game`
--
ALTER TABLE `tbl_game`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_game_category`
--
ALTER TABLE `tbl_game_category`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

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

