#
# Table structure for table 'pages'
#
CREATE TABLE pages (
	tx_vendee_base_headerimage int(11) unsigned DEFAULT '0',
  tx_vendee_base_icon int(11) unsigned DEFAULT '0',
);
CREATE TABLE sys_file_reference (
 tx_vendee_base_headerimage_placement tinytext,
);

#
# Table structure for table 'tt_content'
#
CREATE TABLE tt_content (
	colwidth2col int(11) DEFAULT '0' NOT NULL,
	colwidth3col int(11) DEFAULT '0' NOT NULL,
	firstcol int(11) DEFAULT '0' NOT NULL,
	secondcol int(11) DEFAULT '0' NOT NULL,
	thirdcol int(11) DEFAULT '0' NOT NULL,
	fourthcol int(11) DEFAULT '0' NOT NULL,
);

#
# Table structure for table 'tx_news_domain_model_news'
#
CREATE TABLE tx_news_domain_model_news (
	difficulty varchar(30) DEFAULT '' NOT NULL,
	timepiste varchar(30) DEFAULT '' NOT NULL,
	numpiste int(4) DEFAULT '0' NOT NULL,
	descriptionpiste1 mediumtext,
	descriptionpiste2 mediumtext,
	kmtotal decimal(3,1) DEFAULT '0' NOT NULL,
	kmgoudron decimal(3,1) DEFAULT '0' NOT NULL,
	kmsable decimal(3,1) DEFAULT '0' NOT NULL,
	kmchemin decimal(3,1) DEFAULT '0' NOT NULL,
	patrimoine text,
	faune text,
	flore text,
);