[BUGFIX] Indexed Search pibased plugin can load again translations
[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(255) 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 tinyint(3) 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,wid),
69 KEY metaphone (metaphone,wid)
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 phash_pid (phash,page_id),
86 KEY page_id (page_id),
87 KEY rl0 (rl0,rl1,phash),
88 KEY rl0_2 (rl0,phash)
89 ) ENGINE=InnoDB;
90
91 #
92 # Table structure for table 'index_grlist'
93 #
94 CREATE TABLE index_grlist (
95 phash int(11) DEFAULT '0' NOT NULL,
96 phash_x int(11) DEFAULT '0' NOT NULL,
97 hash_gr_list int(11) DEFAULT '0' NOT NULL,
98 gr_list varchar(255) DEFAULT '' NOT NULL,
99 uniqid int(11) NOT NULL auto_increment,
100 PRIMARY KEY (uniqid),
101 KEY joinkey (phash,hash_gr_list),
102 KEY phash_grouping (phash_x,hash_gr_list)
103 ) ENGINE=InnoDB;
104
105 #
106 # Table structure for table 'index_stat_search'
107 #
108 CREATE TABLE index_stat_search (
109 uid int(11) NOT NULL auto_increment,
110 searchstring varchar(255) DEFAULT '' NOT NULL,
111 searchoptions blob,
112 tstamp int(11) DEFAULT '0' NOT NULL,
113 feuser_id int(11) unsigned DEFAULT '0' NOT NULL,
114 cookie varchar(10) DEFAULT '' NOT NULL,
115 IP varchar(255) DEFAULT '' NOT NULL,
116 hits int(11) DEFAULT '0' NOT NULL,
117 PRIMARY KEY (uid)
118 ) ENGINE=InnoDB;
119
120 #
121 # Table structure for table 'index_debug'
122 #
123 CREATE TABLE index_debug (
124 phash int(11) DEFAULT '0' NOT NULL,
125 debuginfo mediumtext,
126 PRIMARY KEY (phash)
127 );
128
129 #
130 # Table structure for table 'index_config'
131 #
132 CREATE TABLE index_config (
133 uid int(11) NOT NULL auto_increment,
134 pid int(11) DEFAULT '0' NOT NULL,
135 tstamp int(11) DEFAULT '0' NOT NULL,
136 crdate int(11) DEFAULT '0' NOT NULL,
137 cruser_id int(11) DEFAULT '0' NOT NULL,
138 hidden tinyint(4) DEFAULT '0' NOT NULL,
139 starttime int(11) DEFAULT '0' NOT NULL,
140
141 set_id int(11) DEFAULT '0' NOT NULL,
142 session_data mediumtext,
143
144 title varchar(255) DEFAULT '' NOT NULL,
145 description text,
146 type varchar(30) DEFAULT '' NOT NULL,
147 depth int(11) unsigned DEFAULT '0' NOT NULL,
148 table2index varchar(255) DEFAULT '' NOT NULL,
149 alternative_source_pid int(11) unsigned DEFAULT '0' NOT NULL,
150 get_params varchar(255) DEFAULT '' NOT NULL,
151 fieldlist varchar(255) DEFAULT '' NOT NULL,
152 externalUrl varchar(255) DEFAULT '' NOT NULL,
153 indexcfgs text,
154 chashcalc tinyint(3) unsigned DEFAULT '0' NOT NULL,
155 filepath varchar(255) DEFAULT '' NOT NULL,
156 extensions varchar(255) DEFAULT '' NOT NULL,
157
158 timer_next_indexing int(11) DEFAULT '0' NOT NULL,
159 timer_frequency int(11) DEFAULT '0' NOT NULL,
160 timer_offset int(11) DEFAULT '0' NOT NULL,
161 url_deny text,
162 recordsbatch int(11) DEFAULT '0' NOT NULL,
163 records_indexonchange tinyint(4) DEFAULT '0' NOT NULL,
164
165 PRIMARY KEY (uid),
166 KEY parent (pid)
167 );
168
169
170 #
171 # Table structure for table 'index_stat_word'
172 #
173 CREATE TABLE index_stat_word (
174 uid int(11) NOT NULL auto_increment,
175 word varchar(30) DEFAULT '' NOT NULL,
176 index_stat_search_id int(11) DEFAULT '0' NOT NULL,
177 tstamp int(11) DEFAULT '0' NOT NULL,
178 pageid int(11) DEFAULT '0' NOT NULL,
179 PRIMARY KEY (uid),
180 KEY tstamp (tstamp,word)
181 ) ENGINE=InnoDB;