Added modfunc2 which offers statistics of entered search words.
[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) DEFAULT '0' NOT NULL,
17 data_page_reg1 int(11) DEFAULT '0' NOT NULL,
18 data_page_type tinyint(3) 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) 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 PRIMARY KEY (phash),
36 KEY phash_grouping (phash_grouping)
37 );
38
39 #
40 # Table structure for table 'index_fulltext'
41 #
42 CREATE TABLE index_fulltext (
43 phash int(11) DEFAULT '0' NOT NULL,
44 fulltextdata mediumtext NOT NULL,
45 PRIMARY KEY (phash)
46 );
47
48 #
49 # Table structure for table 'index_rel'
50 #
51 CREATE TABLE index_rel (
52 phash int(11) DEFAULT '0' NOT NULL,
53 wid int(11) DEFAULT '0' NOT NULL,
54 count smallint(5) DEFAULT '0' NOT NULL,
55 first smallint(5) DEFAULT '0' NOT NULL,
56 freq smallint(5) DEFAULT '0' NOT NULL,
57 flags smallint(5) DEFAULT '0' NOT NULL,
58 PRIMARY KEY (phash,wid),
59 KEY wid (wid,phash)
60 );
61
62 #
63 # Table structure for table 'index_words'
64 #
65 CREATE TABLE index_words (
66 wid int(11) DEFAULT '0' NOT NULL,
67 baseword varchar(60) DEFAULT '' NOT NULL,
68 metaphone int(11) DEFAULT '0' NOT NULL,
69 is_stopword tinyint(3) DEFAULT '0' NOT NULL,
70 PRIMARY KEY (wid),
71 KEY baseword (baseword,wid),
72 KEY metaphone (metaphone,wid)
73 );
74
75 #
76 # Table structure for table 'index_section'
77 #
78 CREATE TABLE index_section (
79 phash int(11) DEFAULT '0' NOT NULL,
80 phash_t3 int(11) DEFAULT '0' NOT NULL,
81 rl0 int(11) DEFAULT '0' NOT NULL,
82 rl1 int(11) DEFAULT '0' NOT NULL,
83 rl2 int(11) DEFAULT '0' NOT NULL,
84 page_id int(11) DEFAULT '0' NOT NULL,
85 uniqid int(11) DEFAULT '0' NOT NULL auto_increment,
86 PRIMARY KEY (uniqid),
87 KEY joinkey (phash,rl0),
88 # KEY phash_pid (phash,page_id),
89 KEY page_id (page_id),
90 KEY rl0 (rl0,rl1,phash),
91 KEY rl0_2 (rl0,phash)
92 );
93
94 #
95 # Table structure for table 'index_grlist'
96 #
97 CREATE TABLE index_grlist (
98 phash int(11) DEFAULT '0' NOT NULL,
99 phash_x int(11) DEFAULT '0' NOT NULL,
100 hash_gr_list int(11) DEFAULT '0' NOT NULL,
101 gr_list tinytext NOT NULL,
102 uniqid int(11) DEFAULT '0' NOT NULL auto_increment,
103 PRIMARY KEY (uniqid),
104 KEY joinkey (phash,hash_gr_list),
105 KEY phash_grouping (phash_x,hash_gr_list)
106 );
107
108 #
109 # Table structure for table 'index_stat_search'
110 #
111 CREATE TABLE index_stat_search (
112 uid int(11) DEFAULT '0' NOT NULL auto_increment,
113 searchstring tinytext NOT NULL,
114 searchoptions blob NOT NULL,
115 tstamp int(11) DEFAULT '0' NOT NULL,
116 feuser_id int(11) DEFAULT '0' NOT NULL,
117 cookie varchar(10) DEFAULT '' NOT NULL,
118 IP tinytext NOT NULL,
119 hits int(11) DEFAULT '0' NOT NULL,
120 PRIMARY KEY (uid)
121 );
122
123
124 #
125 # Table structure for table 'index_stat_word'
126 #
127 CREATE TABLE index_stat_word (
128 uid int(11) DEFAULT '0' NOT NULL auto_increment,
129 word varchar(30) DEFAULT '' NOT NULL,
130 index_stat_search_id int(11) DEFAULT '0' NOT NULL,
131 tstamp int(11) DEFAULT '0' NOT NULL,
132 PRIMARY KEY (uid),
133 KEY tstamp (tstamp,word)
134 );
135
136 #
137 # Table structure for table 'index_debug'
138 #
139 CREATE TABLE index_debug (
140 phash int(11) DEFAULT '0' NOT NULL,
141 debuginfo mediumtext NOT NULL,
142 PRIMARY KEY (phash)
143 );
144
145 #
146 # Table structure for table 'index_config'
147 #
148 CREATE TABLE index_config (
149 uid int(11) DEFAULT '0' NOT NULL auto_increment,
150 pid int(11) DEFAULT '0' NOT NULL,
151 tstamp int(11) DEFAULT '0' NOT NULL,
152 crdate int(11) DEFAULT '0' NOT NULL,
153 cruser_id int(11) DEFAULT '0' NOT NULL,
154 hidden tinyint(4) DEFAULT '0' NOT NULL,
155 starttime int(11) DEFAULT '0' NOT NULL,
156 title tinytext NOT NULL,
157 description text NOT NULL,
158 type int(11) DEFAULT '0' NOT NULL,
159 depth int(11) DEFAULT '0' NOT NULL,
160 table2index tinytext NOT NULL,
161 alternative_source_pid blob NOT NULL,
162 get_params tinytext NOT NULL,
163 fieldlist tinytext NOT NULL,
164 externalUrl tinytext NOT NULL,
165 chashcalc tinyint(3) DEFAULT '0' NOT NULL,
166 filepath tinytext NOT NULL,
167 extensions tinytext NOT NULL,
168
169 PRIMARY KEY (uid),
170 KEY parent (pid)
171 );
172
173 #
174 # Table structure for table 'index_stat_word'
175 #
176 CREATE TABLE index_stat_word (
177 uid int(11) DEFAULT '0' NOT NULL auto_increment,
178 word varchar(30) DEFAULT '' NOT NULL,
179 index_stat_search_id int(11) DEFAULT '0' NOT NULL,
180 tstamp int(11) DEFAULT '0' NOT NULL,
181 pageid int(11) DEFAULT '0' NOT NULL,
182 PRIMARY KEY (uid),
183 KEY tstamp (tstamp,word)
184 );