CREATE TABLE tt_content (
    tx_visitecampus_tx_visitcampus_titre_css tinytext,
    tx_visitecampus_tx_visitcampus_audio_audio INT(11) unsigned DEFAULT '0' NOT NULL,
    tx_visitecampus_tx_visitcampus_boitepromo_image INT(11) unsigned DEFAULT '0' NOT NULL,
    tx_visitecampus_tx_visitcampus_boitepromo_repeat_items INT(11) unsigned DEFAULT '0' NOT NULL,
    tx_visitecampus_tx_visitcampus_carte_page_select tinytext,
    tx_visitecampus_tx_visitcampus_lien_contact_lien_label tinytext,
    tx_visitecampus_tx_visitcampus_citation_texte mediumtext,
    tx_visitecampus_tx_visitcampus_enchiffres_apropos_repeat INT(11) unsigned DEFAULT '0' NOT NULL,
    tx_visitecampus_tx_visitcampus_enchiffres_chiffre tinytext,
    tx_visitecampus_tx_visitcampus_enchiffres_texte mediumtext,
    tx_visitecampus_tx_visitcampus_image_image INT(11) unsigned DEFAULT '0' NOT NULL,
    tx_visitecampus_tx_visitcampus_texte_bgrose_rte mediumtext,
    tx_visitecampus_tx_visitcampus_texte_enchiffres_rte mediumtext,
    tx_visitecampus_tx_visitcampus_texte_home_isCard INT(11) unsigned DEFAULT '0' NOT NULL,
    tx_visitecampus_tx_visitcampus_texte_home_rte mediumtext,
    tx_visitecampus_tx_visitcampus_texte_image_bgrose_image INT(11) unsigned DEFAULT '0' NOT NULL,
    tx_visitecampus_tx_visitcampus_texte_image_bgrose_rte mediumtext,
    tx_visitecampus_tx_visitcampus_texte_imagedroite_image INT(11) unsigned DEFAULT '0' NOT NULL,
    tx_visitecampus_tx_visitcampus_texte_imagedroite_texte mediumtext,
    tx_visitecampus_tx_visitcampus_texte_imagegauche_image INT(11) unsigned DEFAULT '0' NOT NULL,
    tx_visitecampus_tx_visitcampus_texte_imagegauche_texte mediumtext,
    tx_visitecampus_tx_visitcampus_texte_pourquoi_site_rte mediumtext,
    tx_visitecampus_tx_visitcampus_textebaspage_rte mediumtext,
    tx_visitecampus_tx_visitcampus_trombinoscope_repeat_items INT(11) unsigned DEFAULT '0' NOT NULL,
    tx_visitecampus_tx_visitcampus_video_css tinytext,
    tx_visitecampus_tx_visitcampus_video_image_placeholder INT(11) unsigned DEFAULT '0' NOT NULL,
    tx_visitecampus_tx_visitcampus_video_video INT(11) unsigned DEFAULT '0' NOT NULL,
    tx_visitecampus_tx_visitcampus_section_select tinytext,
);

CREATE TABLE tx_visitecampus_tx_visitcampus_enchiffres_apropos_repeat (
    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,
    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,

    parentid INT(11) DEFAULT '0' NOT NULL,
    parenttable VARCHAR(255) DEFAULT '' NOT NULL,
    tx_visitecampus_tx_visitcampus_enchiffres_apropos_items_chiffres tinytext,
    tx_visitecampus_tx_visitcampus_enchiffres_apropos_items_rte mediumtext,
    tx_visitecampus_tx_visitcampus_enchiffres_apropos_items_titre tinytext,

    PRIMARY KEY (uid),
    KEY LANGUAGE (l10n_parent,sys_language_uid)
);

CREATE TABLE tx_visitecampus_tx_visitcampus_trombinoscope_repeat_items (
    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,
    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,

    parentid INT(11) DEFAULT '0' NOT NULL,
    parenttable VARCHAR(255) DEFAULT '' NOT NULL,
    tx_visitecampus_tx_visitcampus_trombinoscope_repeat_fonction tinytext,
    tx_visitecampus_tx_visitcampus_trombinoscope_repeat_image INT(11) unsigned DEFAULT '0' NOT NULL,
    tx_visitecampus_tx_visitcampus_trombinoscope_repeat_nom_prenom tinytext,

    PRIMARY KEY (uid),
    KEY LANGUAGE (l10n_parent,sys_language_uid)
);

CREATE TABLE tx_visitecampus_tx_visitcampus_boitepromo_repeat_items (
    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,
    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,

    parentid INT(11) DEFAULT '0' NOT NULL,
    parenttable VARCHAR(255) DEFAULT '' NOT NULL,
    tx_visitecampus_tx_visitcampus_boitepromo_repeat_title tinytext,
    tx_visitecampus_tx_visitcampus_boitepromo_repeat_image INT(11) unsigned DEFAULT '0' NOT NULL,
    tx_visitecampus_tx_visitcampus_boitepromo_repeat_link tinytext,

    PRIMARY KEY (uid),
    KEY LANGUAGE (l10n_parent,sys_language_uid)
);

CREATE TABLE pages (
    tx_visitecampus_carte_data_map_item varchar(255) DEFAULT '' NOT NULL,
    tx_visitecampus_carte_couleur_du_point varchar(255) DEFAULT '' NOT NULL,
    tx_visitecampus_carte_autres_lieu INT(11) DEFAULT '0' NOT NULL,
    tx_visitecampus_carte_coordonnee_du_lieu_x varchar(255) DEFAULT '' NOT NULL,
    tx_visitecampus_carte_coordonnee_du_lieu_y varchar(255) DEFAULT '' NOT NULL,
    tx_visitecampus_carte_coordonnee_du_fond_x varchar(255) DEFAULT '' NOT NULL,
    tx_visitecampus_carte_coordonnee_du_fond_y varchar(255) DEFAULT '' NOT NULL
);