SHARE
TWEET

Untitled

a guest Apr 24th, 2019 214 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. -- phpMyAdmin SQL Dump
  2. -- version 4.8.1
  3. -- https://www.phpmyadmin.net/
  4. --
  5. -- Host: 127.0.0.1
  6. -- Generation Time: Apr 24, 2019 at 04:15 PM
  7. -- Server version: 10.1.33-MariaDB
  8. -- PHP Version: 7.2.6
  9.  
  10. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  11. SET AUTOCOMMIT = 0;
  12. START TRANSACTION;
  13. SET time_zone = "+00:00";
  14.  
  15.  
  16. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  17. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  18. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  19. /*!40101 SET NAMES utf8mb4 */;
  20.  
  21. --
  22. -- Database: `shitty_ucp`
  23. --
  24.  
  25. -- --------------------------------------------------------
  26.  
  27. --
  28. -- Table structure for table `ajail_logs`
  29. --
  30.  
  31. CREATE TABLE `ajail_logs` (
  32.   `JailedDBID` INT(11) NOT NULL,
  33.   `JailedBy` VARCHAR(24) NOT NULL,
  34.   `Reason` VARCHAR(128) NOT NULL,
  35.   `Date` VARCHAR(32) NOT NULL
  36. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  37.  
  38. -- --------------------------------------------------------
  39.  
  40. --
  41. -- Table structure for table `bans`
  42. --
  43.  
  44. CREATE TABLE `bans` (
  45.   `id` INT(11) NOT NULL,
  46.   `AccountID` INT(11) DEFAULT NULL,
  47.   `IPAddress` VARCHAR(16) DEFAULT NULL,
  48.   `BanDate` INT(11) NOT NULL,
  49.   `Admin` VARCHAR(24) NOT NULL,
  50.   `Reason` VARCHAR(128) NOT NULL
  51. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  52.  
  53. -- --------------------------------------------------------
  54.  
  55. --
  56. -- Table structure for table `ban_logs`
  57. --
  58.  
  59. CREATE TABLE `ban_logs` (
  60.   `BannedDBID` INT(11) NOT NULL,
  61.   `BannedBy` VARCHAR(24) NOT NULL,
  62.   `Reason` VARCHAR(128) NOT NULL,
  63.   `Date` VARCHAR(32) NOT NULL
  64. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  65.  
  66. -- --------------------------------------------------------
  67.  
  68. --
  69. -- Table structure for table `characters`
  70. --
  71.  
  72. CREATE TABLE `characters` (
  73.   `CharacterID` INT(11) NOT NULL,
  74.   `OwnerID` INT(11) NOT NULL,
  75.   `Name` VARCHAR(24) NOT NULL
  76. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  77.  
  78. -- --------------------------------------------------------
  79.  
  80. --
  81. -- Table structure for table `donator_items`
  82. --
  83.  
  84. CREATE TABLE `donator_items` (
  85.   `BuyerID` INT(11) NOT NULL,
  86.   `Type` INT(11) NOT NULL,
  87.   `ActivationString` VARCHAR(256) NOT NULL,
  88.   `BuyTimestamp` INT(11) NOT NULL
  89. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  90.  
  91. -- --------------------------------------------------------
  92.  
  93. --
  94. -- Table structure for table `hacker_log`
  95. --
  96.  
  97. CREATE TABLE `hacker_log` (
  98.   `AccountID` INT(11) NOT NULL,
  99.   `Username` VARCHAR(24) NOT NULL,
  100.   `Action` VARCHAR(512) NOT NULL,
  101.   `Timestamp` INT(11) NOT NULL
  102. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  103.  
  104. -- --------------------------------------------------------
  105.  
  106. --
  107. -- Table structure for table `ig_announcement`
  108. --
  109.  
  110. CREATE TABLE `ig_announcement` (
  111.   `UserID` INT(11) NOT NULL,
  112.   `Message` VARCHAR(144) NOT NULL,
  113.   `Type` INT(11) NOT NULL
  114. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  115.  
  116. -- --------------------------------------------------------
  117.  
  118. --
  119. -- Table structure for table `kick_logs`
  120. --
  121.  
  122. CREATE TABLE `kick_logs` (
  123.   `KickedDBID` INT(11) NOT NULL,
  124.   `KickedBy` VARCHAR(24) NOT NULL,
  125.   `Reason` VARCHAR(128) NOT NULL,
  126.   `Date` VARCHAR(32) NOT NULL
  127. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  128.  
  129. -- --------------------------------------------------------
  130.  
  131. --
  132. -- Table structure for table `news`
  133. --
  134.  
  135. CREATE TABLE `news` (
  136.   `ID` INT(11) NOT NULL,
  137.   `Title` VARCHAR(128) NOT NULL,
  138.   `Poster` VARCHAR(24) NOT NULL,
  139.   `Timestamp` INT(11) NOT NULL,
  140.   `Message` VARCHAR(1024) NOT NULL,
  141.   `Draft` INT(11) NOT NULL DEFAULT '0'
  142. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  143.  
  144. -- --------------------------------------------------------
  145.  
  146. --
  147. -- Table structure for table `players`
  148. --
  149.  
  150. CREATE TABLE `players` (
  151.   `id` INT(11) NOT NULL,
  152.   `username` VARCHAR(24) NOT NULL,
  153.   `email` VARCHAR(256) NOT NULL,
  154.   `HelperLevel` INT(11) NOT NULL DEFAULT '0',
  155.   `Adminlevel` INT(11) NOT NULL DEFAULT '0',
  156.   `PassedTest` INT(11) NOT NULL DEFAULT '0',
  157.   `activated` INT(11) NOT NULL DEFAULT '0',
  158.   `salt` VARCHAR(256) NOT NULL,
  159.   `samp_terms` INT(11) NOT NULL DEFAULT '0',
  160.   `dcrp_terms` INT(11) NOT NULL DEFAULT '0',
  161.   `SecretWord` VARCHAR(128) NOT NULL
  162. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  163.  
  164. -- --------------------------------------------------------
  165.  
  166. --
  167. -- Table structure for table `roleplay_test`
  168. --
  169.  
  170. CREATE TABLE `roleplay_test` (
  171.   `account_id` INT(11) NOT NULL,
  172.   `question_1` VARCHAR(512) DEFAULT '',
  173.   `question_2` VARCHAR(512) DEFAULT '',
  174.   `question_3` VARCHAR(512) DEFAULT '',
  175.   `question_4` VARCHAR(512) DEFAULT '',
  176.   `app_status` INT(11) NOT NULL DEFAULT '0',
  177.   `timestamp` INT(11) NOT NULL,
  178.   `ip_addr` VARCHAR(32) NOT NULL,
  179.   `user_agent` VARCHAR(512) NOT NULL,
  180.   `denied_id` INT(11) DEFAULT NULL
  181. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  182.  
  183. -- --------------------------------------------------------
  184.  
  185. --
  186. -- Table structure for table `settings`
  187. --
  188.  
  189. CREATE TABLE `settings` (
  190.   `PlayerMOTD` VARCHAR(144) NOT NULL,
  191.   `HelperMOTD` VARCHAR(144) NOT NULL,
  192.   `ServerRevision` VARCHAR(144) NOT NULL
  193. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  194.  
  195. -- --------------------------------------------------------
  196.  
  197. --
  198. -- Table structure for table `ucp_comments`
  199. --
  200.  
  201. CREATE TABLE `ucp_comments` (
  202.   `ID` INT(11) NOT NULL,
  203.   `NewsID` INT(11) NOT NULL,
  204.   `UserID` INT(11) NOT NULL,
  205.   `Timestamp` INT(11) NOT NULL,
  206.   `Message` VARCHAR(512) NOT NULL,
  207.   `Hidden` INT(11) NOT NULL DEFAULT '0'
  208. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  209.  
  210. --
  211. -- Indexes for dumped tables
  212. --
  213.  
  214. --
  215. -- Indexes for table `bans`
  216. --
  217. ALTER TABLE `bans`
  218.   ADD PRIMARY KEY (`id`),
  219.   ADD UNIQUE KEY `AccountID` (`AccountID`);
  220.  
  221. --
  222. -- Indexes for table `characters`
  223. --
  224. ALTER TABLE `characters`
  225.   ADD PRIMARY KEY (`CharacterID`),
  226.   ADD UNIQUE KEY `Name` (`Name`);
  227.  
  228. --
  229. -- Indexes for table `news`
  230. --
  231. ALTER TABLE `news`
  232.   ADD PRIMARY KEY (`ID`);
  233.  
  234. --
  235. -- Indexes for table `players`
  236. --
  237. ALTER TABLE `players`
  238.   ADD PRIMARY KEY (`id`),
  239.   ADD UNIQUE KEY `username` (`username`);
  240.  
  241. --
  242. -- Indexes for table `roleplay_test`
  243. --
  244. ALTER TABLE `roleplay_test`
  245.   ADD PRIMARY KEY (`account_id`);
  246.  
  247. --
  248. -- Indexes for table `ucp_comments`
  249. --
  250. ALTER TABLE `ucp_comments`
  251.   ADD PRIMARY KEY (`ID`);
  252.  
  253. --
  254. -- AUTO_INCREMENT for dumped tables
  255. --
  256.  
  257. --
  258. -- AUTO_INCREMENT for table `bans`
  259. --
  260. ALTER TABLE `bans`
  261.   MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT;
  262.  
  263. --
  264. -- AUTO_INCREMENT for table `characters`
  265. --
  266. ALTER TABLE `characters`
  267.   MODIFY `CharacterID` INT(11) NOT NULL AUTO_INCREMENT;
  268.  
  269. --
  270. -- AUTO_INCREMENT for table `news`
  271. --
  272. ALTER TABLE `news`
  273.   MODIFY `ID` INT(11) NOT NULL AUTO_INCREMENT;
  274.  
  275. --
  276. -- AUTO_INCREMENT for table `players`
  277. --
  278. ALTER TABLE `players`
  279.   MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT;
  280.  
  281. --
  282. -- AUTO_INCREMENT for table `roleplay_test`
  283. --
  284. ALTER TABLE `roleplay_test`
  285.   MODIFY `account_id` INT(11) NOT NULL AUTO_INCREMENT;
  286.  
  287. --
  288. -- AUTO_INCREMENT for table `ucp_comments`
  289. --
  290. ALTER TABLE `ucp_comments`
  291.   MODIFY `ID` INT(11) NOT NULL AUTO_INCREMENT;
  292. COMMIT;
  293.  
  294. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  295. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  296. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top