ext_tables.sql

CREATE TABLE pages (
	tx_styleguide_containsdemo varchar(255) DEFAULT '' NOT NULL
);

CREATE TABLE sys_language (
	tx_styleguide_isdemorecord tinyint(1) unsigned DEFAULT '0' NOT NULL
);

CREATE TABLE be_groups (
	tx_styleguide_isdemorecord tinyint(1) unsigned DEFAULT '0' NOT NULL
);

CREATE TABLE be_users (
	tx_styleguide_isdemorecord tinyint(1) unsigned DEFAULT '0' NOT NULL
);

CREATE TABLE tx_styleguide_elements_basic (
	input_1 text,
	input_2 text,
	input_3 text,
	input_4 text,
	input_5 text,
	input_8 text,
	input_9 text,
	input_10 text,
	input_11 text,
	input_12 text,
	input_13 text,
	input_14 text,
	input_15 text,
	input_16 text,
	input_19 text,
	input_20 text,
	input_21 text,
	input_22 text,
	input_23 text,
	input_24 text,
	input_25 text,
	input_26 text,
	input_27 text,
	input_28 text,
	input_29 text,
	input_30 text,
	input_31 text,
	input_32 text,
	input_33 text,
	input_34 text,
	input_35 text,
	input_36 text,
	input_37 text,
	input_38 text,
	input_39 text,
	input_40 text,
	input_41 text,
	input_42 text,

	inputdatetime_1 text,
	inputdatetime_2 date,
	inputdatetime_3 text,
	inputdatetime_4 datetime,
	inputdatetime_5 text,
	inputdatetime_6 text,
	inputdatetime_7 text,
	inputdatetime_8 text,
	inputdatetime_9 text,
	inputdatetime_10 text,

	text_1 text,
	text_2 text,
	text_3 text,
	text_4 text,
	text_5 text,
	text_6 text,
	text_7 text,
	text_8 text,
	text_9 text,
	text_10 text,
	text_11 text,
	text_12 text,
	text_13 text,
	text_14 text,
	text_15 text,
	text_16 text,
	text_17 text,
	text_18 text,
	text_19 text,

	checkbox_1 int(11) DEFAULT '0' NOT NULL,
	checkbox_2 int(11) DEFAULT '0' NOT NULL,
	checkbox_3 int(11) DEFAULT '0' NOT NULL,
	checkbox_4 int(11) DEFAULT '0' NOT NULL,
	checkbox_6 int(11) DEFAULT '0' NOT NULL,
	checkbox_7 int(11) DEFAULT '0' NOT NULL,
	checkbox_8 int(11) DEFAULT '0' NOT NULL,
	checkbox_9 int(11) DEFAULT '0' NOT NULL,
	checkbox_10 int(11) DEFAULT '0' NOT NULL,
	checkbox_11 int(11) DEFAULT '0' NOT NULL,
	checkbox_12 int(11) DEFAULT '0' NOT NULL,
	checkbox_13 int(11) DEFAULT '0' NOT NULL,
	checkbox_14 int(11) DEFAULT '0' NOT NULL,
	checkbox_15 int(11) DEFAULT '0' NOT NULL,
	checkbox_16 int(11) DEFAULT '0' NOT NULL,
	checkbox_17 int(11) DEFAULT '0' NOT NULL,
	checkbox_18 int(11) DEFAULT '0' NOT NULL,
	checkbox_19 int(11) DEFAULT '0' NOT NULL,
	checkbox_20 int(11) DEFAULT '0' NOT NULL,
	checkbox_21 int(11) DEFAULT '0' NOT NULL,
	checkbox_22 int(11) DEFAULT '0' NOT NULL,
	checkbox_23 int(11) DEFAULT '0' NOT NULL,
	checkbox_24 int(11) DEFAULT '0' NOT NULL,
	checkbox_25 int(11) DEFAULT '0' NOT NULL,
	checkbox_26 int(11) DEFAULT '0' NOT NULL,

	radio_1 int(11) DEFAULT '0' NOT NULL,
	radio_2 int(11) DEFAULT '0' NOT NULL,
	radio_3 int(11) DEFAULT '0' NOT NULL,
	radio_4 text,
	radio_5 int(11) DEFAULT '0' NOT NULL,
	radio_6 int(11) DEFAULT '0' NOT NULL,

	none_1 text,
	none_2 text,
	none_3 text,
	none_4 text,
	none_5 text,

	passthrough_1 text,
	passthrough_2 text,

	user_1 text,

	flex_1 text
);

