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,
);

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)
);

#
# Bcc
# Table structure for table 'tt_formations_bcc'
#
CREATE TABLE tt_formations_bcc
(
    uid              int(11) unsigned         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,
    t3ver_oid        int(11)      DEFAULT '0' NOT NULL,
    t3ver_id         int(11)      DEFAULT '0' NOT NULL,
    t3ver_wsid       int(11)      DEFAULT '0' NOT NULL,
    t3ver_label      varchar(30)  DEFAULT ''  NOT NULL,
    t3ver_state      tinyint(4)   DEFAULT '0' NOT NULL,
    t3ver_stage      tinyint(4)   DEFAULT '0' NOT NULL,
    t3ver_count      int(11)      DEFAULT '0' NOT NULL,
    t3ver_tstamp     int(11)      DEFAULT '0' NOT NULL,
    t3ver_move_id    int(11)      DEFAULT '0' NOT NULL,
    t3_origuid       int(11)      DEFAULT '0' NOT NULL,
    editlock         tinyint(4)   DEFAULT '0' NOT NULL,
    sys_language_uid int(11)      DEFAULT '0' NOT NULL,
    l10n_parent      int(11)      DEFAULT '0' NOT NULL,
    l10n_diffsource  mediumtext,
    l10n_source      int(11)      DEFAULT '0' NOT NULL,
    deleted          tinyint(4)   DEFAULT '0' NOT NULL,
    hidden           tinyint(4)   DEFAULT '0' NOT NULL,
    starttime        int(11)      DEFAULT '0' NOT NULL,
    endtime          int(11)      DEFAULT '0' NOT NULL,
    sorting          int(11)      DEFAULT '0' NOT NULL,
    fe_group         varchar(100) DEFAULT '0' NOT NULL,

    name             varchar(255) DEFAULT ''  NOT NULL,

    id               int(11) unsigned         NOT NULL,
    libelle          varchar(255) DEFAULT ''  NOT NULL,
    bcc_ues          varchar(255) DEFAULT ''  NOT NULL,
    libelle_en       varchar(255) DEFAULT ''  NOT NULL,

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

#
# Brochure
# Table structure for table 'tt_formations_brochure'
#
CREATE TABLE tt_formations_brochure
(
    uid                                   int(11) unsigned         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,
    t3ver_oid                             int(11)      DEFAULT '0' NOT NULL,
    t3ver_id                              int(11)      DEFAULT '0' NOT NULL,
    t3ver_wsid                            int(11)      DEFAULT '0' NOT NULL,
    t3ver_label                           varchar(30)  DEFAULT ''  NOT NULL,
    t3ver_state                           tinyint(4)   DEFAULT '0' NOT NULL,
    t3ver_stage                           tinyint(4)   DEFAULT '0' NOT NULL,
    t3ver_count                           int(11)      DEFAULT '0' NOT NULL,
    t3ver_tstamp                          int(11)      DEFAULT '0' NOT NULL,
    t3ver_move_id                         int(11)      DEFAULT '0' NOT NULL,
    t3_origuid                            int(11)      DEFAULT '0' NOT NULL,
    editlock                              tinyint(4)   DEFAULT '0' NOT NULL,
    sys_language_uid                      int(11)      DEFAULT '0' NOT NULL,
    l10n_parent                           int(11)      DEFAULT '0' NOT NULL,
    l10n_diffsource                       mediumtext,
    l10n_source                           int(11)      DEFAULT '0' NOT NULL,
    deleted                               tinyint(4)   DEFAULT '0' NOT NULL,
    hidden                                tinyint(4)   DEFAULT '0' NOT NULL,
    starttime                             int(11)      DEFAULT '0' NOT NULL,
    endtime                               int(11)      DEFAULT '0' NOT NULL,
    sorting                               int(11)      DEFAULT '0' NOT NULL,
    fe_group                              varchar(100) DEFAULT '0' NOT NULL,

    name                                  varchar(255) DEFAULT ''  NOT NULL,

    id                                    int(11) unsigned         NOT NULL,
    clef                                  varchar(255) DEFAULT ''  NOT NULL,
    acces                                 text,
    plus_formation                        text,
    competences                           text,
    capacite_accueil                      varchar(255) DEFAULT ''  NOT NULL,
    modalite_candidature                  text,
    brochure_lieu                         varchar(255) DEFAULT ''  NOT NULL,
    calendrier                            text,
    apres_formation                       text,
    insertion_profesionnelle              text,
    lien_externe                          text,
    video                                 text,
    chiffres_cles                         text,
    objectifs                             text,
    disciplines                           text,
    organisation                          text,
    modalite_fi                           text,
    modalite_fa                           text,
    modalite_fc                           text,
    duree                                 text,
    volume_horaire                        text,
    options                               text,
    internationalisation                  text,
    environnement_recherche               text,
    brochure_partenaire_coaccreditation   varchar(255) DEFAULT ''  NOT NULL,
    mots_cles                             text,
    modalites_candidature_titre_url       text,
    modalites_candidature_url             text,
    brochure_modalites                    varchar(255) DEFAULT ''  NOT NULL,
    date_prerentree                       text,
    date_rentree                          text,
    lieux_autres                          text,
    brochure_label                        varchar(255) DEFAULT ''  NOT NULL,
    labels_autres                         text,
    informations_rentree                  text,
    modifications                         text,
    modalites_candidature_url_2           text,
    modalites_candidature_url_3           text,
    contact_formation_1_text              text,
    contact_formation_2_text              text,
    contact_pedagogique_1_text            text,
    contact_pedagogique_2_text            text,
    contact_autre_text                    text,
    fc_tarifs                             text,
    fc_eligibilite_cpf                    text,
    fc_modalite_formation_distance        text,
    fc_temps_travail_personnel            text,
    partenariats_autres                   text,
    brochure_partenariats_institutionnels varchar(255) DEFAULT ''  NOT NULL,
    acces_en                              text,
    plus_formation_en                     text,
    competences_en                        text,
    calendrier_en                         text,
    apres_formation_en                    text,
    insertion_profesionnelle_en           text,
    objectifs_en                          text,
    disciplines_en                        text,
    options_en                            text,
    internationalisation_en               text,
    environnement_recherche_en            text,
    pdf_supplementaire                    text,
    contact_formation_1_text_en           text,
    contact_formation_2_text_en           text,
    contact_pedagogique_1_text_en         text,
    contact_pedagogique_2_text_en         text,

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

#
# Composante
# Table structure for table 'tt_formations_composante'
#
CREATE TABLE tt_formations_composante
(
    uid              int(11) unsigned         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,
    t3ver_oid        int(11)      DEFAULT '0' NOT NULL,
    t3ver_id         int(11)      DEFAULT '0' NOT NULL,
    t3ver_wsid       int(11)      DEFAULT '0' NOT NULL,
    t3ver_label      varchar(30)  DEFAULT ''  NOT NULL,
    t3ver_state      tinyint(4)   DEFAULT '0' NOT NULL,
    t3ver_stage      tinyint(4)   DEFAULT '0' NOT NULL,
    t3ver_count      int(11)      DEFAULT '0' NOT NULL,
    t3ver_tstamp     int(11)      DEFAULT '0' NOT NULL,
    t3ver_move_id    int(11)      DEFAULT '0' NOT NULL,
    t3_origuid       int(11)      DEFAULT '0' NOT NULL,
    editlock         tinyint(4)   DEFAULT '0' NOT NULL,
    sys_language_uid int(11)      DEFAULT '0' NOT NULL,
    l10n_parent      int(11)      DEFAULT '0' NOT NULL,
    l10n_diffsource  mediumtext,
    l10n_source      int(11)      DEFAULT '0' NOT NULL,
    deleted          tinyint(4)   DEFAULT '0' NOT NULL,
    hidden           tinyint(4)   DEFAULT '0' NOT NULL,
    starttime        int(11)      DEFAULT '0' NOT NULL,
    endtime          int(11)      DEFAULT '0' NOT NULL,
    sorting          int(11)      DEFAULT '0' NOT NULL,
    fe_group         varchar(100) DEFAULT '0' NOT NULL,

    name             varchar(255) DEFAULT ''  NOT NULL,

    id               int(11) unsigned         NOT NULL,
    nom              varchar(255) DEFAULT ''  NOT NULL,
    nom_long         varchar(255) DEFAULT ''  NOT NULL,
    logo             varchar(255) DEFAULT ''  NOT NULL,
    rne              varchar(50)  DEFAULT ''  NOT NULL,
    url              varchar(255) DEFAULT ''  NOT NULL,
    nom_long_en      varchar(255) DEFAULT ''  NOT NULL,

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

#
# Diplome
# Table structure for table 'tt_formations_diplome'
#
CREATE TABLE tt_formations_diplome
(
    uid                  int(11) unsigned         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,
    t3ver_oid            int(11)      DEFAULT '0' NOT NULL,
    t3ver_id             int(11)      DEFAULT '0' NOT NULL,
    t3ver_wsid           int(11)      DEFAULT '0' NOT NULL,
    t3ver_label          varchar(30)  DEFAULT ''  NOT NULL,
    t3ver_state          tinyint(4)   DEFAULT '0' NOT NULL,
    t3ver_stage          tinyint(4)   DEFAULT '0' NOT NULL,
    t3ver_count          int(11)      DEFAULT '0' NOT NULL,
    t3ver_tstamp         int(11)      DEFAULT '0' NOT NULL,
    t3ver_move_id        int(11)      DEFAULT '0' NOT NULL,
    t3_origuid           int(11)      DEFAULT '0' NOT NULL,
    editlock             tinyint(4)   DEFAULT '0' NOT NULL,
    sys_language_uid     int(11)      DEFAULT '0' NOT NULL,
    l10n_parent          int(11)      DEFAULT '0' NOT NULL,
    l10n_diffsource      mediumtext,
    l10n_source          int(11)      DEFAULT '0' NOT NULL,
    deleted              tinyint(4)   DEFAULT '0' NOT NULL,
    hidden               tinyint(4)   DEFAULT '0' NOT NULL,
    starttime            int(11)      DEFAULT '0' NOT NULL,
    endtime              int(11)      DEFAULT '0' NOT NULL,
    sorting              int(11)      DEFAULT '0' NOT NULL,
    fe_group             varchar(100) DEFAULT '0' NOT NULL,

    name                 varchar(255) DEFAULT ''  NOT NULL,

    id                   int(11) unsigned         NOT NULL,
    nom                  varchar(255) DEFAULT ''  NOT NULL,
    nombre_semestre      varchar(50)  DEFAULT ''  NOT NULL,
    diplome_type_diplome int(11) unsigned         NOT NULL,
    rncp                 varchar(100) DEFAULT ''  NOT NULL,

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

#
# Domaine
# Table structure for table 'tt_formations_domaine'
#
CREATE TABLE tt_formations_domaine
(
    uid              int(11) unsigned         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,
    t3ver_oid        int(11)      DEFAULT '0' NOT NULL,
    t3ver_id         int(11)      DEFAULT '0' NOT NULL,
    t3ver_wsid       int(11)      DEFAULT '0' NOT NULL,
    t3ver_label      varchar(30)  DEFAULT ''  NOT NULL,
    t3ver_state      tinyint(4)   DEFAULT '0' NOT NULL,
    t3ver_stage      tinyint(4)   DEFAULT '0' NOT NULL,
    t3ver_count      int(11)      DEFAULT '0' NOT NULL,
    t3ver_tstamp     int(11)      DEFAULT '0' NOT NULL,
    t3ver_move_id    int(11)      DEFAULT '0' NOT NULL,
    t3_origuid       int(11)      DEFAULT '0' NOT NULL,
    editlock         tinyint(4)   DEFAULT '0' NOT NULL,
    sys_language_uid int(11)      DEFAULT '0' NOT NULL,
    l10n_parent      int(11)      DEFAULT '0' NOT NULL,
    l10n_diffsource  mediumtext,
    l10n_source      int(11)      DEFAULT '0' NOT NULL,
    deleted          tinyint(4)   DEFAULT '0' NOT NULL,
    hidden           tinyint(4)   DEFAULT '0' NOT NULL,
    starttime        int(11)      DEFAULT '0' NOT NULL,
    endtime          int(11)      DEFAULT '0' NOT NULL,
    sorting          int(11)      DEFAULT '0' NOT NULL,
    fe_group         varchar(100) DEFAULT '0' NOT NULL,

    name             varchar(255) DEFAULT ''  NOT NULL,

    id               int(11) unsigned         NOT NULL,
    libelle          varchar(255) DEFAULT ''  NOT NULL,
    libelle_en       varchar(255) DEFAULT ''  NOT NULL,

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

#
# Ecue
# Table structure for table 'tt_formations_ecue'
#
CREATE TABLE tt_formations_ecue
(
    uid                    int(11) unsigned         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,
    t3ver_oid              int(11)      DEFAULT '0' NOT NULL,
    t3ver_id               int(11)      DEFAULT '0' NOT NULL,
    t3ver_wsid             int(11)      DEFAULT '0' NOT NULL,
    t3ver_label            varchar(30)  DEFAULT ''  NOT NULL,
    t3ver_state            tinyint(4)   DEFAULT '0' NOT NULL,
    t3ver_stage            tinyint(4)   DEFAULT '0' NOT NULL,
    t3ver_count            int(11)      DEFAULT '0' NOT NULL,
    t3ver_tstamp           int(11)      DEFAULT '0' NOT NULL,
    t3ver_move_id          int(11)      DEFAULT '0' NOT NULL,
    t3_origuid             int(11)      DEFAULT '0' NOT NULL,
    editlock               tinyint(4)   DEFAULT '0' NOT NULL,
    sys_language_uid       int(11)      DEFAULT '0' NOT NULL,
    l10n_parent            int(11)      DEFAULT '0' NOT NULL,
    l10n_diffsource        mediumtext,
    l10n_source            int(11)      DEFAULT '0' NOT NULL,
    deleted                tinyint(4)   DEFAULT '0' NOT NULL,
    hidden                 tinyint(4)   DEFAULT '0' NOT NULL,
    starttime              int(11)      DEFAULT '0' NOT NULL,
    endtime                int(11)      DEFAULT '0' NOT NULL,
    sorting                int(11)      DEFAULT '0' NOT NULL,
    fe_group               varchar(100) DEFAULT '0' NOT NULL,

    name                   varchar(255) DEFAULT ''  NOT NULL,

    id                     int(11) unsigned         NOT NULL,
    nom                    varchar(255) DEFAULT ''  NOT NULL,
    ordre                  int(11) unsigned         NOT NULL,
    code_objet             varchar(255) DEFAULT ''  NOT NULL,
    ects                   varchar(255) DEFAULT ''  NOT NULL,
    syllabus               text,
    syllabus_en            text,
    langue                 varchar(255) DEFAULT ''  NOT NULL,
    heures_cm              double,
    heures_td              double,
    heures_tp              double,
    nom_en                 varchar(255) DEFAULT ''  NOT NULL,
    # Détail
    prerequis              text,
    evaluation_cc_ct       text,
    methode_enseignement   text,
    objectif_apprentissage text,
    modalites              text,
    slug                   varchar(255) DEFAULT ''  NOT NULL,

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

#
# Label
# Table structure for table 'tt_formations_label'
#
CREATE TABLE tt_formations_label
(
    uid              int(11) unsigned         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,
    t3ver_oid        int(11)      DEFAULT '0' NOT NULL,
    t3ver_id         int(11)      DEFAULT '0' NOT NULL,
    t3ver_wsid       int(11)      DEFAULT '0' NOT NULL,
    t3ver_label      varchar(30)  DEFAULT ''  NOT NULL,
    t3ver_state      tinyint(4)   DEFAULT '0' NOT NULL,
    t3ver_stage      tinyint(4)   DEFAULT '0' NOT NULL,
    t3ver_count      int(11)      DEFAULT '0' NOT NULL,
    t3ver_tstamp     int(11)      DEFAULT '0' NOT NULL,
    t3ver_move_id    int(11)      DEFAULT '0' NOT NULL,
    t3_origuid       int(11)      DEFAULT '0' NOT NULL,
    editlock         tinyint(4)   DEFAULT '0' NOT NULL,
    sys_language_uid int(11)      DEFAULT '0' NOT NULL,
    l10n_parent      int(11)      DEFAULT '0' NOT NULL,
    l10n_diffsource  mediumtext,
    l10n_source      int(11)      DEFAULT '0' NOT NULL,
    deleted          tinyint(4)   DEFAULT '0' NOT NULL,
    hidden           tinyint(4)   DEFAULT '0' NOT NULL,
    starttime        int(11)      DEFAULT '0' NOT NULL,
    endtime          int(11)      DEFAULT '0' NOT NULL,
    sorting          int(11)      DEFAULT '0' NOT NULL,
    fe_group         varchar(100) DEFAULT '0' NOT NULL,

    name             varchar(255) DEFAULT ''  NOT NULL,

    id               int(11) unsigned         NOT NULL,
    nom              varchar(255) DEFAULT ''  NOT NULL,
    url              varchar(255) DEFAULT ''  NOT NULL,

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

#
# Lieu
# Table structure for table 'tt_formations_lieu'
#
CREATE TABLE tt_formations_lieu
(
    uid              int(11) unsigned         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,
    t3ver_oid        int(11)      DEFAULT '0' NOT NULL,
    t3ver_id         int(11)      DEFAULT '0' NOT NULL,
    t3ver_wsid       int(11)      DEFAULT '0' NOT NULL,
    t3ver_label      varchar(30)  DEFAULT ''  NOT NULL,
    t3ver_state      tinyint(4)   DEFAULT '0' NOT NULL,
    t3ver_stage      tinyint(4)   DEFAULT '0' NOT NULL,
    t3ver_count      int(11)      DEFAULT '0' NOT NULL,
    t3ver_tstamp     int(11)      DEFAULT '0' NOT NULL,
    t3ver_move_id    int(11)      DEFAULT '0' NOT NULL,
    t3_origuid       int(11)      DEFAULT '0' NOT NULL,
    editlock         tinyint(4)   DEFAULT '0' NOT NULL,
    sys_language_uid int(11)      DEFAULT '0' NOT NULL,
    l10n_parent      int(11)      DEFAULT '0' NOT NULL,
    l10n_diffsource  mediumtext,
    l10n_source      int(11)      DEFAULT '0' NOT NULL,
    deleted          tinyint(4)   DEFAULT '0' NOT NULL,
    hidden           tinyint(4)   DEFAULT '0' NOT NULL,
    starttime        int(11)      DEFAULT '0' NOT NULL,
    endtime          int(11)      DEFAULT '0' NOT NULL,
    sorting          int(11)      DEFAULT '0' NOT NULL,
    fe_group         varchar(100) DEFAULT '0' NOT NULL,

    name             varchar(255) DEFAULT ''  NOT NULL,

    id               int(11) unsigned         NOT NULL,
    nom              varchar(255) DEFAULT ''  NOT NULL,
    adresse          varchar(255) DEFAULT ''  NOT NULL,
    gps              varchar(50)  DEFAULT ''  NOT NULL,
    adresse2         varchar(50)  DEFAULT ''  NOT NULL,
    code_postal      varchar(50)  DEFAULT ''  NOT NULL,
    ville            varchar(50)  DEFAULT ''  NOT NULL,

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

#
# Mention
# Table structure for table 'tt_formations_mention'
#
CREATE TABLE tt_formations_mention
(
    uid              int(11) unsigned         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,
    t3ver_oid        int(11)      DEFAULT '0' NOT NULL,
    t3ver_id         int(11)      DEFAULT '0' NOT NULL,
    t3ver_wsid       int(11)      DEFAULT '0' NOT NULL,
    t3ver_label      varchar(30)  DEFAULT ''  NOT NULL,
    t3ver_state      tinyint(4)   DEFAULT '0' NOT NULL,
    t3ver_stage      tinyint(4)   DEFAULT '0' NOT NULL,
    t3ver_count      int(11)      DEFAULT '0' NOT NULL,
    t3ver_tstamp     int(11)      DEFAULT '0' NOT NULL,
    t3ver_move_id    int(11)      DEFAULT '0' NOT NULL,
    t3_origuid       int(11)      DEFAULT '0' NOT NULL,
    editlock         tinyint(4)   DEFAULT '0' NOT NULL,
    sys_language_uid int(11)      DEFAULT '0' NOT NULL,
    l10n_parent      int(11)      DEFAULT '0' NOT NULL,
    l10n_diffsource  mediumtext,
    l10n_source      int(11)      DEFAULT '0' NOT NULL,
    deleted          tinyint(4)   DEFAULT '0' NOT NULL,
    hidden           tinyint(4)   DEFAULT '0' NOT NULL,
    starttime        int(11)      DEFAULT '0' NOT NULL,
    endtime          int(11)      DEFAULT '0' NOT NULL,
    sorting          int(11)      DEFAULT '0' NOT NULL,
    fe_group         varchar(100) DEFAULT '0' NOT NULL,

    name             varchar(255) DEFAULT ''  NOT NULL,

    id               int(11) unsigned         NOT NULL,
    libelle          varchar(255) DEFAULT ''  NOT NULL,
    libelle_en       varchar(255) DEFAULT ''  NOT NULL,

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

#
# Modalite
# Table structure for table 'tt_formations_modalite'
#
CREATE TABLE tt_formations_modalite
(
    uid              int(11) unsigned         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,
    t3ver_oid        int(11)      DEFAULT '0' NOT NULL,
    t3ver_id         int(11)      DEFAULT '0' NOT NULL,
    t3ver_wsid       int(11)      DEFAULT '0' NOT NULL,
    t3ver_label      varchar(30)  DEFAULT ''  NOT NULL,
    t3ver_state      tinyint(4)   DEFAULT '0' NOT NULL,
    t3ver_stage      tinyint(4)   DEFAULT '0' NOT NULL,
    t3ver_count      int(11)      DEFAULT '0' NOT NULL,
    t3ver_tstamp     int(11)      DEFAULT '0' NOT NULL,
    t3ver_move_id    int(11)      DEFAULT '0' NOT NULL,
    t3_origuid       int(11)      DEFAULT '0' NOT NULL,
    editlock         tinyint(4)   DEFAULT '0' NOT NULL,
    sys_language_uid int(11)      DEFAULT '0' NOT NULL,
    l10n_parent      int(11)      DEFAULT '0' NOT NULL,
    l10n_diffsource  mediumtext,
    l10n_source      int(11)      DEFAULT '0' NOT NULL,
    deleted          tinyint(4)   DEFAULT '0' NOT NULL,
    hidden           tinyint(4)   DEFAULT '0' NOT NULL,
    starttime        int(11)      DEFAULT '0' NOT NULL,
    endtime          int(11)      DEFAULT '0' NOT NULL,
    sorting          int(11)      DEFAULT '0' NOT NULL,
    fe_group         varchar(100) DEFAULT '0' NOT NULL,

    name             varchar(255) DEFAULT ''  NOT NULL,

    id               int(11) unsigned         NOT NULL,
    libelle          varchar(255) DEFAULT ''  NOT NULL,
    libelle_long     text,
    libelle_long_en  text,

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

#
# Parcours
# Table structure for table 'tt_formations_parcours'
#
CREATE TABLE tt_formations_parcours
(
    uid                          int(11) unsigned         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,
    t3ver_oid                    int(11)      DEFAULT '0' NOT NULL,
    t3ver_id                     int(11)      DEFAULT '0' NOT NULL,
    t3ver_wsid                   int(11)      DEFAULT '0' NOT NULL,
    t3ver_label                  varchar(30)  DEFAULT ''  NOT NULL,
    t3ver_state                  tinyint(4)   DEFAULT '0' NOT NULL,
    t3ver_stage                  tinyint(4)   DEFAULT '0' NOT NULL,
    t3ver_count                  int(11)      DEFAULT '0' NOT NULL,
    t3ver_tstamp                 int(11)      DEFAULT '0' NOT NULL,
    t3ver_move_id                int(11)      DEFAULT '0' NOT NULL,
    t3_origuid                   int(11)      DEFAULT '0' NOT NULL,
    editlock                     tinyint(4)   DEFAULT '0' NOT NULL,
    sys_language_uid             int(11)      DEFAULT '0' NOT NULL,
    l10n_parent                  int(11)      DEFAULT '0' NOT NULL,
    l10n_diffsource              mediumtext,
    l10n_source                  int(11)      DEFAULT '0' NOT NULL,
    deleted                      tinyint(4)   DEFAULT '0' NOT NULL,
    hidden                       tinyint(4)   DEFAULT '0' NOT NULL,
    starttime                    int(11)      DEFAULT '0' NOT NULL,
    endtime                      int(11)      DEFAULT '0' NOT NULL,
    sorting                      int(11)      DEFAULT '0' NOT NULL,
    fe_group                     varchar(100) DEFAULT '0' NOT NULL,

    name                         varchar(255) DEFAULT ''  NOT NULL,

    id                           int(11) unsigned         NOT NULL,
    titre                        varchar(255) DEFAULT ''  NOT NULL,
    parcours_diplome             varchar(50)  DEFAULT ''  NOT NULL,
    parcours_composante          varchar(50)  DEFAULT ''  NOT NULL,
    parcours_secteurs            varchar(50)  DEFAULT ''  NOT NULL,
    parcours_domaine             varchar(50)  DEFAULT ''  NOT NULL,
    # Détail
    parcours_bccs                varchar(255) DEFAULT ''  NOT NULL,
    parcours_bccs_2eme_semestres varchar(255) DEFAULT ''  NOT NULL,
    url_candidatures             varchar(255) DEFAULT ''  NOT NULL,
    competences                  varchar(255) DEFAULT ''  NOT NULL,
    disciplines                  varchar(255) DEFAULT ''  NOT NULL,
    url_site_institutionnel      text,
    mcc                          text,
    domaine_accreditation        text,
    parcours_brochure            varchar(255) DEFAULT ''  NOT NULL,
    cle_phenix                   varchar(255) DEFAULT ''  NOT NULL,
    niveau_annee                 varchar(255) DEFAULT ''  NOT NULL,
    parcours_mention             varchar(255) DEFAULT ''  NOT NULL,
    titre_en                     varchar(255) DEFAULT ''  NOT NULL,
    slug                         text,
    slug_en                      text,

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

#
# Partenaire
# Table structure for table 'tt_formations_partenaire'
#
CREATE TABLE tt_formations_partenaire
(
    uid              int(11) unsigned         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,
    t3ver_oid        int(11)      DEFAULT '0' NOT NULL,
    t3ver_id         int(11)      DEFAULT '0' NOT NULL,
    t3ver_wsid       int(11)      DEFAULT '0' NOT NULL,
    t3ver_label      varchar(30)  DEFAULT ''  NOT NULL,
    t3ver_state      tinyint(4)   DEFAULT '0' NOT NULL,
    t3ver_stage      tinyint(4)   DEFAULT '0' NOT NULL,
    t3ver_count      int(11)      DEFAULT '0' NOT NULL,
    t3ver_tstamp     int(11)      DEFAULT '0' NOT NULL,
    t3ver_move_id    int(11)      DEFAULT '0' NOT NULL,
    t3_origuid       int(11)      DEFAULT '0' NOT NULL,
    editlock         tinyint(4)   DEFAULT '0' NOT NULL,
    sys_language_uid int(11)      DEFAULT '0' NOT NULL,
    l10n_parent      int(11)      DEFAULT '0' NOT NULL,
    l10n_diffsource  mediumtext,
    l10n_source      int(11)      DEFAULT '0' NOT NULL,
    deleted          tinyint(4)   DEFAULT '0' NOT NULL,
    hidden           tinyint(4)   DEFAULT '0' NOT NULL,
    starttime        int(11)      DEFAULT '0' NOT NULL,
    endtime          int(11)      DEFAULT '0' NOT NULL,
    sorting          int(11)      DEFAULT '0' NOT NULL,
    fe_group         varchar(100) DEFAULT '0' NOT NULL,

    name             varchar(255) DEFAULT ''  NOT NULL,

    id               int(11) unsigned         NOT NULL,
    nom              varchar(255) DEFAULT ''  NOT NULL,
    url              varchar(255) DEFAULT ''  NOT NULL,
    contact          varchar(255) DEFAULT ''  NOT NULL,
    logo             varchar(255) DEFAULT ''  NOT NULL,

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

#
# Secteur
# Table structure for table 'tt_formations_secteur'
#
CREATE TABLE tt_formations_secteur
(
    uid              int(11) unsigned         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,
    t3ver_oid        int(11)      DEFAULT '0' NOT NULL,
    t3ver_id         int(11)      DEFAULT '0' NOT NULL,
    t3ver_wsid       int(11)      DEFAULT '0' NOT NULL,
    t3ver_label      varchar(30)  DEFAULT ''  NOT NULL,
    t3ver_state      tinyint(4)   DEFAULT '0' NOT NULL,
    t3ver_stage      tinyint(4)   DEFAULT '0' NOT NULL,
    t3ver_count      int(11)      DEFAULT '0' NOT NULL,
    t3ver_tstamp     int(11)      DEFAULT '0' NOT NULL,
    t3ver_move_id    int(11)      DEFAULT '0' NOT NULL,
    t3_origuid       int(11)      DEFAULT '0' NOT NULL,
    editlock         tinyint(4)   DEFAULT '0' NOT NULL,
    sys_language_uid int(11)      DEFAULT '0' NOT NULL,
    l10n_parent      int(11)      DEFAULT '0' NOT NULL,
    l10n_diffsource  mediumtext,
    l10n_source      int(11)      DEFAULT '0' NOT NULL,
    deleted          tinyint(4)   DEFAULT '0' NOT NULL,
    hidden           tinyint(4)   DEFAULT '0' NOT NULL,
    starttime        int(11)      DEFAULT '0' NOT NULL,
    endtime          int(11)      DEFAULT '0' NOT NULL,
    sorting          int(11)      DEFAULT '0' NOT NULL,
    fe_group         varchar(100) DEFAULT '0' NOT NULL,

    name             varchar(255) DEFAULT ''  NOT NULL,

    id               int(11) unsigned         NOT NULL,
    libelle          varchar(255) DEFAULT ''  NOT NULL,

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

#
# Type diplome
# Table structure for table 'tt_formations_type_diplome'
#
CREATE TABLE tt_formations_type_diplome
(
    uid              int(11) unsigned         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,
    t3ver_oid        int(11)      DEFAULT '0' NOT NULL,
    t3ver_id         int(11)      DEFAULT '0' NOT NULL,
    t3ver_wsid       int(11)      DEFAULT '0' NOT NULL,
    t3ver_label      varchar(30)  DEFAULT ''  NOT NULL,
    t3ver_state      tinyint(4)   DEFAULT '0' NOT NULL,
    t3ver_stage      tinyint(4)   DEFAULT '0' NOT NULL,
    t3ver_count      int(11)      DEFAULT '0' NOT NULL,
    t3ver_tstamp     int(11)      DEFAULT '0' NOT NULL,
    t3ver_move_id    int(11)      DEFAULT '0' NOT NULL,
    t3_origuid       int(11)      DEFAULT '0' NOT NULL,
    editlock         tinyint(4)   DEFAULT '0' NOT NULL,
    sys_language_uid int(11)      DEFAULT '0' NOT NULL,
    l10n_parent      int(11)      DEFAULT '0' NOT NULL,
    l10n_diffsource  mediumtext,
    l10n_source      int(11)      DEFAULT '0' NOT NULL,
    deleted          tinyint(4)   DEFAULT '0' NOT NULL,
    hidden           tinyint(4)   DEFAULT '0' NOT NULL,
    starttime        int(11)      DEFAULT '0' NOT NULL,
    endtime          int(11)      DEFAULT '0' NOT NULL,
    sorting          int(11)      DEFAULT '0' NOT NULL,
    fe_group         varchar(100) DEFAULT '0' NOT NULL,

    name             varchar(255) DEFAULT ''  NOT NULL,

    id               int(11) unsigned         NOT NULL,
    libelle          varchar(255) DEFAULT ''  NOT NULL,
    libelle_en       varchar(255) DEFAULT ''  NOT NULL,

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

#
# Ue
# Table structure for table 'tt_formations_ue'
#
CREATE TABLE tt_formations_ue
(
    uid                    int(11) unsigned         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,
    t3ver_oid              int(11)      DEFAULT '0' NOT NULL,
    t3ver_id               int(11)      DEFAULT '0' NOT NULL,
    t3ver_wsid             int(11)      DEFAULT '0' NOT NULL,
    t3ver_label            varchar(30)  DEFAULT ''  NOT NULL,
    t3ver_state            tinyint(4)   DEFAULT '0' NOT NULL,
    t3ver_stage            tinyint(4)   DEFAULT '0' NOT NULL,
    t3ver_count            int(11)      DEFAULT '0' NOT NULL,
    t3ver_tstamp           int(11)      DEFAULT '0' NOT NULL,
    t3ver_move_id          int(11)      DEFAULT '0' NOT NULL,
    t3_origuid             int(11)      DEFAULT '0' NOT NULL,
    editlock               tinyint(4)   DEFAULT '0' NOT NULL,
    sys_language_uid       int(11)      DEFAULT '0' NOT NULL,
    l10n_parent            int(11)      DEFAULT '0' NOT NULL,
    l10n_diffsource        mediumtext,
    l10n_source            int(11)      DEFAULT '0' NOT NULL,
    deleted                tinyint(4)   DEFAULT '0' NOT NULL,
    hidden                 tinyint(4)   DEFAULT '0' NOT NULL,
    starttime              int(11)      DEFAULT '0' NOT NULL,
    endtime                int(11)      DEFAULT '0' NOT NULL,
    sorting                int(11)      DEFAULT '0' NOT NULL,
    fe_group               varchar(100) DEFAULT '0' NOT NULL,

    name                   varchar(255) DEFAULT ''  NOT NULL,

    id                     int(11) unsigned         NOT NULL,
    libelle                varchar(255) DEFAULT ''  NOT NULL,
    ue_ecues               varchar(255) DEFAULT ''  NOT NULL,
    code_objet             varchar(255) DEFAULT ''  NOT NULL,
    ects                   varchar(255) DEFAULT ''  NOT NULL,
    syllabus               text,
    langue                 varchar(255) DEFAULT ''  NOT NULL,
    heures_cm              double,
    heures_td              double,
    heures_tp              double,
    prerequis              text,
    ordre                  int(11) unsigned         NOT NULL,
    libelle_en             varchar(255) DEFAULT ''  NOT NULL,
    # Détail
    evalutation_cc_ct      text,
    methode_enseignement   text,
    objectif_apprentissage text,
    modalites              text,
    syllabus_en            text,
    slug                   varchar(255) DEFAULT ''  NOT NULL,

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