# used in /t3import but maybe not necessary/needed any more
CREATE TABLE importlog
(
    pid  int(11)                      DEFAULT '0' NOT NULL,
    text text COLLATE utf8_general_ci DEFAULT ''  NOT NULL
);

# used in /t3import but maybe not necessary/needed any more
CREATE TABLE urls_new
(
    id   int(20) DEFAULT '0' NOT NULL auto_increment,
    url  varchar(255) COLLATE utf8_general_ci,
    pid  int(11),
    lang int(11),

    PRIMARY KEY (id)
);

# used in /t3import but maybe not necessary/needed any more
CREATE TABLE urls_old
(
    id   int(11) DEFAULT '0' NOT NULL auto_increment,
    url  varchar(255) COLLATE utf8_general_ci,
    pid  int(11),
    lang int(11),

    PRIMARY KEY (id)
);

# used in /t3import but maybe not necessary/needed any more
CREATE TABLE urls_old_news
(
    id           int(11) DEFAULT '0' NOT NULL auto_increment,
    uid          int(11),
    storage_pid  int(11),
    display_pid  int(11),
    language_uid int(11),
    url          varchar(1024) COLLATE utf8_general_ci,

    PRIMARY KEY (id)
);

# needed for language menu, solr indexing and sitemap
CREATE TABLE tx_nedistribution_domain_model_product
(
    import_id       varchar(255) DEFAULT ''  NOT NULL,
    title           mediumtext,
    slug            mediumtext,
    description     text,
    image_base64    longtext,
    smc_id          varchar(255) DEFAULT ''  NOT NULL,
    parent_category int(11)      DEFAULT '0' NOT NULL
);

# needed for language menu, solr indexing and sitemap
CREATE TABLE tx_nedistribution_domain_model_document
(
    import_id   varchar(255) DEFAULT '' NOT NULL,
    title       mediumtext,
    description text,
    link        mediumtext,
    filename    varchar(255) DEFAULT '' NOT NULL,
    edition     varchar(255) DEFAULT '' NOT NULL,
    name        varchar(255) DEFAULT '' NOT NULL,
    smc_id      varchar(255) DEFAULT '' NOT NULL
);

# needed for language menu
CREATE TABLE tx_nedistribution_domain_model_category
(
    import_id       varchar(255) DEFAULT ''  NOT NULL,
    title           mediumtext,
    slug            mediumtext,
    description     text,
    smc_id          varchar(255) DEFAULT ''  NOT NULL,
    parent_category int(11)      DEFAULT '0' NOT NULL
);

CREATE TABLE tx_nedistribution_domain_model_grayteaser
(
    header        varchar(255)     DEFAULT ''  NOT NULL,
    headline      varchar(255)     DEFAULT ''  NOT NULL,
    headline_type varchar(255)     DEFAULT ''  NOT NULL,
    image         int(11) unsigned DEFAULT '0' NOT NULL,
    icon          int(11) unsigned DEFAULT '0' NOT NULL,
    box_text      text                         NOT NULL,
    link          text,
    link_text     varchar(255)     DEFAULT ''  NOT NULL,
    link_title    varchar(255)     DEFAULT ''  NOT NULL
);

CREATE TABLE sys_refindex
(
    ref_uid bigint DEFAULT '0' NOT NULL
);

CREATE TABLE sys_file
(
    size bigint unsigned DEFAULT '0' NOT NULL
);