-- phpMyAdmin SQL Dump
-- version 4.5.1
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Jun 23, 2017 at 12:57 PM
-- Server version: 10.1.13-MariaDB
-- PHP Version: 7.0.8

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

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

--
-- Table structure for table `game`
--

CREATE TABLE `game` (
  `id` int(11) NOT NULL,
  `game_id` int(11) NOT NULL,
  `game_name` varchar(255) NOT NULL,
  `game_type` varchar(255) NOT NULL,
  `game_subtype` varchar(255) NOT NULL DEFAULT '',
  `image_id` int(11) NOT NULL,
  `image_url` varchar(255) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `game`
--

INSERT INTO `game` (`id`, `game_id`, `game_name`, `game_type`, `game_subtype`, `image_id`, `image_url`, `created_at`, `updated_at`) VALUES
(111, 1, 'helicopter', 'helicopter', '', 0, 'Tulips.jpg', '2017-05-09 11:32:26', '2017-05-09 11:32:26'),
(112, 1, 'helicopter', 'helicopter', '', 0, '01 - Baarish - DownloadMing.SE.mp3', '2017-05-09 11:32:26', '2017-05-09 11:38:07'),
(113, 2, 'memory', 'memory', '', 0, 'Tulips.jpg', '2017-05-09 11:32:38', '2017-05-09 11:32:38'),
(114, 2, 'memory', 'memory', '', 0, 'Penguins.jpg', '2017-05-09 11:32:38', '2017-05-09 11:32:38'),
(115, 2, 'memory', 'memory', '', 0, 'Lighthouse.jpg', '2017-05-09 11:32:38', '2017-05-09 11:32:38'),
(116, 2, 'memory', 'memory', '', 0, 'Lighthouse.jpg', '2017-05-09 11:37:27', '2017-05-09 11:37:27'),
(117, 2, 'memory', 'memory', '', 0, 'Jellyfish.jpg', '2017-05-09 11:37:27', '2017-05-09 11:37:27'),
(118, 2, 'memory', 'memory', '', 0, 'Desert.jpg', '2017-05-09 11:37:27', '2017-05-09 11:37:27'),
(119, 2, 'memory', 'memory', '', 0, 'Chrysanthemum.jpg', '2017-05-09 11:37:27', '2017-05-09 11:37:27'),
(120, 2, 'memory', 'memory', '', 0, 'Koala.jpg', '2017-05-09 11:37:27', '2017-05-09 11:37:27'),
(121, 3, 'quiz game', 'quiz game', 'colors', 0, 'Chrysanthemum.jpg', '2017-05-09 11:38:31', '2017-05-09 11:38:31'),
(122, 3, 'quiz game', 'quiz game', 'colors', 0, 'Desert.jpg', '2017-05-09 11:38:31', '2017-05-09 11:38:31'),
(123, 3, 'quiz game', 'quiz game', 'colors', 0, 'Hydrangeas.jpg', '2017-05-09 11:38:31', '2017-05-09 11:38:31'),
(124, 3, 'quiz game', 'quiz game', 'colors', 0, 'Jellyfish.jpg', '2017-05-09 11:38:31', '2017-05-09 11:38:31'),
(125, 3, 'quiz game', 'quiz game', 'colors', 0, 'Koala.jpg', '2017-05-09 11:38:31', '2017-05-09 11:38:31'),
(126, 3, 'quiz game', 'quiz game', 'letters', 0, 'Tulips.jpg', '2017-05-09 11:38:50', '2017-05-09 11:38:50'),
(127, 3, 'quiz game', 'quiz game', 'letters', 0, 'Penguins.jpg', '2017-05-09 11:38:51', '2017-05-09 11:38:51'),
(128, 3, 'quiz game', 'quiz game', 'letters', 0, 'Lighthouse.jpg', '2017-05-09 11:38:51', '2017-05-09 11:38:51'),
(129, 3, 'quiz game', 'quiz game', 'letters', 0, 'Koala.jpg', '2017-05-09 11:38:51', '2017-05-09 11:38:51'),
(130, 3, 'quiz game', 'quiz game', 'letters', 0, 'Jellyfish.jpg', '2017-05-09 11:38:51', '2017-05-09 11:38:51'),
(131, 3, 'quiz game', 'quiz game', 'numbers', 0, 'Chrysanthemum.jpg', '2017-05-09 11:39:19', '2017-05-09 11:39:19'),
(132, 3, 'quiz game', 'quiz game', 'numbers', 0, 'Desert.jpg', '2017-05-09 11:39:19', '2017-05-09 11:39:19'),
(133, 3, 'quiz game', 'quiz game', 'numbers', 0, 'Hydrangeas.jpg', '2017-05-09 11:39:19', '2017-05-09 11:39:19'),
(134, 3, 'quiz game', 'quiz game', 'numbers', 0, 'Jellyfish.jpg', '2017-05-09 11:39:19', '2017-05-09 11:39:19'),
(135, 3, 'quiz game', 'quiz game', 'numbers', 0, 'Koala.jpg', '2017-05-09 11:39:19', '2017-05-09 11:39:19'),
(136, 4, 'WordSearch', 'WordSearch', '', 0, 'asdasdasd', '2017-06-23 09:30:23', '2017-06-23 09:38:20'),
(137, 4, 'WordSearch', 'WordSearch', '', 0, 'asdb', '2017-06-23 09:30:23', '2017-06-23 09:38:27'),
(138, 4, 'WordSearch', 'WordSearch', '', 0, 'asdw', '2017-06-23 09:30:23', '2017-06-23 09:38:30'),
(139, 4, 'WordSearch', 'WordSearch', '', 0, 'asde', '2017-06-23 09:30:23', '2017-06-23 09:38:31'),
(140, 4, 'WordSearch', 'WordSearch', '', 0, 'asdr', '2017-06-23 09:30:23', '2017-06-23 09:38:33'),
(141, 4, 'WordSearch', 'WordSearch', '', 0, 'asdt', '2017-06-23 09:30:23', '2017-06-23 09:38:34'),
(142, 4, 'WordSearch', 'WordSearch', '', 0, 'asd', '2017-06-23 09:30:23', '2017-06-23 09:30:23'),
(143, 4, 'WordSearch', 'WordSearch', '', 0, 'asd', '2017-06-23 09:30:23', '2017-06-23 09:30:23'),
(144, 4, 'WordSearch', 'WordSearch', '', 0, 'asdasdd', '2017-06-23 09:30:23', '2017-06-23 09:38:25'),
(145, 5, 'buildaword', 'buildaword', '', 0, 'Deserunt sed eligendi optio excepteur laboris commodo dolorum sint voluptatem culpa tenetur blanditiis architecto', '2017-06-23 09:44:38', '2017-06-23 09:45:26'),
(146, 5, 'buildaword', 'buildaword', '', 0, 'Consequatur rerum natus minim perferendis et harum id id', '2017-06-23 09:44:38', '2017-06-23 09:45:26'),
(147, 5, 'buildaword', 'buildaword', '', 0, 'Autem quos non dolorem velit itaque', '2017-06-23 09:44:38', '2017-06-23 09:45:26'),
(148, 5, 'buildaword', 'buildaword', '', 0, 'Quasi consequat Esse nobis officia esse possimus reprehenderit', '2017-06-23 09:44:38', '2017-06-23 09:45:26'),
(149, 5, 'buildaword', 'buildaword', '', 0, 'Ex enim enim ullamco sit rerum ab qui dolore expedita distinctio Harum eu', '2017-06-23 09:44:38', '2017-06-23 09:45:26'),
(150, 5, 'buildaword', 'buildaword', '', 0, 'Voluptas est ex explicabo Corrupti fugiat molestiae tempore sunt qui similique ab qui illo distinctio Maiores', '2017-06-23 09:44:38', '2017-06-23 09:45:26'),
(151, 5, 'buildaword', 'buildaword', '', 0, 'Cillum qui vel eum qui perferendis eos itaque veniam', '2017-06-23 09:44:38', '2017-06-23 09:45:26'),
(152, 5, 'buildaword', 'buildaword', '', 0, 'Iusto tempor ut voluptatem Alias iusto dolorem consequuntur et amet incidunt et quia ea et eveniet sapiente eos voluptatem deserunt', '2017-06-23 09:44:38', '2017-06-23 09:45:26'),
(153, 5, 'buildaword', 'buildaword', '', 0, 'Id et quae accusamus aliquam dolore consequuntur est delectus in neque et dolore voluptatem aspernatur explicabo Perferendis vero sed elit', '2017-06-23 09:44:38', '2017-06-23 09:45:26'),
(154, 5, 'buildaword', 'buildaword', '', 0, 'Distinctio Accusantium sint anim veniam perferendis facilis facilis nemo voluptas voluptatum perspiciatis tempore voluptas fugiat numquam sint unde expedita architecto', '2017-06-23 09:44:38', '2017-06-23 09:45:26'),
(155, 5, 'buildaword', 'buildaword', '', 0, 'Suscipit sit velit cumque voluptates pariatur Maiores do reprehenderit quisquam possimus', '2017-06-23 09:44:38', '2017-06-23 09:45:26'),
(156, 5, 'buildaword', 'buildaword', '', 0, 'Qui veniam neque nihil sunt libero porro eaque suscipit quis placeat enim culpa officiis ullamco', '2017-06-23 09:44:38', '2017-06-23 09:45:26'),
(159, 6, 'tictactoe', 'tictactoe', '', 0, 'Koala.jpg', '2017-06-23 10:21:45', '2017-06-23 10:21:45'),
(160, 6, 'tictactoe', 'tictactoe', '', 0, 'Tulips.jpg', '2017-06-23 10:21:45', '2017-06-23 10:21:45');

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `game`
--
ALTER TABLE `game`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=161;
/*!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 */;
