Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- 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 */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement