ext_tables.sql

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

CREATE TABLE tt_content (
    tx_styleguide_containsdemo varchar(255) DEFAULT '' 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 fe_groups (
    tx_styleguide_containsdemo varchar(255) DEFAULT '' NOT NULL
);

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


CREATE TABLE tx_styleguide_ctrl_common (
    title text,
    description text,
);


CREATE TABLE tx_styleguide_ctrl_minimal (
    title text,
);


CREATE TABLE tx_styleguide_displaycond (
    input_1 text,
    input_2 text,
    input_4 text,
    input_5 text,
    input_6 text,
    input_7 text,
    input_8 text,
    input_9 text,
    input_10 text,
    input_11 text,
    input_12 text,
    input_13 text,
    input_16 text,
    input_17 text,
    input_18 text,
    input_19 text,
    input_20 text,

    number_1 int(11) DEFAULT '0' NOT NULL,
    number_2 int(11) DEFAULT '0' NOT NULL,
    number_3 int(11) DEFAULT '0' NOT NULL,

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

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

    flex_1 text,
    flex_2 text,
    flex_3 text,
);


CREATE TABLE tx_styleguide_elements_basic (
    input_1 text,
    input_2 text,
    input_3 text,
    input_4 text,
    input_5 text,
    input_10 text,
    input_11 text,
    input_12 text,
    input_13 text,
    input_14 text,
    input_15 text,
    input_19 text,
    input_20 text,
    input_21 text,
    input_22 text,
    input_23 text,
    input_24 text,
    input_26 text,
    input_27 text,
    input_28 text,
    input_33 text,
    input_35 text,
    input_36 text,
    input_40 text,
    input_41 text,
    input_42 text,
    input_43 text,
    input_44 text,

    link_1 text,
    link_2 text,
    link_3 text,
    link_4 text,
    link_5 text,

    password_1 text,
    password_2 text,
    password_3 text,
    password_4 text,
    password_5 text,
    password_6 text,
    password_7 text,

    color_1 text,
    color_2 text,
    color_3 text,

    number_1 text,
    number_2 int(11) DEFAULT '0' NOT NULL,
    number_3 int(11) DEFAULT '0' NOT NULL,
    number_4 int(11) DEFAULT '0' NOT NULL,
    number_5 text,
    number_6 int(11) DEFAULT '0' NOT NULL,
    number_7 int(11) DEFAULT '0' NOT NULL,

    email_1 text,
    email_2 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,
    inputdatetime_11 text,

    text_1 text,
    text_2 text,
    text_3 text,
    text_4 text,
    text_5 text,
    text_6 text,
    text_7 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,
    text_20 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,

    passthrough_1 text,
    passthrough_2 text,

    user_1 text,
    user_2 text,

    unknown_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_db_10 text,
    group_db_11 text,
    group_requestUpdate_1 text,

    flex_1 text
);

CREATE TABLE tx_styleguide_elements_folder
(
    folder_1 text,
    folder_2 text,
    flex_1 text
);

CREATE TABLE tx_styleguide_elements_imagemanipulation (
    group_db_1 text,
    group_db_2 text,
    group_db_3 text,
    crop_1 text,
    crop_2 text,
    crop_3 text,
    crop_4 text,
    crop_5 text,
    crop_6 text,
    crop_7 text,
    crop_8 text
);


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

CREATE TABLE tx_styleguide_elements_slugs (
    input_1 text,
    input_2 text,
    input_3 text,
    slug_1 text,
    slug_2 text,
    slug_3 text,
    slug_4 text,
    slug_5 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_single_16 text,
    select_single_17 text,
    select_single_18 text,
    select_single_19 text,
    select_single_20 text,

    select_singlebox_1 text,
    select_singlebox_2 text,
    select_singlebox_3 text,

    select_checkbox_1 text,
    select_checkbox_2 text,
    select_checkbox_3 text,
    select_checkbox_4 text,
    select_checkbox_5 text,
    select_checkbox_6 text,
    select_checkbox_7 text,

    select_multiplesidebyside_1 text,
    select_multiplesidebyside_2 text,
    select_multiplesidebyside_3 text,
    select_multiplesidebyside_5 text,
    select_multiplesidebyside_6 text,
    select_multiplesidebyside_7 text,
    select_multiplesidebyside_8 text,
    select_multiplesidebyside_9 text,
    select_multiplesidebyside_10 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,

    category_11 text,
    category_1n text,
    category_mm text,

    flex_1 text,

    select_requestUpdate_1 text
);


CREATE TABLE tx_styleguide_elements_select_single_12_foreign (
    fal_1 text
);


# MM tables for fields defined in flex form data structures
# are NOT auto created by DefaultTcaSchema
CREATE TABLE tx_styleguide_elements_select_flex_1_multiplesidebyside_2_mm (
	uid_local int(11) unsigned DEFAULT 0 NOT NULL,
	uid_foreign int(11) unsigned DEFAULT 0 NOT NULL,
	sorting int(11) unsigned DEFAULT 0 NOT NULL,
	sorting_foreign int(11) unsigned DEFAULT 0 NOT NULL,

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


CREATE TABLE tx_styleguide_elements_t3editor (
    t3editor_1 text,
    t3editor_2 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_file_1 text,
    flex_1 text,
    flex_2 text,
    flex_3 text,
    flex_5 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,
    inline_2 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
);

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

    input_1 text,
    input_3 text,
    color_1 text,
    group_db_1 text,
    select_tree_1 text
);

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

    input_1 text,
    file_1 int(11) DEFAULT '0' NOT NULL,
    rte_1 text,
    select_tree_1 text,
    t3editor_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,
    file_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_file (
    file_1 int(11) DEFAULT '0' NOT NULL,
    file_2 int(11) DEFAULT '0' NOT NULL,
    file_3 int(11) DEFAULT '0' NOT NULL,
    file_4 int(11) DEFAULT '0' NOT NULL,
    file_5 int(11) DEFAULT '0' NOT NULL,
    file_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
);


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


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_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_mnsymmetricgroup (
    input_1 tinytext,
    branches int(11) DEFAULT '0' NOT NULL
);


CREATE TABLE tx_styleguide_inline_mnsymmetricgroup_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_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,

    link_1 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 (
    record_type text,
    input_1 text,
    color_1 text,
    text_1 text
);


CREATE TABLE tx_styleguide_typeforeign (
    foreign_table int(11) DEFAULT '0' NOT NULL,
    input_1 text,
    color_1 text,
    text_1 text
);


CREATE TABLE tx_styleguide_valuesdefault (
    input_1 text,
    input_2 text,

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

    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,
    checkbox_4 int(11) DEFAULT '0' NOT NULL,

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

    select_1 text,
    select_2 text
);

CREATE TABLE tx_styleguide_l10nreadonly (
    input text,
    color text,
    datetime text,
    link text,
    slug text,
    checkbox int(11) DEFAULT '0' NOT NULL,
    checkbox_toggle int(11) DEFAULT '0' NOT NULL,
    checkbox_labeled_toggle int(11) DEFAULT '0' NOT NULL,
    radio int(11) DEFAULT '0' NOT NULL,
    none text,
    group text,
    group_mm text,
    group_file text,
    folder text,
    image_manipulation text,
    language int(11) DEFAULT '0' NOT NULL,
    text text,
    text_rte text,
    text_belayoutwizard text,
    text_t3editor text,
    text_table text,
    select_single text,
    select_single_box text,
    select_checkbox text,
    select_tree text,
    select_tree_mm text,
    select_multiplesidebyside text,
    select_multiplesidebyside_mm text,
    inline text,
    flex text
);

CREATE TABLE tx_styleguide_l10nreadonly_inline_child (
    parentid int(11) DEFAULT '0' NOT NULL,
    parenttable text,
    input text,
);

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