#
# Table structure for table 'tt_content'
#
CREATE TABLE tt_content (
    carousel_imageType varchar(255) DEFAULT '' NOT NULL,
    carousel_imgPattern varchar(255) DEFAULT '' NOT NULL,
    carousel_imgPattern_opacity varchar(255) DEFAULT '' NOT NULL,
    carousel_textBgColor varchar(255) DEFAULT '' NOT NULL,
    carousel_textPattern varchar(255) DEFAULT '' NOT NULL,
    carousel_bgColor varchar(255) DEFAULT '' NOT NULL,
    textpic_textBgColor varchar(255) DEFAULT '' NOT NULL,
    textpic_textPattern varchar(255) DEFAULT '' NOT NULL,
    textpic_textLink varchar(255) DEFAULT '' NOT NULL,
    textpic_link varchar(1024) DEFAULT '' NOT NULL,
    tx_wseilsusine_fiches_events_products_projects_axe tinytext,
	tx_wseilsusine_fiches_events_products_projects_filternature int(11) unsigned DEFAULT '0' NOT NULL,
    tx_wseilsusine_fiches_events_products_projects_category tinytext,
    tx_wseilsusine_fiches_events_products_projects_lab_name tinytext,
    tx_wseilsusine_fiches_events_products_projects_porteur tinytext,
    tx_wseilsusine_fiches_events_products_projects_state tinytext,
    tx_wseilsusine_fiches_events_products_projects_tri tinytext,
    tx_wseilsusine_fiches_events_products_projects_type_fiche tinytext,
    tx_wseilsusine_fiches_events_products_projects_year_max date,
    tx_wseilsusine_fiches_events_products_projects_year_min date,
	tx_wseilsusine_fiches_events_products_projects_filterkeywords int(11) unsigned DEFAULT '0' NOT NULL,
    tx_wseilsusine_localisation_building_name tinytext,
	tx_wseilsusine_fiches_events_products_projects_campagne tinytext,
    quote_author_function varchar(255) DEFAULT '' NOT NULL,
    quote_picture int(11) unsigned DEFAULT '0' NOT NULL,
    tx_wseilsusine_keynumber_repeater int(11) unsigned DEFAULT '0' NOT NULL,
    tx_wseilsusine_keynumber_selectsize tinytext,
    picture_number tinytext,
    tx_wseilsusine_external_link_bloc_description mediumtext,
    tx_wseilsusine_external_link_bloc_label_link tinytext,
    tx_wseilsusine_trombinoscope_mixte_repeater int(11) unsigned DEFAULT '0' NOT NULL,
    tx_wseilsusine_trombinoscope_mixte_view_type tinytext,
    tx_wseilsusine_trombinoscope_mixte_tri int(11) DEFAULT '0',
    tx_wseilsusine_trombinoscope_mixte_recherche int(11) DEFAULT '0',
    tx_wseilsusine_formation_list_repeater int(11) unsigned DEFAULT '0' NOT NULL,
    tx_wseilsusine_formation_list_title tinytext,
    tx_wseilsusine_linkpagepro tinytext,
    tx_wseilsusine_cities int(11) unsigned DEFAULT '0' NOT NULL,
    tx_wseilsusine_countries int(11) unsigned DEFAULT '0' NOT NULL,
    tx_wseilsusine_depart int(11) unsigned DEFAULT '0' NOT NULL,
    tx_wseilsusine_mapconf tinytext,
    tx_wseilsusine_mapview tinytext,
    tx_wseilsusine_legend tinytext,
    tx_wseilsusine_halpublications_collectionstampons tinytext,
    tx_wseilsusine_halpublications_criteretri tinytext,
    tx_wseilsusine_halpublications_displayfields tinytext,
    tx_wseilsusine_halpublications_publicationtype tinytext,
    tx_wseilsusine_halpublications_startyear varchar(4) DEFAULT '' NOT NULL,
	tx_wseilsusine_halpublications_endyear varchar(4) DEFAULT '' NOT NULL,
    tx_wseilsusine_halpublications_structure tinytext,
	tx_wseilsusine_halpublications_halid tinytext,
	tx_wseilsusine_halpublications_collection tinytext
);

