#
# Table structure for table 'tx_drbeckmannproducts_domain_model_product'
#
CREATE TABLE tx_drbeckmannproducts_domain_model_product
(
	title                               varchar(255)         DEFAULT ''  NOT NULL,
	navigation_title                    varchar(255)         DEFAULT ''  NOT NULL,
	seo_title                           varchar(255)         DEFAULT ''  NOT NULL,
	h1                                  varchar(255)         DEFAULT ''  NOT NULL,
	seo_description                     text,
	og_title                            varchar(255)         DEFAULT ''  NOT NULL,
	og_description                      text,
	og_image                            int(11) unsigned     DEFAULT '0' NOT NULL,
	teaser_title                        text,
	teaser_text                         text,
	product_image                       int(11) unsigned     DEFAULT '0' NOT NULL,
	no_index                            smallint(5) unsigned DEFAULT '0' NOT NULL,
	no_follow                           smallint(5) unsigned DEFAULT '0' NOT NULL,
	new                                 smallint(5) unsigned DEFAULT '0' NOT NULL,
	description_headline                text,
	size_text                           varchar(255)         DEFAULT ''  NOT NULL,
	size_icon                           varchar(20)          DEFAULT ''  NOT NULL,
	description_text                    text,
	gallery_images                      int(11) unsigned     DEFAULT '0' NOT NULL,
	gallery_video                       varchar(255)         DEFAULT ''  NOT NULL,
	categories                          varchar(255)         DEFAULT ''  NOT NULL,
	path_segment                        varchar(2048),
	effect_text                         text,
	use_case_suitable_text              text,
	use_case_unsuitable_text            text,
	additional_content_text             text,
	eco_contribution_headline           varchar(255)         DEFAULT ''  NOT NULL,
	eco_contribution_text               text,
	content_video                       int(11) unsigned     DEFAULT '0' NOT NULL,
	content_video_autoplay              smallint(5) unsigned DEFAULT '0' NOT NULL,
	faqs_headline                       tinytext,
	faqs                                tinytext,
	product_info_headline               tinytext,
	tips                                text,
	application_headline                tinytext,
	application_first_line              tinytext,
	step_groups                         int(11) unsigned     DEFAULT '0' NOT NULL,
	related_products_headline           tinytext,
	disclaimer_headline                 tinytext,
	disclaimer_description_1            tinytext,
	disclaimer_description_2            tinytext,
	disclaimer_description_3            tinytext,
	show_buy_button                     tinyint(1) unsigned  DEFAULT '0' NOT NULL,
	commerce_connector_ean              varchar(255)         DEFAULT ''  NOT NULL,
	commerce_connector_tracking_id      varchar(255)         DEFAULT ''  NOT NULL,
	stain_detective_enabled             smallint(5) unsigned DEFAULT '0' NOT NULL,
	stain_detective_filters_stain       tinytext,
	stain_detective_filters_fabric      tinytext,
	stain_detective_filters_washability tinytext,
	campaign_only                       smallint(5) unsigned DEFAULT '0' NOT NULL,
	tx_yoastseo_focuskeyword            varchar(100)         DEFAULT ''  NOT NULL,
	sku                                 varchar(10)          DEFAULT ''  NOT NULL,
	import_change_timestamp             int(11) unsigned     DEFAULT '0' NOT NULL
);

#
# Table structure for table 'tx_drbeckmannproducts_domain_model_productvideo'
#
CREATE TABLE tx_drbeckmannproducts_domain_model_productvideo
(
	title       varchar(255)         DEFAULT ''  NOT NULL,
	video_id    varchar(255)         DEFAULT ''  NOT NULL,
	portrait    smallint(5) unsigned DEFAULT '0' NOT NULL,
	video_cover int(11) unsigned                 NOT NULL DEFAULT '0'
);

#
# Extend table structure of table 'sys_category'
#
CREATE TABLE sys_category
(
	drbeckmann_products_lead_text             text,
	drbeckmann_products_image                 int(11) unsigned DEFAULT '0' NOT NULL,
	drbeckmann_products_image_campaign        int(11) unsigned DEFAULT '0' NOT NULL,
	drbeckmann_products_theme_color           varchar(255)     DEFAULT ''  NOT NULL,

	drbeckmann_products_external_id           varchar(255)     DEFAULT ''  NOT NULL,
	drbeckmann_products_path_segment          varchar(2048),
	drbeckmann_products_alternative_url_title varchar(2048),
	drbeckmann_products_distribution_category int UNSIGNED                 NOT NULL DEFAULT '0',
	drbeckmann_products_sorting_navigation    int UNSIGNED                 NOT NULL DEFAULT '0',
	drbeckmann_products_sorting_topcategory   int UNSIGNED                 NOT NULL DEFAULT '0',
	drbeckmann_products_sorting_subcategory   int UNSIGNED                 NOT NULL DEFAULT '0',
	drbeckmann_products_show_menu             smallint UNSIGNED            NOT NULL DEFAULT '0',

	drbeckmann_products_header_image          int(11) unsigned DEFAULT '0' NOT NULL,
	drbeckmann_products_subtitle              varchar(255)     DEFAULT ''  NOT NULL,
	drbeckmann_products_section_intro         text,
	drbeckmann_products_section_description   text,

	drbeckmann_products_teaser_title          varchar(255)     DEFAULT ''  NOT NULL,
	drbeckmann_products_teaser_subtitle       varchar(255)     DEFAULT ''  NOT NULL,
	drbeckmann_products_teaser_text           text,
	drbeckmann_products_teaser_image          int(11) unsigned DEFAULT '0' NOT NULL,
	drbeckmann_products_teaser_cta            varchar(255)     DEFAULT ''  NOT NULL,
	drbeckmann_products_content               int(11) unsigned DEFAULT '0' NOT NULL,

	drbeckmann_products_detail_image          int(11) unsigned DEFAULT '0' NOT NULL,
	drbeckmann_products_productlist_headline  varchar(255)     DEFAULT ''  NOT NULL,
	drbeckmann_products_productlist_intro     text,

	drbeckmann_products_seo_title             varchar(255)     DEFAULT ''  NOT NULL,
	drbeckmann_products_seo_description       text,
);

#
# Extend table structure of table 'tt_content'
#
CREATE TABLE tt_content
(
	drbeckmann_products_products             tinytext,
	drbeckmann_products_sys_category_content int(11) unsigned DEFAULT '0' NOT NULL,
	drbeckmann_product_category_selection    int(11) unsigned DEFAULT '0' NOT NULL
);

#
# Table structure for table 'tx_drbeckmannproducts_domain_model_staindetectivefilter'
#
CREATE TABLE tx_drbeckmannproducts_domain_model_staindetectivefilter
(
	filter_group tinytext,
	theme_color  tinytext,
	title        varchar(255)     DEFAULT ''  NOT NULL,
	image        int(11) unsigned DEFAULT '0' NOT NULL
);

#
# Table structure for table 'tx_drbeckmannproducts_domain_model_stepgroup'
#
CREATE TABLE tx_drbeckmannproducts_domain_model_stepgroup
(
	product int(11) unsigned DEFAULT '0' NOT NULL,
	title   varchar(255)     DEFAULT ''  NOT NULL,
	steps   int(11) unsigned DEFAULT '0' NOT NULL
);

#
# Table structure for table 'tx_drbeckmannproducts_domain_model_step'
#
CREATE TABLE tx_drbeckmannproducts_domain_model_step
(
	step_group int(11) unsigned DEFAULT '0' NOT NULL,
	text       text,
	image      int(11) unsigned DEFAULT '0' NOT NULL
);
