-- phpMyAdmin SQL Dump
-- version 4.9.11
-- https://www.phpmyadmin.net/

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: `chan`
--

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

--
-- Table structure for table `actions_log`
--

CREATE TABLE `actions_log` (
  `id` int(10) UNSIGNED NOT NULL,
  `oldmask` int(11) DEFAULT NULL,
  `newmask` int(11) DEFAULT NULL,
  `postno` int(10) UNSIGNED NOT NULL,
  `board` varchar(10) NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `sub` varchar(100) DEFAULT NULL,
  `com` text DEFAULT NULL,
  `filename` varchar(255) DEFAULT NULL,
  `admin` varchar(50) NOT NULL,
  `created_on` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `april_emotes`
--

CREATE TABLE `april_emotes` (
  `id` int(10) UNSIGNED NOT NULL,
  `session_id` varchar(40) NOT NULL,
  `ip` varchar(45) DEFAULT NULL,
  `data` text DEFAULT NULL,
  `created_on` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=ascii COLLATE=ascii_bin;

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

--
-- Table structure for table `april_stock_prices`
--

CREATE TABLE `april_stock_prices` (
  `id` int(10) UNSIGNED NOT NULL,
  `stock` varchar(10) NOT NULL,
  `price` int(11) NOT NULL,
  `created_on` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=ascii COLLATE=ascii_bin;

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

--
-- Table structure for table `april_stock_users`
--

CREATE TABLE `april_stock_users` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` varchar(32) NOT NULL,
  `stock` varchar(10) NOT NULL,
  `amount` int(11) NOT NULL,
  `created_on` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=ascii COLLATE=ascii_bin;

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

--
-- Table structure for table `banned_users`
--

CREATE TABLE `banned_users` (
  `no` int(10) UNSIGNED NOT NULL,
  `board` varchar(10) DEFAULT NULL,
  `global` tinyint(1) NOT NULL DEFAULT 0,
  `zonly` tinyint(1) NOT NULL DEFAULT 0,
  `name` varchar(100) DEFAULT NULL,
  `tripcode` varchar(20) DEFAULT NULL,
  `host` varchar(45) NOT NULL,
  `reverse` varchar(255) DEFAULT NULL,
  `xff` varchar(255) DEFAULT NULL,
  `reason` text DEFAULT NULL,
  `length` datetime DEFAULT NULL,
  `admin` varchar(50) NOT NULL,
  `md5` varchar(32) DEFAULT NULL,
  `4pass_id` varchar(10) DEFAULT NULL,
  `password` varchar(64) DEFAULT NULL,
  `post_num` int(10) UNSIGNED DEFAULT NULL,
  `rule` varchar(50) DEFAULT NULL,
  `post_time` datetime DEFAULT NULL,
  `post_json` text DEFAULT NULL,
  `template_id` int(11) DEFAULT NULL,
  `admin_ip` varchar(45) DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT 1,
  `now` timestamp NOT NULL DEFAULT current_timestamp(),
  `unbannedon` timestamp NULL DEFAULT NULL,
  `unbannedby` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `ban_requests`
--

CREATE TABLE `ban_requests` (
  `id` int(10) UNSIGNED NOT NULL,
  `host` varchar(45) NOT NULL,
  `reverse` varchar(255) DEFAULT NULL,
  `pwd` varchar(64) DEFAULT NULL,
  `xff` varchar(255) DEFAULT NULL,
  `reason` text DEFAULT NULL,
  `global` tinyint(1) DEFAULT 0,
  `tpl_name` varchar(255) DEFAULT NULL,
  `ban_template` int(11) DEFAULT NULL,
  `board` varchar(10) NOT NULL,
  `janitor` varchar(50) NOT NULL,
  `spost` blob DEFAULT NULL,
  `post_json` text DEFAULT NULL,
  `warn_req` tinyint(1) DEFAULT 0,
  `ts` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `ban_templates`
--

CREATE TABLE `ban_templates` (
  `no` int(10) UNSIGNED NOT NULL,
  `rule` varchar(50) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `publicreason` text DEFAULT NULL,
  `privatereason` text DEFAULT NULL,
  `days` int(11) DEFAULT NULL,
  `banlen` varchar(20) DEFAULT NULL,
  `publicban` tinyint(1) DEFAULT 0,
  `bantype` enum('local','global') DEFAULT 'local',
  `postban` varchar(20) DEFAULT NULL,
  `postban_arg` varchar(10) DEFAULT NULL,
  `save_post` varchar(20) DEFAULT NULL,
  `can_warn` tinyint(1) DEFAULT 1,
  `level` enum('janitor','mod','manager','admin') DEFAULT 'mod',
  `special_action` varchar(50) DEFAULT NULL,
  `blacklist` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `blacklist`
--

CREATE TABLE `blacklist` (
  `id` int(10) UNSIGNED NOT NULL,
  `field` varchar(20) NOT NULL,
  `contents` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `addedby` varchar(50) DEFAULT NULL,
  `ban` tinyint(4) DEFAULT 0,
  `banlength` int(11) DEFAULT 0,
  `banreason` text DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT 1,
  `boardrestrict` varchar(255) DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `blotter_messages`
--

CREATE TABLE `blotter_messages` (
  `id` int(10) UNSIGNED NOT NULL,
  `date` int(10) UNSIGNED NOT NULL,
  `content` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `boardlist`
--

CREATE TABLE `boardlist` (
  `id` int(10) UNSIGNED NOT NULL,
  `dir` varchar(10) NOT NULL,
  `name` varchar(100) NOT NULL,
  `db` int(11) DEFAULT NULL,
  `domain` varchar(100) DEFAULT NULL,
  `sql_cache` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `contest_banners`
--

CREATE TABLE `contest_banners` (
  `id` int(10) UNSIGNED NOT NULL,
  `file_id` varchar(50) NOT NULL,
  `file_ext` varchar(4) NOT NULL,
  `board` varchar(10) NOT NULL,
  `is_live` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=ascii COLLATE=ascii_bin;

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

--
-- Table structure for table `del_log`
--

CREATE TABLE `del_log` (
  `id` int(10) UNSIGNED NOT NULL,
  `imgonly` tinyint(1) NOT NULL DEFAULT 0,
  `postno` int(10) UNSIGNED NOT NULL,
  `resto` int(10) UNSIGNED DEFAULT 0,
  `board` varchar(10) NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `sub` varchar(100) DEFAULT NULL,
  `com` text DEFAULT NULL,
  `img` tinyint(1) DEFAULT 0,
  `filename` varchar(255) DEFAULT NULL,
  `admin` varchar(50) DEFAULT NULL,
  `admin_ip` varchar(45) DEFAULT NULL,
  `template_id` int(11) DEFAULT 0,
  `tool` varchar(20) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `email_signins`
--

CREATE TABLE `email_signins` (
  `id` int(10) UNSIGNED NOT NULL,
  `token` varchar(32) NOT NULL,
  `hashed_email` varchar(32) NOT NULL,
  `ip` varchar(45) NOT NULL,
  `domain` varchar(100) DEFAULT NULL,
  `ua` varchar(255) DEFAULT NULL,
  `country` varchar(2) DEFAULT NULL,
  `bot_score` int(11) DEFAULT 0,
  `created_on` timestamp NOT NULL DEFAULT current_timestamp(),
  `used` int(11) NOT NULL DEFAULT 0,
  `failed_challenges` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=ascii COLLATE=ascii_bin;

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

--
-- Table structure for table `email_signins_blacklist`
--

CREATE TABLE `email_signins_blacklist` (
  `id` int(10) UNSIGNED NOT NULL,
  `email` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=ascii COLLATE=ascii_bin;

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

--
-- Table structure for table `email_signins_queue`
--

CREATE TABLE `email_signins_queue` (
  `id` int(10) UNSIGNED NOT NULL,
  `email` varchar(255) NOT NULL,
  `token` varchar(32) NOT NULL,
  `created_on` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `event_log`
--

CREATE TABLE `event_log` (
  `id` int(10) UNSIGNED NOT NULL,
  `type` varchar(30) NOT NULL,
  `ip` varchar(45) DEFAULT NULL,
  `board` varchar(10) DEFAULT NULL,
  `thread_id` int(10) UNSIGNED DEFAULT NULL,
  `post_id` int(10) UNSIGNED DEFAULT NULL,
  `arg_num` int(11) DEFAULT NULL,
  `arg_str` varchar(50) DEFAULT NULL,
  `pwd` varchar(64) DEFAULT NULL,
  `req_sig` varchar(8) DEFAULT NULL,
  `ua_sig` varchar(9) DEFAULT NULL,
  `meta` text DEFAULT NULL,
  `created_on` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `flood_log`
--

CREATE TABLE `flood_log` (
  `id` int(10) UNSIGNED NOT NULL,
  `board` varchar(10) NOT NULL,
  `thread_id` int(10) UNSIGNED NOT NULL,
  `ip` varchar(45) NOT NULL,
  `phash` varchar(16) DEFAULT NULL,
  `ua_sig` varchar(9) DEFAULT NULL,
  `req_sig` varchar(8) DEFAULT NULL,
  `created_on` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=ascii COLLATE=ascii_bin;

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

--
-- Table structure for table `f_md5`
--

CREATE TABLE `f_md5` (
  `filename` varchar(255) NOT NULL,
  `md5` varchar(32) NOT NULL,
  `now` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=ascii COLLATE=ascii_bin;

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

--
-- Table structure for table `g`
--

CREATE TABLE `g` (
  `no` int(10) UNSIGNED NOT NULL,
  `resto` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `sticky` tinyint(1) NOT NULL DEFAULT 0,
  `closed` tinyint(1) NOT NULL DEFAULT 0,
  `archived` tinyint(1) NOT NULL DEFAULT 0,
  `now` varchar(50) NOT NULL,
  `time` int(10) UNSIGNED NOT NULL,
  `last_modified` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `root` timestamp NULL DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `tripcode` varchar(20) DEFAULT NULL,
  `capcode` varchar(50) NOT NULL DEFAULT 'none',
  `country` varchar(2) DEFAULT NULL,
  `board_flag` varchar(10) DEFAULT NULL,
  `id` varchar(10) DEFAULT NULL,
  `sub` varchar(100) DEFAULT NULL,
  `com` text DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `host` varchar(45) DEFAULT NULL,
  `pwd` varchar(64) DEFAULT NULL,
  `4pass_id` varchar(10) DEFAULT NULL,
  `since4pass` int(11) DEFAULT 0,
  `filename` varchar(255) DEFAULT NULL,
  `ext` varchar(10) DEFAULT NULL,
  `fsize` int(10) UNSIGNED DEFAULT 0,
  `md5` varchar(32) DEFAULT NULL,
  `w` int(10) UNSIGNED DEFAULT 0,
  `h` int(10) UNSIGNED DEFAULT 0,
  `tn_w` int(10) UNSIGNED DEFAULT 0,
  `tn_h` int(10) UNSIGNED DEFAULT 0,
  `tim` varchar(20) DEFAULT NULL,
  `filedeleted` tinyint(1) NOT NULL DEFAULT 0,
  `tmd5` varchar(16) DEFAULT NULL,
  `permasage` tinyint(1) NOT NULL DEFAULT 0,
  `permaage` tinyint(1) NOT NULL DEFAULT 0,
  `undead` tinyint(1) NOT NULL DEFAULT 0,
  `m_img` tinyint(1) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `halloween_tricks`
--

CREATE TABLE `halloween_tricks` (
  `user_hash` varchar(10) NOT NULL,
  `score` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=ascii COLLATE=ascii_bin;

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

--
-- Table structure for table `halloween_votes`
--

CREATE TABLE `halloween_votes` (
  `id` int(10) UNSIGNED NOT NULL,
  `long_ip` int(10) UNSIGNED NOT NULL,
  `board` varchar(10) NOT NULL,
  `post_id` int(10) UNSIGNED NOT NULL,
  `created_on` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=ascii COLLATE=ascii_bin;

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

--
-- Table structure for table `iprangebans`
--

CREATE TABLE `iprangebans` (
  `id` int(10) UNSIGNED NOT NULL,
  `range_start` int(10) UNSIGNED NOT NULL,
  `range_end` int(10) UNSIGNED NOT NULL,
  `asn` int(10) UNSIGNED DEFAULT NULL,
  `reason` text DEFAULT NULL,
  `creator` varchar(50) DEFAULT NULL,
  `created_on` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_on` int(10) UNSIGNED DEFAULT NULL,
  `expires_on` int(10) UNSIGNED DEFAULT 0,
  `active` tinyint(1) NOT NULL DEFAULT 1,
  `boards` text DEFAULT NULL,
  `ops_only` tinyint(1) DEFAULT 0,
  `img_only` tinyint(1) DEFAULT 0,
  `lenient` tinyint(4) DEFAULT 0,
  `report_only` tinyint(1) DEFAULT 0,
  `ua_ids` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=ascii COLLATE=ascii_bin;

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

--
-- Table structure for table `like_user_log`
--

CREATE TABLE `like_user_log` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` varchar(32) NOT NULL,
  `target_user_id` varchar(32) NOT NULL,
  `suspicious` tinyint(1) DEFAULT 0,
  `board` varchar(10) NOT NULL,
  `post_id` int(10) UNSIGNED NOT NULL,
  `created_on` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=ascii COLLATE=ascii_bin;

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

--
-- Table structure for table `like_user_scores`
--

CREATE TABLE `like_user_scores` (
  `user_id` varchar(32) NOT NULL,
  `user_score` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=ascii COLLATE=ascii_bin;

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

--
-- Table structure for table `mod_users`
--

CREATE TABLE `mod_users` (
  `id` int(10) UNSIGNED NOT NULL,
  `username` varchar(50) NOT NULL,
  `password` varchar(255) NOT NULL,
  `allow` text DEFAULT NULL,
  `deny` text DEFAULT NULL,
  `flags` text DEFAULT NULL,
  `level` enum('janitor','mod','manager','admin') NOT NULL,
  `password_expired` tinyint(1) NOT NULL DEFAULT 0,
  `signed_agreement` tinyint(1) NOT NULL DEFAULT 0,
  `auth_secret` varchar(255) DEFAULT NULL,
  `ips` text DEFAULT NULL,
  `last_ua` varchar(128) DEFAULT NULL,
  `last_login` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `pass_users`
--

CREATE TABLE `pass_users` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_hash` varchar(10) NOT NULL,
  `session_id` varchar(64) DEFAULT NULL,
  `pin` varchar(255) NOT NULL,
  `email` varchar(255) DEFAULT NULL,
  `gift_email` varchar(255) DEFAULT NULL,
  `purchase_date` datetime DEFAULT NULL,
  `expiration_date` datetime DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `last_status` tinyint(4) DEFAULT NULL,
  `email_reminder_sent` tinyint(1) NOT NULL DEFAULT 0,
  `email_expired_sent` tinyint(1) NOT NULL DEFAULT 0,
  `last_ip` varchar(45) DEFAULT NULL,
  `last_used` timestamp NULL DEFAULT NULL,
  `last_country` varchar(2) DEFAULT NULL,
  `pending_id` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `postfilter`
--

CREATE TABLE `postfilter` (
  `id` int(10) UNSIGNED NOT NULL,
  `pattern` text NOT NULL,
  `autosage` tinyint(1) NOT NULL DEFAULT 0,
  `log` tinyint(1) NOT NULL DEFAULT 0,
  `regex` tinyint(1) NOT NULL DEFAULT 0,
  `quiet` tinyint(1) NOT NULL DEFAULT 0,
  `lenient` tinyint(1) NOT NULL DEFAULT 0,
  `ops_only` tinyint(1) NOT NULL DEFAULT 0,
  `min_count` int(11) DEFAULT 1,
  `board` varchar(10) NOT NULL DEFAULT '',
  `ban_days` int(11) DEFAULT 0,
  `created_on` int(10) UNSIGNED DEFAULT NULL,
  `updated_on` int(10) UNSIGNED DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `postfilter_hits`
--

CREATE TABLE `postfilter_hits` (
  `id` int(10) UNSIGNED NOT NULL,
  `filter_id` int(10) UNSIGNED NOT NULL,
  `board` varchar(10) DEFAULT NULL,
  `long_ip` int(10) UNSIGNED NOT NULL,
  `created_on` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=ascii COLLATE=ascii_bin;

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

--
-- Table structure for table `r9k_mutes`
--

CREATE TABLE `r9k_mutes` (
  `ip` int(10) UNSIGNED NOT NULL,
  `timeout_power` int(11) NOT NULL DEFAULT 0,
  `mute_until` timestamp NULL DEFAULT NULL,
  `next_expire` timestamp NULL DEFAULT NULL,
  `created_on` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=ascii COLLATE=ascii_bin;

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

--
-- Table structure for table `r9k_posts`
--

CREATE TABLE `r9k_posts` (
  `text` varchar(32) NOT NULL,
  `image` varchar(32) DEFAULT NULL,
  `created_on` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=ascii COLLATE=ascii_bin;

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

--
-- Table structure for table `rapidsearch`
--

CREATE TABLE `rapidsearch` (
  `id` int(10) UNSIGNED NOT NULL,
  `board` varchar(10) NOT NULL,
  `postno` int(10) UNSIGNED NOT NULL,
  `body` text DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `reports`
--

CREATE TABLE `reports` (
  `id` int(10) UNSIGNED NOT NULL,
  `ip` int(10) UNSIGNED NOT NULL,
  `pwd` varchar(64) DEFAULT NULL,
  `4pass_id` varchar(10) DEFAULT NULL,
  `req_sig` varchar(8) DEFAULT NULL,
  `board` varchar(10) NOT NULL,
  `no` int(10) UNSIGNED NOT NULL,
  `resto` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `cat` tinyint(4) DEFAULT NULL,
  `weight` float DEFAULT 1,
  `report_category` int(11) DEFAULT NULL,
  `ws` tinyint(1) DEFAULT 0,
  `post_ip` int(10) UNSIGNED DEFAULT NULL,
  `post_json` text DEFAULT NULL,
  `cleared` tinyint(1) NOT NULL DEFAULT 0,
  `cleared_by` varchar(50) DEFAULT NULL,
  `ts` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `reports_for_posts`
--

CREATE TABLE `reports_for_posts` (
  `id` int(10) UNSIGNED NOT NULL,
  `board` varchar(10) NOT NULL,
  `postid` int(10) UNSIGNED NOT NULL,
  `threadid` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `num_rule` int(11) NOT NULL DEFAULT 0,
  `num_illegal` int(11) NOT NULL DEFAULT 0,
  `max_cat` tinyint(4) DEFAULT NULL,
  `cleared` tinyint(1) NOT NULL DEFAULT 0,
  `clearedby` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `report_categories`
--

CREATE TABLE `report_categories` (
  `id` int(10) UNSIGNED NOT NULL,
  `board` varchar(10) DEFAULT NULL,
  `op_only` tinyint(1) DEFAULT 0,
  `reply_only` tinyint(1) DEFAULT 0,
  `image_only` tinyint(1) DEFAULT 0,
  `exclude_boards` text DEFAULT NULL,
  `title` varchar(255) NOT NULL,
  `weight` float NOT NULL DEFAULT 1,
  `filtered` int(11) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `report_clear_log`
--

CREATE TABLE `report_clear_log` (
  `id` int(10) UNSIGNED NOT NULL,
  `long_ip` int(10) UNSIGNED NOT NULL,
  `pwd` varchar(64) DEFAULT NULL,
  `pass_id` varchar(10) DEFAULT NULL,
  `category` int(11) DEFAULT NULL,
  `weight` float DEFAULT NULL,
  `created_on` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=ascii COLLATE=ascii_bin;

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

--
-- Table structure for table `tensor_log`
--

CREATE TABLE `tensor_log` (
  `id` int(10) UNSIGNED NOT NULL,
  `board` varchar(10) NOT NULL,
  `thread_id` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `post_id` int(10) UNSIGNED NOT NULL,
  `file_id` varchar(20) DEFAULT NULL,
  `file_ext` varchar(4) DEFAULT NULL,
  `nsfw` float DEFAULT NULL,
  `created_on` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=ascii COLLATE=ascii_bin;

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

--
-- Table structure for table `user_actions`
--

CREATE TABLE `user_actions` (
  `id` int(11) NOT NULL,
  `board` varchar(10) DEFAULT NULL,
  `postno` int(11) DEFAULT NULL,
  `ip` bigint(20) UNSIGNED DEFAULT NULL,
  `time` datetime DEFAULT NULL,
  `uploaded` bigint(20) DEFAULT NULL,
  `action` varchar(50) DEFAULT NULL,
  `had_image` tinyint(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `vip_capcodes`
--

CREATE TABLE `vip_capcodes` (
  `user_id` varchar(50) NOT NULL,
  `user_key` varchar(255) NOT NULL,
  `name` varchar(100) NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT 1,
  `last_used` int(10) UNSIGNED DEFAULT NULL,
  `last_ip` varchar(45) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `actions_log`
--
ALTER TABLE `actions_log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `board` (`board`),
  ADD KEY `admin` (`admin`);

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

--
-- Indexes for table `april_stock_prices`
--
ALTER TABLE `april_stock_prices`
  ADD PRIMARY KEY (`id`),
  ADD KEY `stock` (`stock`,`created_on`);

--
-- Indexes for table `april_stock_users`
--
ALTER TABLE `april_stock_users`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `stock` (`stock`);

--
-- Indexes for table `banned_users`
--
ALTER TABLE `banned_users`
  ADD PRIMARY KEY (`no`),
  ADD KEY `host` (`host`),
  ADD KEY `active` (`active`),
  ADD KEY `md5` (`md5`),
  ADD KEY `4pass_id` (`4pass_id`),
  ADD KEY `password` (`password`(8));

--
-- Indexes for table `ban_requests`
--
ALTER TABLE `ban_requests`
  ADD PRIMARY KEY (`id`),
  ADD KEY `host` (`host`),
  ADD KEY `board` (`board`),
  ADD KEY `ts` (`ts`);

--
-- Indexes for table `ban_templates`
--
ALTER TABLE `ban_templates`
  ADD PRIMARY KEY (`no`);

--
-- Indexes for table `blacklist`
--
ALTER TABLE `blacklist`
  ADD PRIMARY KEY (`id`),
  ADD KEY `active` (`active`,`field`,`contents`(191)),
  ADD KEY `boardrestrict` (`boardrestrict`(191));

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

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

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

--
-- Indexes for table `del_log`
--
ALTER TABLE `del_log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `board` (`board`),
  ADD KEY `timestamp` (`timestamp`),
  ADD KEY `admin` (`admin`);

--
-- Indexes for table `email_signins`
--
ALTER TABLE `email_signins`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `token` (`token`),
  ADD KEY `hashed_email` (`hashed_email`),
  ADD KEY `ip` (`ip`),
  ADD KEY `created_on` (`created_on`);

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

--
-- Indexes for table `email_signins_queue`
--
ALTER TABLE `email_signins_queue`
  ADD PRIMARY KEY (`id`),
  ADD KEY `email` (`email`);

--
-- Indexes for table `event_log`
--
ALTER TABLE `event_log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `type` (`type`),
  ADD KEY `ip` (`ip`),
  ADD KEY `pwd` (`pwd`(8)),
  ADD KEY `ua_sig` (`ua_sig`),
  ADD KEY `created_on` (`created_on`);

--
-- Indexes for table `flood_log`
--
ALTER TABLE `flood_log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `ip` (`ip`),
  ADD KEY `created_on` (`created_on`);

--
-- Indexes for table `f_md5`
--
ALTER TABLE `f_md5`
  ADD PRIMARY KEY (`filename`),
  ADD KEY `md5` (`md5`);

--
-- Indexes for table `g`
--
ALTER TABLE `g`
  ADD PRIMARY KEY (`no`),
  ADD KEY `resto` (`resto`);

--
-- Indexes for table `halloween_tricks`
--
ALTER TABLE `halloween_tricks`
  ADD PRIMARY KEY (`user_hash`);

--
-- Indexes for table `halloween_votes`
--
ALTER TABLE `halloween_votes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `long_ip` (`long_ip`),
  ADD KEY `board` (`board`,`post_id`);

--
-- Indexes for table `iprangebans`
--
ALTER TABLE `iprangebans`
  ADD PRIMARY KEY (`id`),
  ADD KEY `range_start` (`range_start`),
  ADD KEY `range_end` (`range_end`),
  ADD KEY `asn` (`asn`),
  ADD KEY `active` (`active`);

--
-- Indexes for table `like_user_log`
--
ALTER TABLE `like_user_log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `target_user_id` (`target_user_id`),
  ADD KEY `created_on` (`created_on`);

--
-- Indexes for table `like_user_scores`
--
ALTER TABLE `like_user_scores`
  ADD PRIMARY KEY (`user_id`);

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

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

--
-- Indexes for table `postfilter`
--
ALTER TABLE `postfilter`
  ADD PRIMARY KEY (`id`),
  ADD KEY `active` (`active`,`board`);

--
-- Indexes for table `postfilter_hits`
--
ALTER TABLE `postfilter_hits`
  ADD PRIMARY KEY (`id`),
  ADD KEY `filter_id` (`filter_id`,`long_ip`,`created_on`);

--
-- Indexes for table `r9k_mutes`
--
ALTER TABLE `r9k_mutes`
  ADD PRIMARY KEY (`ip`);

--
-- Indexes for table `r9k_posts`
--
ALTER TABLE `r9k_posts`
  ADD PRIMARY KEY (`text`);

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

--
-- Indexes for table `reports`
--
ALTER TABLE `reports`
  ADD PRIMARY KEY (`id`),
  ADD KEY `ip` (`ip`),
  ADD KEY `board` (`board`,`no`),
  ADD KEY `ts` (`ts`);

--
-- Indexes for table `reports_for_posts`
--
ALTER TABLE `reports_for_posts`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `board_postid` (`board`,`postid`),
  ADD KEY `postid` (`postid`);

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

--
-- Indexes for table `report_clear_log`
--
ALTER TABLE `report_clear_log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `long_ip` (`long_ip`),
  ADD KEY `pwd` (`pwd`),
  ADD KEY `pass_id` (`pass_id`),
  ADD KEY `created_on` (`created_on`);

--
-- Indexes for table `tensor_log`
--
ALTER TABLE `tensor_log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `board_post_id` (`board`,`post_id`);

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

--
-- Indexes for table `vip_capcodes`
--
ALTER TABLE `vip_capcodes`
  ADD PRIMARY KEY (`user_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `actions_log`
--
ALTER TABLE `actions_log`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `april_emotes`
--
ALTER TABLE `april_emotes`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `april_stock_prices`
--
ALTER TABLE `april_stock_prices`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `april_stock_users`
--
ALTER TABLE `april_stock_users`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `banned_users`
--
ALTER TABLE `banned_users`
  MODIFY `no` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ban_requests`
--
ALTER TABLE `ban_requests`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ban_templates`
--
ALTER TABLE `ban_templates`
  MODIFY `no` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `blacklist`
--
ALTER TABLE `blacklist`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `blotter_messages`
--
ALTER TABLE `blotter_messages`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `boardlist`
--
ALTER TABLE `boardlist`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `contest_banners`
--
ALTER TABLE `contest_banners`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `del_log`
--
ALTER TABLE `del_log`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `email_signins`
--
ALTER TABLE `email_signins`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `email_signins_blacklist`
--
ALTER TABLE `email_signins_blacklist`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `email_signins_queue`
--
ALTER TABLE `email_signins_queue`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `event_log`
--
ALTER TABLE `event_log`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `flood_log`
--
ALTER TABLE `flood_log`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `g`
--
ALTER TABLE `g`
  MODIFY `no` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `halloween_votes`
--
ALTER TABLE `halloween_votes`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `iprangebans`
--
ALTER TABLE `iprangebans`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `like_user_log`
--
ALTER TABLE `like_user_log`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mod_users`
--
ALTER TABLE `mod_users`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pass_users`
--
ALTER TABLE `pass_users`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `postfilter`
--
ALTER TABLE `postfilter`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `postfilter_hits`
--
ALTER TABLE `postfilter_hits`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `rapidsearch`
--
ALTER TABLE `rapidsearch`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `reports`
--
ALTER TABLE `reports`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `reports_for_posts`
--
ALTER TABLE `reports_for_posts`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `report_categories`
--
ALTER TABLE `report_categories`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `report_clear_log`
--
ALTER TABLE `report_clear_log`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tensor_log`
--
ALTER TABLE `tensor_log`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `user_actions`
--
ALTER TABLE `user_actions`
  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 */;