CREATE TABLE tx_styleguide_elements_group (
	group_db_1 text,
	group_db_2 text,
	group_db_3 text,
	group_db_4 text,
	group_db_5 text,
	group_db_7 text,
	group_db_8 text,
	group_db_9 text,
	group_folder_1 text,
	group_requestUpdate_1 text,

	flex_1 text
);


CREATE TABLE tx_styleguide_elements_rsainput (
	rsainput_1 text,
	rsainput_2 text,
	rsainput_inline_1 text,
	rsainput_flex_1 text
);


CREATE TABLE tx_styleguide_elements_rsainput_flex_1_inline_1_child (
	parentid int(11) DEFAULT '0' NOT NULL,
	parenttable text,

	rsainput_1 text
);


CREATE TABLE tx_styleguide_elements_rsainput_inline_1_child (
	parentid int(11) DEFAULT '0' NOT NULL,
	parenttable text,

	rsainput_1 text
);


CREATE TABLE tx_styleguide_elements_rte (
	rte_1 text,
	rte_2 text,
	rte_3 text,
	rte_inline_1 text,
	rte_flex_1 text,
	input_palette_1 text,
	rte_palette_1 text
);


CREATE TABLE tx_styleguide_elements_rte_flex_1_inline_1_child (
	parentid int(11) DEFAULT '0' NOT NULL,
	parenttable text,

	rte_1 text
);


CREATE TABLE tx_styleguide_elements_rte_inline_1_child (
	parentid int(11) DEFAULT '0' NOT NULL,
	parenttable text,

	rte_1 text
);


CREATE TABLE tx_styleguide_elements_select (
	select_single_1 text,
	select_single_2 text,
	select_single_3 text,
	select_single_4 text,
	select_single_5 text,
	select_single_7 text,
	select_single_8 text,
	select_single_10 text,
	select_single_11 text,
	select_single_12 text,
	select_single_13 text,
	select_single_14 text,
	select_single_15 text,

	select_singlebox_1 text,
	select_singlebox_2 text,

	select_checkbox_1 text,
	select_checkbox_2 text,
	select_checkbox_3 text,
	select_checkbox_4 text,

	select_multiplesidebyside_1 text,
	select_multiplesidebyside_2 text,
	select_multiplesidebyside_3 text,
	select_multiplesidebyside_4 text,
	select_multiplesidebyside_5 text,
	select_multiplesidebyside_6 text,
	select_multiplesidebyside_7 text,
	select_multiplesidebyside_8 text,
	select_multiplesidebyside_9 text,

	select_tree_1 text,
	select_tree_2 text,
	select_tree_3 text,
	select_tree_4 text,
	select_tree_5 text,
	select_tree_6 text,

	flex_1 text,

	select_requestUpdate_1 text
);


CREATE TABLE tx_styleguide_elements_select_single_12_foreign (
	fal_1 text
);


CREATE TABLE tx_styleguide_elements_select_single_15_mm (
	uid_local int(11) DEFAULT '0' NOT NULL,
	uid_foreign int(11) DEFAULT '0' NOT NULL,
	sorting int(11) DEFAULT '0' NOT NULL,

	KEY uid_local (uid_local),
	KEY uid_foreign (uid_foreign)
);


CREATE TABLE tx_styleguide_elements_select_multiplesidebyside_8_mm (
	uid_local int(11) DEFAULT '0' NOT NULL,
	uid_foreign int(11) DEFAULT '0' NOT NULL,
	sorting int(11) DEFAULT '0' NOT NULL,

	KEY uid_local (uid_local),
	KEY uid_foreign (uid_foreign)
);


