File: //storage02/Bkup/ayaa_ni_dm_db-2022-05-28.sql
-- MariaDB dump 10.19 Distrib 10.4.24-MariaDB, for Linux (x86_64)
--
-- Host: localhost Database: ayaa_ayaani
-- ------------------------------------------------------
-- Server version 10.4.24-MariaDB-log
/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `wprc_actionscheduler_actions`
--
DROP TABLE IF EXISTS `wprc_actionscheduler_actions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_actionscheduler_actions` (
`action_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`hook` varchar(191) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`status` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`scheduled_date_gmt` datetime DEFAULT '0000-00-00 00:00:00',
`scheduled_date_local` datetime DEFAULT '0000-00-00 00:00:00',
`args` varchar(191) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`schedule` longtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`group_id` bigint(20) unsigned NOT NULL DEFAULT 0,
`attempts` int(11) NOT NULL DEFAULT 0,
`last_attempt_gmt` datetime DEFAULT '0000-00-00 00:00:00',
`last_attempt_local` datetime DEFAULT '0000-00-00 00:00:00',
`claim_id` bigint(20) unsigned NOT NULL DEFAULT 0,
`extended_args` varchar(8000) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
PRIMARY KEY (`action_id`),
KEY `hook` (`hook`),
KEY `status` (`status`),
KEY `scheduled_date_gmt` (`scheduled_date_gmt`),
KEY `args` (`args`),
KEY `group_id` (`group_id`),
KEY `last_attempt_gmt` (`last_attempt_gmt`),
KEY `claim_id` (`claim_id`),
KEY `claim_id_status_scheduled_date_gmt` (`claim_id`,`status`,`scheduled_date_gmt`)
) ENGINE=InnoDB AUTO_INCREMENT=5086 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_actionscheduler_claims`
--
DROP TABLE IF EXISTS `wprc_actionscheduler_claims`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_actionscheduler_claims` (
`claim_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`date_created_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`claim_id`),
KEY `date_created_gmt` (`date_created_gmt`)
) ENGINE=InnoDB AUTO_INCREMENT=4019 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_actionscheduler_groups`
--
DROP TABLE IF EXISTS `wprc_actionscheduler_groups`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_actionscheduler_groups` (
`group_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`slug` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
PRIMARY KEY (`group_id`),
KEY `slug` (`slug`(191))
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_actionscheduler_logs`
--
DROP TABLE IF EXISTS `wprc_actionscheduler_logs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_actionscheduler_logs` (
`log_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`action_id` bigint(20) unsigned NOT NULL,
`message` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
`log_date_gmt` datetime DEFAULT '0000-00-00 00:00:00',
`log_date_local` datetime DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`log_id`),
KEY `action_id` (`action_id`),
KEY `log_date_gmt` (`log_date_gmt`)
) ENGINE=InnoDB AUTO_INCREMENT=15234 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_commentmeta`
--
DROP TABLE IF EXISTS `wprc_commentmeta`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_commentmeta` (
`meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`comment_id` bigint(20) unsigned NOT NULL DEFAULT 0,
`meta_key` varchar(255) DEFAULT NULL,
`meta_value` longtext DEFAULT NULL,
PRIMARY KEY (`meta_id`),
KEY `comment_id` (`comment_id`),
KEY `meta_key` (`meta_key`(191))
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_comments`
--
DROP TABLE IF EXISTS `wprc_comments`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_comments` (
`comment_ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`comment_post_ID` bigint(20) unsigned NOT NULL DEFAULT 0,
`comment_author` tinytext NOT NULL,
`comment_author_email` varchar(100) NOT NULL DEFAULT '',
`comment_author_url` varchar(200) NOT NULL DEFAULT '',
`comment_author_IP` varchar(100) NOT NULL DEFAULT '',
`comment_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`comment_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`comment_content` text NOT NULL,
`comment_karma` int(11) NOT NULL DEFAULT 0,
`comment_approved` varchar(20) NOT NULL DEFAULT '1',
`comment_agent` varchar(255) NOT NULL DEFAULT '',
`comment_type` varchar(20) NOT NULL DEFAULT 'comment',
`comment_parent` bigint(20) unsigned NOT NULL DEFAULT 0,
`user_id` bigint(20) unsigned NOT NULL DEFAULT 0,
PRIMARY KEY (`comment_ID`),
KEY `comment_post_ID` (`comment_post_ID`),
KEY `comment_approved_date_gmt` (`comment_approved`,`comment_date_gmt`),
KEY `comment_date_gmt` (`comment_date_gmt`),
KEY `comment_parent` (`comment_parent`),
KEY `comment_author_email` (`comment_author_email`(10)),
KEY `woo_idx_comment_type` (`comment_type`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_e_events`
--
DROP TABLE IF EXISTS `wprc_e_events`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_e_events` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`event_data` text COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`created_at` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `created_at_index` (`created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_e_submissions`
--
DROP TABLE IF EXISTS `wprc_e_submissions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_e_submissions` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`type` varchar(60) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`hash_id` varchar(60) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`main_meta_id` bigint(20) unsigned NOT NULL COMMENT 'Id of main field. to represent the main meta field',
`post_id` bigint(20) unsigned NOT NULL,
`referer` varchar(500) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`referer_title` varchar(300) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`element_id` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`form_name` varchar(60) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`campaign_id` bigint(20) unsigned NOT NULL,
`user_id` bigint(20) unsigned DEFAULT NULL,
`user_ip` varchar(46) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`user_agent` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
`actions_count` int(11) DEFAULT 0,
`actions_succeeded_count` int(11) DEFAULT 0,
`status` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`is_read` tinyint(1) NOT NULL DEFAULT 0,
`meta` text COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`created_at_gmt` datetime NOT NULL,
`updated_at_gmt` datetime NOT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `hash_id_unique_index` (`hash_id`),
KEY `main_meta_id_index` (`main_meta_id`),
KEY `hash_id_index` (`hash_id`),
KEY `type_index` (`type`),
KEY `post_id_index` (`post_id`),
KEY `element_id_index` (`element_id`),
KEY `campaign_id_index` (`campaign_id`),
KEY `user_id_index` (`user_id`),
KEY `user_ip_index` (`user_ip`),
KEY `status_index` (`status`),
KEY `is_read_index` (`is_read`),
KEY `created_at_gmt_index` (`created_at_gmt`),
KEY `updated_at_gmt_index` (`updated_at_gmt`),
KEY `created_at_index` (`created_at`),
KEY `updated_at_index` (`updated_at`),
KEY `referer_index` (`referer`(191)),
KEY `referer_title_index` (`referer_title`(191))
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_e_submissions_actions_log`
--
DROP TABLE IF EXISTS `wprc_e_submissions_actions_log`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_e_submissions_actions_log` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`submission_id` bigint(20) unsigned NOT NULL,
`action_name` varchar(60) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`action_label` varchar(60) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`status` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`log` text COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`created_at_gmt` datetime NOT NULL,
`updated_at_gmt` datetime NOT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `submission_id_index` (`submission_id`),
KEY `action_name_index` (`action_name`),
KEY `status_index` (`status`),
KEY `created_at_gmt_index` (`created_at_gmt`),
KEY `updated_at_gmt_index` (`updated_at_gmt`),
KEY `created_at_index` (`created_at`),
KEY `updated_at_index` (`updated_at`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_e_submissions_values`
--
DROP TABLE IF EXISTS `wprc_e_submissions_values`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_e_submissions_values` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`submission_id` bigint(20) unsigned NOT NULL DEFAULT 0,
`key` varchar(60) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`value` longtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `submission_id_index` (`submission_id`),
KEY `key_index` (`key`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_ewwwio_images`
--
DROP TABLE IF EXISTS `wprc_ewwwio_images`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_ewwwio_images` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`attachment_id` bigint(20) unsigned DEFAULT NULL,
`gallery` varchar(10) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`resize` varchar(75) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`path` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
`converted` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
`results` varchar(75) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`image_size` int(10) unsigned DEFAULT NULL,
`orig_size` int(10) unsigned DEFAULT NULL,
`backup` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`level` int(10) unsigned DEFAULT NULL,
`pending` tinyint(4) NOT NULL DEFAULT 0,
`updates` int(10) unsigned DEFAULT NULL,
`updated` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
`trace` blob DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `path` (`path`(191)),
KEY `attachment_info` (`gallery`(3),`attachment_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_ewwwio_queue`
--
DROP TABLE IF EXISTS `wprc_ewwwio_queue`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_ewwwio_queue` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`attachment_id` bigint(20) unsigned DEFAULT NULL,
`gallery` varchar(20) DEFAULT NULL,
`scanned` tinyint(4) NOT NULL DEFAULT 0,
`new` tinyint(4) NOT NULL DEFAULT 0,
PRIMARY KEY (`id`),
KEY `attachment_info` (`gallery`(3),`attachment_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_ffi_cache`
--
DROP TABLE IF EXISTS `wprc_ffi_cache`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_ffi_cache` (
`feed_id` varchar(20) NOT NULL,
`last_update` int(11) NOT NULL,
`status` int(11) NOT NULL DEFAULT 0,
`errors` blob DEFAULT NULL,
`settings` blob DEFAULT NULL,
`enabled` tinyint(1) DEFAULT 0,
`system_enabled` tinyint(1) DEFAULT 1,
`changed_time` int(11) DEFAULT 0,
`cache_lifetime` int(11) DEFAULT 60,
`boosted` varchar(4) DEFAULT 'nope',
`send_email` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (`feed_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_ffi_comments`
--
DROP TABLE IF EXISTS `wprc_ffi_comments`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_ffi_comments` (
`id` varchar(50) NOT NULL,
`post_id` varchar(50) NOT NULL,
`from` blob DEFAULT NULL,
`text` longblob DEFAULT NULL,
`created_time` int(11) DEFAULT NULL,
`updated_time` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_ffi_image_cache`
--
DROP TABLE IF EXISTS `wprc_ffi_image_cache`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_ffi_image_cache` (
`url` varchar(50) NOT NULL,
`width` int(11) DEFAULT NULL,
`height` int(11) DEFAULT NULL,
`creation_time` timestamp NOT NULL DEFAULT current_timestamp(),
`original_url` varchar(300) DEFAULT NULL,
PRIMARY KEY (`url`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_ffi_options`
--
DROP TABLE IF EXISTS `wprc_ffi_options`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_ffi_options` (
`id` varchar(50) NOT NULL,
`value` longblob DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_ffi_post_media`
--
DROP TABLE IF EXISTS `wprc_ffi_post_media`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_ffi_post_media` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`feed_id` varchar(20) NOT NULL,
`post_id` varchar(50) NOT NULL,
`post_type` varchar(10) NOT NULL,
`media_url` text DEFAULT NULL,
`media_width` int(11) DEFAULT NULL,
`media_height` int(11) DEFAULT NULL,
`media_type` varchar(100) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_ffi_posts`
--
DROP TABLE IF EXISTS `wprc_ffi_posts`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_ffi_posts` (
`feed_id` varchar(20) NOT NULL,
`post_id` varchar(50) NOT NULL,
`post_type` varchar(10) NOT NULL,
`post_text` blob DEFAULT NULL,
`post_permalink` varchar(300) DEFAULT NULL,
`post_header` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`user_nickname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`user_screenname` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`user_pic` varchar(700) NOT NULL,
`user_link` varchar(300) DEFAULT NULL,
`rand_order` double DEFAULT NULL,
`creation_index` int(11) NOT NULL DEFAULT 0,
`image_url` text DEFAULT NULL,
`image_width` int(11) DEFAULT NULL,
`image_height` int(11) DEFAULT NULL,
`media_url` text DEFAULT NULL,
`media_width` int(11) DEFAULT NULL,
`media_height` int(11) DEFAULT NULL,
`media_type` varchar(100) DEFAULT NULL,
`post_timestamp` int(11) DEFAULT NULL,
`smart_order` int(11) DEFAULT NULL,
`post_status` varchar(15) DEFAULT NULL,
`post_source` varchar(300) DEFAULT NULL,
`post_additional` varchar(300) DEFAULT NULL,
`user_bio` text DEFAULT NULL,
`user_counts_media` int(11) DEFAULT NULL,
`user_counts_follows` int(11) DEFAULT NULL,
`user_counts_followed_by` int(11) DEFAULT NULL,
`location` text DEFAULT NULL,
`carousel_size` int(11) DEFAULT NULL,
`post_content` blob DEFAULT NULL,
PRIMARY KEY (`post_id`,`post_type`,`feed_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_ffi_snapshots`
--
DROP TABLE IF EXISTS `wprc_ffi_snapshots`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_ffi_snapshots` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`description` varchar(20) DEFAULT NULL,
`creation_time` timestamp NOT NULL DEFAULT current_timestamp(),
`settings` longtext NOT NULL,
`fb_settings` longtext DEFAULT NULL,
`version` varchar(10) NOT NULL DEFAULT '2.0',
`dump` blob DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_ffi_streams`
--
DROP TABLE IF EXISTS `wprc_ffi_streams`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_ffi_streams` (
`id` int(11) NOT NULL,
`name` varchar(250) DEFAULT NULL,
`value` longblob DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_ffi_streams_sources`
--
DROP TABLE IF EXISTS `wprc_ffi_streams_sources`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_ffi_streams_sources` (
`feed_id` varchar(20) NOT NULL,
`stream_id` int(11) NOT NULL,
PRIMARY KEY (`feed_id`,`stream_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_gf_draft_submissions`
--
DROP TABLE IF EXISTS `wprc_gf_draft_submissions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_gf_draft_submissions` (
`uuid` char(32) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`email` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`form_id` mediumint(10) unsigned NOT NULL,
`date_created` datetime NOT NULL,
`ip` varchar(45) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`source_url` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
`submission` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
PRIMARY KEY (`uuid`),
KEY `form_id` (`form_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_gf_entry`
--
DROP TABLE IF EXISTS `wprc_gf_entry`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_gf_entry` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`form_id` mediumint(10) unsigned NOT NULL,
`post_id` bigint(10) unsigned DEFAULT NULL,
`date_created` datetime NOT NULL,
`date_updated` datetime DEFAULT NULL,
`is_starred` tinyint(10) NOT NULL DEFAULT 0,
`is_read` tinyint(10) NOT NULL DEFAULT 0,
`ip` varchar(45) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`source_url` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
`user_agent` varchar(250) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
`currency` varchar(5) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`payment_status` varchar(15) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`payment_date` datetime DEFAULT NULL,
`payment_amount` decimal(19,2) DEFAULT NULL,
`payment_method` varchar(30) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`transaction_id` varchar(50) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`is_fulfilled` tinyint(10) DEFAULT NULL,
`created_by` bigint(10) unsigned DEFAULT NULL,
`transaction_type` tinyint(10) DEFAULT NULL,
`status` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'active',
PRIMARY KEY (`id`),
KEY `form_id` (`form_id`),
KEY `form_id_status` (`form_id`,`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_gf_entry_meta`
--
DROP TABLE IF EXISTS `wprc_gf_entry_meta`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_gf_entry_meta` (
`id` bigint(10) unsigned NOT NULL AUTO_INCREMENT,
`form_id` mediumint(10) unsigned NOT NULL DEFAULT 0,
`entry_id` bigint(10) unsigned NOT NULL,
`meta_key` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`meta_value` longtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`item_index` varchar(60) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `meta_key` (`meta_key`(191)),
KEY `entry_id` (`entry_id`),
KEY `meta_value` (`meta_value`(191))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_gf_entry_notes`
--
DROP TABLE IF EXISTS `wprc_gf_entry_notes`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_gf_entry_notes` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`entry_id` int(10) unsigned NOT NULL,
`user_name` varchar(250) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`user_id` bigint(10) DEFAULT NULL,
`date_created` datetime NOT NULL,
`value` longtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`note_type` varchar(50) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`sub_type` varchar(50) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `entry_id` (`entry_id`),
KEY `entry_user_key` (`entry_id`,`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_gf_form`
--
DROP TABLE IF EXISTS `wprc_gf_form`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_gf_form` (
`id` mediumint(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(150) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`date_created` datetime NOT NULL,
`date_updated` datetime DEFAULT NULL,
`is_active` tinyint(10) NOT NULL DEFAULT 1,
`is_trash` tinyint(10) NOT NULL DEFAULT 0,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_gf_form_meta`
--
DROP TABLE IF EXISTS `wprc_gf_form_meta`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_gf_form_meta` (
`form_id` mediumint(10) unsigned NOT NULL,
`display_meta` longtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`entries_grid_meta` longtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`confirmations` longtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`notifications` longtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
PRIMARY KEY (`form_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_gf_form_revisions`
--
DROP TABLE IF EXISTS `wprc_gf_form_revisions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_gf_form_revisions` (
`id` bigint(10) unsigned NOT NULL AUTO_INCREMENT,
`form_id` mediumint(10) unsigned NOT NULL,
`display_meta` longtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`date_created` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `date_created` (`date_created`),
KEY `form_id` (`form_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_gf_form_view`
--
DROP TABLE IF EXISTS `wprc_gf_form_view`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_gf_form_view` (
`id` bigint(10) unsigned NOT NULL AUTO_INCREMENT,
`form_id` mediumint(10) unsigned NOT NULL,
`date_created` datetime NOT NULL,
`ip` char(15) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`count` mediumint(10) unsigned NOT NULL DEFAULT 1,
PRIMARY KEY (`id`),
KEY `date_created` (`date_created`),
KEY `form_id` (`form_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_links`
--
DROP TABLE IF EXISTS `wprc_links`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_links` (
`link_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`link_url` varchar(255) NOT NULL DEFAULT '',
`link_name` varchar(255) NOT NULL DEFAULT '',
`link_image` varchar(255) NOT NULL DEFAULT '',
`link_target` varchar(25) NOT NULL DEFAULT '',
`link_description` varchar(255) NOT NULL DEFAULT '',
`link_visible` varchar(20) NOT NULL DEFAULT 'Y',
`link_owner` bigint(20) unsigned NOT NULL DEFAULT 1,
`link_rating` int(11) NOT NULL DEFAULT 0,
`link_updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`link_rel` varchar(255) NOT NULL DEFAULT '',
`link_notes` mediumtext NOT NULL,
`link_rss` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`link_id`),
KEY `link_visible` (`link_visible`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_litespeed_avatar`
--
DROP TABLE IF EXISTS `wprc_litespeed_avatar`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_litespeed_avatar` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`url` varchar(1000) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
`md5` varchar(128) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
`dateline` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (`id`),
UNIQUE KEY `md5` (`md5`),
KEY `dateline` (`dateline`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_litespeed_url`
--
DROP TABLE IF EXISTS `wprc_litespeed_url`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_litespeed_url` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`url` varchar(500) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`cache_tags` varchar(1000) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
UNIQUE KEY `url` (`url`(191)),
KEY `cache_tags` (`cache_tags`(191))
) ENGINE=InnoDB AUTO_INCREMENT=141 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_litespeed_url_file`
--
DROP TABLE IF EXISTS `wprc_litespeed_url_file`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_litespeed_url_file` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`url_id` bigint(20) NOT NULL,
`vary` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'md5 of final vary',
`filename` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'md5 of file content',
`type` tinyint(4) NOT NULL COMMENT 'css=1,js=2,ccss=3,ucss=4',
`expired` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (`id`),
KEY `filename` (`filename`),
KEY `type` (`type`),
KEY `url_id_2` (`url_id`,`vary`,`type`),
KEY `filename_2` (`filename`,`expired`),
KEY `url_id` (`url_id`,`expired`)
) ENGINE=InnoDB AUTO_INCREMENT=454 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_loginizer_logs`
--
DROP TABLE IF EXISTS `wprc_loginizer_logs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_loginizer_logs` (
`username` varchar(255) NOT NULL DEFAULT '',
`time` int(10) NOT NULL DEFAULT 0,
`count` int(10) NOT NULL DEFAULT 0,
`lockout` int(10) NOT NULL DEFAULT 0,
`ip` varchar(255) NOT NULL DEFAULT '',
`url` varchar(255) NOT NULL DEFAULT '',
UNIQUE KEY `ip` (`ip`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_options`
--
DROP TABLE IF EXISTS `wprc_options`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_options` (
`option_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`option_name` varchar(191) NOT NULL DEFAULT '',
`option_value` longtext NOT NULL,
`autoload` varchar(20) NOT NULL DEFAULT 'yes',
PRIMARY KEY (`option_id`),
UNIQUE KEY `option_name` (`option_name`),
KEY `autoload` (`autoload`)
) ENGINE=InnoDB AUTO_INCREMENT=1336076 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_postmeta`
--
DROP TABLE IF EXISTS `wprc_postmeta`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_postmeta` (
`meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`post_id` bigint(20) unsigned NOT NULL DEFAULT 0,
`meta_key` varchar(255) DEFAULT NULL,
`meta_value` longtext DEFAULT NULL,
PRIMARY KEY (`meta_id`),
KEY `post_id` (`post_id`),
KEY `meta_key` (`meta_key`(191))
) ENGINE=InnoDB AUTO_INCREMENT=497557 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_posts`
--
DROP TABLE IF EXISTS `wprc_posts`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_posts` (
`ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`post_author` bigint(20) unsigned NOT NULL DEFAULT 0,
`post_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`post_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`post_content` longtext NOT NULL,
`post_title` text NOT NULL,
`post_excerpt` text NOT NULL,
`post_status` varchar(20) NOT NULL DEFAULT 'publish',
`comment_status` varchar(20) NOT NULL DEFAULT 'open',
`ping_status` varchar(20) NOT NULL DEFAULT 'open',
`post_password` varchar(255) NOT NULL DEFAULT '',
`post_name` varchar(200) NOT NULL DEFAULT '',
`to_ping` text NOT NULL,
`pinged` text NOT NULL,
`post_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`post_modified_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`post_content_filtered` longtext NOT NULL,
`post_parent` bigint(20) unsigned NOT NULL DEFAULT 0,
`guid` varchar(255) NOT NULL DEFAULT '',
`menu_order` int(11) NOT NULL DEFAULT 0,
`post_type` varchar(20) NOT NULL DEFAULT 'post',
`post_mime_type` varchar(100) NOT NULL DEFAULT '',
`comment_count` bigint(20) NOT NULL DEFAULT 0,
PRIMARY KEY (`ID`),
KEY `post_name` (`post_name`(191)),
KEY `type_status_date` (`post_type`,`post_status`,`post_date`,`ID`),
KEY `post_parent` (`post_parent`),
KEY `post_author` (`post_author`)
) ENGINE=InnoDB AUTO_INCREMENT=33097 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_revslider_css`
--
DROP TABLE IF EXISTS `wprc_revslider_css`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_revslider_css` (
`id` int(9) NOT NULL AUTO_INCREMENT,
`handle` text NOT NULL,
`settings` longtext DEFAULT NULL,
`hover` longtext DEFAULT NULL,
`advanced` longtext DEFAULT NULL,
`params` longtext NOT NULL,
PRIMARY KEY (`id`),
KEY `handle_index` (`handle`(64))
) ENGINE=InnoDB AUTO_INCREMENT=110 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_revslider_css_bkp`
--
DROP TABLE IF EXISTS `wprc_revslider_css_bkp`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_revslider_css_bkp` (
`id` int(9) NOT NULL AUTO_INCREMENT,
`handle` text NOT NULL,
`settings` longtext DEFAULT NULL,
`hover` longtext DEFAULT NULL,
`advanced` longtext DEFAULT NULL,
`params` longtext NOT NULL,
PRIMARY KEY (`id`),
KEY `handle_index` (`handle`(64))
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_revslider_layer_animations`
--
DROP TABLE IF EXISTS `wprc_revslider_layer_animations`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_revslider_layer_animations` (
`id` int(9) NOT NULL AUTO_INCREMENT,
`handle` text NOT NULL,
`params` text NOT NULL,
`settings` text DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_revslider_layer_animations_bkp`
--
DROP TABLE IF EXISTS `wprc_revslider_layer_animations_bkp`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_revslider_layer_animations_bkp` (
`id` int(9) NOT NULL AUTO_INCREMENT,
`handle` text NOT NULL,
`params` text NOT NULL,
`settings` text DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_revslider_navigations`
--
DROP TABLE IF EXISTS `wprc_revslider_navigations`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_revslider_navigations` (
`id` int(9) NOT NULL AUTO_INCREMENT,
`name` varchar(191) NOT NULL,
`handle` varchar(191) NOT NULL,
`type` varchar(191) NOT NULL,
`css` longtext NOT NULL,
`markup` longtext NOT NULL,
`settings` longtext DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_revslider_navigations_bkp`
--
DROP TABLE IF EXISTS `wprc_revslider_navigations_bkp`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_revslider_navigations_bkp` (
`id` int(9) NOT NULL AUTO_INCREMENT,
`name` varchar(191) NOT NULL,
`handle` varchar(191) NOT NULL,
`type` varchar(191) NOT NULL,
`css` longtext NOT NULL,
`markup` longtext NOT NULL,
`settings` longtext DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_revslider_sliders`
--
DROP TABLE IF EXISTS `wprc_revslider_sliders`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_revslider_sliders` (
`id` int(9) NOT NULL AUTO_INCREMENT,
`title` tinytext NOT NULL,
`alias` tinytext DEFAULT NULL,
`params` longtext NOT NULL,
`settings` text DEFAULT NULL,
`type` varchar(191) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `type_index` (`type`(8))
) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_revslider_sliders_bkp`
--
DROP TABLE IF EXISTS `wprc_revslider_sliders_bkp`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_revslider_sliders_bkp` (
`id` int(9) NOT NULL AUTO_INCREMENT,
`title` tinytext NOT NULL,
`alias` tinytext DEFAULT NULL,
`params` longtext NOT NULL,
`settings` text DEFAULT NULL,
`type` varchar(191) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `type_index` (`type`(8))
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_revslider_slides`
--
DROP TABLE IF EXISTS `wprc_revslider_slides`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_revslider_slides` (
`id` int(9) NOT NULL AUTO_INCREMENT,
`slider_id` int(9) NOT NULL,
`slide_order` int(11) NOT NULL,
`params` longtext NOT NULL,
`layers` longtext NOT NULL,
`settings` text NOT NULL,
PRIMARY KEY (`id`),
KEY `slider_id_index` (`slider_id`)
) ENGINE=InnoDB AUTO_INCREMENT=115 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_revslider_slides_bkp`
--
DROP TABLE IF EXISTS `wprc_revslider_slides_bkp`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_revslider_slides_bkp` (
`id` int(9) NOT NULL AUTO_INCREMENT,
`slider_id` int(9) NOT NULL,
`slide_order` int(11) NOT NULL,
`params` longtext NOT NULL,
`layers` longtext NOT NULL,
`settings` text NOT NULL,
PRIMARY KEY (`id`),
KEY `slider_id_index` (`slider_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_revslider_static_slides`
--
DROP TABLE IF EXISTS `wprc_revslider_static_slides`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_revslider_static_slides` (
`id` int(9) NOT NULL AUTO_INCREMENT,
`slider_id` int(9) NOT NULL,
`params` longtext NOT NULL,
`layers` longtext NOT NULL,
`settings` text NOT NULL,
PRIMARY KEY (`id`),
KEY `slider_id_index` (`slider_id`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_revslider_static_slides_bkp`
--
DROP TABLE IF EXISTS `wprc_revslider_static_slides_bkp`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_revslider_static_slides_bkp` (
`id` int(9) NOT NULL AUTO_INCREMENT,
`slider_id` int(9) NOT NULL,
`params` longtext NOT NULL,
`layers` longtext NOT NULL,
`settings` text NOT NULL,
PRIMARY KEY (`id`),
KEY `slider_id_index` (`slider_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_term_relationships`
--
DROP TABLE IF EXISTS `wprc_term_relationships`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_term_relationships` (
`object_id` bigint(20) unsigned NOT NULL DEFAULT 0,
`term_taxonomy_id` bigint(20) unsigned NOT NULL DEFAULT 0,
`term_order` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (`object_id`,`term_taxonomy_id`),
KEY `term_taxonomy_id` (`term_taxonomy_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_term_taxonomy`
--
DROP TABLE IF EXISTS `wprc_term_taxonomy`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_term_taxonomy` (
`term_taxonomy_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`term_id` bigint(20) unsigned NOT NULL DEFAULT 0,
`taxonomy` varchar(32) NOT NULL DEFAULT '',
`description` longtext NOT NULL,
`parent` bigint(20) unsigned NOT NULL DEFAULT 0,
`count` bigint(20) NOT NULL DEFAULT 0,
PRIMARY KEY (`term_taxonomy_id`),
UNIQUE KEY `term_id_taxonomy` (`term_id`,`taxonomy`),
KEY `taxonomy` (`taxonomy`)
) ENGINE=InnoDB AUTO_INCREMENT=250 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_termmeta`
--
DROP TABLE IF EXISTS `wprc_termmeta`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_termmeta` (
`meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`term_id` bigint(20) unsigned NOT NULL DEFAULT 0,
`meta_key` varchar(255) DEFAULT NULL,
`meta_value` longtext DEFAULT NULL,
PRIMARY KEY (`meta_id`),
KEY `term_id` (`term_id`),
KEY `meta_key` (`meta_key`(191))
) ENGINE=InnoDB AUTO_INCREMENT=4781 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_terms`
--
DROP TABLE IF EXISTS `wprc_terms`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_terms` (
`term_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(200) NOT NULL DEFAULT '',
`slug` varchar(200) NOT NULL DEFAULT '',
`term_group` bigint(10) NOT NULL DEFAULT 0,
PRIMARY KEY (`term_id`),
KEY `slug` (`slug`(191)),
KEY `name` (`name`(191))
) ENGINE=InnoDB AUTO_INCREMENT=250 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_tm_taskmeta`
--
DROP TABLE IF EXISTS `wprc_tm_taskmeta`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_tm_taskmeta` (
`meta_id` bigint(20) NOT NULL AUTO_INCREMENT,
`task_id` bigint(20) NOT NULL DEFAULT 0,
`meta_key` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`meta_value` longtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
PRIMARY KEY (`meta_id`),
KEY `meta_key` (`meta_key`(191)),
KEY `task_id` (`task_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1576 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_tm_tasks`
--
DROP TABLE IF EXISTS `wprc_tm_tasks`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_tm_tasks` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) NOT NULL,
`type` varchar(300) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`class_identifier` varchar(300) COLLATE utf8mb4_unicode_520_ci DEFAULT '0',
`attempts` int(11) DEFAULT 0,
`description` varchar(300) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`time_created` timestamp NOT NULL DEFAULT current_timestamp(),
`last_locked_at` bigint(20) DEFAULT 0,
`status` varchar(300) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1576 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_usermeta`
--
DROP TABLE IF EXISTS `wprc_usermeta`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_usermeta` (
`umeta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) unsigned NOT NULL DEFAULT 0,
`meta_key` varchar(255) DEFAULT NULL,
`meta_value` longtext DEFAULT NULL,
PRIMARY KEY (`umeta_id`),
KEY `user_id` (`user_id`),
KEY `meta_key` (`meta_key`(191))
) ENGINE=InnoDB AUTO_INCREMENT=3011 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_users`
--
DROP TABLE IF EXISTS `wprc_users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_users` (
`ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_login` varchar(60) NOT NULL DEFAULT '',
`user_pass` varchar(255) NOT NULL DEFAULT '',
`user_nicename` varchar(50) NOT NULL DEFAULT '',
`user_email` varchar(100) NOT NULL DEFAULT '',
`user_url` varchar(100) NOT NULL DEFAULT '',
`user_registered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`user_activation_key` varchar(255) NOT NULL DEFAULT '',
`user_status` int(11) NOT NULL DEFAULT 0,
`display_name` varchar(250) NOT NULL DEFAULT '',
PRIMARY KEY (`ID`),
KEY `user_login_key` (`user_login`),
KEY `user_nicename` (`user_nicename`),
KEY `user_email` (`user_email`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_vimeography_gallery`
--
DROP TABLE IF EXISTS `wprc_vimeography_gallery`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_vimeography_gallery` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(150) NOT NULL,
`date_created` datetime NOT NULL,
`is_active` tinyint(1) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_vimeography_gallery_meta`
--
DROP TABLE IF EXISTS `wprc_vimeography_gallery_meta`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_vimeography_gallery_meta` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`gallery_id` mediumint(8) unsigned NOT NULL,
`source_url` varchar(100) NOT NULL,
`resource_uri` varchar(100) NOT NULL,
`featured_video` varchar(100) DEFAULT NULL,
`video_limit` mediumint(7) NOT NULL,
`gallery_width` varchar(10) DEFAULT NULL,
`cache_timeout` mediumint(7) NOT NULL,
`theme_name` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_wc_admin_note_actions`
--
DROP TABLE IF EXISTS `wprc_wc_admin_note_actions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_wc_admin_note_actions` (
`action_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`note_id` bigint(20) unsigned NOT NULL,
`name` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`label` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`query` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
`status` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`is_primary` tinyint(1) NOT NULL DEFAULT 0,
`actioned_text` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`nonce_action` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`nonce_name` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
PRIMARY KEY (`action_id`),
KEY `note_id` (`note_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7492 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_wc_admin_notes`
--
DROP TABLE IF EXISTS `wprc_wc_admin_notes`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_wc_admin_notes` (
`note_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`type` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`locale` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`title` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
`content` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
`content_data` longtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`status` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`source` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`date_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`date_reminder` datetime DEFAULT NULL,
`is_snoozable` tinyint(1) NOT NULL DEFAULT 0,
`layout` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
`image` varchar(200) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`is_deleted` tinyint(1) NOT NULL DEFAULT 0,
`icon` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'info',
`is_read` tinyint(1) NOT NULL DEFAULT 0,
PRIMARY KEY (`note_id`)
) ENGINE=InnoDB AUTO_INCREMENT=66 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_wc_category_lookup`
--
DROP TABLE IF EXISTS `wprc_wc_category_lookup`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_wc_category_lookup` (
`category_tree_id` bigint(20) unsigned NOT NULL,
`category_id` bigint(20) unsigned NOT NULL,
PRIMARY KEY (`category_tree_id`,`category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_wc_customer_lookup`
--
DROP TABLE IF EXISTS `wprc_wc_customer_lookup`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_wc_customer_lookup` (
`customer_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) unsigned DEFAULT NULL,
`username` varchar(60) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
`first_name` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`last_name` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`email` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`date_last_active` timestamp NULL DEFAULT NULL,
`date_registered` timestamp NULL DEFAULT NULL,
`country` char(2) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
`postcode` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
`city` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
`state` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
PRIMARY KEY (`customer_id`),
UNIQUE KEY `user_id` (`user_id`),
KEY `email` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_wc_download_log`
--
DROP TABLE IF EXISTS `wprc_wc_download_log`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_wc_download_log` (
`download_log_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`timestamp` datetime NOT NULL,
`permission_id` bigint(20) unsigned NOT NULL,
`user_id` bigint(20) unsigned DEFAULT NULL,
`user_ip_address` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT '',
PRIMARY KEY (`download_log_id`),
KEY `permission_id` (`permission_id`),
KEY `timestamp` (`timestamp`),
CONSTRAINT `fk_wprc_wc_download_log_permission_id` FOREIGN KEY (`permission_id`) REFERENCES `wprc_woocommerce_downloadable_product_permissions` (`permission_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_wc_order_coupon_lookup`
--
DROP TABLE IF EXISTS `wprc_wc_order_coupon_lookup`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_wc_order_coupon_lookup` (
`order_id` bigint(20) unsigned NOT NULL,
`coupon_id` bigint(20) NOT NULL,
`date_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`discount_amount` double NOT NULL DEFAULT 0,
PRIMARY KEY (`order_id`,`coupon_id`),
KEY `coupon_id` (`coupon_id`),
KEY `date_created` (`date_created`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_wc_order_product_lookup`
--
DROP TABLE IF EXISTS `wprc_wc_order_product_lookup`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_wc_order_product_lookup` (
`order_item_id` bigint(20) unsigned NOT NULL,
`order_id` bigint(20) unsigned NOT NULL,
`product_id` bigint(20) unsigned NOT NULL,
`variation_id` bigint(20) unsigned NOT NULL,
`customer_id` bigint(20) unsigned DEFAULT NULL,
`date_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`product_qty` int(11) NOT NULL,
`product_net_revenue` double NOT NULL DEFAULT 0,
`product_gross_revenue` double NOT NULL DEFAULT 0,
`coupon_amount` double NOT NULL DEFAULT 0,
`tax_amount` double NOT NULL DEFAULT 0,
`shipping_amount` double NOT NULL DEFAULT 0,
`shipping_tax_amount` double NOT NULL DEFAULT 0,
PRIMARY KEY (`order_item_id`),
KEY `order_id` (`order_id`),
KEY `product_id` (`product_id`),
KEY `customer_id` (`customer_id`),
KEY `date_created` (`date_created`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_wc_order_stats`
--
DROP TABLE IF EXISTS `wprc_wc_order_stats`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_wc_order_stats` (
`order_id` bigint(20) unsigned NOT NULL,
`parent_id` bigint(20) unsigned NOT NULL DEFAULT 0,
`date_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`date_created_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`num_items_sold` int(11) NOT NULL DEFAULT 0,
`total_sales` double NOT NULL DEFAULT 0,
`tax_total` double NOT NULL DEFAULT 0,
`shipping_total` double NOT NULL DEFAULT 0,
`net_total` double NOT NULL DEFAULT 0,
`returning_customer` tinyint(1) DEFAULT NULL,
`status` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`customer_id` bigint(20) unsigned NOT NULL,
PRIMARY KEY (`order_id`),
KEY `date_created` (`date_created`),
KEY `customer_id` (`customer_id`),
KEY `status` (`status`(191))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_wc_order_tax_lookup`
--
DROP TABLE IF EXISTS `wprc_wc_order_tax_lookup`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_wc_order_tax_lookup` (
`order_id` bigint(20) unsigned NOT NULL,
`tax_rate_id` bigint(20) unsigned NOT NULL,
`date_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`shipping_tax` double NOT NULL DEFAULT 0,
`order_tax` double NOT NULL DEFAULT 0,
`total_tax` double NOT NULL DEFAULT 0,
PRIMARY KEY (`order_id`,`tax_rate_id`),
KEY `tax_rate_id` (`tax_rate_id`),
KEY `date_created` (`date_created`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_wc_product_meta_lookup`
--
DROP TABLE IF EXISTS `wprc_wc_product_meta_lookup`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_wc_product_meta_lookup` (
`product_id` bigint(20) NOT NULL,
`sku` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT '',
`virtual` tinyint(1) DEFAULT 0,
`downloadable` tinyint(1) DEFAULT 0,
`min_price` decimal(19,4) DEFAULT NULL,
`max_price` decimal(19,4) DEFAULT NULL,
`onsale` tinyint(1) DEFAULT 0,
`stock_quantity` double DEFAULT NULL,
`stock_status` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT 'instock',
`rating_count` bigint(20) DEFAULT 0,
`average_rating` decimal(3,2) DEFAULT 0.00,
`total_sales` bigint(20) DEFAULT 0,
`tax_status` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT 'taxable',
`tax_class` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT '',
PRIMARY KEY (`product_id`),
KEY `virtual` (`virtual`),
KEY `downloadable` (`downloadable`),
KEY `stock_status` (`stock_status`),
KEY `stock_quantity` (`stock_quantity`),
KEY `onsale` (`onsale`),
KEY `min_max_price` (`min_price`,`max_price`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_wc_rate_limits`
--
DROP TABLE IF EXISTS `wprc_wc_rate_limits`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_wc_rate_limits` (
`rate_limit_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`rate_limit_key` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`rate_limit_expiry` bigint(20) unsigned NOT NULL,
PRIMARY KEY (`rate_limit_id`),
UNIQUE KEY `rate_limit_key` (`rate_limit_key`(191))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_wc_reserved_stock`
--
DROP TABLE IF EXISTS `wprc_wc_reserved_stock`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_wc_reserved_stock` (
`order_id` bigint(20) NOT NULL,
`product_id` bigint(20) NOT NULL,
`stock_quantity` double NOT NULL DEFAULT 0,
`timestamp` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`expires` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`order_id`,`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_wc_tax_rate_classes`
--
DROP TABLE IF EXISTS `wprc_wc_tax_rate_classes`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_wc_tax_rate_classes` (
`tax_rate_class_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
`slug` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
PRIMARY KEY (`tax_rate_class_id`),
UNIQUE KEY `slug` (`slug`(191))
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_wc_webhooks`
--
DROP TABLE IF EXISTS `wprc_wc_webhooks`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_wc_webhooks` (
`webhook_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`status` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`name` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
`user_id` bigint(20) unsigned NOT NULL,
`delivery_url` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
`secret` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
`topic` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`date_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`date_created_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`date_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`date_modified_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`api_version` smallint(4) NOT NULL,
`failure_count` smallint(10) NOT NULL DEFAULT 0,
`pending_delivery` tinyint(1) NOT NULL DEFAULT 0,
PRIMARY KEY (`webhook_id`),
KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_wcpdf_invoice_number`
--
DROP TABLE IF EXISTS `wprc_wcpdf_invoice_number`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_wcpdf_invoice_number` (
`id` int(16) NOT NULL AUTO_INCREMENT,
`order_id` int(16) DEFAULT NULL,
`date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`calculated_number` int(16) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_wfblockediplog`
--
DROP TABLE IF EXISTS `wprc_wfblockediplog`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_wfblockediplog` (
`IP` binary(16) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
`countryCode` varchar(2) NOT NULL,
`blockCount` int(10) unsigned NOT NULL DEFAULT 0,
`unixday` int(10) unsigned NOT NULL,
`blockType` varchar(50) NOT NULL DEFAULT 'generic',
PRIMARY KEY (`IP`,`unixday`,`blockType`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_wfblocks7`
--
DROP TABLE IF EXISTS `wprc_wfblocks7`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_wfblocks7` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`type` int(10) unsigned NOT NULL DEFAULT 0,
`IP` binary(16) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
`blockedTime` bigint(20) NOT NULL,
`reason` varchar(255) NOT NULL,
`lastAttempt` int(10) unsigned DEFAULT 0,
`blockedHits` int(10) unsigned DEFAULT 0,
`expiration` bigint(20) unsigned NOT NULL DEFAULT 0,
`parameters` text DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `type` (`type`),
KEY `IP` (`IP`),
KEY `expiration` (`expiration`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_wfconfig`
--
DROP TABLE IF EXISTS `wprc_wfconfig`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_wfconfig` (
`name` varchar(100) NOT NULL,
`val` longblob DEFAULT NULL,
`autoload` enum('no','yes') NOT NULL DEFAULT 'yes',
PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_wfcrawlers`
--
DROP TABLE IF EXISTS `wprc_wfcrawlers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_wfcrawlers` (
`IP` binary(16) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
`patternSig` binary(16) NOT NULL,
`status` char(8) NOT NULL,
`lastUpdate` int(10) unsigned NOT NULL,
`PTR` varchar(255) DEFAULT '',
PRIMARY KEY (`IP`,`patternSig`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_wffilechanges`
--
DROP TABLE IF EXISTS `wprc_wffilechanges`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_wffilechanges` (
`filenameHash` char(64) NOT NULL,
`file` varchar(1000) NOT NULL,
`md5` char(32) NOT NULL,
PRIMARY KEY (`filenameHash`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_wffilemods`
--
DROP TABLE IF EXISTS `wprc_wffilemods`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_wffilemods` (
`filenameMD5` binary(16) NOT NULL,
`filename` varchar(1000) NOT NULL,
`knownFile` tinyint(3) unsigned NOT NULL,
`oldMD5` binary(16) NOT NULL,
`newMD5` binary(16) NOT NULL,
`SHAC` binary(32) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
`stoppedOnSignature` varchar(255) NOT NULL DEFAULT '',
`stoppedOnPosition` int(10) unsigned NOT NULL DEFAULT 0,
`isSafeFile` varchar(1) NOT NULL DEFAULT '?',
PRIMARY KEY (`filenameMD5`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_wfhits`
--
DROP TABLE IF EXISTS `wprc_wfhits`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_wfhits` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`attackLogTime` double(17,6) unsigned NOT NULL,
`ctime` double(17,6) unsigned NOT NULL,
`IP` binary(16) DEFAULT NULL,
`jsRun` tinyint(4) DEFAULT 0,
`statusCode` int(11) NOT NULL DEFAULT 200,
`isGoogle` tinyint(4) NOT NULL,
`userID` int(10) unsigned NOT NULL,
`newVisit` tinyint(3) unsigned NOT NULL,
`URL` text DEFAULT NULL,
`referer` text DEFAULT NULL,
`UA` text DEFAULT NULL,
`action` varchar(64) NOT NULL DEFAULT '',
`actionDescription` text DEFAULT NULL,
`actionData` text DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `k1` (`ctime`),
KEY `k2` (`IP`,`ctime`),
KEY `attackLogTime` (`attackLogTime`)
) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_wfhoover`
--
DROP TABLE IF EXISTS `wprc_wfhoover`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_wfhoover` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`owner` text DEFAULT NULL,
`host` text DEFAULT NULL,
`path` text DEFAULT NULL,
`hostKey` varbinary(124) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `k2` (`hostKey`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_wfissues`
--
DROP TABLE IF EXISTS `wprc_wfissues`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_wfissues` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`time` int(10) unsigned NOT NULL,
`lastUpdated` int(10) unsigned NOT NULL,
`status` varchar(10) NOT NULL,
`type` varchar(20) NOT NULL,
`severity` tinyint(3) unsigned NOT NULL,
`ignoreP` char(32) NOT NULL,
`ignoreC` char(32) NOT NULL,
`shortMsg` varchar(255) NOT NULL,
`longMsg` text DEFAULT NULL,
`data` text DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `lastUpdated` (`lastUpdated`),
KEY `status` (`status`),
KEY `ignoreP` (`ignoreP`),
KEY `ignoreC` (`ignoreC`)
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_wfknownfilelist`
--
DROP TABLE IF EXISTS `wprc_wfknownfilelist`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_wfknownfilelist` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`path` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=27672 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_wflivetraffichuman`
--
DROP TABLE IF EXISTS `wprc_wflivetraffichuman`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_wflivetraffichuman` (
`IP` binary(16) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
`identifier` binary(32) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
`expiration` int(10) unsigned NOT NULL,
PRIMARY KEY (`IP`,`identifier`),
KEY `expiration` (`expiration`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_wflocs`
--
DROP TABLE IF EXISTS `wprc_wflocs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_wflocs` (
`IP` binary(16) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
`ctime` int(10) unsigned NOT NULL,
`failed` tinyint(3) unsigned NOT NULL,
`city` varchar(255) DEFAULT '',
`region` varchar(255) DEFAULT '',
`countryName` varchar(255) DEFAULT '',
`countryCode` char(2) DEFAULT '',
`lat` float(10,7) DEFAULT 0.0000000,
`lon` float(10,7) DEFAULT 0.0000000,
PRIMARY KEY (`IP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_wflogins`
--
DROP TABLE IF EXISTS `wprc_wflogins`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_wflogins` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`hitID` int(11) DEFAULT NULL,
`ctime` double(17,6) unsigned NOT NULL,
`fail` tinyint(3) unsigned NOT NULL,
`action` varchar(40) NOT NULL,
`username` varchar(255) NOT NULL,
`userID` int(10) unsigned NOT NULL,
`IP` binary(16) DEFAULT NULL,
`UA` text DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `k1` (`IP`,`fail`),
KEY `hitID` (`hitID`)
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_wfls_2fa_secrets`
--
DROP TABLE IF EXISTS `wprc_wfls_2fa_secrets`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_wfls_2fa_secrets` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) unsigned NOT NULL,
`secret` tinyblob NOT NULL,
`recovery` blob NOT NULL,
`ctime` int(10) unsigned NOT NULL,
`vtime` int(10) unsigned NOT NULL,
`mode` enum('authenticator') NOT NULL DEFAULT 'authenticator',
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_wfls_settings`
--
DROP TABLE IF EXISTS `wprc_wfls_settings`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_wfls_settings` (
`name` varchar(191) NOT NULL DEFAULT '',
`value` longblob DEFAULT NULL,
`autoload` enum('no','yes') NOT NULL DEFAULT 'yes',
PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_wfnotifications`
--
DROP TABLE IF EXISTS `wprc_wfnotifications`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_wfnotifications` (
`id` varchar(32) NOT NULL DEFAULT '',
`new` tinyint(3) unsigned NOT NULL DEFAULT 1,
`category` varchar(255) NOT NULL,
`priority` int(11) NOT NULL DEFAULT 1000,
`ctime` int(10) unsigned NOT NULL,
`html` text NOT NULL,
`links` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_wfpendingissues`
--
DROP TABLE IF EXISTS `wprc_wfpendingissues`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_wfpendingissues` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`time` int(10) unsigned NOT NULL,
`lastUpdated` int(10) unsigned NOT NULL,
`status` varchar(10) NOT NULL,
`type` varchar(20) NOT NULL,
`severity` tinyint(3) unsigned NOT NULL,
`ignoreP` char(32) NOT NULL,
`ignoreC` char(32) NOT NULL,
`shortMsg` varchar(255) NOT NULL,
`longMsg` text DEFAULT NULL,
`data` text DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `lastUpdated` (`lastUpdated`),
KEY `status` (`status`),
KEY `ignoreP` (`ignoreP`),
KEY `ignoreC` (`ignoreC`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_wfreversecache`
--
DROP TABLE IF EXISTS `wprc_wfreversecache`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_wfreversecache` (
`IP` binary(16) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
`host` varchar(255) NOT NULL,
`lastUpdate` int(10) unsigned NOT NULL,
PRIMARY KEY (`IP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_wfsnipcache`
--
DROP TABLE IF EXISTS `wprc_wfsnipcache`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_wfsnipcache` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`IP` varchar(45) NOT NULL DEFAULT '',
`expiration` timestamp NOT NULL DEFAULT current_timestamp(),
`body` varchar(255) NOT NULL DEFAULT '',
`count` int(10) unsigned NOT NULL DEFAULT 0,
`type` int(10) unsigned NOT NULL DEFAULT 0,
PRIMARY KEY (`id`),
KEY `expiration` (`expiration`),
KEY `IP` (`IP`),
KEY `type` (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_wfstatus`
--
DROP TABLE IF EXISTS `wprc_wfstatus`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_wfstatus` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`ctime` double(17,6) unsigned NOT NULL,
`level` tinyint(3) unsigned NOT NULL,
`type` char(5) NOT NULL,
`msg` varchar(1000) NOT NULL,
PRIMARY KEY (`id`),
KEY `k1` (`ctime`),
KEY `k2` (`type`)
) ENGINE=InnoDB AUTO_INCREMENT=1562 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_wftrafficrates`
--
DROP TABLE IF EXISTS `wprc_wftrafficrates`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_wftrafficrates` (
`eMin` int(10) unsigned NOT NULL,
`IP` binary(16) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
`hitType` enum('hit','404') NOT NULL DEFAULT 'hit',
`hits` int(10) unsigned NOT NULL,
PRIMARY KEY (`eMin`,`IP`,`hitType`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_woocommerce_api_keys`
--
DROP TABLE IF EXISTS `wprc_woocommerce_api_keys`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_woocommerce_api_keys` (
`key_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) unsigned NOT NULL,
`description` varchar(200) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`permissions` varchar(10) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`consumer_key` char(64) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`consumer_secret` char(43) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`nonces` longtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`truncated_key` char(7) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`last_access` datetime DEFAULT NULL,
PRIMARY KEY (`key_id`),
KEY `consumer_key` (`consumer_key`),
KEY `consumer_secret` (`consumer_secret`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_woocommerce_attribute_taxonomies`
--
DROP TABLE IF EXISTS `wprc_woocommerce_attribute_taxonomies`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_woocommerce_attribute_taxonomies` (
`attribute_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`attribute_name` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`attribute_label` varchar(200) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`attribute_type` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`attribute_orderby` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`attribute_public` int(1) NOT NULL DEFAULT 1,
PRIMARY KEY (`attribute_id`),
KEY `attribute_name` (`attribute_name`(20))
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_woocommerce_downloadable_product_permissions`
--
DROP TABLE IF EXISTS `wprc_woocommerce_downloadable_product_permissions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_woocommerce_downloadable_product_permissions` (
`permission_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`download_id` varchar(36) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`product_id` bigint(20) unsigned NOT NULL,
`order_id` bigint(20) unsigned NOT NULL DEFAULT 0,
`order_key` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`user_email` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`user_id` bigint(20) unsigned DEFAULT NULL,
`downloads_remaining` varchar(9) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`access_granted` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`access_expires` datetime DEFAULT NULL,
`download_count` bigint(20) unsigned NOT NULL DEFAULT 0,
PRIMARY KEY (`permission_id`),
KEY `download_order_key_product` (`product_id`,`order_id`,`order_key`(16),`download_id`),
KEY `download_order_product` (`download_id`,`order_id`,`product_id`),
KEY `order_id` (`order_id`),
KEY `user_order_remaining_expires` (`user_id`,`order_id`,`downloads_remaining`,`access_expires`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_woocommerce_log`
--
DROP TABLE IF EXISTS `wprc_woocommerce_log`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_woocommerce_log` (
`log_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`timestamp` datetime NOT NULL,
`level` smallint(4) NOT NULL,
`source` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`message` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
`context` longtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
PRIMARY KEY (`log_id`),
KEY `level` (`level`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_woocommerce_order_itemmeta`
--
DROP TABLE IF EXISTS `wprc_woocommerce_order_itemmeta`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_woocommerce_order_itemmeta` (
`meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`order_item_id` bigint(20) unsigned NOT NULL,
`meta_key` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`meta_value` longtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
PRIMARY KEY (`meta_id`),
KEY `order_item_id` (`order_item_id`),
KEY `meta_key` (`meta_key`(32))
) ENGINE=InnoDB AUTO_INCREMENT=187 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_woocommerce_order_items`
--
DROP TABLE IF EXISTS `wprc_woocommerce_order_items`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_woocommerce_order_items` (
`order_item_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`order_item_name` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
`order_item_type` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
`order_id` bigint(20) unsigned NOT NULL,
PRIMARY KEY (`order_item_id`),
KEY `order_id` (`order_id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_woocommerce_payment_tokenmeta`
--
DROP TABLE IF EXISTS `wprc_woocommerce_payment_tokenmeta`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_woocommerce_payment_tokenmeta` (
`meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`payment_token_id` bigint(20) unsigned NOT NULL,
`meta_key` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`meta_value` longtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
PRIMARY KEY (`meta_id`),
KEY `payment_token_id` (`payment_token_id`),
KEY `meta_key` (`meta_key`(32))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_woocommerce_payment_tokens`
--
DROP TABLE IF EXISTS `wprc_woocommerce_payment_tokens`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_woocommerce_payment_tokens` (
`token_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`gateway_id` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`token` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
`user_id` bigint(20) unsigned NOT NULL DEFAULT 0,
`type` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`is_default` tinyint(1) NOT NULL DEFAULT 0,
PRIMARY KEY (`token_id`),
KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_woocommerce_sessions`
--
DROP TABLE IF EXISTS `wprc_woocommerce_sessions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_woocommerce_sessions` (
`session_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`session_key` char(32) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`session_value` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
`session_expiry` bigint(20) unsigned NOT NULL,
PRIMARY KEY (`session_id`),
UNIQUE KEY `session_key` (`session_key`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_woocommerce_shipping_zone_locations`
--
DROP TABLE IF EXISTS `wprc_woocommerce_shipping_zone_locations`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_woocommerce_shipping_zone_locations` (
`location_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`zone_id` bigint(20) unsigned NOT NULL,
`location_code` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`location_type` varchar(40) COLLATE utf8mb4_unicode_520_ci NOT NULL,
PRIMARY KEY (`location_id`),
KEY `location_id` (`location_id`),
KEY `location_type_code` (`location_type`(10),`location_code`(20))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_woocommerce_shipping_zone_methods`
--
DROP TABLE IF EXISTS `wprc_woocommerce_shipping_zone_methods`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_woocommerce_shipping_zone_methods` (
`zone_id` bigint(20) unsigned NOT NULL,
`instance_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`method_id` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`method_order` bigint(20) unsigned NOT NULL,
`is_enabled` tinyint(1) NOT NULL DEFAULT 1,
PRIMARY KEY (`instance_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_woocommerce_shipping_zones`
--
DROP TABLE IF EXISTS `wprc_woocommerce_shipping_zones`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_woocommerce_shipping_zones` (
`zone_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`zone_name` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`zone_order` bigint(20) unsigned NOT NULL,
PRIMARY KEY (`zone_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_woocommerce_tax_rate_locations`
--
DROP TABLE IF EXISTS `wprc_woocommerce_tax_rate_locations`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_woocommerce_tax_rate_locations` (
`location_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`location_code` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`tax_rate_id` bigint(20) unsigned NOT NULL,
`location_type` varchar(40) COLLATE utf8mb4_unicode_520_ci NOT NULL,
PRIMARY KEY (`location_id`),
KEY `tax_rate_id` (`tax_rate_id`),
KEY `location_type_code` (`location_type`(10),`location_code`(20))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_woocommerce_tax_rates`
--
DROP TABLE IF EXISTS `wprc_woocommerce_tax_rates`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_woocommerce_tax_rates` (
`tax_rate_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`tax_rate_country` varchar(2) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
`tax_rate_state` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
`tax_rate` varchar(8) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
`tax_rate_name` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
`tax_rate_priority` bigint(20) unsigned NOT NULL,
`tax_rate_compound` int(1) NOT NULL DEFAULT 0,
`tax_rate_shipping` int(1) NOT NULL DEFAULT 1,
`tax_rate_order` bigint(20) unsigned NOT NULL,
`tax_rate_class` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
PRIMARY KEY (`tax_rate_id`),
KEY `tax_rate_country` (`tax_rate_country`),
KEY `tax_rate_state` (`tax_rate_state`(2)),
KEY `tax_rate_class` (`tax_rate_class`(10)),
KEY `tax_rate_priority` (`tax_rate_priority`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_woodmart_wishlist_products`
--
DROP TABLE IF EXISTS `wprc_woodmart_wishlist_products`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_woodmart_wishlist_products` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`product_id` varchar(255) NOT NULL,
`wishlist_id` int(11) DEFAULT NULL,
`date_added` timestamp NOT NULL DEFAULT current_timestamp(),
PRIMARY KEY (`ID`),
KEY `product_id` (`product_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_woodmart_wishlists`
--
DROP TABLE IF EXISTS `wprc_woodmart_wishlists`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_woodmart_wishlists` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`date_created` timestamp NOT NULL DEFAULT current_timestamp(),
PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_wpforms_tasks_meta`
--
DROP TABLE IF EXISTS `wprc_wpforms_tasks_meta`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_wpforms_tasks_meta` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`action` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`data` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
`date` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_yith_wcan_filter_sessions`
--
DROP TABLE IF EXISTS `wprc_yith_wcan_filter_sessions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_yith_wcan_filter_sessions` (
`ID` bigint(20) NOT NULL AUTO_INCREMENT,
`hash` char(32) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`token` char(10) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`origin_url` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
`query_vars` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
`expiration` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `filter_hash` (`hash`),
UNIQUE KEY `filter_token` (`token`),
KEY `filter_expiration` (`expiration`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_yoast_indexable`
--
DROP TABLE IF EXISTS `wprc_yoast_indexable`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_yoast_indexable` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`permalink` longtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`permalink_hash` varchar(40) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`object_id` bigint(20) DEFAULT NULL,
`object_type` varchar(32) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`object_sub_type` varchar(32) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`author_id` bigint(20) DEFAULT NULL,
`post_parent` bigint(20) DEFAULT NULL,
`title` text COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`description` mediumtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`breadcrumb_title` text COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`post_status` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`is_public` tinyint(1) DEFAULT NULL,
`is_protected` tinyint(1) DEFAULT 0,
`has_public_posts` tinyint(1) DEFAULT NULL,
`number_of_pages` int(11) unsigned DEFAULT NULL,
`canonical` longtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`primary_focus_keyword` varchar(191) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`primary_focus_keyword_score` int(3) DEFAULT NULL,
`readability_score` int(3) DEFAULT NULL,
`is_cornerstone` tinyint(1) DEFAULT 0,
`is_robots_noindex` tinyint(1) DEFAULT 0,
`is_robots_nofollow` tinyint(1) DEFAULT 0,
`is_robots_noarchive` tinyint(1) DEFAULT 0,
`is_robots_noimageindex` tinyint(1) DEFAULT 0,
`is_robots_nosnippet` tinyint(1) DEFAULT 0,
`twitter_title` text COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`twitter_image` longtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`twitter_description` longtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`twitter_image_id` varchar(191) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`twitter_image_source` text COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`open_graph_title` text COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`open_graph_description` longtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`open_graph_image` longtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`open_graph_image_id` varchar(191) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`open_graph_image_source` text COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`open_graph_image_meta` mediumtext COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`link_count` int(11) DEFAULT NULL,
`incoming_link_count` int(11) DEFAULT NULL,
`prominent_words_version` int(11) unsigned DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
`blog_id` bigint(20) NOT NULL DEFAULT 1,
`language` varchar(32) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`region` varchar(32) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`schema_page_type` varchar(64) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`schema_article_type` varchar(64) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`has_ancestors` tinyint(1) DEFAULT 0,
`estimated_reading_time_minutes` int(11) DEFAULT NULL,
`version` int(11) DEFAULT 1,
`object_last_modified` datetime DEFAULT NULL,
`object_published_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `object_type_and_sub_type` (`object_type`,`object_sub_type`),
KEY `object_id_and_type` (`object_id`,`object_type`),
KEY `permalink_hash_and_object_type` (`permalink_hash`,`object_type`),
KEY `subpages` (`post_parent`,`object_type`,`post_status`,`object_id`),
KEY `prominent_words` (`prominent_words_version`,`object_type`,`object_sub_type`,`post_status`),
KEY `published_sitemap_index` (`object_published_at`,`is_robots_noindex`,`object_type`,`object_sub_type`)
) ENGINE=InnoDB AUTO_INCREMENT=6272 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_yoast_indexable_hierarchy`
--
DROP TABLE IF EXISTS `wprc_yoast_indexable_hierarchy`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_yoast_indexable_hierarchy` (
`indexable_id` int(11) unsigned NOT NULL,
`ancestor_id` int(11) unsigned NOT NULL,
`depth` int(11) unsigned DEFAULT NULL,
`blog_id` bigint(20) NOT NULL DEFAULT 1,
PRIMARY KEY (`indexable_id`,`ancestor_id`),
KEY `indexable_id` (`indexable_id`),
KEY `ancestor_id` (`ancestor_id`),
KEY `depth` (`depth`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_yoast_migrations`
--
DROP TABLE IF EXISTS `wprc_yoast_migrations`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_yoast_migrations` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`version` varchar(191) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `wprc_yoast_migrations_version` (`version`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_yoast_primary_term`
--
DROP TABLE IF EXISTS `wprc_yoast_primary_term`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_yoast_primary_term` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`post_id` bigint(20) DEFAULT NULL,
`term_id` bigint(20) DEFAULT NULL,
`taxonomy` varchar(32) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
`blog_id` bigint(20) NOT NULL DEFAULT 1,
PRIMARY KEY (`id`),
KEY `post_taxonomy` (`post_id`,`taxonomy`),
KEY `post_term` (`post_id`,`term_id`)
) ENGINE=InnoDB AUTO_INCREMENT=203 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `wprc_yoast_seo_links`
--
DROP TABLE IF EXISTS `wprc_yoast_seo_links`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wprc_yoast_seo_links` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`url` varchar(255) DEFAULT NULL,
`post_id` bigint(20) unsigned DEFAULT NULL,
`target_post_id` bigint(20) unsigned DEFAULT NULL,
`type` varchar(8) DEFAULT NULL,
`indexable_id` int(11) unsigned DEFAULT NULL,
`target_indexable_id` int(11) unsigned DEFAULT NULL,
`height` int(11) unsigned DEFAULT NULL,
`width` int(11) unsigned DEFAULT NULL,
`size` int(11) unsigned DEFAULT NULL,
`language` varchar(32) DEFAULT NULL,
`region` varchar(32) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `link_direction` (`post_id`,`type`),
KEY `indexable_link_direction` (`indexable_id`,`type`)
) ENGINE=InnoDB AUTO_INCREMENT=25772 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2022-05-28 11:04:59