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

	uid int(11) NOT NULL auto_increment,
	pid int(11) DEFAULT '0' NOT NULL,

	title varchar(255) DEFAULT '' NOT NULL,
	description mediumtext,
	color varchar(60) DEFAULT '' 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(11) unsigned 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(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,

	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_wseils_domain_model_application'
#
CREATE TABLE tx_wseils_domain_model_application (

	uid int(11) NOT NULL auto_increment,
	pid int(11) DEFAULT '0' NOT NULL,

	title varchar(255) DEFAULT '' NOT NULL,
	description text,
	link varchar(1024) DEFAULT '' NOT NULL,
	icon int(11) unsigned DEFAULT '0' NOT NULL,
	categories 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(11) unsigned DEFAULT '0' NOT NULL,
	external_id int(11) DEFAULT '0',
	is_public int(11) unsigned DEFAULT '0' NOT NULL,
	display_user_link int(11) unsigned 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(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,

	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_wseils_domain_model_application_user_mm'
#
CREATE TABLE tx_wseils_domain_model_application_user_mm (
	uid_local int(11) DEFAULT '0' NOT NULL,
	uid_foreign int(11) DEFAULT '0' NOT NULL,
	favorite tinyint(4) unsigned DEFAULT '0' NOT NULL,
	sorting int(11) DEFAULT '0' NOT NULL,
	KEY uid_local (uid_local),
	KEY uid_foreign (uid_foreign)
);

#
# Table structure for table 'fe_users'
#
CREATE TABLE fe_users (
	related_application int(11) DEFAULT '0',
	related_favorite_application int(11) DEFAULT '0',
	matricule varchar(1024) DEFAULT '',
	service varchar(1024) DEFAULT '',
	zimbra varchar(1024) DEFAULT '',
	manager varchar(1024) DEFAULT '',
	title varchar(255) DEFAULT '',
	cruser_id int(10) UNSIGNED DEFAULT '0',
	lockToDomain varchar(50) COLLATE utf8_unicode_ci DEFAULT '',
	deleted smallint(5) UNSIGNED DEFAULT '0',
	zip varchar(10) COLLATE utf8_unicode_ci DEFAULT '',
	city varchar(50) COLLATE utf8_unicode_ci DEFAULT '',
	country varchar(40) COLLATE utf8_unicode_ci DEFAULT '',
	www varchar(80) COLLATE utf8_unicode_ci DEFAULT '',
	company varchar(80) COLLATE utf8_unicode_ci DEFAULT '',
	lastlogin int(10) UNSIGNED DEFAULT '0',
	is_online int(10) UNSIGNED DEFAULT '0',
	felogin_forgotHash varchar(80) COLLATE utf8_unicode_ci DEFAULT '',
	module_sys_dmail_newsletter smallint(5) UNSIGNED DEFAULT '0',
	module_sys_dmail_category int(10) UNSIGNED DEFAULT '0',
	module_sys_dmail_html smallint(5) UNSIGNED DEFAULT '0',
	middle_name varchar(50) COLLATE utf8_unicode_ci DEFAULT '',
);

#
# Table structure for table 'tx_wseils_statistics'
#
CREATE TABLE tx_wseils_statistics (
	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,
	sorting int(11) DEFAULT '0' NOT NULL,
	page_id int(11) DEFAULT '0' NOT NULL,
	rubrique_id int(11) DEFAULT '0' NOT NULL,
	user tinytext,
	session_id tinytext,

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


ALTER TABLE `tx_wseils_statistics` ADD INDEX `page_id` (`page_id`);
ALTER TABLE `tx_wseils_statistics` ADD INDEX `user` (`user`(100));
ALTER TABLE `tx_wseils_statistics` ADD INDEX `cruser_id` (`cruser_id`);


#
# Table structure for table 'sys_category'
#
CREATE TABLE sys_category (
	data_category_id int(11) DEFAULT '0',
	style tinytext,
);

#
# Table structure for table 'pages'
#
CREATE TABLE pages (
	display_user_link int(11) unsigned DEFAULT '0' NOT NULL,
);

#
# Table structure for table 'tt_content'
#
CREATE TABLE tt_content (
	gridelement_timeslide tinytext,
	tx_mask_text_timeslide tinytext,
	tx_mask_img_timeslide tinytext,
	tx_mask_bornetv_img int(11) DEFAULT '0' NOT NULL,
	tx_mask_video_file int(11) DEFAULT '0' NOT NULL
);

#
# Table structure for table 'sys_file_reference'
#
CREATE TABLE sys_file_reference (
	tx_mask_bornetv_img int(11) DEFAULT '0' NOT NULL,
	tx_mask_video_file int(11) DEFAULT '0' NOT NULL,
    tx_mask_img_nav INT UNSIGNED DEFAULT 0 NOT NULL,
);


#
# Table structure for table 'tx_wseils_favorite'
#
CREATE TABLE tx_wseils_favorite (
	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,
	sorting tinytext,
	page_id tinytext,
	rubrique_id tinytext,
	user_id tinytext,

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