CREATE TABLE tx_styleguide_elements_special (
	special_custom_1 text,
	special_exclude_1 text,
	special_explicitvalues_1 text,
	special_languages_1 text,
	special_modlistgroup_1 text,
	special_pagetypes_1 text,
	special_tables_1 text,
	special_tables_2 text,
	special_tables_3 text,
	special_usermods_1 text
);


CREATE TABLE tx_styleguide_elements_t3editor (
	t3editor_1 text,
	t3editor_reload_1 int(11) DEFAULT '0' NOT NULL,
	t3editor_inline_1 text,
	t3editor_flex_1 text
);


CREATE TABLE tx_styleguide_elements_t3editor_flex_1_inline_1_child (
	parentid int(11) DEFAULT '0' NOT NULL,
	parenttable text,

	t3editor_1 text
);


CREATE TABLE tx_styleguide_elements_t3editor_inline_1_child (
	parentid int(11) DEFAULT '0' NOT NULL,
	parenttable text,

	t3editor_1 text
);


CREATE TABLE tx_styleguide_flex (
	flex_1 text,
	flex_2 text,
	flex_3 text,
	flex_4 text,
	flex_4_select_1 text,
	flex_5 text,
	flex_6 text,
	flex_6_select_1 text,
	flex_7 text,
	flex_7_select_1 text
);


CREATE TABLE tx_styleguide_flex_flex_3_inline_1_child (
	parentid int(11) DEFAULT '0' NOT NULL,
	parenttable text,

	input_1 text
);


CREATE TABLE tx_styleguide_inline_1n (
	inline_1 int(11) DEFAULT '0' NOT NULL
);


CREATE TABLE tx_styleguide_inline_11 (
	inline_1 int(11) DEFAULT '0' NOT NULL
);

CREATE TABLE tx_styleguide_inline_11_child (
	input_1 text DEFAULT '' NOT NULL
);

CREATE TABLE tx_styleguide_inline_1n_child (
	parentid int(11) DEFAULT '0' NOT NULL,
	parenttable text,

	input_1 text,
	input_2 text,
	group_db_1 text,
	select_tree_1 text
);

CREATE TABLE tx_styleguide_inline_1nnol10n (
	inline_1 int(11) DEFAULT '0' NOT NULL
);


CREATE TABLE tx_styleguide_inline_1nnol10n_child (
	parentid int(11) DEFAULT '0' NOT NULL,
	parenttable text,

	input_1 text
);


CREATE TABLE tx_styleguide_inline_1n1n (
	inline_1 int(11) DEFAULT '0' NOT NULL
);


CREATE TABLE tx_styleguide_inline_1n1n_child (
	parentid int(11) DEFAULT '0' NOT NULL,
	parenttable text,

	inline_1 int(11) DEFAULT '0' NOT NULL
);


CREATE TABLE tx_styleguide_inline_1n1n_childchild (
	parentid int(11) DEFAULT '0' NOT NULL,
	parenttable text,

	input_1 text
);


CREATE TABLE tx_styleguide_inline_expand (
	inline_1 text
);


CREATE TABLE tx_styleguide_inline_expand_inline_1_child (
	parentid int(11) DEFAULT '0' NOT NULL,
	parenttable text,

	dummy_1 text,
	inline_fal_1 int(11) DEFAULT '0' NOT NULL,
	rte_1 text,
	select_tree_1 text,
	t3editor_1 text
);


CREATE TABLE tx_styleguide_inline_expandsingle (
	inline_1 int(11) DEFAULT '0' NOT NULL
);


CREATE TABLE tx_styleguide_inline_expandsingle_child (
	parentid int(11) DEFAULT '0' NOT NULL,
	parenttable text,

	input_1 text
);


CREATE TABLE tx_styleguide_inline_fal (
	inline_1 int(11) DEFAULT '0' NOT NULL,
	inline_2 int(11) DEFAULT '0' NOT NULL,
	inline_3 int(11) DEFAULT '0' NOT NULL,
	inline_flex_1 text
);


