forked from TYPO3-Solr/ext-solr
-
Notifications
You must be signed in to change notification settings - Fork 1
/
ext_tables.sql
145 lines (118 loc) · 3.72 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
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
#
# 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,
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_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) 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(191),item_uid),
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_cache'
#
CREATE TABLE tx_solr_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_solr_cache_tags'
#
CREATE TABLE tx_solr_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;
#
# 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;
#
# Update size of entry_value for table 'sys_registry'
#
CREATE TABLE sys_registry (
entry_value longblob
) 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)
);