Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # WordPress MySQL database backup
- # Created by UpdraftPlus version 2.16.21.24 (https://updraftplus.com)
- # WordPress Version: 5.3.2, running on PHP 7.4.2 (Apache/2.4.38 (Debian)), MySQL 8.0.19
- # Backup of: https://www.cododigital.co.uk
- # Home URL: https://www.cododigital.co.uk
- # Content URL: https://www.cododigital.co.uk/wp-content
- # Uploads URL: https://resources.cododigital.co.uk/wp-content/uploads
- # Table prefix: wp_
- # Filtered table prefix:
- # Site info: multisite=0
- # Site info: end
- # Generated: Friday 14. February 2020 00:21 UTC
- # Hostname: db-prod.cododigital.co.uk
- # Database: `wordpress-codo-digital`
- # --------------------------------------------------------
- /*!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 */;
- /*!40101 SET foreign_key_checks = 0 */;
- # Table: `wp_options`
- # Approximate rows expected in table: 384
- # Delete any existing table `wp_options`
- DROP TABLE IF EXISTS `wp_options`;
- # Table structure of table `wp_options`
- CREATE TABLE `wp_options` (
- `option_id` bigint unsigned NOT NULL AUTO_INCREMENT,
- `option_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
- `option_value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
- `autoload` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'yes',
- PRIMARY KEY (`option_id`),
- UNIQUE KEY `option_name` (`option_name`),
- KEY `autoload` (`autoload`)
- ) ENGINE=InnoDB AUTO_INCREMENT=49746 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci ;
- # Data contents of table `wp_options`
- # End of data contents of table `wp_options`
- # Table: `wp_users`
- # Approximate rows expected in table: 2
- # Delete any existing table `wp_users`
- DROP TABLE IF EXISTS `wp_users`;
- # Table structure of table `wp_users`
- CREATE TABLE `wp_users` (
- `ID` bigint unsigned NOT NULL AUTO_INCREMENT,
- `user_login` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
- `user_pass` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
- `user_nicename` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
- `user_email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
- `user_url` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
- `user_registered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `user_activation_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
- `user_status` int NOT NULL DEFAULT '0',
- `display_name` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci 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=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci ;
- # Data contents of table `wp_users`
- # End of data contents of table `wp_users`
- # Table: `wp_usermeta`
- # Approximate rows expected in table: 55
- # Delete any existing table `wp_usermeta`
- DROP TABLE IF EXISTS `wp_usermeta`;
- # Table structure of table `wp_usermeta`
- CREATE TABLE `wp_usermeta` (
- `umeta_id` bigint unsigned NOT NULL AUTO_INCREMENT,
- `user_id` bigint unsigned NOT NULL DEFAULT '0',
- `meta_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
- `meta_value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
- PRIMARY KEY (`umeta_id`),
- KEY `user_id` (`user_id`),
- KEY `meta_key` (`meta_key`(191))
- ) ENGINE=InnoDB AUTO_INCREMENT=79 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci ;
- # Data contents of table `wp_usermeta`
- # End of data contents of table `wp_usermeta`
- # Table: `wp_commentmeta`
- # Approximate rows expected in table: 0
- # Delete any existing table `wp_commentmeta`
- DROP TABLE IF EXISTS `wp_commentmeta`;
- # Table structure of table `wp_commentmeta`
- CREATE TABLE `wp_commentmeta` (
- `meta_id` bigint unsigned NOT NULL AUTO_INCREMENT,
- `comment_id` bigint unsigned NOT NULL DEFAULT '0',
- `meta_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
- `meta_value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
- PRIMARY KEY (`meta_id`),
- KEY `comment_id` (`comment_id`),
- KEY `meta_key` (`meta_key`(191))
- ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci ;
- # Data contents of table `wp_commentmeta`
- # End of data contents of table `wp_commentmeta`
- # Table: `wp_comments`
- # Approximate rows expected in table: 0
- # Delete any existing table `wp_comments`
- DROP TABLE IF EXISTS `wp_comments`;
- # Table structure of table `wp_comments`
- CREATE TABLE `wp_comments` (
- `comment_ID` bigint unsigned NOT NULL AUTO_INCREMENT,
- `comment_post_ID` bigint unsigned NOT NULL DEFAULT '0',
- `comment_author` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
- `comment_author_email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
- `comment_author_url` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
- `comment_author_IP` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci 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 CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
- `comment_karma` int NOT NULL DEFAULT '0',
- `comment_approved` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '1',
- `comment_agent` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
- `comment_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
- `comment_parent` bigint unsigned NOT NULL DEFAULT '0',
- `user_id` bigint 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))
- ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci ;
- # Data contents of table `wp_comments`
- # End of data contents of table `wp_comments`
- # Table: `wp_links`
- # Approximate rows expected in table: 0
- # Delete any existing table `wp_links`
- DROP TABLE IF EXISTS `wp_links`;
- # Table structure of table `wp_links`
- CREATE TABLE `wp_links` (
- `link_id` bigint unsigned NOT NULL AUTO_INCREMENT,
- `link_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
- `link_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
- `link_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
- `link_target` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
- `link_description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
- `link_visible` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'Y',
- `link_owner` bigint unsigned NOT NULL DEFAULT '1',
- `link_rating` int NOT NULL DEFAULT '0',
- `link_updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `link_rel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
- `link_notes` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
- `link_rss` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
- PRIMARY KEY (`link_id`),
- KEY `link_visible` (`link_visible`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci ;
- # Data contents of table `wp_links`
- # End of data contents of table `wp_links`
- # Table: `wp_postmeta`
- # Approximate rows expected in table: 237
- # Delete any existing table `wp_postmeta`
- DROP TABLE IF EXISTS `wp_postmeta`;
- # Table structure of table `wp_postmeta`
- CREATE TABLE `wp_postmeta` (
- `meta_id` bigint unsigned NOT NULL AUTO_INCREMENT,
- `post_id` bigint unsigned NOT NULL DEFAULT '0',
- `meta_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
- `meta_value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
- PRIMARY KEY (`meta_id`),
- KEY `post_id` (`post_id`),
- KEY `meta_key` (`meta_key`(191))
- ) ENGINE=InnoDB AUTO_INCREMENT=507 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci ;
- # Data contents of table `wp_postmeta`
- # End of data contents of table `wp_postmeta`
- # Table: `wp_posts`
- # Approximate rows expected in table: 151
- # Delete any existing table `wp_posts`
- DROP TABLE IF EXISTS `wp_posts`;
- # Table structure of table `wp_posts`
- CREATE TABLE `wp_posts` (
- `ID` bigint unsigned NOT NULL AUTO_INCREMENT,
- `post_author` bigint 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 CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
- `post_title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
- `post_excerpt` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
- `post_status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'publish',
- `comment_status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'open',
- `ping_status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'open',
- `post_password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
- `post_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
- `to_ping` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
- `pinged` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci 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 CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
- `post_parent` bigint unsigned NOT NULL DEFAULT '0',
- `guid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
- `menu_order` int NOT NULL DEFAULT '0',
- `post_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'post',
- `post_mime_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
- `comment_count` bigint 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=411 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci ;
- # Data contents of table `wp_posts`
- # End of data contents of table `wp_posts`
- # Table: `wp_term_relationships`
- # Approximate rows expected in table: 103
- # Delete any existing table `wp_term_relationships`
- DROP TABLE IF EXISTS `wp_term_relationships`;
- # Table structure of table `wp_term_relationships`
- CREATE TABLE `wp_term_relationships` (
- `object_id` bigint unsigned NOT NULL DEFAULT '0',
- `term_taxonomy_id` bigint unsigned NOT NULL DEFAULT '0',
- `term_order` int NOT NULL DEFAULT '0',
- PRIMARY KEY (`object_id`,`term_taxonomy_id`),
- KEY `term_taxonomy_id` (`term_taxonomy_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci ;
- # Data contents of table `wp_term_relationships`
- # End of data contents of table `wp_term_relationships`
- # Table: `wp_term_taxonomy`
- # Approximate rows expected in table: 110
- # Delete any existing table `wp_term_taxonomy`
- DROP TABLE IF EXISTS `wp_term_taxonomy`;
- # Table structure of table `wp_term_taxonomy`
- CREATE TABLE `wp_term_taxonomy` (
- `term_taxonomy_id` bigint unsigned NOT NULL AUTO_INCREMENT,
- `term_id` bigint unsigned NOT NULL DEFAULT '0',
- `taxonomy` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
- `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
- `parent` bigint unsigned NOT NULL DEFAULT '0',
- `count` bigint NOT NULL DEFAULT '0',
- PRIMARY KEY (`term_taxonomy_id`),
- UNIQUE KEY `term_id_taxonomy` (`term_id`,`taxonomy`),
- KEY `taxonomy` (`taxonomy`)
- ) ENGINE=InnoDB AUTO_INCREMENT=111 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci ;
- # Data contents of table `wp_term_taxonomy`
- # End of data contents of table `wp_term_taxonomy`
- # Table: `wp_termmeta`
- # Approximate rows expected in table: 0
- # Delete any existing table `wp_termmeta`
- DROP TABLE IF EXISTS `wp_termmeta`;
- # Table structure of table `wp_termmeta`
- CREATE TABLE `wp_termmeta` (
- `meta_id` bigint unsigned NOT NULL AUTO_INCREMENT,
- `term_id` bigint unsigned NOT NULL DEFAULT '0',
- `meta_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
- `meta_value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
- PRIMARY KEY (`meta_id`),
- KEY `term_id` (`term_id`),
- KEY `meta_key` (`meta_key`(191))
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci ;
- # Data contents of table `wp_termmeta`
- # End of data contents of table `wp_termmeta`
- # Table: `wp_terms`
- # Approximate rows expected in table: 110
- # Delete any existing table `wp_terms`
- DROP TABLE IF EXISTS `wp_terms`;
- # Table structure of table `wp_terms`
- CREATE TABLE `wp_terms` (
- `term_id` bigint unsigned NOT NULL AUTO_INCREMENT,
- `name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
- `slug` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
- `term_group` bigint NOT NULL DEFAULT '0',
- PRIMARY KEY (`term_id`),
- KEY `slug` (`slug`(191)),
- KEY `name` (`name`(191))
- ) ENGINE=InnoDB AUTO_INCREMENT=111 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci ;
- # Data contents of table `wp_terms`
- # End of data contents of table `wp_terms`
- # Table: `wp_yoast_seo_links`
- # Approximate rows expected in table: 4
- # Delete any existing table `wp_yoast_seo_links`
- DROP TABLE IF EXISTS `wp_yoast_seo_links`;
- # Table structure of table `wp_yoast_seo_links`
- CREATE TABLE `wp_yoast_seo_links` (
- `id` bigint unsigned NOT NULL AUTO_INCREMENT,
- `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
- `post_id` bigint unsigned NOT NULL,
- `target_post_id` bigint unsigned NOT NULL,
- `type` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
- PRIMARY KEY (`id`),
- KEY `link_direction` (`post_id`,`type`)
- ) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci ;
- # Data contents of table `wp_yoast_seo_links`
- # End of data contents of table `wp_yoast_seo_links`
- # Table: `wp_yoast_seo_meta`
- # Approximate rows expected in table: 73
- # Delete any existing table `wp_yoast_seo_meta`
- DROP TABLE IF EXISTS `wp_yoast_seo_meta`;
- # Table structure of table `wp_yoast_seo_meta`
- CREATE TABLE `wp_yoast_seo_meta` (
- `object_id` bigint unsigned NOT NULL,
- `internal_link_count` int unsigned DEFAULT NULL,
- `incoming_link_count` int unsigned DEFAULT NULL,
- UNIQUE KEY `object_id` (`object_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci ;
- # Data contents of table `wp_yoast_seo_meta`
- # End of data contents of table `wp_yoast_seo_meta`
- # Table: `wp_ewwwio_images`
- # Approximate rows expected in table: 545
- # Delete any existing table `wp_ewwwio_images`
- DROP TABLE IF EXISTS `wp_ewwwio_images`;
- # Table structure of table `wp_ewwwio_images`
- CREATE TABLE `wp_ewwwio_images` (
- `id` int unsigned NOT NULL AUTO_INCREMENT,
- `attachment_id` bigint unsigned DEFAULT NULL,
- `gallery` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
- `resize` varchar(75) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
- `path` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
- `converted` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
- `results` varchar(75) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
- `image_size` int unsigned DEFAULT NULL,
- `orig_size` int unsigned DEFAULT NULL,
- `backup` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
- `level` int unsigned DEFAULT NULL,
- `pending` tinyint(1) NOT NULL DEFAULT '0',
- `updates` int unsigned DEFAULT NULL,
- `updated` timestamp NULL DEFAULT '1971-01-01 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
- `trace` blob,
- UNIQUE KEY `id` (`id`),
- KEY `path` (`path`(191)),
- KEY `attachment_info` (`gallery`(3),`attachment_id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=546 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci ;
- # Data contents of table `wp_ewwwio_images`
- # End of data contents of table `wp_ewwwio_images`
- # Table: `wp_ewwwio_queue`
- # Approximate rows expected in table: 0
- # Delete any existing table `wp_ewwwio_queue`
- DROP TABLE IF EXISTS `wp_ewwwio_queue`;
- # Table structure of table `wp_ewwwio_queue`
- CREATE TABLE `wp_ewwwio_queue` (
- `attachment_id` bigint unsigned DEFAULT NULL,
- `gallery` varchar(10) DEFAULT NULL,
- `scanned` tinyint(1) NOT NULL DEFAULT '0',
- KEY `attachment_info` (`gallery`(3),`attachment_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;
- # Data contents of table `wp_ewwwio_queue`
- # End of data contents of table `wp_ewwwio_queue`
- # Table: `wp_gf_addon_feed`
- # Approximate rows expected in table: 0
- # Delete any existing table `wp_gf_addon_feed`
- DROP TABLE IF EXISTS `wp_gf_addon_feed`;
- # Table structure of table `wp_gf_addon_feed`
- CREATE TABLE `wp_gf_addon_feed` (
- `id` mediumint unsigned NOT NULL AUTO_INCREMENT,
- `form_id` mediumint unsigned NOT NULL,
- `is_active` tinyint(1) NOT NULL DEFAULT '1',
- `feed_order` mediumint unsigned NOT NULL DEFAULT '0',
- `meta` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
- `addon_slug` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
- `event_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
- PRIMARY KEY (`id`),
- KEY `addon_form` (`addon_slug`,`form_id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci ;
- # Data contents of table `wp_gf_addon_feed`
- # End of data contents of table `wp_gf_addon_feed`
- # Table: `wp_gf_draft_submissions`
- # Approximate rows expected in table: 0
- # Delete any existing table `wp_gf_draft_submissions`
- DROP TABLE IF EXISTS `wp_gf_draft_submissions`;
- # Table structure of table `wp_gf_draft_submissions`
- CREATE TABLE `wp_gf_draft_submissions` (
- `uuid` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
- `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
- `form_id` mediumint unsigned NOT NULL,
- `date_created` datetime NOT NULL,
- `ip` varchar(39) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
- `source_url` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
- `submission` longtext CHARACTER SET utf8mb4 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 ;
- # Data contents of table `wp_gf_draft_submissions`
- # End of data contents of table `wp_gf_draft_submissions`
- # Table: `wp_gf_entry`
- # Approximate rows expected in table: 6
- # Delete any existing table `wp_gf_entry`
- DROP TABLE IF EXISTS `wp_gf_entry`;
- # Table structure of table `wp_gf_entry`
- CREATE TABLE `wp_gf_entry` (
- `id` int unsigned NOT NULL AUTO_INCREMENT,
- `form_id` mediumint unsigned NOT NULL,
- `post_id` bigint unsigned DEFAULT NULL,
- `date_created` datetime NOT NULL,
- `date_updated` datetime DEFAULT NULL,
- `is_starred` tinyint(1) NOT NULL DEFAULT '0',
- `is_read` tinyint(1) NOT NULL DEFAULT '0',
- `ip` varchar(39) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
- `source_url` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
- `user_agent` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
- `currency` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
- `payment_status` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
- `payment_date` datetime DEFAULT NULL,
- `payment_amount` decimal(19,2) DEFAULT NULL,
- `payment_method` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
- `transaction_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
- `is_fulfilled` tinyint(1) DEFAULT NULL,
- `created_by` bigint unsigned DEFAULT NULL,
- `transaction_type` tinyint(1) DEFAULT NULL,
- `status` varchar(20) CHARACTER SET utf8mb4 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 AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci ;
- # Data contents of table `wp_gf_entry`
- # End of data contents of table `wp_gf_entry`
- # Table: `wp_gf_entry_meta`
- # Approximate rows expected in table: 38
- # Delete any existing table `wp_gf_entry_meta`
- DROP TABLE IF EXISTS `wp_gf_entry_meta`;
- # Table structure of table `wp_gf_entry_meta`
- CREATE TABLE `wp_gf_entry_meta` (
- `id` bigint unsigned NOT NULL AUTO_INCREMENT,
- `form_id` mediumint unsigned NOT NULL DEFAULT '0',
- `entry_id` bigint unsigned NOT NULL,
- `meta_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
- `meta_value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
- `item_index` varchar(60) CHARACTER SET utf8mb4 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 AUTO_INCREMENT=42 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci ;
- # Data contents of table `wp_gf_entry_meta`
- # End of data contents of table `wp_gf_entry_meta`
- # Table: `wp_gf_entry_notes`
- # Approximate rows expected in table: 2
- # Delete any existing table `wp_gf_entry_notes`
- DROP TABLE IF EXISTS `wp_gf_entry_notes`;
- # Table structure of table `wp_gf_entry_notes`
- CREATE TABLE `wp_gf_entry_notes` (
- `id` int unsigned NOT NULL AUTO_INCREMENT,
- `entry_id` int unsigned NOT NULL,
- `user_name` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
- `user_id` bigint DEFAULT NULL,
- `date_created` datetime NOT NULL,
- `value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
- `note_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
- `sub_type` varchar(50) CHARACTER SET utf8mb4 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 AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci ;
- # Data contents of table `wp_gf_entry_notes`
- # End of data contents of table `wp_gf_entry_notes`
- # Table: `wp_gf_form`
- # Approximate rows expected in table: 0
- # Delete any existing table `wp_gf_form`
- DROP TABLE IF EXISTS `wp_gf_form`;
- # Table structure of table `wp_gf_form`
- CREATE TABLE `wp_gf_form` (
- `id` mediumint unsigned NOT NULL AUTO_INCREMENT,
- `title` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
- `date_created` datetime NOT NULL,
- `date_updated` datetime DEFAULT NULL,
- `is_active` tinyint(1) NOT NULL DEFAULT '1',
- `is_trash` tinyint(1) NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci ;
- # Data contents of table `wp_gf_form`
- # End of data contents of table `wp_gf_form`
- # Table: `wp_gf_form_meta`
- # Approximate rows expected in table: 0
- # Delete any existing table `wp_gf_form_meta`
- DROP TABLE IF EXISTS `wp_gf_form_meta`;
- # Table structure of table `wp_gf_form_meta`
- CREATE TABLE `wp_gf_form_meta` (
- `form_id` mediumint unsigned NOT NULL,
- `display_meta` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
- `entries_grid_meta` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
- `confirmations` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
- `notifications` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
- PRIMARY KEY (`form_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci ;
- # Data contents of table `wp_gf_form_meta`
- # End of data contents of table `wp_gf_form_meta`
- # Table: `wp_gf_form_revisions`
- # Approximate rows expected in table: 0
- # Delete any existing table `wp_gf_form_revisions`
- DROP TABLE IF EXISTS `wp_gf_form_revisions`;
- # Table structure of table `wp_gf_form_revisions`
- CREATE TABLE `wp_gf_form_revisions` (
- `id` bigint unsigned NOT NULL AUTO_INCREMENT,
- `form_id` mediumint unsigned NOT NULL,
- `display_meta` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
- `date_created` datetime NOT NULL,
- PRIMARY KEY (`id`),
- KEY `date_created` (`date_created`),
- KEY `form_id` (`form_id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci ;
- # Data contents of table `wp_gf_form_revisions`
- # End of data contents of table `wp_gf_form_revisions`
- # Table: `wp_gf_form_view`
- # Approximate rows expected in table: 110
- # Delete any existing table `wp_gf_form_view`
- DROP TABLE IF EXISTS `wp_gf_form_view`;
- # Table structure of table `wp_gf_form_view`
- CREATE TABLE `wp_gf_form_view` (
- `id` bigint unsigned NOT NULL AUTO_INCREMENT,
- `form_id` mediumint unsigned NOT NULL,
- `date_created` datetime NOT NULL,
- `ip` char(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
- `count` mediumint unsigned NOT NULL DEFAULT '1',
- PRIMARY KEY (`id`),
- KEY `date_created` (`date_created`),
- KEY `form_id` (`form_id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=116 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci ;
- # Data contents of table `wp_gf_form_view`
- # End of data contents of table `wp_gf_form_view`
- # Table: `wp_oses_clicks`
- # Approximate rows expected in table: 0
- # Delete any existing table `wp_oses_clicks`
- DROP TABLE IF EXISTS `wp_oses_clicks`;
- # Table structure of table `wp_oses_clicks`
- CREATE TABLE `wp_oses_clicks` (
- `email_click_id` bigint NOT NULL AUTO_INCREMENT,
- `email_id` bigint NOT NULL,
- `email_click_url` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
- `email_click_count` int DEFAULT '0',
- `email_first_click_date` datetime DEFAULT NULL,
- `email_last_click_date` datetime DEFAULT NULL,
- PRIMARY KEY (`email_click_id`),
- KEY `email_id` (`email_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci ;
- # Data contents of table `wp_oses_clicks`
- # End of data contents of table `wp_oses_clicks`
- # Table: `wp_oses_emails`
- # Approximate rows expected in table: 37
- # Delete any existing table `wp_oses_emails`
- DROP TABLE IF EXISTS `wp_oses_emails`;
- # Table structure of table `wp_oses_emails`
- CREATE TABLE `wp_oses_emails` (
- `email_id` bigint NOT NULL AUTO_INCREMENT,
- `subsite_id` bigint DEFAULT NULL,
- `email_to` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
- `email_subject` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
- `email_message` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
- `email_headers` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
- `email_attachments` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
- `email_status` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL,
- `email_open_count` int DEFAULT '0',
- `email_first_open_date` datetime DEFAULT NULL,
- `email_last_open_date` datetime DEFAULT NULL,
- `email_created` datetime NOT NULL,
- `email_sent` datetime DEFAULT NULL,
- `email_parent` bigint DEFAULT NULL,
- `auto_retries` int DEFAULT '0',
- `manual_retries` int DEFAULT '0',
- PRIMARY KEY (`email_id`),
- KEY `email_subject` (`email_subject`)
- ) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci ;
- # Data contents of table `wp_oses_emails`
- # End of data contents of table `wp_oses_emails`
- # Table: `wp_w3tc_cdn_pathmap`
- # Approximate rows expected in table: 0
- # Delete any existing table `wp_w3tc_cdn_pathmap`
- DROP TABLE IF EXISTS `wp_w3tc_cdn_pathmap`;
- # Table structure of table `wp_w3tc_cdn_pathmap`
- CREATE TABLE `wp_w3tc_cdn_pathmap` (
- `path` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
- `path_hash` varchar(32) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL,
- `type` tinyint(1) NOT NULL DEFAULT '0',
- `remote_id` varchar(200) CHARACTER SET ascii COLLATE ascii_general_ci DEFAULT NULL,
- PRIMARY KEY (`path_hash`),
- KEY `remote_id` (`remote_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci ;
- # Data contents of table `wp_w3tc_cdn_pathmap`
- # End of data contents of table `wp_w3tc_cdn_pathmap`
- # Table: `wp_w3tc_cdn_queue`
- # Approximate rows expected in table: 0
- # Delete any existing table `wp_w3tc_cdn_queue`
- DROP TABLE IF EXISTS `wp_w3tc_cdn_queue`;
- # Table structure of table `wp_w3tc_cdn_queue`
- CREATE TABLE `wp_w3tc_cdn_queue` (
- `id` int unsigned NOT NULL AUTO_INCREMENT,
- `local_path` varchar(500) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
- `remote_path` varchar(500) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
- `command` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '1 - Upload, 2 - Delete, 3 - Purge',
- `last_error` varchar(150) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
- `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- PRIMARY KEY (`id`),
- KEY `date` (`date`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci ;
- # Data contents of table `wp_w3tc_cdn_queue`
- # End of data contents of table `wp_w3tc_cdn_queue`
- /*!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 */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement