-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Jul 06, 2025 at 08:20 PM
-- Server version: 10.5.29-MariaDB-0+deb11u1
-- PHP Version: 8.2.28

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

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

--
-- Table structure for table `scores_game_1`
--

CREATE TABLE `scores_game_1` (
  `id` int(11) UNSIGNED NOT NULL,
  `user_id` int(11) UNSIGNED DEFAULT NULL,
  `user_type` enum('guest','authenticated') NOT NULL DEFAULT 'guest',
  `player_name` varchar(100) NOT NULL,
  `score` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `scores_game_1`
--

INSERT INTO `scores_game_1` (`id`, `user_id`, `user_type`, `player_name`, `score`, `created_at`) VALUES
(1, NULL, 'guest', 'NATE2', 2, '2025-06-26 20:29:36'),
(2, NULL, 'guest', 'NATE2', 3, '2025-06-26 20:35:22'),
(3, NULL, 'guest', 'NATE', 1, '2025-06-26 21:53:04'),
(4, NULL, 'guest', 'NATE2', 2, '2025-06-26 21:55:37'),
(5, NULL, 'guest', 'NATE', 4, '2025-06-26 23:19:17'),
(6, 1, 'authenticated', 'NATES', 7, '2025-06-26 23:45:36'),
(7, NULL, 'guest', 'NATEG', 7, '2025-06-27 00:17:46'),
(8, NULL, 'guest', 'NATE3', 2, '2025-06-28 20:23:15'),
(10, 4, 'authenticated', 'YO', 2, '2025-07-04 20:27:12'),
(11, NULL, 'guest', 'GUESTSCORE', 2, '2025-07-04 20:51:08'),
(12, NULL, 'guest', 'NATE', 2, '2025-07-05 20:29:24'),
(13, NULL, 'guest', 'NATEZX', 2, '2025-07-05 20:32:58'),
(14, NULL, 'guest', 'NATEZX2', 4, '2025-07-05 20:38:27'),
(15, NULL, 'guest', 'NATEZX3', 3, '2025-07-05 20:43:13'),
(16, NULL, 'guest', 'NATEZX4', 2, '2025-07-05 20:44:02'),
(17, 2, 'authenticated', 'NATEZX5', 2, '2025-07-05 20:47:33'),
(18, NULL, 'guest', 'GUESTYO', 1, '2025-07-05 20:50:12');

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

--
-- Table structure for table `scores_game_2`
--

CREATE TABLE `scores_game_2` (
  `id` int(11) NOT NULL,
  `player_name` varchar(100) NOT NULL,
  `score` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `scores_game_2`
--

INSERT INTO `scores_game_2` (`id`, `player_name`, `score`, `created_at`) VALUES
(1, 'NATE2', 1, '2025-06-16 05:14:06'),
(2, 'NATE2', 3, '2025-06-16 05:14:27'),
(3, 'NATE2', 3, '2025-06-16 05:41:38'),
(4, 'NATE2', 2, '2025-06-17 16:42:49'),
(5, 'NATE2', 19, '2025-06-19 00:59:56');

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

--
-- Table structure for table `scores_game_4`
--

CREATE TABLE `scores_game_4` (
  `id` int(11) NOT NULL,
  `player_name` varchar(100) NOT NULL,
  `score` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `scores_game_4`
--

INSERT INTO `scores_game_4` (`id`, `player_name`, `score`, `created_at`) VALUES
(1, 'NATE2', 6, '2025-06-16 22:22:00'),
(2, 'NATE2', 17, '2025-06-17 06:55:43');

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

--
-- Table structure for table `scores_game_6`
--

CREATE TABLE `scores_game_6` (
  `id` int(11) NOT NULL,
  `player_name` varchar(100) NOT NULL,
  `score` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `scores_game_6`
--

INSERT INTO `scores_game_6` (`id`, `player_name`, `score`, `created_at`) VALUES
(1, 'NATE2', 7, '2025-06-16 22:51:49'),
(2, 'NATE2', 32, '2025-06-19 01:03:09');

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

--
-- Table structure for table `scores_game_7`
--

CREATE TABLE `scores_game_7` (
  `id` int(11) NOT NULL,
  `player_name` varchar(100) NOT NULL,
  `score` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `scores_game_7`
--

INSERT INTO `scores_game_7` (`id`, `player_name`, `score`, `created_at`) VALUES
(4, 'NATE2', 5, '2025-06-16 22:56:33');

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

--
-- Table structure for table `scores_game_8`
--

CREATE TABLE `scores_game_8` (
  `id` int(11) NOT NULL,
  `player_name` varchar(100) NOT NULL,
  `score` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `scores_game_8`
--

INSERT INTO `scores_game_8` (`id`, `player_name`, `score`, `created_at`) VALUES
(4, 'NATE2', 2, '2025-06-16 22:58:33'),
(5, 'NATE2', 9, '2025-06-17 06:59:49'),
(6, 'NATE2', 8, '2025-06-19 01:04:23');

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

--
-- Table structure for table `times_game_3`
--

CREATE TABLE `times_game_3` (
  `id` int(11) NOT NULL,
  `player_name` varchar(100) NOT NULL,
  `time_raw` decimal(6,3) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `times_game_3`
--

INSERT INTO `times_game_3` (`id`, `player_name`, `time_raw`, `created_at`) VALUES
(1, 'NATE2', 3.958, '2025-06-16 21:13:12'),
(2, 'NATE2', 3.383, '2025-06-16 21:19:27'),
(3, 'NATE2', 14.091, '2025-06-16 21:34:04'),
(4, 'NATE2', 3.558, '2025-06-16 21:35:34'),
(5, 'NATE2', 4.585, '2025-06-16 21:38:10'),
(6, 'NATE2', 7.635, '2025-06-16 21:43:51'),
(7, 'NATE2', 4.088, '2025-06-16 21:47:54'),
(8, 'NATE2', 9.524, '2025-06-16 21:48:10'),
(9, 'NATE2', 16.528, '2025-06-17 17:05:18'),
(10, 'NATE2', 56.723, '2025-06-19 01:01:30');

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

--
-- Table structure for table `times_game_5`
--

CREATE TABLE `times_game_5` (
  `id` int(11) NOT NULL,
  `player_name` varchar(100) NOT NULL,
  `time_raw` decimal(6,3) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `times_game_5`
--

INSERT INTO `times_game_5` (`id`, `player_name`, `time_raw`, `created_at`) VALUES
(9, 'NATE2', 5.000, '2025-06-16 22:37:29'),
(10, 'NATE2', 2.000, '2025-06-17 17:07:50'),
(11, 'NATE2', 4.000, '2025-06-17 17:21:07'),
(12, 'NATE2', 4.000, '2025-06-17 17:26:05'),
(13, 'NATE2', 8.130, '2025-06-17 17:31:46'),
(14, 'NATE2', 3.790, '2025-06-19 01:02:28');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `scores_game_1`
--
ALTER TABLE `scores_game_1`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`);

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `scores_game_1`
--
ALTER TABLE `scores_game_1`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `scores_game_1`
--
ALTER TABLE `scores_game_1`
  ADD CONSTRAINT `fk_user_id` FOREIGN KEY (`user_id`) REFERENCES `NativeMobileLoginAndRegistration`.`users` (`user_id`);
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 */;
