#
# Table structure for table 'tx_news_domain_model_news'
#
CREATE TABLE tx_news_domain_model_news (
    tel2 TINYTEXT DEFAULT '' NOT NULL,
    snapchat TINYTEXT DEFAULT '' NOT NULL,
    youtube TINYTEXT DEFAULT '' NOT NULL,
    cantons_related int(11) DEFAULT '0' NOT NULL,
    cantons_borders TEXT DEFAULT '' NOT NULL,
    partner_related int(11) DEFAULT '0' NOT NULL,
    cantons_related_from int(11) DEFAULT '0' NOT NULL,
    reference_job TINYTEXT DEFAULT '' NOT NULL,
    domaine_employ TINYTEXT DEFAULT '' NOT NULL,
    related_amenities TINYTEXT DEFAULT '' NOT NULL,
    title_help_information TINYTEXT DEFAULT '' NOT NULL,
    title_help_information_second TINYTEXT DEFAULT '' NOT NULL,
    title_help_information_third TINYTEXT DEFAULT '' NOT NULL,
    bodytext_help_information TEXT DEFAULT '' NOT NULL,
    bodytext_help_information_second TEXT DEFAULT '' NOT NULL,
    bodytext_help_information_third TEXT DEFAULT '' NOT NULL,
    communes_related int(11) DEFAULT '0' NOT NULL,
    communes_related_from int(11) DEFAULT '0' NOT NULL,
    person_first_name TINYTEXT DEFAULT '' NOT NULL,
    person_activity TINYTEXT DEFAULT '' NOT NULL,
    tourinsoft_id TINYTEXT DEFAULT '' NOT NULL,
    tracking_script TEXT DEFAULT '' NOT NULL,
    show_category_image int(11) DEFAULT '0' NOT NULL,
);

#
# Table structure for table 'tx_news_domain_model_news_cantons_related_mm'
#
CREATE TABLE tx_news_domain_model_news_cantons_related_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)
);

#
# Table structure for table 'tx_news_domain_model_news_partner_related_mm'
#
CREATE TABLE tx_news_domain_model_news_partner_related_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)
);

#
# Table structure for table 'tx_stratissite_domain_model_amenities'
#
CREATE TABLE tx_stratissite_domain_model_amenities(
    uid int(11)             NOT NULL auto_increment,
    pid int(11)             DEFAULT '0' NOT NULL,
    tstamp int(11)          DEFAULT '0' NOT NULL,
    crdate int(11)          DEFAULT '0' NOT NULL,
    deleted tinyint(4)      DEFAULT '0' NOT NULL,
    hidden tinyint(4)       DEFAULT '0' NOT NULL,
    parent int(11)          DEFAULT '0' NOT NULL,
    title                   TINYTEXT,
    categories              TINYTEXT,
    tags                    TINYTEXT,
    PRIMARY KEY (uid),
    KEY parent (pid)
);

#
# Table structure for table 'tx_news_domain_model_news_communes_related_mm'
#
CREATE TABLE tx_news_domain_model_news_communes_related_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)
);


#
# Table structure for table 'tx_powermail_domain_model_field'
#
CREATE TABLE tx_powermail_domain_model_field (
    autocomplete INT(11) DEFAULT '0'
);

#
# Extend table structure of table 'sys_category'
#
CREATE TABLE sys_category (
    cat_email varchar(255) NOT NULL DEFAULT ''
);
