Indexed Search modifications for support of cronjob based indexing. More to come...
[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) DEFAULT '0' 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) DEFAULT '0' 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) DEFAULT '0' 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) DEFAULT '0' 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) DEFAULT '0' NOT NULL auto_increment,
152 pid int(11) DEFAULT '0' NOT NULL,
153 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
154 crdate int(11) unsigned DEFAULT '0' NOT NULL,
155 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
156 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
157 starttime int(11) unsigned DEFAULT '0' NOT NULL,
158
159 set_id int(11) DEFAULT '0' NOT NULL,
160 session_data mediumtext NOT NULL,
161 first_run_time int(11) unsigned DEFAULT '0' NOT NULL,
162 frequency int(11) unsigned DEFAULT '0' NOT NULL,
163 last_run int(11) unsigned DEFAULT '0' NOT NULL,
164
165 title tinytext NOT NULL,
166 description text NOT NULL,
167 type int(11) unsigned DEFAULT '0' NOT NULL,
168 depth int(11) unsigned DEFAULT '0' NOT NULL,
169 table2index tinytext NOT NULL,
170 alternative_source_pid blob NOT NULL,
171 get_params tinytext NOT NULL,
172 fieldlist tinytext NOT NULL,
173 externalUrl tinytext NOT NULL,
174 chashcalc tinyint(3) unsigned DEFAULT '0' NOT NULL,
175 filepath tinytext NOT NULL,
176 extensions tinytext NOT NULL,
177
178 PRIMARY KEY (uid),
179 KEY parent (pid)
180 );
181
182
183 #
184 # Table structure for table 'index_stat_word'
185 #
186 CREATE TABLE index_stat_word (
187 uid int(11) DEFAULT '0' NOT NULL auto_increment,
188 word varchar(30) DEFAULT '' NOT NULL,
189 index_stat_search_id int(11) DEFAULT '0' NOT NULL,
190 tstamp int(11) DEFAULT '0' NOT NULL,
191 pageid int(11) DEFAULT '0' NOT NULL,
192 PRIMARY KEY (uid),
193 KEY tstamp (tstamp,word)
194 );