mirror of
https://github.com/werkraum-media/events.git
synced 2024-05-09 01:37:38 +02:00
Daniel Siepmann
713bc4b697
A new class is added which will add meta tags for dates and events. The class has an interface which allows it to be replaced via DI to alter behaviour. Refactor import regarding data handler. We now also need to add a new column "keywords". We use the new DataHandler approach. But that approach only covered relations so far. We therefore refactor that area to be more generic and use that one for new keywords column. Relates: #10642
104 lines
3.4 KiB
SQL
104 lines
3.4 KiB
SQL
CREATE TABLE tx_events_domain_model_event (
|
|
title varchar(255) DEFAULT '' NOT NULL,
|
|
subtitle text,
|
|
global_id varchar(255) DEFAULT '' NOT NULL,
|
|
slug varchar(255) DEFAULT '' NOT NULL,
|
|
highlight smallint(5) unsigned DEFAULT '0' NOT NULL,
|
|
teaser text,
|
|
details text,
|
|
price_info text,
|
|
web varchar(255) DEFAULT '' NOT NULL,
|
|
ticket text,
|
|
facebook varchar(255) DEFAULT '' NOT NULL,
|
|
youtube varchar(255) DEFAULT '' NOT NULL,
|
|
instagram varchar(255) DEFAULT '' NOT NULL,
|
|
images int(11) unsigned NOT NULL default '0',
|
|
categories int(11) DEFAULT '0' NOT NULL,
|
|
features int(11) DEFAULT '0' NOT NULL,
|
|
keywords text,
|
|
pages text,
|
|
dates int(11) unsigned DEFAULT '0' NOT NULL,
|
|
organizer int(11) unsigned DEFAULT '0',
|
|
location int(11) unsigned DEFAULT '0',
|
|
partner text,
|
|
region int(11) unsigned DEFAULT '0',
|
|
references_events text,
|
|
source_name varchar(255) DEFAULT '' NOT NULL,
|
|
source_url varchar(255) DEFAULT '' NOT NULL,
|
|
KEY dataHandler (l10n_parent, t3ver_oid, deleted, t3ver_wsid, t3ver_state)
|
|
);
|
|
|
|
CREATE TABLE tx_events_domain_model_organizer (
|
|
name varchar(255) DEFAULT '' NOT NULL,
|
|
street varchar(255) DEFAULT '' NOT NULL,
|
|
district varchar(255) DEFAULT '' NOT NULL,
|
|
city varchar(255) DEFAULT '' NOT NULL,
|
|
zip varchar(255) DEFAULT '' NOT NULL,
|
|
phone varchar(255) DEFAULT '' NOT NULL,
|
|
web varchar(255) DEFAULT '' NOT NULL,
|
|
email varchar(255) DEFAULT '' NOT NULL,
|
|
|
|
KEY dataHandler (l10n_parent, sys_language_uid, deleted)
|
|
);
|
|
|
|
CREATE TABLE tx_events_domain_model_partner (
|
|
title varchar(255) DEFAULT '' NOT NULL,
|
|
link varchar(255) DEFAULT '' NOT NULL,
|
|
images int(11) unsigned NOT NULL default '0',
|
|
|
|
KEY dataHandler (l10n_parent, sys_language_uid, deleted)
|
|
);
|
|
|
|
CREATE TABLE tx_events_domain_model_date (
|
|
event int(11) unsigned DEFAULT '0' NOT NULL,
|
|
start int(11) DEFAULT NULL,
|
|
end int(11) DEFAULT NULL,
|
|
canceled varchar(255) DEFAULT 'no' NOT NULL,
|
|
slug varchar(255) DEFAULT '' NOT NULL,
|
|
KEY event (event),
|
|
KEY dataHandler (event, t3ver_wsid, pid)
|
|
);
|
|
|
|
CREATE TABLE tx_events_domain_model_region (
|
|
title varchar(255) DEFAULT '' NOT NULL,
|
|
);
|
|
|
|
CREATE TABLE tx_events_domain_model_date (
|
|
event int(11) unsigned DEFAULT '0' NOT NULL,
|
|
postponed_date int(11) unsigned DEFAULT '0' NOT NULL,
|
|
canceled_link varchar(1024) DEFAULT '' NOT NULL,
|
|
);
|
|
|
|
CREATE TABLE tx_events_domain_model_import (
|
|
title varchar(1024) DEFAULT '' NOT NULL,
|
|
|
|
storage_pid int(11) unsigned DEFAULT '0' NOT NULL,
|
|
files_folder varchar(1024) DEFAULT '' NOT NULL,
|
|
|
|
categories_pid int(11) unsigned,
|
|
category_parent int(11) unsigned,
|
|
|
|
features_pid int(11) unsigned,
|
|
features_parent int(11) unsigned,
|
|
|
|
region int(11) unsigned DEFAULT '0' NOT NULL,
|
|
|
|
rest_experience varchar(1024) DEFAULT '' NOT NULL,
|
|
rest_search_query varchar(1024) DEFAULT '' NOT NULL,
|
|
);
|
|
|
|
CREATE TABLE tx_events_domain_model_location (
|
|
global_id varchar(255) DEFAULT '' NOT NULL,
|
|
name varchar(255) DEFAULT '' NOT NULL,
|
|
street varchar(255) DEFAULT '' NOT NULL,
|
|
city varchar(255) DEFAULT '' NOT NULL,
|
|
zip varchar(255) DEFAULT '' NOT NULL,
|
|
district varchar(255) DEFAULT '' NOT NULL,
|
|
country varchar(255) DEFAULT '' NOT NULL,
|
|
phone varchar(255) DEFAULT '' NOT NULL,
|
|
latitude varchar(255) DEFAULT '' NOT NULL,
|
|
longitude varchar(255) DEFAULT '' NOT NULL,
|
|
|
|
KEY global_id (global_id)
|
|
);
|