demo_game_level_system.sql

-- phpMyAdmin SQL Dump
-- version 5.0.2
-- https://www.phpmyadmin.net/
--
-- Wersja serwera: 10.4.11-MariaDB
-- Wersja PHP: 7.4.5

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

--
-- Baza danych: `demo_game_level_system`
--
CREATE DATABASE IF NOT EXISTS `demo_game_level_system` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_polish_ci;
USE `demo_game_level_system`;

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

--
-- Struktura tabeli dla tabeli `users`
--

DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` int(10) UNSIGNED NOT NULL,
  `level` int(10) UNSIGNED NOT NULL,
  `xp_all` int(10) UNSIGNED NOT NULL,
  `xp_current` int(10) UNSIGNED NOT NULL,
  `xp_needed` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_polish_ci;

--
-- Dane początkowe dla tabeli `users`
--

INSERT INTO `users` (`id`, `level`, `xp_all`, `xp_current`, `xp_needed`) VALUES(1, 0, 0, 0, 100);

--
-- Indeksy dla tabeli `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT dla tabeli `users`
--
ALTER TABLE `users`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
COMMIT;