CREATE TABLE tt_content (
    tx_contenuintranet_announcesearchresult tinytext,
    tx_contenuintranet_announcesfilter int(11) DEFAULT '0',
    tx_contenuintranet_announceeditionpage tinytext DEFAULT '0',
    tx_contenuintranet_announcemanage tinytext DEFAULT '0',
    tx_contenuintranet_announcelistpage tinytext DEFAULT '0',
    tx_contenuintranet_announcefolders tinytext,
    tx_contenuintranet_announce_popupdelete tinytext,
    tx_contenuintranet_announce_popuphide tinytext,
    tx_contenuintranet_announce_popupshow tinytext,
    tx_contenuintranet_announce_popupdelete_title tinytext,
    tx_contenuintranet_announce_popuphide_title tinytext,
    tx_contenuintranet_announce_popupshow_title tinytext,
    tx_contenuintranet_majmaxresult tinytext,
    tx_contenuintranet_majmonthconfig int(11) unsigned DEFAULT '1' NOT NULL,
    tx_contenuintranet_majpageid tinytext,
    tx_contenuintranet_movmentappearence tinytext,
    tx_contenuintranet_movmentlink tinytext,
    tx_contenuintranet_movmentrepeater int(11) unsigned DEFAULT '0' NOT NULL,
    tx_contenuintranet_pressrepeater int(11) unsigned DEFAULT '0' NOT NULL,
    tx_contenuintranet_statsmaxresult tinytext,
    tx_contenuintranet_statstitle tinytext,
    tx_contenuintranet_statstype tinytext DEFAULT '0',
    tx_contenuintranet_statsrubrique int(11) DEFAULT 0,
    tx_contenuintranet_statslink tinytext,
    tx_contenuintranet_statslinklabel tinytext,
    tx_contenuintranet_majbutton varchar(255),
    tx_contenuintranet_majbuttonid tinytext,
    tx_contenuintranet_pressbuttonlink tinytext,
    tx_contenuintranet_pressbuttontext varchar(255)
);
CREATE TABLE tx_contenuintranet_petitesannonces (
    uid int(11) NOT NULL auto_increment,
    pid int(11) 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 tinyint(4) unsigned DEFAULT '0' NOT NULL,
    hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
    starttime int(11) unsigned DEFAULT '0' NOT NULL,
    endtime int(11) unsigned DEFAULT '0' NOT NULL,
    categories tinytext NOT NULL,
    title varchar(255) DEFAULT '',
    description tinytext DEFAULT '',
    price varchar(255) DEFAULT '',
    price_comp varchar(255) DEFAULT '',
    fe_user int(11) NOT NULL,
    images varchar(1024) DEFAULT '',
    image1 varchar(1024) DEFAULT '',
    image2 varchar(1024) DEFAULT '',
    image3 varchar(1024) DEFAULT '',
    username varchar(255) DEFAULT '',
    useremail varchar(255) DEFAULT '',
    displaymail varchar(255) DEFAULT '',
    personnal_phone varchar(20) DEFAULT '',
    professionnal_phone varchar(20) DEFAULT '',
    duration varchar(20) DEFAULT '7',
    consent tinyint(4) DEFAULT 0,
    suppImage1 text,
    suppImage2 text,
    suppImage3 text,
    PRIMARY KEY (uid),
);
CREATE TABLE tx_contenuintranet_movmentrepeater (
    uid int(11) NOT NULL auto_increment,
    pid int(11) DEFAULT '0' NOT NULL,
    parentid int(11) DEFAULT '0' NOT NULL,
    parenttable varchar(255) DEFAULT '' NOT NULL,
    sorting int(11) unsigned DEFAULT '0' NOT NULL,
    t3ver_oid int(11) unsigned DEFAULT '0' NOT NULL,
    t3ver_id int(11) DEFAULT '0' NOT NULL,
    t3ver_wsid int(11) DEFAULT '0' NOT NULL,
    t3ver_label varchar(255) DEFAULT '' NOT NULL,
    t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
    t3ver_stage int(11) 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,
    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 tinyint(4) unsigned DEFAULT '0' NOT NULL,
    hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
    starttime int(11) unsigned DEFAULT '0' NOT NULL,
    endtime int(11) unsigned 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,
    tx_contenuintranet_movmenttitle tinytext,
    tx_contenuintranet_movmentusers int(11) unsigned DEFAULT '0' NOT NULL,
    tx_contenuintranet_movmentrelation int(11) DEFAULT '0',
    PRIMARY KEY (uid),
    KEY parent (pid),
    KEY t3ver_oid (t3ver_oid,t3ver_wsid),
    KEY language (l10n_parent,sys_language_uid)
);
CREATE TABLE tx_contenuintranet_movmentusers (
    uid int(11) NOT NULL auto_increment,
    pid int(11) DEFAULT '0' NOT NULL,
    parentid int(11) DEFAULT '0' NOT NULL,
    parenttable varchar(255) DEFAULT '' NOT NULL,
    sorting int(11) unsigned DEFAULT '0' NOT NULL,
    t3ver_oid int(11) unsigned DEFAULT '0' NOT NULL,
    t3ver_id int(11) DEFAULT '0' NOT NULL,
    t3ver_wsid int(11) DEFAULT '0' NOT NULL,
    t3ver_label varchar(255) DEFAULT '' NOT NULL,
    t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
    t3ver_stage int(11) 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,
    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 tinyint(4) unsigned DEFAULT '0' NOT NULL,
    hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
    starttime int(11) unsigned DEFAULT '0' NOT NULL,
    endtime int(11) unsigned 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,
    tx_contenuintranet_movmentusersdescription mediumtext,
    tx_contenuintranet_movmentuserstitle tinytext,
    tx_contenuintranet_movmentusersuser int(11) DEFAULT '0' NOT NULL,
    PRIMARY KEY (uid),
    KEY parent (pid),
    KEY t3ver_oid (t3ver_oid,t3ver_wsid),
    KEY language (l10n_parent,sys_language_uid)
);
CREATE TABLE tx_contenuintranet_pressrepeater (
    uid int(11) NOT NULL auto_increment,
    pid int(11) DEFAULT '0' NOT NULL,
    parentid int(11) DEFAULT '0' NOT NULL,
    parenttable varchar(255) DEFAULT '' NOT NULL,
    sorting int(11) unsigned DEFAULT '0' NOT NULL,
    t3ver_oid int(11) unsigned DEFAULT '0' NOT NULL,
    t3ver_id int(11) DEFAULT '0' NOT NULL,
    t3ver_wsid int(11) DEFAULT '0' NOT NULL,
    t3ver_label varchar(255) DEFAULT '' NOT NULL,
    t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
    t3ver_stage int(11) 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,
    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 tinyint(4) unsigned DEFAULT '0' NOT NULL,
    hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
    starttime int(11) unsigned DEFAULT '0' NOT NULL,
    endtime int(11) unsigned 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,
    tx_contenuintranet_presslink tinytext,
    tx_contenuintranet_presslogo int(11) unsigned DEFAULT '0' NOT NULL,
    tx_contenuintranet_presstitle tinytext,
    PRIMARY KEY (uid),
    KEY parent (pid),
    KEY t3ver_oid (t3ver_oid,t3ver_wsid),
    KEY language (l10n_parent,sys_language_uid)
);
