#
# Table structure for table 'tx_news_domain_model_news'
#
CREATE TABLE tx_news_domain_model_news (

    main_media             INT(11) UNSIGNED DEFAULT '0',
    home_media             INT(11) UNSIGNED DEFAULT '0',
    user_media             INT(11) UNSIGNED DEFAULT '0',

    activity               TEXT,
    activity2              TEXT,
    activity3              TEXT,
    content_elements_aside TEXT,

    tel                    TINYTEXT,
    fax                    TINYTEXT,
    email                  TINYTEXT,
    email2                 TINYTEXT,
    www                    TEXT,
    facebook               TINYTEXT,
    twitter                TINYTEXT,
    instagram              TINYTEXT,
    linkedin               TINYTEXT,

    recipients             TEXT,

    informations           TEXT,
    reservation            TEXT,
    schedule               TEXT,
    price                  TEXT,
    url                    TINYTEXT,
    start_hour             INT(11) DEFAULT '0' NOT NULL,
    end_hour               INT(11) DEFAULT '0' NOT NULL,

    person_civility        TINYTEXT,
    person_name            TINYTEXT,
    person_tel             TINYTEXT,
    person_fax             TINYTEXT,
    person_email           TINYTEXT,
    person_www             TINYTEXT,

    population             TEXT,
    inhabitants            TEXT,
    mayor                  TEXT,
    map_points             TEXT,
    website                TEXT,

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

    domains                TEXT,

    subscription_enabled   int(11) DEFAULT '0' NOT NULL,
    related_subscriber     int(11) DEFAULT '0' NOT NULL,
    subscriber_limit       tinyint(4) DEFAULT '0' NOT NULL,
    second_tel             TINYTEXT,

    related_locations      INT(11) DEFAULT '0' NOT NULL,
    related_locations_from INT(11) DEFAULT '0' NOT NULL
);

#
# Table structure for table 'tx_news_record_mm'
#
CREATE TABLE tx_news_record_mm (

    uid_local       INT(11) UNSIGNED DEFAULT '0' NOT NULL,
    uid_foreign     INT(11) UNSIGNED DEFAULT '0' NOT NULL,
    tablenames      VARCHAR(255) DEFAULT ''      NOT NULL,
    fieldname       VARCHAR(255) DEFAULT ''      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)
);

#
# Table structure for table 'tt_content'
#
CREATE TABLE tt_content (
    tx_stratis_news_related_news INT(11) DEFAULT '0' NOT NULL
);

#
# Table structure for table 'tx_news_domain_model_subscriber'
#
CREATE TABLE tx_news_domain_model_subscriber (
    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,
    cruser_id               int(11) DEFAULT '0' NOT NULL,
    sorting                 int(11) DEFAULT '0' NOT NULL,
    deleted                 tinyint(4) DEFAULT '0' NOT NULL,
    hidden                  tinyint(4) DEFAULT '0' NOT NULL,
    name text,
    first_name text,
    email text,
    civility int(11) DEFAULT '0' NOT NULL,
    related_news int(11) DEFAULT '0' NOT NULL,

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

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