forked from kitodo/kitodo-presentation
-
Notifications
You must be signed in to change notification settings - Fork 1
/
ext_tables.sql
377 lines (348 loc) · 12.6 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
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
--
-- Table structure for table 'tx_dlf_documents'
--
CREATE TABLE tx_dlf_documents (
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 smallint(6) DEFAULT '0' NOT NULL,
hidden smallint(6) DEFAULT '0' NOT NULL,
starttime int(11) DEFAULT '0' NOT NULL,
endtime int(11) DEFAULT '0' NOT NULL,
fe_group varchar(100) DEFAULT '' NOT NULL,
prod_id varchar(255) DEFAULT '' NOT NULL,
location varchar(255) DEFAULT '' NOT NULL,
record_id varchar(255) DEFAULT '' NOT NULL,
opac_id varchar(255) DEFAULT '' NOT NULL,
union_id varchar(255) DEFAULT '' NOT NULL,
urn varchar(255) DEFAULT '' NOT NULL,
purl varchar(255) DEFAULT '' NOT NULL,
title text NOT NULL,
title_sorting text NOT NULL,
author varchar(255) DEFAULT '' NOT NULL,
year varchar(255) DEFAULT '' NOT NULL,
place varchar(255) DEFAULT '' NOT NULL,
thumbnail varchar(255) DEFAULT '' NOT NULL,
structure int(11) DEFAULT '0' NOT NULL,
partof int(11) DEFAULT '0' NOT NULL,
volume varchar(255) DEFAULT '' NOT NULL,
volume_sorting varchar(255) DEFAULT '' NOT NULL,
license varchar(255) DEFAULT '' NOT NULL,
terms varchar(255) DEFAULT '' NOT NULL,
restrictions varchar(255) DEFAULT '' NOT NULL,
out_of_print text NOT NULL,
rights_info text NOT NULL,
collections int(11) DEFAULT '0' NOT NULL,
mets_label text NOT NULL,
mets_orderlabel text NOT NULL,
owner int(11) DEFAULT '0' NOT NULL,
solrcore int(11) DEFAULT '0' NOT NULL,
status smallint(6) unsigned DEFAULT '0' NOT NULL,
document_format varchar(100) DEFAULT '' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid),
KEY location (location),
KEY record_id (record_id),
KEY partof (partof)
);
--
-- Table structure for table 'tx_dlf_structures'
--
CREATE TABLE tx_dlf_structures (
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 smallint(6) DEFAULT '0' NOT NULL,
sys_language_uid int(11) DEFAULT '0' NOT NULL,
l18n_parent int(11) DEFAULT '0' NOT NULL,
l18n_diffsource mediumblob NOT NULL,
l10n_state text COLLATE utf8_unicode_ci DEFAULT NULL,
hidden smallint(6) DEFAULT '0' NOT NULL,
toplevel smallint(6) DEFAULT '0' NOT NULL,
label varchar(255) DEFAULT '' NOT NULL,
index_name varchar(255) DEFAULT '' NOT NULL,
oai_name varchar(255) DEFAULT '' NOT NULL,
thumbnail int(11) DEFAULT '0' NOT NULL,
status smallint(6) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid),
KEY language (l18n_parent,sys_language_uid),
KEY index_name (index_name)
);
--
-- Table structure for table 'tx_dlf_metadata'
--
CREATE TABLE tx_dlf_metadata (
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 smallint(6) DEFAULT '0' NOT NULL,
sys_language_uid int(11) DEFAULT '0' NOT NULL,
l18n_parent int(11) DEFAULT '0' NOT NULL,
l18n_diffsource mediumblob NOT NULL,
l10n_state text COLLATE utf8_unicode_ci DEFAULT NULL,
hidden smallint(6) DEFAULT '0' NOT NULL,
sorting int(11) DEFAULT '0' NOT NULL,
label varchar(255) DEFAULT '' NOT NULL,
index_name varchar(255) DEFAULT '' NOT NULL,
format int(11) DEFAULT '0' NOT NULL,
default_value varchar(255) DEFAULT '' NOT NULL,
wrap text NOT NULL,
index_tokenized smallint(6) DEFAULT '0' NOT NULL,
index_stored smallint(6) DEFAULT '0' NOT NULL,
index_indexed smallint(6) DEFAULT '0' NOT NULL,
index_boost float(4,2) DEFAULT '1.00' NOT NULL,
is_sortable smallint(6) DEFAULT '0' NOT NULL,
is_facet smallint(6) DEFAULT '0' NOT NULL,
is_listed smallint(6) DEFAULT '0' NOT NULL,
index_autocomplete smallint(6) DEFAULT '0' NOT NULL,
status smallint(6) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid),
KEY language (l18n_parent,sys_language_uid),
KEY index_name (index_name),
KEY index_autocomplete (index_autocomplete),
KEY is_sortable (is_sortable),
KEY is_facet (is_facet),
KEY is_listed (is_listed)
);
--
-- Table structure for table 'tx_dlf_metadataformat'
--
CREATE TABLE tx_dlf_metadataformat (
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 smallint(6) DEFAULT '0' NOT NULL,
l10n_state text COLLATE utf8_unicode_ci DEFAULT NULL,
parent_id int(11) DEFAULT '0' NOT NULL,
encoded int(11) DEFAULT '0' NOT NULL,
xpath varchar(1024) DEFAULT '' NOT NULL,
xpath_sorting varchar(1024) DEFAULT '' NOT NULL,
subentries int(11) DEFAULT '0' NOT NULL,
mandatory smallint(6) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid),
KEY parent_id (parent_id)
);
--
-- Table structure for table 'tx_dlf_metadatasubentries'
--
CREATE TABLE tx_dlf_metadatasubentries (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
parent_id 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 smallint(6) DEFAULT '0' NOT NULL,
sys_language_uid int(11) DEFAULT '0' NOT NULL,
l18n_parent int(11) DEFAULT '0' NOT NULL,
l18n_diffsource mediumblob NOT NULL,
label varchar(255) DEFAULT '' NOT NULL,
index_name varchar(255) DEFAULT '' NOT NULL,
xpath varchar(1024) DEFAULT '' NOT NULL,
default_value varchar(255) DEFAULT '' NOT NULL,
wrap text NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid),
KEY parent_id (parent_id),
KEY language (l18n_parent,sys_language_uid),
KEY index_name (index_name)
);
--
-- Table structure for table 'tx_dlf_formats'
--
CREATE TABLE tx_dlf_formats (
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 smallint(6) DEFAULT '0' NOT NULL,
type varchar(255) DEFAULT '' NOT NULL,
root varchar(255) DEFAULT '' NOT NULL,
namespace varchar(255) DEFAULT '' NOT NULL,
class varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
--
-- Table structure for table 'tx_dlf_solrcores'
--
CREATE TABLE tx_dlf_solrcores (
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 smallint(6) DEFAULT '0' NOT NULL,
label varchar(255) DEFAULT '' NOT NULL,
index_name varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid),
KEY index_name (index_name)
);
--
-- Table structure for table 'tx_dlf_collections'
--
CREATE TABLE tx_dlf_collections (
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,
fe_cruser_id int(11) DEFAULT '0' NOT NULL,
fe_admin_lock smallint(6) DEFAULT '0' NOT NULL,
deleted smallint(6) DEFAULT '0' NOT NULL,
sys_language_uid int(11) DEFAULT '0' NOT NULL,
l18n_parent int(11) DEFAULT '0' NOT NULL,
l18n_diffsource mediumblob NOT NULL,
l10n_state text COLLATE utf8_unicode_ci DEFAULT NULL,
hidden smallint(6) DEFAULT '0' NOT NULL,
fe_group varchar(100) DEFAULT '' NOT NULL,
label varchar(255) DEFAULT '' NOT NULL,
index_name varchar(255) DEFAULT '' NOT NULL,
index_search text NOT NULL,
oai_name varchar(255) DEFAULT '' NOT NULL,
description text NOT NULL,
thumbnail varchar(255) DEFAULT '' NOT NULL,
priority smallint(6) DEFAULT '3' NOT NULL,
documents int(11) DEFAULT '0' NOT NULL,
owner int(11) DEFAULT '0' NOT NULL,
status smallint(6) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid),
KEY language (l18n_parent,sys_language_uid),
KEY index_name (index_name),
KEY oai_name (oai_name),
KEY pid_cruser (pid,fe_cruser_id)
);
--
-- Table structure for table 'tx_dlf_libraries'
--
CREATE TABLE tx_dlf_libraries (
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 smallint(6) DEFAULT '0' NOT NULL,
sys_language_uid int(11) DEFAULT '0' NOT NULL,
l18n_parent int(11) DEFAULT '0' NOT NULL,
l18n_diffsource mediumblob NOT NULL,
l10n_state text COLLATE utf8_unicode_ci DEFAULT NULL,
label varchar(255) DEFAULT '' NOT NULL,
index_name varchar(255) DEFAULT '' NOT NULL,
website varchar(255) DEFAULT '' NOT NULL,
contact varchar(255) DEFAULT '' NOT NULL,
image varchar(255) DEFAULT '' NOT NULL,
oai_label varchar(255) DEFAULT '' NOT NULL,
oai_base varchar(255) DEFAULT '' NOT NULL,
opac_label varchar(255) DEFAULT '' NOT NULL,
opac_base varchar(255) DEFAULT '' NOT NULL,
union_label varchar(255) DEFAULT '' NOT NULL,
union_base varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid),
KEY language (l18n_parent,sys_language_uid),
KEY index_name (index_name)
);
--
-- Table structure for table 'tx_dlf_tokens'
--
CREATE TABLE tx_dlf_tokens (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
tstamp int(11) DEFAULT '0' NOT NULL COMMENT 'Timestamp of the token used to determine if it has expired.',
token varchar(255) DEFAULT '' NOT NULL,
options mediumtext NOT NULL,
ident varchar(30) DEFAULT '' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid),
KEY token (token)
);
--
-- Table structure for table 'tx_dlf_relations'
--
CREATE TABLE tx_dlf_relations (
uid int(11) NOT NULL auto_increment,
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,
ident varchar(30) DEFAULT '' NOT NULL COMMENT 'An identifier to describe which tables are matched.',
PRIMARY KEY (uid),
KEY local_foreign (uid_local,uid_foreign,ident)
) COMMENT 'Pivot table for many-to-many relations between tables. In particular, this is used to match documents and collections by using ident=docs_colls.';
--
-- Table structure for table 'tx_dlf_basket'
--
CREATE TABLE tx_dlf_basket (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
tstamp int(11) DEFAULT '0' NOT NULL,
fe_user_id int(11) DEFAULT '0' NOT NULL,
deleted smallint(6) DEFAULT '0' NOT NULL,
sys_language_uid int(11) DEFAULT '0' NOT NULL,
l18n_parent int(11) DEFAULT '0' NOT NULL,
l18n_diffsource mediumblob NOT NULL,
l10n_state text COLLATE utf8_unicode_ci DEFAULT NULL,
label varchar(255) DEFAULT '' NOT NULL,
session_id varchar(32) DEFAULT '' NOT NULL,
doc_ids varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid),
KEY language (l18n_parent,sys_language_uid)
);
--
-- Table structure for table 'tx_dlf_printer'
--
CREATE TABLE tx_dlf_printer (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
deleted smallint(6) DEFAULT '0' NOT NULL,
print varchar(255) DEFAULT '' NOT NULL,
label varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
--
-- Table structure for table 'tx_dlf_mail'
--
CREATE TABLE tx_dlf_mail (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
deleted smallint(6) DEFAULT '0' NOT NULL,
sorting int(11) DEFAULT '0' NOT NULL,
mail varchar(255) DEFAULT '' NOT NULL,
name varchar(255) DEFAULT '' NOT NULL,
label varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
--
-- Table structure for table 'tx_dlf_actionlog'
--
CREATE TABLE tx_dlf_actionlog (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
crdate int(11) DEFAULT '0' NOT NULL,
deleted smallint(6) DEFAULT '0' NOT NULL,
user_id int(11) DEFAULT '0' NOT NULL,
file_name varchar(255) DEFAULT '' NOT NULL,
count_pages int(11) DEFAULT '0' NOT NULL,
name varchar(100) DEFAULT '' NOT NULL,
label varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);