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