353 linhas
12 KiB
SQL
353 linhas
12 KiB
SQL
--
|
|
-- 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,
|
|
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,
|
|
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,
|
|
mandatory smallint(6) DEFAULT '0' NOT NULL,
|
|
|
|
PRIMARY KEY (uid),
|
|
KEY parent (pid),
|
|
KEY parent_id (parent_id)
|
|
);
|
|
|
|
--
|
|
-- 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)
|
|
);
|