#
# Table structure for table 'tt_content'
#

CREATE TABLE tt_content (
    fe_users_records text,
	header_center tinyint(4) DEFAULT '0' NOT NULL,
	gray_bg tinyint(4) DEFAULT '0' NOT NULL,
	default_images tinyint(4) DEFAULT '0' NOT NULL,
	element_as_sitemap tinyint(4) DEFAULT '0' NOT NULL,
	shop_info tinyint(4) DEFAULT '0' NOT NULL,
	section_space tinyint(4) DEFAULT '0' NOT NULL,
	icon tinyint(4) DEFAULT '0' NOT NULL,
	tx_drk_template_icon varchar(255) DEFAULT '' NOT NULL,
	tx_drk_template_orientation varchar(255) DEFAULT '' NOT NULL,
	voicesearch TINYINT(1) DEFAULT '0' NOT NULL,

	# ensure to not loose data due to missing gridelements migration

	colPos smallint(6) DEFAULT '0' NOT NULL,
	layout varchar(255) DEFAULT '' NOT NULL,
	backupColPos smallint(6) DEFAULT '-2' NOT NULL,
	tx_gridelements_backend_layout varchar(255) DEFAULT '' NOT NULL,
	tx_gridelements_children int(11) DEFAULT '0' NOT NULL,
	tx_gridelements_container int(11) DEFAULT '0' NOT NULL,
	tx_gridelements_columns int(11) DEFAULT '0' NOT NULL,

	# addons from old plus_drk_base, names need refactoring, but we keep them for now

		subheader text,
		preheader varchar(255) DEFAULT '' NOT NULL,
		text_expander tinyint(4) DEFAULT '0' NOT NULL,
		tx_plus_drk_base_image_desc tinyint(1) unsigned DEFAULT '1' NOT NULL,
		tx_plus_drk_base_image_original_size tinyint(1) unsigned DEFAULT '0' NOT NULL,
		tx_plus_drk_base_image_portrait tinyint(1) unsigned DEFAULT '0' NOT NULL,
		tx_plus_drk_base_donate_page varchar(255) DEFAULT '' NOT NULL,
		tx_plus_drk_base_donate_purpose int(11) DEFAULT 0 NOT NULL,
		tx_plus_drk_base_donate_amount int(6) DEFAULT 0 NOT NULL,

	KEY gridelements (tx_gridelements_container,tx_gridelements_columns)

);

#
# Table structure for table 'pages'
#
CREATE TABLE pages (
	show_social_media_shares tinyint(4) DEFAULT '1' NOT NULL,
	show_print_pdf_buttons tinyint(4) DEFAULT '1' NOT NULL,
	show_readspeaker_buttons tinyint(4) DEFAULT '1' NOT NULL,
	menu_main_stop_process tinyint(4) DEFAULT '0' NOT NULL,
	frs_read_more_customize varchar(255) DEFAULT '' NOT NULL,
	epx_donation_link varchar(255) DEFAULT '' NOT NULL,
	epx_donation_active int(11) NOT NULL DEFAULT '0',
	language_inactive tinyint(4) DEFAULT '0' NOT NULL,
	plainlanguage_inactive tinyint(4) DEFAULT '0' NOT NULL,
	search_inactive tinyint(4) DEFAULT '0' NOT NULL,
	newsletter_inactive tinyint(4) DEFAULT '0' NOT NULL,
	main_menu int(11) NOT NULL DEFAULT '0',
	footer_menu int(11) NOT NULL DEFAULT '0',
	icon tinyint(4) DEFAULT '0' NOT NULL,

# addons from old plus_drk_base, names need refactoring, but we keep them for now

	tx_plus_drk_base_donate_page varchar(255) DEFAULT '' NOT NULL,
	tx_plus_drk_base_donate_purpose int(11) DEFAULT 0 NOT NULL,
	tx_plus_drk_base_donate_amount int(6) DEFAULT 0 NOT NULL,
	donation_inactive tinyint(4) DEFAULT '0' NOT NULL,
);

#
# Table structure for table 'fe_users'
#
CREATE TABLE fe_users (
	description text,
	teamlink_pid int(11) NOT NULL DEFAULT '0',
	teamlink_title varchar(255) DEFAULT '' NOT NULL,
	frs_user_image varchar(255) DEFAULT '' NOT NULL,
	twitter varchar(255) DEFAULT '' NOT NULL,
	user_title varchar(255) DEFAULT '' NOT NULL,
	mobil varchar(255) DEFAULT '' NOT NULL
);

#
# Table structure for table 'sys_file_reference'
#
CREATE TABLE sys_file_reference (
	frs_show_copyright tinyint(4) DEFAULT '0' NOT NULL
);

#
# Table structure for table 'tx_news_domain_model_news'
#
CREATE TABLE tx_news_domain_model_news (
	frs_press_number text,
  hide_press_lotto tinyint(4) DEFAULT '0' NOT NULL,
	frs_country text,
	frs_calltoaction int(11) unsigned DEFAULT '0' NOT NULL,
	is_event TINYINT(1) unsigned DEFAULT '0' NOT NULL,
	datetime_end INT(11) unsigned DEFAULT '0'
);

#
# Table structure for table 'be_groups'
#
# overwrite category_perms field due to size restriction of default varchar(255) field.
CREATE TABLE be_groups (
	category_perms text
);
