meilisearch/ext_tables.sql
2021-04-17 00:26:33 +02:00

130 lines
4.1 KiB
SQL

#
# Table structure for table 'tx_meilisearch_last_searches'
#
CREATE TABLE tx_meilisearch_last_searches
(
sequence_id tinyint(3) unsigned DEFAULT '0' NOT NULL,
tstamp int(11) DEFAULT '0' NOT NULL,
keywords varchar(128) DEFAULT '' NOT NULL,
PRIMARY KEY (sequence_id)
) ENGINE = InnoDB;
#
# Table structure for table 'tx_meilisearch_statistics'
#
CREATE TABLE tx_meilisearch_statistics
(
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
root_pid int(11) DEFAULT '0' NOT NULL,
tstamp int(11) DEFAULT '0' NOT NULL,
language int(11) DEFAULT '0' NOT NULL,
num_found int(11) DEFAULT '0' NOT NULL,
suggestions_shown int(1) DEFAULT '0' NOT NULL,
time_total int(11) DEFAULT '0' NOT NULL,
time_preparation int(11) DEFAULT '0' NOT NULL,
time_processing int(11) DEFAULT '0' NOT NULL,
feuser_id int(11) unsigned DEFAULT '0' NOT NULL,
cookie varchar(32) DEFAULT '' NOT NULL,
ip varchar(255) DEFAULT '' NOT NULL,
keywords varchar(128) DEFAULT '' NOT NULL,
page int(5) unsigned DEFAULT '0' NOT NULL,
filters blob,
sorting varchar(128) DEFAULT '' NOT NULL,
parameters blob,
PRIMARY KEY (uid),
KEY rootpid_keywords (root_pid, keywords),
KEY rootpid_tstamp (root_pid, tstamp)
) ENGINE = InnoDB;
#
# Table structure for table 'tx_meilisearch_indexqueue_item'
#
CREATE TABLE tx_meilisearch_indexqueue_item
(
uid int(11) NOT NULL auto_increment,
root int(11) DEFAULT '0' NOT NULL,
item_type varchar(255) DEFAULT '' NOT NULL,
item_uid int(11) DEFAULT '0' NOT NULL,
indexing_configuration varchar(255) DEFAULT '' NOT NULL,
has_indexing_properties tinyint(1) DEFAULT '0' NOT NULL,
indexing_priority int(11) DEFAULT '0' NOT NULL,
changed int(11) DEFAULT '0' NOT NULL,
indexed int(11) DEFAULT '0' NOT NULL,
errors text NOT NULL,
pages_mountidentifier varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (uid),
KEY changed (changed),
KEY indexing_priority_changed (indexing_priority, changed),
KEY item_id (item_type, item_uid),
KEY pages_mountpoint (item_type, item_uid, has_indexing_properties, pages_mountidentifier)
) ENGINE = InnoDB;
#
# Table structure for table 'tx_meilisearch_indexqueue_indexing_property'
#
CREATE TABLE tx_meilisearch_indexqueue_indexing_property
(
uid int(11) NOT NULL auto_increment,
root int(11) DEFAULT '0' NOT NULL,
item_id int(11) DEFAULT '0' NOT NULL,
property_key varchar(255) DEFAULT '' NOT NULL,
property_value mediumtext NOT NULL,
PRIMARY KEY (uid),
KEY item_id (item_id)
) ENGINE = InnoDB;
#
# Table structure for table 'tx_meilisearch_cache'
#
CREATE TABLE tx_meilisearch_cache
(
id int(11) unsigned NOT NULL auto_increment,
identifier varchar(250) DEFAULT '' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
content mediumblob,
lifetime int(11) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (id),
KEY cache_id (identifier)
) ENGINE = InnoDB;
#
# Table structure for table 'tx_meilisearch_cache_tags'
#
CREATE TABLE tx_meilisearch_cache_tags
(
id int(11) unsigned NOT NULL auto_increment,
identifier varchar(250) DEFAULT '' NOT NULL,
tag varchar(250) DEFAULT '' NOT NULL,
PRIMARY KEY (id),
KEY cache_id (identifier),
KEY cache_tag (tag)
) ENGINE = InnoDB;
#
# Extending 'pages' table with extra keys
#
CREATE TABLE pages
(
KEY content_from_pid_deleted (content_from_pid, deleted),
KEY doktype_no_search_deleted (doktype, no_search, deleted)
);