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