CREATE TABLE tx_styleguide_inline_foreignrecorddefaults (
	inline_1 int(11) DEFAULT '0' NOT NULL
);


CREATE TABLE tx_styleguide_inline_foreignrecorddefaults_child (
	parentid int(11) DEFAULT '0' NOT NULL,
	parenttable text,

	input_1 text
);

#
# Table structure for table 'tx_styleguide_inline_parentnosoftdelete'
#
CREATE TABLE tx_styleguide_inline_parentnosoftdelete (
	inline_1 int(11) DEFAULT '0' NOT NULL,
	text_1 text
);


CREATE TABLE tx_styleguide_inline_mm (
	title tinytext,
	inline_1 int(11) DEFAULT '0' NOT NULL
);


CREATE TABLE tx_styleguide_inline_mm_child_rel (
	uid int(11) NOT NULL auto_increment,
	uid_local int(11) DEFAULT '0' NOT NULL,
	uid_foreign int(11) DEFAULT '0' NOT NULL,
	tablenames varchar(255) DEFAULT '' NOT NULL,
	sorting int(11) DEFAULT '0' NOT NULL,
	sorting_foreign int(11) DEFAULT '0' NOT NULL,
	ident varchar(255) DEFAULT '' NOT NULL,

	KEY uid_local (uid_local),
	KEY uid_foreign (uid_foreign),
	PRIMARY KEY (uid)
);


CREATE TABLE tx_styleguide_inline_mm_child (
	title tinytext,
	parents int(11) DEFAULT '0' NOT NULL,
	inline_2 int(11) DEFAULT '0' NOT NULL
);


CREATE TABLE tx_styleguide_inline_mm_child_childchild_rel (
	uid int(11) NOT NULL auto_increment,
	uid_local int(11) DEFAULT '0' NOT NULL,
	uid_foreign int(11) DEFAULT '0' NOT NULL,
	tablenames varchar(255) DEFAULT '' NOT NULL,
	sorting int(11) DEFAULT '0' NOT NULL,
	sorting_foreign int(11) DEFAULT '0' NOT NULL,
	ident varchar(255) DEFAULT '' NOT NULL,

	KEY uid_local (uid_local),
	KEY uid_foreign (uid_foreign),
	PRIMARY KEY (uid)
);


CREATE TABLE tx_styleguide_inline_mm_childchild (
	title tinytext,
	parents int(11) DEFAULT '0' NOT NULL
);


CREATE TABLE tx_styleguide_inline_mn (
	input_1 tinytext,
	inline_1 int(11) DEFAULT '0' NOT NULL
);


CREATE TABLE tx_styleguide_inline_mn_mm (
	parentid int(11) DEFAULT '0' NOT NULL,
	childid int(11) DEFAULT '0' NOT NULL,
	parentsort int(10) DEFAULT '0' NOT NULL,
	childsort int(10) DEFAULT '0' NOT NULL,

	check_1 int(11) DEFAULT '0' NOT NULL
);


CREATE TABLE tx_styleguide_inline_mn_child (
	input_1 tinytext,
	parents int(11) DEFAULT '0' NOT NULL
);


CREATE TABLE tx_styleguide_inline_mngroup (
	input_1 tinytext,
	inline_1 int(11) DEFAULT '0' NOT NULL
);


CREATE TABLE tx_styleguide_inline_mngroup_mm (
	parentid int(11) DEFAULT '0' NOT NULL,
	childid int(11) DEFAULT '0' NOT NULL,
	parentsort int(10) DEFAULT '0' NOT NULL,
	childsort int(10) DEFAULT '0' NOT NULL,

	check_1 int(11) DEFAULT '0' NOT NULL
);


CREATE TABLE tx_styleguide_inline_mngroup_child (
	input_1 tinytext,
	parents int(11) DEFAULT '0' NOT NULL
);


CREATE TABLE tx_styleguide_inline_mnsymmetric (
	input_1 tinytext,
	branches int(11) DEFAULT '0' NOT NULL
);


