-
Notifications
You must be signed in to change notification settings - Fork 21
/
Copy pathext_tables.sql
144 lines (133 loc) · 4.32 KB
/
ext_tables.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
#
# Table structure for table 'tx_mksearch_indices'
#
CREATE TABLE tx_mksearch_indices (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
tstamp int(11) DEFAULT '0' NOT NULL,
crdate int(11) DEFAULT '0' NOT NULL,
cruser_id int(11) DEFAULT '0' NOT NULL,
sys_language_uid int(11) DEFAULT '0' NOT NULL,
l10n_parent int(11) DEFAULT '0' NOT NULL,
l10n_diffsource mediumtext,
deleted tinyint(4) DEFAULT '0' NOT NULL,
hidden tinyint(4) DEFAULT '0' NOT NULL,
title varchar(100) DEFAULT '' NOT NULL,
description text,
name varchar(255) DEFAULT '0' NOT NULL,
engine varchar(50) DEFAULT '0' NOT NULL,
solrversion int(11) DEFAULT '0' NOT NULL,
composites int(11) DEFAULT '0' NOT NULL,
configuration text,
PRIMARY KEY (uid),
KEY parent (pid)
);
#
# Table structure for table 'tx_mksearch_configcomposites'
#
CREATE TABLE tx_mksearch_configcomposites (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
tstamp int(11) DEFAULT '0' NOT NULL,
crdate int(11) DEFAULT '0' NOT NULL,
cruser_id int(11) DEFAULT '0' NOT NULL,
sys_language_uid int(11) DEFAULT '0' NOT NULL,
l10n_parent int(11) DEFAULT '0' NOT NULL,
l10n_diffsource mediumtext,
deleted tinyint(4) DEFAULT '0' NOT NULL,
hidden tinyint(4) DEFAULT '0' NOT NULL,
title varchar(100) DEFAULT '' NOT NULL,
description text,
configuration text,
indices int(11) DEFAULT '0' NOT NULL,
configs int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
#
# Table structure for table 'tx_mksearch_indices_configcomposites_mm'
#
#
CREATE TABLE tx_mksearch_indices_configcomposites_mm (
uid_local int(11) DEFAULT '0' NOT NULL,
uid_foreign int(11) DEFAULT '0' NOT NULL,
tablenames varchar(30) DEFAULT '' NOT NULL,
sorting int(11) DEFAULT '0' NOT NULL,
sorting_foreign int(11) DEFAULT '0' NOT NULL,
KEY uid_local (uid_local),
KEY uid_foreign (uid_foreign)
);
#
# Table structure for table 'tx_mksearch_indexerconfigs'
#
CREATE TABLE tx_mksearch_indexerconfigs (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
tstamp int(11) DEFAULT '0' NOT NULL,
crdate int(11) DEFAULT '0' NOT NULL,
cruser_id int(11) DEFAULT '0' NOT NULL,
sys_language_uid int(11) DEFAULT '0' NOT NULL,
l10n_parent int(11) DEFAULT '0' NOT NULL,
l10n_diffsource mediumtext,
deleted tinyint(4) DEFAULT '0' NOT NULL,
hidden tinyint(4) DEFAULT '0' NOT NULL,
title varchar(100) DEFAULT '' NOT NULL,
description text,
extkey varchar(50) DEFAULT '' NOT NULL,
contenttype varchar(50) DEFAULT '' NOT NULL,
configuration text,
composites int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
#
# Table structure for table 'tx_mksearch_configcomposites_indexerconfigs_mm'
#
#
CREATE TABLE tx_mksearch_configcomposites_indexerconfigs_mm (
uid_local int(11) DEFAULT '0' NOT NULL,
uid_foreign int(11) DEFAULT '0' NOT NULL,
tablenames varchar(30) DEFAULT '' NOT NULL,
sorting int(11) DEFAULT '0' NOT NULL,
sorting_foreign int(11) DEFAULT '0' NOT NULL,
KEY uid_local (uid_local),
KEY uid_foreign (uid_foreign)
);
--
-- Tabellenstruktur für Tabelle `tx_mksearch_queue`
--
CREATE TABLE tx_mksearch_queue (
uid int(11) NOT NULL auto_increment,
cr_date datetime default '1970-01-01 00:00:01',
lastupdate datetime default '1970-01-01 00:00:01',
deleted tinyint(4) DEFAULT '0' NOT NULL,
prefer tinyint(4) DEFAULT '0' NOT NULL,
recid int(11) DEFAULT '0' NOT NULL,
tablename varchar(255) DEFAULT '' NOT NULL,
data text,
resolver varchar(255) NOT NULL default '',
being_indexed tinyint(4) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid)
);
#
# Table structure for table 'tx_mksearch_keywords'
#
CREATE TABLE tx_mksearch_keywords (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
tstamp int(11) DEFAULT '0' NOT NULL,
crdate int(11) DEFAULT '0' NOT NULL,
cruser_id int(11) DEFAULT '0' NOT NULL,
deleted tinyint(4) DEFAULT '0' NOT NULL,
hidden tinyint(4) DEFAULT '0' NOT NULL,
keyword tinytext NOT NULL,
link tinytext NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
#
# Table structure for table 'tt_content'
#
CREATE TABLE tt_content (
tx_mksearch_is_indexable tinyint(1) DEFAULT '0' NOT NULL
);