forked from TYPO3-CMS/indexed_search
-
Notifications
You must be signed in to change notification settings - Fork 0
/
ext_tables.sql
149 lines (137 loc) · 4.34 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
#
# Table structure for table 'index_phash'
#
CREATE TABLE index_phash (
phash int(11) DEFAULT '0' NOT NULL,
phash_grouping int(11) DEFAULT '0' NOT NULL,
static_page_arguments blob,
data_filename varchar(1024) DEFAULT '' NOT NULL,
data_page_id int(11) unsigned DEFAULT '0' NOT NULL,
data_page_type int(11) unsigned DEFAULT '0' NOT NULL,
data_page_mp varchar(255) DEFAULT '' NOT NULL,
gr_list varchar(255) DEFAULT '' NOT NULL,
item_type varchar(5) DEFAULT '' NOT NULL,
item_title varchar(255) DEFAULT '' NOT NULL,
item_description varchar(255) DEFAULT '' NOT NULL,
item_mtime int(11) DEFAULT '0' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
item_size int(11) DEFAULT '0' NOT NULL,
contentHash int(11) DEFAULT '0' NOT NULL,
crdate int(11) DEFAULT '0' NOT NULL,
parsetime int(11) DEFAULT '0' NOT NULL,
sys_language_uid int(11) DEFAULT '0' NOT NULL,
item_crdate int(11) DEFAULT '0' NOT NULL,
externalUrl tinyint(3) DEFAULT '0' NOT NULL,
recordUid int(11) DEFAULT '0' NOT NULL,
freeIndexUid int(11) DEFAULT '0' NOT NULL,
freeIndexSetId int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (phash),
KEY phash_grouping (phash_grouping),
KEY freeIndexUid (freeIndexUid)
) ENGINE=InnoDB;
#
# Table structure for table 'index_fulltext'
#
CREATE TABLE index_fulltext (
phash int(11) DEFAULT '0' NOT NULL,
fulltextdata mediumtext,
metaphonedata mediumtext NOT NULL,
PRIMARY KEY (phash)
) ENGINE=InnoDB;
#
# Table structure for table 'index_rel'
#
CREATE TABLE index_rel (
phash int(11) DEFAULT '0' NOT NULL,
wid int(11) DEFAULT '0' NOT NULL,
count tinyint(3) unsigned DEFAULT '0' NOT NULL,
first int(11) unsigned DEFAULT '0' NOT NULL,
freq smallint(5) unsigned DEFAULT '0' NOT NULL,
flags tinyint(3) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (phash,wid),
KEY wid (wid,phash)
) ENGINE=InnoDB;
#
# Table structure for table 'index_words'
#
CREATE TABLE index_words (
wid int(11) DEFAULT '0' NOT NULL,
baseword varchar(60) DEFAULT '' NOT NULL,
metaphone int(11) DEFAULT '0' NOT NULL,
is_stopword tinyint(3) DEFAULT '0' NOT NULL,
PRIMARY KEY (wid),
KEY baseword (baseword),
KEY metaphone (metaphone)
) ENGINE=InnoDB;
#
# Table structure for table 'index_section'
#
CREATE TABLE index_section (
phash int(11) DEFAULT '0' NOT NULL,
phash_t3 int(11) DEFAULT '0' NOT NULL,
rl0 int(11) unsigned DEFAULT '0' NOT NULL,
rl1 int(11) unsigned DEFAULT '0' NOT NULL,
rl2 int(11) unsigned DEFAULT '0' NOT NULL,
page_id int(11) DEFAULT '0' NOT NULL,
uniqid int(11) NOT NULL auto_increment,
PRIMARY KEY (uniqid),
KEY joinkey (phash,rl0),
KEY page_id (page_id),
KEY rl0 (rl0,rl1,phash),
KEY rl0_2 (rl0,phash)
) ENGINE=InnoDB;
#
# Table structure for table 'index_grlist'
#
CREATE TABLE index_grlist (
phash int(11) DEFAULT '0' NOT NULL,
phash_x int(11) DEFAULT '0' NOT NULL,
hash_gr_list int(11) DEFAULT '0' NOT NULL,
gr_list varchar(255) DEFAULT '' NOT NULL,
uniqid int(11) NOT NULL auto_increment,
PRIMARY KEY (uniqid),
KEY joinkey (phash,hash_gr_list),
KEY phash_grouping (phash_x,hash_gr_list)
) ENGINE=InnoDB;
#
# Table structure for table 'index_debug'
#
CREATE TABLE index_debug (
phash int(11) DEFAULT '0' NOT NULL,
debuginfo mediumtext,
PRIMARY KEY (phash)
);
#
# Table structure for table 'index_config'
#
CREATE TABLE index_config (
set_id int(11) DEFAULT '0' NOT NULL,
session_data mediumtext,
title varchar(255) DEFAULT '' NOT NULL,
type varchar(30) DEFAULT '' NOT NULL,
depth int(11) unsigned DEFAULT '0' NOT NULL,
table2index varchar(255) DEFAULT '' NOT NULL,
alternative_source_pid int(11) unsigned DEFAULT '0' NOT NULL,
get_params varchar(255) DEFAULT '' NOT NULL,
fieldlist varchar(255) DEFAULT '' NOT NULL,
externalUrl varchar(255) DEFAULT '' NOT NULL,
indexcfgs text,
filepath varchar(255) DEFAULT '' NOT NULL,
extensions varchar(255) DEFAULT '' NOT NULL,
timer_frequency int(11) DEFAULT '0' NOT NULL,
url_deny text,
recordsbatch int(11) DEFAULT '0' NOT NULL,
records_indexonchange tinyint(4) DEFAULT '0' NOT NULL
);
#
# Table structure for table 'index_stat_word'
#
CREATE TABLE index_stat_word (
uid int(11) NOT NULL auto_increment,
word varchar(50) DEFAULT '' NOT NULL,
index_stat_search_id int(11) DEFAULT '0' NOT NULL,
tstamp int(11) DEFAULT '0' NOT NULL,
pageid int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY tstamp (tstamp,word)
) ENGINE=InnoDB;