-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Jan 23, 2025 at 07:18 PM
-- Server version: 8.0.40-cll-lve
-- PHP Version: 8.3.15

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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: `merakiit_garnier`
--

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

--
-- Table structure for table `players`
--

CREATE TABLE `players` (
  `id` bigint UNSIGNED NOT NULL,
  `first_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `last_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `mobile_number` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `email` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `players`
--

INSERT INTO `players` (`id`, `first_name`, `last_name`, `mobile_number`, `email`, `created_at`, `updated_at`) VALUES
(1, 'Mickey', 'Mouse', '1234567890', 'mickey.mouse@disney.com', NULL, NULL),
(2, 'Bugs', 'Bunny', '9876543210', 'bugs.bunny@looneytunes.com', NULL, NULL),
(3, 'SpongeBob', 'SquarePants', '5551234567', 'spongebob@bikinibottom.com', NULL, NULL),
(4, 'Homer', 'Simpson', '5557891234', 'homer.simpson@springfield.com', NULL, NULL),
(5, 'Bart', 'Simpson', '5551112222', 'bart.simpson@springfield.com', NULL, NULL),
(6, 'Scooby', 'Doo', '8005557890', 'scoobydoo@mysteryinc.com', NULL, NULL),
(7, 'Tom', NULL, '5555551234', 'tom@catandmouse.com', NULL, NULL),
(8, 'Jerry', NULL, '5555555678', 'jerry@catandmouse.com', NULL, NULL),
(9, 'Patrick', 'Star', '5559876543', 'patrick@bikinibottom.com', NULL, NULL),
(10, 'Donald', 'Duck', '5552223333', 'donald.duck@disney.com', NULL, NULL),
(11, 'Goofy', NULL, '5553334444', 'goofy@disney.com', NULL, NULL),
(12, 'Fred', 'Flintstone', '5554445555', 'fred.flintstone@bedrock.com', NULL, NULL),
(13, 'Shaggy', 'Rogers', '5556667777', 'shaggy@mysteryinc.com', NULL, NULL),
(14, 'Daffy', 'Duck', '5558889999', 'daffy.duck@looneytunes.com', NULL, NULL),
(15, 'Tweety', 'Bird', '5559990000', 'tweety@looneytunes.com', NULL, NULL),
(16, 'Popeye', NULL, '5551230987', 'popeye@spinachmail.com', NULL, NULL),
(17, 'Arthur', 'Read', '5554567890', 'arthur.read@elwoodcity.com', NULL, NULL),
(18, 'Stewie', 'Griffin', '5559874321', 'stewie.griffin@familyguy.com', NULL, NULL),
(19, 'Peter', 'Griffin', '5556543210', 'peter.griffin@familyguy.com', NULL, NULL),
(20, 'Bender', NULL, '5557654321', 'bender@futurama.com', NULL, NULL),
(21, 'Finn', 'The Human', '5551119876', 'finn@landofooo.com', NULL, NULL),
(22, 'Jake', 'The Dog', '5552228765', 'jake@landofooo.com', NULL, NULL),
(23, 'Kim', 'Possible', '5553337654', 'kim.possible@kpsaves.com', NULL, NULL);

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

--
-- Table structure for table `players_scores`
--

CREATE TABLE `players_scores` (
  `id` bigint UNSIGNED NOT NULL,
  `player_id` int NOT NULL,
  `score` int NOT NULL,
  `game_time` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `players_scores`
--

INSERT INTO `players_scores` (`id`, `player_id`, `score`, `game_time`, `created_at`, `updated_at`) VALUES
(1, 1, 45, '00:00:15', NULL, NULL),
(2, 2, 29, '00:00:20', NULL, NULL),
(3, 3, 41, '00:00:16', NULL, NULL),
(4, 4, 32, '00:00:10', NULL, NULL),
(5, 5, 33, '00:00:39', NULL, NULL),
(6, 6, 44, '00:00:14', NULL, NULL),
(7, 7, 31, '00:00:23', NULL, NULL),
(8, 8, 9, '00:00:29', NULL, NULL),
(9, 9, 34, '00:00:30', NULL, NULL),
(10, 10, 10, '00:00:22', NULL, NULL),
(11, 11, 27, '00:00:27', NULL, NULL),
(12, 12, 46, '00:00:34', NULL, NULL),
(13, 13, 8, '00:00:21', NULL, NULL),
(14, 14, 14, '00:00:18', NULL, NULL),
(15, 15, 3, '00:00:37', NULL, NULL),
(16, 16, 36, '00:00:13', NULL, NULL),
(17, 17, 6, '00:00:24', NULL, NULL),
(18, 18, 23, '00:00:19', NULL, NULL),
(19, 19, 18, '00:00:17', NULL, NULL),
(20, 20, 7, '00:00:25', NULL, NULL),
(21, 21, 2, '00:00:35', NULL, NULL),
(22, 22, 15, '00:00:36', NULL, NULL),
(23, 23, 40, '00:00:31', NULL, NULL);

--
-- Indexes for dumped tables
--

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `players`
--
ALTER TABLE `players`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33;

--
-- AUTO_INCREMENT for table `players_scores`
--
ALTER TABLE `players_scores`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;
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 */;
