CREATE TABLE tx_ifsttarpublication_publication (
	url varchar(255) DEFAULT '' NOT NULL,
	html text,
	force_tri varchar(255) DEFAULT '' NOT NULL,
	id_hal text
);
#
# Table structure for table 'tx_ifsttar_onglet'
#
CREATE TABLE tx_ifsttar_onglet (
	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,
	type int(11) DEFAULT '0' NOT NULL,
	title text,
	url varchar(255) DEFAULT '' NOT NULL,
	force_tri varchar(255) DEFAULT '' NOT NULL,
	html text,
	texte_libre text,
	user int(11) DEFAULT '0' NOT NULL,

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

CREATE TABLE fe_users (
	slug varchar(2048),
);
CREATE TABLE tx_ifsttar_onglet (
	title_en text,
	url_en varchar(255) DEFAULT '' NOT NULL,
	html_en text,
	texte_libre_en text,
	anglais tinyint(3) DEFAULT '0' NOT NULL,

);
#Champs rajouté par sf register sur l intra
#
# Table structure for table 'fe_users'
#
CREATE TABLE fe_users (
	activated_on int(11) unsigned DEFAULT '0' NOT NULL,

	pseudonym varchar(50) DEFAULT '',
	gender int(11) unsigned DEFAULT '0' NOT NULL,
	date_of_birth int(11) DEFAULT '0' NOT NULL,
	language char(2) DEFAULT '' NOT NULL,
	zone varchar(45) DEFAULT '' NOT NULL,
	static_info_country char(3) DEFAULT '' NOT NULL,
	timezone float DEFAULT '0' NOT NULL,
	daylight tinyint(4) unsigned DEFAULT '0' NOT NULL,
	mobilephone varchar(20) DEFAULT '' NOT NULL,
	gtc tinyint(4) unsigned DEFAULT '0' NOT NULL,
	privacy tinyint(4) unsigned DEFAULT '0' NOT NULL,
	status int(11) unsigned DEFAULT '0' NOT NULL,
	by_invitation tinyint(4) unsigned DEFAULT '0' NOT NULL,
	comments text,
	module_sys_dmail_newsletter tinyint(3) unsigned DEFAULT '0' NOT NULL,
	module_sys_dmail_html tinyint(3) unsigned DEFAULT '0' NOT NULL,
	module_sys_dmail_category text,
	email_new varchar(254) DEFAULT '' NOT NULL,
	invitation_email varchar(254) DEFAULT '' NOT NULL,
	display_cnu int(11) DEFAULT '0' NOT NULL,
    display_hceres int(11) DEFAULT '0' NOT NULL,
    display_mc int(11) DEFAULT '0' NOT NULL,

	lightTheme  tinyint(1) DEFAULT '0' NOT NULL,
    tx_ifsttar_application_supp_student mediumtext,
    school mediumtext,
	roles mediumtext,
    libelle_etape varchar(255) DEFAULT '' NOT NULL
);


#
# Table structure for table 'fe_groups'
#
CREATE TABLE fe_groups (
	felogin_redirectPid tinytext
);
