Skip to content

Instantly share code, notes, and snippets.

@jutta-livingmiracles
Last active November 30, 2018 23:14
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jutta-livingmiracles/aac6d14673e58be89db49c5323890b3c to your computer and use it in GitHub Desktop.
Save jutta-livingmiracles/aac6d14673e58be89db49c5323890b3c to your computer and use it in GitHub Desktop.
-- phpMyAdmin SQL Dump
-- version 2.11.11.3
-- http://www.phpmyadmin.net
--
-- Host: 198.71.239.71:3308
-- Generation Time: Nov 30, 2018 at 04:07 PM
-- Server version: 5.6.32
-- PHP Version: 5.3.3
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Database: `nxxxxxxxxxxxxxx`
--
-- --------------------------------------------------------
--
-- Table structure for table `wp_relevanssi`
--
CREATE TABLE `wp_relevanssi` (
`doc` bigint(20) NOT NULL DEFAULT '0',
`term` varchar(50) NOT NULL DEFAULT '0',
`term_reverse` varchar(50) NOT NULL DEFAULT '0',
`content` mediumint(9) NOT NULL DEFAULT '0',
`title` mediumint(9) NOT NULL DEFAULT '0',
`comment` mediumint(9) NOT NULL DEFAULT '0',
`tag` mediumint(9) NOT NULL DEFAULT '0',
`link` mediumint(9) NOT NULL DEFAULT '0',
`author` mediumint(9) NOT NULL DEFAULT '0',
`category` mediumint(9) NOT NULL DEFAULT '0',
`excerpt` mediumint(9) NOT NULL DEFAULT '0',
`taxonomy` mediumint(9) NOT NULL DEFAULT '0',
`customfield` mediumint(9) NOT NULL DEFAULT '0',
`mysqlcolumn` mediumint(9) NOT NULL DEFAULT '0',
`taxonomy_detail` longtext NOT NULL,
`customfield_detail` longtext NOT NULL,
`mysqlcolumn_detail` longtext NOT NULL,
`type` varchar(210) NOT NULL DEFAULT 'post',
`item` bigint(20) NOT NULL DEFAULT '0',
UNIQUE KEY `doctermitem` (`doc`,`term`,`item`),
KEY `terms` (`term`(20)),
KEY `relevanssi_term_reverse_idx` (`term_reverse`(10)),
KEY `docs` (`doc`),
KEY `typeitem` (`type`,`item`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `wp_relevanssi`
--
INSERT INTO `wp_relevanssi` VALUES(941, 941, 'misperception', 'noitpecrepsim', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', 'post', 0, 6.00);
INSERT INTO `wp_relevanssi` VALUES(738, 738, 'misperception', 'noitpecrepsim', 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', 'post', 0, 12.00);
INSERT INTO `wp_relevanssi` VALUES(339, 339, 'misperception', 'noitpecrepsim', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', 'post', 0, 6.00);
INSERT INTO `wp_relevanssi` VALUES(322, 322, 'misperception', 'noitpecrepsim', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', 'post', 0, 6.00);
INSERT INTO `wp_relevanssi` VALUES(308, 308, 'misperception', 'noitpecrepsim', 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', 'post', 0, 12.00);
INSERT INTO `wp_relevanssi` VALUES(298, 298, 'misperception', 'noitpecrepsim', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', 'post', 0, 6.00);
INSERT INTO `wp_relevanssi` VALUES(287, 287, 'misperception', 'noitpecrepsim', 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', 'post', 0, 12.00);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment