#
# Table structure for table 'tx_cartproducts_domain_model_product_bevariantattribute'
#
CREATE TABLE tx_cartproducts_domain_model_product_bevariantattribute
(
    tx_muthsevshop_display_type int(11) DEFAULT '0' NOT NULL
);

###
# Table structure for table `pages`
###
CREATE TABLE pages
(
    tx_muthsevshop_product_category INT(11) unsigned DEFAULT '0' NOT NULL
);

###
# Table structure for table `sys_category`
###
CREATE TABLE sys_category
(
    is_featured INT(4) unsigned DEFAULT '0' NOT NULL
);

###
# Table structure for table `tx_cart_domain_model_order_item`
###
CREATE TABLE tx_cart_domain_model_order_item
(
    contact INT(11) unsigned DEFAULT '0' NOT NULL
);

###
# Table structure for table `tx_cartproducts_domain_model_product_bevariant`
###
CREATE TABLE tx_cartproducts_domain_model_product_bevariant
(
    product            int(11) unsigned DEFAULT '0' NOT NULL,
    images             VARCHAR(255)     DEFAULT ''  NOT NULL,
    quantity_discounts INT(11) unsigned             NOT NULL,

    KEY product (product)
);

###
# Table structure for table `tx_cartproducts_domain_model_product_fevariant`
###
CREATE TABLE tx_cartproducts_domain_model_product_fevariant
(
    description                              VARCHAR(150)     DEFAULT ''  NOT NULL,
    record_type                              INT(11) unsigned DEFAULT '0' NOT NULL,
    tx_muthsevshop_fevariantdisplaycondition VARCHAR(20)      DEFAULT ''  NOT NULL
);

###
# Table structure for table `tx_muthsevshop_domain_model_product_fevariantdisplaycondition`
###
CREATE TABLE tx_muthsevshop_domain_model_product_fevariantdisplaycondition
(
    condition_group TINYINT      DEFAULT '0' NOT NULL,
    field_name      VARCHAR(255) DEFAULT ''  NOT NULL,
    field_value     VARCHAR(255) DEFAULT ''  NOT NULL,
    operator        VARCHAR(10)  DEFAULT ''  NOT NULL
);

###
# Table structure for table `tx_cartproducts_domain_model_product_product`
###
CREATE TABLE tx_cartproducts_domain_model_product_product
(
    default_be_variant INT(11) DEFAULT '0' NOT NULL
);

###
# Table structure for table `tx_cart_domain_model_tag`
###
CREATE TABLE tx_cart_domain_model_tag
(
    items           INT(11)          DEFAULT '0' NOT NULL,
    images          INT(11) unsigned DEFAULT '0',
    seo_title       VARCHAR(255)                 NOT NULL DEFAULT '',
    seo_description TEXT,
    seo_headline    VARCHAR(255)                 NOT NULL DEFAULT '',
    seo_text        TEXT,
    slug            VARCHAR(2048),
    single_pid      INT(11) unsigned DEFAULT '0' NOT NULL,
    list_pid        INT(11) unsigned DEFAULT '0' NOT NULL,

    import_id       varchar(100)     DEFAULT ''  NOT NULL,
    import_source   varchar(100)     DEFAULT ''  NOT NULL,

    KEY import (import_id, import_source)
);
