-- phpMyAdmin SQL Dump
-- version 5.1.3
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jun 05, 2024 at 05:08 PM
-- Server version: 10.4.24-MariaDB
-- PHP Version: 8.1.4

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

--
-- Database: `whitelist_registry`
--

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

--
-- Table structure for table `tokens`
--

CREATE TABLE `tokens` (
  `id` int(11) NOT NULL,
  `token` varchar(255) NOT NULL,
  `creation_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `tokens`
--

UPDATE `tokens` SET `id` = 1,`token` = 'Ship_System03adc77a-bb9f-4a14-9ecf-0531c23758e3',`creation_date` = '2024-06-05 11:12:47' WHERE `tokens`.`id` = 1;
UPDATE `tokens` SET `id` = 2,`token` = 'Ship_System5dd04321-116f-4dcd-ab83-81ebb3b7441f',`creation_date` = '2024-06-05 11:12:47' WHERE `tokens`.`id` = 2;
UPDATE `tokens` SET `id` = 3,`token` = 'Ship_System4ece6aa8-b384-4a02-aa98-9aa5920832cd',`creation_date` = '2024-06-05 11:12:47' WHERE `tokens`.`id` = 3;

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `player_id` varchar(255) NOT NULL,
  `player_name` varchar(255) NOT NULL,
  `discord_id` varchar(255) NOT NULL,
  `account_status` varchar(255) NOT NULL,
  `blacklisted` tinyint(1) NOT NULL,
  `last_updated_date` datetime NOT NULL,
  `creation_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `users`
--

UPDATE `users` SET `id` = 1,`player_id` = '25583235',`player_name` = 'Abelfrejya',`discord_id` = '437670964038467606',`account_status` = 'Functional',`blacklisted` = 0,`last_updated_date` = '2024-06-05 11:33:26',`creation_date` = '2024-06-05 11:33:26' WHERE `users`.`id` = 1;

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

--
-- Table structure for table `versions`
--

CREATE TABLE `versions` (
  `id` int(11) NOT NULL,
  `version` varchar(255) NOT NULL,
  `version_type` varchar(255) NOT NULL,
  `version_status` varchar(255) NOT NULL,
  `last_updated_date` datetime NOT NULL,
  `creation_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `versions`
--

UPDATE `versions` SET `id` = 1,`version` = '2.0.2',`version_type` = 'Ship_System',`version_status` = 'Functional',`last_updated_date` = '2024-06-05 11:36:35',`creation_date` = '2024-06-05 11:36:35' WHERE `versions`.`id` = 1;
UPDATE `versions` SET `id` = 2,`version` = '2.0.1',`version_type` = 'Ship_System',`version_status` = 'Functional',`last_updated_date` = '2024-06-05 16:57:15',`creation_date` = '2024-06-05 16:57:15' WHERE `versions`.`id` = 2;

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

--
-- Table structure for table `whitelists`
--

CREATE TABLE `whitelists` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `whitelist_id` varchar(255) NOT NULL,
  `whitelist_type` varchar(255) NOT NULL,
  `whitelist_status` varchar(255) NOT NULL,
  `whitelist_token` varchar(255) NOT NULL,
  `blacklisted` tinyint(1) NOT NULL,
  `last_updated_date` datetime NOT NULL,
  `creation_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `whitelists`
--

UPDATE `whitelists` SET `id` = 1,`user_id` = 1,`whitelist_id` = '25583235',`whitelist_type` = 'User',`whitelist_status` = 'Functional',`whitelist_token` = 'Ship_Systemd26d4a73-4113-466a-9cf9-e35c55f09244',`blacklisted` = 0,`last_updated_date` = '2024-06-05 11:34:18',`creation_date` = '2024-06-05 11:34:18' WHERE `whitelists`.`id` = 1;
UPDATE `whitelists` SET `id` = 2,`user_id` = 1,`whitelist_id` = '5518809',`whitelist_type` = 'Group',`whitelist_status` = 'Functional',`whitelist_token` = 'Ship_Systema4028db0-55dc-4d53-988c-360ef4b74a85',`blacklisted` = 0,`last_updated_date` = '2024-06-05 17:06:42',`creation_date` = '2024-06-05 17:06:42' WHERE `whitelists`.`id` = 2;

--
-- Indexes for dumped tables
--

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `whitelists`
--
ALTER TABLE `whitelists`
  ADD CONSTRAINT `whitelists_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
COMMIT;