schema.sql

-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: MySQL-8.4
-- Generation Time: Oct 23, 2025 at 07:36 PM
-- Server version: 8.4.4
-- PHP Version: 8.4.1

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

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

--
-- Table structure for table `achievement_text`
--

CREATE TABLE `achievement_text` (
  `name` varchar(64) NOT NULL,
  `text` varchar(1000) NOT NULL,
  `amount` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `achievement_users`
--

CREATE TABLE `achievement_users` (
  `username` varchar(20) NOT NULL,
  `name` varchar(64) NOT NULL,
  `type` varchar(12) NOT NULL COMMENT 's,v',
  `ach_date` date NOT NULL,
  `closed` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `activations`
--

CREATE TABLE `activations` (
  `username` varchar(20) NOT NULL,
  `secret` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `applications`
--

CREATE TABLE `applications` (
  `username` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `name` varchar(256) NOT NULL,
  `birthday` date NOT NULL,
  `country` varchar(5) NOT NULL,
  `what` varchar(500) NOT NULL,
  `why` varchar(500) NOT NULL,
  `date` datetime NOT NULL,
  `accepted` tinyint(1) NOT NULL DEFAULT '0',
  `review_time` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `badboys`
--

CREATE TABLE `badboys` (
  `ip` varchar(64) NOT NULL,
  `submit_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `username` varchar(33) NOT NULL DEFAULT '',
  `agent` varchar(315) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `ban_reasons`
--

CREATE TABLE `ban_reasons` (
  `id` int NOT NULL,
  `reason` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `blog`
--

CREATE TABLE `blog` (
  `id` int NOT NULL,
  `title` varchar(256) NOT NULL,
  `content` mediumtext NOT NULL,
  `date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `bulletins`
--

CREATE TABLE `bulletins` (
  `id` int NOT NULL,
  `content` varchar(500) NOT NULL,
  `by_user` varchar(20) NOT NULL,
  `date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `channel_banners`
--

CREATE TABLE `channel_banners` (
  `username` varchar(20) NOT NULL,
  `links` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `channel_comments`
--

CREATE TABLE `channel_comments` (
  `id` int NOT NULL,
  `on_channel` varchar(20) NOT NULL,
  `by_user` varchar(20) NOT NULL,
  `comment` varchar(500) NOT NULL,
  `date` datetime NOT NULL,
  `seen` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `contest_entries`
--

CREATE TABLE `contest_entries` (
  `url` varchar(11) NOT NULL,
  `votes` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `contest_votes`
--

CREATE TABLE `contest_votes` (
  `url` varchar(11) NOT NULL,
  `ip` varchar(128) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `converting`
--

CREATE TABLE `converting` (
  `url` varchar(11) NOT NULL,
  `uploaded_on` datetime NOT NULL,
  `convert_status` tinyint(1) NOT NULL DEFAULT '0',
  `queue` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `feature_suggestions`
--

CREATE TABLE `feature_suggestions` (
  `id` int NOT NULL,
  `title` varchar(128) NOT NULL,
  `description` varchar(1000) NOT NULL,
  `from_user` varchar(20) NOT NULL,
  `votes` int NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `forgot_password`
--

CREATE TABLE `forgot_password` (
  `username` varchar(20) NOT NULL,
  `code` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `friends`
--

CREATE TABLE `friends` (
  `id` int NOT NULL,
  `friend_1` varchar(20) NOT NULL,
  `friend_2` varchar(20) NOT NULL,
  `by_user` varchar(20) NOT NULL,
  `status` int NOT NULL DEFAULT '0',
  `sent_on` datetime NOT NULL,
  `seen` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `help`
--

CREATE TABLE `help` (
  `id` int NOT NULL,
  `guid` varchar(128) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `title` text COLLATE utf8mb4_general_ci,
  `content` mediumtext COLLATE utf8mb4_general_ci NOT NULL,
  `published` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `iprange_bans`
--

CREATE TABLE `iprange_bans` (
  `bid` int NOT NULL,
  `ip_range` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `mentions`
--

CREATE TABLE `mentions` (
  `video` int DEFAULT NULL,
  `channel` varchar(20) DEFAULT NULL,
  `type` int NOT NULL,
  `date` datetime NOT NULL,
  `username` varchar(20) NOT NULL,
  `seen` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `most_subscribed_month`
--

CREATE TABLE `most_subscribed_month` (
  `username` varchar(20) NOT NULL,
  `amount` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `most_subscribed_week`
--

CREATE TABLE `most_subscribed_week` (
  `username` varchar(20) NOT NULL,
  `amount` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `most_viewed_month`
--

CREATE TABLE `most_viewed_month` (
  `username` varchar(20) NOT NULL,
  `amount` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `most_viewed_week`
--

CREATE TABLE `most_viewed_week` (
  `username` varchar(20) NOT NULL,
  `amount` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `options`
--

CREATE TABLE `options` (
  `option_name` varchar(50) NOT NULL,
  `value` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `playlists`
--

CREATE TABLE `playlists` (
  `purl` varchar(11) COLLATE utf8mb4_general_ci NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `title` varchar(128) COLLATE utf8mb4_general_ci NOT NULL,
  `description` text COLLATE utf8mb4_general_ci NOT NULL,
  `created_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `thumbnail` varchar(11) COLLATE utf8mb4_general_ci NOT NULL,
  `created_on` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `playlists_videos`
--

CREATE TABLE `playlists_videos` (
  `url` varchar(11) NOT NULL,
  `purl` varchar(11) NOT NULL,
  `position` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `private_messages`
--

CREATE TABLE `private_messages` (
  `id` int NOT NULL,
  `from_user` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `to_user` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `message` varchar(10000) NOT NULL,
  `subject` varchar(256) NOT NULL DEFAULT '',
  `date_sent` datetime NOT NULL,
  `seen` int NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `recently_viewed`
--

CREATE TABLE `recently_viewed` (
  `url` varchar(11) NOT NULL,
  `time_viewed` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `replies`
--

CREATE TABLE `replies` (
  `id` int NOT NULL,
  `for_user` varchar(20) NOT NULL,
  `seen` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

CREATE TABLE `reports` (
  `id` int NOT NULL,
  `report_from` int NOT NULL,
  `report_to` int NOT NULL,
  `report_type` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `report_description` text COLLATE utf8mb4_general_ci,
  `reported` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` int NOT NULL,
  `session` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `user` int NOT NULL,
  `ip` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `remembered` int NOT NULL DEFAULT '0',
  `first_access` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `last_access` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `browser` text COLLATE utf8mb4_general_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

CREATE TABLE `settings` (
  `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `value` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `strikes`
--

CREATE TABLE `strikes` (
  `username` varchar(20) NOT NULL,
  `issued_by` varchar(20) NOT NULL,
  `issued_on` int NOT NULL,
  `video_links` text NOT NULL,
  `comment` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `subscriptions`
--

CREATE TABLE `subscriptions` (
  `id` int NOT NULL,
  `subscriber` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `subscription` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `submit_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `source` varchar(11) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `terminations`
--

CREATE TABLE `terminations` (
  `username` varchar(20) NOT NULL,
  `secret` varchar(100) NOT NULL,
  `issued` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `themes`
--

CREATE TABLE `themes` (
  `url` varchar(20) NOT NULL,
  `title` varchar(101) NOT NULL,
  `description` varchar(1100) NOT NULL,
  `category` int NOT NULL,
  `logged_in` int NOT NULL,
  `header` int NOT NULL,
  `chrome` tinyint(1) NOT NULL,
  `firefox` tinyint(1) NOT NULL,
  `edge` tinyint(1) NOT NULL,
  `internet` tinyint(1) NOT NULL,
  `opera` tinyint(1) NOT NULL,
  `owner` varchar(20) NOT NULL,
  `upload_date` datetime NOT NULL,
  `installs` int NOT NULL,
  `accepted` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `uploads`
--

CREATE TABLE `uploads` (
  `url` varchar(11) NOT NULL,
  `type` tinyint(1) NOT NULL COMMENT '0 = Upload, 1 = Change',
  `user` varchar(50) NOT NULL,
  `filesize` int NOT NULL,
  `filetype` varchar(50) NOT NULL,
  `modified` varchar(50) NOT NULL,
  `token` varchar(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int NOT NULL,
  `username` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `displayname` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `email` varchar(128) NOT NULL,
  `password` varchar(64) NOT NULL,
  `reg_date` datetime NOT NULL,
  `last_login` datetime NOT NULL,
  `strikes` tinyint(1) NOT NULL DEFAULT '0',
  `videos_watched` int NOT NULL DEFAULT '0',
  `channel_views` int NOT NULL DEFAULT '0',
  `channel_comments` int NOT NULL DEFAULT '0',
  `video_views` int NOT NULL DEFAULT '0',
  `videos` int NOT NULL DEFAULT '0',
  `favorites` int NOT NULL DEFAULT '0',
  `subscribers` int NOT NULL DEFAULT '0',
  `subscriptions` int NOT NULL DEFAULT '0',
  `friends` int NOT NULL DEFAULT '0',
  `birthday` date NOT NULL,
  `country` varchar(5) NOT NULL DEFAULT '',
  `website` varchar(128) NOT NULL DEFAULT '',
  `about` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `avatar` mediumblob,
  `cover` mediumblob,
  `bg_version` int NOT NULL DEFAULT '1',
  `banner_version` int NOT NULL DEFAULT '1',
  `channel_type` int NOT NULL DEFAULT '0',
  `banned` tinyint(1) NOT NULL DEFAULT '0',
  `privacy` tinyint(1) NOT NULL DEFAULT '0' COMMENT '#0 = Public #1 = Unlisted #2 = Friends',
  `ban_reasons` varchar(50) NOT NULL DEFAULT '',
  `1st_latest_ip` varchar(128) NOT NULL,
  `2nd_latest_ip` varchar(128) NOT NULL DEFAULT '',
  `last_username_update` int NOT NULL DEFAULT '0',
  `bg` varchar(6) NOT NULL DEFAULT 'ffffff',
  `chn_radius` int NOT NULL DEFAULT '0',
  `avt_radius` int DEFAULT '0',
  `nav` varchar(6) NOT NULL DEFAULT '89857F',
  `h_head` varchar(6) NOT NULL DEFAULT '666666',
  `h_head_fnt` varchar(6) NOT NULL DEFAULT 'ffffff',
  `h_in` varchar(6) NOT NULL DEFAULT 'eeeeee',
  `h_in_fnt` varchar(6) NOT NULL DEFAULT '6d6d6d',
  `n_head` varchar(6) NOT NULL DEFAULT '666666',
  `n_head_fnt` varchar(6) NOT NULL DEFAULT 'ffffff',
  `n_in` varchar(6) NOT NULL DEFAULT 'ffffff',
  `n_in_fnt` varchar(6) NOT NULL DEFAULT '000000',
  `links` varchar(6) NOT NULL DEFAULT '89857F',
  `font` int NOT NULL DEFAULT '0',
  `b_avatar` varchar(7) NOT NULL DEFAULT '999999',
  `connect` varchar(32) NOT NULL DEFAULT '',
  `c_subscriber` tinyint(1) NOT NULL DEFAULT '1',
  `c_subscription` tinyint(1) NOT NULL DEFAULT '1',
  `c_friend` tinyint(1) NOT NULL DEFAULT '1',
  `c_featured` tinyint(1) NOT NULL DEFAULT '1',
  `featured_n_url` varchar(32) NOT NULL DEFAULT '',
  `featured_s_url` varchar(32) NOT NULL DEFAULT '',
  `snow` tinyint(1) NOT NULL DEFAULT '0',
  `mondo` tinyint(1) NOT NULL DEFAULT '0',
  `c_videos` tinyint(1) NOT NULL DEFAULT '1',
  `c_favorites` tinyint(1) NOT NULL DEFAULT '1',
  `c_comments` tinyint(1) NOT NULL DEFAULT '1',
  `c_featured_playlists` tinyint(1) NOT NULL DEFAULT '0',
  `c_featured_channels` tinyint(1) NOT NULL DEFAULT '0',
  `c_recent` tinyint(1) NOT NULL DEFAULT '1',
  `c_playlists` tinyint(1) NOT NULL DEFAULT '0',
  `playlists` varchar(256) NOT NULL DEFAULT '',
  `featured_channels` varchar(256) NOT NULL DEFAULT '',
  `bg_position` int NOT NULL DEFAULT '0',
  `bg_repeat` int DEFAULT '0',
  `bg_fixed` int NOT NULL DEFAULT '0',
  `bg_stretch` int NOT NULL DEFAULT '0',
  `h_trans` int NOT NULL DEFAULT '0',
  `n_trans` int DEFAULT '0',
  `channel_title` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `channel_description` varchar(2500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `channel_tags` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `i_name` varchar(128) DEFAULT '',
  `i_occupation` varchar(128) NOT NULL DEFAULT '',
  `i_schools` varchar(128) NOT NULL DEFAULT '',
  `i_interests` varchar(128) NOT NULL DEFAULT '',
  `i_movies` varchar(128) NOT NULL DEFAULT '',
  `i_music` varchar(128) NOT NULL DEFAULT '',
  `i_books` varchar(128) NOT NULL DEFAULT '',
  `a_name` tinyint(1) NOT NULL DEFAULT '1',
  `a_website` tinyint(1) NOT NULL DEFAULT '1',
  `a_description` tinyint(1) NOT NULL DEFAULT '1',
  `a_occupation` tinyint(1) NOT NULL DEFAULT '1',
  `a_schools` tinyint(1) NOT NULL DEFAULT '1',
  `a_interests` tinyint(1) NOT NULL DEFAULT '1',
  `a_movies` tinyint(1) NOT NULL DEFAULT '1',
  `a_music` tinyint(1) NOT NULL DEFAULT '1',
  `a_books` tinyint(1) DEFAULT '1',
  `a_last` tinyint(1) NOT NULL DEFAULT '1',
  `a_reg` tinyint(1) NOT NULL DEFAULT '1',
  `a_subs` tinyint(1) NOT NULL DEFAULT '1',
  `a_subs2` tinyint(1) NOT NULL DEFAULT '0',
  `a_country` tinyint(1) NOT NULL DEFAULT '1',
  `a_age` tinyint(1) NOT NULL DEFAULT '1',
  `ra_comments` tinyint(1) NOT NULL DEFAULT '1',
  `ra_favorites` tinyint(1) DEFAULT '1',
  `ra_friends` tinyint(1) NOT NULL DEFAULT '1',
  `activated` tinyint(1) NOT NULL DEFAULT '1',
  `channel_comment_privacy` tinyint(1) NOT NULL DEFAULT '0',
  `can_friend` tinyint(1) NOT NULL DEFAULT '1',
  `can_mention` tinyint(1) NOT NULL DEFAULT '1',
  `can_message` tinyint(1) NOT NULL DEFAULT '1',
  `featured_title` varchar(64) NOT NULL DEFAULT '',
  `theme` int NOT NULL DEFAULT '0',
  `default_view` tinyint(1) NOT NULL DEFAULT '0',
  `c_all` tinyint(1) NOT NULL DEFAULT '1',
  `channel_version` int NOT NULL DEFAULT '1',
  `subscriber_d` tinyint(1) NOT NULL DEFAULT '0',
  `subscription_d` tinyint(1) NOT NULL DEFAULT '0',
  `friends_d` tinyint(1) NOT NULL DEFAULT '0',
  `featured_d` tinyint(1) NOT NULL DEFAULT '1',
  `channel_d` tinyint(1) NOT NULL DEFAULT '1',
  `recent_d` tinyint(1) NOT NULL DEFAULT '1',
  `c_custom` tinyint(1) NOT NULL DEFAULT '0',
  `custom_d` tinyint(1) NOT NULL DEFAULT '1',
  `modules_vertical_r` varchar(24) NOT NULL DEFAULT 'cu,re,ft,s2,s1,fr,co',
  `modules_vertical_l` varchar(24) NOT NULL DEFAULT 'cu,re,ft,s2,s1,fr,co',
  `custom` varchar(1024) NOT NULL DEFAULT '',
  `partner` tinyint(1) NOT NULL DEFAULT '0',
  `nouveau` tinyint(1) NOT NULL DEFAULT '0',
  `is_admin` tinyint(1) NOT NULL DEFAULT '0',
  `is_mod` tinyint(1) NOT NULL DEFAULT '0',
  `shadowbanned` tinyint(1) NOT NULL DEFAULT '0',
  `adsense` varchar(100) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `users_block`
--

CREATE TABLE `users_block` (
  `blocker` varchar(20) NOT NULL,
  `blocked` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `users_oldnames`
--

CREATE TABLE `users_oldnames` (
  `displayname` varchar(20) NOT NULL,
  `username` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `users_remembers`
--

CREATE TABLE `users_remembers` (
  `uid` varchar(20) NOT NULL,
  `code` varchar(32) NOT NULL,
  `browser` varchar(16) NOT NULL,
  `last_login` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `videos`
--

CREATE TABLE `videos` (
  `url` varchar(11) NOT NULL,
  `file` varchar(80) NOT NULL,
  `hd` tinyint(1) NOT NULL,
  `title` varchar(100) NOT NULL,
  `description` varchar(1000) NOT NULL DEFAULT '',
  `tags` varchar(250) NOT NULL DEFAULT '',
  `category` int NOT NULL DEFAULT '1',
  `privacy` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0 = Pub, 1 = Pri, 2 = Unli',
  `uploaded_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `uploaded_on` datetime NOT NULL,
  `thumbnail` mediumblob,
  `views` int NOT NULL DEFAULT '0',
  `displayviews` int NOT NULL DEFAULT '0',
  `watched` mediumint NOT NULL DEFAULT '0',
  `comments` int NOT NULL DEFAULT '0',
  `responses` int NOT NULL DEFAULT '0',
  `favorites` int NOT NULL DEFAULT '0',
  `1_star` int NOT NULL DEFAULT '0',
  `2_star` int NOT NULL DEFAULT '0',
  `3_star` int NOT NULL DEFAULT '0',
  `4_star` int NOT NULL DEFAULT '0',
  `5_star` int NOT NULL DEFAULT '0',
  `length` int NOT NULL DEFAULT '0',
  `s_comments` tinyint(1) NOT NULL DEFAULT '1',
  `s_ratings` tinyint(1) NOT NULL DEFAULT '1',
  `s_responses` tinyint(1) NOT NULL DEFAULT '1',
  `s_related` tinyint(1) NOT NULL DEFAULT '1',
  `featured` tinyint(1) NOT NULL DEFAULT '0',
  `frontpage` tinyint(1) NOT NULL DEFAULT '0',
  `most_popular` tinyint(1) NOT NULL DEFAULT '1',
  `banned_uploader` tinyint(1) NOT NULL DEFAULT '0',
  `shadowbanned_uploader` tinyint(1) NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `thumbs` tinyint(1) NOT NULL DEFAULT '-1',
  `show_ads` tinyint(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `videos_deleted`
--

CREATE TABLE `videos_deleted` (
  `id` varchar(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `videos_flags`
--

CREATE TABLE `videos_flags` (
  `url` varchar(11) NOT NULL,
  `by_user` varchar(20) NOT NULL,
  `reason` int NOT NULL,
  `submit_on` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `videos_schedule`
--

CREATE TABLE `videos_schedule` (
  `id` varchar(11) NOT NULL,
  `date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `videos_views`
--

CREATE TABLE `videos_views` (
  `vid` varchar(11) NOT NULL,
  `views` smallint NOT NULL,
  `submit_date` date NOT NULL DEFAULT '0000-00-00',
  `source` varchar(64) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `videos_watched`
--

CREATE TABLE `videos_watched` (
  `vid` varchar(11) NOT NULL,
  `watchtime` mediumint NOT NULL,
  `submit_date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `video_comments`
--

CREATE TABLE `video_comments` (
  `id` int NOT NULL,
  `url` varchar(11) NOT NULL,
  `comment` mediumtext NOT NULL,
  `by_user` varchar(20) NOT NULL,
  `date_sent` datetime NOT NULL,
  `rating` int NOT NULL DEFAULT '0',
  `has_replies` tinyint(1) NOT NULL DEFAULT '0',
  `reply_to` int NOT NULL DEFAULT '0',
  `seen` tinyint(1) NOT NULL DEFAULT '0',
  `raters` varchar(10000) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `video_favorites`
--

CREATE TABLE `video_favorites` (
  `url` varchar(11) NOT NULL,
  `favorite_by` varchar(20) NOT NULL,
  `date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `video_ratings`
--

CREATE TABLE `video_ratings` (
  `url` varchar(11) NOT NULL,
  `user_rated` varchar(20) NOT NULL,
  `stars` tinyint(1) NOT NULL,
  `submit_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `video_responses`
--

CREATE TABLE `video_responses` (
  `id` int NOT NULL,
  `url` varchar(11) NOT NULL,
  `url_response` varchar(11) NOT NULL,
  `date` datetime NOT NULL,
  `seen` tinyint(1) NOT NULL DEFAULT '0',
  `accepted` tinyint(1) NOT NULL DEFAULT '0',
  `response_user` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `wrong_logins`
--

CREATE TABLE `wrong_logins` (
  `ip` varchar(128) NOT NULL,
  `submit_date` datetime NOT NULL,
  `channel` varchar(32) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `achievement_text`
--
ALTER TABLE `achievement_text`
  ADD PRIMARY KEY (`name`);

--
-- Indexes for table `achievement_users`
--
ALTER TABLE `achievement_users`
  ADD UNIQUE KEY `username` (`username`,`name`),
  ADD KEY `username_2` (`username`),
  ADD KEY `type` (`type`);

--
-- Indexes for table `activations`
--
ALTER TABLE `activations`
  ADD PRIMARY KEY (`username`);

--
-- Indexes for table `applications`
--
ALTER TABLE `applications`
  ADD PRIMARY KEY (`username`);

--
-- Indexes for table `badboys`
--
ALTER TABLE `badboys`
  ADD UNIQUE KEY `ip` (`ip`,`submit_date`);

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

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

--
-- Indexes for table `bulletins`
--
ALTER TABLE `bulletins`
  ADD PRIMARY KEY (`id`),
  ADD KEY `by_user` (`by_user`);

--
-- Indexes for table `channel_banners`
--
ALTER TABLE `channel_banners`
  ADD PRIMARY KEY (`username`);

--
-- Indexes for table `channel_comments`
--
ALTER TABLE `channel_comments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `on_channel` (`on_channel`);

--
-- Indexes for table `contest_entries`
--
ALTER TABLE `contest_entries`
  ADD PRIMARY KEY (`url`);

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

--
-- Indexes for table `converting`
--
ALTER TABLE `converting`
  ADD PRIMARY KEY (`url`),
  ADD KEY `uploaded_on` (`uploaded_on`);

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

--
-- Indexes for table `forgot_password`
--
ALTER TABLE `forgot_password`
  ADD PRIMARY KEY (`username`);

--
-- Indexes for table `friends`
--
ALTER TABLE `friends`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `friend_1` (`friend_1`,`friend_2`),
  ADD KEY `friend_1_2` (`friend_1`),
  ADD KEY `friend_2` (`friend_2`),
  ADD KEY `sent_on` (`sent_on`),
  ADD KEY `friend_1_3` (`friend_1`,`friend_2`,`status`);

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

--
-- Indexes for table `iprange_bans`
--
ALTER TABLE `iprange_bans`
  ADD PRIMARY KEY (`bid`);

--
-- Indexes for table `mentions`
--
ALTER TABLE `mentions`
  ADD UNIQUE KEY `comment` (`video`,`username`),
  ADD UNIQUE KEY `channel` (`channel`,`username`);

--
-- Indexes for table `most_subscribed_month`
--
ALTER TABLE `most_subscribed_month`
  ADD PRIMARY KEY (`username`);

--
-- Indexes for table `most_subscribed_week`
--
ALTER TABLE `most_subscribed_week`
  ADD PRIMARY KEY (`username`);

--
-- Indexes for table `most_viewed_month`
--
ALTER TABLE `most_viewed_month`
  ADD PRIMARY KEY (`username`);

--
-- Indexes for table `most_viewed_week`
--
ALTER TABLE `most_viewed_week`
  ADD PRIMARY KEY (`username`);

--
-- Indexes for table `options`
--
ALTER TABLE `options`
  ADD PRIMARY KEY (`option_name`);

--
-- Indexes for table `playlists`
--
ALTER TABLE `playlists`
  ADD PRIMARY KEY (`purl`),
  ADD UNIQUE KEY `title` (`title`,`created_by`);

--
-- Indexes for table `playlists_videos`
--
ALTER TABLE `playlists_videos`
  ADD UNIQUE KEY `url` (`url`,`purl`);

--
-- Indexes for table `private_messages`
--
ALTER TABLE `private_messages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `from_user` (`from_user`),
  ADD KEY `to_user` (`to_user`),
  ADD KEY `seen` (`seen`);

--
-- Indexes for table `recently_viewed`
--
ALTER TABLE `recently_viewed`
  ADD PRIMARY KEY (`url`);

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

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

--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`name`);

--
-- Indexes for table `strikes`
--
ALTER TABLE `strikes`
  ADD KEY `issued_by` (`issued_by`),
  ADD KEY `username` (`username`);

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

--
-- Indexes for table `terminations`
--
ALTER TABLE `terminations`
  ADD PRIMARY KEY (`username`);

--
-- Indexes for table `themes`
--
ALTER TABLE `themes`
  ADD PRIMARY KEY (`url`);
ALTER TABLE `themes` ADD FULLTEXT KEY `title` (`title`,`description`);

--
-- Indexes for table `uploads`
--
ALTER TABLE `uploads`
  ADD PRIMARY KEY (`url`),
  ADD KEY `size` (`filesize`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD KEY `displayname` (`displayname`),
  ADD KEY `shadowbanned` (`shadowbanned`),
  ADD KEY `username` (`username`);

--
-- Indexes for table `users_block`
--
ALTER TABLE `users_block`
  ADD KEY `blocker` (`blocker`),
  ADD KEY `blocked` (`blocked`);

--
-- Indexes for table `videos`
--
ALTER TABLE `videos`
  ADD PRIMARY KEY (`url`),
  ADD KEY `uploaded_by` (`uploaded_by`),
  ADD KEY `featured` (`featured`),
  ADD KEY `uploaded_on` (`uploaded_on`),
  ADD KEY `privacy` (`privacy`,`banned_uploader`,`shadowbanned_uploader`,`status`);
ALTER TABLE `videos` ADD FULLTEXT KEY `FullText` (`title`,`description`,`tags`);
ALTER TABLE `videos` ADD FULLTEXT KEY `FullText2` (`title`,`description`);
ALTER TABLE `videos` ADD FULLTEXT KEY `title` (`title`);

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

--
-- Indexes for table `videos_flags`
--
ALTER TABLE `videos_flags`
  ADD UNIQUE KEY `url` (`url`,`by_user`);

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

--
-- Indexes for table `videos_views`
--
ALTER TABLE `videos_views`
  ADD UNIQUE KEY `vid` (`vid`,`submit_date`,`source`),
  ADD KEY `views` (`views`);

--
-- Indexes for table `videos_watched`
--
ALTER TABLE `videos_watched`
  ADD UNIQUE KEY `vid` (`vid`,`submit_date`),
  ADD KEY `watchtime` (`watchtime`);

--
-- Indexes for table `video_comments`
--
ALTER TABLE `video_comments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `url` (`url`),
  ADD KEY `reply_to` (`reply_to`),
  ADD KEY `seen` (`seen`),
  ADD KEY `date_sent` (`date_sent`),
  ADD KEY `by_user` (`by_user`),
  ADD KEY `rating` (`rating`);

--
-- Indexes for table `video_favorites`
--
ALTER TABLE `video_favorites`
  ADD UNIQUE KEY `url` (`url`,`favorite_by`),
  ADD KEY `date` (`date`),
  ADD KEY `favorite_by` (`favorite_by`);

--
-- Indexes for table `video_ratings`
--
ALTER TABLE `video_ratings`
  ADD UNIQUE KEY `url` (`url`,`user_rated`);

--
-- Indexes for table `video_responses`
--
ALTER TABLE `video_responses`
  ADD PRIMARY KEY (`id`),
  ADD KEY `url` (`url`,`accepted`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `ban_reasons`
--
ALTER TABLE `ban_reasons`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `blog`
--
ALTER TABLE `blog`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bulletins`
--
ALTER TABLE `bulletins`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `channel_comments`
--
ALTER TABLE `channel_comments`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `feature_suggestions`
--
ALTER TABLE `feature_suggestions`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `friends`
--
ALTER TABLE `friends`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `help`
--
ALTER TABLE `help`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `iprange_bans`
--
ALTER TABLE `iprange_bans`
  MODIFY `bid` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `private_messages`
--
ALTER TABLE `private_messages`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `reports`
--
ALTER TABLE `reports`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sessions`
--
ALTER TABLE `sessions`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `subscriptions`
--
ALTER TABLE `subscriptions`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `video_comments`
--
ALTER TABLE `video_comments`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `video_responses`
--
ALTER TABLE `video_responses`
  MODIFY `id` int 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 */;