SQL Import

Sometimes SEO Booster cannot create the necessary database tables automatically.

You can use below SQL instructions to create the database tables needed. You should only do this in rare circumstances or if directed by support or you know what you are doing.

You can also manually create the tables directly in the MySQL database, using PHPMyadmin or similar.

Remember to change the below prefix “wp_” to what you use. Default WordPress prefix is “wp_”

Last updated: March 27th 2019 – Version 3.5.7

-- These SQL instructions will create the necessary database tables for SEO Booster 2.
-- Remember to change the prefix to whatever you are using - Do a search and replace for "wp_".
--

CREATE TABLE `wp_sb2_404` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `lp` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `firstseen` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `lastseen` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `visits` int(11) NOT NULL,
  `referer` text COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


CREATE TABLE `wp_sb2_autolink` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `keyword` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `disable` int(1) DEFAULT '0',
  `nflw` int(1) DEFAULT '0',
  `lastseen` longtext COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `keyword` (`keyword`(191)),
  KEY `url` (`url`(191))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


CREATE TABLE `wp_sb2_bl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `ig` tinyint(1) NOT NULL,
  `domain` text NOT NULL,
  `ref` varchar(1024) NOT NULL,
  `httpstatus` varchar(3) NOT NULL,
  `verified` smallint(1) NOT NULL DEFAULT '0',
  `lp` varchar(1024) NOT NULL,
  `anchor` text NOT NULL,
  `href` text NOT NULL,
  `img` tinyint(4) NOT NULL,
  `visits` int(11) NOT NULL,
  `firstvisit` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `lastvisit` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `lastcheck` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `nflw` tinyint(4) NOT NULL,
  `errorcount` smallint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `ref` (`ref`(255)),
  KEY `ig` (`ig`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


CREATE TABLE `wp_sb2_crawl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `url` varchar(1024) NOT NULL,
  `lastcrawl` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `visits` int(11) NOT NULL DEFAULT '1',
  `engine` varchar(50) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `url` (`url`(255)),
  KEY `engine` (`engine`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


CREATE TABLE `wp_sb2_kw` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `ig` tinyint(4) NOT NULL,
  `kw` varchar(255) NOT NULL,
  `term_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `lp` varchar(500) NOT NULL,
  `googletld` varchar(30) NOT NULL,
  `visits` int(11) NOT NULL,
  `firstvisit` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `lastvisit` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `engine` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `lp` (`lp`(255)),
  KEY `id` (`id`),
  KEY `kw` (`kw`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


CREATE TABLE `wp_sb2_kwdt` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `refid` int(11) NOT NULL,
  `daday` date NOT NULL,
  `visits` int(11) NOT NULL DEFAULT '1',
  `avgpos` int(11) NOT NULL DEFAULT '0',
  `cdhits` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `refid` (`refid`),
  KEY `daday` (`daday`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


CREATE TABLE `wp_sb2_log` (
  `logtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `prio` tinyint(1) NOT NULL,
  `log` varchar(2048) COLLATE utf8mb4_unicode_ci NOT NULL,
  KEY `logtime` (`logtime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


CREATE TABLE `wp_sb2_urls` (
  `ID` bigint(20) NOT NULL AUTO_INCREMENT,
  `urlkey` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` varchar(1024) COLLATE utf8mb4_unicode_ci NOT NULL,
  `absurl` varchar(1024) COLLATE utf8mb4_unicode_ci NOT NULL,
  `http_code` varchar(3) COLLATE utf8mb4_unicode_ci NOT NULL,
  `refid` int(11) DEFAULT NULL,
  `code` varchar(3) COLLATE utf8mb4_unicode_ci NOT NULL,
  `scraped` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID`),
  KEY `urlkey` (`urlkey`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


CREATE TABLE `wp_sb2_urls_meta` (
  `meta_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `refid` int(11) NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`meta_id`),
  KEY `refid` (`refid`),
  KEY `name` (`name`(191))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
Was this article helpful to you? Yes No

How can we help?