forked from TYPO3-extensions/solr
-
Notifications
You must be signed in to change notification settings - Fork 0
/
ext_tables.sql
111 lines (88 loc) · 2.78 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
#
# 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(10) 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 keywords (keywords),
KEY rootpid_keywords (root_pid,keywords)
) 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,
PRIMARY KEY (uid),
KEY changed (changed),
KEY item_id (item_type,item_uid)
) 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;