-- https://www.phpmyadmin.net/
--

START TRANSACTION;

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

--
-- 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;

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

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

--
-- 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;
COMMIT;
