*** empty log message ***
[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 # Table structure for table 'index_fulltext'
9 #
10 CREATE TABLE index_fulltext (
11 phash int(11) DEFAULT '0' NOT NULL,
12 fulltextdata mediumtext NOT NULL,
13 PRIMARY KEY (phash)
14 );
15
16
17 #
18 # Table structure for table 'index_grlist'
19 #
20 CREATE TABLE index_grlist (
21 phash int(11) DEFAULT '0' NOT NULL,
22 phash_x int(11) DEFAULT '0' NOT NULL,
23 hash_gr_list int(11) DEFAULT '0' NOT NULL,
24 gr_list tinytext NOT NULL,
25 uniqid int(11) DEFAULT '0' NOT NULL auto_increment,
26 PRIMARY KEY (uniqid),
27 KEY joinkey (phash,hash_gr_list),
28 KEY phash_grouping (phash_x,hash_gr_list)
29 );
30
31
32 #
33 # Table structure for table 'index_phash'
34 #
35 CREATE TABLE index_phash (
36 phash int(11) DEFAULT '0' NOT NULL,
37 phash_grouping int(11) DEFAULT '0' NOT NULL,
38 cHashParams tinyblob NOT NULL,
39 data_filename tinytext NOT NULL,
40 data_page_id int(11) unsigned DEFAULT '0' NOT NULL,
41 data_page_reg1 int(11) unsigned DEFAULT '0' NOT NULL,
42 data_page_type tinyint(3) unsigned DEFAULT '0' NOT NULL,
43 data_page_mp tinytext NOT NULL,
44 gr_list tinytext NOT NULL,
45 item_type tinyint(4) DEFAULT '0' NOT NULL,
46 item_title tinytext NOT NULL,
47 item_description tinytext NOT NULL,
48 item_mtime int(11) DEFAULT '0' NOT NULL,
49 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
50 item_size int(11) DEFAULT '0' NOT NULL,
51 contentHash int(11) DEFAULT '0' NOT NULL,
52 crdate int(11) DEFAULT '0' NOT NULL,
53 parsetime int(11) DEFAULT '0' NOT NULL,
54 sys_language_uid int(11) DEFAULT '0' NOT NULL,
55 item_crdate int(11) DEFAULT '0' NOT NULL,
56 PRIMARY KEY (phash),
57 KEY phash_grouping (phash_grouping)
58 );
59
60
61 #
62 # Table structure for table 'index_rel'
63 #
64 CREATE TABLE index_rel (
65 phash int(11) DEFAULT '0' NOT NULL,
66 wid int(11) DEFAULT '0' NOT NULL,
67 count tinyint(3) unsigned DEFAULT '0' NOT NULL,
68 first tinyint(3) unsigned DEFAULT '0' NOT NULL,
69 freq smallint(5) unsigned DEFAULT '0' NOT NULL,
70 flags tinyint(3) unsigned DEFAULT '0' NOT NULL,
71 PRIMARY KEY (phash,wid),
72 KEY wid (wid,phash)
73 );
74
75
76 #
77 # Table structure for table 'index_section'
78 #
79 CREATE TABLE index_section (
80 phash int(11) DEFAULT '0' NOT NULL,
81 phash_t3 int(11) DEFAULT '0' NOT NULL,
82 rl0 int(11) unsigned DEFAULT '0' NOT NULL,
83 rl1 int(11) unsigned DEFAULT '0' NOT NULL,
84 rl2 int(11) unsigned DEFAULT '0' NOT NULL,
85 page_id int(11) DEFAULT '0' NOT NULL,
86 uniqid int(11) DEFAULT '0' NOT NULL auto_increment,
87 PRIMARY KEY (uniqid),
88 KEY joinkey (phash,rl0),
89 KEY page_id (page_id),
90 KEY rl0 (rl0,rl1,phash),
91 KEY rl0_2 (rl0,phash)
92 );
93
94
95 #
96 # Table structure for table 'index_stat_search'
97 #
98 CREATE TABLE index_stat_search (
99 uid int(11) DEFAULT '0' NOT NULL auto_increment,
100 searchstring tinytext NOT NULL,
101 searchoptions blob NOT NULL,
102 tstamp int(11) DEFAULT '0' NOT NULL,
103 feuser_id int(11) unsigned DEFAULT '0' NOT NULL,
104 cookie varchar(10) DEFAULT '' NOT NULL,
105 IP tinytext NOT NULL,
106 hits int(11) DEFAULT '0' NOT NULL,
107 PRIMARY KEY (uid)
108 );
109
110
111 #
112 # Table structure for table 'index_stat_word'
113 #
114 CREATE TABLE index_stat_word (
115 uid int(11) DEFAULT '0' NOT NULL auto_increment,
116 word varchar(30) DEFAULT '' NOT NULL,
117 index_stat_search_id int(11) DEFAULT '0' NOT NULL,
118 tstamp int(11) DEFAULT '0' NOT NULL,
119 PRIMARY KEY (uid),
120 KEY tstamp (tstamp,word)
121 );
122
123
124 #
125 # Table structure for table 'index_words'
126 #
127 CREATE TABLE index_words (
128 wid int(11) DEFAULT '0' NOT NULL,
129 baseword varchar(30) DEFAULT '' NOT NULL,
130 metaphone int(11) DEFAULT '0' NOT NULL,
131 PRIMARY KEY (wid),
132 KEY baseword (baseword,wid),
133 KEY metaphone (metaphone,wid)
134 );