-- phpMyAdmin SQL Dump
-- version 5.1.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jan 19, 2026 at 01:57 AM
-- Server version: 10.4.21-MariaDB
-- PHP Version: 7.4.25

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

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

--
-- Table structure for table `academy_class`
--

CREATE TABLE `academy_class` (
  `id` int(255) NOT NULL,
  `slug` varchar(100) NOT NULL,
  `position` int(15) NOT NULL DEFAULT 1,
  `type` varchar(15) NOT NULL COMMENT 'general, one-on-one',
  `category_data_id` int(2) NOT NULL,
  `users_id` int(255) NOT NULL COMMENT 'user untuk menampung dana yang masuk',
  `name` varchar(50) NOT NULL,
  `cover` varchar(100) NOT NULL DEFAULT '',
  `banner` varchar(100) NOT NULL DEFAULT '',
  `description` varchar(10000) NOT NULL,
  `register_info` varchar(1000) NOT NULL DEFAULT '',
  `level` char(7) NOT NULL COMMENT 'NONE, BEGIN, INTER, ADVAN',
  `certificate` tinyint(1) NOT NULL DEFAULT 0,
  `mandatory_info` varchar(250) NOT NULL DEFAULT '',
  `schedule_info` varchar(250) NOT NULL DEFAULT '',
  `price` int(30) NOT NULL DEFAULT 0,
  `price_before` varchar(30) NOT NULL DEFAULT '',
  `discount_percent` varchar(20) NOT NULL DEFAULT '',
  `price_half_info` varchar(100) NOT NULL DEFAULT '',
  `limit_member` int(10) NOT NULL DEFAULT 0,
  `status` char(10) NOT NULL DEFAULT 'REGIST' COMMENT 'REGIST, RUNNING, ENDED',
  `tab_ask` tinyint(1) NOT NULL DEFAULT 0 COMMENT '0: member, 1: public, -1: hidden',
  `tab_member` tinyint(1) NOT NULL DEFAULT 0 COMMENT '0: member, 1: public, -1: hidden',
  `lock_ask` tinyint(1) NOT NULL DEFAULT 0,
  `lock_answer` tinyint(1) NOT NULL DEFAULT 0,
  `count_member` int(10) NOT NULL DEFAULT 0,
  `count_ask` int(25) NOT NULL DEFAULT 0,
  `is_half_join` tinyint(1) NOT NULL DEFAULT 0,
  `is_certif_give` tinyint(1) NOT NULL DEFAULT 0,
  `certificate_id` int(20) NOT NULL DEFAULT 0,
  `is_open` tinyint(1) NOT NULL DEFAULT 0,
  `is_listed` tinyint(1) NOT NULL DEFAULT 1,
  `is_show` tinyint(1) NOT NULL DEFAULT 0,
  `date_regist_start` varchar(20) NOT NULL DEFAULT '',
  `date_regist_end` varchar(20) NOT NULL DEFAULT '',
  `date_start` varchar(20) NOT NULL,
  `date_end` varchar(20) NOT NULL,
  `date_start_code` bigint(14) NOT NULL DEFAULT 0,
  `date_end_code` bigint(14) NOT NULL DEFAULT 0,
  `date_publish` varchar(20) NOT NULL,
  `date_update` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `academy_class_ask`
--

CREATE TABLE `academy_class_ask` (
  `id` int(255) NOT NULL,
  `class_id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `content` varchar(10000) NOT NULL,
  `date_publish` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `academy_class_ask_answer`
--

CREATE TABLE `academy_class_ask_answer` (
  `id` int(255) NOT NULL,
  `ask_id` int(255) NOT NULL,
  `class_id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `content` varchar(2000) NOT NULL,
  `date_publish` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `academy_class_faq`
--

CREATE TABLE `academy_class_faq` (
  `id` int(255) NOT NULL,
  `class_id` int(255) NOT NULL,
  `ask` varchar(100) NOT NULL,
  `answer` varchar(500) NOT NULL,
  `position` tinyint(2) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `academy_class_file`
--

CREATE TABLE `academy_class_file` (
  `id` int(255) NOT NULL,
  `class_id` int(255) NOT NULL,
  `position` int(10) NOT NULL DEFAULT 1,
  `title` varchar(150) NOT NULL,
  `count_file` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `academy_class_file_content`
--

CREATE TABLE `academy_class_file_content` (
  `id` int(255) NOT NULL,
  `topic_id` int(255) NOT NULL,
  `schedule_id` int(255) NOT NULL DEFAULT 0,
  `position` int(10) NOT NULL DEFAULT 1,
  `users_id` int(255) NOT NULL,
  `title` varchar(200) NOT NULL,
  `password` varchar(100) NOT NULL DEFAULT '',
  `url` varchar(250) NOT NULL,
  `date_publish` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `academy_class_member`
--

CREATE TABLE `academy_class_member` (
  `id` int(255) NOT NULL,
  `class_id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `show_import_schedule` int(1) NOT NULL DEFAULT 1,
  `status` char(7) NOT NULL DEFAULT 'WAITING' COMMENT 'WAITING, JOINED',
  `joined_invoice_id` char(255) NOT NULL DEFAULT '',
  `joined_type` char(4) NOT NULL DEFAULT 'FULL' COMMENT 'FULL,HALF',
  `is_banned` int(1) NOT NULL DEFAULT 0,
  `date_publish` varchar(20) NOT NULL,
  `date_update` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `academy_class_member_schedule`
--

CREATE TABLE `academy_class_member_schedule` (
  `id` int(255) NOT NULL,
  `class_id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `schedule_id` int(255) NOT NULL,
  `is_paid` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `academy_class_mentor`
--

CREATE TABLE `academy_class_mentor` (
  `id` int(255) NOT NULL,
  `class_id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `academy_class_record`
--

CREATE TABLE `academy_class_record` (
  `id` int(100) NOT NULL,
  `class_id` int(255) NOT NULL,
  `schedule_id` int(255) NOT NULL DEFAULT 0,
  `position` int(5) NOT NULL DEFAULT 0,
  `title` varchar(150) NOT NULL,
  `file` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `academy_class_review`
--

CREATE TABLE `academy_class_review` (
  `id` int(255) NOT NULL,
  `class_id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `review` mediumtext NOT NULL,
  `date_publish` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `academy_class_room`
--

CREATE TABLE `academy_class_room` (
  `id` int(255) NOT NULL,
  `class_id` int(255) NOT NULL,
  `teacher_id` int(255) DEFAULT NULL,
  `platform_type` varchar(10) NOT NULL COMMENT 'zoom, gmeet',
  `platform_url` varchar(100) NOT NULL DEFAULT '',
  `info` varchar(1000) NOT NULL,
  `count_meet` int(3) NOT NULL DEFAULT 0,
  `is_show` int(1) NOT NULL DEFAULT 0,
  `date_start` varchar(20) NOT NULL,
  `date_end` varchar(20) NOT NULL,
  `date_publish` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `academy_class_schedule`
--

CREATE TABLE `academy_class_schedule` (
  `id` int(50) NOT NULL,
  `class_id` int(255) NOT NULL,
  `position` int(10) NOT NULL,
  `users_id` int(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `live_type` char(8) NOT NULL COMMENT '[KOSONGKAN], INTERNAL, URL',
  `live_data` varchar(250) NOT NULL DEFAULT '',
  `note` varchar(250) NOT NULL DEFAULT '',
  `is_part` tinyint(1) NOT NULL DEFAULT 0,
  `price` int(10) NOT NULL DEFAULT 0,
  `price_special` int(10) NOT NULL DEFAULT 0,
  `date_start` char(10) NOT NULL,
  `date_part_info` varchar(100) NOT NULL DEFAULT '' COMMENT 'di isi dengan text apabila is_part = 1',
  `time_start` char(5) NOT NULL,
  `time_end` char(5) NOT NULL,
  `status` char(10) NOT NULL DEFAULT '' COMMENT '[KOSONGKAN], RUNNING, ENDED',
  `date_order` bigint(15) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `academy_class_schedule_member`
--

CREATE TABLE `academy_class_schedule_member` (
  `id` int(255) NOT NULL,
  `class_id` int(255) NOT NULL,
  `schedule_id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `is_joined` int(1) NOT NULL DEFAULT 0,
  `count_reminder_notif` int(2) NOT NULL DEFAULT 0,
  `count_reminder_email` int(2) NOT NULL DEFAULT 0,
  `count_reminder_push` int(2) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `academy_class_schedule_part`
--

CREATE TABLE `academy_class_schedule_part` (
  `id` int(50) NOT NULL,
  `schedule_id` int(50) NOT NULL,
  `name` varchar(150) NOT NULL,
  `live_type` char(8) NOT NULL COMMENT 'OFFLINE',
  `live_data` varchar(150) NOT NULL DEFAULT '',
  `date_start` char(10) NOT NULL,
  `time_start` char(5) NOT NULL,
  `time_end` char(5) NOT NULL,
  `status` char(10) NOT NULL DEFAULT '' COMMENT '[KOSONGKAN], RUNNING, ENDED'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `academy_mentor`
--

CREATE TABLE `academy_mentor` (
  `id` int(10) NOT NULL,
  `users_id` int(255) NOT NULL,
  `cover` varchar(50) NOT NULL,
  `realname` varchar(100) NOT NULL DEFAULT '',
  `bio` varchar(500) NOT NULL DEFAULT '',
  `is_active` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `achievement`
--

CREATE TABLE `achievement` (
  `id` int(255) NOT NULL,
  `title` varchar(100) NOT NULL,
  `description` varchar(500) NOT NULL,
  `on_level` int(1) NOT NULL DEFAULT 1,
  `level_1` int(5) NOT NULL DEFAULT 0,
  `level_2` int(5) NOT NULL DEFAULT 0,
  `level_3` int(5) NOT NULL DEFAULT 0,
  `level_4` int(5) NOT NULL DEFAULT 0,
  `level_5` int(5) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `achievement_work`
--

CREATE TABLE `achievement_work` (
  `id` int(255) NOT NULL,
  `category` int(2) NOT NULL,
  `img` varchar(100) NOT NULL,
  `title` varchar(100) NOT NULL,
  `info` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `admin_banned_ip`
--

CREATE TABLE `admin_banned_ip` (
  `id` int(20) NOT NULL,
  `ip_address` char(25) NOT NULL,
  `date_expired` char(8) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `admin_banned_users`
--

CREATE TABLE `admin_banned_users` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `info` varchar(10000) NOT NULL DEFAULT '',
  `date_publish` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `admin_banned_word`
--

CREATE TABLE `admin_banned_word` (
  `id` int(50) NOT NULL,
  `word` varchar(50) NOT NULL,
  `count` int(5) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `admin_banned_word_users`
--

CREATE TABLE `admin_banned_word_users` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `banned_word_id` int(50) NOT NULL,
  `count` int(10) NOT NULL DEFAULT 0,
  `is_suspect` tinyint(1) NOT NULL DEFAULT 0,
  `date_yw` char(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `admin_banned_word_users_history`
--

CREATE TABLE `admin_banned_word_users_history` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `banned_word_users_id` int(255) NOT NULL,
  `banned_word_id` int(50) NOT NULL,
  `content_type` char(7) NOT NULL COMMENT 'STATUS, STSCOM, NOVCOM, WTCOM, SCRCOM, FLSCOM, SHRCOM, PTRCOM',
  `content_id` int(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `admin_comparison_script_part`
--

CREATE TABLE `admin_comparison_script_part` (
  `id` int(255) NOT NULL,
  `part_id` int(255) NOT NULL,
  `content` mediumtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `admin_competition_selection`
--

CREATE TABLE `admin_competition_selection` (
  `id` int(255) NOT NULL,
  `competition_id` int(255) NOT NULL,
  `content_type` char(5) NOT NULL,
  `content_id` int(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `admin_competition_selection_curator`
--

CREATE TABLE `admin_competition_selection_curator` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `cs_id` int(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `admin_curator_curation_history`
--

CREATE TABLE `admin_curator_curation_history` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `content_data_id` int(255) NOT NULL,
  `part_id` int(255) NOT NULL,
  `date_ymd` char(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `admin_curator_curation_timeline`
--

CREATE TABLE `admin_curator_curation_timeline` (
  `id` int(100) NOT NULL,
  `users_id` int(255) NOT NULL,
  `content_data_id` int(255) NOT NULL,
  `part_id` int(255) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `date_publish` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `admin_curator_curation_total`
--

CREATE TABLE `admin_curator_curation_total` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `count_novel` int(50) NOT NULL DEFAULT 0,
  `count_novel_chapter` int(50) NOT NULL DEFAULT 0,
  `count_script` int(50) NOT NULL DEFAULT 0,
  `count_script_part` int(50) NOT NULL DEFAULT 0,
  `count_comic` int(50) NOT NULL DEFAULT 0,
  `count_comic_episode` int(50) NOT NULL DEFAULT 0,
  `count_flash` int(50) NOT NULL DEFAULT 0,
  `count_short` int(50) NOT NULL DEFAULT 0,
  `count_poetry` int(50) NOT NULL DEFAULT 0,
  `date_ym` char(7) NOT NULL,
  `date_ymd` char(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `admin_director_content`
--

CREATE TABLE `admin_director_content` (
  `id` int(255) NOT NULL,
  `content_type` char(5) NOT NULL,
  `content_id` int(255) NOT NULL,
  `premis` varchar(5000) NOT NULL DEFAULT '',
  `tokoh` mediumtext NOT NULL,
  `sinopsis` mediumtext NOT NULL,
  `point_trending` int(255) NOT NULL DEFAULT 0,
  `date_order` bigint(15) NOT NULL,
  `date_publish` varchar(20) NOT NULL,
  `date_update` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `admin_director_content_pinned`
--

CREATE TABLE `admin_director_content_pinned` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `content_type` char(5) NOT NULL,
  `content_id` int(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `admin_event_director_select`
--

CREATE TABLE `admin_event_director_select` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `type` int(1) NOT NULL,
  `event_content_id` int(255) NOT NULL,
  `date_update` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `admin_grant`
--

CREATE TABLE `admin_grant` (
  `id` int(255) NOT NULL,
  `title` char(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `admin_jury_content`
--

CREATE TABLE `admin_jury_content` (
  `id` int(255) NOT NULL,
  `competition_id` int(15) NOT NULL DEFAULT 0,
  `content_data_id` int(255) NOT NULL,
  `genre` varchar(200) NOT NULL,
  `summary` text NOT NULL,
  `notes` text NOT NULL,
  `is_show` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `admin_jury_content_pinned`
--

CREATE TABLE `admin_jury_content_pinned` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `competition_id` int(10) NOT NULL DEFAULT 0,
  `jury_content_id` int(255) NOT NULL,
  `score1` int(10) NOT NULL DEFAULT 0,
  `score2` int(10) NOT NULL DEFAULT 0,
  `score3` int(10) NOT NULL DEFAULT 0,
  `notes` varchar(3000) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `admin_mentor_content`
--

CREATE TABLE `admin_mentor_content` (
  `id` int(255) NOT NULL,
  `content_type` char(5) NOT NULL,
  `content_id` int(255) NOT NULL,
  `genre` varchar(200) NOT NULL,
  `summary` text NOT NULL,
  `notes` text NOT NULL,
  `selected_by` varchar(100) NOT NULL DEFAULT '',
  `mark` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `admin_mentor_content_pinned`
--

CREATE TABLE `admin_mentor_content_pinned` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `content_id` int(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `admin_privateuser_content`
--

CREATE TABLE `admin_privateuser_content` (
  `id` int(50) NOT NULL,
  `users_id` int(255) NOT NULL,
  `content_type` char(5) NOT NULL,
  `content_id` int(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `admin_push`
--

CREATE TABLE `admin_push` (
  `id` int(255) NOT NULL,
  `banner` varchar(100) NOT NULL DEFAULT '',
  `title` varchar(100) NOT NULL,
  `info` varchar(150) NOT NULL,
  `content_type` char(6) NOT NULL,
  `content_data` varchar(100) NOT NULL,
  `status` int(1) NOT NULL DEFAULT 0,
  `date_publish` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `admin_push_users`
--

CREATE TABLE `admin_push_users` (
  `id` int(255) NOT NULL,
  `admin_notif_id` int(255) NOT NULL,
  `login_token_id` int(255) NOT NULL,
  `date_ymd` char(8) NOT NULL,
  `date_publish` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `admin_submit`
--

CREATE TABLE `admin_submit` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `users_id_curator` int(255) NOT NULL DEFAULT 0,
  `content_data_id` int(255) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `is_updatepart` tinyint(1) NOT NULL DEFAULT 0,
  `is_cancel` tinyint(1) NOT NULL DEFAULT 0,
  `date_chat` bigint(15) NOT NULL DEFAULT 0,
  `date_order` bigint(15) NOT NULL,
  `date_order_work` bigint(15) NOT NULL DEFAULT 0,
  `date_order_work_part` bigint(15) NOT NULL DEFAULT 0,
  `date_update` varchar(20) NOT NULL,
  `date_publish` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `admin_submit_change`
--

CREATE TABLE `admin_submit_change` (
  `id` int(255) NOT NULL,
  `content_data_id` int(255) NOT NULL,
  `code` varchar(15) NOT NULL,
  `content` mediumtext NOT NULL,
  `is_decline` tinyint(1) NOT NULL DEFAULT 0,
  `is_creator_read` tinyint(1) NOT NULL DEFAULT 0,
  `curator_revision` mediumtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `admin_submit_history`
--

CREATE TABLE `admin_submit_history` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `content_data_id` int(255) NOT NULL,
  `part_id` int(255) NOT NULL DEFAULT 0,
  `status` tinyint(1) NOT NULL,
  `date_publish` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `admin_submit_revision`
--

CREATE TABLE `admin_submit_revision` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `content_data_id` int(255) NOT NULL,
  `part_id` int(255) NOT NULL DEFAULT 0,
  `type_revision` char(8) NOT NULL COMMENT 'revision, appeal',
  `content` mediumtext NOT NULL,
  `is_read` tinyint(1) NOT NULL DEFAULT 0,
  `date_publish` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `admin_submit_status_approve`
--

CREATE TABLE `admin_submit_status_approve` (
  `id` int(255) NOT NULL,
  `content_data_id` int(255) NOT NULL,
  `part_id` int(255) NOT NULL,
  `date_update` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `admin_submit_work`
--

CREATE TABLE `admin_submit_work` (
  `id` int(255) NOT NULL,
  `content_data_id` int(255) NOT NULL,
  `storyline` mediumtext NOT NULL,
  `count_revision` int(5) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `admin_users`
--

CREATE TABLE `admin_users` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `grant_id` int(255) NOT NULL,
  `grant_level` int(2) NOT NULL DEFAULT 0,
  `data_1` varchar(15) NOT NULL DEFAULT '',
  `free_access` tinyint(1) NOT NULL DEFAULT 0,
  `notif_chat` int(1) NOT NULL DEFAULT 0,
  `is_active` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `admin_users_curator_total`
--

CREATE TABLE `admin_users_curator_total` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `total` int(3) NOT NULL DEFAULT 0,
  `total_novel` int(3) NOT NULL DEFAULT 0,
  `date_ym` varchar(7) NOT NULL,
  `date_ymd` varchar(10) NOT NULL,
  `date_publish` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `admin_users_history_curation`
--

CREATE TABLE `admin_users_history_curation` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `content_type` char(7) NOT NULL,
  `is_path` tinyint(1) NOT NULL DEFAULT 0,
  `count` int(50) NOT NULL,
  `date_y` char(4) NOT NULL,
  `date_ym` char(6) NOT NULL,
  `date_ymd` char(8) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `admin_users_insider`
--

CREATE TABLE `admin_users_insider` (
  `id` int(10) NOT NULL,
  `users_id` int(255) NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  `date_publish` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `admin_work_backup_part`
--

CREATE TABLE `admin_work_backup_part` (
  `id` int(100) NOT NULL,
  `content_data_id` int(255) NOT NULL,
  `part_id` int(255) NOT NULL,
  `content` mediumtext NOT NULL,
  `date_expired` char(8) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `admin_work_history`
--

CREATE TABLE `admin_work_history` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `content_data_id` int(255) NOT NULL,
  `date_order` bigint(14) NOT NULL,
  `date_update` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `admin_work_part_change`
--

CREATE TABLE `admin_work_part_change` (
  `id` int(255) NOT NULL,
  `content_data_id` int(255) NOT NULL,
  `part_id` int(255) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `is_read` tinyint(1) NOT NULL DEFAULT 0,
  `date_update` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `admin_work_part_change_content`
--

CREATE TABLE `admin_work_part_change_content` (
  `id` int(255) NOT NULL,
  `content_data_id` int(255) NOT NULL,
  `part_id` int(255) NOT NULL,
  `code` varchar(15) NOT NULL,
  `content` mediumtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `admin_work_pinned`
--

CREATE TABLE `admin_work_pinned` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `code` varchar(25) NOT NULL DEFAULT 'curator',
  `content_data_id` int(255) NOT NULL,
  `date_order` bigint(15) NOT NULL,
  `date_update` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `admin_work_previous`
--

CREATE TABLE `admin_work_previous` (
  `id` int(255) NOT NULL,
  `content_type` char(7) NOT NULL,
  `content_id` int(255) NOT NULL,
  `part_id` int(255) NOT NULL,
  `content` mediumtext NOT NULL,
  `date_order` bigint(15) NOT NULL,
  `date_update` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `ai_style`
--

CREATE TABLE `ai_style` (
  `id` int(15) NOT NULL,
  `icon` varchar(20) NOT NULL,
  `name` varchar(50) NOT NULL,
  `code` varchar(50) NOT NULL,
  `code_stabilityai` varchar(50) NOT NULL,
  `is_show` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `analytic_visitor_work`
--

CREATE TABLE `analytic_visitor_work` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `content_type` char(7) NOT NULL,
  `content_id` int(255) NOT NULL,
  `count_reach` int(255) NOT NULL DEFAULT 0,
  `count_view` int(255) NOT NULL DEFAULT 0,
  `count_ipuniq` int(255) NOT NULL DEFAULT 0,
  `count_session` int(255) NOT NULL DEFAULT 0,
  `order_ym` int(6) NOT NULL DEFAULT 0,
  `date_ymd` int(8) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `analytic_work_trueread`
--

CREATE TABLE `analytic_work_trueread` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `content_data_id` int(255) NOT NULL,
  `part_id` int(255) NOT NULL,
  `duration` varchar(5) NOT NULL,
  `is_completed` tinyint(1) NOT NULL DEFAULT 0,
  `date_update` varchar(20) NOT NULL,
  `date_publish` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `boost`
--

CREATE TABLE `boost` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `date_order` bigint(15) NOT NULL,
  `date_update` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `boost_content`
--

CREATE TABLE `boost_content` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `content_data_id` int(255) NOT NULL,
  `count_reach` int(100) NOT NULL DEFAULT 0,
  `date_order` bigint(15) NOT NULL DEFAULT 0,
  `date_publish` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `certificate`
--

CREATE TABLE `certificate` (
  `id` int(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `info` varchar(1500) NOT NULL,
  `signature` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `certificate_members`
--

CREATE TABLE `certificate_members` (
  `id` int(255) NOT NULL,
  `certificate_id` int(255) NOT NULL,
  `certificate_number` char(30) NOT NULL,
  `users_id` int(255) NOT NULL,
  `users_realname` varchar(100) NOT NULL DEFAULT '',
  `purpose` varchar(50) NOT NULL DEFAULT '',
  `expired_date` char(10) NOT NULL DEFAULT '',
  `date_issue` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `chat_content`
--

CREATE TABLE `chat_content` (
  `id` int(255) NOT NULL,
  `code` varchar(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `content_type` int(1) NOT NULL,
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `salt` int(7) NOT NULL DEFAULT 0,
  `date_publish` varchar(20) NOT NULL,
  `date_update` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `chat_group`
--

CREATE TABLE `chat_group` (
  `id` int(255) NOT NULL,
  `code` varchar(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `name` varchar(150) NOT NULL,
  `count_users` int(10) NOT NULL DEFAULT 1,
  `date_publish` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `chat_group_connect`
--

CREATE TABLE `chat_group_connect` (
  `id` int(255) NOT NULL,
  `type_connect` char(10) NOT NULL COMMENT 'ACADEMY',
  `chat_group_id` int(255) NOT NULL,
  `connect_id` int(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `chat_users`
--

CREATE TABLE `chat_users` (
  `id` int(255) NOT NULL,
  `code` varchar(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `content_type` int(1) NOT NULL DEFAULT 0 COMMENT '0: private, 1: group',
  `content_id` int(255) NOT NULL DEFAULT 0 COMMENT 'content_type: 0 = users_id, 1 = group_id',
  `status` int(1) NOT NULL DEFAULT 1,
  `date_order` bigint(15) NOT NULL,
  `date_update` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `comment_content`
--

CREATE TABLE `comment_content` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `users_id_creator` int(255) NOT NULL,
  `content_type` char(7) NOT NULL,
  `content_id` int(255) NOT NULL,
  `part_id` int(255) NOT NULL,
  `index_id` varchar(255) NOT NULL DEFAULT '',
  `comment_type` char(7) NOT NULL COMMENT 'text, sticker',
  `content` varchar(1000) NOT NULL,
  `count_reply` int(7) NOT NULL DEFAULT 0,
  `is_read` tinyint(1) NOT NULL DEFAULT 0,
  `ip_address` varchar(20) NOT NULL DEFAULT '',
  `code` varchar(255) NOT NULL,
  `is_reply` tinyint(1) NOT NULL DEFAULT 0,
  `date_publish` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `comment_content_reply`
--

CREATE TABLE `comment_content_reply` (
  `id` int(255) NOT NULL,
  `comment_id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `comment_type` char(7) NOT NULL COMMENT 'text, sticker	',
  `content` varchar(1000) NOT NULL,
  `is_read` tinyint(1) NOT NULL DEFAULT 0,
  `is_reply` tinyint(1) NOT NULL DEFAULT 0,
  `ip_address` varchar(20) NOT NULL DEFAULT '',
  `date_publish` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `comment_count_paragraph`
--

CREATE TABLE `comment_count_paragraph` (
  `id` int(255) NOT NULL,
  `content_data_id` int(255) NOT NULL,
  `part_id` int(255) NOT NULL,
  `index_id` int(255) NOT NULL,
  `count` int(5) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `competition`
--

CREATE TABLE `competition` (
  `id` int(11) NOT NULL,
  `users_id` int(11) NOT NULL,
  `type` varchar(5) NOT NULL COMMENT 'novel,comic,scrpt,art',
  `content_id` int(11) NOT NULL,
  `submit_date` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `competition_detail`
--

CREATE TABLE `competition_detail` (
  `id` int(100) NOT NULL,
  `cover` varchar(50) NOT NULL,
  `title` varchar(50) NOT NULL,
  `info` varchar(1000) NOT NULL,
  `url_competition` varchar(150) NOT NULL DEFAULT '',
  `is_work_novel` tinyint(1) NOT NULL DEFAULT 0,
  `is_work_comic` tinyint(1) NOT NULL DEFAULT 0,
  `is_work_script` tinyint(1) NOT NULL DEFAULT 0,
  `is_work_art` tinyint(1) NOT NULL DEFAULT 0,
  `is_work_flash` tinyint(1) NOT NULL DEFAULT 0,
  `is_work_short` tinyint(1) NOT NULL DEFAULT 0,
  `is_show_work` tinyint(1) NOT NULL DEFAULT 0,
  `is_lock` tinyint(1) NOT NULL DEFAULT 0,
  `status` varchar(10) NOT NULL DEFAULT 'COMING' COMMENT 'COMING, ONGOING, JUDGING, FINISH',
  `date_start` char(10) NOT NULL DEFAULT '',
  `date_end` char(10) NOT NULL DEFAULT '',
  `is_show` int(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `competition_detail_user`
--

CREATE TABLE `competition_detail_user` (
  `id` int(255) NOT NULL,
  `competition_id` int(50) NOT NULL,
  `users_id` int(255) NOT NULL,
  `realname` varchar(100) NOT NULL DEFAULT '',
  `date_publish` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `competition_detail_winner_section`
--

CREATE TABLE `competition_detail_winner_section` (
  `id` int(100) NOT NULL,
  `competition_id` int(100) NOT NULL,
  `position` int(10) NOT NULL,
  `title` varchar(50) NOT NULL,
  `info` varchar(150) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `competition_voting`
--

CREATE TABLE `competition_voting` (
  `id` int(100) NOT NULL,
  `competition_id` int(100) NOT NULL,
  `content_type` varchar(7) NOT NULL,
  `content_id` int(255) NOT NULL,
  `count_vote_all` int(3) NOT NULL,
  `count_vote_valid` int(3) NOT NULL,
  `count_vote_invalid` int(3) NOT NULL,
  `date_update` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `competition_voting_user`
--

CREATE TABLE `competition_voting_user` (
  `id` int(100) NOT NULL,
  `competition_voting_id` int(100) NOT NULL,
  `users_id` int(255) NOT NULL,
  `ip_address` varchar(45) NOT NULL DEFAULT '',
  `date_publish` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `competition_work`
--

CREATE TABLE `competition_work` (
  `id` int(255) NOT NULL,
  `competition_id` int(50) NOT NULL,
  `users_id` int(255) NOT NULL,
  `content_data_id` int(255) NOT NULL,
  `is_submit` tinyint(1) NOT NULL DEFAULT 1,
  `date_order` char(14) NOT NULL,
  `date_publish` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `competition_work_winners`
--

CREATE TABLE `competition_work_winners` (
  `id` int(255) NOT NULL,
  `competition_id` int(100) NOT NULL,
  `content_data_id` int(255) NOT NULL,
  `winner_section_id` int(50) NOT NULL DEFAULT 0,
  `winner_title` varchar(50) NOT NULL DEFAULT '',
  `jury_quote` varchar(200) NOT NULL DEFAULT '',
  `section` int(5) NOT NULL DEFAULT 0,
  `position` int(5) NOT NULL,
  `order_position` int(2) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `connect_block`
--

CREATE TABLE `connect_block` (
  `id` int(255) NOT NULL,
  `users_id_from` int(255) NOT NULL,
  `users_id_to` int(255) NOT NULL,
  `date_publish` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `connect_follow`
--

CREATE TABLE `connect_follow` (
  `id` int(11) NOT NULL,
  `users_id_from` int(255) NOT NULL,
  `users_id_to` int(255) NOT NULL,
  `date_publish` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `content_data`
--

CREATE TABLE `content_data` (
  `id` int(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `content_type` char(7) NOT NULL,
  `old_content_type` char(7) NOT NULL,
  `old_content_id` int(255) NOT NULL,
  `old_slug` varchar(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `cover` varchar(300) NOT NULL DEFAULT '',
  `banner` varchar(300) NOT NULL DEFAULT '',
  `title` varchar(250) NOT NULL,
  `preview` varchar(1000) NOT NULL DEFAULT '',
  `genre_id` int(10) NOT NULL DEFAULT 0,
  `count_part` int(5) NOT NULL DEFAULT 0,
  `count_view` int(5) NOT NULL DEFAULT 0,
  `count_like` int(5) NOT NULL DEFAULT 0,
  `count_comment` int(5) NOT NULL DEFAULT 0,
  `users_id_curator` int(255) NOT NULL DEFAULT 0,
  `is_showstar` tinyint(1) NOT NULL DEFAULT 1,
  `is_publish` tinyint(1) NOT NULL DEFAULT 0,
  `is_curation` tinyint(1) NOT NULL DEFAULT 0,
  `is_adult` tinyint(1) NOT NULL DEFAULT 0,
  `is_finish` tinyint(1) NOT NULL DEFAULT 0,
  `is_protected` tinyint(1) NOT NULL DEFAULT 0,
  `is_takedown` tinyint(1) NOT NULL DEFAULT 0,
  `monetize_type` tinyint(1) NOT NULL DEFAULT 0,
  `monetize_koin_full` int(5) NOT NULL DEFAULT 0,
  `monetize_koin_part` int(5) NOT NULL DEFAULT 0,
  `open_part` int(4) NOT NULL DEFAULT 0,
  `date_author` char(14) NOT NULL DEFAULT '0',
  `date_order` char(14) NOT NULL,
  `date_publish` varchar(20) NOT NULL,
  `date_update` varchar(20) NOT NULL,
  `is_parsing_content_5` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `content_data_comic`
--

CREATE TABLE `content_data_comic` (
  `id` int(255) NOT NULL,
  `content_data_id` int(255) NOT NULL,
  `blurb` mediumtext NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `content_data_comic_part`
--

CREATE TABLE `content_data_comic_part` (
  `id` int(255) NOT NULL,
  `content_data_id` int(255) NOT NULL,
  `position` int(50) NOT NULL DEFAULT 1,
  `photo` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `preview` varchar(500) NOT NULL,
  `count_view` int(20) NOT NULL DEFAULT 0,
  `count_like` int(20) NOT NULL DEFAULT 0,
  `count_comment` int(20) NOT NULL DEFAULT 0,
  `users_id_curator` int(255) NOT NULL DEFAULT 0,
  `is_adult` tinyint(1) NOT NULL DEFAULT 0,
  `is_curation` tinyint(1) NOT NULL DEFAULT 0,
  `is_takedown` tinyint(1) NOT NULL DEFAULT 0,
  `date_ymd` char(10) NOT NULL,
  `date_publish` varchar(20) NOT NULL,
  `date_update` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `content_data_comic_part_data`
--

CREATE TABLE `content_data_comic_part_data` (
  `id` int(255) NOT NULL,
  `comic_part_id` int(255) NOT NULL,
  `position` int(5) NOT NULL,
  `title` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `width` int(5) NOT NULL,
  `height` int(5) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `content_data_flash`
--

CREATE TABLE `content_data_flash` (
  `id` int(255) NOT NULL,
  `content_data_id` int(255) NOT NULL,
  `content` mediumtext NOT NULL,
  `content_data_id_prev` int(255) NOT NULL DEFAULT 0,
  `content_data_id_next` int(255) NOT NULL DEFAULT 0,
  `count_words` int(20) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `content_data_novel`
--

CREATE TABLE `content_data_novel` (
  `id` int(255) NOT NULL,
  `content_data_id` int(255) NOT NULL,
  `blurb` mediumtext NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `content_data_novel_part`
--

CREATE TABLE `content_data_novel_part` (
  `id` int(255) NOT NULL,
  `content_data_id` int(255) NOT NULL,
  `position` int(3) NOT NULL,
  `data_image_id` int(150) NOT NULL,
  `title` varchar(255) NOT NULL,
  `preview` varchar(500) NOT NULL DEFAULT '',
  `content` mediumtext NOT NULL,
  `footnote` varchar(7000) NOT NULL DEFAULT '',
  `count_words` int(20) NOT NULL DEFAULT 0,
  `count_view` int(20) NOT NULL DEFAULT 0,
  `count_like` int(20) NOT NULL DEFAULT 0,
  `count_comment` int(20) NOT NULL DEFAULT 0,
  `users_id_curator` int(255) NOT NULL DEFAULT 0,
  `is_adult` tinyint(1) NOT NULL DEFAULT 0,
  `is_curation` tinyint(1) NOT NULL DEFAULT 0,
  `is_takedown` tinyint(1) NOT NULL DEFAULT 0,
  `date_ymd` char(10) NOT NULL,
  `date_publish` varchar(20) NOT NULL,
  `date_update` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `content_data_script`
--

CREATE TABLE `content_data_script` (
  `id` int(255) NOT NULL,
  `content_data_id` int(255) NOT NULL,
  `blurb` mediumtext NOT NULL,
  `premise` varchar(1000) NOT NULL DEFAULT '',
  `synopsis` mediumtext DEFAULT NULL,
  `characters` mediumtext DEFAULT NULL,
  `visibility` int(1) NOT NULL DEFAULT 0 COMMENT '0: terbuka, 1: terbatas, 2: terkunci, 3: premium'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `content_data_script_allowed`
--

CREATE TABLE `content_data_script_allowed` (
  `id` int(50) NOT NULL,
  `content_data_id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `date_publish` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `content_data_script_allowed_request`
--

CREATE TABLE `content_data_script_allowed_request` (
  `id` int(50) NOT NULL,
  `content_data_id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `date_expired` char(8) NOT NULL,
  `date_publish` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `content_data_script_character`
--

CREATE TABLE `content_data_script_character` (
  `id` int(255) NOT NULL,
  `content_data_id` int(255) NOT NULL,
  `name` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `content_data_script_part`
--

CREATE TABLE `content_data_script_part` (
  `id` int(255) NOT NULL,
  `content_data_id` int(255) NOT NULL,
  `position` int(50) NOT NULL DEFAULT 1,
  `title` varchar(300) NOT NULL,
  `preview` varchar(100) NOT NULL DEFAULT '',
  `content` longtext DEFAULT NULL,
  `footnote` varchar(7000) NOT NULL DEFAULT '',
  `count_words` int(150) NOT NULL DEFAULT 0,
  `count_view` int(255) NOT NULL DEFAULT 0,
  `count_like` int(100) NOT NULL DEFAULT 0,
  `count_comment` int(100) NOT NULL DEFAULT 0,
  `users_id_curator` int(255) NOT NULL DEFAULT 0,
  `is_publish` tinyint(1) NOT NULL DEFAULT 0,
  `is_curation` tinyint(1) NOT NULL DEFAULT 0,
  `is_takedown` tinyint(1) NOT NULL DEFAULT 0,
  `date_publish` varchar(20) NOT NULL,
  `date_update` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `content_data_short`
--

CREATE TABLE `content_data_short` (
  `id` int(255) NOT NULL,
  `content_data_id` int(255) NOT NULL,
  `content` mediumtext NOT NULL,
  `count_words` int(20) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `content_history_part`
--

CREATE TABLE `content_history_part` (
  `id` int(255) NOT NULL,
  `part_id` int(255) NOT NULL,
  `content_data_id` int(255) NOT NULL,
  `type` char(15) NOT NULL COMMENT 'delete, draft, publish',
  `data_image_id` int(150) NOT NULL DEFAULT 0,
  `title` varchar(255) NOT NULL,
  `preview` varchar(500) NOT NULL DEFAULT '',
  `content` mediumtext NOT NULL,
  `footnote` varchar(7000) NOT NULL DEFAULT '',
  `count_words` int(20) NOT NULL DEFAULT 0,
  `is_adult` tinyint(1) NOT NULL DEFAULT 0,
  `is_curation` tinyint(1) NOT NULL DEFAULT 0,
  `date_ymd` char(10) NOT NULL,
  `date_publish` varchar(20) NOT NULL,
  `date_expired` char(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `content_isread_part`
--

CREATE TABLE `content_isread_part` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `content_data_id` int(255) NOT NULL,
  `part_id` int(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `content_users_label`
--

CREATE TABLE `content_users_label` (
  `id` int(100) NOT NULL,
  `label` int(1) NOT NULL COMMENT '1: writer, 2: illustrator',
  `content_data_id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `title` varchar(150) NOT NULL,
  `migrasi_code` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `contribution_counter`
--

CREATE TABLE `contribution_counter` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `login` int(3) NOT NULL DEFAULT 0,
  `timeline` int(3) NOT NULL DEFAULT 0,
  `comment` int(3) NOT NULL DEFAULT 0,
  `work` int(3) NOT NULL DEFAULT 0,
  `novel` int(3) NOT NULL DEFAULT 0,
  `comic` int(3) NOT NULL DEFAULT 0,
  `script` int(3) NOT NULL DEFAULT 0,
  `flash` int(3) NOT NULL DEFAULT 0,
  `short` int(3) NOT NULL DEFAULT 0,
  `poetry` int(3) NOT NULL DEFAULT 0,
  `date_ymd` char(8) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `contribution_history`
--

CREATE TABLE `contribution_history` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `code` varchar(10) NOT NULL COMMENT 'login, chat, follow, review, like, bookmark',
  `date_ymd` char(8) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `contribution_login_history`
--

CREATE TABLE `contribution_login_history` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `date_code` char(14) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `creator_account`
--

CREATE TABLE `creator_account` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `users_id_root` int(255) NOT NULL DEFAULT 0,
  `style_program_id` int(5) NOT NULL DEFAULT 0,
  `cash` int(13) NOT NULL DEFAULT 0,
  `cash_pending` int(13) NOT NULL DEFAULT 0,
  `cash_payout` int(13) NOT NULL DEFAULT 0,
  `cash_total` int(13) NOT NULL DEFAULT 0,
  `royalty_level` int(2) NOT NULL DEFAULT 1,
  `delete_limit` varchar(20) NOT NULL DEFAULT '' COMMENT 'tanggal,limit chapter, limit comment',
  `is_chatcurator` tinyint(1) NOT NULL DEFAULT 0,
  `is_illustrator` tinyint(1) NOT NULL DEFAULT 0,
  `is_partner` tinyint(1) NOT NULL DEFAULT 0,
  `is_banned` tinyint(1) NOT NULL DEFAULT 0,
  `transfer_code` int(6) NOT NULL DEFAULT 0,
  `date_order` bigint(15) NOT NULL,
  `date_publish` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `creator_account_detail`
--

CREATE TABLE `creator_account_detail` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `address` varchar(1500) NOT NULL DEFAULT '',
  `website` varchar(255) NOT NULL DEFAULT '',
  `account_fb` varchar(255) NOT NULL DEFAULT '',
  `account_twitter` varchar(255) NOT NULL DEFAULT '',
  `account_ig` varchar(255) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `creator_account_writter`
--

CREATE TABLE `creator_account_writter` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `writer` int(1) NOT NULL DEFAULT 0,
  `type` int(1) NOT NULL DEFAULT 0,
  `brand_name` varchar(100) NOT NULL DEFAULT '',
  `brand_logo` varchar(100) NOT NULL DEFAULT '',
  `brand_url` varchar(50) NOT NULL DEFAULT '',
  `source_ads` varchar(10000) NOT NULL DEFAULT '',
  `source_analytic` varchar(10000) NOT NULL DEFAULT '',
  `rss_folder` varchar(20) NOT NULL DEFAULT '',
  `date_grabbing` varchar(20) NOT NULL DEFAULT '',
  `date_publish` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `creator_bank`
--

CREATE TABLE `creator_bank` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `bank_data_id` int(3) NOT NULL,
  `bank_account_name` varchar(20) NOT NULL,
  `bank_account_number` char(30) NOT NULL,
  `date_publish` varchar(20) NOT NULL,
  `date_update` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `creator_chat`
--

CREATE TABLE `creator_chat` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `content_data_id` int(255) NOT NULL,
  `content` varchar(2000) NOT NULL,
  `is_creator` int(1) NOT NULL DEFAULT 0,
  `is_read` int(1) NOT NULL DEFAULT 0,
  `date_publish` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `creator_data_image`
--

CREATE TABLE `creator_data_image` (
  `id` int(150) NOT NULL,
  `users_id` int(255) NOT NULL,
  `content_type` char(7) NOT NULL,
  `file` varchar(50) NOT NULL,
  `date_order` char(14) NOT NULL,
  `date_publish` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `creator_history_income`
--

CREATE TABLE `creator_history_income` (
  `id` int(255) NOT NULL,
  `creator_type` int(1) NOT NULL,
  `users_id` int(255) NOT NULL,
  `cash` int(255) NOT NULL DEFAULT 0,
  `date_ymd` varchar(10) NOT NULL,
  `date_publish` varchar(20) NOT NULL,
  `date_update` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `creator_history_monetize`
--

CREATE TABLE `creator_history_monetize` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `content_type` char(7) NOT NULL,
  `content_id` int(255) NOT NULL,
  `cash_before` int(100) DEFAULT NULL,
  `sharing_percent` int(10) DEFAULT NULL,
  `cash` int(100) NOT NULL,
  `invoice_id` char(255) NOT NULL DEFAULT '',
  `is_offline` int(1) NOT NULL DEFAULT 0,
  `date_ym` char(7) NOT NULL,
  `date_ymd` char(10) NOT NULL,
  `date_publish` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `creator_history_payout`
--

CREATE TABLE `creator_history_payout` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `request_payout_id` int(255) NOT NULL,
  `is_partner` int(1) NOT NULL,
  `sender` varchar(150) NOT NULL DEFAULT '',
  `cash` int(255) NOT NULL DEFAULT 0,
  `bank_data_id` int(3) NOT NULL,
  `bank_name` char(20) NOT NULL,
  `bank_account_name` char(20) NOT NULL,
  `bank_account_number` char(30) NOT NULL DEFAULT '',
  `data_payout_period_id` int(10) NOT NULL DEFAULT 0,
  `date_ym` char(7) NOT NULL,
  `date_transfer` varchar(20) NOT NULL DEFAULT '',
  `date_update` varchar(20) NOT NULL,
  `date_publish` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `creator_notification_income`
--

CREATE TABLE `creator_notification_income` (
  `id` int(255) NOT NULL,
  `creator_type` char(6) NOT NULL,
  `users_id` int(255) NOT NULL,
  `cash` int(100) NOT NULL DEFAULT 0,
  `status` int(1) NOT NULL DEFAULT 0,
  `date_ymd` varchar(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `creator_order_list`
--

CREATE TABLE `creator_order_list` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `invoice_id` char(255) NOT NULL,
  `wicu_id` int(255) NOT NULL,
  `count_items` int(15) NOT NULL,
  `status` char(10) NOT NULL DEFAULT 'WAITING' COMMENT 'FAILED, WAITING, PROCESS, SENDING, COMPLETED',
  `is_read` int(1) NOT NULL DEFAULT 0,
  `date_order` bigint(15) NOT NULL,
  `date_update` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `creator_royalty_level`
--

CREATE TABLE `creator_royalty_level` (
  `id` int(2) NOT NULL,
  `level` int(3) NOT NULL DEFAULT 1,
  `name` varchar(10) NOT NULL,
  `data_sharing_id` int(5) NOT NULL,
  `followers_min` int(5) NOT NULL,
  `followers_max` int(5) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `creator_shipping_courier`
--

CREATE TABLE `creator_shipping_courier` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `courier_code` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `creator_work_acquisition`
--

CREATE TABLE `creator_work_acquisition` (
  `id` int(255) NOT NULL,
  `users_id_from` int(255) NOT NULL,
  `users_id_to` int(255) NOT NULL,
  `content_data_id` int(255) NOT NULL,
  `status` int(1) NOT NULL DEFAULT 0,
  `is_read` int(1) NOT NULL DEFAULT 0,
  `date_order` bigint(15) NOT NULL,
  `date_publish` varchar(20) NOT NULL,
  `date_update` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `creator_work_bypass`
--

CREATE TABLE `creator_work_bypass` (
  `id` int(20) NOT NULL,
  `content_data_id` int(255) NOT NULL,
  `info` varchar(250) NOT NULL,
  `date_publish` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `data`
--

CREATE TABLE `data` (
  `id` int(255) NOT NULL,
  `type` int(10) NOT NULL,
  `position` int(10) NOT NULL,
  `code` varchar(20) NOT NULL DEFAULT '',
  `name` varchar(255) NOT NULL,
  `value` varchar(250) NOT NULL,
  `info` varchar(140) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `data_avatar`
--

CREATE TABLE `data_avatar` (
  `id` int(3) NOT NULL,
  `title` varchar(25) NOT NULL,
  `data_from` varchar(25) NOT NULL,
  `creator` varchar(25) NOT NULL,
  `items_count` int(3) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `data_countries`
--

CREATE TABLE `data_countries` (
  `id` int(11) NOT NULL,
  `phone` int(5) NOT NULL,
  `code` char(2) NOT NULL,
  `name` varchar(80) NOT NULL,
  `currency` varchar(3) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `data_doodle`
--

CREATE TABLE `data_doodle` (
  `id` int(50) NOT NULL,
  `image` varchar(50) NOT NULL,
  `title` varchar(50) NOT NULL,
  `is_show` tinyint(1) NOT NULL DEFAULT 0,
  `date_start` char(8) NOT NULL,
  `date_end` char(8) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `data_payout_period`
--

CREATE TABLE `data_payout_period` (
  `id` int(10) NOT NULL,
  `title` varchar(50) NOT NULL,
  `is_selected` tinyint(1) NOT NULL DEFAULT 0,
  `date_ym` char(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `data_redirect`
--

CREATE TABLE `data_redirect` (
  `id` int(20) NOT NULL,
  `type` char(10) NOT NULL COMMENT 'internal, external',
  `url` varchar(150) NOT NULL,
  `is_tokenauth` int(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `data_sharing`
--

CREATE TABLE `data_sharing` (
  `id` int(2) NOT NULL,
  `description` varchar(100) NOT NULL,
  `platform` int(2) NOT NULL,
  `publisher` int(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `data_telco_period`
--

CREATE TABLE `data_telco_period` (
  `id` int(4) NOT NULL,
  `providers` char(5) NOT NULL,
  `title` varchar(50) NOT NULL,
  `code` varchar(30) NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `data_theme_poetry`
--

CREATE TABLE `data_theme_poetry` (
  `id` int(255) NOT NULL,
  `type` int(1) NOT NULL DEFAULT 1,
  `title` varchar(20) NOT NULL,
  `data1` char(100) NOT NULL,
  `data2` char(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `data_username_disabled`
--

CREATE TABLE `data_username_disabled` (
  `id` int(25) NOT NULL,
  `username` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `emoticon`
--

CREATE TABLE `emoticon` (
  `id` int(255) NOT NULL,
  `tipe` int(1) NOT NULL DEFAULT 1,
  `name` varchar(255) NOT NULL,
  `folder` varchar(255) NOT NULL,
  `filetype` varchar(5) NOT NULL,
  `count` int(10) NOT NULL DEFAULT 0,
  `price` int(255) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `film_details`
--

CREATE TABLE `film_details` (
  `id` int(255) NOT NULL,
  `sgid` int(255) NOT NULL,
  `film_id` int(255) NOT NULL,
  `cover` varchar(255) NOT NULL DEFAULT '',
  `title` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `invoice_content`
--

CREATE TABLE `invoice_content` (
  `id` int(255) NOT NULL,
  `invoice_id` varchar(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `reference_id` int(255) NOT NULL DEFAULT 0,
  `title` varchar(250) NOT NULL DEFAULT '',
  `price_before` int(50) NOT NULL DEFAULT 0,
  `price_final` int(50) NOT NULL DEFAULT 0,
  `voucher_id` int(50) NOT NULL DEFAULT 0,
  `have_offline` tinyint(1) NOT NULL DEFAULT 0,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `is_completed` tinyint(1) NOT NULL DEFAULT 0,
  `date_ymd` char(10) NOT NULL,
  `date_time` char(8) NOT NULL,
  `date_publish` varchar(20) NOT NULL,
  `date_update` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `invoice_content_shipping`
--

CREATE TABLE `invoice_content_shipping` (
  `id` int(255) NOT NULL,
  `courier_code` varchar(10) NOT NULL,
  `package` varchar(50) NOT NULL,
  `recipient_name` varchar(60) NOT NULL,
  `recipient_phone` varchar(50) NOT NULL,
  `address` varchar(500) NOT NULL,
  `weight` varchar(10) NOT NULL DEFAULT '0',
  `price` int(100) NOT NULL DEFAULT 0,
  `waybill` varchar(150) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `invoice_content_user`
--

CREATE TABLE `invoice_content_user` (
  `id` int(255) NOT NULL,
  `inv_id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL COMMENT 'diisi dengan users_id seller',
  `count_item` int(5) NOT NULL DEFAULT 0,
  `is_shipping` tinyint(1) NOT NULL DEFAULT 0,
  `content_shipping_id` int(255) NOT NULL DEFAULT 0,
  `status` varchar(20) NOT NULL DEFAULT 'WAITING_PAYMENT' COMMENT 'WAITING_PAYMENT, WAITING_CONFIRM, PROCESS, SENDING, DELIVERED, COMPLETED, REJECTED, CANCEL_ORDER',
  `date_expired` bigint(14) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `invoice_content_user_item`
--

CREATE TABLE `invoice_content_user_item` (
  `id` int(255) NOT NULL,
  `content_user_id` int(255) NOT NULL COMMENT 'invoice_content_user id',
  `content_type` char(10) NOT NULL COMMENT 'PREMIUM, TOPUP, NOVEL, COMIC, FLASH, SHORT, CLASS, MARKET',
  `content_id` int(255) NOT NULL,
  `part_id` int(255) NOT NULL,
  `weight` varchar(10) NOT NULL DEFAULT '0',
  `quantity` int(5) NOT NULL DEFAULT 1,
  `price_item` int(50) NOT NULL,
  `price_before` int(50) NOT NULL,
  `price_final` int(50) NOT NULL,
  `voucher_id` int(50) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `invoice_content_voucher`
--

CREATE TABLE `invoice_content_voucher` (
  `id` int(100) NOT NULL,
  `inv_id` int(255) NOT NULL,
  `voucher_id` int(255) NOT NULL,
  `total_before` int(10) NOT NULL,
  `total_after` int(10) NOT NULL,
  `discount_price` int(10) NOT NULL,
  `rules` varchar(350) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `invoice_data_success`
--

CREATE TABLE `invoice_data_success` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `invoice_id` char(255) NOT NULL,
  `cash` int(100) NOT NULL,
  `date_ym` char(6) NOT NULL DEFAULT '',
  `date_ymd` char(8) NOT NULL DEFAULT '',
  `date_publish` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `invoice_reference`
--

CREATE TABLE `invoice_reference` (
  `id` int(255) NOT NULL,
  `reference_code` char(200) NOT NULL COMMENT 'REF.[wiId].[methodid].[ymdhis].[randomcode]',
  `inv_id` int(255) NOT NULL,
  `payment_method_id` int(255) NOT NULL,
  `payment_data` varchar(150) NOT NULL DEFAULT '',
  `payment_url` varchar(150) NOT NULL DEFAULT '',
  `data_1` varchar(255) NOT NULL DEFAULT '' COMMENT 'CHARGE_ID dari Xendit',
  `status` int(1) NOT NULL DEFAULT 0,
  `date_expired` bigint(15) NOT NULL DEFAULT 0,
  `date_publish` varchar(20) NOT NULL,
  `date_update` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='status';

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

--
-- Table structure for table `login_apps`
--

CREATE TABLE `login_apps` (
  `id` int(255) NOT NULL,
  `appkey` varchar(255) NOT NULL,
  `type` int(1) NOT NULL,
  `icon` varchar(100) NOT NULL DEFAULT '',
  `logo` varchar(100) NOT NULL DEFAULT '',
  `banner` varchar(100) NOT NULL DEFAULT '',
  `color` char(6) NOT NULL DEFAULT '',
  `name` varchar(100) NOT NULL,
  `version` char(7) NOT NULL DEFAULT '',
  `description` varchar(1000) NOT NULL,
  `url_callback` varchar(150) DEFAULT '',
  `url_tos` varchar(150) NOT NULL DEFAULT '',
  `url_privacy` varchar(150) NOT NULL DEFAULT '',
  `organization` varchar(150) NOT NULL DEFAULT '',
  `website` varchar(150) NOT NULL DEFAULT '',
  `uid_customerservice` int(255) NOT NULL DEFAULT 0,
  `is_fm` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `login_apps_access`
--

CREATE TABLE `login_apps_access` (
  `id` int(255) NOT NULL,
  `apps_id` int(255) NOT NULL,
  `chat` int(1) NOT NULL DEFAULT 0,
  `timeline` int(1) NOT NULL DEFAULT 0,
  `creator_webtoon` int(1) NOT NULL DEFAULT 0,
  `creator_novel` int(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `login_apps_approve`
--

CREATE TABLE `login_apps_approve` (
  `id` int(255) NOT NULL,
  `apps_id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `date_update` varchar(20) NOT NULL,
  `date_publish` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `login_email_code`
--

CREATE TABLE `login_email_code` (
  `id` int(255) NOT NULL,
  `type` int(1) NOT NULL DEFAULT 1,
  `users_id` int(255) NOT NULL,
  `code` varchar(255) NOT NULL,
  `data1` char(255) NOT NULL DEFAULT '',
  `date_expired` char(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `login_redirect_signature`
--

CREATE TABLE `login_redirect_signature` (
  `id` int(255) NOT NULL,
  `apps_id` int(255) NOT NULL,
  `signature` varchar(255) NOT NULL,
  `salt` varchar(100) NOT NULL,
  `sign_key` varchar(100) NOT NULL,
  `date_expired` char(14) NOT NULL,
  `date_publish` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `login_token`
--

CREATE TABLE `login_token` (
  `id` int(11) NOT NULL,
  `apps_id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `token_1` char(70) NOT NULL,
  `token_2` char(70) NOT NULL,
  `token_auth` char(140) NOT NULL DEFAULT '',
  `os_type` varchar(20) NOT NULL DEFAULT '',
  `device_id` varchar(255) NOT NULL DEFAULT '',
  `date_using` char(10) NOT NULL DEFAULT '',
  `date_expired` int(8) NOT NULL DEFAULT 0,
  `date_publish` varchar(20) NOT NULL,
  `date_update` char(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `login_token_auth`
--

CREATE TABLE `login_token_auth` (
  `id` int(255) NOT NULL,
  `login_token_id` int(20) NOT NULL,
  `token_auth` char(140) NOT NULL,
  `ip_address` char(20) NOT NULL,
  `date_expired` char(14) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `login_token_onetime`
--

CREATE TABLE `login_token_onetime` (
  `id` int(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `content` varchar(255) NOT NULL DEFAULT '',
  `date_expired` char(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `login_validation_apps`
--

CREATE TABLE `login_validation_apps` (
  `id` int(255) NOT NULL,
  `apps_id` int(255) NOT NULL,
  `signature` varchar(255) NOT NULL,
  `date_expired` char(14) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `market_books`
--

CREATE TABLE `market_books` (
  `id` int(255) NOT NULL,
  `items_id` int(255) NOT NULL,
  `type_data_id` int(10) NOT NULL,
  `isbn` varchar(50) NOT NULL DEFAULT '-',
  `genre_id` int(50) NOT NULL,
  `publishing_name` varchar(50) NOT NULL DEFAULT '',
  `description` mediumtext NOT NULL,
  `comment` varchar(500) NOT NULL DEFAULT '',
  `comment_name` varchar(50) NOT NULL DEFAULT '',
  `dimension` varchar(50) NOT NULL DEFAULT '-',
  `pages` int(10) NOT NULL DEFAULT 0,
  `goodreads_slug` varchar(50) NOT NULL DEFAULT '',
  `goodreads_score` varchar(7) NOT NULL DEFAULT '',
  `content_type` char(5) NOT NULL DEFAULT '',
  `content_id` int(255) NOT NULL DEFAULT 0,
  `date_cron` bigint(15) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `market_books_writer`
--

CREATE TABLE `market_books_writer` (
  `id` int(100) NOT NULL,
  `book_id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL DEFAULT 0,
  `realname` varchar(50) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `market_colab`
--

CREATE TABLE `market_colab` (
  `id` int(10) NOT NULL,
  `slug` varchar(70) NOT NULL,
  `title` varchar(50) NOT NULL,
  `count_item` int(2) NOT NULL DEFAULT 0,
  `date_update` varchar(20) NOT NULL,
  `date_publish` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `market_colab_items`
--

CREATE TABLE `market_colab_items` (
  `id` int(20) NOT NULL,
  `market_colab_id` int(10) NOT NULL,
  `items_id` int(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `market_group`
--

CREATE TABLE `market_group` (
  `id` int(10) NOT NULL,
  `slug` char(15) NOT NULL,
  `image` varchar(20) NOT NULL,
  `title` varchar(20) NOT NULL,
  `color` char(6) NOT NULL DEFAULT '',
  `is_discover` tinyint(1) NOT NULL DEFAULT 0,
  `is_menu` tinyint(1) NOT NULL DEFAULT 0,
  `is_selected` tinyint(1) NOT NULL DEFAULT 0,
  `is_show` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `market_group_items`
--

CREATE TABLE `market_group_items` (
  `id` int(255) NOT NULL,
  `group_id` int(10) NOT NULL,
  `items_id` int(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `market_items`
--

CREATE TABLE `market_items` (
  `id` int(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `market_type` varchar(10) NOT NULL COMMENT 'BOOK',
  `items_type` char(5) NOT NULL DEFAULT 'READY' COMMENT 'READY, PO',
  `users_id` int(255) NOT NULL,
  `cover` varchar(150) NOT NULL DEFAULT '',
  `title` varchar(150) NOT NULL,
  `info_bonus` varchar(500) NOT NULL DEFAULT '',
  `stock_available` int(100) NOT NULL DEFAULT 0,
  `stock_keep` int(100) NOT NULL DEFAULT 0,
  `count_sold` int(50) NOT NULL DEFAULT 0,
  `weight` int(15) NOT NULL DEFAULT 0 COMMENT 'satuan gram',
  `price` int(100) NOT NULL DEFAULT 0,
  `limit_stock` int(15) NOT NULL DEFAULT 10 COMMENT '	untuk membatasi order lebih dari 10',
  `po_days` tinyint(3) NOT NULL DEFAULT 0,
  `discount_type` varchar(10) NOT NULL DEFAULT '' COMMENT 'percent, price',
  `discount_data` int(100) NOT NULL DEFAULT 0,
  `count_view` int(100) NOT NULL DEFAULT 0,
  `is_sale` tinyint(1) NOT NULL,
  `is_takedown` tinyint(1) NOT NULL DEFAULT 0,
  `date_order` bigint(15) NOT NULL,
  `date_publish` varchar(20) NOT NULL,
  `date_update` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `market_items_bonus`
--

CREATE TABLE `market_items_bonus` (
  `id` int(255) NOT NULL,
  `items_id` int(255) NOT NULL,
  `title` varchar(50) NOT NULL,
  `file` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `market_items_genre`
--

CREATE TABLE `market_items_genre` (
  `id` int(255) NOT NULL,
  `items_id` int(255) NOT NULL,
  `genre_id` int(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `market_items_info`
--

CREATE TABLE `market_items_info` (
  `id` int(255) NOT NULL,
  `items_id` int(255) NOT NULL,
  `data_title` varchar(20) NOT NULL,
  `data_content` varchar(150) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `market_items_photo`
--

CREATE TABLE `market_items_photo` (
  `id` int(255) NOT NULL,
  `items_id` int(255) NOT NULL,
  `photo` varchar(150) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `market_items_review`
--

CREATE TABLE `market_items_review` (
  `id` int(255) NOT NULL,
  `books_id` int(255) NOT NULL,
  `name` varchar(50) NOT NULL,
  `content` varchar(1000) NOT NULL,
  `star` varchar(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `market_items_web`
--

CREATE TABLE `market_items_web` (
  `id` int(255) NOT NULL,
  `items_id` int(255) NOT NULL,
  `web_data_id` int(10) NOT NULL,
  `url` varchar(200) NOT NULL,
  `price` int(50) NOT NULL DEFAULT 0,
  `benefit` varchar(200) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `market_pinned`
--

CREATE TABLE `market_pinned` (
  `id` int(20) NOT NULL,
  `position` tinyint(5) NOT NULL,
  `items_id` int(255) NOT NULL,
  `is_show` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `market_special_preorder`
--

CREATE TABLE `market_special_preorder` (
  `id` int(5) NOT NULL,
  `items_id` int(255) NOT NULL,
  `cover` varchar(50) NOT NULL,
  `benefit` varchar(2000) NOT NULL,
  `is_publish` tinyint(1) NOT NULL DEFAULT 0,
  `date_start` char(14) NOT NULL,
  `date_end` char(14) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `menu_data`
--

CREATE TABLE `menu_data` (
  `id` int(20) NOT NULL,
  `slug` varchar(20) NOT NULL,
  `position` int(4) NOT NULL,
  `title` varchar(30) NOT NULL,
  `background` varchar(40) NOT NULL,
  `content_type` char(7) NOT NULL DEFAULT '',
  `vapi_minimum` int(2) NOT NULL DEFAULT 0,
  `is_show` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `menu_explore`
--

CREATE TABLE `menu_explore` (
  `id` int(255) NOT NULL,
  `page` char(7) NOT NULL,
  `position` int(5) NOT NULL,
  `title` varchar(50) NOT NULL,
  `title_page` varchar(40) NOT NULL DEFAULT '',
  `section` char(15) NOT NULL,
  `section_type` char(50) NOT NULL,
  `more_page` varchar(20) NOT NULL DEFAULT '',
  `is_cache` tinyint(1) NOT NULL DEFAULT 0,
  `is_login` tinyint(1) NOT NULL DEFAULT 0,
  `is_show` tinyint(1) NOT NULL DEFAULT 0,
  `vapi_minimum` tinyint(3) NOT NULL DEFAULT 0,
  `vapi_maximum` tinyint(3) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `menu_explore_catalog`
--

CREATE TABLE `menu_explore_catalog` (
  `id` int(255) NOT NULL,
  `slug` char(100) NOT NULL,
  `type` char(10) NOT NULL,
  `position` int(2) NOT NULL DEFAULT 1,
  `banner` varchar(100) NOT NULL,
  `title` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `menu_explore_feature`
--

CREATE TABLE `menu_explore_feature` (
  `id` int(50) NOT NULL,
  `position` int(5) NOT NULL DEFAULT 1,
  `codename` char(15) NOT NULL,
  `url` varchar(50) NOT NULL,
  `icon` varchar(25) NOT NULL DEFAULT '',
  `title` varchar(50) NOT NULL,
  `vapi_min` int(5) NOT NULL DEFAULT 0,
  `is_premium` tinyint(1) NOT NULL DEFAULT 0,
  `is_user_premium` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Jika bernilai 1 maka hanya tampil pada user premium saja',
  `is_insider` tinyint(1) NOT NULL DEFAULT 0,
  `is_show` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `menu_explore_info`
--

CREATE TABLE `menu_explore_info` (
  `id` int(10) NOT NULL,
  `banner` varchar(50) NOT NULL,
  `title` varchar(100) NOT NULL,
  `description` varchar(255) NOT NULL,
  `data_redirect_id` int(20) NOT NULL DEFAULT 0,
  `specific_for` char(10) NOT NULL DEFAULT '',
  `is_tokenauth` tinyint(1) NOT NULL DEFAULT 0,
  `is_show` int(1) NOT NULL DEFAULT 0,
  `date_start` char(10) NOT NULL,
  `date_end` char(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `menu_others_list`
--

CREATE TABLE `menu_others_list` (
  `id` int(255) NOT NULL,
  `position` int(2) NOT NULL DEFAULT 1,
  `icon` varchar(50) NOT NULL,
  `title` varchar(100) NOT NULL,
  `url` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `menu_popup`
--

CREATE TABLE `menu_popup` (
  `id` int(50) NOT NULL,
  `content_type` char(7) NOT NULL COMMENT 'info, class, novel, comic, flash, short, film',
  `content_id` int(255) NOT NULL DEFAULT 0,
  `image` varchar(100) NOT NULL DEFAULT '',
  `button` varchar(25) NOT NULL,
  `url` varchar(100) NOT NULL DEFAULT '',
  `is_token` tinyint(1) NOT NULL DEFAULT 0,
  `is_show` tinyint(1) NOT NULL DEFAULT 0,
  `date_start` char(10) NOT NULL,
  `date_end` char(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `menu_popup_users`
--

CREATE TABLE `menu_popup_users` (
  `id` int(255) NOT NULL,
  `popup_id` int(50) NOT NULL,
  `users_id` int(255) NOT NULL,
  `date_ymd` char(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` int(255) NOT NULL,
  `users_id_from` int(255) NOT NULL,
  `users_id_to` int(255) NOT NULL,
  `type` int(2) NOT NULL DEFAULT 0,
  `code` varchar(255) NOT NULL DEFAULT '',
  `content` varchar(150) NOT NULL,
  `is_read` tinyint(1) NOT NULL DEFAULT 0,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `status_browser` tinyint(1) NOT NULL DEFAULT 1,
  `date_order` char(14) NOT NULL,
  `date_update` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `notifications_browser`
--

CREATE TABLE `notifications_browser` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `title` varchar(50) NOT NULL,
  `body` varchar(255) NOT NULL,
  `type` char(15) NOT NULL,
  `data1` varchar(255) NOT NULL DEFAULT '',
  `data2` varchar(255) NOT NULL DEFAULT '',
  `data3` varchar(255) NOT NULL,
  `is_read` int(1) NOT NULL DEFAULT 0,
  `date_expired` varchar(12) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `notifications_content_pending`
--

CREATE TABLE `notifications_content_pending` (
  `id` int(255) NOT NULL,
  `content_data_id` int(255) NOT NULL,
  `data_action` varchar(20) NOT NULL COMMENT 'WORK_NEW, PART_UPDATE',
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `date_ymd` char(8) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `notifications_creator`
--

CREATE TABLE `notifications_creator` (
  `id` int(255) NOT NULL,
  `type` char(10) NOT NULL COMMENT 'work, info',
  `users_id` int(255) NOT NULL,
  `content_data_id` int(255) NOT NULL DEFAULT 0,
  `part_id` int(255) NOT NULL DEFAULT 0,
  `content` varchar(50) DEFAULT NULL,
  `help` varchar(200) NOT NULL DEFAULT '',
  `is_read` tinyint(1) NOT NULL DEFAULT 0,
  `date_order` bigint(15) NOT NULL,
  `date_update` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `notifications_email_cron`
--

CREATE TABLE `notifications_email_cron` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `title` varchar(50) NOT NULL,
  `content` varchar(300) NOT NULL,
  `date_publish` char(14) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `notifications_firebase`
--

CREATE TABLE `notifications_firebase` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `type` char(10) NOT NULL,
  `data_id` int(255) NOT NULL,
  `dateymd` char(10) NOT NULL DEFAULT '',
  `date_expired` bigint(15) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `notifications_firebase_cron`
--

CREATE TABLE `notifications_firebase_cron` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `title` varchar(50) NOT NULL,
  `content` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `notifications_firebase_follow`
--

CREATE TABLE `notifications_firebase_follow` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `count` int(10) NOT NULL DEFAULT 0,
  `date_ymd` char(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `notifications_follow`
--

CREATE TABLE `notifications_follow` (
  `id` int(255) NOT NULL,
  `users_id_from` int(255) NOT NULL,
  `users_id_to` int(255) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `date_order` char(14) NOT NULL,
  `date_update` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `notifications_info`
--

CREATE TABLE `notifications_info` (
  `id` int(255) NOT NULL,
  `info` varchar(500) NOT NULL,
  `is_system` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `notifications_lastseen`
--

CREATE TABLE `notifications_lastseen` (
  `id` int(255) NOT NULL,
  `apps_id` int(255) NOT NULL,
  `users_id_from` int(255) NOT NULL,
  `users_id_to` int(255) NOT NULL,
  `is_hidden` tinyint(1) NOT NULL DEFAULT 0,
  `date_order` varchar(14) NOT NULL,
  `date_update` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `old_analytic_visitor_work`
--

CREATE TABLE `old_analytic_visitor_work` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `content_type` char(7) NOT NULL,
  `content_id` int(255) NOT NULL,
  `count_reach` int(255) NOT NULL DEFAULT 0,
  `count_view` int(255) NOT NULL DEFAULT 0,
  `count_ipuniq` int(255) NOT NULL DEFAULT 0,
  `count_session` int(255) NOT NULL DEFAULT 0,
  `order_ym` int(6) NOT NULL DEFAULT 0,
  `date_ymd` int(8) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `old_record_visitor_work`
--

CREATE TABLE `old_record_visitor_work` (
  `id` int(255) NOT NULL,
  `ip_address` char(20) NOT NULL,
  `content_type` char(7) NOT NULL,
  `content_id` int(255) NOT NULL,
  `part_id` int(255) NOT NULL DEFAULT 0,
  `date_ymd` int(8) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `popularity_users`
--

CREATE TABLE `popularity_users` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `is_moovel` int(1) NOT NULL DEFAULT 0,
  `is_toon` int(1) NOT NULL DEFAULT 0,
  `point` int(15) NOT NULL DEFAULT 0,
  `date_ymd` char(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `premium_film`
--

CREATE TABLE `premium_film` (
  `id` int(20) NOT NULL,
  `film_id` int(50) NOT NULL,
  `is_show` tinyint(1) NOT NULL DEFAULT 1,
  `date_start` char(8) NOT NULL,
  `date_end` char(8) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `premium_users`
--

CREATE TABLE `premium_users` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `transaction_type` char(10) NOT NULL COMMENT 'INVOICE, TELCO',
  `transaction_data` varchar(100) NOT NULL,
  `premium_users_history_id` int(255) NOT NULL DEFAULT 0,
  `date_start` char(10) NOT NULL,
  `date_end` char(10) NOT NULL,
  `date_publish` varchar(20) NOT NULL,
  `date_update` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `premium_users_benefit_boost`
--

CREATE TABLE `premium_users_benefit_boost` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `content_type` char(7) NOT NULL,
  `content_id` int(255) NOT NULL,
  `date_ymd` char(8) NOT NULL,
  `date_publish` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `premium_users_benefit_sticker`
--

CREATE TABLE `premium_users_benefit_sticker` (
  `id` int(100) NOT NULL,
  `users_id` int(255) NOT NULL,
  `sticker_id` int(100) NOT NULL,
  `date_ymd` char(8) NOT NULL,
  `date_publish` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `premium_users_benefit_works`
--

CREATE TABLE `premium_users_benefit_works` (
  `id` int(100) NOT NULL,
  `users_id` int(255) NOT NULL,
  `content_type` char(7) NOT NULL,
  `content_id` int(255) NOT NULL,
  `part_id` int(255) NOT NULL,
  `count` int(7) NOT NULL DEFAULT 1,
  `date_y` char(4) NOT NULL,
  `date_ym` char(6) NOT NULL,
  `date_ymd` char(8) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `premium_users_benefit_works_history`
--

CREATE TABLE `premium_users_benefit_works_history` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `content_type` char(7) NOT NULL,
  `content_id` int(255) NOT NULL,
  `part_id` int(255) NOT NULL DEFAULT 0,
  `date_rewrite` char(15) NOT NULL,
  `date_publish` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `premium_users_history`
--

CREATE TABLE `premium_users_history` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `transaction_type` char(10) NOT NULL COMMENT 'INVOICE, TELCO',
  `transaction_data` varchar(100) NOT NULL COMMENT 'invoice_id, msisdn',
  `date_start` char(10) NOT NULL,
  `date_end` char(10) NOT NULL,
  `date_trx_y` char(4) NOT NULL,
  `date_trx_ym` char(6) NOT NULL,
  `date_trx_ymd` char(8) NOT NULL,
  `date_publish` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `premium_validation`
--

CREATE TABLE `premium_validation` (
  `id` int(100) NOT NULL,
  `users_id` int(255) NOT NULL,
  `transaction_type` char(10) NOT NULL COMMENT 'INVOICE, TELCO',
  `uniq_code` varchar(100) NOT NULL,
  `date_publish` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `publishing`
--

CREATE TABLE `publishing` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `born` varchar(10) NOT NULL DEFAULT '',
  `phone` varchar(17) NOT NULL DEFAULT '',
  `address` varchar(1500) NOT NULL DEFAULT '',
  `website` varchar(255) NOT NULL DEFAULT '',
  `account_fb` varchar(255) NOT NULL DEFAULT '',
  `account_twitter` varchar(255) NOT NULL DEFAULT '',
  `account_ig` varchar(255) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `reading_list`
--

CREATE TABLE `reading_list` (
  `id` int(255) NOT NULL,
  `slug` varchar(100) NOT NULL,
  `content_type` char(5) NOT NULL,
  `cover` varchar(50) NOT NULL,
  `title` varchar(70) NOT NULL,
  `suggested_by` varchar(100) NOT NULL,
  `date_start` int(8) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `reading_list_content`
--

CREATE TABLE `reading_list_content` (
  `id` int(255) NOT NULL,
  `reading_list_id` int(255) NOT NULL,
  `content_data_id` int(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `record_visitor_work`
--

CREATE TABLE `record_visitor_work` (
  `id` int(255) NOT NULL,
  `ip_address` char(20) NOT NULL,
  `content_type` char(7) NOT NULL,
  `content_id` int(255) NOT NULL,
  `part_id` int(255) NOT NULL DEFAULT 0,
  `date_ymd` int(8) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `report_data`
--

CREATE TABLE `report_data` (
  `id` int(20) NOT NULL,
  `users_id` int(255) NOT NULL,
  `content_type` char(15) NOT NULL,
  `content_id` int(255) NOT NULL,
  `is_solved` tinyint(1) NOT NULL DEFAULT 0,
  `is_read` tinyint(1) NOT NULL DEFAULT 0,
  `date_publish` varchar(20) NOT NULL,
  `date_update` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `slider`
--

CREATE TABLE `slider` (
  `id` int(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `title` varchar(50) NOT NULL,
  `url` varchar(100) NOT NULL DEFAULT '',
  `is_tokenauth` tinyint(1) NOT NULL DEFAULT 0,
  `is_show` tinyint(1) NOT NULL DEFAULT 1,
  `date_start` char(8) NOT NULL,
  `date_end` char(8) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `special_users_freeread`
--

CREATE TABLE `special_users_freeread` (
  `id` int(50) NOT NULL,
  `users_id` int(255) NOT NULL,
  `voucher_internal_id` int(25) NOT NULL DEFAULT 0,
  `content_type` char(7) NOT NULL COMMENT 'isi all apabila semua karya',
  `content_id` int(255) NOT NULL COMMENT 'apabila content_type = all, maka nilai kolom ini adalah 0',
  `date_expired` char(14) NOT NULL,
  `date_publish` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `sticker_list`
--

CREATE TABLE `sticker_list` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `icon` varchar(100) NOT NULL,
  `title` varchar(20) NOT NULL,
  `count_sticker` int(3) NOT NULL DEFAULT 0,
  `koin` int(10) NOT NULL DEFAULT 0,
  `is_curation` tinyint(1) NOT NULL DEFAULT 0,
  `is_publish` tinyint(1) NOT NULL DEFAULT 0,
  `date_publish` varchar(20) NOT NULL,
  `date_update` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `sticker_list_content`
--

CREATE TABLE `sticker_list_content` (
  `id` int(255) NOT NULL,
  `sticker_id` int(255) NOT NULL,
  `image` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `sticker_list_livechat`
--

CREATE TABLE `sticker_list_livechat` (
  `id` int(10) NOT NULL,
  `sticker_id` int(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `story_content`
--

CREATE TABLE `story_content` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `content_data_id` int(255) NOT NULL,
  `content_data` int(255) NOT NULL DEFAULT 0,
  `content` varchar(10) NOT NULL COMMENT '1.0: novel, 1.1: chapter, 2.0: comic, 2.1: episode',
  `date_order` char(14) NOT NULL,
  `date_update` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `talk_content`
--

CREATE TABLE `talk_content` (
  `id` int(255) NOT NULL,
  `type` int(1) NOT NULL COMMENT '0: lainnya, 1: podcast, 2: bercerita',
  `users_id` int(255) NOT NULL,
  `banner` varchar(50) NOT NULL DEFAULT '',
  `title` varchar(255) NOT NULL DEFAULT '''''',
  `description` varchar(1500) NOT NULL DEFAULT '''''',
  `code` char(25) NOT NULL DEFAULT '',
  `content_type` char(7) NOT NULL DEFAULT '',
  `content_id` int(255) NOT NULL DEFAULT 0,
  `is_talkoftheweek` tinyint(1) NOT NULL DEFAULT 0,
  `is_premium` tinyint(1) NOT NULL DEFAULT 0,
  `is_show` tinyint(1) NOT NULL DEFAULT 1,
  `date_time` char(5) NOT NULL DEFAULT '''''',
  `date_ymd` char(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `talk_live`
--

CREATE TABLE `talk_live` (
  `id` int(255) NOT NULL,
  `slug` varchar(20) NOT NULL,
  `banner` char(100) NOT NULL,
  `title` varchar(100) NOT NULL,
  `speakers` varchar(500) NOT NULL DEFAULT '',
  `code` char(100) NOT NULL DEFAULT '',
  `status` int(1) NOT NULL DEFAULT 1,
  `date_time` char(5) NOT NULL,
  `date_ymd` char(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `timeline_content`
--

CREATE TABLE `timeline_content` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `content_type` tinyint(1) NOT NULL COMMENT '1: status, 2: rekwik, 3: work activity (comment, like), 4: work publish (new, update)',
  `content_id` int(255) NOT NULL,
  `content` tinyint(2) NOT NULL DEFAULT 0,
  `is_option` int(1) NOT NULL DEFAULT 1,
  `is_takedown` tinyint(1) NOT NULL DEFAULT 0,
  `date_order` bigint(14) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `timeline_content_hot`
--

CREATE TABLE `timeline_content_hot` (
  `id` int(255) NOT NULL,
  `timeline_status_id` int(255) NOT NULL,
  `point` int(5) NOT NULL DEFAULT 0,
  `date_trending` char(8) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `timeline_content_old`
--

CREATE TABLE `timeline_content_old` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `content_type` int(2) NOT NULL COMMENT '1:post, 2:menanggapi status, 3:rekwik, 4:novel baru/chapter baru, 5:komik baru/episode baru, 6:komentar di novel, 7:komentar di komik',
  `content_id` int(255) NOT NULL,
  `content` int(2) NOT NULL DEFAULT 0,
  `is_option` int(1) NOT NULL DEFAULT 1,
  `date_order` bigint(14) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `timeline_status`
--

CREATE TABLE `timeline_status` (
  `id` int(255) NOT NULL,
  `apps_id` int(20) NOT NULL,
  `users_id` int(255) NOT NULL,
  `content` varchar(7000) NOT NULL,
  `count_vote` int(10) NOT NULL DEFAULT 0,
  `count_comment` int(10) NOT NULL DEFAULT 0,
  `count_view` int(10) NOT NULL DEFAULT 0,
  `is_attach` tinyint(1) NOT NULL DEFAULT 0,
  `is_share` tinyint(1) NOT NULL DEFAULT 0,
  `is_banned` tinyint(1) NOT NULL DEFAULT 0,
  `is_takedown` tinyint(1) NOT NULL DEFAULT 0,
  `ip_address` varchar(20) NOT NULL,
  `date_order` bigint(15) NOT NULL,
  `date_publish` varchar(20) NOT NULL,
  `date_update` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `timeline_status_attach`
--

CREATE TABLE `timeline_status_attach` (
  `id` int(255) NOT NULL,
  `timeline_status_id` int(255) NOT NULL,
  `content_type` char(5) NOT NULL COMMENT 'image, work',
  `content_data` varchar(255) NOT NULL,
  `data_help` varchar(50) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `timeline_status_comment`
--

CREATE TABLE `timeline_status_comment` (
  `id` int(255) NOT NULL,
  `timeline_status_id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `content_type` char(7) NOT NULL DEFAULT '' COMMENT 'sticker, novel, comic, scrpt, flash, short',
  `content` varchar(2000) NOT NULL,
  `is_no_have_status` tinyint(1) NOT NULL DEFAULT 0,
  `ip_address` varchar(20) NOT NULL,
  `date_publish` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `timeline_status_mute`
--

CREATE TABLE `timeline_status_mute` (
  `id` int(255) NOT NULL,
  `timeline_status_id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `date_publish` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `timeline_status_share`
--

CREATE TABLE `timeline_status_share` (
  `id` int(100) NOT NULL,
  `timeline_status_id` int(255) NOT NULL,
  `title` varchar(100) NOT NULL,
  `preview` varchar(250) NOT NULL,
  `url` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `timeline_status_vote`
--

CREATE TABLE `timeline_status_vote` (
  `id` int(255) NOT NULL,
  `timeline_status_id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `vote` tinyint(1) NOT NULL COMMENT '1,-1',
  `date_update` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `timeline_works_content`
--

CREATE TABLE `timeline_works_content` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `content_data_id` int(255) NOT NULL,
  `date_order` char(14) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tmp_analytic_trueread`
--

CREATE TABLE `tmp_analytic_trueread` (
  `id` int(255) NOT NULL,
  `code` varchar(35) NOT NULL,
  `users_id` int(255) NOT NULL,
  `content_data_id` int(255) NOT NULL,
  `part_id` int(255) NOT NULL,
  `is_record` tinyint(1) NOT NULL DEFAULT 0,
  `is_delete` tinyint(1) NOT NULL DEFAULT 0,
  `date_expired` char(14) NOT NULL,
  `date_publish` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `tmp_analytic_trueread_history`
--

CREATE TABLE `tmp_analytic_trueread_history` (
  `id` int(255) NOT NULL,
  `code` varchar(35) NOT NULL,
  `users_id` int(255) NOT NULL,
  `apps_id` int(5) NOT NULL,
  `ip_address` varchar(45) NOT NULL,
  `data` varchar(150) NOT NULL,
  `date_ymd` char(10) NOT NULL,
  `date_his` char(8) NOT NULL,
  `date_order` char(14) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

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

CREATE TABLE `users` (
  `id` int(255) NOT NULL,
  `username` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone_code` int(5) NOT NULL DEFAULT 62,
  `phone` varchar(100) NOT NULL DEFAULT '',
  `password_type` int(1) NOT NULL,
  `password` varchar(255) NOT NULL,
  `uid_klikfilm` varchar(100) NOT NULL DEFAULT '',
  `validate_email` int(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `users_achievement`
--

CREATE TABLE `users_achievement` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `achievement_id` int(255) NOT NULL,
  `level` int(2) NOT NULL,
  `date_publish` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `users_address_book`
--

CREATE TABLE `users_address_book` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `recipient_name` varchar(60) NOT NULL DEFAULT '',
  `recipient_phone` varchar(50) NOT NULL DEFAULT '',
  `province_id` int(100) NOT NULL,
  `city_id` int(100) NOT NULL,
  `district_id` int(100) NOT NULL,
  `village_id` int(100) NOT NULL,
  `postal_code` varchar(5) NOT NULL,
  `address` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `users_behavior_work_genre`
--

CREATE TABLE `users_behavior_work_genre` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `genre_id` int(255) NOT NULL,
  `count` int(100) NOT NULL DEFAULT 1,
  `date_yw` int(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `users_connect_providers`
--

CREATE TABLE `users_connect_providers` (
  `id` int(50) NOT NULL,
  `users_id` int(255) NOT NULL,
  `data_id` int(50) NOT NULL,
  `msisdn` char(15) NOT NULL,
  `is_primary` tinyint(1) NOT NULL DEFAULT 0,
  `is_disconnect` tinyint(1) NOT NULL DEFAULT 0,
  `date_login` varchar(20) NOT NULL,
  `date_check` varchar(20) NOT NULL,
  `date_publish` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `users_contactus`
--

CREATE TABLE `users_contactus` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL DEFAULT 0,
  `email` varchar(255) NOT NULL,
  `content` varchar(5000) NOT NULL DEFAULT '',
  `date_publish` varchar(255) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `users_content_history`
--

CREATE TABLE `users_content_history` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `content_type` char(7) NOT NULL,
  `content_id` int(255) NOT NULL,
  `date_order` bigint(15) NOT NULL,
  `date_update` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `users_content_purchased`
--

CREATE TABLE `users_content_purchased` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `content_type` char(5) NOT NULL DEFAULT '',
  `content_id` int(255) NOT NULL,
  `date_order` bigint(15) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `users_data_details`
--

CREATE TABLE `users_data_details` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `date_join` varchar(10) NOT NULL DEFAULT '',
  `time_join` char(8) NOT NULL DEFAULT '00:00:00',
  `introduction` int(1) NOT NULL DEFAULT 0,
  `koin` double NOT NULL DEFAULT 0,
  `is_qrcode` int(1) NOT NULL DEFAULT 0,
  `count_kunci` float NOT NULL DEFAULT 0,
  `count_kunci_using` float NOT NULL DEFAULT 0,
  `mission_completed` int(10) NOT NULL DEFAULT 0,
  `count_followers` int(255) NOT NULL DEFAULT 0,
  `count_followings` int(255) NOT NULL DEFAULT 0,
  `date_recommended` varchar(10) NOT NULL DEFAULT '',
  `date_online` bigint(20) NOT NULL DEFAULT 0,
  `date_notification` bigint(20) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `users_data_identity`
--

CREATE TABLE `users_data_identity` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `photo` varchar(255) NOT NULL DEFAULT '',
  `cover` varchar(255) NOT NULL DEFAULT '',
  `realname` varchar(255) NOT NULL DEFAULT 'NO-NAME',
  `about` varchar(10000) NOT NULL DEFAULT '',
  `gender` int(1) NOT NULL DEFAULT 0,
  `birthday` varchar(255) NOT NULL DEFAULT '',
  `account_instagram` varchar(100) NOT NULL DEFAULT '',
  `account_tiktok` varchar(100) NOT NULL DEFAULT '',
  `account_x` varchar(100) NOT NULL DEFAULT '',
  `writter` int(1) NOT NULL DEFAULT 0,
  `verify` int(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `users_data_setup`
--

CREATE TABLE `users_data_setup` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `timeline_status_hot` int(1) NOT NULL DEFAULT 1,
  `timeline_status_topusers` int(1) NOT NULL DEFAULT 1,
  `send_message` int(1) NOT NULL DEFAULT 1,
  `profile_show` int(1) NOT NULL DEFAULT 1,
  `last_seen` int(1) NOT NULL DEFAULT 1,
  `chat_last_seen` int(1) NOT NULL DEFAULT 1,
  `topusers_show` int(1) NOT NULL DEFAULT 1,
  `dark_mode` int(1) DEFAULT 0,
  `theme_color_id` int(15) NOT NULL DEFAULT 0,
  `theme_layout_id` int(15) NOT NULL DEFAULT 0,
  `theme_background_id` int(15) NOT NULL DEFAULT 0,
  `theme_logo_id` int(15) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `users_deactivate`
--

CREATE TABLE `users_deactivate` (
  `id` int(15) NOT NULL,
  `users_id` int(255) NOT NULL,
  `reason` varchar(1000) NOT NULL,
  `date_publish` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `users_favorite`
--

CREATE TABLE `users_favorite` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `content_type` char(7) NOT NULL,
  `content_id` int(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `users_history_ai`
--

CREATE TABLE `users_history_ai` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `from_page` char(15) NOT NULL COMMENT 'PROFILEPHOTO, PROFILECOVER',
  `file` varchar(150) NOT NULL,
  `kunci` float NOT NULL DEFAULT 0,
  `date_publish` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `users_sticker_lastused`
--

CREATE TABLE `users_sticker_lastused` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `sticker_content_id` int(255) NOT NULL,
  `date_order` bigint(15) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `users_sticker_purchased`
--

CREATE TABLE `users_sticker_purchased` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `sticker_id` int(255) NOT NULL,
  `koin` int(10) NOT NULL DEFAULT 0,
  `date_order` bigint(15) NOT NULL DEFAULT 0,
  `date_publish` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `users_work_lastseen`
--

CREATE TABLE `users_work_lastseen` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `content_type` char(7) NOT NULL,
  `content_id` int(255) NOT NULL,
  `date_order` bigint(15) NOT NULL,
  `date_update` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `users_work_likes`
--

CREATE TABLE `users_work_likes` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `content_data_id` int(255) NOT NULL,
  `part_id` int(255) NOT NULL,
  `date_publish` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `voucher_content`
--

CREATE TABLE `voucher_content` (
  `id` int(255) NOT NULL,
  `code` char(50) NOT NULL,
  `type` char(6) NOT NULL COMMENT 'multi, single',
  `users_id` int(255) NOT NULL DEFAULT 0 COMMENT '0 untuk voucher dari admin kwikku',
  `title` varchar(70) NOT NULL,
  `description` varchar(150) NOT NULL,
  `promo_type` varchar(15) NOT NULL COMMENT 'all_percent, all_price, item_percent, item_price, dynamic_kwikku, shipping',
  `promo_value` int(50) NOT NULL DEFAULT 0,
  `price_min` int(50) NOT NULL DEFAULT 0,
  `price_max` int(50) NOT NULL DEFAULT 0,
  `limit_usage` int(25) NOT NULL DEFAULT 0 COMMENT '0 untuk unlimited sampai expired',
  `count_usage` int(25) NOT NULL DEFAULT 0,
  `avail_for` tinyint(1) NOT NULL COMMENT '0: all, 1: digital, 2: fisik',
  `setup_age` varchar(25) NOT NULL DEFAULT '' COMMENT 'contoh penggunaan: up-7, down-7. 7 adalah 7 hari',
  `is_realprice` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Apabila bernilai 1 maka harga potongan juga dibebankan ke Publisher, apabila 0 maka hanya kwikku yang dibebankan',
  `is_disabledsharing` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Mematikan sharing persen dengan Kwikku',
  `is_active` tinyint(1) NOT NULL DEFAULT 0,
  `date_start` varchar(10) NOT NULL,
  `date_expired` varchar(10) NOT NULL,
  `date_publish` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `voucher_content_use`
--

CREATE TABLE `voucher_content_use` (
  `id` int(100) NOT NULL,
  `voucher_id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `invoice_id` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `voucher_internal`
--

CREATE TABLE `voucher_internal` (
  `id` int(25) NOT NULL,
  `code` varchar(25) NOT NULL,
  `users_id` int(255) NOT NULL,
  `voucher_type` char(15) NOT NULL COMMENT 'FREEREAD, WORKPURCHASED',
  `type_usage` char(10) NOT NULL COMMENT 'MULTIPLE, ONETIME',
  `count_usage` int(5) NOT NULL COMMENT 'Batas limit untuk nilai "type_usage" = MULTIPLE, kalau ONETIME di isi dengan 0',
  `data_help` varchar(150) NOT NULL DEFAULT '',
  `price` int(10) NOT NULL DEFAULT 0,
  `is_show` tinyint(1) NOT NULL DEFAULT 1,
  `date_start` char(15) NOT NULL,
  `date_end` char(15) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `voucher_internal_users`
--

CREATE TABLE `voucher_internal_users` (
  `id` int(100) NOT NULL,
  `voucher_internal_id` int(25) NOT NULL,
  `users_id` int(255) NOT NULL,
  `date_expired` char(14) NOT NULL,
  `date_publish` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `voucher_internal_works`
--

CREATE TABLE `voucher_internal_works` (
  `id` int(25) NOT NULL,
  `voucher_internal_id` int(25) NOT NULL,
  `content_data_id` int(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `voucher_users`
--

CREATE TABLE `voucher_users` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `voucher_id` int(255) NOT NULL,
  `date_publish` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `wallet_history`
--

CREATE TABLE `wallet_history` (
  `id` int(255) NOT NULL,
  `type` int(1) NOT NULL DEFAULT 1,
  `users_id` int(255) NOT NULL,
  `transaction_id` int(255) NOT NULL,
  `content_type` char(15) NOT NULL DEFAULT '',
  `content_data1` int(255) NOT NULL DEFAULT 0,
  `content_data2` int(255) NOT NULL DEFAULT 0,
  `payment_type` char(5) NOT NULL DEFAULT '',
  `payment_price` int(100) NOT NULL DEFAULT 0,
  `content` char(255) NOT NULL DEFAULT '',
  `koin` int(255) NOT NULL DEFAULT 0,
  `status` int(1) NOT NULL,
  `date_ymd` char(10) NOT NULL,
  `date_publish` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `wallet_kunci_package`
--

CREATE TABLE `wallet_kunci_package` (
  `id` int(255) NOT NULL,
  `position` int(1) NOT NULL,
  `code_playstore` char(10) NOT NULL DEFAULT '',
  `code_ios` char(10) NOT NULL DEFAULT '',
  `image` varchar(20) NOT NULL DEFAULT '',
  `title` varchar(255) NOT NULL,
  `info` varchar(500) NOT NULL DEFAULT '',
  `kunci` int(50) NOT NULL DEFAULT 0,
  `discount` int(10) NOT NULL DEFAULT 0,
  `price` int(10) NOT NULL DEFAULT 0,
  `price_telkomsel` int(10) DEFAULT 0,
  `info_telkomsel` varchar(150) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `wallet_payment_telco`
--

CREATE TABLE `wallet_payment_telco` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `wallet_kunci_id` int(50) NOT NULL,
  `transaction_code` varchar(50) NOT NULL,
  `msisdn` varchar(20) NOT NULL,
  `is_completed` tinyint(1) NOT NULL DEFAULT 0,
  `date_transaction` varchar(20) NOT NULL,
  `date_publish` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `wallet_record_payment`
--

CREATE TABLE `wallet_record_payment` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `content_type` char(5) NOT NULL,
  `content_id` int(255) NOT NULL,
  `data` varchar(255) NOT NULL DEFAULT '0',
  `price` char(100) NOT NULL,
  `date_publish` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `wallet_record_payment_kunci`
--

CREATE TABLE `wallet_record_payment_kunci` (
  `id` int(255) NOT NULL,
  `apps_id` int(50) NOT NULL DEFAULT 0,
  `users_id` int(255) NOT NULL,
  `action` char(3) NOT NULL COMMENT 'IN, OUT',
  `content` varchar(150) NOT NULL,
  `kunci` float NOT NULL,
  `invoice_id` varchar(255) NOT NULL DEFAULT '',
  `date_publish` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `work_achievement`
--

CREATE TABLE `work_achievement` (
  `id` int(255) NOT NULL,
  `content_data_id` int(255) NOT NULL,
  `achievement_work_id` int(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `work_bookmark`
--

CREATE TABLE `work_bookmark` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `content_data_id` int(255) NOT NULL,
  `part_id` int(255) NOT NULL,
  `date_update` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `work_category_exclusive`
--

CREATE TABLE `work_category_exclusive` (
  `id` int(255) NOT NULL,
  `category_exclusive_id` int(50) NOT NULL,
  `content_data_id` int(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `work_choice`
--

CREATE TABLE `work_choice` (
  `id` int(100) NOT NULL,
  `content_data_id` int(255) NOT NULL,
  `is_show` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `work_connect_film`
--

CREATE TABLE `work_connect_film` (
  `id` int(50) NOT NULL,
  `content_data_id` int(255) NOT NULL,
  `film_id` int(255) NOT NULL,
  `cover` varchar(50) DEFAULT '',
  `title` varchar(50) DEFAULT '',
  `link_wikipedia` varchar(150) DEFAULT '',
  `from_kwikku` int(1) NOT NULL DEFAULT 0,
  `status_production` char(10) NOT NULL DEFAULT '' COMMENT 'progress, production'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `work_connect_program`
--

CREATE TABLE `work_connect_program` (
  `id` int(255) NOT NULL,
  `content_data_id` int(255) NOT NULL,
  `program_id` int(20) NOT NULL,
  `date_order` bigint(15) NOT NULL,
  `date_update` varchar(20) NOT NULL,
  `date_publish` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `work_data_category_exclusive`
--

CREATE TABLE `work_data_category_exclusive` (
  `id` int(5) NOT NULL,
  `group_code` int(2) NOT NULL,
  `name` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `work_data_character`
--

CREATE TABLE `work_data_character` (
  `id` int(255) NOT NULL,
  `position` int(3) NOT NULL,
  `content_data_id` int(255) NOT NULL,
  `data_avatar` varchar(50) NOT NULL DEFAULT '',
  `name` varchar(55) NOT NULL,
  `gender` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `work_data_genre`
--

CREATE TABLE `work_data_genre` (
  `id` int(50) NOT NULL,
  `slug` char(50) NOT NULL,
  `icon` char(30) NOT NULL,
  `title` char(255) NOT NULL,
  `tagline` varchar(150) NOT NULL,
  `is_novel` tinyint(1) NOT NULL DEFAULT 0,
  `is_script` tinyint(1) NOT NULL DEFAULT 0,
  `is_comic` tinyint(1) NOT NULL DEFAULT 0,
  `is_flash` tinyint(1) NOT NULL DEFAULT 0,
  `is_short` tinyint(1) NOT NULL DEFAULT 0,
  `is_poetry` tinyint(1) NOT NULL DEFAULT 0,
  `is_artwork` tinyint(1) NOT NULL DEFAULT 0,
  `is_market` tinyint(1) NOT NULL DEFAULT 0,
  `is_show` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `work_data_genre_character`
--

CREATE TABLE `work_data_genre_character` (
  `id` int(255) NOT NULL,
  `slug` char(255) NOT NULL,
  `icon` char(255) NOT NULL,
  `title` char(255) NOT NULL,
  `info` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `work_data_package`
--

CREATE TABLE `work_data_package` (
  `id` int(50) NOT NULL,
  `position` int(5) NOT NULL DEFAULT 1,
  `content_type` char(7) NOT NULL,
  `code` int(15) NOT NULL,
  `icon` varchar(50) NOT NULL,
  `title` varchar(20) NOT NULL,
  `description` varchar(200) NOT NULL,
  `is_cart` int(1) NOT NULL DEFAULT 0,
  `is_offline` int(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `work_data_public`
--

CREATE TABLE `work_data_public` (
  `id` int(255) NOT NULL,
  `content_data_id` int(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `work_data_setup`
--

CREATE TABLE `work_data_setup` (
  `id` int(255) NOT NULL,
  `content_data_id` int(255) NOT NULL,
  `is_audiobook_disabled` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `work_linked`
--

CREATE TABLE `work_linked` (
  `id` int(255) NOT NULL,
  `content_data_id` int(255) NOT NULL,
  `content_data_id_to` int(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `work_lock`
--

CREATE TABLE `work_lock` (
  `id` int(255) NOT NULL,
  `lock_type` char(11) NOT NULL COMMENT 'COMPETITION',
  `lock_data` int(255) NOT NULL,
  `content_data_id` int(255) NOT NULL,
  `part_open` int(5) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `work_recommended`
--

CREATE TABLE `work_recommended` (
  `id` int(50) NOT NULL,
  `content_data_id` int(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `work_review`
--

CREATE TABLE `work_review` (
  `id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `content_data_id` int(255) NOT NULL,
  `star` int(1) NOT NULL DEFAULT 0,
  `content` varchar(1000) NOT NULL,
  `is_anonim` tinyint(1) NOT NULL DEFAULT 0,
  `date_order` bigint(15) NOT NULL,
  `date_publish` varchar(20) NOT NULL,
  `date_update` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `work_review_count`
--

CREATE TABLE `work_review_count` (
  `id` int(255) NOT NULL,
  `content_data_id` int(255) NOT NULL,
  `star` float NOT NULL DEFAULT 0,
  `total` int(10) NOT NULL DEFAULT 0,
  `star_1` int(10) NOT NULL DEFAULT 0,
  `star_2` int(10) NOT NULL DEFAULT 0,
  `star_3` int(10) NOT NULL DEFAULT 0,
  `star_4` int(10) NOT NULL DEFAULT 0,
  `star_5` int(10) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `work_review_reply`
--

CREATE TABLE `work_review_reply` (
  `id` int(100) NOT NULL,
  `review_id` int(255) NOT NULL,
  `users_id` int(255) NOT NULL,
  `content` varchar(1000) NOT NULL,
  `date_publish` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `work_tags`
--

CREATE TABLE `work_tags` (
  `id` int(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `count` int(255) NOT NULL DEFAULT 0,
  `date_order` bigint(15) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `work_tags_data`
--

CREATE TABLE `work_tags_data` (
  `id` int(255) NOT NULL,
  `tags_id` int(255) NOT NULL,
  `content_data_id` int(255) NOT NULL,
  `date_publish` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `work_takedown`
--

CREATE TABLE `work_takedown` (
  `id` int(50) NOT NULL,
  `content_data_id` int(255) NOT NULL,
  `date_publish` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `work_trending`
--

CREATE TABLE `work_trending` (
  `id` int(255) NOT NULL,
  `content_data_id` int(255) NOT NULL,
  `count` int(10) NOT NULL DEFAULT 1,
  `date_trending` int(8) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `work_trending_history`
--

CREATE TABLE `work_trending_history` (
  `id` int(255) NOT NULL,
  `content_data_id` int(255) NOT NULL,
  `count` int(10) NOT NULL,
  `date_trending` int(8) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `work_version`
--

CREATE TABLE `work_version` (
  `id` int(255) NOT NULL,
  `content_data_id` int(255) NOT NULL,
  `version` int(15) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `academy_class`
--
ALTER TABLE `academy_class`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `slug` (`slug`),
  ADD KEY `type` (`type`),
  ADD KEY `date_start_code` (`date_start_code`),
  ADD KEY `is_show` (`is_show`),
  ADD KEY `date_end_code` (`date_end_code`),
  ADD KEY `category_data_id` (`category_data_id`),
  ADD KEY `position` (`position`),
  ADD KEY `is_listed` (`is_listed`);

--
-- Indexes for table `academy_class_ask`
--
ALTER TABLE `academy_class_ask`
  ADD PRIMARY KEY (`id`),
  ADD KEY `class_id` (`class_id`),
  ADD KEY `users_id` (`users_id`);

--
-- Indexes for table `academy_class_ask_answer`
--
ALTER TABLE `academy_class_ask_answer`
  ADD PRIMARY KEY (`id`),
  ADD KEY `ask_id` (`ask_id`),
  ADD KEY `class_id` (`class_id`),
  ADD KEY `users_id` (`users_id`);

--
-- Indexes for table `academy_class_faq`
--
ALTER TABLE `academy_class_faq`
  ADD PRIMARY KEY (`id`),
  ADD KEY `class_id` (`class_id`);

--
-- Indexes for table `academy_class_file`
--
ALTER TABLE `academy_class_file`
  ADD PRIMARY KEY (`id`),
  ADD KEY `class_id` (`class_id`),
  ADD KEY `position` (`position`);

--
-- Indexes for table `academy_class_file_content`
--
ALTER TABLE `academy_class_file_content`
  ADD PRIMARY KEY (`id`),
  ADD KEY `topic_id` (`topic_id`),
  ADD KEY `position` (`position`),
  ADD KEY `users_id` (`users_id`);

--
-- Indexes for table `academy_class_member`
--
ALTER TABLE `academy_class_member`
  ADD PRIMARY KEY (`id`),
  ADD KEY `class_id` (`class_id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `is_banned` (`is_banned`);

--
-- Indexes for table `academy_class_member_schedule`
--
ALTER TABLE `academy_class_member_schedule`
  ADD PRIMARY KEY (`id`),
  ADD KEY `class_id` (`class_id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `schedule_id` (`schedule_id`);

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

--
-- Indexes for table `academy_class_record`
--
ALTER TABLE `academy_class_record`
  ADD PRIMARY KEY (`id`),
  ADD KEY `class_id` (`class_id`),
  ADD KEY `position` (`position`);

--
-- Indexes for table `academy_class_review`
--
ALTER TABLE `academy_class_review`
  ADD PRIMARY KEY (`id`),
  ADD KEY `class_id` (`class_id`),
  ADD KEY `users_id` (`users_id`);

--
-- Indexes for table `academy_class_room`
--
ALTER TABLE `academy_class_room`
  ADD PRIMARY KEY (`id`),
  ADD KEY `class_id` (`class_id`),
  ADD KEY `teacher_id` (`teacher_id`),
  ADD KEY `is_show` (`is_show`);

--
-- Indexes for table `academy_class_schedule`
--
ALTER TABLE `academy_class_schedule`
  ADD PRIMARY KEY (`id`),
  ADD KEY `class_id` (`class_id`),
  ADD KEY `position` (`position`),
  ADD KEY `date_start` (`date_start`),
  ADD KEY `date_order` (`date_order`),
  ADD KEY `status` (`status`),
  ADD KEY `users_id` (`users_id`);

--
-- Indexes for table `academy_class_schedule_member`
--
ALTER TABLE `academy_class_schedule_member`
  ADD PRIMARY KEY (`id`),
  ADD KEY `class_id` (`class_id`),
  ADD KEY `schedule_id` (`schedule_id`),
  ADD KEY `users_id` (`users_id`);

--
-- Indexes for table `academy_class_schedule_part`
--
ALTER TABLE `academy_class_schedule_part`
  ADD PRIMARY KEY (`id`),
  ADD KEY `schedule_id` (`schedule_id`),
  ADD KEY `date_start` (`date_start`);

--
-- Indexes for table `academy_mentor`
--
ALTER TABLE `academy_mentor`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_id` (`users_id`),
  ADD KEY `is_active` (`is_active`);

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

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

--
-- Indexes for table `admin_banned_ip`
--
ALTER TABLE `admin_banned_ip`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `ip_address` (`ip_address`),
  ADD KEY `date_expired` (`date_expired`);

--
-- Indexes for table `admin_banned_users`
--
ALTER TABLE `admin_banned_users`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`);

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

--
-- Indexes for table `admin_banned_word_users`
--
ALTER TABLE `admin_banned_word_users`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `banned_word_id` (`banned_word_id`),
  ADD KEY `date_yw` (`date_yw`),
  ADD KEY `is_suspect` (`is_suspect`);

--
-- Indexes for table `admin_banned_word_users_history`
--
ALTER TABLE `admin_banned_word_users_history`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `banned_word_id` (`banned_word_id`),
  ADD KEY `banned_word_users_id` (`banned_word_users_id`);

--
-- Indexes for table `admin_comparison_script_part`
--
ALTER TABLE `admin_comparison_script_part`
  ADD PRIMARY KEY (`id`),
  ADD KEY `part_id` (`part_id`);

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

--
-- Indexes for table `admin_competition_selection_curator`
--
ALTER TABLE `admin_competition_selection_curator`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `cs_id` (`cs_id`);

--
-- Indexes for table `admin_curator_curation_history`
--
ALTER TABLE `admin_curator_curation_history`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `part_id` (`part_id`),
  ADD KEY `date_ymd` (`date_ymd`),
  ADD KEY `content_data_id` (`content_data_id`);

--
-- Indexes for table `admin_curator_curation_timeline`
--
ALTER TABLE `admin_curator_curation_timeline`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `content_data_id` (`content_data_id`);

--
-- Indexes for table `admin_curator_curation_total`
--
ALTER TABLE `admin_curator_curation_total`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `date_ym` (`date_ym`),
  ADD KEY `date_ymd` (`date_ymd`);

--
-- Indexes for table `admin_director_content`
--
ALTER TABLE `admin_director_content`
  ADD PRIMARY KEY (`id`),
  ADD KEY `content_type` (`content_type`),
  ADD KEY `content_id` (`content_id`),
  ADD KEY `date_order` (`date_order`),
  ADD KEY `point_trending` (`point_trending`);

--
-- Indexes for table `admin_director_content_pinned`
--
ALTER TABLE `admin_director_content_pinned`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `content_type` (`content_type`),
  ADD KEY `content_id` (`content_id`);

--
-- Indexes for table `admin_event_director_select`
--
ALTER TABLE `admin_event_director_select`
  ADD PRIMARY KEY (`id`),
  ADD KEY `type` (`type`),
  ADD KEY `event_content_id` (`event_content_id`),
  ADD KEY `users_id` (`users_id`);

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

--
-- Indexes for table `admin_jury_content`
--
ALTER TABLE `admin_jury_content`
  ADD PRIMARY KEY (`id`),
  ADD KEY `competition_id` (`competition_id`),
  ADD KEY `content_data_id` (`content_data_id`);

--
-- Indexes for table `admin_jury_content_pinned`
--
ALTER TABLE `admin_jury_content_pinned`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `jury_content_id` (`jury_content_id`);

--
-- Indexes for table `admin_mentor_content`
--
ALTER TABLE `admin_mentor_content`
  ADD PRIMARY KEY (`id`),
  ADD KEY `content_type` (`content_type`),
  ADD KEY `content_id` (`content_id`);

--
-- Indexes for table `admin_mentor_content_pinned`
--
ALTER TABLE `admin_mentor_content_pinned`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `content_id` (`content_id`);

--
-- Indexes for table `admin_privateuser_content`
--
ALTER TABLE `admin_privateuser_content`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`);

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

--
-- Indexes for table `admin_push_users`
--
ALTER TABLE `admin_push_users`
  ADD PRIMARY KEY (`id`),
  ADD KEY `admin_notif_id` (`admin_notif_id`),
  ADD KEY `login_token_id` (`login_token_id`);

--
-- Indexes for table `admin_submit`
--
ALTER TABLE `admin_submit`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `content_data_id` (`content_data_id`),
  ADD KEY `users_id_curator` (`users_id_curator`),
  ADD KEY `status` (`status`),
  ADD KEY `date_order` (`date_order`),
  ADD KEY `is_cancel` (`is_cancel`),
  ADD KEY `date_chat` (`date_chat`),
  ADD KEY `is_updatepart` (`is_updatepart`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `date_order_work` (`date_order_work`),
  ADD KEY `date_order_work_part` (`date_order_work_part`);

--
-- Indexes for table `admin_submit_change`
--
ALTER TABLE `admin_submit_change`
  ADD PRIMARY KEY (`id`),
  ADD KEY `is_creator_read` (`is_creator_read`),
  ADD KEY `is_decline` (`is_decline`),
  ADD KEY `content_data_id` (`content_data_id`);

--
-- Indexes for table `admin_submit_history`
--
ALTER TABLE `admin_submit_history`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `content_data_id` (`content_data_id`);

--
-- Indexes for table `admin_submit_revision`
--
ALTER TABLE `admin_submit_revision`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `is_read` (`is_read`),
  ADD KEY `type_revision` (`type_revision`),
  ADD KEY `part_id` (`part_id`),
  ADD KEY `content_data_id` (`content_data_id`);

--
-- Indexes for table `admin_submit_status_approve`
--
ALTER TABLE `admin_submit_status_approve`
  ADD PRIMARY KEY (`id`),
  ADD KEY `part_id` (`part_id`),
  ADD KEY `content_data_id` (`content_data_id`);

--
-- Indexes for table `admin_submit_work`
--
ALTER TABLE `admin_submit_work`
  ADD PRIMARY KEY (`id`),
  ADD KEY `content_data_id` (`content_data_id`);

--
-- Indexes for table `admin_users`
--
ALTER TABLE `admin_users`
  ADD PRIMARY KEY (`id`),
  ADD KEY `free_access` (`free_access`);

--
-- Indexes for table `admin_users_curator_total`
--
ALTER TABLE `admin_users_curator_total`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `date_ym` (`date_ym`),
  ADD KEY `date_ymd` (`date_ymd`);

--
-- Indexes for table `admin_users_history_curation`
--
ALTER TABLE `admin_users_history_curation`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `content_type` (`content_type`),
  ADD KEY `date_y` (`date_y`),
  ADD KEY `date_ym` (`date_ym`),
  ADD KEY `date_ymd` (`date_ymd`),
  ADD KEY `is_path` (`is_path`);

--
-- Indexes for table `admin_users_insider`
--
ALTER TABLE `admin_users_insider`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_id` (`users_id`),
  ADD KEY `is_active` (`is_active`);

--
-- Indexes for table `admin_work_backup_part`
--
ALTER TABLE `admin_work_backup_part`
  ADD PRIMARY KEY (`id`),
  ADD KEY `part_id` (`part_id`),
  ADD KEY `date_expired` (`date_expired`),
  ADD KEY `content_data_id` (`content_data_id`);

--
-- Indexes for table `admin_work_history`
--
ALTER TABLE `admin_work_history`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `content_data_id` (`content_data_id`),
  ADD KEY `date_order` (`date_order`);

--
-- Indexes for table `admin_work_part_change`
--
ALTER TABLE `admin_work_part_change`
  ADD PRIMARY KEY (`id`),
  ADD KEY `part_id` (`part_id`),
  ADD KEY `content_data_id` (`content_data_id`),
  ADD KEY `is_read` (`is_read`);

--
-- Indexes for table `admin_work_part_change_content`
--
ALTER TABLE `admin_work_part_change_content`
  ADD PRIMARY KEY (`id`),
  ADD KEY `part_id` (`part_id`),
  ADD KEY `code` (`code`),
  ADD KEY `content_data_id` (`content_data_id`);

--
-- Indexes for table `admin_work_pinned`
--
ALTER TABLE `admin_work_pinned`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `date_order` (`date_order`),
  ADD KEY `code` (`code`),
  ADD KEY `content_data_id` (`content_data_id`);

--
-- Indexes for table `admin_work_previous`
--
ALTER TABLE `admin_work_previous`
  ADD PRIMARY KEY (`id`),
  ADD KEY `content_type` (`content_type`),
  ADD KEY `content_id` (`content_id`),
  ADD KEY `part_id` (`part_id`),
  ADD KEY `date_order` (`date_order`);

--
-- Indexes for table `ai_style`
--
ALTER TABLE `ai_style`
  ADD PRIMARY KEY (`id`),
  ADD KEY `is_show` (`is_show`),
  ADD KEY `name` (`name`);

--
-- Indexes for table `analytic_visitor_work`
--
ALTER TABLE `analytic_visitor_work`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `content_type` (`content_type`),
  ADD KEY `content_id` (`content_id`),
  ADD KEY `order_ym` (`order_ym`),
  ADD KEY `date_ymd` (`date_ymd`);

--
-- Indexes for table `analytic_work_trueread`
--
ALTER TABLE `analytic_work_trueread`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `part_id` (`part_id`),
  ADD KEY `is_completed` (`is_completed`),
  ADD KEY `content_data_id` (`content_data_id`);

--
-- Indexes for table `boost`
--
ALTER TABLE `boost`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_id` (`users_id`),
  ADD KEY `date_order` (`date_order`);

--
-- Indexes for table `boost_content`
--
ALTER TABLE `boost_content`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `date_order` (`date_order`),
  ADD KEY `content_data_id` (`content_data_id`);

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

--
-- Indexes for table `certificate_members`
--
ALTER TABLE `certificate_members`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `certificate_number` (`certificate_number`),
  ADD KEY `certificate_id` (`certificate_id`),
  ADD KEY `users_id` (`users_id`);

--
-- Indexes for table `chat_content`
--
ALTER TABLE `chat_content`
  ADD PRIMARY KEY (`id`),
  ADD KEY `code` (`code`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `content_type` (`content_type`);

--
-- Indexes for table `chat_group`
--
ALTER TABLE `chat_group`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `code` (`code`),
  ADD KEY `users_id` (`users_id`);

--
-- Indexes for table `chat_group_connect`
--
ALTER TABLE `chat_group_connect`
  ADD PRIMARY KEY (`id`),
  ADD KEY `type_connect` (`type_connect`),
  ADD KEY `chat_group_id` (`chat_group_id`),
  ADD KEY `connect_id` (`connect_id`);

--
-- Indexes for table `chat_users`
--
ALTER TABLE `chat_users`
  ADD PRIMARY KEY (`id`),
  ADD KEY `code` (`code`),
  ADD KEY `date_order` (`date_order`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `content_type` (`content_type`),
  ADD KEY `content_id` (`content_id`);

--
-- Indexes for table `comment_content`
--
ALTER TABLE `comment_content`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `users_id_creator` (`users_id_creator`),
  ADD KEY `content_type` (`content_type`),
  ADD KEY `content_id` (`content_id`),
  ADD KEY `part_id` (`part_id`),
  ADD KEY `index_id` (`index_id`),
  ADD KEY `is_read` (`is_read`),
  ADD KEY `is_reply` (`is_reply`);

--
-- Indexes for table `comment_content_reply`
--
ALTER TABLE `comment_content_reply`
  ADD PRIMARY KEY (`id`),
  ADD KEY `comment_id` (`comment_id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `is_read` (`is_read`),
  ADD KEY `is_reply` (`is_reply`);

--
-- Indexes for table `comment_count_paragraph`
--
ALTER TABLE `comment_count_paragraph`
  ADD PRIMARY KEY (`id`),
  ADD KEY `content_data_id` (`content_data_id`),
  ADD KEY `part_id` (`part_id`),
  ADD KEY `index_id` (`index_id`);

--
-- Indexes for table `competition`
--
ALTER TABLE `competition`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `type` (`type`),
  ADD KEY `content_id` (`content_id`);

--
-- Indexes for table `competition_detail`
--
ALTER TABLE `competition_detail`
  ADD PRIMARY KEY (`id`),
  ADD KEY `is_show` (`is_show`),
  ADD KEY `status` (`status`);

--
-- Indexes for table `competition_detail_user`
--
ALTER TABLE `competition_detail_user`
  ADD PRIMARY KEY (`id`),
  ADD KEY `competition_id` (`competition_id`),
  ADD KEY `users_id` (`users_id`);

--
-- Indexes for table `competition_detail_winner_section`
--
ALTER TABLE `competition_detail_winner_section`
  ADD PRIMARY KEY (`id`),
  ADD KEY `competition_id` (`competition_id`),
  ADD KEY `position` (`position`);

--
-- Indexes for table `competition_voting`
--
ALTER TABLE `competition_voting`
  ADD PRIMARY KEY (`id`),
  ADD KEY `competition_id` (`competition_id`),
  ADD KEY `content_type` (`content_type`),
  ADD KEY `content_id` (`content_id`);

--
-- Indexes for table `competition_voting_user`
--
ALTER TABLE `competition_voting_user`
  ADD PRIMARY KEY (`id`),
  ADD KEY `competition_voting_id` (`competition_voting_id`),
  ADD KEY `users_id` (`users_id`);

--
-- Indexes for table `competition_work`
--
ALTER TABLE `competition_work`
  ADD PRIMARY KEY (`id`),
  ADD KEY `competition_id` (`competition_id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `date_order` (`date_order`),
  ADD KEY `is_submit` (`is_submit`);

--
-- Indexes for table `competition_work_winners`
--
ALTER TABLE `competition_work_winners`
  ADD PRIMARY KEY (`id`),
  ADD KEY `competition_id` (`competition_id`),
  ADD KEY `order_position` (`order_position`),
  ADD KEY `winner_section_id` (`winner_section_id`);

--
-- Indexes for table `connect_block`
--
ALTER TABLE `connect_block`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id_to` (`users_id_to`),
  ADD KEY `users_id_from` (`users_id_from`);

--
-- Indexes for table `connect_follow`
--
ALTER TABLE `connect_follow`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id_from` (`users_id_from`),
  ADD KEY `users_id_to` (`users_id_to`);

--
-- Indexes for table `content_data`
--
ALTER TABLE `content_data`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `slug` (`slug`),
  ADD KEY `content_type` (`content_type`),
  ADD KEY `old_content_type` (`old_content_type`),
  ADD KEY `old_content_id` (`old_content_id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `title` (`title`),
  ADD KEY `is_publish` (`is_publish`),
  ADD KEY `is_curation` (`is_curation`),
  ADD KEY `is_takedown` (`is_takedown`),
  ADD KEY `is_finish` (`is_finish`),
  ADD KEY `is_protected` (`is_protected`),
  ADD KEY `monetize_type` (`monetize_type`),
  ADD KEY `date_order` (`date_order`),
  ADD KEY `old_slug` (`old_slug`),
  ADD KEY `genre_id` (`genre_id`),
  ADD KEY `count_part` (`count_part`),
  ADD KEY `count_view` (`count_view`),
  ADD KEY `open_part` (`open_part`);

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

--
-- Indexes for table `content_data_comic_part`
--
ALTER TABLE `content_data_comic_part`
  ADD PRIMARY KEY (`id`),
  ADD KEY `content_data_id` (`content_data_id`),
  ADD KEY `is_curation` (`is_curation`),
  ADD KEY `is_takedown` (`is_takedown`),
  ADD KEY `date_ymd` (`date_ymd`),
  ADD KEY `position` (`position`);

--
-- Indexes for table `content_data_comic_part_data`
--
ALTER TABLE `content_data_comic_part_data`
  ADD PRIMARY KEY (`id`),
  ADD KEY `comic_part_id` (`comic_part_id`),
  ADD KEY `position` (`position`);

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

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

--
-- Indexes for table `content_data_novel_part`
--
ALTER TABLE `content_data_novel_part`
  ADD PRIMARY KEY (`id`),
  ADD KEY `content_data_id` (`content_data_id`),
  ADD KEY `position` (`position`),
  ADD KEY `is_curation` (`is_curation`),
  ADD KEY `is_takedown` (`is_takedown`),
  ADD KEY `date_ymd` (`date_ymd`);

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

--
-- Indexes for table `content_data_script_allowed`
--
ALTER TABLE `content_data_script_allowed`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`);

--
-- Indexes for table `content_data_script_allowed_request`
--
ALTER TABLE `content_data_script_allowed_request`
  ADD PRIMARY KEY (`id`),
  ADD KEY `content_data_id` (`content_data_id`),
  ADD KEY `users_id` (`users_id`);

--
-- Indexes for table `content_data_script_character`
--
ALTER TABLE `content_data_script_character`
  ADD PRIMARY KEY (`id`),
  ADD KEY `content_data_id` (`content_data_id`),
  ADD KEY `name` (`name`);

--
-- Indexes for table `content_data_script_part`
--
ALTER TABLE `content_data_script_part`
  ADD PRIMARY KEY (`id`),
  ADD KEY `position` (`position`),
  ADD KEY `is_publish` (`is_publish`),
  ADD KEY `is_curation` (`is_curation`),
  ADD KEY `content_data_id` (`content_data_id`),
  ADD KEY `is_takedown` (`is_takedown`);

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

--
-- Indexes for table `content_history_part`
--
ALTER TABLE `content_history_part`
  ADD PRIMARY KEY (`id`),
  ADD KEY `part_id` (`part_id`),
  ADD KEY `content_data_id` (`content_data_id`),
  ADD KEY `date_expired` (`date_expired`);

--
-- Indexes for table `content_isread_part`
--
ALTER TABLE `content_isread_part`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `content_data_id` (`content_data_id`),
  ADD KEY `part_id` (`part_id`);

--
-- Indexes for table `content_users_label`
--
ALTER TABLE `content_users_label`
  ADD PRIMARY KEY (`id`),
  ADD KEY `content_data_id` (`content_data_id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `label` (`label`);

--
-- Indexes for table `contribution_counter`
--
ALTER TABLE `contribution_counter`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `date_ymd` (`date_ymd`);

--
-- Indexes for table `contribution_history`
--
ALTER TABLE `contribution_history`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `code` (`code`),
  ADD KEY `date_ymd` (`date_ymd`);

--
-- Indexes for table `contribution_login_history`
--
ALTER TABLE `contribution_login_history`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `date_code` (`date_code`);

--
-- Indexes for table `creator_account`
--
ALTER TABLE `creator_account`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_id` (`users_id`),
  ADD KEY `date_order` (`date_order`),
  ADD KEY `is_partner` (`is_partner`),
  ADD KEY `transfer_code` (`transfer_code`),
  ADD KEY `is_illustrator` (`is_illustrator`),
  ADD KEY `is_chatcurator` (`is_chatcurator`),
  ADD KEY `is_banned` (`is_banned`);

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

--
-- Indexes for table `creator_account_writter`
--
ALTER TABLE `creator_account_writter`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `writer` (`writer`),
  ADD KEY `type` (`type`);

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

--
-- Indexes for table `creator_chat`
--
ALTER TABLE `creator_chat`
  ADD PRIMARY KEY (`id`),
  ADD KEY `is_creator` (`is_creator`),
  ADD KEY `is_read` (`is_read`),
  ADD KEY `content_data_id` (`content_data_id`);

--
-- Indexes for table `creator_data_image`
--
ALTER TABLE `creator_data_image`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `content_type` (`content_type`),
  ADD KEY `date_order` (`date_order`);

--
-- Indexes for table `creator_history_income`
--
ALTER TABLE `creator_history_income`
  ADD PRIMARY KEY (`id`),
  ADD KEY `type` (`creator_type`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `date_ymd` (`date_ymd`);

--
-- Indexes for table `creator_history_monetize`
--
ALTER TABLE `creator_history_monetize`
  ADD PRIMARY KEY (`id`),
  ADD KEY `content_type` (`content_type`),
  ADD KEY `content_id` (`content_id`),
  ADD KEY `date_ym` (`date_ym`),
  ADD KEY `date_ymd` (`date_ymd`),
  ADD KEY `users_id` (`users_id`);

--
-- Indexes for table `creator_history_payout`
--
ALTER TABLE `creator_history_payout`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `date_ym` (`date_ym`),
  ADD KEY `request_payout_id` (`request_payout_id`),
  ADD KEY `data_payout_period_id` (`data_payout_period_id`);

--
-- Indexes for table `creator_notification_income`
--
ALTER TABLE `creator_notification_income`
  ADD PRIMARY KEY (`id`),
  ADD KEY `creator_type` (`creator_type`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `status` (`status`),
  ADD KEY `date_ymd` (`date_ymd`);

--
-- Indexes for table `creator_order_list`
--
ALTER TABLE `creator_order_list`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `date_order` (`date_order`),
  ADD KEY `status` (`status`);

--
-- Indexes for table `creator_royalty_level`
--
ALTER TABLE `creator_royalty_level`
  ADD PRIMARY KEY (`id`),
  ADD KEY `level` (`level`);

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

--
-- Indexes for table `creator_work_acquisition`
--
ALTER TABLE `creator_work_acquisition`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id_from` (`users_id_from`),
  ADD KEY `users_id_to` (`users_id_to`),
  ADD KEY `status` (`status`),
  ADD KEY `is_read` (`is_read`),
  ADD KEY `date_order` (`date_order`);

--
-- Indexes for table `creator_work_bypass`
--
ALTER TABLE `creator_work_bypass`
  ADD PRIMARY KEY (`id`),
  ADD KEY `content_data_id` (`content_data_id`);

--
-- Indexes for table `data`
--
ALTER TABLE `data`
  ADD PRIMARY KEY (`id`),
  ADD KEY `type` (`type`),
  ADD KEY `position` (`position`),
  ADD KEY `value` (`value`),
  ADD KEY `info` (`info`),
  ADD KEY `code` (`code`);

--
-- Indexes for table `data_avatar`
--
ALTER TABLE `data_avatar`
  ADD PRIMARY KEY (`id`),
  ADD KEY `title` (`title`);

--
-- Indexes for table `data_countries`
--
ALTER TABLE `data_countries`
  ADD PRIMARY KEY (`id`),
  ADD KEY `phone` (`phone`),
  ADD KEY `code` (`code`),
  ADD KEY `currency` (`currency`);

--
-- Indexes for table `data_doodle`
--
ALTER TABLE `data_doodle`
  ADD PRIMARY KEY (`id`),
  ADD KEY `is_show` (`is_show`),
  ADD KEY `date_start` (`date_start`),
  ADD KEY `date_end` (`date_end`);

--
-- Indexes for table `data_payout_period`
--
ALTER TABLE `data_payout_period`
  ADD PRIMARY KEY (`id`),
  ADD KEY `date_ym` (`date_ym`);

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

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

--
-- Indexes for table `data_telco_period`
--
ALTER TABLE `data_telco_period`
  ADD PRIMARY KEY (`id`),
  ADD KEY `providers` (`providers`),
  ADD KEY `code` (`code`),
  ADD KEY `is_active` (`is_active`);

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

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

--
-- Indexes for table `emoticon`
--
ALTER TABLE `emoticon`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tipe` (`tipe`);

--
-- Indexes for table `film_details`
--
ALTER TABLE `film_details`
  ADD PRIMARY KEY (`id`),
  ADD KEY `film_id` (`film_id`);

--
-- Indexes for table `invoice_content`
--
ALTER TABLE `invoice_content`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `status` (`status`),
  ADD KEY `date_ymd` (`date_ymd`),
  ADD KEY `invoice_id` (`invoice_id`),
  ADD KEY `is_completed` (`is_completed`),
  ADD KEY `have_offline` (`have_offline`);

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

--
-- Indexes for table `invoice_content_user`
--
ALTER TABLE `invoice_content_user`
  ADD PRIMARY KEY (`id`),
  ADD KEY `inv_id` (`inv_id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `content_shipping_id` (`content_shipping_id`);

--
-- Indexes for table `invoice_content_user_item`
--
ALTER TABLE `invoice_content_user_item`
  ADD PRIMARY KEY (`id`),
  ADD KEY `content_user_id` (`content_user_id`);

--
-- Indexes for table `invoice_content_voucher`
--
ALTER TABLE `invoice_content_voucher`
  ADD PRIMARY KEY (`id`),
  ADD KEY `inv_id` (`inv_id`),
  ADD KEY `voucher_id` (`voucher_id`);

--
-- Indexes for table `invoice_data_success`
--
ALTER TABLE `invoice_data_success`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `invoice_id` (`invoice_id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `date_ym` (`date_ym`),
  ADD KEY `date_ymd` (`date_ymd`);

--
-- Indexes for table `invoice_reference`
--
ALTER TABLE `invoice_reference`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `reference_code` (`reference_code`),
  ADD KEY `payment_method_id` (`payment_method_id`),
  ADD KEY `status` (`status`),
  ADD KEY `date_expired` (`date_expired`),
  ADD KEY `payment_data` (`payment_data`),
  ADD KEY `inv_id` (`inv_id`);

--
-- Indexes for table `login_apps`
--
ALTER TABLE `login_apps`
  ADD PRIMARY KEY (`id`),
  ADD KEY `apps_privatekey` (`appkey`),
  ADD KEY `apps_type` (`type`);

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

--
-- Indexes for table `login_apps_approve`
--
ALTER TABLE `login_apps_approve`
  ADD PRIMARY KEY (`id`),
  ADD KEY `apps_id` (`apps_id`),
  ADD KEY `users_id` (`users_id`);

--
-- Indexes for table `login_email_code`
--
ALTER TABLE `login_email_code`
  ADD PRIMARY KEY (`id`),
  ADD KEY `type` (`type`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `code` (`code`),
  ADD KEY `date_expired` (`date_expired`);

--
-- Indexes for table `login_redirect_signature`
--
ALTER TABLE `login_redirect_signature`
  ADD PRIMARY KEY (`id`),
  ADD KEY `apps_id` (`apps_id`),
  ADD KEY `date_expired` (`date_expired`),
  ADD KEY `sign_key` (`sign_key`);

--
-- Indexes for table `login_token`
--
ALTER TABLE `login_token`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `apps_id` (`apps_id`),
  ADD KEY `token_1` (`token_1`),
  ADD KEY `token_2` (`token_2`),
  ADD KEY `device_id` (`device_id`),
  ADD KEY `date_expired` (`date_expired`),
  ADD KEY `date_using` (`date_using`),
  ADD KEY `token_auth` (`token_auth`);

--
-- Indexes for table `login_token_auth`
--
ALTER TABLE `login_token_auth`
  ADD PRIMARY KEY (`id`),
  ADD KEY `login_token_id` (`login_token_id`),
  ADD KEY `token_auth` (`token_auth`),
  ADD KEY `ip_address` (`ip_address`),
  ADD KEY `date_expired` (`date_expired`);

--
-- Indexes for table `login_token_onetime`
--
ALTER TABLE `login_token_onetime`
  ADD PRIMARY KEY (`id`),
  ADD KEY `token` (`token`),
  ADD KEY `date_expired` (`date_expired`);

--
-- Indexes for table `login_validation_apps`
--
ALTER TABLE `login_validation_apps`
  ADD PRIMARY KEY (`id`),
  ADD KEY `apps_id` (`apps_id`),
  ADD KEY `date_expired` (`date_expired`);

--
-- Indexes for table `market_books`
--
ALTER TABLE `market_books`
  ADD PRIMARY KEY (`id`),
  ADD KEY `content_type` (`content_type`),
  ADD KEY `content_id` (`content_id`),
  ADD KEY `items_id` (`items_id`),
  ADD KEY `date_cron` (`date_cron`);

--
-- Indexes for table `market_books_writer`
--
ALTER TABLE `market_books_writer`
  ADD PRIMARY KEY (`id`),
  ADD KEY `book_id` (`book_id`);

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

--
-- Indexes for table `market_colab_items`
--
ALTER TABLE `market_colab_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `market_colab_id` (`market_colab_id`),
  ADD KEY `items_id` (`items_id`);

--
-- Indexes for table `market_group`
--
ALTER TABLE `market_group`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `slug` (`slug`),
  ADD KEY `is_discover` (`is_discover`),
  ADD KEY `is_menu` (`is_menu`),
  ADD KEY `is_selected` (`is_selected`),
  ADD KEY `is_show` (`is_show`);

--
-- Indexes for table `market_group_items`
--
ALTER TABLE `market_group_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `group_id` (`group_id`),
  ADD KEY `items_id` (`items_id`);

--
-- Indexes for table `market_items`
--
ALTER TABLE `market_items`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `slug` (`slug`),
  ADD KEY `is_sale` (`is_sale`),
  ADD KEY `date_order` (`date_order`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `title` (`title`),
  ADD KEY `is_takedown` (`is_takedown`),
  ADD KEY `items_type` (`items_type`);

--
-- Indexes for table `market_items_bonus`
--
ALTER TABLE `market_items_bonus`
  ADD PRIMARY KEY (`id`),
  ADD KEY `items_id` (`items_id`);

--
-- Indexes for table `market_items_genre`
--
ALTER TABLE `market_items_genre`
  ADD PRIMARY KEY (`id`),
  ADD KEY `items_id` (`items_id`),
  ADD KEY `genre_id` (`genre_id`);

--
-- Indexes for table `market_items_info`
--
ALTER TABLE `market_items_info`
  ADD PRIMARY KEY (`id`),
  ADD KEY `items_id` (`items_id`),
  ADD KEY `data_title` (`data_title`);

--
-- Indexes for table `market_items_photo`
--
ALTER TABLE `market_items_photo`
  ADD PRIMARY KEY (`id`),
  ADD KEY `items_id` (`items_id`);

--
-- Indexes for table `market_items_review`
--
ALTER TABLE `market_items_review`
  ADD PRIMARY KEY (`id`),
  ADD KEY `books_id` (`books_id`);

--
-- Indexes for table `market_items_web`
--
ALTER TABLE `market_items_web`
  ADD PRIMARY KEY (`id`),
  ADD KEY `items_id` (`items_id`);

--
-- Indexes for table `market_pinned`
--
ALTER TABLE `market_pinned`
  ADD PRIMARY KEY (`id`),
  ADD KEY `position` (`position`),
  ADD KEY `is_show` (`is_show`);

--
-- Indexes for table `market_special_preorder`
--
ALTER TABLE `market_special_preorder`
  ADD PRIMARY KEY (`id`),
  ADD KEY `items_id` (`items_id`),
  ADD KEY `date_start` (`date_start`),
  ADD KEY `date_end` (`date_end`),
  ADD KEY `is_publish` (`is_publish`);

--
-- Indexes for table `menu_data`
--
ALTER TABLE `menu_data`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `slug` (`slug`),
  ADD KEY `position` (`position`),
  ADD KEY `is_show` (`is_show`),
  ADD KEY `vapi_minimum` (`vapi_minimum`);

--
-- Indexes for table `menu_explore`
--
ALTER TABLE `menu_explore`
  ADD PRIMARY KEY (`id`),
  ADD KEY `page` (`page`),
  ADD KEY `position` (`position`),
  ADD KEY `is_show` (`is_show`),
  ADD KEY `is_login` (`is_login`),
  ADD KEY `more_page` (`more_page`),
  ADD KEY `vapi_minimum` (`vapi_minimum`),
  ADD KEY `vapi_maximum` (`vapi_maximum`),
  ADD KEY `is_cache` (`is_cache`);

--
-- Indexes for table `menu_explore_catalog`
--
ALTER TABLE `menu_explore_catalog`
  ADD PRIMARY KEY (`id`),
  ADD KEY `slug` (`slug`),
  ADD KEY `type` (`type`),
  ADD KEY `position` (`position`);

--
-- Indexes for table `menu_explore_feature`
--
ALTER TABLE `menu_explore_feature`
  ADD PRIMARY KEY (`id`),
  ADD KEY `position` (`position`),
  ADD KEY `is_show` (`is_show`),
  ADD KEY `is_premium` (`is_premium`),
  ADD KEY `is_user_premium` (`is_user_premium`),
  ADD KEY `vapi_min` (`vapi_min`),
  ADD KEY `is_insider` (`is_insider`);

--
-- Indexes for table `menu_explore_info`
--
ALTER TABLE `menu_explore_info`
  ADD PRIMARY KEY (`id`),
  ADD KEY `is_show` (`is_show`),
  ADD KEY `date_start` (`date_start`),
  ADD KEY `date_end` (`date_end`);

--
-- Indexes for table `menu_others_list`
--
ALTER TABLE `menu_others_list`
  ADD PRIMARY KEY (`id`),
  ADD KEY `position` (`position`);

--
-- Indexes for table `menu_popup`
--
ALTER TABLE `menu_popup`
  ADD PRIMARY KEY (`id`),
  ADD KEY `is_show` (`is_show`),
  ADD KEY `date_start` (`date_start`),
  ADD KEY `date_end` (`date_end`);

--
-- Indexes for table `menu_popup_users`
--
ALTER TABLE `menu_popup_users`
  ADD PRIMARY KEY (`id`),
  ADD KEY `popup_id` (`popup_id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `date_ymd` (`date_ymd`);

--
-- Indexes for table `notifications`
--
ALTER TABLE `notifications`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id_from` (`users_id_from`),
  ADD KEY `users_id_to` (`users_id_to`),
  ADD KEY `type` (`type`),
  ADD KEY `date_order` (`date_order`),
  ADD KEY `status` (`status`),
  ADD KEY `status_browser` (`status_browser`),
  ADD KEY `is_read` (`is_read`);

--
-- Indexes for table `notifications_browser`
--
ALTER TABLE `notifications_browser`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `is_read` (`is_read`),
  ADD KEY `date_expired` (`date_expired`);

--
-- Indexes for table `notifications_content_pending`
--
ALTER TABLE `notifications_content_pending`
  ADD PRIMARY KEY (`id`),
  ADD KEY `status` (`status`),
  ADD KEY `date_ymd` (`date_ymd`),
  ADD KEY `content_data_id` (`content_data_id`);

--
-- Indexes for table `notifications_creator`
--
ALTER TABLE `notifications_creator`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `date_order` (`date_order`),
  ADD KEY `part_id` (`part_id`),
  ADD KEY `content_data_id` (`content_data_id`);

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

--
-- Indexes for table `notifications_firebase`
--
ALTER TABLE `notifications_firebase`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `type` (`type`),
  ADD KEY `data_id` (`data_id`),
  ADD KEY `dateymd` (`dateymd`),
  ADD KEY `date_expired` (`date_expired`);

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

--
-- Indexes for table `notifications_firebase_follow`
--
ALTER TABLE `notifications_firebase_follow`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `date_ymd` (`date_ymd`);

--
-- Indexes for table `notifications_follow`
--
ALTER TABLE `notifications_follow`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id_from` (`users_id_from`),
  ADD KEY `users_id_to` (`users_id_to`),
  ADD KEY `status` (`status`),
  ADD KEY `date_order` (`date_order`);

--
-- Indexes for table `notifications_info`
--
ALTER TABLE `notifications_info`
  ADD PRIMARY KEY (`id`),
  ADD KEY `is_system` (`is_system`);

--
-- Indexes for table `notifications_lastseen`
--
ALTER TABLE `notifications_lastseen`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id_to` (`users_id_to`),
  ADD KEY `users_id_from` (`users_id_from`),
  ADD KEY `date_order` (`date_order`);

--
-- Indexes for table `old_analytic_visitor_work`
--
ALTER TABLE `old_analytic_visitor_work`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `content_type` (`content_type`),
  ADD KEY `content_id` (`content_id`),
  ADD KEY `order_ym` (`order_ym`),
  ADD KEY `date_ymd` (`date_ymd`);

--
-- Indexes for table `old_record_visitor_work`
--
ALTER TABLE `old_record_visitor_work`
  ADD PRIMARY KEY (`id`),
  ADD KEY `ip_address` (`ip_address`),
  ADD KEY `content_type` (`content_type`),
  ADD KEY `content_id` (`content_id`),
  ADD KEY `part_id` (`part_id`),
  ADD KEY `date_ymd` (`date_ymd`);

--
-- Indexes for table `popularity_users`
--
ALTER TABLE `popularity_users`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `point` (`point`),
  ADD KEY `date_ymd` (`date_ymd`),
  ADD KEY `is_moovel` (`is_moovel`),
  ADD KEY `is_toon` (`is_toon`);

--
-- Indexes for table `premium_film`
--
ALTER TABLE `premium_film`
  ADD PRIMARY KEY (`id`),
  ADD KEY `is_show` (`is_show`),
  ADD KEY `date_start` (`date_start`),
  ADD KEY `date_end` (`date_end`);

--
-- Indexes for table `premium_users`
--
ALTER TABLE `premium_users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_id` (`users_id`) USING BTREE,
  ADD KEY `date_start` (`date_start`),
  ADD KEY `date_end` (`date_end`),
  ADD KEY `transaction_type` (`transaction_type`),
  ADD KEY `transaction_data` (`transaction_data`);

--
-- Indexes for table `premium_users_benefit_boost`
--
ALTER TABLE `premium_users_benefit_boost`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `date_ymd` (`date_ymd`);

--
-- Indexes for table `premium_users_benefit_sticker`
--
ALTER TABLE `premium_users_benefit_sticker`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `date_ymd` (`date_ymd`);

--
-- Indexes for table `premium_users_benefit_works`
--
ALTER TABLE `premium_users_benefit_works`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `content_type` (`content_type`),
  ADD KEY `content_id` (`content_id`),
  ADD KEY `part_id` (`part_id`),
  ADD KEY `date_y` (`date_y`),
  ADD KEY `date_ym` (`date_ym`),
  ADD KEY `date_ymd` (`date_ymd`);

--
-- Indexes for table `premium_users_benefit_works_history`
--
ALTER TABLE `premium_users_benefit_works_history`
  ADD PRIMARY KEY (`id`),
  ADD KEY `content_type` (`content_type`),
  ADD KEY `users_id` (`users_id`) USING BTREE,
  ADD KEY `content_id` (`content_id`),
  ADD KEY `part_id` (`part_id`),
  ADD KEY `date_rewrite` (`date_rewrite`);

--
-- Indexes for table `premium_users_history`
--
ALTER TABLE `premium_users_history`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `date_trx_y` (`date_trx_y`),
  ADD KEY `date_trx_ym` (`date_trx_ym`),
  ADD KEY `date_trx_ymd` (`date_trx_ymd`);

--
-- Indexes for table `premium_validation`
--
ALTER TABLE `premium_validation`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `transaction_type` (`transaction_type`),
  ADD KEY `uniq_code` (`uniq_code`);

--
-- Indexes for table `publishing`
--
ALTER TABLE `publishing`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`);

--
-- Indexes for table `reading_list`
--
ALTER TABLE `reading_list`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `slug` (`slug`),
  ADD KEY `content_type` (`content_type`),
  ADD KEY `date_start` (`date_start`);

--
-- Indexes for table `reading_list_content`
--
ALTER TABLE `reading_list_content`
  ADD PRIMARY KEY (`id`),
  ADD KEY `reading_list_id` (`reading_list_id`);

--
-- Indexes for table `record_visitor_work`
--
ALTER TABLE `record_visitor_work`
  ADD PRIMARY KEY (`id`),
  ADD KEY `ip_address` (`ip_address`),
  ADD KEY `content_type` (`content_type`),
  ADD KEY `content_id` (`content_id`),
  ADD KEY `part_id` (`part_id`),
  ADD KEY `date_ymd` (`date_ymd`);

--
-- Indexes for table `report_data`
--
ALTER TABLE `report_data`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `content_type` (`content_type`),
  ADD KEY `content_id` (`content_id`),
  ADD KEY `is_solved` (`is_solved`),
  ADD KEY `is_read` (`is_read`);

--
-- Indexes for table `slider`
--
ALTER TABLE `slider`
  ADD PRIMARY KEY (`id`),
  ADD KEY `is_show` (`is_show`),
  ADD KEY `date_start` (`date_start`),
  ADD KEY `date_end` (`date_end`);

--
-- Indexes for table `special_users_freeread`
--
ALTER TABLE `special_users_freeread`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `voucher_internal_id` (`voucher_internal_id`),
  ADD KEY `date_expired` (`date_expired`),
  ADD KEY `content_type` (`content_type`),
  ADD KEY `content_id` (`content_id`);

--
-- Indexes for table `sticker_list`
--
ALTER TABLE `sticker_list`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `title` (`title`),
  ADD KEY `is_curation` (`is_curation`),
  ADD KEY `is_publish` (`is_publish`);

--
-- Indexes for table `sticker_list_content`
--
ALTER TABLE `sticker_list_content`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sticker_id` (`sticker_id`);

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

--
-- Indexes for table `story_content`
--
ALTER TABLE `story_content`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_id` (`users_id`),
  ADD KEY `content_data` (`content_data`),
  ADD KEY `date_order` (`date_order`),
  ADD KEY `content_data_id` (`content_data_id`);

--
-- Indexes for table `talk_content`
--
ALTER TABLE `talk_content`
  ADD PRIMARY KEY (`id`),
  ADD KEY `type` (`type`),
  ADD KEY `content_type` (`content_type`),
  ADD KEY `content_id` (`content_id`),
  ADD KEY `date_ymd` (`date_ymd`),
  ADD KEY `is_talkoftheweek` (`is_talkoftheweek`),
  ADD KEY `date_time` (`date_time`),
  ADD KEY `is_premium` (`is_premium`),
  ADD KEY `is_show` (`is_show`);

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

--
-- Indexes for table `timeline_content`
--
ALTER TABLE `timeline_content`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `date_order` (`date_order`),
  ADD KEY `is_takedown` (`is_takedown`);

--
-- Indexes for table `timeline_content_hot`
--
ALTER TABLE `timeline_content_hot`
  ADD PRIMARY KEY (`id`),
  ADD KEY `point` (`point`),
  ADD KEY `date_trending` (`date_trending`),
  ADD KEY `timeline_status_id` (`timeline_status_id`);

--
-- Indexes for table `timeline_content_old`
--
ALTER TABLE `timeline_content_old`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `date_order` (`date_order`);

--
-- Indexes for table `timeline_status`
--
ALTER TABLE `timeline_status`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `date_order` (`date_order`),
  ADD KEY `content` (`content`(768)),
  ADD KEY `apps_id` (`apps_id`),
  ADD KEY `is_banned` (`is_banned`),
  ADD KEY `is_takedown` (`is_takedown`);

--
-- Indexes for table `timeline_status_attach`
--
ALTER TABLE `timeline_status_attach`
  ADD PRIMARY KEY (`id`),
  ADD KEY `content_type` (`content_type`),
  ADD KEY `content_data` (`content_data`),
  ADD KEY `timeline_status_id` (`timeline_status_id`);

--
-- Indexes for table `timeline_status_comment`
--
ALTER TABLE `timeline_status_comment`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `timeline_status_id` (`timeline_status_id`),
  ADD KEY `is_no_have_status` (`is_no_have_status`);

--
-- Indexes for table `timeline_status_mute`
--
ALTER TABLE `timeline_status_mute`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `timeline_status_id` (`timeline_status_id`);

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

--
-- Indexes for table `timeline_status_vote`
--
ALTER TABLE `timeline_status_vote`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `vote` (`vote`),
  ADD KEY `timeline_status_id` (`timeline_status_id`);

--
-- Indexes for table `timeline_works_content`
--
ALTER TABLE `timeline_works_content`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `date_order` (`date_order`),
  ADD KEY `content_data_id` (`content_data_id`);

--
-- Indexes for table `tmp_analytic_trueread`
--
ALTER TABLE `tmp_analytic_trueread`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `code` (`code`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `part_id` (`part_id`),
  ADD KEY `date_expired` (`date_expired`),
  ADD KEY `is_delete` (`is_delete`),
  ADD KEY `is_record` (`is_record`),
  ADD KEY `content_data_id` (`content_data_id`);

--
-- Indexes for table `tmp_analytic_trueread_history`
--
ALTER TABLE `tmp_analytic_trueread_history`
  ADD PRIMARY KEY (`id`),
  ADD KEY `code` (`code`),
  ADD KEY `date_ymd` (`date_ymd`),
  ADD KEY `date_order` (`date_order`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `username` (`username`),
  ADD UNIQUE KEY `email` (`email`),
  ADD KEY `phone` (`phone`),
  ADD KEY `uid_klikfilm` (`uid_klikfilm`),
  ADD KEY `phone_code` (`phone_code`),
  ADD KEY `password_type` (`password_type`),
  ADD KEY `password` (`password`);

--
-- Indexes for table `users_achievement`
--
ALTER TABLE `users_achievement`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `achievement_id` (`achievement_id`);

--
-- Indexes for table `users_address_book`
--
ALTER TABLE `users_address_book`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`);

--
-- Indexes for table `users_behavior_work_genre`
--
ALTER TABLE `users_behavior_work_genre`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `genre_id` (`genre_id`),
  ADD KEY `date_yw` (`date_yw`);

--
-- Indexes for table `users_connect_providers`
--
ALTER TABLE `users_connect_providers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `data_id` (`data_id`),
  ADD KEY `is_disconnect` (`is_disconnect`),
  ADD KEY `msisdn` (`msisdn`),
  ADD KEY `is_primary` (`is_primary`);

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

--
-- Indexes for table `users_content_history`
--
ALTER TABLE `users_content_history`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `content_type` (`content_type`),
  ADD KEY `date_order` (`date_order`),
  ADD KEY `content_id` (`content_id`);

--
-- Indexes for table `users_content_purchased`
--
ALTER TABLE `users_content_purchased`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `type` (`content_type`),
  ADD KEY `date_order` (`date_order`),
  ADD KEY `content_type` (`content_type`),
  ADD KEY `content_id` (`content_id`);

--
-- Indexes for table `users_data_details`
--
ALTER TABLE `users_data_details`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_id` (`users_id`),
  ADD KEY `date_online` (`date_online`),
  ADD KEY `date_recommended` (`date_recommended`);

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

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

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

--
-- Indexes for table `users_favorite`
--
ALTER TABLE `users_favorite`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `content_type` (`content_type`),
  ADD KEY `content_id` (`content_id`);

--
-- Indexes for table `users_history_ai`
--
ALTER TABLE `users_history_ai`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `from_page` (`from_page`);

--
-- Indexes for table `users_sticker_lastused`
--
ALTER TABLE `users_sticker_lastused`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `date_order` (`date_order`);

--
-- Indexes for table `users_sticker_purchased`
--
ALTER TABLE `users_sticker_purchased`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `sticker_id` (`sticker_id`),
  ADD KEY `date_order` (`date_order`);

--
-- Indexes for table `users_work_lastseen`
--
ALTER TABLE `users_work_lastseen`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `content_type` (`content_type`),
  ADD KEY `content_id` (`content_id`),
  ADD KEY `date_order` (`date_order`);

--
-- Indexes for table `users_work_likes`
--
ALTER TABLE `users_work_likes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `part_id` (`part_id`),
  ADD KEY `content_data_id` (`content_data_id`);

--
-- Indexes for table `voucher_content`
--
ALTER TABLE `voucher_content`
  ADD PRIMARY KEY (`id`),
  ADD KEY `code` (`code`),
  ADD KEY `type` (`type`),
  ADD KEY `promo_type` (`promo_type`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `date_start` (`date_start`),
  ADD KEY `date_expired` (`date_expired`),
  ADD KEY `is_active` (`is_active`);

--
-- Indexes for table `voucher_content_use`
--
ALTER TABLE `voucher_content_use`
  ADD PRIMARY KEY (`id`),
  ADD KEY `voucher_id` (`voucher_id`),
  ADD KEY `users_id` (`users_id`);

--
-- Indexes for table `voucher_internal`
--
ALTER TABLE `voucher_internal`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `code` (`code`),
  ADD KEY `voucher_type` (`voucher_type`),
  ADD KEY `type_usage` (`type_usage`),
  ADD KEY `date_start` (`date_start`),
  ADD KEY `date_end` (`date_end`),
  ADD KEY `is_show` (`is_show`),
  ADD KEY `users_id` (`users_id`);

--
-- Indexes for table `voucher_internal_users`
--
ALTER TABLE `voucher_internal_users`
  ADD PRIMARY KEY (`id`),
  ADD KEY `voucher_internal_id` (`voucher_internal_id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `date_expired` (`date_expired`);

--
-- Indexes for table `voucher_internal_works`
--
ALTER TABLE `voucher_internal_works`
  ADD PRIMARY KEY (`id`),
  ADD KEY `voucher_internal_id` (`voucher_internal_id`),
  ADD KEY `content_data_id` (`content_data_id`);

--
-- Indexes for table `voucher_users`
--
ALTER TABLE `voucher_users`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `voucher_id` (`voucher_id`);

--
-- Indexes for table `wallet_history`
--
ALTER TABLE `wallet_history`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `transaction_id` (`transaction_id`),
  ADD KEY `status` (`status`),
  ADD KEY `date_ymd` (`date_ymd`),
  ADD KEY `type` (`type`);

--
-- Indexes for table `wallet_kunci_package`
--
ALTER TABLE `wallet_kunci_package`
  ADD PRIMARY KEY (`id`),
  ADD KEY `position` (`position`),
  ADD KEY `code_playstore` (`code_playstore`),
  ADD KEY `price_telkomsel` (`price_telkomsel`),
  ADD KEY `code_ios` (`code_ios`);

--
-- Indexes for table `wallet_payment_telco`
--
ALTER TABLE `wallet_payment_telco`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `transaction_code` (`transaction_code`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `is_completed` (`is_completed`),
  ADD KEY `wallet_kunci_id` (`wallet_kunci_id`);

--
-- Indexes for table `wallet_record_payment`
--
ALTER TABLE `wallet_record_payment`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `content_type` (`content_type`),
  ADD KEY `content_id` (`content_id`);

--
-- Indexes for table `wallet_record_payment_kunci`
--
ALTER TABLE `wallet_record_payment_kunci`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `apps_id` (`apps_id`);

--
-- Indexes for table `work_achievement`
--
ALTER TABLE `work_achievement`
  ADD PRIMARY KEY (`id`),
  ADD KEY `content_data_id` (`content_data_id`);

--
-- Indexes for table `work_bookmark`
--
ALTER TABLE `work_bookmark`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `part_id` (`part_id`),
  ADD KEY `content_data_id` (`content_data_id`);

--
-- Indexes for table `work_category_exclusive`
--
ALTER TABLE `work_category_exclusive`
  ADD PRIMARY KEY (`id`),
  ADD KEY `category_exclusive_id` (`category_exclusive_id`),
  ADD KEY `content_data_id` (`content_data_id`);

--
-- Indexes for table `work_choice`
--
ALTER TABLE `work_choice`
  ADD PRIMARY KEY (`id`),
  ADD KEY `is_show` (`is_show`),
  ADD KEY `content_data_id` (`content_data_id`);

--
-- Indexes for table `work_connect_film`
--
ALTER TABLE `work_connect_film`
  ADD PRIMARY KEY (`id`),
  ADD KEY `film_id` (`film_id`),
  ADD KEY `from_kwikku` (`from_kwikku`),
  ADD KEY `content_data_id` (`content_data_id`);

--
-- Indexes for table `work_connect_program`
--
ALTER TABLE `work_connect_program`
  ADD PRIMARY KEY (`id`),
  ADD KEY `program_id` (`program_id`),
  ADD KEY `date_order` (`date_order`),
  ADD KEY `content_data_id` (`content_data_id`);

--
-- Indexes for table `work_data_category_exclusive`
--
ALTER TABLE `work_data_category_exclusive`
  ADD PRIMARY KEY (`id`),
  ADD KEY `name` (`name`),
  ADD KEY `group_code` (`group_code`);

--
-- Indexes for table `work_data_character`
--
ALTER TABLE `work_data_character`
  ADD PRIMARY KEY (`id`),
  ADD KEY `position` (`position`),
  ADD KEY `name` (`name`),
  ADD KEY `content_data_id` (`content_data_id`);

--
-- Indexes for table `work_data_genre`
--
ALTER TABLE `work_data_genre`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `slug` (`slug`),
  ADD KEY `title` (`title`),
  ADD KEY `is_novel` (`is_novel`),
  ADD KEY `is_script` (`is_script`),
  ADD KEY `is_comic` (`is_comic`),
  ADD KEY `is_flash` (`is_flash`),
  ADD KEY `is_show` (`is_show`),
  ADD KEY `is_artwork` (`is_artwork`),
  ADD KEY `is_short` (`is_short`),
  ADD KEY `is_market` (`is_market`),
  ADD KEY `is_poetry` (`is_poetry`);

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

--
-- Indexes for table `work_data_package`
--
ALTER TABLE `work_data_package`
  ADD PRIMARY KEY (`id`),
  ADD KEY `content_type` (`content_type`),
  ADD KEY `position` (`position`),
  ADD KEY `code` (`code`);

--
-- Indexes for table `work_data_public`
--
ALTER TABLE `work_data_public`
  ADD PRIMARY KEY (`id`),
  ADD KEY `content_data_id` (`content_data_id`);

--
-- Indexes for table `work_data_setup`
--
ALTER TABLE `work_data_setup`
  ADD PRIMARY KEY (`id`),
  ADD KEY `content_data_id` (`content_data_id`);

--
-- Indexes for table `work_linked`
--
ALTER TABLE `work_linked`
  ADD PRIMARY KEY (`id`),
  ADD KEY `content_data_id` (`content_data_id`),
  ADD KEY `content_data_id_to` (`content_data_id_to`);

--
-- Indexes for table `work_lock`
--
ALTER TABLE `work_lock`
  ADD PRIMARY KEY (`id`),
  ADD KEY `lock_type` (`lock_type`),
  ADD KEY `lock_data` (`lock_data`),
  ADD KEY `content_data_id` (`content_data_id`);

--
-- Indexes for table `work_recommended`
--
ALTER TABLE `work_recommended`
  ADD PRIMARY KEY (`id`),
  ADD KEY `content_data_id` (`content_data_id`);

--
-- Indexes for table `work_review`
--
ALTER TABLE `work_review`
  ADD PRIMARY KEY (`id`),
  ADD KEY `users_id` (`users_id`),
  ADD KEY `date_order` (`date_order`),
  ADD KEY `content_data_id` (`content_data_id`);

--
-- Indexes for table `work_review_count`
--
ALTER TABLE `work_review_count`
  ADD PRIMARY KEY (`id`),
  ADD KEY `content_data_id` (`content_data_id`);

--
-- Indexes for table `work_review_reply`
--
ALTER TABLE `work_review_reply`
  ADD PRIMARY KEY (`id`),
  ADD KEY `review_id` (`review_id`),
  ADD KEY `users_id` (`users_id`);

--
-- Indexes for table `work_tags`
--
ALTER TABLE `work_tags`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`),
  ADD KEY `count` (`count`),
  ADD KEY `date_order` (`date_order`);

--
-- Indexes for table `work_tags_data`
--
ALTER TABLE `work_tags_data`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tags_id` (`tags_id`),
  ADD KEY `content_data_id` (`content_data_id`);

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

--
-- Indexes for table `work_trending`
--
ALTER TABLE `work_trending`
  ADD PRIMARY KEY (`id`),
  ADD KEY `count` (`count`),
  ADD KEY `date_trending` (`date_trending`),
  ADD KEY `content_data_id` (`content_data_id`);

--
-- Indexes for table `work_trending_history`
--
ALTER TABLE `work_trending_history`
  ADD PRIMARY KEY (`id`),
  ADD KEY `content_data_id` (`content_data_id`),
  ADD KEY `date_trending` (`date_trending`);

--
-- Indexes for table `work_version`
--
ALTER TABLE `work_version`
  ADD PRIMARY KEY (`id`),
  ADD KEY `content_data_id` (`content_data_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `academy_class`
--
ALTER TABLE `academy_class`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `academy_class_ask`
--
ALTER TABLE `academy_class_ask`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `academy_class_ask_answer`
--
ALTER TABLE `academy_class_ask_answer`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `academy_class_faq`
--
ALTER TABLE `academy_class_faq`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `academy_class_file`
--
ALTER TABLE `academy_class_file`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `academy_class_file_content`
--
ALTER TABLE `academy_class_file_content`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `academy_class_member`
--
ALTER TABLE `academy_class_member`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `academy_class_member_schedule`
--
ALTER TABLE `academy_class_member_schedule`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `academy_class_mentor`
--
ALTER TABLE `academy_class_mentor`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `academy_class_record`
--
ALTER TABLE `academy_class_record`
  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `academy_class_review`
--
ALTER TABLE `academy_class_review`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `academy_class_room`
--
ALTER TABLE `academy_class_room`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `academy_class_schedule`
--
ALTER TABLE `academy_class_schedule`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `academy_class_schedule_member`
--
ALTER TABLE `academy_class_schedule_member`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `academy_class_schedule_part`
--
ALTER TABLE `academy_class_schedule_part`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `achievement`
--
ALTER TABLE `achievement`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `achievement_work`
--
ALTER TABLE `achievement_work`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `admin_banned_ip`
--
ALTER TABLE `admin_banned_ip`
  MODIFY `id` int(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `admin_banned_users`
--
ALTER TABLE `admin_banned_users`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `admin_banned_word`
--
ALTER TABLE `admin_banned_word`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `admin_banned_word_users`
--
ALTER TABLE `admin_banned_word_users`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `admin_banned_word_users_history`
--
ALTER TABLE `admin_banned_word_users_history`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `admin_comparison_script_part`
--
ALTER TABLE `admin_comparison_script_part`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `admin_competition_selection`
--
ALTER TABLE `admin_competition_selection`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `admin_competition_selection_curator`
--
ALTER TABLE `admin_competition_selection_curator`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `admin_curator_curation_history`
--
ALTER TABLE `admin_curator_curation_history`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `admin_curator_curation_timeline`
--
ALTER TABLE `admin_curator_curation_timeline`
  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `admin_curator_curation_total`
--
ALTER TABLE `admin_curator_curation_total`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `admin_director_content`
--
ALTER TABLE `admin_director_content`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `admin_director_content_pinned`
--
ALTER TABLE `admin_director_content_pinned`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `admin_event_director_select`
--
ALTER TABLE `admin_event_director_select`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `admin_grant`
--
ALTER TABLE `admin_grant`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `admin_jury_content`
--
ALTER TABLE `admin_jury_content`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `admin_jury_content_pinned`
--
ALTER TABLE `admin_jury_content_pinned`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `admin_mentor_content`
--
ALTER TABLE `admin_mentor_content`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `admin_mentor_content_pinned`
--
ALTER TABLE `admin_mentor_content_pinned`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `admin_privateuser_content`
--
ALTER TABLE `admin_privateuser_content`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `admin_push`
--
ALTER TABLE `admin_push`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `admin_push_users`
--
ALTER TABLE `admin_push_users`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `admin_submit`
--
ALTER TABLE `admin_submit`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `admin_submit_change`
--
ALTER TABLE `admin_submit_change`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `admin_submit_history`
--
ALTER TABLE `admin_submit_history`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `admin_submit_revision`
--
ALTER TABLE `admin_submit_revision`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `admin_submit_status_approve`
--
ALTER TABLE `admin_submit_status_approve`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `admin_submit_work`
--
ALTER TABLE `admin_submit_work`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `admin_users`
--
ALTER TABLE `admin_users`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `admin_users_curator_total`
--
ALTER TABLE `admin_users_curator_total`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `admin_users_history_curation`
--
ALTER TABLE `admin_users_history_curation`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `admin_work_backup_part`
--
ALTER TABLE `admin_work_backup_part`
  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `admin_work_history`
--
ALTER TABLE `admin_work_history`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `admin_work_part_change`
--
ALTER TABLE `admin_work_part_change`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `admin_work_part_change_content`
--
ALTER TABLE `admin_work_part_change_content`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `admin_work_pinned`
--
ALTER TABLE `admin_work_pinned`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `admin_work_previous`
--
ALTER TABLE `admin_work_previous`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ai_style`
--
ALTER TABLE `ai_style`
  MODIFY `id` int(15) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `analytic_visitor_work`
--
ALTER TABLE `analytic_visitor_work`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `analytic_work_trueread`
--
ALTER TABLE `analytic_work_trueread`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `boost`
--
ALTER TABLE `boost`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `boost_content`
--
ALTER TABLE `boost_content`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `certificate`
--
ALTER TABLE `certificate`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `certificate_members`
--
ALTER TABLE `certificate_members`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `chat_content`
--
ALTER TABLE `chat_content`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `chat_group`
--
ALTER TABLE `chat_group`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `chat_group_connect`
--
ALTER TABLE `chat_group_connect`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `chat_users`
--
ALTER TABLE `chat_users`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `comment_content`
--
ALTER TABLE `comment_content`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `comment_content_reply`
--
ALTER TABLE `comment_content_reply`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `comment_count_paragraph`
--
ALTER TABLE `comment_count_paragraph`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `competition`
--
ALTER TABLE `competition`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `competition_detail`
--
ALTER TABLE `competition_detail`
  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `competition_detail_user`
--
ALTER TABLE `competition_detail_user`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `competition_detail_winner_section`
--
ALTER TABLE `competition_detail_winner_section`
  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `competition_voting`
--
ALTER TABLE `competition_voting`
  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `competition_voting_user`
--
ALTER TABLE `competition_voting_user`
  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `competition_work`
--
ALTER TABLE `competition_work`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `competition_work_winners`
--
ALTER TABLE `competition_work_winners`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `connect_block`
--
ALTER TABLE `connect_block`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `connect_follow`
--
ALTER TABLE `connect_follow`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `content_data`
--
ALTER TABLE `content_data`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `content_data_comic`
--
ALTER TABLE `content_data_comic`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `content_data_comic_part`
--
ALTER TABLE `content_data_comic_part`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `content_data_comic_part_data`
--
ALTER TABLE `content_data_comic_part_data`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `content_data_flash`
--
ALTER TABLE `content_data_flash`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `content_data_novel`
--
ALTER TABLE `content_data_novel`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `content_data_novel_part`
--
ALTER TABLE `content_data_novel_part`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `content_data_script`
--
ALTER TABLE `content_data_script`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `content_data_script_allowed`
--
ALTER TABLE `content_data_script_allowed`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `content_data_script_allowed_request`
--
ALTER TABLE `content_data_script_allowed_request`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `content_data_script_character`
--
ALTER TABLE `content_data_script_character`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `content_data_script_part`
--
ALTER TABLE `content_data_script_part`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `content_data_short`
--
ALTER TABLE `content_data_short`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `content_history_part`
--
ALTER TABLE `content_history_part`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `content_isread_part`
--
ALTER TABLE `content_isread_part`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `content_users_label`
--
ALTER TABLE `content_users_label`
  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `contribution_counter`
--
ALTER TABLE `contribution_counter`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `contribution_history`
--
ALTER TABLE `contribution_history`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `contribution_login_history`
--
ALTER TABLE `contribution_login_history`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `creator_account`
--
ALTER TABLE `creator_account`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `creator_account_detail`
--
ALTER TABLE `creator_account_detail`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `creator_account_writter`
--
ALTER TABLE `creator_account_writter`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `creator_bank`
--
ALTER TABLE `creator_bank`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `creator_chat`
--
ALTER TABLE `creator_chat`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `creator_data_image`
--
ALTER TABLE `creator_data_image`
  MODIFY `id` int(150) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `creator_history_income`
--
ALTER TABLE `creator_history_income`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `creator_history_monetize`
--
ALTER TABLE `creator_history_monetize`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `creator_history_payout`
--
ALTER TABLE `creator_history_payout`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `creator_notification_income`
--
ALTER TABLE `creator_notification_income`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `creator_order_list`
--
ALTER TABLE `creator_order_list`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `creator_royalty_level`
--
ALTER TABLE `creator_royalty_level`
  MODIFY `id` int(2) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `creator_shipping_courier`
--
ALTER TABLE `creator_shipping_courier`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `creator_work_acquisition`
--
ALTER TABLE `creator_work_acquisition`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `creator_work_bypass`
--
ALTER TABLE `creator_work_bypass`
  MODIFY `id` int(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `data`
--
ALTER TABLE `data`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `data_avatar`
--
ALTER TABLE `data_avatar`
  MODIFY `id` int(3) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `data_countries`
--
ALTER TABLE `data_countries`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `data_doodle`
--
ALTER TABLE `data_doodle`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `data_redirect`
--
ALTER TABLE `data_redirect`
  MODIFY `id` int(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `data_sharing`
--
ALTER TABLE `data_sharing`
  MODIFY `id` int(2) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `data_telco_period`
--
ALTER TABLE `data_telco_period`
  MODIFY `id` int(4) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `data_theme_poetry`
--
ALTER TABLE `data_theme_poetry`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `data_username_disabled`
--
ALTER TABLE `data_username_disabled`
  MODIFY `id` int(25) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `emoticon`
--
ALTER TABLE `emoticon`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `film_details`
--
ALTER TABLE `film_details`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `invoice_content`
--
ALTER TABLE `invoice_content`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `invoice_content_shipping`
--
ALTER TABLE `invoice_content_shipping`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `invoice_content_user`
--
ALTER TABLE `invoice_content_user`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `invoice_content_user_item`
--
ALTER TABLE `invoice_content_user_item`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `invoice_content_voucher`
--
ALTER TABLE `invoice_content_voucher`
  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `invoice_data_success`
--
ALTER TABLE `invoice_data_success`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `invoice_reference`
--
ALTER TABLE `invoice_reference`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `login_apps`
--
ALTER TABLE `login_apps`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `login_apps_access`
--
ALTER TABLE `login_apps_access`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `login_apps_approve`
--
ALTER TABLE `login_apps_approve`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `login_email_code`
--
ALTER TABLE `login_email_code`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `login_redirect_signature`
--
ALTER TABLE `login_redirect_signature`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `login_token`
--
ALTER TABLE `login_token`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `login_token_auth`
--
ALTER TABLE `login_token_auth`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `login_token_onetime`
--
ALTER TABLE `login_token_onetime`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `login_validation_apps`
--
ALTER TABLE `login_validation_apps`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `market_books`
--
ALTER TABLE `market_books`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `market_books_writer`
--
ALTER TABLE `market_books_writer`
  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `market_colab_items`
--
ALTER TABLE `market_colab_items`
  MODIFY `id` int(20) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `market_group_items`
--
ALTER TABLE `market_group_items`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `market_items`
--
ALTER TABLE `market_items`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `market_items_bonus`
--
ALTER TABLE `market_items_bonus`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `market_items_genre`
--
ALTER TABLE `market_items_genre`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `market_items_info`
--
ALTER TABLE `market_items_info`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `market_items_photo`
--
ALTER TABLE `market_items_photo`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `market_items_review`
--
ALTER TABLE `market_items_review`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `market_items_web`
--
ALTER TABLE `market_items_web`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `market_pinned`
--
ALTER TABLE `market_pinned`
  MODIFY `id` int(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `market_special_preorder`
--
ALTER TABLE `market_special_preorder`
  MODIFY `id` int(5) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `menu_data`
--
ALTER TABLE `menu_data`
  MODIFY `id` int(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `menu_explore`
--
ALTER TABLE `menu_explore`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `menu_explore_catalog`
--
ALTER TABLE `menu_explore_catalog`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `menu_explore_feature`
--
ALTER TABLE `menu_explore_feature`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `menu_others_list`
--
ALTER TABLE `menu_others_list`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `menu_popup`
--
ALTER TABLE `menu_popup`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `menu_popup_users`
--
ALTER TABLE `menu_popup_users`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `notifications`
--
ALTER TABLE `notifications`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `notifications_browser`
--
ALTER TABLE `notifications_browser`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `notifications_content_pending`
--
ALTER TABLE `notifications_content_pending`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `notifications_creator`
--
ALTER TABLE `notifications_creator`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `notifications_email_cron`
--
ALTER TABLE `notifications_email_cron`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `notifications_firebase`
--
ALTER TABLE `notifications_firebase`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `notifications_firebase_cron`
--
ALTER TABLE `notifications_firebase_cron`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `notifications_firebase_follow`
--
ALTER TABLE `notifications_firebase_follow`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `notifications_follow`
--
ALTER TABLE `notifications_follow`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `notifications_info`
--
ALTER TABLE `notifications_info`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `notifications_lastseen`
--
ALTER TABLE `notifications_lastseen`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `old_analytic_visitor_work`
--
ALTER TABLE `old_analytic_visitor_work`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `old_record_visitor_work`
--
ALTER TABLE `old_record_visitor_work`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `popularity_users`
--
ALTER TABLE `popularity_users`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `premium_film`
--
ALTER TABLE `premium_film`
  MODIFY `id` int(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `premium_users`
--
ALTER TABLE `premium_users`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `premium_users_benefit_boost`
--
ALTER TABLE `premium_users_benefit_boost`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `premium_users_benefit_sticker`
--
ALTER TABLE `premium_users_benefit_sticker`
  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `premium_users_benefit_works`
--
ALTER TABLE `premium_users_benefit_works`
  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `premium_users_benefit_works_history`
--
ALTER TABLE `premium_users_benefit_works_history`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `premium_users_history`
--
ALTER TABLE `premium_users_history`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `premium_validation`
--
ALTER TABLE `premium_validation`
  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `publishing`
--
ALTER TABLE `publishing`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `reading_list`
--
ALTER TABLE `reading_list`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `reading_list_content`
--
ALTER TABLE `reading_list_content`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `record_visitor_work`
--
ALTER TABLE `record_visitor_work`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `report_data`
--
ALTER TABLE `report_data`
  MODIFY `id` int(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `slider`
--
ALTER TABLE `slider`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `special_users_freeread`
--
ALTER TABLE `special_users_freeread`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sticker_list`
--
ALTER TABLE `sticker_list`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sticker_list_content`
--
ALTER TABLE `sticker_list_content`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `story_content`
--
ALTER TABLE `story_content`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `talk_content`
--
ALTER TABLE `talk_content`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `talk_live`
--
ALTER TABLE `talk_live`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `timeline_content`
--
ALTER TABLE `timeline_content`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `timeline_content_hot`
--
ALTER TABLE `timeline_content_hot`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `timeline_content_old`
--
ALTER TABLE `timeline_content_old`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `timeline_status`
--
ALTER TABLE `timeline_status`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `timeline_status_attach`
--
ALTER TABLE `timeline_status_attach`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `timeline_status_comment`
--
ALTER TABLE `timeline_status_comment`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `timeline_status_mute`
--
ALTER TABLE `timeline_status_mute`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `timeline_status_share`
--
ALTER TABLE `timeline_status_share`
  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `timeline_status_vote`
--
ALTER TABLE `timeline_status_vote`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `timeline_works_content`
--
ALTER TABLE `timeline_works_content`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tmp_analytic_trueread`
--
ALTER TABLE `tmp_analytic_trueread`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tmp_analytic_trueread_history`
--
ALTER TABLE `tmp_analytic_trueread_history`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `users_achievement`
--
ALTER TABLE `users_achievement`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `users_address_book`
--
ALTER TABLE `users_address_book`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `users_behavior_work_genre`
--
ALTER TABLE `users_behavior_work_genre`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `users_connect_providers`
--
ALTER TABLE `users_connect_providers`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `users_contactus`
--
ALTER TABLE `users_contactus`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `users_content_history`
--
ALTER TABLE `users_content_history`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `users_content_purchased`
--
ALTER TABLE `users_content_purchased`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `users_data_details`
--
ALTER TABLE `users_data_details`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `users_data_identity`
--
ALTER TABLE `users_data_identity`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `users_data_setup`
--
ALTER TABLE `users_data_setup`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `users_deactivate`
--
ALTER TABLE `users_deactivate`
  MODIFY `id` int(15) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `users_favorite`
--
ALTER TABLE `users_favorite`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `users_history_ai`
--
ALTER TABLE `users_history_ai`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `users_sticker_lastused`
--
ALTER TABLE `users_sticker_lastused`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `users_sticker_purchased`
--
ALTER TABLE `users_sticker_purchased`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `users_work_lastseen`
--
ALTER TABLE `users_work_lastseen`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `users_work_likes`
--
ALTER TABLE `users_work_likes`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `voucher_content`
--
ALTER TABLE `voucher_content`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `voucher_content_use`
--
ALTER TABLE `voucher_content_use`
  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `voucher_internal`
--
ALTER TABLE `voucher_internal`
  MODIFY `id` int(25) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `voucher_internal_users`
--
ALTER TABLE `voucher_internal_users`
  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `voucher_internal_works`
--
ALTER TABLE `voucher_internal_works`
  MODIFY `id` int(25) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `voucher_users`
--
ALTER TABLE `voucher_users`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `wallet_history`
--
ALTER TABLE `wallet_history`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `wallet_kunci_package`
--
ALTER TABLE `wallet_kunci_package`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `wallet_payment_telco`
--
ALTER TABLE `wallet_payment_telco`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `wallet_record_payment`
--
ALTER TABLE `wallet_record_payment`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `wallet_record_payment_kunci`
--
ALTER TABLE `wallet_record_payment_kunci`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `work_achievement`
--
ALTER TABLE `work_achievement`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `work_bookmark`
--
ALTER TABLE `work_bookmark`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `work_category_exclusive`
--
ALTER TABLE `work_category_exclusive`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `work_choice`
--
ALTER TABLE `work_choice`
  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `work_connect_film`
--
ALTER TABLE `work_connect_film`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `work_connect_program`
--
ALTER TABLE `work_connect_program`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `work_data_category_exclusive`
--
ALTER TABLE `work_data_category_exclusive`
  MODIFY `id` int(5) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `work_data_character`
--
ALTER TABLE `work_data_character`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `work_data_genre`
--
ALTER TABLE `work_data_genre`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `work_data_genre_character`
--
ALTER TABLE `work_data_genre_character`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `work_data_package`
--
ALTER TABLE `work_data_package`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `work_data_public`
--
ALTER TABLE `work_data_public`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `work_data_setup`
--
ALTER TABLE `work_data_setup`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `work_linked`
--
ALTER TABLE `work_linked`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `work_lock`
--
ALTER TABLE `work_lock`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `work_recommended`
--
ALTER TABLE `work_recommended`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `work_review`
--
ALTER TABLE `work_review`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `work_review_count`
--
ALTER TABLE `work_review_count`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `work_review_reply`
--
ALTER TABLE `work_review_reply`
  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `work_tags`
--
ALTER TABLE `work_tags`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `work_tags_data`
--
ALTER TABLE `work_tags_data`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `work_takedown`
--
ALTER TABLE `work_takedown`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `work_trending`
--
ALTER TABLE `work_trending`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `work_trending_history`
--
ALTER TABLE `work_trending_history`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT;

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