CREATE TABLE tx_nepsm_domain_model_announcement
(
    title        varchar(255)     DEFAULT ''  NOT NULL,
    subtitle     varchar(255)     DEFAULT ''  NOT NULL,
    abstract     text                         NOT NULL,
    content      text                         NOT NULL,
    release_date int(11) unsigned DEFAULT '0' NOT NULL,
    thumbnail    int(11) unsigned DEFAULT '0' NOT NULL,
    image        int(11) unsigned DEFAULT '0' NOT NULL,
    related      int(11) unsigned DEFAULT '0' NOT NULL,
    slug         varchar(255)     DEFAULT ''  NOT NULL
);

CREATE TABLE tx_nepsm_announcement_announcement_mm
(
    uid_local       int(11) unsigned DEFAULT '0' NOT NULL,
    uid_foreign     int(11) unsigned DEFAULT '0' 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)
);

CREATE TABLE tx_nepsm_domain_model_download
(
    title varchar(255) DEFAULT '' NOT NULL,
    slug  varchar(255) DEFAULT '' NOT NULL
);

CREATE TABLE tx_nepsm_domain_model_glossary
(
    title varchar(255) DEFAULT '' NOT NULL,
    slug  varchar(255) DEFAULT '' NOT NULL
);

CREATE TABLE tx_nepsm_domain_model_job
(
    title         varchar(255)        DEFAULT ''  NOT NULL,
    startjob      varchar(255)        DEFAULT ''  NOT NULL,
    inactive      tinyint(4) unsigned DEFAULT '0' NOT NULL,
    place         varchar(255)        DEFAULT ''  NOT NULL,
    contract      varchar(255)        DEFAULT ''  NOT NULL,
    job_i_d       varchar(255)        DEFAULT ''  NOT NULL,
    mailbutton    varchar(255)        DEFAULT ''  NOT NULL,
    intro_text    text                            NOT NULL,
    headline1     varchar(255)        DEFAULT ''  NOT NULL,
    text1         text                            NOT NULL,
    headline2     varchar(255)        DEFAULT ''  NOT NULL,
    text2         text                            NOT NULL,
    headline3     varchar(255)        DEFAULT ''  NOT NULL,
    text3         text                            NOT NULL,
    headline4     varchar(255)        DEFAULT ''  NOT NULL,
    text4         text                            NOT NULL,
    stageimg      int(11) unsigned                NOT NULL default '0',
    company       int(11) unsigned    DEFAULT '0' NOT NULL,
    contactperson int(11) unsigned    DEFAULT '0' NOT NULL,
    slug          varchar(255)        DEFAULT ''  NOT NULL
);

CREATE TABLE tx_nepsm_domain_model_contactperson
(
    name            varchar(255)     DEFAULT ''  NOT NULL,
    firstname       varchar(255)     DEFAULT ''  NOT NULL,
    jobtitle        varchar(255)     DEFAULT ''  NOT NULL,
    department      varchar(255)     DEFAULT ''  NOT NULL,
    image           int(11) unsigned             NOT NULL default '0',
    mail            varchar(255)     DEFAULT ''  NOT NULL,
    phone           varchar(255)     DEFAULT ''  NOT NULL,
    contactcategory int(11) unsigned DEFAULT '0' NOT NULL
);
CREATE TABLE tx_nepsm_domain_model_contactcategories
(
    name varchar(255) DEFAULT '' NOT NULL,
);

CREATE TABLE tx_nepsm_domain_model_company
(
    name    varchar(255) DEFAULT '' NOT NULL,
    street  varchar(255) DEFAULT '' NOT NULL,
    zip     varchar(255) DEFAULT '' NOT NULL,
    city    varchar(255) DEFAULT '' NOT NULL,
    country varchar(255) DEFAULT '' NOT NULL,
    phone1  varchar(255) DEFAULT '' NOT NULL,
    phone2  varchar(255) DEFAULT '' NOT NULL,
    web     varchar(255) DEFAULT '' NOT NULL,
    web2    varchar(255) DEFAULT '' NOT NULL,
    email   varchar(255) DEFAULT '' NOT NULL,
    text    text                    NOT NULL,
);

CREATE TABLE tx_nepsm_domain_model_media
(
    title            varchar(255)     DEFAULT ''  NOT NULL,
    category         int(11) unsigned DEFAULT '0' NOT NULL,
    shortdescription text                         NOT NULL,
    description      text                         NOT NULL,
    file             int(11) unsigned             NOT NULL default '0',
    thumbnail        int(11) unsigned DEFAULT '0' NOT NULL,
    copyright        varchar(255)     DEFAULT ''  NOT NULL,
    tags             varchar(255)     DEFAULT ''  NOT NULL,
    slug             varchar(255)     DEFAULT ''  NOT NULL,
    sorting         int(11) unsigned DEFAULT '0' NOT NULL
);

CREATE TABLE tx_nepsm_domain_model_mediacategory
(
    title varchar(255) DEFAULT '' NOT NULL
);

CREATE TABLE tx_nepsm_domain_model_mediatag
(
    title varchar(255) DEFAULT '' NOT NULL
);

CREATE TABLE tx_nepsm_domain_model_pressreport
(
    title varchar(255) DEFAULT '' NOT NULL,
    slug  varchar(255) DEFAULT '' NOT NULL
);

CREATE TABLE tx_nepsm_domain_model_reference
(
    title varchar(255) DEFAULT '' NOT NULL,
    slug  varchar(255) DEFAULT '' NOT NULL
);

CREATE TABLE tx_nepsm_domain_model_teammember
(
    title varchar(255) DEFAULT '' NOT NULL,
    slug  varchar(255) DEFAULT '' NOT NULL
);