CREATE TABLE tx_vendee_enfance (
    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(100) 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 '' NOT NULL,

    userid varchar(100) DEFAULT '' NULL,
    -- Situation
    datebirth varchar(100) DEFAULT '' NULL,
    approvaltype varchar(100) DEFAULT '' NULL,
    day0to18 varchar(100) DEFAULT '' NULL,
    dayp18m varchar(100) DEFAULT '' NULL,
    dayp24m varchar(100) DEFAULT '' NULL,
    periscol varchar(100) DEFAULT '' NULL,
    vacscol varchar(100) DEFAULT '' NULL,
    datefirstapproval varchar(100) DEFAULT '' NULL,
    datelastapproval varchar(100) DEFAULT '' NULL,
    datenextapproval varchar(100) DEFAULT '' NULL,
    -- Hosting Environment 
    housing varchar(100) DEFAULT '' NULL,
    housingtype varchar(100) DEFAULT '' NULL,
    groundfloor varchar(100) DEFAULT '' NULL,
    floornumber varchar(100) DEFAULT '' NULL,
    elevator varchar(100) DEFAULT '' NULL,
    roomnumber varchar(100) DEFAULT '' NULL,
    area varchar(100) DEFAULT '' NULL,
    privategarden varchar(100) DEFAULT '' NULL,
    court varchar(100) DEFAULT '' NULL,
    environment varchar(100) DEFAULT '' NULL,
    proximitypublicgarden varchar(100) DEFAULT '' NULL,
    proximityschool varchar(100) DEFAULT '' NULL,
    animals varchar(100) DEFAULT '' NULL,
    seatnumberchildren varchar(100) DEFAULT '' NULL,
    babyshell varchar(100) DEFAULT '' NULL,
    carseatnumber varchar(100) DEFAULT '' NULL,
    -- Practical Informations
    familysituation varchar(100) DEFAULT '' NULL,
    childrenlivinghome varchar(100) DEFAULT '' NULL,
    otheradultshome varchar(100) DEFAULT '' NULL,
    childrenreceptionfamilyassistant varchar(100) DEFAULT '' NULL,
    firstimageassmat varchar(150) DEFAULT '' NULL,
    secondimageassmat varchar(150) DEFAULT '' NULL,
    thirdimageassmat varchar(150) DEFAULT '' NULL,
    educationexperience text DEFAULT '' NULL,
    rawhourlysalary varchar(100) DEFAULT '' NULL,
    meals varchar(100) DEFAULT '' NULL,
    snack varchar(100) DEFAULT '' NULL,
    ratesperkilometer varchar(100) DEFAULT '' NULL,
    upto9h varchar(100) DEFAULT '' NULL,
    toylibrary varchar(100) DEFAULT '' NULL,
    library varchar(100) DEFAULT '' NULL,
    shows varchar(100) DEFAULT '' NULL,
    walks varchar(100) DEFAULT '' NULL,
    babybus varchar(100) DEFAULT '' NULL,
    awakeningmorning varchar(100) DEFAULT '' NULL,
    availableallday varchar(100) DEFAULT '' NULL,
    morningfrom varchar(100) DEFAULT '' NULL,
    morningto varchar(100) DEFAULT '' NULL,
    afternoonfrom varchar(100) DEFAULT '' NULL,
    afternoonto varchar(100) DEFAULT '' NULL,
    visibleemail varchar(100) DEFAULT '' NULL,
    notes text DEFAULT '' NULL,
    -- Availabities
    availabletext text DEFAULT '' NULL,
    available varchar(100) DEFAULT '' NULL,
    childrenspecialneeds varchar(100) DEFAULT '' NULL,
    childrenatypicalhours varchar(100) DEFAULT '' NULL,

    PRIMARY KEY (uid),
);