CREATE TABLE tx_styleguide_inline_mnsymmetric_mm (
	hotelid int(11) DEFAULT '0' NOT NULL,
	branchid int(11) DEFAULT '0' NOT NULL,
	hotelsort int(10) DEFAULT '0' NOT NULL,
	branchsort int(10) DEFAULT '0' NOT NULL
);


CREATE TABLE tx_styleguide_inline_usecombination (
	inline_1 int(11) DEFAULT '0' NOT NULL
);


CREATE TABLE tx_styleguide_inline_usecombination_mm (
	select_parent int(11) unsigned DEFAULT '0' NOT NULL,
	select_child int(11) unsigned DEFAULT '0' NOT NULL
);


CREATE TABLE tx_styleguide_inline_usecombination_child (
	input_1 varchar(255) DEFAULT '' NOT NULL
);


CREATE TABLE tx_styleguide_inline_usecombinationbox (
	inline_1 int(11) DEFAULT '0' NOT NULL
);


CREATE TABLE tx_styleguide_inline_usecombinationbox_mm (
	select_parent int(11) unsigned DEFAULT '0' NOT NULL,
	select_child int(11) unsigned DEFAULT '0' NOT NULL
);


CREATE TABLE tx_styleguide_inline_usecombinationbox_child (
	input_1 varchar(255) DEFAULT '' NOT NULL
);


CREATE TABLE tx_styleguide_palette (
	palette_1_1 int(11) DEFAULT '0' NOT NULL,
	palette_1_2 text,
	palette_1_3 int(11) DEFAULT '0' NOT NULL,
	palette_2_1 text,
	palette_3_1 text,
	palette_3_2 text,
	palette_4_1 text,
	palette_4_2 text,
	palette_4_3 text,
	palette_4_4 text,
	palette_5_1 text,
	palette_5_2 text,
	palette_6_1 text,
	palette_7_1 text
);


CREATE TABLE tx_styleguide_required (
	notrequired_1 text,

	input_1 text,
	input_2 text,
	input_3 text,

	text_1 text,

	select_1 text,
	select_2 text,
	select_3 text,
	select_4 text,
	select_5 text,

	group_1 text,
	group_2 text,

	rte_1 text,
	rte_2 text,

	inline_1 text,
	inline_2 text,
	inline_3 text,

	flex_1 text,
	flex_2 text,

	palette_input_1 text,
	palette_input_2 text
);


CREATE TABLE tx_styleguide_required_flex_2_inline_1_child (
	parentid int(11) DEFAULT '0' NOT NULL,
	parenttable text,

	input_1 text
);


CREATE TABLE tx_styleguide_required_inline_1_child (
	parentid int(11) DEFAULT '0' NOT NULL,
	parenttable text,

	input_1 text
);


CREATE TABLE tx_styleguide_required_inline_2_child (
	parentid int(11) DEFAULT '0' NOT NULL,
	parenttable text,

	input_1 text
);


CREATE TABLE tx_styleguide_required_inline_3_child (
	parentid int(11) DEFAULT '0' NOT NULL,
	parenttable text,

	input_1 text
);


CREATE TABLE tx_styleguide_required_rte_2_child (
	parentid int(11) DEFAULT '0' NOT NULL,
	parenttable text,

	rte_1 text
);


CREATE TABLE tx_styleguide_staticdata (
	value_1 tinytext
);


CREATE TABLE tx_styleguide_type (
	type text,

	text_1 text
);


CREATE TABLE tx_styleguide_valuesdefault (
	input_1 text,
	input_2 text,
	input_3 text,

	text_1 text,

	checkbox_1 int(11) DEFAULT '0' NOT NULL,
	checkbox_2 int(11) DEFAULT '0' NOT NULL,
	checkbox_3 int(11) DEFAULT '0' NOT NULL,

	radio_1 int(11) DEFAULT '0' NOT NULL,

	select_1 text,
	select_2 text
);

#
# Table structure for table 'tx_styleguide_inline_parentnosoftdelete'
#
CREATE TABLE tx_styleguide_inline_parentnosoftdelete (
	inline_1 int(11) DEFAULT '0' NOT NULL,
	text_1 text
);