forked from tpwd/ke_search
-
Notifications
You must be signed in to change notification settings - Fork 0
/
ext_tables.sql
187 lines (168 loc) · 4.98 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
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
#
# Table structure for table 'pages'
#
CREATE TABLE pages (
tx_kesearch_tags text,
tx_kesearch_abstract text,
tx_kesearch_resultimage int(11) unsigned DEFAULT '0' NOT NULL
);
#
# Table structure for table 'sys_category'
#
CREATE TABLE sys_category (
tx_kesearch_filter text,
tx_kesearch_filtersubcat text
);
#
# Table structure for table 'tx_kesearch_filters'
#
CREATE TABLE tx_kesearch_filters (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
tstamp int(11) DEFAULT '0' NOT NULL,
crdate int(11) DEFAULT '0' NOT NULL,
cruser_id int(11) DEFAULT '0' NOT NULL,
sys_language_uid int(11) DEFAULT '0' NOT NULL,
l10n_parent int(11) DEFAULT '0' NOT NULL,
l10n_diffsource mediumtext,
deleted tinyint(4) DEFAULT '0' NOT NULL,
hidden tinyint(4) DEFAULT '0' NOT NULL,
title tinytext,
options text,
rendertype varchar(90) DEFAULT '' NOT NULL,
markAllCheckboxes tinyint(1) DEFAULT '0' NOT NULL,
target_pid int(11) DEFAULT '0' NOT NULL,
amount int(11) DEFAULT '0' NOT NULL,
shownumberofresults tinyint(1) DEFAULT '0' NOT NULL,
alphabeticalsorting tinyint(1) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
#
# Table structure for table 'tx_kesearch_filteroptions'
#
CREATE TABLE tx_kesearch_filteroptions (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
tstamp int(11) DEFAULT '0' NOT NULL,
crdate int(11) DEFAULT '0' NOT NULL,
cruser_id int(11) DEFAULT '0' NOT NULL,
sys_language_uid int(11) DEFAULT '0' NOT NULL,
l10n_parent int(11) DEFAULT '0' NOT NULL,
l10n_diffsource mediumtext,
deleted tinyint(4) DEFAULT '0' NOT NULL,
hidden tinyint(4) DEFAULT '0' NOT NULL,
title tinytext,
tag tinytext,
slug varchar(2048),
automated_tagging text,
automated_tagging_exclude text,
sorting int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
#
# Table structure for table 'tx_kesearch_index'
#
CREATE TABLE tx_kesearch_index (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
tstamp int(11) DEFAULT '0' NOT NULL,
crdate int(11) DEFAULT '0' NOT NULL,
cruser_id int(11) DEFAULT '0' NOT NULL,
starttime int(11) DEFAULT '0' NOT NULL,
endtime int(11) DEFAULT '0' NOT NULL,
fe_group varchar(100) DEFAULT '0' NOT NULL,
targetpid text,
content mediumtext,
hidden_content mediumtext,
params tinytext,
type tinytext,
tags text,
abstract text,
sortdate int(11) DEFAULT '0' NOT NULL,
orig_uid varchar(255) DEFAULT '0' NOT NULL,
orig_pid int(11) DEFAULT '0' NOT NULL,
title tinytext,
language int(11) DEFAULT '0' NOT NULL,
directory tinytext,
hash varchar(32) DEFAULT '' NOT NULL,
FULLTEXT INDEX tags (tags),
FULLTEXT INDEX title (title),
FULLTEXT INDEX titlecontent (title,content),
FULLTEXT INDEX titlecontenthiddencontent (title,content,hidden_content),
PRIMARY KEY (uid),
KEY parent (pid)
) ENGINE = MyISAM;
#
# Table structure for table 'tx_kesearch_indexerconfig'
#
CREATE TABLE tx_kesearch_indexerconfig (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
tstamp int(11) DEFAULT '0' NOT NULL,
crdate int(11) DEFAULT '0' NOT NULL,
cruser_id int(11) DEFAULT '0' NOT NULL,
deleted tinyint(4) DEFAULT '0' NOT NULL,
hidden tinyint(4) DEFAULT '0' NOT NULL,
title tinytext,
storagepid text,
targetpid text,
startingpoints_recursive text,
single_pages text,
sysfolder text,
index_content_with_restrictions text,
type varchar(90) DEFAULT '' NOT NULL,
index_news_category_mode tinyint(4) DEFAULT '0' NOT NULL,
index_news_category_selection text,
index_extnews_category_selection text,
index_news_archived tinyint(4) DEFAULT '0' NOT NULL,
index_news_useHRDatesSingle tinyint(4) DEFAULT '0' NOT NULL,
index_news_useHRDatesSingleWithoutDay tinyint(4) DEFAULT '0' NOT NULL,
index_news_files_mode tinyint(4) DEFAULT '0' NOT NULL,
index_use_page_tags tinyint(3) DEFAULT '0' NOT NULL,
index_use_page_tags_for_files tinyint(3) DEFAULT '0' NOT NULL,
index_page_doctypes varchar(255) DEFAULT '' NOT NULL,
directories text,
fileext tinytext,
content_fields text,
file_reference_fields text,
filteroption int(11) DEFAULT '0' NOT NULL,
fal_storage int(11) DEFAULT '0' NOT NULL,
contenttypes text,
PRIMARY KEY (uid),
KEY parent (pid)
);
#
# Table structure for table 'tx_kesearch_stat_search'
#
CREATE TABLE tx_kesearch_stat_search (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
searchphrase text,
tstamp int(11) DEFAULT '0' NOT NULL,
hits int(11) DEFAULT '0' NOT NULL,
tagsagainst text,
language int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid)
);
#
# Table structure for table 'tx_kesearch_stat_word'
#
CREATE TABLE tx_kesearch_stat_word (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
word text,
tstamp int(11) DEFAULT '0' NOT NULL,
pageid int(11) DEFAULT '0' NOT NULL,
resultsfound int(1) DEFAULT '0' NOT NULL,
language int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid)
);
#
# Table structure for table 'sys_file_metadata'
#
CREATE TABLE sys_file_metadata
(
tx_kesearch_no_search tinyint(4) DEFAULT '0' NOT NULL
);