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