forked from TYPO3-Solr/ext-solr
-
Notifications
You must be signed in to change notification settings - Fork 0
/
ext_tables.sql
111 lines (90 loc) · 2.99 KB
/
ext_tables.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
#
# Table structure for table 'tx_solr_last_searches'
#
CREATE TABLE tx_solr_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_solr_statistics'
#
CREATE TABLE tx_solr_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,
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_solr_indexqueue_item'
#
CREATE TABLE tx_solr_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) unsigned 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 root (root),
KEY indexing_priority_changed (indexing_priority, changed),
KEY item_id (item_type(191),item_uid),
KEY site_statistics (root,indexing_configuration),
KEY pages_mountpoint (item_type(191),item_uid,has_indexing_properties,pages_mountidentifier(191))
) ENGINE=InnoDB;
#
# Table structure for table 'tx_solr_indexqueue_indexing_property'
#
CREATE TABLE tx_solr_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_solr_eventqueue_item'
#
CREATE TABLE tx_solr_eventqueue_item (
uid int(11) NOT NULL auto_increment,
tstamp int(11) DEFAULT '0' NOT NULL,
event longblob,
error tinyint(3) unsigned DEFAULT '0' NOT NULL,
error_message text,
PRIMARY KEY (uid),
KEY tstamp (tstamp),
KEY error (error),
) ENGINE=InnoDB;
#
# Extending 'pages' table with extra keys
#
CREATE TABLE pages (
no_search_sub_entries tinyint(3) unsigned DEFAULT '0' NOT NULL,
KEY content_from_pid_deleted (content_from_pid,deleted),
KEY doktype_no_search_deleted (doktype,no_search,deleted)
);