[RELEASE] Release of TYPO3 9.5.3
[Packages/TYPO3.CMS.git] / typo3 / sysext / indexed_search / ext_tables.sql
1
2 #
3 # Table structure for table 'index_phash'
4 #
5 CREATE TABLE index_phash (
6 phash int(11) DEFAULT '0' NOT NULL,
7 phash_grouping int(11) DEFAULT '0' NOT NULL,
8 cHashParams blob,
9 data_filename varchar(1024) DEFAULT '' NOT NULL,
10 data_page_id int(11) unsigned DEFAULT '0' NOT NULL,
11 data_page_reg1 int(11) unsigned DEFAULT '0' NOT NULL,
12 data_page_type int(11) unsigned DEFAULT '0' NOT NULL,
13 data_page_mp varchar(255) DEFAULT '' NOT NULL,
14 gr_list varchar(255) DEFAULT '' NOT NULL,
15 item_type varchar(5) DEFAULT '' NOT NULL,
16 item_title varchar(255) DEFAULT '' NOT NULL,
17 item_description varchar(255) DEFAULT '' NOT NULL,
18 item_mtime int(11) DEFAULT '0' NOT NULL,
19 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
20 item_size int(11) DEFAULT '0' NOT NULL,
21 contentHash int(11) DEFAULT '0' NOT NULL,
22 crdate int(11) DEFAULT '0' NOT NULL,
23 parsetime int(11) DEFAULT '0' NOT NULL,
24 sys_language_uid int(11) DEFAULT '0' NOT NULL,
25 item_crdate int(11) DEFAULT '0' NOT NULL,
26 externalUrl tinyint(3) DEFAULT '0' NOT NULL,
27 recordUid int(11) DEFAULT '0' NOT NULL,
28 freeIndexUid int(11) DEFAULT '0' NOT NULL,
29 freeIndexSetId int(11) DEFAULT '0' NOT NULL,
30 PRIMARY KEY (phash),
31 KEY phash_grouping (phash_grouping),
32 KEY freeIndexUid (freeIndexUid)
33 ) ENGINE=InnoDB;
34
35 #
36 # Table structure for table 'index_fulltext'
37 #
38 CREATE TABLE index_fulltext (
39 phash int(11) DEFAULT '0' NOT NULL,
40 fulltextdata mediumtext,
41 metaphonedata mediumtext NOT NULL,
42 PRIMARY KEY (phash)
43 ) ENGINE=InnoDB;
44
45 #
46 # Table structure for table 'index_rel'
47 #
48 CREATE TABLE index_rel (
49 phash int(11) DEFAULT '0' NOT NULL,
50 wid int(11) DEFAULT '0' NOT NULL,
51 count tinyint(3) unsigned DEFAULT '0' NOT NULL,
52 first int(11) unsigned DEFAULT '0' NOT NULL,
53 freq smallint(5) unsigned DEFAULT '0' NOT NULL,
54 flags tinyint(3) unsigned DEFAULT '0' NOT NULL,
55 PRIMARY KEY (phash,wid),
56 KEY wid (wid,phash)
57 ) ENGINE=InnoDB;
58
59 #
60 # Table structure for table 'index_words'
61 #
62 CREATE TABLE index_words (
63 wid int(11) DEFAULT '0' NOT NULL,
64 baseword varchar(60) DEFAULT '' NOT NULL,
65 metaphone int(11) DEFAULT '0' NOT NULL,
66 is_stopword tinyint(3) DEFAULT '0' NOT NULL,
67 PRIMARY KEY (wid),
68 KEY baseword (baseword),
69 KEY metaphone (metaphone)
70 ) ENGINE=InnoDB;
71
72 #
73 # Table structure for table 'index_section'
74 #
75 CREATE TABLE index_section (
76 phash int(11) DEFAULT '0' NOT NULL,
77 phash_t3 int(11) DEFAULT '0' NOT NULL,
78 rl0 int(11) unsigned DEFAULT '0' NOT NULL,
79 rl1 int(11) unsigned DEFAULT '0' NOT NULL,
80 rl2 int(11) unsigned DEFAULT '0' NOT NULL,
81 page_id int(11) DEFAULT '0' NOT NULL,
82 uniqid int(11) NOT NULL auto_increment,
83 PRIMARY KEY (uniqid),
84 KEY joinkey (phash,rl0),
85 KEY page_id (page_id),
86 KEY rl0 (rl0,rl1,phash),
87 KEY rl0_2 (rl0,phash)
88 ) ENGINE=InnoDB;
89
90 #
91 # Table structure for table 'index_grlist'
92 #
93 CREATE TABLE index_grlist (
94 phash int(11) DEFAULT '0' NOT NULL,
95 phash_x int(11) DEFAULT '0' NOT NULL,
96 hash_gr_list int(11) DEFAULT '0' NOT NULL,
97 gr_list varchar(255) DEFAULT '' NOT NULL,
98 uniqid int(11) NOT NULL auto_increment,
99 PRIMARY KEY (uniqid),
100 KEY joinkey (phash,hash_gr_list),
101 KEY phash_grouping (phash_x,hash_gr_list)
102 ) ENGINE=InnoDB;
103
104 #
105 # Table structure for table 'index_stat_search'
106 #
107 CREATE TABLE index_stat_search (
108 uid int(11) NOT NULL auto_increment,
109 searchstring varchar(255) DEFAULT '' NOT NULL,
110 searchoptions blob,
111 tstamp int(11) DEFAULT '0' NOT NULL,
112 feuser_id int(11) unsigned DEFAULT '0' NOT NULL,
113 cookie varchar(32) DEFAULT '' NOT NULL,
114 IP varchar(255) DEFAULT '' NOT NULL,
115 hits int(11) DEFAULT '0' NOT NULL,
116 PRIMARY KEY (uid)
117 ) ENGINE=InnoDB;
118
119 #
120 # Table structure for table 'index_debug'
121 #
122 CREATE TABLE index_debug (
123 phash int(11) DEFAULT '0' NOT NULL,
124 debuginfo mediumtext,
125 PRIMARY KEY (phash)
126 );
127
128 #
129 # Table structure for table 'index_config'
130 #
131 CREATE TABLE index_config (
132 set_id int(11) DEFAULT '0' NOT NULL,
133 session_data mediumtext,
134
135 title varchar(255) DEFAULT '' NOT NULL,
136 type varchar(30) DEFAULT '' NOT NULL,
137 depth int(11) unsigned DEFAULT '0' NOT NULL,
138 table2index varchar(255) DEFAULT '' NOT NULL,
139 alternative_source_pid int(11) unsigned DEFAULT '0' NOT NULL,
140 get_params varchar(255) DEFAULT '' NOT NULL,
141 fieldlist varchar(255) DEFAULT '' NOT NULL,
142 externalUrl varchar(255) DEFAULT '' NOT NULL,
143 indexcfgs text,
144 chashcalc tinyint(3) unsigned DEFAULT '0' NOT NULL,
145 filepath varchar(255) DEFAULT '' NOT NULL,
146 extensions varchar(255) DEFAULT '' NOT NULL,
147
148 timer_next_indexing int(11) DEFAULT '0' NOT NULL,
149 timer_frequency int(11) DEFAULT '0' NOT NULL,
150 timer_offset int(11) DEFAULT '0' NOT NULL,
151 url_deny text,
152 recordsbatch int(11) DEFAULT '0' NOT NULL,
153 records_indexonchange tinyint(4) DEFAULT '0' NOT NULL
154 );
155
156
157 #
158 # Table structure for table 'index_stat_word'
159 #
160 CREATE TABLE index_stat_word (
161 uid int(11) NOT NULL auto_increment,
162 word varchar(30) DEFAULT '' NOT NULL,
163 index_stat_search_id int(11) DEFAULT '0' NOT NULL,
164 tstamp int(11) DEFAULT '0' NOT NULL,
165 pageid int(11) DEFAULT '0' NOT NULL,
166 PRIMARY KEY (uid),
167 KEY tstamp (tstamp,word)
168 ) ENGINE=InnoDB;