CREATE TABLE tx_nlmediacenter_domain_model_download (
	record_type varchar(255) NOT NULL DEFAULT '',
    record int(11) unsigned DEFAULT '0',
	teaser_text text NOT NULL DEFAULT '',
	link_text varchar(255) NOT NULL DEFAULT '',
	order_number varchar(255) NOT NULL DEFAULT '',
	e_paper_url varchar(1024) NOT NULL DEFAULT '',
	other_url varchar(1024) NOT NULL DEFAULT '',
	other_url_text varchar(255) NOT NULL DEFAULT '',
    oxomi_id varchar(255) NOT NULL DEFAULT '',
    sw_id varchar(255) NOT NULL DEFAULT '',
    sw_stock int(11) NOT NULL DEFAULT '0',
	media_type int(11) unsigned DEFAULT '0',
	topics int(11) unsigned NOT NULL DEFAULT '0',
	product_categories int(11) unsigned NOT NULL DEFAULT '0',
	programs int(11) unsigned NOT NULL DEFAULT '0',
	systems int(11) unsigned NOT NULL DEFAULT '0',
	target_groups int(11) unsigned NOT NULL DEFAULT '0'
);

CREATE TABLE tx_nlmediacenter_domain_model_mediatype (
	title varchar(255) NOT NULL DEFAULT '',
	slug varchar(255) NOT NULL DEFAULT '',
	download_section int(11) DEFAULT '0' NOT NULL,
	online_catalog_document_kind varchar(255) NOT NULL DEFAULT ''
);

CREATE TABLE tx_nlmediacenter_domain_model_targetgroup (
	title varchar(255) NOT NULL DEFAULT '',
	title_singular varchar(255) NOT NULL DEFAULT '',
	teaser_image int(11) unsigned NOT NULL DEFAULT '0',
	slug varchar(255) NOT NULL DEFAULT ''
);

CREATE TABLE tx_nlmediacenter_domain_model_externalfile (
    title varchar(255) NOT NULL DEFAULT '',
    url varchar(255) NOT NULL DEFAULT '',
    preview_image int(11) unsigned NOT NULL DEFAULT '0',
    mediacenter_download int(11) unsigned DEFAULT '0'
);

CREATE TABLE pages (
    mediacenter_download int(11) unsigned NOT NULL DEFAULT '0'
);

CREATE TABLE sys_file_metadata (
    mediacenter_download int(11) unsigned NOT NULL DEFAULT '0'
);

CREATE TABLE tx_news_domain_model_news (
	mediacenter_download int(11) unsigned NOT NULL DEFAULT '0'
);