#
# Table structure for table 'tx_ifsttarpublication_publication'
#
CREATE TABLE tx_ifsttarpublication_publication (
	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,
	sorting int(10) 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,
	title_publication text,
	title_publication_en text,
	type int(11) DEFAULT '0' NOT NULL,
	typedocument text,
	typeaffichage int(11) DEFAULT '0' NOT NULL,
	auteur text,
	departementlaboratoire tinytext,
	contrat tinytext,
	tri int(11) DEFAULT '0' NOT NULL,
	texte_libre text,
	texte_libre_en text,
	anglais tinyint(3) DEFAULT '0' NOT NULL,
	anneemin tinytext,
	anneemax tinytext,
	reference_madis tinytext,
	user int(11) DEFAULT '0' NOT NULL,

	PRIMARY KEY (uid),
	KEY parent (pid)
);
#
# Table structure for table 'tx_ifsttarpublicationsiteintegre_publicationSiteIntegre'
#
CREATE TABLE tx_ifsttarpublicationsiteintegre_publicationSiteIntegre (
	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,
	sorting int(10) 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,
	title_publication text,
	title_publication_en text,
	type int(11) DEFAULT '0' NOT NULL,
	typedocument text,
	typeaffichage int(11) DEFAULT '0' NOT NULL,
	auteur text,
	departementlaboratoire tinytext,
	contrat tinytext,
	tri int(11) DEFAULT '0' NOT NULL,
	texte_libre text,
	texte_libre_en text,
	anglais tinyint(3) DEFAULT '0' NOT NULL,
	anneemin tinytext,
	anneemax tinytext,
	reference_madis tinytext,

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

#
# Table structure for table 'tx_ifsttarph2_categorie'
#
CREATE TABLE tx_ifsttarph2_categorie (
	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,
	deleted tinyint(4) DEFAULT '0' NOT NULL,
	hidden tinyint(4) DEFAULT '0' NOT NULL,
	titre tinytext,
	type int(11) DEFAULT '0' NOT NULL,

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

#
# Table structure for table 'tx_ifsttarph2_projet_evenement'
#
CREATE TABLE tx_ifsttarph2_projet_evenement (
	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,
	deleted tinyint(4) DEFAULT '0' NOT NULL,
	hidden tinyint(4) DEFAULT '0' NOT NULL,
	id_dossier int(11) DEFAULT '0' NOT NULL,
	titre varchar(255) DEFAULT '' NOT NULL,
	activite_recherche int(11) DEFAULT '0' NOT NULL,
	nature varchar(255) DEFAULT '' NOT NULL,
	service_porteur varchar(255) DEFAULT '' NOT NULL,
	axe int(11) DEFAULT '0' NOT NULL,
	date_debut int(11) DEFAULT '0' NOT NULL,
	etat varchar(255) DEFAULT '' NOT NULL,
	porteur int(11) DEFAULT '0' NOT NULL,
	coporteur varchar(255) DEFAULT '' NOT NULL,
	description_courte_dissemination text,
	resume text,
	site_web varchar(255) DEFAULT '' NOT NULL,
	titre_campagne varchar(255) DEFAULT '' NOT NULL,
	date_fin int(11) DEFAULT '0' NOT NULL,
	mots_cles text,

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

#
# Table structure for table 'tx_ifsttarph2_consentement'
#
CREATE TABLE tx_ifsttarph2_consentement (
	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,
	deleted tinyint(4) DEFAULT '0' NOT NULL,
	hidden tinyint(4) DEFAULT '0' NOT NULL,
	email varchar(255) DEFAULT '' NOT NULL,
	role varchar(255) DEFAULT '' NOT NULL,
	id_dossier int(11) DEFAULT '0' NOT NULL,
	consentement varchar(255) DEFAULT '' NOT NULL,

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

# Table structure for table 'tx_news_domain_model_news '
#
CREATE TABLE tx_news_domain_model_news (
  event_start int(11) unsigned DEFAULT '0',
);

#
# Table structure for table 'tx_wseilsusine_trombinoscope_mixte_repeater'
#
CREATE TABLE tx_wseilsusine_trombinoscope_mixte_repeater (
    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,
	sorting int(10) DEFAULT '0' NOT NULL,

    tx_wseilsusine_trombinoscope_mixte_repeater_user_select tinytext,
    tx_wseilsusine_trombinoscope_mixte_repeater_email tinytext,
    tx_wseilsusine_trombinoscope_mixte_repeater_function tinytext,
    tx_wseilsusine_trombinoscope_mixte_repeater_mobile tinytext,
    tx_wseilsusine_trombinoscope_mixte_repeater_name tinytext,
    tx_wseilsusine_trombinoscope_mixte_repeater_organisation tinytext,
    tx_wseilsusine_trombinoscope_mixte_repeater_localisation tinytext,
    tx_wseilsusine_trombinoscope_mixte_repeater_phone tinytext,
    tx_wseilsusine_trombinoscope_mixte_repeater_picture int(11) unsigned DEFAULT '0' NOT NULL,
    tx_wseilsusine_trombinoscope_mixte_repeater_surname tinytext,
    tx_wseilsusine_trombinoscope_mixte_repeater_url_detail tinytext,
    tx_wseilsusine_trombinoscope_mixte_repeater_presentation mediumtext,
    tx_wseilsusine_trombinoscope_mixte_repeater_view_list tinytext,
    title tinytext,

    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(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,

	sys_language_uid int(11) DEFAULT '0' NOT NULL,
	l10n_parent int(11) DEFAULT '0' NOT NULL,
	l10n_diffsource mediumblob,
    parentid int(11) DEFAULT '0' NOT NULL,
    parenttable varchar(255) DEFAULT '' NOT NULL,

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

#
# Table structure for table 'tx_wseilsusine_localisation'
#
CREATE TABLE tx_wseilsusine_localisation (

	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,
	sorting int(10) DEFAULT '0' NOT NULL,

	title tinytext,
	picture int(11) unsigned DEFAULT '0' NOT NULL,
    files int(11) DEFAULT '0' NOT NULL,
    adress1 varchar(255) DEFAULT '' NOT NULL,
    adress2 varchar(255) DEFAULT '' NOT NULL,
    adress3 varchar(255) DEFAULT '' NOT NULL,
    url tinytext,
    longitude tinytext,
    latitude tinytext,

	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(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,

	sys_language_uid int(11) DEFAULT '0' NOT NULL,
	l10n_parent int(11) DEFAULT '0' NOT NULL,
	l10n_diffsource mediumblob,
    parentid int(11) DEFAULT '0' NOT NULL,
    parenttable varchar(255) DEFAULT '' NOT NULL,

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

#
# Table structure for table 'tx_wseilsusine_keynumber_repeater'
#
CREATE TABLE tx_wseilsusine_keynumber_repeater (
    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,
	sorting int(10) DEFAULT '0' NOT NULL,

    tx_wseilsusine_keynumber_label tinytext,
    tx_wseilsusine_keynumber_unit tinytext,
    tx_wseilsusine_keynumber_number tinytext,

    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(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,

	sys_language_uid int(11) DEFAULT '0' NOT NULL,
	l10n_parent int(11) DEFAULT '0' NOT NULL,
	l10n_diffsource mediumblob,
    parentid int(11) DEFAULT '0' NOT NULL,
    parenttable varchar(255) DEFAULT '' NOT NULL,

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

#
# Table structure for table 'tx_wseilsusine_formations'
#
CREATE TABLE tx_wseilsusine_formations (

	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,
	sorting int(10) DEFAULT '0' NOT NULL,

	title tinytext,
    color tinytext,

	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(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,

	sys_language_uid int(11) DEFAULT '0' NOT NULL,
	l10n_parent int(11) DEFAULT '0' NOT NULL,
	l10n_diffsource mediumblob,
    parentid int(11) DEFAULT '0' NOT NULL,
    parenttable varchar(255) DEFAULT '' NOT NULL,

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

#
# Table structure for table 'tx_wseilsusine_formation_list_repeater'
#
CREATE TABLE tx_wseilsusine_formation_list_repeater (
    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,
	sorting int(10) DEFAULT '0' NOT NULL,

    tx_wseilsusine_formation_list_repeater_level_select tinytext,
    tx_wseilsusine_formation_list_repeater_link tinytext,
    tx_wseilsusine_formation_list_repeater_title tinytext,
    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(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,

	sys_language_uid int(11) DEFAULT '0' NOT NULL,
	l10n_parent int(11) DEFAULT '0' NOT NULL,
	l10n_diffsource mediumblob,
    parentid int(11) DEFAULT '0' NOT NULL,
    parenttable varchar(255) DEFAULT '' NOT NULL,

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

#
# Surcharge table structure for table 'tx_sfbooks_domain_model_book'
#
CREATE TABLE tx_sfbooks_domain_model_book (
    cover        blob,
    cover_large  blob,
    sample_pdf   blob,
);

#
# Surcharge table structure for table 'tx_bootstrappackage_carousel_item'
#
CREATE TABLE tx_bootstrappackage_carousel_item (
    hide_title tinyint(4) DEFAULT '0' NOT NULL
);

CREATE TABLE tx_wseilsusine_cities (
    parentid int(11) DEFAULT '0' NOT NULL,
    parenttable varchar(255) DEFAULT '' NOT NULL,
    sorting int(11) unsigned DEFAULT '0' NOT NULL,
    tx_wseilsusine_lat double(11,2) DEFAULT '0.00' NOT NULL,
    tx_wseilsusine_long double(11,2) DEFAULT '0.00' NOT NULL,
    tx_wseilsusine_name tinytext,
    KEY language (l10n_parent,sys_language_uid)
);
CREATE TABLE tx_wseilsusine_countries (
    parentid int(11) DEFAULT '0' NOT NULL,
    parenttable varchar(255) DEFAULT '' NOT NULL,
    sorting int(11) unsigned DEFAULT '0' NOT NULL,
    tx_wseilsusine_code tinytext,
    tx_wseilsusine_value tinytext,
    KEY language (l10n_parent,sys_language_uid)
);
CREATE TABLE tx_wseilsusine_depart (
    parentid int(11) DEFAULT '0' NOT NULL,
    parenttable varchar(255) DEFAULT '' NOT NULL,
    sorting int(11) unsigned DEFAULT '0' NOT NULL,
    tx_wseilsusine_numb tinytext,
    tx_wseilsusine_value tinytext,
    KEY language (l10n_parent,sys_language_uid)
);
CREATE TABLE tx_wseilsusine_mapview (
    parentid int(11) DEFAULT '0' NOT NULL,
    parenttable varchar(255) DEFAULT '' NOT NULL,
    sorting int(11) unsigned DEFAULT '0' NOT NULL,
    tx_wseilsusine_cities int(11) unsigned DEFAULT '0' NOT NULL,
    tx_wseilsusine_lat double(11,2) DEFAULT '0.00' NOT NULL,
    tx_wseilsusine_name tinytext,
    KEY language (l10n_parent,sys_language_uid)
);


#
# Surcharge table structure for table 'pages'
#
CREATE TABLE pages (
    tx_wseils_bannerbutton tinyint(3) DEFAULT '0' NOT NULL,
    addThis tinyint(1) DEFAULT '0' NOT NULL,
);

#
# Table structure for table 'tx_wseilsusine_documentationlink'
#
CREATE TABLE tx_wseilsusine_documentationlink (
    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 '' NOT NULL,

    ctype varchar(255) DEFAULT '' NOT NULL,
	documentationlink varchar(255) DEFAULT '' NOT NULL,

    PRIMARY KEY (uid),
    KEY parent (pid),
    KEY sys_language_uid_l10n_parent (sys_language_uid,l10n_parent)
);