-- phpMyAdmin SQL Dump
-- version 4.8.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Apr 24, 2019 at 04:15 PM
-- Server version: 10.1.33-MariaDB
-- PHP Version: 7.2.6

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

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

--
-- Table structure for table `ajail_logs`
--

CREATE TABLE `ajail_logs` (
  `JailedDBID` INT(11) NOT NULL,
  `JailedBy` VARCHAR(24) NOT NULL,
  `Reason` VARCHAR(128) NOT NULL,
  `Date` VARCHAR(32) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `bans`
--

CREATE TABLE `bans` (
  `id` INT(11) NOT NULL,
  `AccountID` INT(11) DEFAULT NULL,
  `IPAddress` VARCHAR(16) DEFAULT NULL,
  `BanDate` INT(11) NOT NULL,
  `Admin` VARCHAR(24) NOT NULL,
  `Reason` VARCHAR(128) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `ban_logs`
--

CREATE TABLE `ban_logs` (
  `BannedDBID` INT(11) NOT NULL,
  `BannedBy` VARCHAR(24) NOT NULL,
  `Reason` VARCHAR(128) NOT NULL,
  `Date` VARCHAR(32) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `characters`
--

CREATE TABLE `characters` (
  `CharacterID` INT(11) NOT NULL,
  `OwnerID` INT(11) NOT NULL,
  `Name` VARCHAR(24) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `donator_items`
--

CREATE TABLE `donator_items` (
  `BuyerID` INT(11) NOT NULL,
  `Type` INT(11) NOT NULL,
  `ActivationString` VARCHAR(256) NOT NULL,
  `BuyTimestamp` INT(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `hacker_log`
--

CREATE TABLE `hacker_log` (
  `AccountID` INT(11) NOT NULL,
  `Username` VARCHAR(24) NOT NULL,
  `Action` VARCHAR(512) NOT NULL,
  `Timestamp` INT(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `ig_announcement`
--

CREATE TABLE `ig_announcement` (
  `UserID` INT(11) NOT NULL,
  `Message` VARCHAR(144) NOT NULL,
  `Type` INT(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `kick_logs`
--

CREATE TABLE `kick_logs` (
  `KickedDBID` INT(11) NOT NULL,
  `KickedBy` VARCHAR(24) NOT NULL,
  `Reason` VARCHAR(128) NOT NULL,
  `Date` VARCHAR(32) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `news`
--

CREATE TABLE `news` (
  `ID` INT(11) NOT NULL,
  `Title` VARCHAR(128) NOT NULL,
  `Poster` VARCHAR(24) NOT NULL,
  `Timestamp` INT(11) NOT NULL,
  `Message` VARCHAR(1024) NOT NULL,
  `Draft` INT(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

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

CREATE TABLE `players` (
  `id` INT(11) NOT NULL,
  `username` VARCHAR(24) NOT NULL,
  `email` VARCHAR(256) NOT NULL,
  `HelperLevel` INT(11) NOT NULL DEFAULT '0',
  `Adminlevel` INT(11) NOT NULL DEFAULT '0',
  `PassedTest` INT(11) NOT NULL DEFAULT '0',
  `activated` INT(11) NOT NULL DEFAULT '0',
  `salt` VARCHAR(256) NOT NULL,
  `samp_terms` INT(11) NOT NULL DEFAULT '0',
  `dcrp_terms` INT(11) NOT NULL DEFAULT '0',
  `SecretWord` VARCHAR(128) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `roleplay_test`
--

CREATE TABLE `roleplay_test` (
  `account_id` INT(11) NOT NULL,
  `question_1` VARCHAR(512) DEFAULT '',
  `question_2` VARCHAR(512) DEFAULT '',
  `question_3` VARCHAR(512) DEFAULT '',
  `question_4` VARCHAR(512) DEFAULT '',
  `app_status` INT(11) NOT NULL DEFAULT '0',
  `timestamp` INT(11) NOT NULL,
  `ip_addr` VARCHAR(32) NOT NULL,
  `user_agent` VARCHAR(512) NOT NULL,
  `denied_id` INT(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `PlayerMOTD` VARCHAR(144) NOT NULL,
  `HelperMOTD` VARCHAR(144) NOT NULL,
  `ServerRevision` VARCHAR(144) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `ucp_comments`
--

CREATE TABLE `ucp_comments` (
  `ID` INT(11) NOT NULL,
  `NewsID` INT(11) NOT NULL,
  `UserID` INT(11) NOT NULL,
  `Timestamp` INT(11) NOT NULL,
  `Message` VARCHAR(512) NOT NULL,
  `Hidden` INT(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `bans`
--
ALTER TABLE `bans`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `AccountID` (`AccountID`);

--
-- Indexes for table `characters`
--
ALTER TABLE `characters`
  ADD PRIMARY KEY (`CharacterID`),
  ADD UNIQUE KEY `Name` (`Name`);

--
-- Indexes for table `news`
--
ALTER TABLE `news`
  ADD PRIMARY KEY (`ID`);

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

--
-- Indexes for table `roleplay_test`
--
ALTER TABLE `roleplay_test`
  ADD PRIMARY KEY (`account_id`);

--
-- Indexes for table `ucp_comments`
--
ALTER TABLE `ucp_comments`
  ADD PRIMARY KEY (`ID`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `bans`
--
ALTER TABLE `bans`
  MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `characters`
--
ALTER TABLE `characters`
  MODIFY `CharacterID` INT(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `news`
--
ALTER TABLE `news`
  MODIFY `ID` INT(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `players`
--
ALTER TABLE `players`
  MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `roleplay_test`
--
ALTER TABLE `roleplay_test`
  MODIFY `account_id` INT(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ucp_comments`
--
ALTER TABLE `ucp_comments`
  MODIFY `ID` INT(11) NOT NULL AUTO_INCREMENT;
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 */;