PHP Classes

File: upload/plugins/bulletinboard/sql_install.sql

Recommend this page to a friend!
  Classes of James Brows   PHP Bulletin Board   upload/plugins/bulletinboard/sql_install.sql   Download  
File: upload/plugins/bulletinboard/sql_install.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: PHP Bulletin Board
Manage and post messages in multi-user forums
Author: By
Last change:
Date: 3 years ago
Size: 79,072 bytes
 

Contents

Class file image Download
-- phpMyAdmin SQL Dump -- version 5.0.2 -- https://www.phpmyadmin.net/ -- -- Host: localhost -- Generation Time: Sep 26, 2021 at 07:07 AM -- Server version: 5.7.24 -- PHP Version: 7.2.19 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: `coffeecms` -- -- -------------------------------------------------------- -- -- Table structure for table `bb_ads_thread_data` -- DROP TABLE IF EXISTS `bb_payment_data`; CREATE TABLE `bb_payment_data` ( `id` bigint(11) NOT NULL, `payment_id` bigint(11) NOT NULL, `user_id` varchar(28) COLLATE utf8_unicode_ci NOT NULL, `status` int(1) NOT NULL DEFAULT '1', `comment` text COLLATE utf8_unicode_ci, `ent_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; DROP TABLE IF EXISTS `bb_ads_thread_data`; CREATE TABLE `bb_ads_thread_data` ( `ads_id` varchar(28) COLLATE utf8_unicode_ci NOT NULL, `thread_id` varchar(28) COLLATE utf8_unicode_ci NOT NULL, `forum_id` varchar(28) COLLATE utf8_unicode_ci NOT NULL, `start_date` date NOT NULL, `end_date` date NOT NULL, `status` int(1) NOT NULL DEFAULT '0', `method` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'forum', `sort_order` int(9) NOT NULL DEFAULT '0', `user_id` varchar(28) COLLATE utf8_unicode_ci DEFAULT NULL, `ent_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `upd_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `bb_alert_data` -- DROP TABLE IF EXISTS `bb_alert_data`; CREATE TABLE `bb_alert_data` ( `alert_id` bigint(11) NOT NULL, `content` text COLLATE utf8_bin NOT NULL, `user_id` varchar(28) COLLATE utf8_bin NOT NULL, `ent_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -------------------------------------------------------- -- -- Table structure for table `bb_annoucement_data` -- DROP TABLE IF EXISTS `bb_annoucement_data`; CREATE TABLE `bb_annoucement_data` ( `a_id` varchar(28) COLLATE utf8_bin NOT NULL, `title` varchar(500) COLLATE utf8_bin NOT NULL, `content` text COLLATE utf8_bin NOT NULL, `status` int(1) NOT NULL DEFAULT '1', `forum_id` varchar(28) COLLATE utf8_bin DEFAULT NULL, `group_id` varchar(28) COLLATE utf8_bin DEFAULT NULL, `user_id` varchar(28) COLLATE utf8_bin NOT NULL, `ent_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `upd_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -------------------------------------------------------- -- -- Table structure for table `bb_banned_browser_data` -- DROP TABLE IF EXISTS `bb_banned_browser_data`; CREATE TABLE `bb_banned_browser_data` ( `browser_name` varchar(255) COLLATE utf8_bin NOT NULL, `user_id` varchar(28) COLLATE utf8_bin DEFAULT NULL, `ent_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -------------------------------------------------------- -- -- Table structure for table `bb_banned_ip_data` -- DROP TABLE IF EXISTS `bb_banned_ip_data`; CREATE TABLE `bb_banned_ip_data` ( `ip_address` varchar(30) COLLATE utf8_unicode_ci NOT NULL, `user_id` varchar(28) COLLATE utf8_unicode_ci DEFAULT NULL, `ent_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `bb_banned_os_data` -- DROP TABLE IF EXISTS `bb_banned_os_data`; CREATE TABLE `bb_banned_os_data` ( `os_name` varchar(255) COLLATE utf8_bin NOT NULL, `user_id` varchar(28) COLLATE utf8_bin DEFAULT NULL, `ent_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -------------------------------------------------------- -- -- Table structure for table `bb_banned_user_data` -- DROP TABLE IF EXISTS `bb_banned_user_data`; CREATE TABLE `bb_banned_user_data` ( `data_method` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'username', `username` varchar(155) COLLATE utf8_unicode_ci NOT NULL, `user_id` varchar(28) COLLATE utf8_unicode_ci DEFAULT NULL, `ent_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `bb_bbcode_data` -- DROP TABLE IF EXISTS `bb_bbcode_data`; CREATE TABLE `bb_bbcode_data` ( `bbcode_id` varchar(16) COLLATE utf8_bin NOT NULL, `title` varchar(255) COLLATE utf8_bin NOT NULL, `tagname` varchar(255) COLLATE utf8_bin NOT NULL, `replace_data` text COLLATE utf8_bin NOT NULL, `example_str` varchar(500) COLLATE utf8_bin DEFAULT NULL, `descriptions` varchar(1000) COLLATE utf8_bin DEFAULT NULL, `status` int(1) NOT NULL DEFAULT '0', `user_id` varchar(28) COLLATE utf8_bin DEFAULT NULL, `ent_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `upd_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -------------------------------------------------------- -- -- Table structure for table `bb_bbcode_hide_pay_data` -- DROP TABLE IF EXISTS `bb_bbcode_hide_pay_data`; CREATE TABLE `bb_bbcode_hide_pay_data` ( `id` bigint(11) NOT NULL, `data_type` varchar(30) COLLATE utf8_bin NOT NULL DEFAULT 'thread', `post_id` varchar(28) COLLATE utf8_bin NOT NULL, `item_id` varchar(155) COLLATE utf8_bin NOT NULL, `item_cost` double NOT NULL DEFAULT '0', `pay_method` varchar(30) COLLATE utf8_bin NOT NULL DEFAULT 'points', `seller_id` varchar(28) COLLATE utf8_bin NOT NULL, `buyer_id` varchar(28) COLLATE utf8_bin NOT NULL, `status` int(1) NOT NULL DEFAULT '1', `ent_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `upd_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -------------------------------------------------------- -- -- Table structure for table `bb_bot_detect_data` -- DROP TABLE IF EXISTS `bb_bot_detect_data`; CREATE TABLE `bb_bot_detect_data` ( `id` int(9) NOT NULL, `session_id` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `ip_address` varchar(25) COLLATE utf8_unicode_ci NOT NULL, `user_agent` varchar(500) COLLATE utf8_unicode_ci NOT NULL, `ent_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `upd_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `bb_buy_usergroup_data` -- DROP TABLE IF EXISTS `bb_buy_usergroup_data`; CREATE TABLE `bb_buy_usergroup_data` ( `order_id` varchar(28) COLLATE utf8_bin NOT NULL, `target_user_id` varchar(28) COLLATE utf8_bin NOT NULL, `group_id` varchar(28) COLLATE utf8_bin NOT NULL, `start_date` date NOT NULL, `end_date` date NOT NULL, `user_id` varchar(28) COLLATE utf8_bin DEFAULT NULL, `ent_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `upd_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -------------------------------------------------------- -- -- Table structure for table `bb_capcha_questions_data` -- DROP TABLE IF EXISTS `bb_capcha_questions_data`; CREATE TABLE `bb_capcha_questions_data` ( `question_id` int(9) NOT NULL, `title` varchar(5000) COLLATE utf8_unicode_ci NOT NULL, `answer` varchar(1000) COLLATE utf8_unicode_ci NOT NULL, `status` int(1) NOT NULL DEFAULT '0', `user_id` varchar(28) COLLATE utf8_unicode_ci DEFAULT NULL, `ent_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `upd_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `bb_capcha_questions_data` -- INSERT INTO `bb_capcha_questions_data` (`question_id`, `title`, `answer`, `status`, `user_id`, `ent_dt`, `upd_dt`) VALUES (1, 'What is the name of ground military forces', 'Army', 1, NULL, '2021-07-12 09:44:28', '2021-07-12 09:44:28'), (3, 'What do you call the middle of something?', 'Center', 1, NULL, '2021-07-12 09:44:54', '2021-07-12 09:44:54'), (4, 'Whose job is it to treat people that are ill or have an injury at a hospital?', 'Doctor', 1, NULL, '2021-07-12 09:45:05', '2021-07-12 09:45:05'), (5, 'What is the process of teaching and learning called?', 'Education', 1, NULL, '2021-07-12 09:45:16', '2021-07-12 09:45:16'), (6, 'What kind of book is written by a person about their own life?', 'Autobiography', 1, NULL, '2021-07-12 09:45:25', '2021-07-12 09:45:25'), (7, 'What is the red liquid that flows through a body?', 'Blood', 1, NULL, '2021-07-12 09:45:44', '2021-07-12 09:45:44'), (8, 'What is the payment of a students education by an organization called?', 'scholarship', 1, NULL, '2021-07-12 09:45:52', '2021-07-12 09:45:52'), (9, 'What is piece of paper with official information written on it?', 'document', 1, NULL, '2021-07-12 09:46:02', '2021-07-12 09:46:02'), (10, 'What is the name of a building where you can borrow books?', 'library', 1, NULL, '2021-07-12 09:46:12', '2021-07-12 09:46:12'), (11, 'Who is a person that makes bread, cakes and pastries?', 'baker', 1, NULL, '2021-07-12 09:46:22', '2021-07-12 09:46:22'), (12, 'What organ controls your speech, feelings, body movement and thoughts?', 'brain', 1, NULL, '2021-07-12 09:46:31', '2021-07-12 09:46:31'), (13, 'What piece of equipment shows a person what direction they are traveling?', 'compass', 1, NULL, '2021-07-12 09:46:41', '2021-07-12 09:46:41'), (14, 'What is a series of events that happen in your mind while you are sleeping?', 'dream', 1, '11015035', '2021-07-12 09:46:50', '2021-07-12 09:46:50'), (15, '<p>What is a that person belongs to<strong> an organization </strong>called?</p>\n', 'member', 1, '11015035', '2021-07-12 09:46:59', '2021-07-12 09:46:59'); -- -------------------------------------------------------- -- -- Table structure for table `bb_captcha_image_session_data` -- DROP TABLE IF EXISTS `bb_captcha_image_session_data`; CREATE TABLE `bb_captcha_image_session_data` ( `session_id` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `ip_address` varchar(30) COLLATE utf8_unicode_ci NOT NULL, `user_agent` varchar(500) COLLATE utf8_unicode_ci NOT NULL, `captcha_result` varchar(30) COLLATE utf8_unicode_ci NOT NULL, `ent_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `bb_captcha_session_data` -- DROP TABLE IF EXISTS `bb_captcha_session_data`; CREATE TABLE `bb_captcha_session_data` ( `id` int(9) NOT NULL, `session_id` varchar(68) COLLATE utf8_bin NOT NULL, `captcha_id` varchar(28) COLLATE utf8_bin NOT NULL, `answer` varchar(255) COLLATE utf8_bin NOT NULL, `ref_id` varchar(28) COLLATE utf8_bin DEFAULT NULL, `ent_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -- Dumping data for table `bb_captcha_session_data` -- INSERT INTO `bb_captcha_session_data` (`id`, `session_id`, `captcha_id`, `answer`, `ref_id`, `ent_dt`) VALUES (252, 'fb975b3275cc4cf1b8afd77a7de44ed3', 'IMAGE', '217585', NULL, '2021-09-09 16:57:15'), (292, '0dfe5a463d26cef9cb48f74c25a856d3', 'IMAGE', '886617', NULL, '2021-09-14 09:53:52'), (467, '2758bab29501935daeb2296978108374', 'IMAGE', '795461', NULL, '2021-09-26 14:05:04'); -- -------------------------------------------------------- -- -- Table structure for table `bb_category_mst` -- DROP TABLE IF EXISTS `bb_category_mst`; CREATE TABLE `bb_category_mst` ( `category_c` varchar(28) COLLATE utf8_unicode_ci NOT NULL, `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `parent_category_c` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL, `friendly_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `thumbnail` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `keywords` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `descriptions` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL, `contents` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL, `status` int(1) NOT NULL DEFAULT '1', `views` int(9) NOT NULL DEFAULT '0', `sort_order` int(9) NOT NULL DEFAULT '0', `user_id` varchar(28) COLLATE utf8_unicode_ci NOT NULL, `ent_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `upd_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `bb_category_mst` -- INSERT INTO `bb_category_mst` (`category_c`, `title`, `parent_category_c`, `friendly_url`, `thumbnail`, `keywords`, `descriptions`, `contents`, `status`, `views`, `sort_order`, `user_id`, `ent_dt`, `upd_dt`) VALUES ('9844612265587', 'Non Title', '', 'Non-Title', '', 'Non Title', 'Non Title', NULL, 1, 0, 0, '', '2021-06-05 09:36:23', '2021-06-05 09:36:23'); -- -------------------------------------------------------- -- -- Table structure for table `bb_disallow_word_data` -- DROP TABLE IF EXISTS `bb_disallow_word_data`; CREATE TABLE `bb_disallow_word_data` ( `word` varchar(155) COLLATE utf8_bin NOT NULL, `ent_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -- Dumping data for table `bb_disallow_word_data` -- INSERT INTO `bb_disallow_word_data` (`word`, `ent_dt`) VALUES ('fuck', '2021-08-08 15:34:01'), ('shit', '2021-08-08 15:34:01'); -- -------------------------------------------------------- -- -- Table structure for table `bb_forum_data` -- DROP TABLE IF EXISTS `bb_forum_data`; CREATE TABLE `bb_forum_data` ( `forum_id` varchar(28) COLLATE utf8_unicode_ci NOT NULL, `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `friendly_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `forum_type` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'normal', `external_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `descriptions` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `keywords` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `thumbnail` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `status` int(1) NOT NULL DEFAULT '1', `parent_id` varchar(28) COLLATE utf8_unicode_ci DEFAULT NULL, `allow_create_thread` int(1) NOT NULL DEFAULT '1', `last_thread_title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `last_thread_friendly_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `last_thread_author_username` varchar(155) COLLATE utf8_unicode_ci DEFAULT NULL, `last_thread_author_avatar` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `last_thread_dt` datetime DEFAULT NULL, `short_content` text COLLATE utf8_unicode_ci, `total_threads` int(9) DEFAULT '0', `total_posts` int(9) NOT NULL DEFAULT '0', `sort_order` int(9) NOT NULL DEFAULT '0', `user_id` varchar(28) COLLATE utf8_unicode_ci DEFAULT NULL, `ent_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `upd_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `bb_forum_message_data` -- DROP TABLE IF EXISTS `bb_forum_message_data`; CREATE TABLE `bb_forum_message_data` ( `forum_id` varchar(28) COLLATE utf8_bin NOT NULL, `message_id` varchar(28) COLLATE utf8_bin NOT NULL, `content` text COLLATE utf8_bin NOT NULL, `user_id` varchar(28) COLLATE utf8_bin DEFAULT NULL, `ent_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `upd_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -------------------------------------------------------- -- -- Table structure for table `bb_forum_usergroup_permission_data` -- DROP TABLE IF EXISTS `bb_forum_usergroup_permission_data`; CREATE TABLE `bb_forum_usergroup_permission_data` ( `forum_id` varchar(28) COLLATE utf8_bin NOT NULL, `group_id` varchar(28) COLLATE utf8_bin NOT NULL, `permission_c` varchar(50) COLLATE utf8_bin NOT NULL, `ent_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -- Dumping data for table `bb_forum_usergroup_permission_data` -- INSERT INTO `bb_forum_usergroup_permission_data` (`forum_id`, `group_id`, `permission_c`, `ent_dt`) VALUES ('5218967344578', '11016011', 'BB10001', '2021-09-26 09:49:15'), ('5218967344578', '11016012', 'BB10001', '2021-09-26 09:49:15'), ('5218967344578', '11016013', 'BB10001', '2021-09-26 09:49:15'), ('5218967344578', '11016014', 'BB10001', '2021-09-26 09:49:15'), ('5218967344578', '11016015', 'BB10001', '2021-09-26 09:49:15'), ('5218967344578', '11016016', 'BB10001', '2021-09-26 09:49:15'), ('5218967344578', '11016017', 'BB10001', '2021-09-26 09:49:15'), ('1412904102935', '11016011', 'BB10001', '2021-09-26 09:59:59'), ('1412904102935', '11016012', 'BB10001', '2021-09-26 09:59:59'), ('1412904102935', '11016013', 'BB10001', '2021-09-26 09:59:59'), ('1412904102935', '11016014', 'BB10001', '2021-09-26 09:59:59'), ('1412904102935', '11016015', 'BB10001', '2021-09-26 09:59:59'), ('1412904102935', '11016016', 'BB10001', '2021-09-26 09:59:59'), ('1412904102935', '11016017', 'BB10001', '2021-09-26 09:59:59'); -- -------------------------------------------------------- -- -- Table structure for table `bb_forum_user_permission_data` -- DROP TABLE IF EXISTS `bb_forum_user_permission_data`; CREATE TABLE `bb_forum_user_permission_data` ( `forum_id` varchar(28) COLLATE utf8_bin NOT NULL, `user_id` varchar(28) COLLATE utf8_bin NOT NULL, `permission_c` varchar(50) COLLATE utf8_bin NOT NULL, `ent_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -------------------------------------------------------- -- -- Table structure for table `bb_hook_content_key_data` -- DROP TABLE IF EXISTS `bb_hook_content_key_data`; CREATE TABLE `bb_hook_content_key_data` ( `key_c` varchar(255) COLLATE utf8_bin NOT NULL, `ent_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -------------------------------------------------------- -- -- Table structure for table `bb_html_global_data` -- DROP TABLE IF EXISTS `bb_html_global_data`; CREATE TABLE `bb_html_global_data` ( `html_c` varchar(255) COLLATE utf8_bin NOT NULL, `title` varchar(255) COLLATE utf8_bin NOT NULL, `content` text COLLATE utf8_bin NOT NULL, `status` int(1) DEFAULT '0', `user_id` varchar(28) COLLATE utf8_bin DEFAULT NULL, `ent_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `upd_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -- Dumping data for table `bb_html_global_data` -- INSERT INTO `bb_html_global_data` (`html_c`, `title`, `content`, `status`, `user_id`, `ent_dt`, `upd_dt`) VALUES ('after_1st_post', 'after_1st_post', '', 0, NULL, '2021-08-09 14:45:01', '2021-08-09 14:45:01'), ('after_1st_post_attach_files', 'after_1st_post_attach_files', '', 0, NULL, '2021-08-09 14:44:49', '2021-08-09 14:44:49'), ('after_1st_post_content', 'after_1st_post_content', '', 0, NULL, '2021-08-09 14:44:42', '2021-08-09 14:44:42'), ('after_forum_right_widgets', 'after_forum_right_widgets', '', 0, NULL, '2021-08-09 14:43:27', '2021-08-09 14:43:27'), ('after_posts_attach_files', 'after_posts_attach_files', '', 0, NULL, '2021-08-09 14:45:17', '2021-08-09 14:45:17'), ('after_posts_content', 'after_posts_content', '', 0, NULL, '2021-08-09 14:45:12', '2021-08-09 14:45:12'), ('before_1st_post_content', 'before_1st_post_content', '', 0, NULL, '2021-08-09 14:44:36', '2021-08-09 14:44:36'), ('before_forum_right_widgets', 'before_forum_right_widgets', '', 0, NULL, '2021-08-09 14:43:19', '2021-08-09 14:43:19'), ('before_list_forums', 'before_list_forums', '', 0, NULL, '2021-08-09 14:43:01', '2021-08-09 14:43:01'), ('bottom_account_page', 'bottom_account_page', '', 0, NULL, '2021-08-09 14:47:55', '2021-08-09 14:47:55'), ('bottom_forums_page', 'bottom_forums_page', '', 0, NULL, '2021-08-09 14:43:54', '2021-08-09 14:43:54'), ('bottom_login_page', 'bottom_login_page', '', 0, NULL, '2021-08-09 14:46:44', '2021-08-09 14:46:44'), ('bottom_posts_content', 'bottom_posts_content', '', 0, NULL, '2021-08-09 14:45:25', '2021-08-09 14:45:25'), ('bottom_profile_page', 'bottom_profile_page', '', 0, NULL, '2021-08-09 14:46:52', '2021-08-09 14:46:52'), ('bottom_register_page', 'bottom_register_page', '', 0, NULL, '2021-08-09 14:46:20', '2021-08-09 14:46:20'), ('bottom_search_page', 'bottom_search_page', '', 0, NULL, '2021-08-09 14:46:03', '2021-08-09 14:46:03'), ('bottom_thread_details_page', 'bottom_thread_details_page', '', 0, NULL, '2021-08-09 14:45:32', '2021-08-09 14:45:32'), ('bottom_thread_reply_page', 'bottom_thread_reply_page', '', 0, NULL, '2021-08-09 14:45:39', '2021-08-09 14:45:39'), ('top_account_page', 'top_account_page', '', 0, NULL, '2021-08-09 14:48:02', '2021-08-09 14:48:02'), ('top_forums_page', 'top_forums_page', '', 0, NULL, '2021-08-09 14:43:42', '2021-08-09 14:43:42'), ('top_home_page', 'top_home_page', '', 0, NULL, '2021-08-09 14:42:53', '2021-08-09 14:42:53'), ('top_login_page', 'top_login_page', '', 0, NULL, '2021-08-09 14:46:38', '2021-08-09 14:46:38'), ('top_profile_page', 'top_profile_page', '', 0, NULL, '2021-08-09 14:46:59', '2021-08-09 14:46:59'), ('top_register_page', 'top_register_page', '', 0, NULL, '2021-08-09 14:46:28', '2021-08-09 14:46:28'), ('top_search_page', 'top_search_page', '', 0, NULL, '2021-08-09 14:46:12', '2021-08-09 14:46:12'), ('top_thread_details_page', 'top_thread_details_page', '', 0, NULL, '2021-08-09 14:44:18', '2021-08-09 14:44:18'), ('top_thread_reply_page', 'top_thread_reply_page', '', 0, NULL, '2021-08-09 14:45:56', '2021-08-09 14:45:56'); -- -------------------------------------------------------- -- -- Table structure for table `bb_message_ads_data` -- DROP TABLE IF EXISTS `bb_message_ads_data`; CREATE TABLE `bb_message_ads_data` ( `ads_id` int(9) NOT NULL, `message_id` varchar(28) COLLATE utf8_bin NOT NULL, `group_id` varchar(28) COLLATE utf8_bin DEFAULT NULL, `user_id` varchar(28) COLLATE utf8_bin DEFAULT NULL, `ent_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -------------------------------------------------------- -- -- Table structure for table `bb_message_attach_files_data` -- DROP TABLE IF EXISTS `bb_message_attach_files_data`; CREATE TABLE `bb_message_attach_files_data` ( `file_id` varchar(28) COLLATE utf8_bin NOT NULL, `message_id` varchar(28) COLLATE utf8_bin NOT NULL, `file_path` varchar(255) COLLATE utf8_bin NOT NULL, `file_name` varchar(155) COLLATE utf8_bin NOT NULL, `file_type` varchar(50) COLLATE utf8_bin DEFAULT NULL, `file_size` float NOT NULL DEFAULT '0', `user_id` varchar(28) COLLATE utf8_bin NOT NULL, `last_download` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `views` int(9) NOT NULL DEFAULT '0', `ent_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -------------------------------------------------------- -- -- Table structure for table `bb_message_data` -- DROP TABLE IF EXISTS `bb_message_data`; CREATE TABLE `bb_message_data` ( `message_id` varchar(28) COLLATE utf8_bin NOT NULL, `parent_id` varchar(28) COLLATE utf8_bin DEFAULT NULL, `subject` varchar(255) COLLATE utf8_bin NOT NULL, `content` text COLLATE utf8_bin NOT NULL, `allow_reply` int(1) NOT NULL DEFAULT '1', `has_attach_files` int(1) DEFAULT '0', `username` varchar(155) COLLATE utf8_bin DEFAULT NULL, `is_read` int(1) NOT NULL DEFAULT '0', `user_id` varchar(28) COLLATE utf8_bin NOT NULL, `ent_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `upd_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -------------------------------------------------------- -- -- Table structure for table `bb_message_user_data` -- DROP TABLE IF EXISTS `bb_message_user_data`; CREATE TABLE `bb_message_user_data` ( `message_id` varchar(28) COLLATE utf8_bin NOT NULL, `target_username` varchar(155) COLLATE utf8_bin DEFAULT NULL, `target_user_id` varchar(28) COLLATE utf8_bin DEFAULT NULL, `source_user_id` varchar(28) COLLATE utf8_bin DEFAULT NULL, `is_read` int(1) NOT NULL DEFAULT '0', `readed_time` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -------------------------------------------------------- -- -- Table structure for table `bb_notifies_data` -- DROP TABLE IF EXISTS `bb_notifies_data`; CREATE TABLE `bb_notifies_data` ( `id` varchar(28) COLLATE utf8_bin NOT NULL, `user_id` varchar(28) COLLATE utf8_bin NOT NULL, `content` varchar(5000) COLLATE utf8_bin NOT NULL, `target_url` varchar(255) COLLATE utf8_bin DEFAULT NULL, `is_read` int(1) NOT NULL DEFAULT '0', `ent_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -------------------------------------------------------- -- -- Table structure for table `bb_notifies_user_data` -- DROP TABLE IF EXISTS `bb_notifies_user_data`; CREATE TABLE `bb_notifies_user_data` ( `id` bigint(11) NOT NULL, `notify_id` varchar(28) COLLATE utf8_bin NOT NULL, `source_user_id` varchar(28) COLLATE utf8_bin DEFAULT NULL, `target_user_id` varchar(28) COLLATE utf8_bin DEFAULT NULL, `target_username` varchar(155) COLLATE utf8_bin NOT NULL, `is_read` int(1) NOT NULL DEFAULT '1', `ent_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -------------------------------------------------------- -- -- Table structure for table `bb_poll_answer_data` -- DROP TABLE IF EXISTS `bb_poll_answer_data`; CREATE TABLE `bb_poll_answer_data` ( `answer_id` varchar(28) COLLATE utf8_bin NOT NULL, `poll_id` varchar(28) COLLATE utf8_bin NOT NULL, `content` varchar(500) COLLATE utf8_bin NOT NULL, `sort_order` int(9) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -------------------------------------------------------- -- -- Table structure for table `bb_poll_data` -- DROP TABLE IF EXISTS `bb_poll_data`; CREATE TABLE `bb_poll_data` ( `poll_id` varchar(28) COLLATE utf8_bin NOT NULL, `thread_id` varchar(28) COLLATE utf8_bin NOT NULL, `question` varchar(500) COLLATE utf8_bin NOT NULL, `status` varchar(1) COLLATE utf8_bin NOT NULL DEFAULT '1', `end_dt` date DEFAULT NULL, `poll_choice` varchar(30) COLLATE utf8_bin NOT NULL DEFAULT 'unique', `poll_choice_max` int(5) NOT NULL DEFAULT '7', `allow_change_answer` int(1) NOT NULL DEFAULT '0', `allow_guest_access` int(1) NOT NULL DEFAULT '0', `set_close_poll_day` int(1) NOT NULL DEFAULT '0', `user_id` varchar(28) COLLATE utf8_bin DEFAULT NULL, `ent_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `upd_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -------------------------------------------------------- -- -- Table structure for table `bb_poll_member_answer_data` -- DROP TABLE IF EXISTS `bb_poll_member_answer_data`; CREATE TABLE `bb_poll_member_answer_data` ( `id` bigint(11) NOT NULL, `visitor_hash` varchar(70) COLLATE utf8_bin NOT NULL, `poll_id` varchar(28) COLLATE utf8_bin NOT NULL, `answer_id` varchar(28) COLLATE utf8_bin NOT NULL, `ip_address` varchar(30) COLLATE utf8_bin NOT NULL, `user_agent` varchar(500) COLLATE utf8_bin DEFAULT NULL, `user_id` varchar(28) COLLATE utf8_bin DEFAULT NULL, `is_guest` int(1) NOT NULL DEFAULT '0', `ent_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -------------------------------------------------------- -- -- Table structure for table `bb_posts_data` -- DROP TABLE IF EXISTS `bb_posts_data`; CREATE TABLE `bb_posts_data` ( `post_id` varchar(28) COLLATE utf8_unicode_ci NOT NULL, `thread_id` varchar(28) COLLATE utf8_unicode_ci NOT NULL, `forum_id` varchar(28) COLLATE utf8_unicode_ci DEFAULT NULL, `content` longtext COLLATE utf8_unicode_ci, `total_reactions` int(9) NOT NULL DEFAULT '0', `has_attach_files` int(1) NOT NULL DEFAULT '0', `user_id` varchar(28) COLLATE utf8_unicode_ci DEFAULT NULL, `sort_order` int(9) NOT NULL DEFAULT '0', `ent_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `upd_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `bb_post_attach_files_data` -- DROP TABLE IF EXISTS `bb_post_attach_files_data`; CREATE TABLE `bb_post_attach_files_data` ( `file_id` varchar(28) COLLATE utf8_bin NOT NULL, `post_id` varchar(28) COLLATE utf8_bin NOT NULL, `file_path` varchar(255) COLLATE utf8_bin NOT NULL, `file_name` varchar(155) COLLATE utf8_bin NOT NULL, `file_type` varchar(50) COLLATE utf8_bin DEFAULT NULL, `file_size` float NOT NULL DEFAULT '0', `user_id` varchar(28) COLLATE utf8_bin NOT NULL, `last_download` datetime DEFAULT NULL, `views` int(9) NOT NULL DEFAULT '0', `ent_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -------------------------------------------------------- -- -- Table structure for table `bb_post_prefix_data` -- DROP TABLE IF EXISTS `bb_post_prefix_data`; CREATE TABLE `bb_post_prefix_data` ( `prefix_id` varchar(8) COLLATE utf8_bin NOT NULL, `title` varchar(155) COLLATE utf8_bin NOT NULL, `bg_color_c` varchar(10) COLLATE utf8_bin DEFAULT NULL, `status` int(1) NOT NULL DEFAULT '1', `user_id` varchar(28) COLLATE utf8_bin DEFAULT NULL, `ent_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `upd_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -- Dumping data for table `bb_post_prefix_data` -- INSERT INTO `bb_post_prefix_data` (`prefix_id`, `title`, `bg_color_c`, `status`, `user_id`, `ent_dt`, `upd_dt`) VALUES ('4355292', 'Help', '#F23412', 1, '11015035', '2021-09-11 09:34:30', '2021-09-11 09:34:30'), ('5405054', 'Bug', '#8F8F8F', 1, '11015035', '2021-09-11 09:35:10', '2021-09-11 09:35:10'), ('6654585', 'Free', '#2DBA60', 1, '11015035', '2021-09-11 09:35:25', '2021-09-11 09:35:25'), ('8459333', 'Question', '#F19425', 1, '11015035', '2021-09-11 09:35:51', '2021-09-11 09:35:51'), ('9355169', 'Tutorial', '#499CCF', 1, '11015035', '2021-09-11 09:34:58', '2021-09-11 09:34:58'); -- -------------------------------------------------------- -- -- Table structure for table `bb_post_reactions_count_data` -- DROP TABLE IF EXISTS `bb_post_reactions_count_data`; CREATE TABLE `bb_post_reactions_count_data` ( `post_id` varchar(28) COLLATE utf8_bin NOT NULL, `reaction_id` varchar(14) COLLATE utf8_bin NOT NULL, `total` int(9) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -------------------------------------------------------- -- -- Table structure for table `bb_post_reactions_data` -- DROP TABLE IF EXISTS `bb_post_reactions_data`; CREATE TABLE `bb_post_reactions_data` ( `id` int(9) NOT NULL, `type` varchar(30) COLLATE utf8_bin NOT NULL DEFAULT 'thread', `post_id` varchar(28) COLLATE utf8_bin NOT NULL, `reaction_id` varchar(28) COLLATE utf8_bin NOT NULL, `reaction_text` varchar(50) COLLATE utf8_bin DEFAULT NULL, `user_id` varchar(28) COLLATE utf8_bin NOT NULL, `ent_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -------------------------------------------------------- -- -- Table structure for table `bb_post_tag_data` -- DROP TABLE IF EXISTS `bb_post_tag_data`; CREATE TABLE `bb_post_tag_data` ( `post_id` varchar(28) COLLATE utf8_bin NOT NULL, `tag` varchar(155) COLLATE utf8_bin NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -------------------------------------------------------- -- -- Table structure for table `bb_ranks_data` -- DROP TABLE IF EXISTS `bb_ranks_data`; CREATE TABLE `bb_ranks_data` ( `rank_id` varchar(14) COLLATE utf8_bin NOT NULL, `title` varchar(155) COLLATE utf8_bin NOT NULL, `image` varchar(255) COLLATE utf8_bin DEFAULT NULL, `status` int(1) NOT NULL DEFAULT '0', `bg_color_c` varchar(30) COLLATE utf8_bin DEFAULT NULL, `left_str` varchar(1000) COLLATE utf8_bin DEFAULT NULL, `right_str` varchar(1000) COLLATE utf8_bin DEFAULT NULL, `user_id` varchar(28) COLLATE utf8_bin DEFAULT NULL, `ent_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `upd_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -- Dumping data for table `bb_ranks_data` -- INSERT INTO `bb_ranks_data` (`rank_id`, `title`, `image`, `status`, `bg_color_c`, `left_str`, `right_str`, `user_id`, `ent_dt`, `upd_dt`) VALUES ('11102011', 'Noob', NULL, 1, '#46B4D4', NULL, NULL, NULL, '2021-07-12 09:49:48', '2021-07-12 09:49:48'), ('11102012', 'Professional', NULL, 1, '#46B4D4', NULL, NULL, NULL, '2021-07-12 09:50:20', '2021-07-12 09:50:20'), ('9244136952425', 'Test', '', 1, '#000000', '', '', '11015035', '2021-09-26 13:36:34', '2021-09-26 13:36:34'); -- -------------------------------------------------------- -- -- Table structure for table `bb_reaction_data` -- DROP TABLE IF EXISTS `bb_reaction_data`; CREATE TABLE `bb_reaction_data` ( `reaction_id` varchar(14) COLLATE utf8_unicode_ci NOT NULL, `title` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `text_color` varchar(8) COLLATE utf8_unicode_ci DEFAULT NULL, `image_path` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `status` int(1) NOT NULL DEFAULT '0', `sort_order` int(9) DEFAULT '0', `score` int(3) NOT NULL DEFAULT '1', `user_id` varchar(28) COLLATE utf8_unicode_ci DEFAULT NULL, `ent_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `upd_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `bb_reaction_data` -- INSERT INTO `bb_reaction_data` (`reaction_id`, `title`, `text_color`, `image_path`, `status`, `sort_order`, `score`, `user_id`, `ent_dt`, `upd_dt`) VALUES ('119471982', 'sad', '#46B4D4', 'public/bb_contents/reactions/sad_7804308671_4387411033.png', 0, 0, 1, '11015035', '2021-09-26 14:00:42', '2021-09-26 14:00:42'), ('255403720', 'live', '#46B4D4', 'public/bb_contents/reactions/love_4564014539_7382666222.png', 0, 0, 1, '11015035', '2021-09-26 14:00:42', '2021-09-26 14:00:42'), ('263122846', 'care', '#46B4D4', 'public/bb_contents/reactions/care_6341567423_9129975918.png', 0, 0, 1, '11015035', '2021-09-26 14:00:42', '2021-09-26 14:00:42'), ('477622474', 'angry', '#46B4D4', 'public/bb_contents/reactions/angry_2334516538_1207762404.png', 0, 0, 1, '11015035', '2021-09-26 14:00:41', '2021-09-26 14:00:41'), ('603532042', 'haha', '#46B4D4', 'public/bb_contents/reactions/haha_9657659872_2583574280.png', 0, 0, 1, '11015035', '2021-09-26 14:00:42', '2021-09-26 14:00:42'), ('655026435', 'wow', '#46B4D4', 'public/bb_contents/reactions/wow_2727404584_1464875623.png', 0, 0, 1, '11015035', '2021-09-26 14:00:42', '2021-09-26 14:00:42'), ('778689943', 'like', '#46B4D4', 'public/bb_contents/reactions/like_9542204390_2561235053.png', 0, 0, 1, '11015035', '2021-09-26 14:00:42', '2021-09-26 14:00:42'); -- -------------------------------------------------------- -- -- Table structure for table `bb_report_page_data` -- DROP TABLE IF EXISTS `bb_report_page_data`; CREATE TABLE `bb_report_page_data` ( `id` int(9) NOT NULL, `title` varchar(255) COLLATE utf8_bin NOT NULL, `type` varchar(30) COLLATE utf8_bin NOT NULL DEFAULT 'thread', `url` varchar(255) COLLATE utf8_bin NOT NULL, `reason` varchar(1000) COLLATE utf8_bin DEFAULT NULL, `target_id` varchar(28) COLLATE utf8_bin DEFAULT NULL, `user_id` varchar(28) COLLATE utf8_bin NOT NULL, `ent_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -------------------------------------------------------- -- -- Table structure for table `bb_shop_cart_data` -- DROP TABLE IF EXISTS `bb_shop_cart_data`; CREATE TABLE `bb_shop_cart_data` ( `user_id` varchar(28) COLLATE utf8_bin NOT NULL, `product_title` varchar(255) COLLATE utf8_bin NOT NULL, `price` double NOT NULL DEFAULT '0', `quantity` int(9) NOT NULL DEFAULT '1', `ent_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -------------------------------------------------------- -- -- Table structure for table `bb_shop_orders_data` -- DROP TABLE IF EXISTS `bb_shop_orders_data`; CREATE TABLE `bb_shop_orders_data` ( `order_id` varchar(28) COLLATE utf8_bin NOT NULL, `product_title` varchar(255) COLLATE utf8_bin NOT NULL, `quantity` int(9) NOT NULL DEFAULT '1', `price` double NOT NULL DEFAULT '0', `status` int(1) NOT NULL DEFAULT '0', `payer_id` varchar(28) COLLATE utf8_bin NOT NULL, `ent_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `upd_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -------------------------------------------------------- -- -- Table structure for table `bb_shop_payment_method_data` -- DROP TABLE IF EXISTS `bb_shop_payment_method_data`; CREATE TABLE `bb_shop_payment_method_data` ( `payment_method` varchar(155) COLLATE utf8_bin NOT NULL, `content` text COLLATE utf8_bin, `status` int(1) NOT NULL DEFAULT '1', `ent_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `upd_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -------------------------------------------------------- -- -- Table structure for table `bb_smiles_category_data` -- DROP TABLE IF EXISTS `bb_smiles_category_data`; CREATE TABLE `bb_smiles_category_data` ( `category_id` varchar(28) COLLATE utf8_unicode_ci NOT NULL, `friendly_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `title` varchar(155) COLLATE utf8_unicode_ci NOT NULL, `status` int(1) NOT NULL DEFAULT '1', `sort_order` int(9) NOT NULL DEFAULT '0', `user_id` varchar(28) COLLATE utf8_unicode_ci DEFAULT NULL, `ent_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `upd_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `bb_smiles_category_data` -- INSERT INTO `bb_smiles_category_data` (`category_id`, `friendly_url`, `title`, `status`, `sort_order`, `user_id`, `ent_dt`, `upd_dt`) VALUES ('6803491913354', 'Default', 'Default', 1, 0, '11015035', '2021-08-17 10:56:04', '2021-08-17 10:56:04'); -- -------------------------------------------------------- -- -- Table structure for table `bb_smiles_data` -- DROP TABLE IF EXISTS `bb_smiles_data`; CREATE TABLE `bb_smiles_data` ( `smile_id` varchar(28) COLLATE utf8_unicode_ci NOT NULL, `category_id` varchar(28) COLLATE utf8_unicode_ci NOT NULL, `image_path` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `text_replace` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `sort_order` int(9) NOT NULL DEFAULT '0', `ent_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `bb_smiles_data` -- INSERT INTO `bb_smiles_data` (`smile_id`, `category_id`, `image_path`, `text_replace`, `sort_order`, `ent_dt`) VALUES ('188911360', '6803491913354', 'public/bb_contents/smiles/Default/12_9206776733.jpg', ':255828:', 11, '2021-08-17 10:56:31'), ('206415341', '6803491913354', 'public/bb_contents/smiles/Default/19_5416225355.jpg', ':938165:', 18, '2021-08-17 10:56:31'), ('278943648', '6803491913354', 'public/bb_contents/smiles/Default/1_5762548234.jpg', ':921586:', 0, '2021-08-17 10:56:30'), ('335641649', '6803491913354', 'public/bb_contents/smiles/Default/15_7458350212.jpg', ':892865:', 14, '2021-08-17 10:56:31'), ('368072449', '6803491913354', 'public/bb_contents/smiles/Default/14_3023470299.jpg', ':896268:', 13, '2021-08-17 10:56:31'), ('414954225', '6803491913354', 'public/bb_contents/smiles/Default/18_2747593552.jpg', ':382637:', 17, '2021-08-17 10:56:31'), ('415084450', '6803491913354', 'public/bb_contents/smiles/Default/16_7554342482.jpg', ':689662:', 15, '2021-08-17 10:56:31'), ('454843788', '6803491913354', 'public/bb_contents/smiles/Default/4_4959310890.jpg', ':186673:', 3, '2021-08-17 10:56:31'), ('554308319', '6803491913354', 'public/bb_contents/smiles/Default/11_1958005895.jpg', ':433428:', 10, '2021-08-17 10:56:31'), ('561480722', '6803491913354', 'public/bb_contents/smiles/Default/13_5652885126.jpg', ':436995:', 12, '2021-08-17 10:56:31'), ('586385151', '6803491913354', 'public/bb_contents/smiles/Default/5_2668325518.jpg', ':644569:', 4, '2021-08-17 10:56:31'), ('626565582', '6803491913354', 'public/bb_contents/smiles/Default/2_9840633646.jpg', ':688137:', 1, '2021-08-17 10:56:30'), ('681876423', '6803491913354', 'public/bb_contents/smiles/Default/17_3541595247.jpg', ':487784:', 16, '2021-08-17 10:56:31'), ('690607235', '6803491913354', 'public/bb_contents/smiles/Default/7_9313136700.jpg', ':135141:', 6, '2021-08-17 10:56:31'), ('741585173', '6803491913354', 'public/bb_contents/smiles/Default/9_4450903901.jpg', ':564195:', 8, '2021-08-17 10:56:31'), ('803221994', '6803491913354', 'public/bb_contents/smiles/Default/10_7501478936.jpg', ':597185:', 9, '2021-08-17 10:56:31'), ('842474268', '6803491913354', 'public/bb_contents/smiles/Default/3_8387344752.jpg', ':779714:', 2, '2021-08-17 10:56:31'), ('958564372', '6803491913354', 'public/bb_contents/smiles/Default/8_3185404139.jpg', ':743581:', 7, '2021-08-17 10:56:31'), ('991044971', '6803491913354', 'public/bb_contents/smiles/Default/6_9166496418.jpg', ':997263:', 5, '2021-08-17 10:56:31'); -- -------------------------------------------------------- -- -- Table structure for table `bb_smile_most_recent_data` -- DROP TABLE IF EXISTS `bb_smile_most_recent_data`; CREATE TABLE `bb_smile_most_recent_data` ( `user_id` varchar(28) COLLATE utf8_bin NOT NULL, `smile_id` varchar(28) COLLATE utf8_bin NOT NULL, `ent_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -------------------------------------------------------- -- -- Table structure for table `bb_threads_data` -- DROP TABLE IF EXISTS `bb_threads_data`; CREATE TABLE `bb_threads_data` ( `thread_id` varchar(28) COLLATE utf8_unicode_ci NOT NULL, `forum_id` varchar(28) COLLATE utf8_unicode_ci NOT NULL, `prefix_id` varchar(8) COLLATE utf8_unicode_ci DEFAULT NULL, `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `friendly_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `content` longtext COLLATE utf8_unicode_ci, `descriptions` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL, `keywords` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL, `tags` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL, `views` int(9) NOT NULL DEFAULT '0', `is_stick` int(1) DEFAULT '0', `is_url` int(1) NOT NULL DEFAULT '0', `has_attach_files` int(1) NOT NULL DEFAULT '0', `external_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `total_replies` int(9) NOT NULL DEFAULT '0', `total_reactions` int(9) NOT NULL DEFAULT '0', `last_repy_time` datetime DEFAULT NULL, `last_username_reply` varchar(155) COLLATE utf8_unicode_ci DEFAULT NULL, `last_approved_time` datetime DEFAULT NULL, `last_approved_username` varchar(155) COLLATE utf8_unicode_ci DEFAULT NULL, `author` varchar(155) COLLATE utf8_unicode_ci DEFAULT NULL, `allow_reply` int(1) NOT NULL DEFAULT '1', `sort_order` int(9) NOT NULL DEFAULT '0', `status` int(1) NOT NULL DEFAULT '0', `user_id` varchar(28) COLLATE utf8_unicode_ci DEFAULT NULL, `ent_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `upd_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `bb_threads_data` -- INSERT INTO `bb_threads_data` (`thread_id`, `forum_id`, `prefix_id`, `title`, `friendly_url`, `content`, `descriptions`, `keywords`, `tags`, `views`, `is_stick`, `is_url`, `has_attach_files`, `external_url`, `total_replies`, `total_reactions`, `last_repy_time`, `last_username_reply`, `last_approved_time`, `last_approved_username`, `author`, `allow_reply`, `sort_order`, `status`, `user_id`, `ent_dt`, `upd_dt`) VALUES ('3988028605022341158', '7542150668492', '5405054', 'Test reaction', 'Test_reaction_3988028605022341158.html', '<p>Test reaction<img src=\"http://localhost/lioncms/public/bb_contents/smiles/Default/6_9166496418.jpg\" /><img src=\"http://localhost/lioncms/public/bb_contents/smiles/Default/6_9166496418.jpg\" /></p>\n', NULL, '', '', 2, 0, 0, 0, NULL, 0, 0, '2021-09-26 14:04:40', 'admin', NULL, NULL, 'admin', 1, 0, 1, '11015035', '2021-09-26 14:04:40', '2021-09-26 14:04:40'); -- -------------------------------------------------------- -- -- Table structure for table `bb_threads_reactions_data` -- DROP TABLE IF EXISTS `bb_threads_reactions_data`; CREATE TABLE `bb_threads_reactions_data` ( `id` int(9) NOT NULL, `thread_id` varchar(28) COLLATE utf8_bin NOT NULL, `reaction_id` varchar(28) COLLATE utf8_bin NOT NULL, `reaction_text` varchar(50) COLLATE utf8_bin DEFAULT NULL, `user_id` varchar(28) COLLATE utf8_bin NOT NULL, `ent_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -------------------------------------------------------- -- -- Table structure for table `bb_thread_attach_files_data` -- DROP TABLE IF EXISTS `bb_thread_attach_files_data`; CREATE TABLE `bb_thread_attach_files_data` ( `file_id` varchar(28) COLLATE utf8_bin NOT NULL, `post_id` varchar(28) COLLATE utf8_bin NOT NULL, `data_type` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT 'thread', `file_path` varchar(255) COLLATE utf8_bin NOT NULL, `file_name` varchar(155) COLLATE utf8_bin NOT NULL, `file_type` varchar(50) COLLATE utf8_bin DEFAULT NULL, `file_size` float NOT NULL DEFAULT '0', `user_id` varchar(28) COLLATE utf8_bin NOT NULL, `last_download` datetime DEFAULT NULL, `views` int(9) NOT NULL DEFAULT '0', `ent_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -------------------------------------------------------- -- -- Table structure for table `bb_thread_tag_data` -- DROP TABLE IF EXISTS `bb_thread_tag_data`; CREATE TABLE `bb_thread_tag_data` ( `thread_id` varchar(28) COLLATE utf8_bin NOT NULL, `tag` varchar(155) COLLATE utf8_bin NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -------------------------------------------------------- -- -- Table structure for table `bb_thread_transfer_data` -- DROP TABLE IF EXISTS `bb_thread_transfer_data`; CREATE TABLE `bb_thread_transfer_data` ( `id` bigint(11) NOT NULL, `data_type` varchar(30) COLLATE utf8_bin NOT NULL DEFAULT 'thread', `transfer_method` varchar(20) COLLATE utf8_bin NOT NULL DEFAULT 'fee', `post_id` varchar(28) COLLATE utf8_bin DEFAULT NULL, `total_value` double NOT NULL DEFAULT '0', `user_id` varchar(28) COLLATE utf8_bin NOT NULL, `target_user_id` varchar(28) COLLATE utf8_bin NOT NULL, `ent_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -------------------------------------------------------- -- -- Table structure for table `bb_usergroup_ranks_data` -- DROP TABLE IF EXISTS `bb_usergroup_ranks_data`; CREATE TABLE `bb_usergroup_ranks_data` ( `group_id` varchar(28) COLLATE utf8_bin NOT NULL, `rank_id` varchar(14) COLLATE utf8_bin NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -- Dumping data for table `bb_usergroup_ranks_data` -- INSERT INTO `bb_usergroup_ranks_data` (`group_id`, `rank_id`) VALUES ('11016011', '11102012'), ('11016014', '11102011'), ('11016017', '11102011'); -- -------------------------------------------------------- -- -- Table structure for table `bb_users_rank_data` -- DROP TABLE IF EXISTS `bb_users_rank_data`; CREATE TABLE `bb_users_rank_data` ( `user_id` varchar(28) COLLATE utf8_bin NOT NULL, `rank_id` varchar(28) COLLATE utf8_bin NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -- Dumping data for table `bb_users_rank_data` -- INSERT INTO `bb_users_rank_data` (`user_id`, `rank_id`) VALUES ('2225528699395364', '11102011'), ('2225528699395364', '11102012'), ('11015035', '11102012'); -- -------------------------------------------------------- -- -- Table structure for table `bb_user_bookmarks_data` -- DROP TABLE IF EXISTS `bb_user_bookmarks_data`; CREATE TABLE `bb_user_bookmarks_data` ( `bookmark_id` int(9) NOT NULL, `user_id` varchar(28) COLLATE utf8_bin NOT NULL, `url` varchar(255) COLLATE utf8_bin NOT NULL, `ent_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -------------------------------------------------------- -- -- Table structure for table `bb_user_data` -- DROP TABLE IF EXISTS `bb_user_data`; CREATE TABLE `bb_user_data` ( `user_id` varchar(28) COLLATE utf8_bin NOT NULL, `posts` int(9) NOT NULL DEFAULT '0', `threads` int(9) NOT NULL DEFAULT '0', `reactions` int(9) NOT NULL DEFAULT '0', `max_message` int(9) NOT NULL DEFAULT '10000', `created_message` int(9) NOT NULL DEFAULT '0', `message_unread` int(9) NOT NULL DEFAULT '0', `require_view_thread_id` varchar(28) COLLATE utf8_bin DEFAULT NULL, `last_view_forum_id` varchar(28) COLLATE utf8_bin DEFAULT NULL, `last_view_forum_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `last_view_post_id` varchar(28) COLLATE utf8_bin DEFAULT NULL, `last_view_post_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `total_thread_views` int(9) NOT NULL DEFAULT '0', `total_followers` int(9) NOT NULL DEFAULT '0', `total_follows` int(9) NOT NULL DEFAULT '0', `bio` varchar(1000) COLLATE utf8_bin DEFAULT NULL, `website` varchar(155) COLLATE utf8_bin DEFAULT NULL, `skills` varchar(1000) COLLATE utf8_bin DEFAULT NULL, `job` varchar(1000) COLLATE utf8_bin DEFAULT NULL, `signature` varchar(5000) COLLATE utf8_bin DEFAULT NULL, `facebook` varchar(255) COLLATE utf8_bin DEFAULT NULL, `about` varchar(5000) COLLATE utf8_bin DEFAULT NULL, `twitter` varchar(255) COLLATE utf8_bin DEFAULT NULL, `total_points` double NOT NULL DEFAULT '0', `balance` double NOT NULL DEFAULT '0', `reputation` int(9) NOT NULL DEFAULT '0', `wall_banner` varchar(255) COLLATE utf8_bin DEFAULT NULL, `is_show_birthday` int(1) NOT NULL DEFAULT '1', `birthday` date DEFAULT NULL, `gender` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT 'none', `address` varchar(155) COLLATE utf8_bin DEFAULT NULL, `phone1` varchar(20) COLLATE utf8_bin DEFAULT NULL, `phone2` varchar(20) COLLATE utf8_bin DEFAULT NULL, `is_show_online_status` int(1) NOT NULL DEFAULT '1', `is_show_activites` int(1) NOT NULL DEFAULT '1', `allow_view_profile` varchar(30) COLLATE utf8_bin NOT NULL DEFAULT '1', `allow_other_write_on_profile` varchar(30) COLLATE utf8_bin NOT NULL DEFAULT '2', `allow_receive_message` varchar(30) COLLATE utf8_bin NOT NULL DEFAULT '2', `received_news_via_email` int(1) NOT NULL DEFAULT '0', `received_activities_via_email` int(1) NOT NULL DEFAULT '0', `icq` varchar(30) COLLATE utf8_bin DEFAULT NULL, `aim` varchar(30) COLLATE utf8_bin DEFAULT NULL, `skype` varchar(155) COLLATE utf8_bin DEFAULT NULL, `google_talk` varchar(155) COLLATE utf8_bin DEFAULT NULL, `lang` varchar(30) COLLATE utf8_bin DEFAULT NULL, `timezone` varchar(155) COLLATE utf8_bin DEFAULT NULL, `two_step_login_verify` int(1) NOT NULL DEFAULT '0', `is_buy_usergroup` int(1) NOT NULL DEFAULT '0', `last_user_online` datetime DEFAULT NULL, `last_user_ip_address` varchar(30) COLLATE utf8_bin DEFAULT NULL, `last_user_user_agent` varchar(255) COLLATE utf8_bin DEFAULT NULL, `ref_user_id` varchar(28) COLLATE utf8_bin DEFAULT NULL, `coin_btc` double NOT NULL DEFAULT '0', `coin_eth` double NOT NULL DEFAULT '0', `coin_usdt` double NOT NULL DEFAULT '0', `coin_busd` double NOT NULL DEFAULT '0', `coin_bnb` double NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -- Dumping data for table `bb_user_data` -- INSERT INTO `bb_user_data` (`user_id`, `posts`, `threads`, `reactions`, `max_message`, `created_message`, `message_unread`, `require_view_thread_id`, `last_view_forum_id`, `last_view_forum_time`, `last_view_post_id`, `last_view_post_time`, `total_thread_views`, `total_followers`, `total_follows`, `bio`, `website`, `skills`, `job`, `signature`, `facebook`, `about`, `twitter`, `total_points`, `balance`, `reputation`, `wall_banner`, `is_show_birthday`, `birthday`, `gender`, `address`, `phone1`, `phone2`, `is_show_online_status`, `is_show_activites`, `allow_view_profile`, `allow_other_write_on_profile`, `allow_receive_message`, `received_news_via_email`, `received_activities_via_email`, `icq`, `aim`, `skype`, `google_talk`, `lang`, `timezone`, `two_step_login_verify`, `is_buy_usergroup`, `last_user_online`, `last_user_ip_address`, `last_user_user_agent`, `ref_user_id`, `coin_btc`, `coin_eth`, `coin_usdt`, `coin_busd`, `coin_bnb`) VALUES ('11015035', 3, 1, 0, 10000, 1, 1, NULL, NULL, '2021-07-14 08:22:52', NULL, '2021-07-14 08:22:52', 0, 2, 1, NULL, '', NULL, '', '<p>test222666666661111111111111</p>', 'test', '<p>111111111111</p>\n', '', 5030, 2020, 0, 'public/uploads/medias/Untitled_1_7570247654.jpg', 0, NULL, 'male', '', NULL, NULL, 1, 1, '2', '2', '2', 1, 1, '', '', '', '', NULL, 'Asia/Krasnoyarsk', 0, 0, '2021-09-26 14:05:04', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.159 Safari/537.36', NULL, 0, 0, 0, 0, 0), ('2225528699395364', 0, 0, 0, 0, 0, 0, NULL, NULL, '2021-08-14 14:59:41', NULL, '2021-08-14 14:59:41', 0, 0, 0, NULL, '', NULL, NULL, '', NULL, '', NULL, 5000, 2000, 0, NULL, 1, NULL, 'none', NULL, NULL, NULL, 1, 1, '1', '2', '2', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0), ('263449789430623225', 0, 0, 0, 0, 0, 0, NULL, NULL, '2021-08-14 14:59:41', NULL, '2021-08-14 14:59:41', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5000, 2000, 0, NULL, 1, NULL, 'none', NULL, NULL, NULL, 1, 1, '1', '2', '2', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0), ('3240323645189', 0, 0, 0, 0, 0, 0, NULL, NULL, '2021-08-14 14:59:41', NULL, '2021-08-14 14:59:41', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5000, 2000, 0, NULL, 1, NULL, 'none', NULL, NULL, NULL, 1, 1, '1', '2', '2', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0), ('4056179583243', 0, 0, 0, 0, 0, 0, NULL, NULL, '2021-08-07 08:43:15', NULL, '2021-08-07 08:43:15', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5000, 2000, 0, NULL, 1, NULL, 'none', NULL, NULL, NULL, 1, 1, '1', '2', '4', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0), ('4178215896315', 0, 0, 0, 0, 0, 1, NULL, NULL, '2021-08-07 08:43:15', NULL, '2021-08-07 08:43:15', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5000, 2000, 0, NULL, 1, NULL, 'none', NULL, NULL, NULL, 1, 1, '1', '2', '2', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0), ('4334400142326', 0, 0, 0, 1000, 1, 0, NULL, NULL, '2021-08-07 08:43:15', NULL, '2021-08-07 08:43:15', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5000, 2000, 0, NULL, 1, NULL, 'none', NULL, NULL, NULL, 1, 1, '1', '2', '2', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, '2021-08-21 15:10:07', NULL, NULL, NULL, 0, 0, 0, 0, 0), ('6232599404137301', 0, 0, 0, 0, 0, 0, NULL, NULL, '2021-08-14 14:59:41', NULL, '2021-08-14 14:59:41', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5000, 2000, 0, NULL, 1, NULL, 'none', NULL, NULL, NULL, 1, 1, '1', '2', '2', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0), ('7051082416067962549', 6, 0, 0, 10000, 0, 1, NULL, NULL, '2021-09-14 09:36:19', NULL, '2021-09-14 09:36:19', 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 4970, 1980, 0, NULL, 1, NULL, 'none', NULL, NULL, NULL, 1, 1, '1', '2', '2', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, '2021-09-25 17:14:54', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:81.0) Gecko/20100101 Firefox/81.0', NULL, 0, 0, 0, 0, 0), ('5462980114593', 0, 0, 0, 10000, 0, 0, NULL, NULL, '2021-09-26 09:32:16', NULL, '2021-09-26 09:32:16', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, NULL, 1, NULL, 'none', NULL, NULL, NULL, 1, 1, '1', '2', '2', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0); -- -------------------------------------------------------- -- -- Table structure for table `bb_user_disallow_forum` -- DROP TABLE IF EXISTS `bb_user_disallow_forum`; CREATE TABLE `bb_user_disallow_forum` ( `forum_id` varchar(28) COLLATE utf8_bin NOT NULL, `user_id` varchar(28) COLLATE utf8_bin NOT NULL, `insert_id` varchar(28) COLLATE utf8_bin NOT NULL, `ent_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -------------------------------------------------------- -- -- Table structure for table `bb_user_disallow_register` -- DROP TABLE IF EXISTS `bb_user_disallow_register`; CREATE TABLE `bb_user_disallow_register` ( `username` varchar(155) COLLATE utf8_bin NOT NULL, `ent_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -- Dumping data for table `bb_user_disallow_register` -- INSERT INTO `bb_user_disallow_register` (`username`, `ent_dt`) VALUES ('admin', '2021-08-08 15:35:49'), ('administrator', '2021-08-08 15:35:50'), ('bulletinboard', '2021-08-08 15:35:50'), ('coffeecms', '2021-08-08 15:35:50'), ('fuck', '2021-08-10 13:56:25'), ('guest', '2021-08-08 15:35:50'), ('login', '2021-08-08 15:35:50'), ('manager', '2021-08-08 15:35:49'), ('mod', '2021-08-08 15:35:49'), ('moderate', '2021-08-08 15:35:49'), ('moderator', '2021-08-08 15:35:49'), ('register', '2021-08-08 15:35:50'), ('system', '2021-08-08 15:35:49'); -- -------------------------------------------------------- -- -- Table structure for table `bb_user_follow_data` -- DROP TABLE IF EXISTS `bb_user_follow_data`; CREATE TABLE `bb_user_follow_data` ( `follow_id` varchar(28) COLLATE utf8_bin NOT NULL, `user_id` varchar(28) COLLATE utf8_bin NOT NULL, `followed_user_id` varchar(28) COLLATE utf8_bin NOT NULL, `ent_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -- Dumping data for table `bb_user_follow_data` -- INSERT INTO `bb_user_follow_data` (`follow_id`, `user_id`, `followed_user_id`, `ent_dt`) VALUES ('56372919133641335235942', '11015035', '11015035', '2021-07-31 16:21:44'), ('25029572496604741003826', '7051082416067962549', '11015035', '2021-09-14 09:36:45'); -- -------------------------------------------------------- -- -- Table structure for table `bb_user_group_data` -- DROP TABLE IF EXISTS `bb_user_group_data`; CREATE TABLE `bb_user_group_data` ( `group_id` varchar(28) COLLATE utf8_bin NOT NULL, `left_str` varchar(5000) COLLATE utf8_bin DEFAULT NULL, `right_str` varchar(5000) COLLATE utf8_bin DEFAULT NULL, `max_message` int(9) NOT NULL DEFAULT '10000', `user_id` varchar(28) COLLATE utf8_bin DEFAULT NULL, `ent_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `upd_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -------------------------------------------------------- -- -- Table structure for table `bb_user_wall_comment_data` -- DROP TABLE IF EXISTS `bb_user_wall_comment_data`; CREATE TABLE `bb_user_wall_comment_data` ( `message_id` varchar(28) COLLATE utf8_bin NOT NULL, `content` text COLLATE utf8_bin NOT NULL, `wall_user_id` varchar(28) COLLATE utf8_bin NOT NULL, `author_id` varchar(28) COLLATE utf8_bin NOT NULL, `status` int(1) NOT NULL DEFAULT '1', `ent_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -------------------------------------------------------- -- -- Table structure for table `bb_visitor_views_data` -- DROP TABLE IF EXISTS `bb_visitor_views_data`; CREATE TABLE `bb_visitor_views_data` ( `id` int(9) NOT NULL, `session_id` varchar(155) COLLATE utf8_bin NOT NULL, `username` varchar(255) COLLATE utf8_bin DEFAULT NULL, `ip_address` varchar(24) COLLATE utf8_bin NOT NULL, `user_agent` varchar(500) COLLATE utf8_bin DEFAULT NULL, `page_url` varchar(255) COLLATE utf8_bin DEFAULT NULL, `referrer_url` varchar(255) COLLATE utf8_bin DEFAULT NULL, `referrer_site` varchar(255) COLLATE utf8_bin DEFAULT NULL, `referrer_type` varchar(50) COLLATE utf8_bin NOT NULL DEFAULT 'website', `os_title` varchar(100) COLLATE utf8_bin DEFAULT NULL, `os_version` varchar(100) COLLATE utf8_bin DEFAULT NULL, `browser_title` varchar(155) COLLATE utf8_bin DEFAULT NULL, `browser_version` varchar(30) COLLATE utf8_bin DEFAULT NULL, `is_mobile` int(1) NOT NULL DEFAULT '0', `is_tablet` int(1) NOT NULL DEFAULT '0', `is_windows` int(1) NOT NULL DEFAULT '0', `is_linux` int(1) NOT NULL DEFAULT '0', `is_android` int(1) NOT NULL DEFAULT '0', `is_ios` int(1) NOT NULL DEFAULT '0', `country_name` varchar(50) COLLATE utf8_bin DEFAULT NULL, `ent_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -- Indexes for dumped tables -- -- -- Indexes for table `bb_ads_thread_data` -- ALTER TABLE `bb_ads_thread_data` ADD PRIMARY KEY (`ads_id`), ADD KEY `thread_id` (`thread_id`), ADD KEY `ads_id` (`ads_id`), ADD KEY `start_date` (`start_date`), ADD KEY `end_date` (`end_date`), ADD KEY `status` (`status`), ADD KEY `method` (`method`), ADD KEY `sort_order` (`sort_order`), ADD KEY `ent_dt` (`ent_dt`), ADD KEY `forum_id` (`forum_id`); -- -- Indexes for table `bb_alert_data` -- ALTER TABLE `bb_alert_data` ADD PRIMARY KEY (`alert_id`), ADD KEY `user_id` (`user_id`), ADD KEY `ent_dt` (`ent_dt`); -- -- Indexes for table `bb_annoucement_data` -- ALTER TABLE `bb_annoucement_data` ADD KEY `a_id` (`a_id`), ADD KEY `forum_id` (`forum_id`), ADD KEY `group_id` (`group_id`), ADD KEY `ent_dt` (`ent_dt`), ADD KEY `status` (`status`), ADD KEY `upd_dt` (`upd_dt`); -- -- Indexes for table `bb_banned_browser_data` -- ALTER TABLE `bb_banned_browser_data` ADD PRIMARY KEY (`browser_name`), ADD KEY `browser_name` (`browser_name`); -- -- Indexes for table `bb_banned_ip_data` -- ALTER TABLE `bb_banned_ip_data` ADD PRIMARY KEY (`ip_address`), ADD KEY `ip_address` (`ip_address`); -- -- Indexes for table `bb_banned_os_data` -- ALTER TABLE `bb_banned_os_data` ADD PRIMARY KEY (`os_name`), ADD KEY `os_name` (`os_name`); -- -- Indexes for table `bb_banned_user_data` -- ALTER TABLE `bb_banned_user_data` ADD KEY `data_method` (`data_method`), ADD KEY `username` (`username`); -- -- Indexes for table `bb_bbcode_data` -- ALTER TABLE `bb_bbcode_data` ADD PRIMARY KEY (`bbcode_id`), ADD KEY `bbcode_id` (`bbcode_id`), ADD KEY `tagname` (`tagname`), ADD KEY `status` (`status`), ADD KEY `upd_dt` (`upd_dt`); -- -- Indexes for table `bb_bbcode_hide_pay_data` -- ALTER TABLE `bb_bbcode_hide_pay_data` ADD PRIMARY KEY (`id`), ADD KEY `data_type` (`data_type`), ADD KEY `post_id` (`post_id`), ADD KEY `item_id` (`item_id`), ADD KEY `pay_method` (`pay_method`), ADD KEY `seller_id` (`seller_id`), ADD KEY `buyer_id` (`buyer_id`), ADD KEY `status` (`status`), ADD KEY `id` (`id`); -- -- Indexes for table `bb_bot_detect_data` -- ALTER TABLE `bb_bot_detect_data` ADD PRIMARY KEY (`id`); -- -- Indexes for table `bb_buy_usergroup_data` -- ALTER TABLE `bb_buy_usergroup_data` ADD KEY `target_user_id` (`target_user_id`), ADD KEY `group_id` (`group_id`), ADD KEY `start_date` (`start_date`), ADD KEY `end_date` (`end_date`), ADD KEY `ent_dt` (`ent_dt`), ADD KEY `order_id` (`order_id`); -- -- Indexes for table `bb_capcha_questions_data` -- ALTER TABLE `bb_capcha_questions_data` ADD PRIMARY KEY (`question_id`), ADD KEY `status` (`status`), ADD KEY `upd_dt` (`upd_dt`); -- -- Indexes for table `bb_captcha_image_session_data` -- ALTER TABLE `bb_captcha_image_session_data` ADD KEY `session_id` (`session_id`), ADD KEY `ent_dt` (`ent_dt`); -- -- Indexes for table `bb_captcha_session_data` -- ALTER TABLE `bb_captcha_session_data` ADD PRIMARY KEY (`id`), ADD KEY `session_id` (`session_id`), ADD KEY `captcha_id` (`captcha_id`), ADD KEY `answer` (`answer`); -- -- Indexes for table `bb_category_mst` -- ALTER TABLE `bb_category_mst` ADD PRIMARY KEY (`category_c`), ADD KEY `ix1` (`category_c`), ADD KEY `ix2` (`title`), ADD KEY `ix3` (`friendly_url`), ADD KEY `ix4` (`status`), ADD KEY `sort_order` (`sort_order`), ADD KEY `upd_dt` (`upd_dt`), ADD KEY `views` (`views`), ADD KEY `user_id` (`user_id`); -- -- Indexes for table `bb_disallow_word_data` -- ALTER TABLE `bb_disallow_word_data` ADD PRIMARY KEY (`word`); -- -- Indexes for table `bb_forum_data` -- ALTER TABLE `bb_forum_data` ADD PRIMARY KEY (`forum_id`), ADD KEY `forum_id` (`forum_id`), ADD KEY `status` (`status`), ADD KEY `parent_id` (`parent_id`), ADD KEY `user_id` (`user_id`), ADD KEY `ent_dt` (`ent_dt`), ADD KEY `upd_dt` (`upd_dt`), ADD KEY `forum_type` (`forum_type`), ADD KEY `sort_order` (`sort_order`); -- -- Indexes for table `bb_forum_message_data` -- ALTER TABLE `bb_forum_message_data` ADD PRIMARY KEY (`message_id`), ADD KEY `forum_id` (`forum_id`), ADD KEY `message_id` (`message_id`), ADD KEY `ent_dt` (`ent_dt`), ADD KEY `user_id` (`user_id`); -- -- Indexes for table `bb_forum_usergroup_permission_data` -- ALTER TABLE `bb_forum_usergroup_permission_data` ADD KEY `forum_id` (`forum_id`), ADD KEY `group_id` (`group_id`); -- -- Indexes for table `bb_forum_user_permission_data` -- ALTER TABLE `bb_forum_user_permission_data` ADD KEY `forum_id` (`forum_id`), ADD KEY `user_id` (`user_id`); -- -- Indexes for table `bb_hook_content_key_data` -- ALTER TABLE `bb_hook_content_key_data` ADD PRIMARY KEY (`key_c`), ADD KEY `key_c` (`key_c`); -- -- Indexes for table `bb_html_global_data` -- ALTER TABLE `bb_html_global_data` ADD PRIMARY KEY (`html_c`), ADD KEY `html_c` (`html_c`), ADD KEY `status` (`status`), ADD KEY `upd_dt` (`upd_dt`); -- -- Indexes for table `bb_message_ads_data` -- ALTER TABLE `bb_message_ads_data` ADD PRIMARY KEY (`ads_id`), ADD KEY `ent_dt` (`ent_dt`), ADD KEY `user_id` (`user_id`), ADD KEY `group_id` (`group_id`), ADD KEY `message_id` (`message_id`); -- -- Indexes for table `bb_message_attach_files_data` -- ALTER TABLE `bb_message_attach_files_data` ADD PRIMARY KEY (`file_id`), ADD KEY `file_id` (`file_id`), ADD KEY `user_id` (`user_id`), ADD KEY `file_size` (`file_size`), ADD KEY `file_path` (`file_path`), ADD KEY `views` (`views`), ADD KEY `last_download` (`last_download`), ADD KEY `file_type` (`file_type`), ADD KEY `file_name` (`file_name`), ADD KEY `message_id` (`message_id`), ADD KEY `ent_dt` (`ent_dt`); -- -- Indexes for table `bb_message_data` -- ALTER TABLE `bb_message_data` ADD PRIMARY KEY (`message_id`), ADD KEY `message_id` (`message_id`), ADD KEY `subject` (`subject`), ADD KEY `user_id` (`user_id`), ADD KEY `ent_dt` (`ent_dt`), ADD KEY `username` (`username`), ADD KEY `parent_id` (`parent_id`), ADD KEY `is_read` (`is_read`); -- -- Indexes for table `bb_message_user_data` -- ALTER TABLE `bb_message_user_data` ADD KEY `message_id` (`message_id`), ADD KEY `target_username` (`target_username`), ADD KEY `target_user_id` (`target_user_id`), ADD KEY `source_user_id` (`source_user_id`); -- -- Indexes for table `bb_notifies_data` -- ALTER TABLE `bb_notifies_data` ADD PRIMARY KEY (`id`), ADD KEY `id` (`id`), ADD KEY `ent_dt` (`ent_dt`), ADD KEY `user_id` (`user_id`); -- -- Indexes for table `bb_notifies_user_data` -- ALTER TABLE `bb_notifies_user_data` ADD PRIMARY KEY (`id`); -- -- Indexes for table `bb_poll_answer_data` -- ALTER TABLE `bb_poll_answer_data` ADD PRIMARY KEY (`answer_id`), ADD KEY `answer_id` (`answer_id`), ADD KEY `poll_id` (`poll_id`), ADD KEY `sort_order` (`sort_order`); -- -- Indexes for table `bb_poll_data` -- ALTER TABLE `bb_poll_data` ADD PRIMARY KEY (`poll_id`), ADD KEY `poll_id` (`poll_id`), ADD KEY `status` (`status`), ADD KEY `user_id` (`user_id`), ADD KEY `upd_dt` (`upd_dt`), ADD KEY `end_dt` (`end_dt`), ADD KEY `thread_id` (`thread_id`); -- -- Indexes for table `bb_poll_member_answer_data` -- ALTER TABLE `bb_poll_member_answer_data` ADD PRIMARY KEY (`id`), ADD KEY `poll_id` (`poll_id`), ADD KEY `is_guest` (`is_guest`), ADD KEY `user_id` (`user_id`), ADD KEY `answer_id` (`answer_id`), ADD KEY `visitor_hash` (`visitor_hash`), ADD KEY `id` (`id`); -- -- Indexes for table `bb_posts_data` -- ALTER TABLE `bb_posts_data` ADD PRIMARY KEY (`post_id`), ADD KEY `user_id` (`user_id`), ADD KEY `upd_dt` (`upd_dt`), ADD KEY `ent_dt` (`ent_dt`), ADD KEY `post_id` (`post_id`), ADD KEY `thread_id` (`thread_id`), ADD KEY `sort_order` (`sort_order`), ADD KEY `total_reactions` (`total_reactions`), ADD KEY `has_attach_files` (`has_attach_files`); -- -- Indexes for table `bb_post_attach_files_data` -- ALTER TABLE `bb_post_attach_files_data` ADD PRIMARY KEY (`file_id`), ADD KEY `file_id` (`file_id`), ADD KEY `post_id` (`post_id`), ADD KEY `user_id` (`user_id`), ADD KEY `file_size` (`file_size`), ADD KEY `file_path` (`file_path`), ADD KEY `views` (`views`), ADD KEY `last_download` (`last_download`), ADD KEY `file_type` (`file_type`), ADD KEY `file_name` (`file_name`); -- -- Indexes for table `bb_post_prefix_data` -- ALTER TABLE `bb_post_prefix_data` ADD PRIMARY KEY (`prefix_id`), ADD KEY `prefix_id` (`prefix_id`), ADD KEY `status` (`status`), ADD KEY `title` (`title`), ADD KEY `upd_dt` (`upd_dt`); -- -- Indexes for table `bb_post_reactions_count_data` -- ALTER TABLE `bb_post_reactions_count_data` ADD KEY `post_id` (`post_id`), ADD KEY `total` (`total`), ADD KEY `reaction_id` (`reaction_id`); -- -- Indexes for table `bb_post_reactions_data` -- ALTER TABLE `bb_post_reactions_data` ADD PRIMARY KEY (`id`), ADD KEY `post_id` (`post_id`), ADD KEY `reaction_id` (`reaction_id`), ADD KEY `user_id` (`user_id`), ADD KEY `reaction_text` (`reaction_text`); -- -- Indexes for table `bb_post_tag_data` -- ALTER TABLE `bb_post_tag_data` ADD KEY `post_id` (`post_id`), ADD KEY `tag` (`tag`); -- -- Indexes for table `bb_ranks_data` -- ALTER TABLE `bb_ranks_data` ADD PRIMARY KEY (`rank_id`), ADD KEY `rank_id` (`rank_id`), ADD KEY `status` (`status`), ADD KEY `upd_dt` (`upd_dt`), ADD KEY `title` (`title`); -- -- Indexes for table `bb_reaction_data` -- ALTER TABLE `bb_reaction_data` ADD PRIMARY KEY (`reaction_id`), ADD KEY `reaction_id` (`reaction_id`), ADD KEY `status` (`status`), ADD KEY `ent_dt` (`ent_dt`), ADD KEY `sort_order` (`sort_order`); -- -- Indexes for table `bb_report_page_data` -- ALTER TABLE `bb_report_page_data` ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`), ADD KEY `ent_dt` (`ent_dt`); -- -- Indexes for table `bb_payment_data` -- ALTER TABLE `bb_payment_data` ADD PRIMARY KEY (`id`), ADD KEY `payment_id` (`payment_id`), ADD KEY `user_id` (`user_id`), ADD KEY `ent_dt` (`ent_dt`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `bb_payment_data` -- ALTER TABLE `bb_payment_data` MODIFY `id` bigint(11) NOT NULL AUTO_INCREMENT; COMMIT; -- -- Indexes for table `bb_shop_cart_data` -- ALTER TABLE `bb_shop_cart_data` ADD KEY `user_id` (`user_id`); -- -- Indexes for table `bb_shop_orders_data` -- ALTER TABLE `bb_shop_orders_data` ADD KEY `upd_dt` (`upd_dt`), ADD KEY `ent_dt` (`ent_dt`), ADD KEY `status` (`status`), ADD KEY `payer_id` (`payer_id`), ADD KEY `order_id` (`order_id`), ADD KEY `product_title` (`product_title`); -- -- Indexes for table `bb_shop_payment_method_data` -- ALTER TABLE `bb_shop_payment_method_data` ADD KEY `payment_method` (`payment_method`), ADD KEY `status` (`status`); -- -- Indexes for table `bb_smiles_category_data` -- ALTER TABLE `bb_smiles_category_data` ADD PRIMARY KEY (`category_id`), ADD KEY `category_id` (`category_id`), ADD KEY `status` (`status`), ADD KEY `ent_dt` (`ent_dt`); -- -- Indexes for table `bb_smiles_data` -- ALTER TABLE `bb_smiles_data` ADD PRIMARY KEY (`smile_id`), ADD KEY `category_id` (`category_id`), ADD KEY `smile_id` (`smile_id`), ADD KEY `sort_order` (`sort_order`); -- -- Indexes for table `bb_smile_most_recent_data` -- ALTER TABLE `bb_smile_most_recent_data` ADD KEY `user_id` (`user_id`), ADD KEY `ent_dt` (`ent_dt`); -- -- Indexes for table `bb_threads_data` -- ALTER TABLE `bb_threads_data` ADD PRIMARY KEY (`thread_id`), ADD KEY `thread_id` (`thread_id`), ADD KEY `views` (`views`), ADD KEY `status` (`status`), ADD KEY `user_id` (`user_id`), ADD KEY `upd_dt` (`upd_dt`), ADD KEY `ent_dt` (`ent_dt`), ADD KEY `is_stick` (`is_stick`), ADD KEY `title` (`title`), ADD KEY `tags` (`tags`), ADD KEY `author` (`author`), ADD KEY `last_approved_time` (`last_approved_time`), ADD KEY `last_approved_username` (`last_approved_username`), ADD KEY `last_username_reply` (`last_username_reply`), ADD KEY `last_repy_time` (`last_repy_time`), ADD KEY `total_replies` (`total_replies`), ADD KEY `sort_order` (`sort_order`), ADD KEY `forum_id` (`forum_id`), ADD KEY `prefix_id` (`prefix_id`), ADD KEY `total_reactions` (`total_reactions`), ADD KEY `has_attach_files` (`has_attach_files`); -- -- Indexes for table `bb_threads_reactions_data` -- ALTER TABLE `bb_threads_reactions_data` ADD PRIMARY KEY (`id`), ADD KEY `reaction_id` (`reaction_id`), ADD KEY `user_id` (`user_id`), ADD KEY `reaction_text` (`reaction_text`), ADD KEY `thread_id` (`thread_id`), ADD KEY `ent_dt` (`ent_dt`); -- -- Indexes for table `bb_thread_attach_files_data` -- ALTER TABLE `bb_thread_attach_files_data` ADD PRIMARY KEY (`file_id`), ADD KEY `file_id` (`file_id`), ADD KEY `post_id` (`post_id`), ADD KEY `user_id` (`user_id`), ADD KEY `file_size` (`file_size`), ADD KEY `file_path` (`file_path`), ADD KEY `views` (`views`), ADD KEY `last_download` (`last_download`), ADD KEY `file_type` (`file_type`), ADD KEY `file_name` (`file_name`), ADD KEY `data_type` (`data_type`); -- -- Indexes for table `bb_thread_tag_data` -- ALTER TABLE `bb_thread_tag_data` ADD KEY `thread_id` (`thread_id`), ADD KEY `tag` (`tag`); -- -- Indexes for table `bb_thread_transfer_data` -- ALTER TABLE `bb_thread_transfer_data` ADD PRIMARY KEY (`id`), ADD KEY `data_type` (`data_type`), ADD KEY `user_id` (`user_id`), ADD KEY `target_user_id` (`target_user_id`), ADD KEY `ent_dt` (`ent_dt`), ADD KEY `post_id` (`post_id`), ADD KEY `transfer_method` (`transfer_method`); -- -- Indexes for table `bb_usergroup_ranks_data` -- ALTER TABLE `bb_usergroup_ranks_data` ADD KEY `group_id` (`group_id`), ADD KEY `rank_id` (`rank_id`); -- -- Indexes for table `bb_users_rank_data` -- ALTER TABLE `bb_users_rank_data` ADD KEY `user_id` (`user_id`), ADD KEY `rank_id` (`rank_id`); -- -- Indexes for table `bb_user_bookmarks_data` -- ALTER TABLE `bb_user_bookmarks_data` ADD PRIMARY KEY (`bookmark_id`), ADD KEY `ent_dt` (`ent_dt`), ADD KEY `user_id` (`user_id`); -- -- Indexes for table `bb_visitor_views_data` -- ALTER TABLE `bb_visitor_views_data` ADD PRIMARY KEY (`id`), ADD KEY `page_url` (`page_url`), ADD KEY `username` (`username`), ADD KEY `ip_address` (`ip_address`), ADD KEY `session_id` (`session_id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `bb_alert_data` -- ALTER TABLE `bb_alert_data` MODIFY `alert_id` bigint(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `bb_bbcode_hide_pay_data` -- ALTER TABLE `bb_bbcode_hide_pay_data` MODIFY `id` bigint(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `bb_bot_detect_data` -- ALTER TABLE `bb_bot_detect_data` MODIFY `id` int(9) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `bb_capcha_questions_data` -- ALTER TABLE `bb_capcha_questions_data` MODIFY `question_id` int(9) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16; -- -- AUTO_INCREMENT for table `bb_captcha_session_data` -- ALTER TABLE `bb_captcha_session_data` MODIFY `id` int(9) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=468; -- -- AUTO_INCREMENT for table `bb_message_ads_data` -- ALTER TABLE `bb_message_ads_data` MODIFY `ads_id` int(9) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `bb_notifies_user_data` -- ALTER TABLE `bb_notifies_user_data` MODIFY `id` bigint(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `bb_poll_member_answer_data` -- ALTER TABLE `bb_poll_member_answer_data` MODIFY `id` bigint(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `bb_post_reactions_data` -- ALTER TABLE `bb_post_reactions_data` MODIFY `id` int(9) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `bb_report_page_data` -- ALTER TABLE `bb_report_page_data` MODIFY `id` int(9) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `bb_threads_reactions_data` -- ALTER TABLE `bb_threads_reactions_data` MODIFY `id` int(9) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `bb_thread_transfer_data` -- ALTER TABLE `bb_thread_transfer_data` MODIFY `id` bigint(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `bb_user_bookmarks_data` -- ALTER TABLE `bb_user_bookmarks_data` MODIFY `bookmark_id` int(9) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `bb_visitor_views_data` -- ALTER TABLE `bb_visitor_views_data` MODIFY `id` int(9) 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 */;