WordPress数据库各表结构介绍
WordPress使用MySQL数据库。作为一个开发者，我们有必要掌握WordPress数据库的基本构造，并在自己的插件或主题中使用他们。
截至WordPress3.0，WordPress一共有以下11个表。这里加上了默认的表前缀 wp_ 。
wp_commentmeta：存储评论的元数据wp_comments：存储评论wp_links：存储友情链接（Blogroll）wp_options：存储WordPress系统选项和插件、主题配置wp_postmeta：存储文章（包括页面、上传文件、修订）的元数据wp_posts：存储文章（包括页面、上传文件、修订）wp_terms：存储每个目录、标签wp_term_relationships：存储每个文章、链接和对应分类的关系wp_term_taxonomy：存储每个目录、标签所对应的分类wp_usermeta：存储用户的元数据wp_users：存储用户
在WordPress的数据库结构中，存储系统选项和插件配置的wp_options表是比较独立的结构，在后文中会提到，它采用了key-value模式存储，这样做的好处是易于拓展，各个插件都可以轻松地在这里存储自己的配置。
post，comment，user 则是三个基本表加上拓展表的组合。以wp_users为例，wp_users已经存储了每个用户会用到的基本信息，比如 login_name、display_name、 password、email等常用信息，但如果我们还要存储一些不常用的数据，最好的做法不是去在表后加上一列，去破坏默认的表结构，而是将数据存在wp_usermeta中。wp_usermeta这个拓展表和wp_options表有类似的结构，我们可以在这里存储每个用户的QQ号码、手机号码、登录WordPress后台的主题选项等等。
比较难以理解的是term，即wp_terms、wp_term_relationships、wp_term_taxonomy。在WordPress的系统里，我们常见的分类有文章的分类、链接的分类，实际上还有TAG，它也是一种特殊的分类方式，我们甚至还可以创建自己的分类方法。WordPress将所有的分类及分类方法、对应结构都记录在这三个表中。wp_terms记录了每个分类的名字以及基本信息，如本站分为“WordPress开发”、“WPCEO插件”等，这里的分类指广义上的分类，所以每个TAG也是一个“分类”。wp_term_taxonomy记录了每个分类所归属的分类方法，如“WordPress开发”、“WPCEO插件”是文章分类（category），放置友情链接的“我的朋友”、“我的同事”分类属于友情链接分类（link_category）。wp_term_relationships记录了每个文章（或链接）所对应的分类方法。
庆幸的是，关于term的使用，WordPress中相关函数的使用方法还是比较清晰明了，我们就没必要纠结于它的构造了。
在上文中我们已经介绍了WordPress数据库中各个表的作用，本文将继续介绍每个表中每个列的作用。WordPress官方文档已经有比较详细的表格，本文仅对常用数据进行介绍。
wp_commentmeta
meta_id：自增唯一IDcomment_id：对应评论IDmeta_key：键名meta_value：键值
wp_comments
comment_ID：自增唯一IDcomment_post_ID：对应文章IDcomment_author：评论者comment_author_email：评论者邮箱comment_author_url：评论者网址comment_author_IP：评论者IPcomment_date：评论时间comment_date_gmt：评论时间（GMT+0时间）comment_content：评论正文comment_karma：未知comment_approved：评论是否被批准comment_agent：评论者的USER AGENTcomment_type：评论类型(pingback/普通)comment_parent：父评论IDuser_id：评论者用户ID（不一定存在）
wp_links
link_id：自增唯一IDlink_url：链接URLlink_name：链接标题link_image：链接图片link_target：链接打开方式link_description：链接描述link_visible：是否可见（Y/N）link_owner：添加者用户IDlink_rating：评分等级link_updated：未知link_rel：XFN关系link_notes：XFN注释link_rss：链接RSS地址
wp_options
option_id：自增唯一IDblog_id：博客ID，用于多用户博客，默认0option_name：键名option_value：键值autoload：在WordPress载入时自动载入（yes/no）
wp_postmeta
meta_id：自增唯一IDpost_id：对应文章IDmeta_key：键名meta_value：键值
wp_posts
ID：自增唯一IDpost_author：对应作者IDpost_date：发布时间post_date_gmt：发布时间（GMT+0时间）post_content：正文post_title：标题post_excerpt：摘录post_status：文章状态（publish/auto-draft/inherit等）comment_status：评论状态（open/closed）ping_status：PING状态（open/closed）post_password：文章密码post_name：文章缩略名to_ping：未知pinged：已经PING过的链接post_modified：修改时间post_modified_gmt：修改时间（GMT+0时间）post_content_filtered：未知post_parent：父文章，主要用于PAGEguid：未知menu_order：排序IDpost_type：文章类型（post/page等）post_mime_type：MIME类型comment_count：评论总数
wp_terms
term_id：分类IDname：分类名slug：缩略名term_group：未知
wp_term_relationships
object_id：对应文章ID/链接IDterm_taxonomy_id：对应分类方法IDterm_order：排序
wp_term_taxonomy
term_taxonomy_id：分类方法IDterm_id：taxonomy：分类方法(category/post_tag)description：未知parent：所属父分类方法IDcount：文章数统计
wp_usermeta
umeta_id：自增唯一IDuser_id：对应用户IDmeta_key：键名meta_value：键值
wp_users
ID：自增唯一IDuser_login：登录名user_pass：密码user_nicename：昵称user_email：Emailuser_url：网址user_registered：注册时间user_activation_key：激活码user_status：用户状态display_name：显示名称-
-- MySQL dump 10.13 Distrib 5.7.13, for Linux (x86_64) -- -- Host: localhost Database: www.dpdp.fun -- ------------------------------------------------------ -- Server version 5.7.13-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 utf8 */; /*!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 `wp_2_commentmeta` -- DROP TABLE IF EXISTS `wp_2_commentmeta`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_2_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, PRIMARY KEY (`meta_id`), KEY `comment_id` (`comment_id`), KEY `meta_key` (`meta_key`(191)) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_2_comments` -- DROP TABLE IF EXISTS `wp_2_comments`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_2_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_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)) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_2_links` -- DROP TABLE IF EXISTS `wp_2_links`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_2_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=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_2_options` -- DROP TABLE IF EXISTS `wp_2_options`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_2_options` ( `option_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `option_name` varchar(64) 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`) ) ENGINE=MyISAM AUTO_INCREMENT=199 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_2_postmeta` -- DROP TABLE IF EXISTS `wp_2_postmeta`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_2_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, PRIMARY KEY (`meta_id`), KEY `post_id` (`post_id`), KEY `meta_key` (`meta_key`(191)) ) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_2_posts` -- DROP TABLE IF EXISTS `wp_2_posts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_2_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(20) 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=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_2_term_relationships` -- DROP TABLE IF EXISTS `wp_2_term_relationships`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_2_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=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_2_term_taxonomy` -- DROP TABLE IF EXISTS `wp_2_term_taxonomy`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_2_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=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_2_termmeta` -- DROP TABLE IF EXISTS `wp_2_termmeta`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_2_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, PRIMARY KEY (`meta_id`), KEY `term_id` (`term_id`), KEY `meta_key` (`meta_key`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_2_terms` -- DROP TABLE IF EXISTS `wp_2_terms`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_2_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=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_ahmeti_wp_timeline` -- DROP TABLE IF EXISTS `wp_ahmeti_wp_timeline`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_ahmeti_wp_timeline` ( `event_id` bigint(20) NOT NULL AUTO_INCREMENT, `group_id` smallint(6) NOT NULL DEFAULT '0', `timeline_bc` bigint(20) DEFAULT '0', `timeline_date` datetime DEFAULT '0000-00-00 00:00:00', `title` varchar(255) DEFAULT NULL, `event_content` mediumtext, `type` enum('event','group_name') NOT NULL DEFAULT 'event' COMMENT 'grup adlar谋 almak i莽in group_name listele, di臒erleri event olacakt谋r.', PRIMARY KEY (`event_id`) ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_aiowps_events` -- DROP TABLE IF EXISTS `wp_aiowps_events`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_aiowps_events` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `event_type` varchar(150) NOT NULL DEFAULT '', `username` varchar(150) DEFAULT NULL, `user_id` bigint(20) DEFAULT NULL, `event_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `ip_or_host` varchar(100) DEFAULT NULL, `referer_info` varchar(255) DEFAULT NULL, `url` varchar(255) DEFAULT NULL, `event_data` longtext, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_aiowps_failed_logins` -- DROP TABLE IF EXISTS `wp_aiowps_failed_logins`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_aiowps_failed_logins` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `user_id` bigint(20) NOT NULL, `user_login` varchar(150) NOT NULL, `failed_login_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `login_attempt_ip` varchar(100) NOT NULL DEFAULT '', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=62164 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_aiowps_global_meta` -- DROP TABLE IF EXISTS `wp_aiowps_global_meta`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_aiowps_global_meta` ( `meta_id` bigint(20) NOT NULL AUTO_INCREMENT, `date_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `meta_key1` varchar(255) NOT NULL, `meta_key2` varchar(255) NOT NULL, `meta_key3` varchar(255) NOT NULL, `meta_key4` varchar(255) NOT NULL, `meta_key5` varchar(255) NOT NULL, `meta_value1` varchar(255) NOT NULL, `meta_value2` text NOT NULL, `meta_value3` text NOT NULL, `meta_value4` longtext NOT NULL, `meta_value5` longtext NOT NULL, PRIMARY KEY (`meta_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_aiowps_login_activity` -- DROP TABLE IF EXISTS `wp_aiowps_login_activity`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_aiowps_login_activity` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `user_id` bigint(20) NOT NULL, `user_login` varchar(150) NOT NULL, `login_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `logout_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `login_ip` varchar(100) NOT NULL DEFAULT '', `login_country` varchar(150) NOT NULL DEFAULT '', `browser_type` varchar(150) NOT NULL DEFAULT '', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_aiowps_login_lockdown` -- DROP TABLE IF EXISTS `wp_aiowps_login_lockdown`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_aiowps_login_lockdown` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `user_id` bigint(20) NOT NULL, `user_login` varchar(150) NOT NULL, `lockdown_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `release_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `failed_login_ip` varchar(100) NOT NULL DEFAULT '', `lock_reason` varchar(128) NOT NULL DEFAULT '', `unlock_key` varchar(128) NOT NULL DEFAULT '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_blog_versions` -- DROP TABLE IF EXISTS `wp_blog_versions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_blog_versions` ( `blog_id` bigint(20) NOT NULL DEFAULT '0', `db_version` varchar(20) NOT NULL DEFAULT '', `last_updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`blog_id`), KEY `db_version` (`db_version`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_blogs` -- DROP TABLE IF EXISTS `wp_blogs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_blogs` ( `blog_id` bigint(20) NOT NULL AUTO_INCREMENT, `site_id` bigint(20) NOT NULL DEFAULT '0', `domain` varchar(200) NOT NULL DEFAULT '', `path` varchar(100) NOT NULL DEFAULT '', `registered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `last_updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `public` tinyint(2) NOT NULL DEFAULT '1', `archived` tinyint(2) NOT NULL DEFAULT '0', `mature` tinyint(2) NOT NULL DEFAULT '0', `spam` tinyint(2) NOT NULL DEFAULT '0', `deleted` tinyint(2) NOT NULL DEFAULT '0', `lang_id` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`blog_id`), KEY `domain` (`domain`(50),`path`(5)), KEY `lang_id` (`lang_id`) ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_bwg_album` -- DROP TABLE IF EXISTS `wp_bwg_album`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_bwg_album` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `slug` varchar(255) NOT NULL, `description` mediumtext NOT NULL, `preview_image` mediumtext NOT NULL, `random_preview_image` mediumtext NOT NULL, `order` bigint(20) NOT NULL, `author` bigint(20) NOT NULL, `published` tinyint(1) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_bwg_album_gallery` -- DROP TABLE IF EXISTS `wp_bwg_album_gallery`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_bwg_album_gallery` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `album_id` bigint(20) NOT NULL, `is_album` tinyint(1) NOT NULL, `alb_gal_id` bigint(20) NOT NULL, `order` bigint(20) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_bwg_gallery` -- DROP TABLE IF EXISTS `wp_bwg_gallery`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_bwg_gallery` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `slug` varchar(255) NOT NULL, `description` mediumtext NOT NULL, `page_link` mediumtext NOT NULL, `preview_image` mediumtext NOT NULL, `random_preview_image` mediumtext NOT NULL, `order` bigint(20) NOT NULL, `author` bigint(20) NOT NULL, `published` tinyint(1) NOT NULL, `gallery_type` varchar(32) NOT NULL, `gallery_source` varchar(256) NOT NULL, `autogallery_image_number` int(4) NOT NULL, `update_flag` varchar(32) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_bwg_image` -- DROP TABLE IF EXISTS `wp_bwg_image`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_bwg_image` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `gallery_id` bigint(20) NOT NULL, `slug` longtext NOT NULL, `filename` varchar(255) NOT NULL, `image_url` mediumtext NOT NULL, `thumb_url` mediumtext NOT NULL, `description` mediumtext NOT NULL, `alt` mediumtext NOT NULL, `date` varchar(128) NOT NULL, `size` varchar(128) NOT NULL, `filetype` varchar(128) NOT NULL, `resolution` varchar(128) NOT NULL, `author` bigint(20) NOT NULL, `order` bigint(20) NOT NULL, `published` tinyint(1) NOT NULL, `comment_count` bigint(20) NOT NULL, `avg_rating` float NOT NULL, `rate_count` bigint(20) NOT NULL, `hit_count` bigint(20) NOT NULL, `redirect_url` varchar(255) NOT NULL, `pricelist_id` bigint(20) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_bwg_image_comment` -- DROP TABLE IF EXISTS `wp_bwg_image_comment`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_bwg_image_comment` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `image_id` bigint(20) NOT NULL, `name` varchar(255) NOT NULL, `date` varchar(64) NOT NULL, `comment` mediumtext NOT NULL, `url` mediumtext NOT NULL, `mail` mediumtext NOT NULL, `published` tinyint(1) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_bwg_image_rate` -- DROP TABLE IF EXISTS `wp_bwg_image_rate`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_bwg_image_rate` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `image_id` bigint(20) NOT NULL, `rate` float NOT NULL, `ip` varchar(64) NOT NULL, `date` varchar(64) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_bwg_image_tag` -- DROP TABLE IF EXISTS `wp_bwg_image_tag`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_bwg_image_tag` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `tag_id` bigint(20) NOT NULL, `image_id` bigint(20) NOT NULL, `gallery_id` bigint(20) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_bwg_option` -- DROP TABLE IF EXISTS `wp_bwg_option`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_bwg_option` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `images_directory` mediumtext NOT NULL, `masonry` varchar(255) NOT NULL, `mosaic` varchar(255) NOT NULL, `resizable_mosaic` tinyint(1) NOT NULL, `mosaic_total_width` int(4) NOT NULL, `image_column_number` int(4) NOT NULL, `images_per_page` int(4) NOT NULL, `thumb_width` int(4) NOT NULL, `thumb_height` int(4) NOT NULL, `upload_thumb_width` int(4) NOT NULL, `upload_thumb_height` int(4) NOT NULL, `image_enable_page` tinyint(1) NOT NULL, `image_title_show_hover` varchar(20) NOT NULL, `ecommerce_icon_show_hover` varchar(20) NOT NULL, `album_column_number` int(4) NOT NULL, `albums_per_page` int(4) NOT NULL, `album_title_show_hover` varchar(8) NOT NULL, `album_thumb_width` int(4) NOT NULL, `album_thumb_height` int(4) NOT NULL, `album_enable_page` tinyint(1) NOT NULL, `extended_album_height` int(4) NOT NULL, `extended_album_description_enable` tinyint(1) NOT NULL, `image_browser_width` int(4) NOT NULL, `image_browser_title_enable` tinyint(1) NOT NULL, `image_browser_description_enable` tinyint(1) NOT NULL, `blog_style_width` int(4) NOT NULL, `blog_style_title_enable` tinyint(1) NOT NULL, `blog_style_images_per_page` int(4) NOT NULL, `blog_style_enable_page` tinyint(1) NOT NULL, `slideshow_type` varchar(16) NOT NULL, `slideshow_interval` int(4) NOT NULL, `slideshow_width` int(4) NOT NULL, `slideshow_height` int(4) NOT NULL, `slideshow_enable_autoplay` tinyint(1) NOT NULL, `slideshow_enable_shuffle` tinyint(1) NOT NULL, `slideshow_enable_ctrl` tinyint(1) NOT NULL, `slideshow_enable_filmstrip` tinyint(1) NOT NULL, `slideshow_filmstrip_height` int(4) NOT NULL, `slideshow_enable_title` tinyint(1) NOT NULL, `slideshow_title_position` varchar(16) NOT NULL, `slideshow_enable_description` tinyint(1) NOT NULL, `slideshow_description_position` varchar(16) NOT NULL, `slideshow_enable_music` tinyint(1) NOT NULL, `slideshow_audio_url` varchar(255) NOT NULL, `slideshow_effect_duration` int(4) NOT NULL, `popup_width` int(4) NOT NULL, `popup_height` int(4) NOT NULL, `popup_type` varchar(16) NOT NULL, `popup_interval` int(4) NOT NULL, `popup_enable_filmstrip` tinyint(1) NOT NULL, `popup_filmstrip_height` int(4) NOT NULL, `popup_enable_ctrl_btn` tinyint(1) NOT NULL, `popup_enable_fullscreen` tinyint(1) NOT NULL, `popup_enable_info` tinyint(1) NOT NULL, `popup_info_always_show` tinyint(1) NOT NULL, `popup_enable_rate` tinyint(1) NOT NULL, `popup_enable_comment` tinyint(1) NOT NULL, `popup_enable_email` tinyint(1) NOT NULL, `popup_enable_captcha` tinyint(1) NOT NULL, `popup_enable_download` tinyint(1) NOT NULL, `popup_enable_fullsize_image` tinyint(1) NOT NULL, `popup_enable_facebook` tinyint(1) NOT NULL, `popup_enable_twitter` tinyint(1) NOT NULL, `popup_enable_google` tinyint(1) NOT NULL, `popup_enable_ecommerce` tinyint(1) NOT NULL, `popup_effect_duration` int(4) NOT NULL, `watermark_type` varchar(8) NOT NULL, `watermark_position` varchar(16) NOT NULL, `watermark_width` int(4) NOT NULL, `watermark_height` int(4) NOT NULL, `watermark_url` mediumtext NOT NULL, `watermark_text` mediumtext NOT NULL, `watermark_link` mediumtext NOT NULL, `watermark_font_size` int(4) NOT NULL, `watermark_font` varchar(16) NOT NULL, `watermark_color` varchar(8) NOT NULL, `watermark_opacity` int(4) NOT NULL, `built_in_watermark_type` varchar(16) NOT NULL, `built_in_watermark_position` varchar(16) NOT NULL, `built_in_watermark_size` int(4) NOT NULL, `built_in_watermark_url` mediumtext NOT NULL, `built_in_watermark_text` mediumtext NOT NULL, `built_in_watermark_font_size` int(4) NOT NULL, `built_in_watermark_font` varchar(16) NOT NULL, `built_in_watermark_color` varchar(8) NOT NULL, `built_in_watermark_opacity` int(4) NOT NULL, `image_right_click` tinyint(1) NOT NULL, `popup_fullscreen` tinyint(1) NOT NULL, `gallery_role` tinyint(1) NOT NULL, `album_role` tinyint(1) NOT NULL, `image_role` tinyint(1) NOT NULL, `popup_autoplay` tinyint(1) NOT NULL, `album_view_type` varchar(16) NOT NULL, `popup_enable_pinterest` tinyint(1) NOT NULL, `popup_enable_tumblr` tinyint(1) NOT NULL, `show_search_box` tinyint(1) NOT NULL, `search_box_width` int(4) NOT NULL, `preload_images` tinyint(1) NOT NULL, `preload_images_count` int(4) NOT NULL, `thumb_click_action` varchar(16) NOT NULL, `thumb_link_target` tinyint(1) NOT NULL, `comment_moderation` tinyint(1) NOT NULL, `popup_hit_counter` tinyint(1) NOT NULL, `enable_ML_import` tinyint(1) NOT NULL, `showthumbs_name` tinyint(1) NOT NULL, `show_album_name` tinyint(1) NOT NULL, `show_image_counts` tinyint(1) NOT NULL, `upload_img_width` int(4) NOT NULL, `upload_img_height` int(4) NOT NULL, `play_icon` tinyint(1) NOT NULL, `show_masonry_thumb_description` tinyint(1) NOT NULL, `slideshow_title_full_width` tinyint(1) NOT NULL, `popup_info_full_width` tinyint(1) NOT NULL, `show_sort_images` tinyint(1) NOT NULL, `autoupdate_interval` int(4) NOT NULL, `instagram_access_token` varchar(128) NOT NULL, `description_tb` tinyint(1) NOT NULL, `enable_seo` tinyint(1) NOT NULL, `autohide_lightbox_navigation` tinyint(1) NOT NULL, `autohide_slideshow_navigation` tinyint(1) NOT NULL, `read_metadata` tinyint(1) NOT NULL, `enable_loop` tinyint(1) NOT NULL, `enable_addthis` tinyint(1) NOT NULL, `addthis_profile_id` varchar(66) NOT NULL, `carousel_interval` int(4) NOT NULL, `carousel_width` int(4) NOT NULL, `carousel_height` int(4) NOT NULL, `carousel_image_column_number` int(4) NOT NULL, `carousel_image_par` varchar(32) NOT NULL, `carousel_enable_title` tinyint(1) NOT NULL, `carousel_enable_autoplay` tinyint(1) NOT NULL, `carousel_r_width` int(4) NOT NULL, `carousel_fit_containerWidth` tinyint(1) NOT NULL, `carousel_prev_next_butt` tinyint(1) NOT NULL, `carousel_play_pause_butt` tinyint(1) NOT NULL, `permissions` varchar(20) NOT NULL, `facebook_app_id` varchar(64) NOT NULL, `facebook_app_secret` varchar(64) NOT NULL, `show_tag_box` tinyint(1) NOT NULL, `show_hide_custom_post` tinyint(1) NOT NULL, `show_hide_post_meta` tinyint(1) NOT NULL, `placeholder` varchar(32) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_bwg_shortcode` -- DROP TABLE IF EXISTS `wp_bwg_shortcode`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_bwg_shortcode` ( `id` bigint(20) NOT NULL, `tagtext` mediumtext NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_bwg_theme` -- DROP TABLE IF EXISTS `wp_bwg_theme`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_bwg_theme` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `options` longtext NOT NULL, `default_theme` tinyint(1) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_commentmeta` -- DROP TABLE IF EXISTS `wp_commentmeta`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_commentmeta` ( `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `comment_id` bigint(20) unsigned NOT NULL DEFAULT '0', `meta_key` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `meta_value` longtext COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`meta_id`), KEY `comment_id` (`comment_id`), KEY `meta_key` (`meta_key`(191)) ) ENGINE=MyISAM AUTO_INCREMENT=146003 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_comments` -- DROP TABLE IF EXISTS `wp_comments`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_comments` ( `comment_ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `comment_post_ID` bigint(20) unsigned NOT NULL DEFAULT '0', `comment_author` tinytext COLLATE utf8mb4_unicode_ci NOT NULL, `comment_author_email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `comment_author_url` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `comment_author_IP` varchar(100) COLLATE utf8mb4_unicode_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 COLLATE utf8mb4_unicode_ci NOT NULL, `comment_karma` int(11) NOT NULL DEFAULT '0', `comment_approved` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1', `comment_agent` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `comment_type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `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)) ) ENGINE=MyISAM AUTO_INCREMENT=36038 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_links` -- DROP TABLE IF EXISTS `wp_links`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_links` ( `link_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `link_url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `link_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `link_image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `link_target` varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `link_description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `link_visible` varchar(20) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `link_notes` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, `link_rss` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`link_id`), KEY `link_visible` (`link_visible`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_mts_wp_reviews` -- DROP TABLE IF EXISTS `wp_mts_wp_reviews`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_mts_wp_reviews` ( `id` int(11) NOT NULL AUTO_INCREMENT, `blog_id` int(11) NOT NULL, `post_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `user_ip` varchar(55) NOT NULL, `rate` int(11) NOT NULL, `date` datetime NOT NULL, UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_options` -- DROP TABLE IF EXISTS `wp_options`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_options` ( `option_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `option_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `option_value` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `autoload` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'yes', PRIMARY KEY (`option_id`), UNIQUE KEY `option_name` (`option_name`) ) ENGINE=MyISAM AUTO_INCREMENT=19963 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_phppc_functions` -- DROP TABLE IF EXISTS `wp_phppc_functions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_phppc_functions` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(256) NOT NULL DEFAULT 'Untitled Function', `description` text, `code` longtext NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_plugin_slickquiz` -- DROP TABLE IF EXISTS `wp_plugin_slickquiz`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_plugin_slickquiz` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `publishedJson` longtext, `workingJson` longtext, `publishedQCount` int(11) DEFAULT NULL, `workingQCount` int(11) DEFAULT NULL, `hasBeenPublished` tinyint(1) NOT NULL DEFAULT '0', `publishedBy` bigint(20) unsigned NOT NULL DEFAULT '0', `publishedDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `createdBy` bigint(20) unsigned NOT NULL DEFAULT '0', `createdDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `lastUpdatedBy` bigint(20) unsigned NOT NULL DEFAULT '0', `lastUpdatedDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`id`), KEY `createdBy_index` (`createdBy`) ) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_plugin_slickquiz_scores` -- DROP TABLE IF EXISTS `wp_plugin_slickquiz_scores`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_plugin_slickquiz_scores` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `score` varchar(50) NOT NULL, `quiz_id` bigint(20) unsigned NOT NULL DEFAULT '0', `createdBy` bigint(20) unsigned NOT NULL DEFAULT '0', `createdDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`id`), KEY `quiz_id_index` (`quiz_id`), KEY `score_index` (`score`) ) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_postmeta` -- DROP TABLE IF EXISTS `wp_postmeta`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_postmeta` ( `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `post_id` bigint(20) unsigned NOT NULL DEFAULT '0', `meta_key` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `meta_value` longtext COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`meta_id`), KEY `post_id` (`post_id`), KEY `meta_key` (`meta_key`(191)) ) ENGINE=MyISAM AUTO_INCREMENT=3177 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_posts` -- DROP TABLE IF EXISTS `wp_posts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_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 COLLATE utf8mb4_unicode_ci NOT NULL, `post_title` text COLLATE utf8mb4_unicode_ci NOT NULL, `post_excerpt` text COLLATE utf8mb4_unicode_ci NOT NULL, `post_status` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'publish', `comment_status` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'open', `ping_status` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'open', `post_password` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `post_name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `to_ping` text COLLATE utf8mb4_unicode_ci NOT NULL, `pinged` text COLLATE utf8mb4_unicode_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 COLLATE utf8mb4_unicode_ci NOT NULL, `post_parent` bigint(20) unsigned NOT NULL DEFAULT '0', `guid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `menu_order` int(11) NOT NULL DEFAULT '0', `post_type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'post', `post_mime_type` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `comment_count` bigint(20) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`), KEY `type_status_date` (`post_type`,`post_status`,`post_date`,`ID`), KEY `post_parent` (`post_parent`), KEY `post_author` (`post_author`), KEY `post_name` (`post_name`(191)), FULLTEXT KEY `yarpp_title` (`post_title`), FULLTEXT KEY `yarpp_content` (`post_content`) ) ENGINE=MyISAM AUTO_INCREMENT=1070 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_registration_log` -- DROP TABLE IF EXISTS `wp_registration_log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_registration_log` ( `ID` bigint(20) NOT NULL AUTO_INCREMENT, `email` varchar(255) NOT NULL DEFAULT '', `IP` varchar(30) NOT NULL DEFAULT '', `blog_id` bigint(20) NOT NULL DEFAULT '0', `date_registered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`ID`), KEY `IP` (`IP`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_signups` -- DROP TABLE IF EXISTS `wp_signups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_signups` ( `signup_id` bigint(20) NOT NULL AUTO_INCREMENT, `domain` varchar(200) NOT NULL DEFAULT '', `path` varchar(100) NOT NULL DEFAULT '', `title` longtext NOT NULL, `user_login` varchar(60) NOT NULL DEFAULT '', `user_email` varchar(100) NOT NULL DEFAULT '', `registered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `activated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `active` tinyint(1) NOT NULL DEFAULT '0', `activation_key` varchar(50) NOT NULL DEFAULT '', `meta` longtext, PRIMARY KEY (`signup_id`), KEY `activation_key` (`activation_key`), KEY `user_email` (`user_email`), KEY `user_login_email` (`user_login`,`user_email`), KEY `domain_path` (`domain`(140),`path`(51)) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_site` -- DROP TABLE IF EXISTS `wp_site`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_site` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `domain` varchar(200) NOT NULL DEFAULT '', `path` varchar(100) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `domain` (`domain`(140),`path`(51)) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_sitemeta` -- DROP TABLE IF EXISTS `wp_sitemeta`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_sitemeta` ( `meta_id` bigint(20) NOT NULL AUTO_INCREMENT, `site_id` bigint(20) NOT NULL DEFAULT '0', `meta_key` varchar(255) DEFAULT NULL, `meta_value` longtext, PRIMARY KEY (`meta_id`), KEY `meta_key` (`meta_key`(191)), KEY `site_id` (`site_id`) ) ENGINE=MyISAM AUTO_INCREMENT=232 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_term_relationships` -- DROP TABLE IF EXISTS `wp_term_relationships`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_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=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_term_taxonomy` -- DROP TABLE IF EXISTS `wp_term_taxonomy`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_term_taxonomy` ( `term_taxonomy_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `term_id` bigint(20) unsigned NOT NULL DEFAULT '0', `taxonomy` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `description` longtext COLLATE utf8mb4_unicode_ci 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=MyISAM AUTO_INCREMENT=93 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_termmeta` -- DROP TABLE IF EXISTS `wp_termmeta`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_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, PRIMARY KEY (`meta_id`), KEY `term_id` (`term_id`), KEY `meta_key` (`meta_key`(191)) ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=gbk; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_terms` -- DROP TABLE IF EXISTS `wp_terms`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_terms` ( `term_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `slug` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `term_group` bigint(10) NOT NULL DEFAULT '0', PRIMARY KEY (`term_id`), KEY `slug` (`slug`(191)), KEY `name` (`name`(191)) ) ENGINE=MyISAM AUTO_INCREMENT=93 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_usermeta` -- DROP TABLE IF EXISTS `wp_usermeta`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_usermeta` ( `umeta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint(20) unsigned NOT NULL DEFAULT '0', `meta_key` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `meta_value` longtext COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`umeta_id`), KEY `user_id` (`user_id`), KEY `meta_key` (`meta_key`(191)) ) ENGINE=MyISAM AUTO_INCREMENT=60 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_users` -- DROP TABLE IF EXISTS `wp_users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_users` ( `ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `user_login` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `user_pass` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `user_nicename` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `user_email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `user_url` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `user_registered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `user_activation_key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `user_status` int(11) NOT NULL DEFAULT '0', `display_name` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `spam` tinyint(2) NOT NULL DEFAULT '0', `deleted` tinyint(2) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`), KEY `user_login_key` (`user_login`), KEY `user_nicename` (`user_nicename`), KEY `user_email` (`user_email`) ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_watu_answer` -- DROP TABLE IF EXISTS `wp_watu_answer`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_watu_answer` ( `ID` int(11) unsigned NOT NULL AUTO_INCREMENT, `question_id` int(11) unsigned NOT NULL, `answer` text, `correct` enum('0','1') NOT NULL DEFAULT '0', `point` int(11) NOT NULL, `sort_order` int(3) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_watu_grading` -- DROP TABLE IF EXISTS `wp_watu_grading`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_watu_grading` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `exam_id` int(11) NOT NULL DEFAULT '0', `gtitle` varchar(255) NOT NULL DEFAULT '', `gdescription` mediumtext NOT NULL, `gfrom` int(11) NOT NULL DEFAULT '0', `gto` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_watu_master` -- DROP TABLE IF EXISTS `wp_watu_master`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_watu_master` ( `ID` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL DEFAULT '', `description` mediumtext NOT NULL, `final_screen` mediumtext NOT NULL, `added_on` datetime NOT NULL DEFAULT '1900-01-01 00:00:00', `randomize` tinyint(4) NOT NULL DEFAULT '0', `single_page` tinyint(4) NOT NULL DEFAULT '0', `show_answers` tinyint(4) NOT NULL DEFAULT '100', `require_login` tinyint(4) NOT NULL DEFAULT '0', `notify_admin` tinyint(4) NOT NULL DEFAULT '0', `randomize_answers` tinyint(4) NOT NULL DEFAULT '0', `pull_random` int(10) unsigned NOT NULL DEFAULT '0', `dont_store_data` tinyint(3) unsigned NOT NULL DEFAULT '0', `show_prev_button` tinyint(3) unsigned NOT NULL DEFAULT '0', `dont_display_question_numbers` tinyint(3) unsigned NOT NULL DEFAULT '0', `require_text_captcha` tinyint(3) unsigned NOT NULL DEFAULT '0', `email_output` text, `notify_user` tinyint(4) NOT NULL DEFAULT '0', `notify_email` varchar(255) NOT NULL DEFAULT '', `take_again` tinyint(4) NOT NULL DEFAULT '0', `times_to_take` tinyint(4) NOT NULL DEFAULT '0', `no_ajax` tinyint(4) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_watu_question` -- DROP TABLE IF EXISTS `wp_watu_question`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_watu_question` ( `ID` int(11) unsigned NOT NULL AUTO_INCREMENT, `exam_id` int(11) unsigned NOT NULL DEFAULT '0', `question` mediumtext NOT NULL, `answer_type` char(15) NOT NULL DEFAULT '', `sort_order` int(3) NOT NULL DEFAULT '0', `is_required` tinyint(3) unsigned NOT NULL DEFAULT '0', `feedback` text, PRIMARY KEY (`ID`), KEY `quiz_id` (`exam_id`) ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_watu_takings` -- DROP TABLE IF EXISTS `wp_watu_takings`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_watu_takings` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `exam_id` int(11) NOT NULL DEFAULT '0', `user_id` int(11) NOT NULL DEFAULT '0', `ip` varchar(20) NOT NULL DEFAULT '', `date` date NOT NULL DEFAULT '1900-01-01', `points` int(11) NOT NULL DEFAULT '0', `grade_id` int(10) unsigned NOT NULL DEFAULT '0', `result` text, `snapshot` mediumtext, `start_time` datetime DEFAULT NULL, `email` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_wfBadLeechers` -- DROP TABLE IF EXISTS `wp_wfBadLeechers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_wfBadLeechers` ( `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', `hits` int(10) unsigned NOT NULL, PRIMARY KEY (`eMin`,`IP`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_wfBlockedIPLog` -- DROP TABLE IF EXISTS `wp_wfBlockedIPLog`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_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, PRIMARY KEY (`IP`,`unixday`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_wfBlocks` -- DROP TABLE IF EXISTS `wp_wfBlocks`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_wfBlocks` ( `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', `wfsn` tinyint(3) unsigned DEFAULT '0', `permanent` tinyint(3) unsigned DEFAULT '0', PRIMARY KEY (`IP`), KEY `k1` (`wfsn`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_wfBlocksAdv` -- DROP TABLE IF EXISTS `wp_wfBlocksAdv`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_wfBlocksAdv` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `blockType` char(2) NOT NULL, `blockString` varchar(255) NOT NULL, `ctime` int(10) unsigned NOT NULL, `reason` varchar(255) NOT NULL, `totalBlocked` int(10) unsigned DEFAULT '0', `lastBlocked` int(10) unsigned DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_wfConfig` -- DROP TABLE IF EXISTS `wp_wfConfig`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_wfConfig` ( `name` varchar(100) NOT NULL, `val` longblob, PRIMARY KEY (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_wfCrawlers` -- DROP TABLE IF EXISTS `wp_wfCrawlers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_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=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_wfFileMods` -- DROP TABLE IF EXISTS `wp_wfFileMods`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_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, PRIMARY KEY (`filenameMD5`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_wfHits` -- DROP TABLE IF EXISTS `wp_wfHits`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_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, `referer` text, `UA` text, `action` varchar(64) NOT NULL DEFAULT '', `actionDescription` text, `actionData` text, PRIMARY KEY (`id`), KEY `k1` (`ctime`), KEY `k2` (`IP`,`ctime`), KEY `attackLogTime` (`attackLogTime`) ) ENGINE=InnoDB AUTO_INCREMENT=31580 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_wfHoover` -- DROP TABLE IF EXISTS `wp_wfHoover`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_wfHoover` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `owner` text, `host` text, `path` text, `hostKey` binary(4) DEFAULT NULL, PRIMARY KEY (`id`), KEY `k2` (`hostKey`) ) ENGINE=InnoDB AUTO_INCREMENT=955 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_wfIssues` -- DROP TABLE IF EXISTS `wp_wfIssues`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_wfIssues` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `time` 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, `data` text, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_wfLeechers` -- DROP TABLE IF EXISTS `wp_wfLeechers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_wfLeechers` ( `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', `hits` int(10) unsigned NOT NULL, PRIMARY KEY (`eMin`,`IP`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_wfLockedOut` -- DROP TABLE IF EXISTS `wp_wfLockedOut`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_wfLockedOut` ( `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', PRIMARY KEY (`IP`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_wfLocs` -- DROP TABLE IF EXISTS `wp_wfLocs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_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 `wp_wfLogins` -- DROP TABLE IF EXISTS `wp_wfLogins`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_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, 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 `wp_wfNet404s` -- DROP TABLE IF EXISTS `wp_wfNet404s`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_wfNet404s` ( `sig` binary(16) NOT NULL, `ctime` int(10) unsigned NOT NULL, `URI` varchar(1000) NOT NULL, PRIMARY KEY (`sig`), KEY `k1` (`ctime`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_wfReverseCache` -- DROP TABLE IF EXISTS `wp_wfReverseCache`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_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=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_wfScanners` -- DROP TABLE IF EXISTS `wp_wfScanners`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_wfScanners` ( `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', `hits` smallint(5) unsigned NOT NULL, PRIMARY KEY (`eMin`,`IP`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_wfStatus` -- DROP TABLE IF EXISTS `wp_wfStatus`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_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=2136 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_wfThrottleLog` -- DROP TABLE IF EXISTS `wp_wfThrottleLog`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_wfThrottleLog` ( `IP` binary(16) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0', `startTime` int(10) unsigned NOT NULL, `endTime` int(10) unsigned NOT NULL, `timesThrottled` int(10) unsigned NOT NULL, `lastReason` varchar(255) NOT NULL, PRIMARY KEY (`IP`), KEY `k2` (`endTime`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_wfVulnScanners` -- DROP TABLE IF EXISTS `wp_wfVulnScanners`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_wfVulnScanners` ( `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, `hits` 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 `wp_wp_pro_quiz_category` -- DROP TABLE IF EXISTS `wp_wp_pro_quiz_category`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_wp_pro_quiz_category` ( `category_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `category_name` varchar(200) NOT NULL, `type` enum('QUESTION','QUIZ') NOT NULL DEFAULT 'QUESTION', PRIMARY KEY (`category_id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_wp_pro_quiz_form` -- DROP TABLE IF EXISTS `wp_wp_pro_quiz_form`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_wp_pro_quiz_form` ( `form_id` int(11) NOT NULL AUTO_INCREMENT, `quiz_id` int(11) NOT NULL, `fieldname` varchar(100) NOT NULL, `type` tinyint(4) NOT NULL, `required` tinyint(1) unsigned NOT NULL, `sort` tinyint(4) NOT NULL, `show_in_statistic` tinyint(1) unsigned NOT NULL, `data` mediumtext, PRIMARY KEY (`form_id`), KEY `quiz_id` (`quiz_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_wp_pro_quiz_lock` -- DROP TABLE IF EXISTS `wp_wp_pro_quiz_lock`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_wp_pro_quiz_lock` ( `quiz_id` int(11) NOT NULL, `lock_ip` varchar(100) NOT NULL, `user_id` bigint(20) unsigned NOT NULL, `lock_type` tinyint(3) unsigned NOT NULL, `lock_date` int(11) NOT NULL, PRIMARY KEY (`quiz_id`,`lock_ip`,`user_id`,`lock_type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_wp_pro_quiz_master` -- DROP TABLE IF EXISTS `wp_wp_pro_quiz_master`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_wp_pro_quiz_master` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(200) NOT NULL, `text` text NOT NULL, `result_text` text NOT NULL, `result_grade_enabled` tinyint(1) NOT NULL, `title_hidden` tinyint(1) NOT NULL, `btn_restart_quiz_hidden` tinyint(1) NOT NULL, `btn_view_question_hidden` tinyint(1) NOT NULL, `question_random` tinyint(1) NOT NULL, `answer_random` tinyint(1) NOT NULL, `time_limit` int(11) NOT NULL, `statistics_on` tinyint(1) NOT NULL, `statistics_ip_lock` int(10) unsigned NOT NULL, `show_points` tinyint(1) NOT NULL, `quiz_run_once` tinyint(1) NOT NULL, `quiz_run_once_type` tinyint(4) NOT NULL, `quiz_run_once_cookie` tinyint(1) NOT NULL, `quiz_run_once_time` int(10) unsigned NOT NULL, `numbered_answer` tinyint(1) NOT NULL, `hide_answer_message_box` tinyint(1) NOT NULL, `disabled_answer_mark` tinyint(1) NOT NULL, `show_max_question` tinyint(1) NOT NULL, `show_max_question_value` int(10) unsigned NOT NULL, `show_max_question_percent` tinyint(1) NOT NULL, `toplist_activated` tinyint(1) NOT NULL, `toplist_data` text NOT NULL, `show_average_result` tinyint(1) NOT NULL, `prerequisite` tinyint(1) NOT NULL, `quiz_modus` tinyint(3) unsigned NOT NULL, `show_review_question` tinyint(1) NOT NULL, `quiz_summary_hide` tinyint(1) NOT NULL, `skip_question_disabled` tinyint(1) NOT NULL, `email_notification` tinyint(3) unsigned NOT NULL, `user_email_notification` tinyint(1) unsigned NOT NULL, `show_category_score` tinyint(1) unsigned NOT NULL, `hide_result_correct_question` tinyint(1) unsigned NOT NULL DEFAULT '0', `hide_result_quiz_time` tinyint(1) unsigned NOT NULL DEFAULT '0', `hide_result_points` tinyint(1) unsigned NOT NULL DEFAULT '0', `autostart` tinyint(1) unsigned NOT NULL DEFAULT '0', `forcing_question_solve` tinyint(1) unsigned NOT NULL DEFAULT '0', `hide_question_position_overview` tinyint(1) unsigned NOT NULL DEFAULT '0', `hide_question_numbering` tinyint(1) unsigned NOT NULL DEFAULT '0', `form_activated` tinyint(1) unsigned NOT NULL, `form_show_position` tinyint(3) unsigned NOT NULL, `start_only_registered_user` tinyint(1) unsigned NOT NULL, `questions_per_page` tinyint(3) unsigned NOT NULL, `sort_categories` tinyint(1) unsigned NOT NULL, `show_category` tinyint(1) unsigned NOT NULL, `category_id` int(10) unsigned NOT NULL, `admin_email` text NOT NULL, `user_email` text NOT NULL, `plugin_container` text, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_wp_pro_quiz_prerequisite` -- DROP TABLE IF EXISTS `wp_wp_pro_quiz_prerequisite`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_wp_pro_quiz_prerequisite` ( `prerequisite_quiz_id` int(11) NOT NULL, `quiz_id` int(11) NOT NULL, PRIMARY KEY (`prerequisite_quiz_id`,`quiz_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_wp_pro_quiz_question` -- DROP TABLE IF EXISTS `wp_wp_pro_quiz_question`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_wp_pro_quiz_question` ( `id` int(11) NOT NULL AUTO_INCREMENT, `quiz_id` int(11) NOT NULL, `online` tinyint(1) unsigned NOT NULL, `sort` smallint(5) unsigned NOT NULL, `title` varchar(200) NOT NULL, `points` int(11) NOT NULL, `question` text NOT NULL, `correct_msg` text NOT NULL, `incorrect_msg` text NOT NULL, `correct_same_text` tinyint(1) NOT NULL, `tip_enabled` tinyint(1) NOT NULL, `tip_msg` text NOT NULL, `answer_type` varchar(50) NOT NULL, `show_points_in_box` tinyint(1) NOT NULL, `answer_points_activated` tinyint(1) NOT NULL, `answer_data` longtext NOT NULL, `category_id` int(10) unsigned NOT NULL, `answer_points_diff_modus_activated` tinyint(1) unsigned NOT NULL, `disable_correct` tinyint(1) unsigned NOT NULL, `matrix_sort_answer_criteria_width` tinyint(3) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `quiz_id` (`quiz_id`), KEY `category_id` (`category_id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_wp_pro_quiz_statistic` -- DROP TABLE IF EXISTS `wp_wp_pro_quiz_statistic`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_wp_pro_quiz_statistic` ( `statistic_ref_id` int(10) unsigned NOT NULL, `question_id` int(11) NOT NULL, `correct_count` int(10) unsigned NOT NULL, `incorrect_count` int(10) unsigned NOT NULL, `hint_count` int(10) unsigned NOT NULL, `solved_count` tinyint(1) NOT NULL, `points` int(10) unsigned NOT NULL, `question_time` int(10) unsigned NOT NULL, `answer_data` text, PRIMARY KEY (`statistic_ref_id`,`question_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_wp_pro_quiz_statistic_ref` -- DROP TABLE IF EXISTS `wp_wp_pro_quiz_statistic_ref`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_wp_pro_quiz_statistic_ref` ( `statistic_ref_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `quiz_id` int(11) NOT NULL, `user_id` bigint(20) unsigned NOT NULL, `create_time` int(11) NOT NULL, `is_old` tinyint(1) unsigned NOT NULL, `form_data` text, PRIMARY KEY (`statistic_ref_id`), KEY `quiz_id` (`quiz_id`,`user_id`), KEY `time` (`create_time`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_wp_pro_quiz_template` -- DROP TABLE IF EXISTS `wp_wp_pro_quiz_template`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_wp_pro_quiz_template` ( `template_id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(200) NOT NULL, `type` tinyint(3) unsigned NOT NULL, `data` text NOT NULL, PRIMARY KEY (`template_id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_wp_pro_quiz_toplist` -- DROP TABLE IF EXISTS `wp_wp_pro_quiz_toplist`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_wp_pro_quiz_toplist` ( `toplist_id` int(11) NOT NULL AUTO_INCREMENT, `quiz_id` int(11) NOT NULL, `date` int(10) unsigned NOT NULL, `user_id` bigint(20) unsigned NOT NULL, `name` varchar(30) NOT NULL, `email` varchar(200) NOT NULL, `points` int(10) unsigned NOT NULL, `result` float unsigned NOT NULL, `ip` varchar(100) NOT NULL, PRIMARY KEY (`toplist_id`,`quiz_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wp_yarpp_related_cache` -- DROP TABLE IF EXISTS `wp_yarpp_related_cache`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_yarpp_related_cache` ( `reference_ID` bigint(20) unsigned NOT NULL DEFAULT '0', `ID` bigint(20) unsigned NOT NULL DEFAULT '0', `score` float unsigned NOT NULL DEFAULT '0', `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`reference_ID`,`ID`), KEY `score` (`score`), KEY `ID` (`ID`) ) ENGINE=MyISAM 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 2016-07-13 11:52:38
