#
# Extend table structure of table 'tt_content'
#
CREATE TABLE tt_content
(
	drbeckmann_customcontentelements_stage_teaser_items        int(11) unsigned DEFAULT '0' NOT NULL,
	drbeckmann_customcontentelements_stage_hero_amazing_slides int(11) unsigned DEFAULT '0' NOT NULL,
	drbeckmann_customcontentelements_logo_reference_list_items int(11) unsigned DEFAULT '0' NOT NULL,
	drbeckmann_customcontentelements_date_teaser_items         int(11) unsigned DEFAULT '0' NOT NULL,
	drbeckmann_customcontentelements_advice_teaser_items       int(11) unsigned DEFAULT '0' NOT NULL,
	drbeckmann_customcontentelements_product_type_questions    int(11) unsigned DEFAULT '0' NOT NULL,
	drbeckmann_customcontentelements_product_type_results      int(11) unsigned DEFAULT '0' NOT NULL,
	drbeckmann_customcontentelements_questions                 int(11) unsigned DEFAULT '0' NOT NULL,
	drbeckmann_customcontentelements_product_teaser_items      int(11) unsigned DEFAULT '0' NOT NULL,
	drbeckmann_customcontentelements_controls                  smallint(5) unsigned DEFAULT '1' NOT NULL,
	drbeckmann_customcontentelements_autoplay                  smallint(5) unsigned DEFAULT '0' NOT NULL,
	drbeckmann_customcontentelements_portrait                  smallint(5) unsigned DEFAULT '0' NOT NULL,
	drbeckmann_customcontentelements_background                varchar(50)  DEFAULT ''    NOT NULL,
	drbeckmann_customcontentelements_background_shape          smallint(5) unsigned DEFAULT '0' NOT NULL,
	drbeckmann_customcontentelements_headline                  text,
	drbeckmann_customcontentelements_subheading                varchar(255) DEFAULT ''    NOT NULL,
	drbeckmann_customcontentelements_link_label                varchar(255) DEFAULT ''    NOT NULL,
	drbeckmann_customcontentelements_link_target               varchar(255) DEFAULT ''    NOT NULL,
	drbeckmann_customcontentelements_link_rel_attribute        varchar(255) DEFAULT ''    NOT NULL,
	drbeckmann_customcontentelements_ratio                     varchar(20)  DEFAULT '4-3' NOT NULL,
	drbeckmann_customcontentelements_position                  varchar(50)  DEFAULT ''    NOT NULL,
	drbeckmann_customcontentelements_sharing                   smallint(5) unsigned DEFAULT '0' NOT NULL,
	drbeckmann_customcontentelements_image_mobile              int(11) unsigned DEFAULT '0' NOT NULL,
	drbeckmann_customcontentelements_description               text,
	drbeckmann_customcontentelements_full_width                smallint(5) unsigned DEFAULT 0 NOT NULL,
	drbeckmann_customcontentelements_stain_type_fat_title      varchar(255) DEFAULT ''    NOT NULL,
	drbeckmann_customcontentelements_stain_type_fat_tooltip    varchar(255) DEFAULT ''    NOT NULL,
	drbeckmann_customcontentelements_stain_type_fruit_title    varchar(255) DEFAULT ''    NOT NULL,
	drbeckmann_customcontentelements_stain_type_fruit_tooltip  varchar(255) DEFAULT ''    NOT NULL,
	drbeckmann_customcontentelements_stain_type_blood_title    varchar(255) DEFAULT ''    NOT NULL,
	drbeckmann_customcontentelements_stain_type_blood_tooltip  varchar(255) DEFAULT ''    NOT NULL,
	drbeckmann_customcontentelements_stain_type_ink_title      varchar(255) DEFAULT ''    NOT NULL,
	drbeckmann_customcontentelements_stain_type_ink_tooltip    varchar(255) DEFAULT ''    NOT NULL,
	drbeckmann_customcontentelements_stain_type_deo_title      varchar(255) DEFAULT ''    NOT NULL,
	drbeckmann_customcontentelements_stain_type_deo_tooltip    varchar(255) DEFAULT ''    NOT NULL,
	drbeckmann_customcontentelements_stain_type_oil_title      varchar(255) DEFAULT ''    NOT NULL,
	drbeckmann_customcontentelements_stain_type_oil_tooltip    varchar(255) DEFAULT ''    NOT NULL,
	drbeckmann_customcontentelements_stain_type_nature_title   varchar(255) DEFAULT ''    NOT NULL,
	drbeckmann_customcontentelements_stain_type_nature_tooltip varchar(255) DEFAULT ''    NOT NULL,
	drbeckmann_customcontentelements_stain_type_office_title   varchar(255) DEFAULT ''    NOT NULL,
	drbeckmann_customcontentelements_stain_type_office_tooltip varchar(255) DEFAULT ''    NOT NULL,
	drbeckmann_customcontentelements_number                    int(11) unsigned DEFAULT '0' NOT NULL,
	drbeckmann_customcontentelements_video_id                  varchar(255) DEFAULT ''    NOT NULL,
	drbeckmann_customcontentelements_image_optional            int(11) unsigned DEFAULT '0' NOT NULL,
	drbeckmann_customcontentelements_link_label_optional       varchar(255) DEFAULT ''    NOT NULL,
	drbeckmann_customcontentelements_link_target_optional      varchar(255) DEFAULT ''    NOT NULL,
	drbeckmann_customcontentelements_quote_personal_name       varchar(255) DEFAULT ''    NOT NULL,
	drbeckmann_customcontentelements_quote_personal_position   varchar(255) DEFAULT ''    NOT NULL,
);

