Skip to content

Instantly share code, notes, and snippets.

@msaari

msaari/relevanssi-log.sql

Created October 24, 2017 04:34
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 msaari/59f6fc8115aa21c261e6a6ca7131b18c to your computer and use it in GitHub Desktop.
Save msaari/59f6fc8115aa21c261e6a6ca7131b18c to your computer and use it in GitHub Desktop.
Download ZIP
Relevanssi log table SQL
Raw
relevanssi-log.sql
CREATE TABLE `wp_relevanssi_log` (
`id` bigint(9) NOT NULL AUTO_INCREMENT,
`query` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
`hits` mediumint(9) NOT NULL DEFAULT '0',
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`user_id` bigint(20) NOT NULL DEFAULT '0',
`ip` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment