CREATE TABLE tt_content (
    tx_carriere_enchiffres int(11) unsigned DEFAULT '0' NOT NULL
);

# Table structure for table 'tx_news_domain_model_news'
#
CREATE TABLE tx_news_domain_model_news (
    identification_number varchar(255) DEFAULT '' NOT NULL,
    name_of_ad varchar(255) DEFAULT '' NOT NULL,
    description_teaser varchar(255) DEFAULT '' NOT NULL,
    date_publication varchar(255) DEFAULT '' NOT NULL,
    application_deadline varchar(255) DEFAULT '' NOT NULL,
    post_type varchar(255) DEFAULT '' NOT NULL,
    localisation_category varchar(255) DEFAULT '' NOT NULL,
    main_tasks text,
    expected_skills text,
    professional_family text,
    assignment varchar(255) DEFAULT '' NOT NULL,
    supervisory_role varchar(255) DEFAULT '' NOT NULL,
    project_management varchar(255) DEFAULT '' NOT NULL,
    knowledge text,
    expertise text,
    soft_skills text,
    number_vacancies varchar(255) DEFAULT '' NOT NULL,
    starting_date_of_competition varchar(255) DEFAULT '' NOT NULL,
    end_date_of_competition varchar(255) DEFAULT '' NOT NULL,
    competition_type varchar(255) DEFAULT '' NOT NULL,
    activity_branch varchar(255) DEFAULT '' NOT NULL,
    eligibility_phase text,
    admission_phase text,
    contact_persons text,
    contact_mail_address varchar(255) DEFAULT '' NOT NULL,
    function varchar(255) DEFAULT '' NOT NULL,
    quote varchar(255) DEFAULT '' NOT NULL,
    employer varchar(255) DEFAULT '' NOT NULL,
    condition varchar(255) DEFAULT '' NOT NULL,
    hierarchic_reattachment varchar(255) DEFAULT '' NOT NULL,
    candidacy varchar(255) DEFAULT '' NOT NULL,
    period_concours varchar(255) DEFAULT '' NOT NULL,
    category varchar(255) DEFAULT '' NOT NULL,
    corps varchar(255) DEFAULT '' NOT NULL,
    environnement_context text,
);

CREATE TABLE tx_bootstrappackage_accordion_item (
    tx_bootstrappackage_accordion_item_repeater int(11) unsigned DEFAULT '0',
);

CREATE TABLE tx_bootstrappackage_carousel_item (
    tx_carriere_carousel_textadd text,
    button_text_2 varchar(255) DEFAULT '' NOT NULL,
    link_2 varchar(1024) DEFAULT '' NOT NULL,
);

CREATE TABLE tx_bootstrappackage_accordion_item_repeater (
    uid int(11) unsigned NOT NULL auto_increment,
    pid int(11) DEFAULT '0' NOT NULL,

    tt_content int(11) unsigned DEFAULT '0',
    header varchar(255) DEFAULT '' NOT NULL,
    bodytext text,
    media int(11) unsigned DEFAULT '0',
    mediaorient varchar(60) DEFAULT 'left' NOT NULL,
    imagecols tinyint(4) unsigned DEFAULT '1' NOT NULL,
    image_zoom tinyint(3) unsigned DEFAULT '0' NOT NULL,

    tstamp int(11) unsigned DEFAULT '0' NOT NULL,
    crdate int(11) unsigned DEFAULT '0' NOT NULL,
    cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
    deleted smallint unsigned DEFAULT '0' NOT NULL,
    hidden smallint unsigned DEFAULT '0' NOT NULL,
    starttime int(11) unsigned DEFAULT '0' NOT NULL,
    endtime int(11) unsigned DEFAULT '0' NOT NULL,
    sorting int(11) DEFAULT '0' NOT NULL,

    sys_language_uid int(11) DEFAULT '0' NOT NULL,
    l10n_parent int(11) unsigned DEFAULT '0' NOT NULL,
    l10n_diffsource mediumblob NULL,

    t3ver_oid int(11) unsigned DEFAULT '0' NOT NULL,
    t3ver_id int(11) unsigned DEFAULT '0' NOT NULL,
    t3ver_wsid int(11) unsigned DEFAULT '0' NOT NULL,
    t3ver_label varchar(255) DEFAULT '' NOT NULL,
    t3ver_state smallint DEFAULT '0' NOT NULL,
    t3ver_stage int(11) DEFAULT '0' NOT NULL,
    t3ver_count int(11) unsigned DEFAULT '0' NOT NULL,
    t3ver_tstamp int(11) unsigned DEFAULT '0' NOT NULL,
    t3ver_move_id int(11) unsigned DEFAULT '0' NOT NULL,
    t3_origuid int(11) unsigned DEFAULT '0' NOT NULL,

    PRIMARY KEY (uid),
    KEY parent (pid),
    KEY t3ver_oid (t3ver_oid,t3ver_wsid),
    KEY language (l10n_parent,sys_language_uid)
);