-- phpMyAdmin SQL Dump
-- version 4.5.4.1deb2ubuntu2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Tempo de geração: 11/10/2017 às 05:27
-- Versão do servidor: 5.7.19-0ubuntu0.16.04.1
-- Versão do PHP: 7.0.22-0ubuntu0.16.04.1

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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 */;

--
-- Banco de dados: `blocksi`
--

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

--
-- Estrutura para tabela `ban_offenses`
--

CREATE TABLE `ban_offenses` (
  `id` int(11) NOT NULL,
  `username` varchar(24) NOT NULL,
  `banBy` varchar(24) NOT NULL,
  `banWhen` varchar(64) NOT NULL,
  `banRemoved` varchar(64) NOT NULL,
  `banNote` varchar(256) NOT NULL,
  `banReason` varchar(256) NOT NULL COMMENT 'shown to staff only',
  `banContent` text NOT NULL COMMENT 'html code',
  `banHowLong` varchar(64) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Fazendo dump de dados para tabela `ban_offenses`
--

INSERT INTO `ban_offenses` (`id`, `username`, `banBy`, `banWhen`, `banRemoved`, `banNote`, `banReason`, `banContent`, `banHowLong`) VALUES
(1, 'KJF', 'KJF', '5/27/2017 11:53PM EST', '5/28/2017 11:53PM EST', 'Test', 'Test', '<tr>\r\n				<td>Profanity</td>\r\n				<td>"Test"</td>\r\n				<td>Forums</td>\r\n			</tr>', '1 day'),
(2, 'Hyperant', 'KJF', 'whenever', 'whenever', 'dont go eating pc\'s', 'he was eatin\' pc\'s', '<tr>\r\n				<td>Profanity</td>\r\n				<td>"Test"</td>\r\n				<td>Forums</td>\r\n			</tr>', 'however');

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

--
-- Estrutura para tabela `blocksi`
--

CREATE TABLE `blocksi` (
  `id` int(11) NOT NULL COMMENT 'AUTO_INCREMENT',
  `username` varchar(16) COLLATE utf8_unicode_ci NOT NULL,
  `password` varchar(4096) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `rank` varchar(16) COLLATE utf8_unicode_ci NOT NULL,
  `realname` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `joindate` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `accCode` varchar(64) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Fazendo dump de dados para tabela `blocksi`
--

INSERT INTO `blocksi` (`id`, `username`, `password`, `email`, `rank`, `realname`, `joindate`, `accCode`) VALUES
(1, 'KJF', 'aonmlaonmlkjihgfedcbaa0Iy9Hxaonmlkjihgfedcaonmlkjihgfedcbaa0Iy9Hx8Gw7Fv6Eu5Dt4Csaonmlkjihgfedaonmlaonmlkjih1zp2Aq', 'keon2004@live.com', 'Owner/Founder', 'Keon Farley', '03/15/2017', ''),
(2, 'uwu', 'aonmlkjiaonmlkjihgfedcbaa0Iy9Hx8Gwaonmlkjihgfedcbaa0Iy9Hx8Gw7Fv6Eu5Dtaonmlkjihgfedcaonmlkjihgfedcbaa0Iy9Hx8Gw7Fv6Eu5Dt4Cs3Br2Aq1zpaonmlkjiaonmlkjihgfedcbaa0Iy9Hxaonmlkjihgfedaonmlkjihgfedcaonmlkjihaonmlkjihgfedaonmlkjihgfedcbaa0Iy9Hx8Gw7Fv6Euaonmlkjihgfedcbaa0Iy9Hx8Gw7Fv6Euaonmlkjihgfedcbaa0Iy9Hxaonmlkjihgfedcbaa0Iy9Hx8Gw7Fv6Eu5Dt4Cs3Braonmlkjihgfedcbaa0Iy9Hxaonmlkjihgfedcbaa0Iy9Hx8Gw7Fv6Eu5Dt4Cs3Br2Aq1zpaonmlkjihgfedcbaaonmlkjihgfedaonmlkjihgfedcaonaonmlkji', 'galaxyynutella@gmail.com', 'Verified', 'Cameron Lewis', '03/15/2017', ''),
(3, 'Child', '=aaonmlkjiaonmlkjihgfedcb9Hx1zpHQhaonmlkjaonmlkjihgPYjaonmlkjihgfedcbaa0Iy9Hx8Gw7Fvaonmlkjihgfedaonmlkjihgf0Iy', '?', 'Cilindro Mod', '?', '03/15/2017', ''),
(4, 'test', 'aonmlkjiaonmlkjihgfedcbaa0Iy9Hx8Gw7Fv6Eu5Dtaonmlkjihaonmlkjiaonmlkjiaonmlkjihgfedcbaa0Iy9Hx8Gw7Fv6Eu5Dtaonmlkjihaonmlkji', '?', 'Test account', '?', '03/15/2017', ''),
(5, 'Penguin', '3BHQhaonmlkjihgfedcbaa0Iy9Hx8Gw7Fv6Eu5Dtaonmlkjihgfedcbaa0Iy9Hx8Gw7Fv6Eu5Dt4Cs3Braonmlkjaonmlkjihgaonmlkjihgfedcbaa0Iy9Hx8Gw7Fv6Eu5Dt5D5Dtaonmlkjihgfedcaonmlkjihgfedcbaa0Iy9Hx8Gw7Fv6Eu5Dt4Cs3Braonmlkjihgaonaonmlkjihgfeaonmlkjiaonmlkjihgfedcbaa0Iy9Hxaonmlkjihgfedaonmlkjihgfedc', '?', 'Cilindro Mod', '?', '03/15/2017', ''),
(6, 'Hyperant', 'aonmlkjihgaonmlkjihgfedcbaa0Iy9Hx8Gw7Fv6Eu5Dt4Cs3Br2Aq1zpaonmlkjihaonmlkjihgfedcbaa0Iy9Hx8Gwaonmlkjihgfedcbaa0Iy9Hx8Gw7Fv6Eu5Dtaonmlkjihgfedcbaa0Iy9Hx8Gw7Fv6Eu5Dtaonmlkjihgfedcbaa0Iy9Hx8Gw7Fv6Eu5Dt4Cs1zp2Aq3Br', 'rasheedfarley2000@hotmail.com', 'Roblox Dev', 'Rasheed Farley', '03/15/2017', ''),
(7, 'luckyroses', '2A2Aqaonmlkjihgaonmlkjaonmlkjihgfedcaonmlkjihgfed5Dt8Gw0Iy', '?', 'Tester/Dev', '?', '03/15/2017', ''),
(8, '!TZHAPPYGARY', '1z1z4C4CsFOdIRcCLiHQhCLiFOdGPeJSb5D5DtIRcFOdENl1z1z', 'ᕕ( ᐛ )ᕗ', 'ᕕ( ᐛ )ᕗ', 'ᕕ( ᐛ )ᕗ', '03/15/2017', ''),
(9, 'test2', '1zp2Aq3Br4Cs5Dt6Eu7Fv8Gw', 'test', 'Owner/Founder', 'Test', '03/15/2017', ''),
(10, 'QueenBee', 'aonmlkjihgfedcbaa0Iy9Hx8Gw7Fv6Euaonmlkjihgaonmlkjihgfedcbaa0Iy9Hx8Gw7Fv6Eu5Dtaonmlkjihgfedcbaa0Iy9Hx8Gw7Fv6Eu5Dtaonmlkjihgfedcbaonmlkjihgfedcbaa0Iy9Hx8Gw7Fv6Eu5Dt4Cs3Br2Aq1zpaonmlkjihgfedcaonmlkjihgfedcbaa0Iy1zp2Aq4Cs', '?', 'Tester', '?', '03/15/2017', ''),
(11, 'Riley', 'aonmlkjihaonmlkjiaonmlkjihgfedcbaa0Iy9Hx8Gw7Fv6Eu5Dt4Cs3Br2Aq1zpaonmlkjihgaonmlkjihgfedcbaa0Iy9Hx8Gw7Fv6Eu5Dt4Cs3Braonmlkjihgfedaonmlkjihgfedc3Br2Aq1zp', '?', 'Tester', '?', '03/15/2017', ''),
(69, 'Trake', 'aonmlkjihaonmlkjihgfedaonmlkjihgfedcbaonmlkjihgfedcbaa0Iy9Hx8Gw7Fv6Eu5Dtaonmlkjihgfedaonmlkjihgfedcaonmlkjihgfedcbaa0Iy9Hx8Gw7Fv6Eu5Dtaonaonmlkjihgfedaonmlkjaonmlkjihgfedcbaaaonmlkjihgfedcaonmlkjihgfedaonml2Aq2Aq5Dt', 'kevblox@gmail.com', 'Tester', '', '03/15/2017', ''),
(2000, 'umbeusnoob24', 'aonmlkjihgfedcbaa0Iy9Hxaonmlkjihgfedcbaonmlkjihaonmlkjaonmlkjihgfedcbaa0Iy9Hxaonmlkjihgfedcbaa0Iy9Hx8Gw7Fv6Eu5Dt4Cs3Braonmlkjihgfedcbaa0Iy9Hxaonmlkjihgfedcbaa0Iy9Hx8Gw7Fv6Eu5Dt4Csaonmlkjihgfedcbaa0Iy9Hx8Gw7Fv6Eu5Dt4Cs3Br2Aq1zpaonmlkjihgfedcba2Aq2Aq', 'ryan.a.adams71@gmail.com', 'Tester', 'Ryan Adams', '03/15/2017', '');

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

--
-- Estrutura para tabela `categories`
--

CREATE TABLE `categories` (
  `id` smallint(6) NOT NULL,
  `name` varchar(256) NOT NULL,
  `description` text NOT NULL,
  `position` smallint(6) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Fazendo dump de dados para tabela `categories`
--

INSERT INTO `categories` (`id`, `name`, `description`, `position`) VALUES
(1, 'General Discussion', 'General discussions test', 1),
(2, 'Off-Topic', 'All unrelated items go in here.', 2);

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

--
-- Estrutura para tabela `devusers`
--

CREATE TABLE `devusers` (
  `id` int(11) NOT NULL,
  `password` varchar(128) NOT NULL,
  `letter` varchar(1) NOT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Fazendo dump de dados para tabela `devusers`
--

INSERT INTO `devusers` (`id`, `password`, `letter`, `user_id`) VALUES
(1, '$2y$10$xstT.FDHxIAIEFWTUMRgU.P7Y4EAgOat/n.9iZlWtFsOaw1gemL3u', 'B', 1),
(3, '$2y$10$kUnEFPGDG1yypBy2fRE2qOiyaYQDaki/0jxRuCr3DQSr0e.N1L9UW', 'A', 2),
(4, '$2y$10$insuB2UadUWb2.BlSf0DauEGZwbZufFZuc5Vsv0eg/zOsiHj9V1VW', 'A', 4),
(5, '$2y$10$HzEI/G7t3Mzl2ENkYstaYOBOqQRuBsEaK/zrLt69LJJhsmPzztHg6', 'C', 3);

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

--
-- Estrutura para tabela `friendrequests`
--

CREATE TABLE `friendrequests` (
  `id` int(11) NOT NULL,
  `idOfRequester` int(11) NOT NULL COMMENT 'one who sends fr',
  `usernameOfSender` varchar(24) NOT NULL,
  `idOfReceiver` int(11) NOT NULL COMMENT 'one who receives fr',
  `dateSent` varchar(24) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Fazendo dump de dados para tabela `friendrequests`
--

INSERT INTO `friendrequests` (`id`, `idOfRequester`, `usernameOfSender`, `idOfReceiver`, `dateSent`) VALUES
(1, 1, 'KJF', 4, '07/3/2017 14:42:46'),
(2, 3, 'KJF2', 2, '07/17/2017 10:25:04'),
(3, 1, 'KJF', 1, '07/18/2017 22:23:03'),
(4, 6, 'Blank', 6, '09/8/2017 22:02:40');

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

--
-- Estrutura para tabela `friendships`
--

CREATE TABLE `friendships` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL COMMENT 'id of person accepting fr',
  `friend_id` int(11) NOT NULL COMMENT 'id of person whose fr was accepted',
  `friendship_start` varchar(24) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Fazendo dump de dados para tabela `friendships`
--

INSERT INTO `friendships` (`id`, `user_id`, `friend_id`, `friendship_start`) VALUES
(1, 1, 2, '06/16/2017'),
(2, 1, 3, '06/16/2017');

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

--
-- Estrutura para tabela `itemlikes`
--

CREATE TABLE `itemlikes` (
  `id` int(11) NOT NULL,
  `username` varchar(24) NOT NULL,
  `itemID` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Fazendo dump de dados para tabela `itemlikes`
--

INSERT INTO `itemlikes` (`id`, `username`, `itemID`) VALUES
(1, 'KJFtest', 1),
(2, 'Kallocke', 1),
(3, 'Kallocke', 2),
(4, 'KJF', 2),
(5, 'test', 3),
(10, 'KJF2', 1);

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

--
-- Estrutura para tabela `logs`
--

CREATE TABLE `logs` (
  `id` int(11) NOT NULL,
  `time` varchar(24) NOT NULL,
  `user` varchar(24) NOT NULL,
  `action` varchar(32) NOT NULL,
  `user2` varchar(24) DEFAULT NULL,
  `extra` varchar(512) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Fazendo dump de dados para tabela `logs`
--

INSERT INTO `logs` (`id`, `time`, `user`, `action`, `user2`, `extra`) VALUES
(1, '06/29/2017 13:57:00', 'KJF', 'created logs', NULL, NULL),
(2, '06/29/2017 13:58:58', 'KJF', 'em', NULL, 'With reason Because this is a test currently at the moment.<br />and with message Because this is a test currently at the moment. <br />with forced maintenance on'),
(3, '06/29/2017 14:02:36', 'KJF', 'dm', NULL, NULL),
(4, '06/29/2017 14:04:05', 'KJF', 'em', NULL, 'With reason Because this is a test currently at the moment.<br />and with message Because this is a test currently at the moment. <br />with forced maintenance on'),
(5, '06/29/2017 14:04:13', 'KJF', 'dm', NULL, NULL),
(6, '06/29/2017 15:33:44', 'KJF', 'dc', NULL, NULL),
(7, '06/29/2017 15:38:53', 'KJF', 'ec', NULL, NULL),
(8, '06/29/2017 15:40:13', 'KJF', 'dc', NULL, NULL),
(9, '06/29/2017 15:40:44', 'KJF', 'ec', NULL, NULL),
(10, '06/29/2017 15:43:22', 'KJF', 'dc', NULL, NULL),
(11, '06/29/2017 15:46:05', 'KJF', 'ec', NULL, NULL),
(12, '06/29/2017 15:53:14', 'KJF', 'dc', NULL, NULL),
(13, '06/29/2017 15:55:06', 'KJF', 'ec', NULL, NULL),
(14, '06/29/2017 15:55:26', 'KJF', 'dc', NULL, NULL),
(15, '06/29/2017 15:55:48', 'KJF', 'ec', NULL, NULL),
(16, '06/29/2017 15:55:53', 'KJF', 'dc', NULL, NULL),
(17, '06/29/2017 15:57:18', 'KJF', 'em', NULL, 'With reason Because this is a test currently at the moment.<br />and with message Because this is a test currently at the moment. <br />with forced maintenance on'),
(18, '06/29/2017 16:13:52', 'KJF', 'ec', NULL, NULL),
(19, '06/29/2017 16:27:04', 'KJF', 'dc', NULL, NULL),
(20, '06/29/2017 17:00:36', 'KJF', 'ec', NULL, NULL),
(21, '06/29/2017 17:00:43', 'KJF', 'dc', NULL, NULL),
(22, '06/29/2017 17:01:06', 'KJF', 'ec', NULL, NULL),
(23, '06/29/2017 17:01:18', 'KJF', 'dc', NULL, NULL),
(24, '06/29/2017 17:01:23', 'KJF', 'ec', NULL, NULL),
(25, '06/29/2017 17:03:23', 'KJF', 'dc', NULL, NULL),
(26, '06/29/2017 17:03:35', 'KJF', 'ec', NULL, NULL),
(27, '06/29/2017 17:04:29', 'KJF', 'dc', NULL, NULL),
(28, '06/30/2017 06:38:23', 'KJF', 'dm', NULL, NULL),
(29, '06/30/2017 06:39:28', 'KJF', 'em', NULL, 'With reason Because this is a test currently at the moment.<br />and with message  <br />with forced maintenance on'),
(30, '07/1/2017 12:48:12', 'KJF', 'dm', NULL, NULL),
(31, '07/1/2017 12:49:30', 'KJF', 'em', NULL, 'With reason Because this is a test currently at the moment.<br />and with message Because this is a test currently at the moment. <br />with forced maintenance on'),
(32, '07/3/2017 14:43:46', 'KJF', 'dm', NULL, NULL),
(33, '07/16/2017 22:11:48', 'KJF', 'em', NULL, 'With reason Because I would like to enable it for a test for Danielle.<br />and with message Danielle enabled maintenace! :O <br />with forced maintenance on'),
(34, '07/16/2017 22:30:50', 'KJF', 'dm', NULL, NULL),
(35, '07/17/2017 11:12:15', 'Kallocke', 'cda', NULL, NULL),
(36, '07/17/2017 11:49:02', 'Kallocke', 'cda', NULL, NULL),
(37, '07/17/2017 11:50:40', 'Kallocke', 'cda', NULL, NULL),
(38, '07/17/2017 11:53:57', 'Kallocke', 'em', NULL, 'With reason tessssssssssssssssssssssssssssssssssssssssssssssssssst<br />and with message tessssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssst <br />with forced maintenance on'),
(39, '07/17/2017 16:31:33', 'KJF', 'dm', NULL, NULL),
(40, '07/17/2017 18:03:04', 'KJF', 'va', 'KJF', NULL),
(41, '07/18/2017 10:49:07', 'KJF', 'va', 'KJF', NULL),
(42, '07/18/2017 22:12:05', 'KJF', 'va', 'KJF', NULL),
(43, '07/18/2017 22:14:30', 'KJF', 'ec', NULL, NULL),
(44, '07/18/2017 22:14:56', 'KJF', 'dc', NULL, NULL),
(45, '07/20/2017 10:01:45', 'KJF', 'va', 'KJF', NULL),
(46, '07/20/2017 11:08:32', 'KJF', 'va', 'KJF', NULL),
(47, '07/20/2017 11:10:20', 'KJF', 'va', 'KJF', NULL),
(48, '07/20/2017 11:10:39', 'KJF', 'va', 'KJF', NULL),
(49, '09/1/2017 13:26:35', 'KJF', 'va', 'Kallocke', NULL),
(50, '09/1/2017 13:32:44', 'KJF', 'va', 'Kallocke', NULL),
(51, '09/1/2017 13:36:46', 'KJF', 'em', NULL, 'With reason The site isn\'t finished.<br />and with message Hey there! Welcome to maintenance mode! If you are an administrator/moderator, you can login in with your developer account below. DM papa shells for a Blocksi account as it wont be released for a while! <br />with forced maintenance '),
(52, '09/1/2017 14:13:21', 'Kallocke', 'cda', NULL, NULL),
(53, '09/1/2017 21:45:52', 'KJF', 'va', 'drifttwo', NULL),
(54, '09/1/2017 21:56:54', 'KJF', 'va', 'drifttwo', NULL),
(55, '09/1/2017 23:32:32', 'KJF', 'dm', NULL, NULL),
(56, '09/1/2017 23:33:17', 'KJF', 'va', 'drifttwo', NULL),
(57, '09/1/2017 23:33:24', 'KJF', 'cpw', 'drifttwo', NULL),
(58, '09/1/2017 23:35:28', 'KJF', 'cpw', 'drifttwo', NULL),
(59, '09/2/2017 03:52:33', 'drifttwo', 'cda', NULL, NULL),
(60, '09/2/2017 09:10:45', 'KJF', 'va', 'KJF', NULL),
(61, '09/2/2017 09:11:18', 'KJF', 'ec', NULL, NULL),
(62, '09/2/2017 09:57:24', 'KJF', 'dc', NULL, NULL),
(63, '09/2/2017 09:59:20', 'KJF', 'dm', NULL, NULL),
(64, '09/2/2017 09:59:27', 'KJF', 'ec', NULL, NULL),
(65, '09/2/2017 10:02:16', 'KJF2', 'cda', NULL, NULL),
(66, '09/2/2017 10:02:39', 'KJF2', 'dc', NULL, NULL),
(67, '09/2/2017 10:03:12', 'KJF2', 'em', NULL, 'With reason Because this is a test currently at the moment.<br />and with message Hey there! Welcome to maintenance mode! If you are an administrator/moderator, you can login in with your developer account below. DM papa shells for a Blocksi account as it wont be released for a while! <br />with forced maintenance on');

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

--
-- Estrutura para tabela `pm`
--

CREATE TABLE `pm` (
  `id` bigint(20) NOT NULL,
  `id2` int(11) NOT NULL,
  `title` varchar(256) NOT NULL,
  `user1` bigint(20) NOT NULL,
  `user2` bigint(20) NOT NULL,
  `message` text NOT NULL,
  `timestamp` int(10) NOT NULL,
  `user1read` varchar(3) NOT NULL,
  `user2read` varchar(3) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Fazendo dump de dados para tabela `pm`
--

INSERT INTO `pm` (`id`, `id2`, `title`, `user1`, `user2`, `message`, `timestamp`, `user1read`, `user2read`) VALUES
(1, 1, 'Hi', 1, 2, 'Hi', 1495390900, 'yes', 'yes'),
(2, 1, 'oooooooooooooooooooooooooo', 2, 1, 'ummmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmm, is this what i&#039;m thinking??? &lt;3 OOOH SENPAI', 1495390907, 'yes', 'yes'),
(3, 1, 'Hi', 1, 2, 'Hi', 1495391132, 'yes', 'yes');

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

--
-- Estrutura para tabela `shopitems`
--

CREATE TABLE `shopitems` (
  `id` int(11) NOT NULL,
  `name` varchar(32) NOT NULL,
  `description` varchar(512) NOT NULL,
  `category` varchar(32) NOT NULL,
  `limited` tinyint(1) NOT NULL,
  `limitedSales` int(11) NOT NULL,
  `available` tinyint(1) NOT NULL,
  `itemLikes` int(11) NOT NULL,
  `itemSales` int(11) NOT NULL,
  `itemFavourite` int(11) NOT NULL,
  `itemCreated` varchar(14) NOT NULL,
  `itemUpdated` varchar(14) NOT NULL,
  `Creator` varchar(16) NOT NULL,
  `itemPath` varchar(128) NOT NULL,
  `membershipRequired` tinyint(1) NOT NULL,
  `pixels` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Fazendo dump de dados para tabela `shopitems`
--

INSERT INTO `shopitems` (`id`, `name`, `description`, `category`, `limited`, `limitedSales`, `available`, `itemLikes`, `itemSales`, `itemFavourite`, `itemCreated`, `itemUpdated`, `Creator`, `itemPath`, `membershipRequired`, `pixels`) VALUES
(1, 'Rigged', 'You are gonna look cool with those rigged edges.', 'Block Styles', 1, 1000, 1, 0, 0, 0, '5/28/2017', '5/28/2017', 'KJF', 'shopping-bag.png', 0, 5000);

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

--
-- Estrutura para tabela `statuses`
--

CREATE TABLE `statuses` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL COMMENT 'user id who posted status',
  `post_date` varchar(11) NOT NULL,
  `content` varchar(256) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Fazendo dump de dados para tabela `statuses`
--

INSERT INTO `statuses` (`id`, `user_id`, `post_date`, `content`) VALUES
(1, 1, '06/16/2017', 'Hello World! KJF posted this (id one)'),
(3, 3, '06/18/2017', 'Hello World! KJF2 posted this (id three)'),
(4, 1, '09/2/2017', 'Blocksi is cool'),
(5, 1, '09/2/2017', 'Test'),
(6, 1, '09/2/2017', ';'),
(7, 4, '09/3/2017', 'mysql> show databases;'),
(8, 4, '09/3/2017', 'im just testing your site for anying bugs/exploits. dont mind be'),
(9, 6, '09/8/2017', 'i am cool'),
(10, 4, '09/14/2017', 'Wazzup?'),
(11, 4, '09/14/2017', 'Wazzup?');

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

--
-- Estrutura para tabela `tbl_users`
--

CREATE TABLE `tbl_users` (
  `user_id` int(11) NOT NULL,
  `username` varchar(60) NOT NULL,
  `email` varchar(60) NOT NULL,
  `password` varchar(255) NOT NULL,
  `gender` int(1) NOT NULL,
  `rank` varchar(20) NOT NULL DEFAULT 'Member',
  `joindate` varchar(10) NOT NULL,
  `lastseen` varchar(24) NOT NULL,
  `pixels` int(11) NOT NULL,
  `ip` varchar(24) NOT NULL,
  `notes` varchar(256) DEFAULT NULL,
  `status` varchar(3) NOT NULL,
  `accCode` varchar(64) DEFAULT NULL,
  `banStatus` varchar(1) DEFAULT NULL,
  `banID` int(11) DEFAULT NULL,
  `alt` varchar(24) DEFAULT NULL,
  `daily_pixels` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Fazendo dump de dados para tabela `tbl_users`
--

INSERT INTO `tbl_users` (`user_id`, `username`, `email`, `password`, `gender`, `rank`, `joindate`, `lastseen`, `pixels`, `ip`, `notes`, `status`, `accCode`, `banStatus`, `banID`, `alt`, `daily_pixels`) VALUES
(1, 'KJF', '', '$2y$10$BjGycZ.XcgvH09JUhyLKg1ON8WJ4PpBcrWRlrNyqjwoEc3D0TBrTbC', 0, 'Owner', 'beginning', '09/20/2017 20:58:15', 1000, '', NULL, '0', NULL, NULL, 1, 'KJF', '2017-07-02 15:15:16'),
(3, 'KJF2', '', '$2y$10$BjGycZ.cgvH09JUhyLKg1ON8WJ4PpBcrWRlrNyqjwoEc3D0TBrTbC', 1, 'Moderator', '5/5/2017', '09/2/2017 09:59:45', 150000, '', NULL, 'yes', NULL, NULL, NULL, 'KJF', '2017-07-02 15:15:16'),
(4, 'drifttwo', '', '$2y$10$BHVItipcERrnmn8GCr.twuqudqZmGzv6gqRyAAbD.G/1JAKAoyFRa', 0, 'Administrator', '4/29/2017', '09/14/2017 18:03:03', 1000, '::1', NULL, 'new', NULL, NULL, NULL, NULL, '2017-07-02 15:15:16'),
(5, 'Hyperant', 'kjf\'s', '$2y$10$VwZeoWBzS7mWpWunMSoXauB692EqwrGS.iAqEcSTlbpimOw82Gbwu', 0, 'Early', '4/29/2017', '06/6/2017 19:28:05', 1000, '192.168.1.8', NULL, 'new', NULL, NULL, 2, NULL, '2017-07-02 15:15:16'),
(6, 'Blank', '', '$2y$10$k1J50oZwTHJlPivYB6v7e.9SsGG8VJW/i/4tKalTU0BBtGFC4ngAO', 3, 'Moderator', '09/08/2017', '09/8/2017 21:58:58', 1500, '68.116.192.161', NULL, '?', NULL, NULL, NULL, NULL, '2017-09-09 00:58:32');

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

--
-- Estrutura para tabela `topics`
--

CREATE TABLE `topics` (
  `parent` smallint(6) NOT NULL,
  `id` int(11) NOT NULL,
  `id2` int(11) NOT NULL,
  `title` varchar(256) NOT NULL,
  `message` longtext NOT NULL,
  `authorid` int(11) NOT NULL,
  `timestamp` int(11) NOT NULL,
  `timestamp2` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Fazendo dump de dados para tabela `topics`
--

INSERT INTO `topics` (`parent`, `id`, `id2`, `title`, `message`, `authorid`, `timestamp`, `timestamp2`) VALUES
(1, 1, 1, 'test', '<strong>test</strong>', 1, 1495389242, 1495389242),
(1, 2, 1, 'KJF senpai! :)))', 'OOOOOhhhh, KJF is my senpai. KJF-chan! :)', 2, 1495389811, 1495408513),
(1, 2, 2, '', '<strong>:D</strong>', 1, 1495389911, 1495389911),
(1, 2, 3, '', '<strong>:D</strong>', 1, 1495389937, 1495389937),
(1, 2, 4, '', '<strong>&lt;3</strong> <img src="https://media.tenor.co/images/aeed0f97ccd1fb9a571fe48dda73408c/tenor.gif" alt="Image" />', 2, 1495389958, 1495389958),
(1, 2, 5, '', 'Edited by KJF<br />\r\n<div style="text-align:left;">hi</div>', 2, 1495391420, 1495391420),
(1, 2, 6, '', '<strong><em><span style="text-decoration:underline;">test</span></em></strong><br />\r\n<strong><em><span style="text-decoration:underline;"><div style="text-align:center;">test</div></span></em></strong>', 1, 1495408434, 1495408434),
(1, 2, 7, '', 't<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\nt', 1, 1495408444, 1495408444),
(1, 2, 8, '', '&#039; or 1=1;', 1, 1495408513, 1495408513),
(1, 3, 1, 'Hey!', 'This is a work in progress :)', 1, 1495908064, 1495908064);

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

--
-- Estrutura para tabela `users`
--

CREATE TABLE `users` (
  `id` bigint(20) NOT NULL,
  `username` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `avatar` text NOT NULL,
  `signup_date` int(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Fazendo dump de dados para tabela `users`
--

INSERT INTO `users` (`id`, `username`, `password`, `email`, `avatar`, `signup_date`) VALUES
(1, 'KJF', '3be47f95be8a7f16c8b6cb4311b59a13717a8f2f', 'keon2004@live.com', 'https://kjf-tech.net/FilesByBoard/KJF.png', 1495388559);

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

--
-- Estrutura para tabela `websettings`
--

CREATE TABLE `websettings` (
  `id` int(11) NOT NULL,
  `maintenance` tinyint(1) NOT NULL,
  `forcemaintenance` int(11) DEFAULT NULL,
  `whoEnabledmaintenance` varchar(24) DEFAULT NULL,
  `maintenanceReason` varchar(128) DEFAULT NULL,
  `whenMaintenanceEnabled` varchar(24) DEFAULT NULL,
  `maintenanceMessage` varchar(256) DEFAULT NULL,
  `cooldown` tinyint(1) NOT NULL,
  `dbmode` tinyint(1) NOT NULL,
  `registration` tinyint(1) NOT NULL,
  `forumMaintenance` tinyint(1) NOT NULL,
  `guestForums` tinyint(1) NOT NULL,
  `shopMaintenance` tinyint(1) NOT NULL,
  `websiteLink` varchar(64) NOT NULL,
  `cdnLink` varchar(64) NOT NULL,
  `filesLink` varchar(64) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='settings of the website';

--
-- Fazendo dump de dados para tabela `websettings`
--

INSERT INTO `websettings` (`id`, `maintenance`, `forcemaintenance`, `whoEnabledmaintenance`, `maintenanceReason`, `whenMaintenanceEnabled`, `maintenanceMessage`, `cooldown`, `dbmode`, `registration`, `forumMaintenance`, `guestForums`, `shopMaintenance`, `websiteLink`, `cdnLink`, `filesLink`) VALUES
(1, 1, 1, 'KJF2', 'Because this is a test currently at the moment.', '09/2/2017 10:03:12', 'Hey there! Welcome to maintenance mode! If you are an administrator/moderator, you can login in with your developer account below. DM papa shells for a Blocksi account as it wont be released for a while!', 0, 0, 0, 0, 0, 0, 'http://blocksi.gq', 'http://img.blocksi.gq', 'http://files.blocksi.gq');

--
-- Índices de tabelas apagadas
--

--
-- Índices de tabela `ban_offenses`
--
ALTER TABLE `ban_offenses`
  ADD PRIMARY KEY (`id`);

--
-- Índices de tabela `blocksi`
--
ALTER TABLE `blocksi`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `id_2` (`id`),
  ADD KEY `id` (`id`);

--
-- Índices de tabela `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`);

--
-- Índices de tabela `devusers`
--
ALTER TABLE `devusers`
  ADD PRIMARY KEY (`id`);

--
-- Índices de tabela `friendrequests`
--
ALTER TABLE `friendrequests`
  ADD PRIMARY KEY (`id`);

--
-- Índices de tabela `friendships`
--
ALTER TABLE `friendships`
  ADD PRIMARY KEY (`id`);

--
-- Índices de tabela `itemlikes`
--
ALTER TABLE `itemlikes`
  ADD PRIMARY KEY (`id`);

--
-- Índices de tabela `logs`
--
ALTER TABLE `logs`
  ADD PRIMARY KEY (`id`);

--
-- Índices de tabela `shopitems`
--
ALTER TABLE `shopitems`
  ADD PRIMARY KEY (`id`);

--
-- Índices de tabela `statuses`
--
ALTER TABLE `statuses`
  ADD PRIMARY KEY (`id`);

--
-- Índices de tabela `tbl_users`
--
ALTER TABLE `tbl_users`
  ADD PRIMARY KEY (`user_id`),
  ADD UNIQUE KEY `email` (`email`);

--
-- Índices de tabela `topics`
--
ALTER TABLE `topics`
  ADD PRIMARY KEY (`id`,`id2`);

--
-- Índices de tabela `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`);

--
-- Índices de tabela `websettings`
--
ALTER TABLE `websettings`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT de tabelas apagadas
--

--
-- AUTO_INCREMENT de tabela `ban_offenses`
--
ALTER TABLE `ban_offenses`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT de tabela `blocksi`
--
ALTER TABLE `blocksi`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'AUTO_INCREMENT', AUTO_INCREMENT=2001;
--
-- AUTO_INCREMENT de tabela `devusers`
--
ALTER TABLE `devusers`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT de tabela `friendrequests`
--
ALTER TABLE `friendrequests`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT de tabela `friendships`
--
ALTER TABLE `friendships`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT de tabela `itemlikes`
--
ALTER TABLE `itemlikes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT de tabela `logs`
--
ALTER TABLE `logs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=68;
--
-- AUTO_INCREMENT de tabela `shopitems`
--
ALTER TABLE `shopitems`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT de tabela `statuses`
--
ALTER TABLE `statuses`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
--
-- AUTO_INCREMENT de tabela `tbl_users`
--
ALTER TABLE `tbl_users`
  MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
/*!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 */;