CREATE TABLE tx_news_domain_model_tag (
    is_primary int(11) DEFAULT '0' NOT NULL,
);
CREATE TABLE tx_news_domain_model_news (
    vacancy varchar(255) DEFAULT '' NOT NULL,
    contact varchar(255) DEFAULT '' NOT NULL,
    holiday varchar(255) DEFAULT '' NOT NULL,
    job_type varchar(255) DEFAULT '' NOT NULL,
    dealer varchar(255) DEFAULT '' NOT NULL,
    email varchar(255) DEFAULT '' NOT NULL,
    phone varchar(255) DEFAULT '' NOT NULL,
    address varchar(255) DEFAULT '' NOT NULL,
    stand_link varchar(255) DEFAULT '' NOT NULL,
    address_link varchar(255) DEFAULT '' NOT NULL,
    related_job_teaser varchar(255) DEFAULT '' NOT NULL,
    use_contact_email tinyint(4) DEFAULT '0' NOT NULL,
    related_job int(11) DEFAULT '0' NOT NULL,
    sub_title varchar(255) DEFAULT '' NOT NULL,
    plan_position varchar(255) DEFAULT 0 NOT NULL,
    short_description text,
    owner tinyint(4) DEFAULT '0' NOT NULL,
    show_title  int(11) DEFAULT '0' NOT NULL,
    coordinates  varchar(255) DEFAULT '' NOT NULL,
    coordinates_link  text,
    social_link  text,
    tx_csseo int(11) unsigned NOT NULL default '0',
    fal_media_dealers int(11) DEFAULT '0' NOT NULL,
    uri_dealers text,
);

#
# Table structure for table 'tx_news_domain_model_news_related_dealer_job_mm'
#
CREATE TABLE tx_news_domain_model_news_related_dealer_job_mm (
      uid_local int(11) DEFAULT '0' NOT NULL,
      uid_foreign int(11) DEFAULT '0' NOT NULL,
      sorting int(11) DEFAULT '0' NOT NULL,
      sorting_foreign int(11) DEFAULT '0' NOT NULL,
      KEY uid_local (uid_local),
      KEY uid_foreign (uid_foreign)
);

CREATE TABLE tx_grossmarkt_domain_model_contact_person (
    uid int(11) NOT NULL auto_increment,
    pid int(11) DEFAULT '0' NOT NULL,
    t3ver_oid int(11) DEFAULT '0' NOT NULL,
    t3ver_id int(11) DEFAULT '0' NOT NULL,
    t3ver_wsid int(11) DEFAULT '0' NOT NULL,
    t3ver_label varchar(30) DEFAULT '' NOT NULL,
    t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
    t3ver_stage tinyint(4) DEFAULT '0' NOT NULL,
    t3ver_count int(11) DEFAULT '0' NOT NULL,
    t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
    t3ver_move_id int(11) DEFAULT '0' NOT NULL,
    t3_origuid int(11) DEFAULT '0' NOT NULL,
    tstamp int(11) DEFAULT '0' NOT NULL,
    crdate int(11) DEFAULT '0' NOT NULL,
    cruser_id int(11) DEFAULT '0' NOT NULL,
    editlock tinyint(4) DEFAULT '0' NOT NULL,
    sys_language_uid int(11) DEFAULT '0' NOT NULL,
    l10n_parent int(11) DEFAULT '0' NOT NULL,
    l10n_diffsource mediumtext,
    l10n_source int(11) DEFAULT '0' NOT NULL,
    deleted tinyint(4) DEFAULT '0' NOT NULL,
    hidden tinyint(4) DEFAULT '0' NOT NULL,
    starttime int(11) DEFAULT '0' NOT NULL,
    endtime int(11) DEFAULT '0' NOT NULL,
    sorting int(11) DEFAULT '0' NOT NULL,

    name varchar(255) DEFAULT '' NOT NULL,
    email varchar(255) DEFAULT '' NOT NULL,
    image int(11) unsigned DEFAULT '0',

    PRIMARY KEY (uid),
    KEY parent (pid)
);

#
# Extend table structure of table 'sys_category'
#
CREATE TABLE sys_category (
      image_detail int(11) unsigned DEFAULT '0',
      purchasing_requirements text,
      opening_hours text,
      parking text,
      delivery_traffic text,
      aps text,
      fees text,
      color varchar(255) DEFAULT '' NOT NULL,
);
#
# Extend table structure of table 'tt_content'
#
CREATE TABLE tt_content (
      background_green int(11) unsigned DEFAULT '0',
);

#
# Extend table structure of table 'sys_file_metadata'
#
CREATE TABLE sys_file_metadata (
       copyright text,
);