CREATE TABLE tx_drbeckmanncustomcontentelements_stage_teaser
(
	tt_content   int unsigned DEFAULT 0,
	image        int(11) unsigned DEFAULT '0' NOT NULL,
-- 	ToDo: Remove image_mobile after brand launch for all countries
	image_mobile int(11) unsigned DEFAULT '0' NOT NULL,
	logo         int(11) unsigned DEFAULT '0' NOT NULL,
	title        text,
	link_label   varchar(255) DEFAULT '' NOT NULL,
	link_target  varchar(255) DEFAULT '' NOT NULL
);

CREATE TABLE tx_drbeckmanncustomcontentelements_logo_reference_list
(
	tt_content  int unsigned DEFAULT 0,
	logo        int(11) unsigned DEFAULT '0' NOT NULL,
	title       text,
	link_label  varchar(255) DEFAULT '' NOT NULL,
	link_target varchar(255) DEFAULT '' NOT NULL,
);

CREATE TABLE tx_drbeckmanncustomcontentelements_stage_hero_amazing_slide
(
	tt_content               int unsigned DEFAULT 0,
	header                   varchar(255) DEFAULT '' NOT NULL,
	layout                   varchar(255) DEFAULT '' NOT NULL,
	packshot                 int(11) unsigned DEFAULT '0' NOT NULL,
	background_image_desktop int (11) unsigned DEFAULT '0' NOT NULL,
	background_image_mobile  int (11) unsigned DEFAULT '0' NOT NULL,
	background_color         varchar(255) DEFAULT '' NOT NULL,
	button_color         		 varchar(255) DEFAULT '' NOT NULL,
	claim                    varchar(255) DEFAULT '' NOT NULL,
	link_label               varchar(255) DEFAULT '' NOT NULL,
	link_target              varchar(255) DEFAULT '' NOT NULL,
	link_rel_attribute       varchar(255) DEFAULT '' NOT NULL
);

CREATE TABLE tx_drbeckmanncustomcontentelements_date_teaser
(
	tt_content int unsigned DEFAULT 0,
	image      int(11) unsigned DEFAULT '0' NOT NULL,
	title      varchar(255) DEFAULT '' NOT NULL,
	headline   varchar(255) DEFAULT '' NOT NULL,
	text       text
);

CREATE TABLE tx_drbeckmanncustomcontentelements_advice_teaser
(
	tt_content int unsigned DEFAULT 0,
	title      varchar(255) DEFAULT '' NOT NULL,
	text       text
);

CREATE TABLE tx_drbeckmanncustomcontentelements_product_type_quiz_question
(
	tt_content int unsigned DEFAULT 0,
	question   varchar(255) DEFAULT '' NOT NULL,
	answers    int(11) unsigned DEFAULT 0 NOT NULL
);

CREATE TABLE tx_drbeckmanncustomcontentelements_product_type_quiz_answer
(
	question int unsigned DEFAULT 0,
	image    int(11) unsigned DEFAULT 0 NOT NULL,
	title    varchar(255) DEFAULT '' NOT NULL
);

CREATE TABLE tx_drbeckmanncustomcontentelements_product_type_quiz_result
(
	tt_content  int unsigned DEFAULT 0,
	answers     tinytext,
	image       int(11) unsigned DEFAULT 0 NOT NULL,
	title       varchar(255) DEFAULT '' NOT NULL,
	text        text,
	link_label  varchar(255) DEFAULT '' NOT NULL,
	link_target varchar(255) DEFAULT '' NOT NULL
);

CREATE TABLE tx_drbeckmanncustomcontentelements_quiz_question
(
	tt_content int unsigned DEFAULT 0,
	media      int(11) unsigned DEFAULT 0 NOT NULL,
	question   varchar(255) DEFAULT '' NOT NULL,
	answers    int(11) unsigned DEFAULT 0 NOT NULL
);

CREATE TABLE tx_drbeckmanncustomcontentelements_quiz_answer
(
	question          int unsigned DEFAULT 0,
	text              varchar(255) DEFAULT '' NOT NULL,
	is_correct_answer smallint(5) unsigned DEFAULT '0' NOT NULL
);

CREATE TABLE tx_drbeckmanncustomcontentelements_product_page_teaser
(
	tt_content  int unsigned DEFAULT 0,
	title       varchar(255) DEFAULT '' NOT NULL,
	description text,
	product     int(11) unsigned DEFAULT 0 NOT NULL,
	badge_new   tinyint(4) unsigned DEFAULT '0' NOT NULL,
	theme_color varchar(255) DEFAULT '' NOT NULL,
	image       int(11) unsigned DEFAULT 0 NOT NULL,
);
