<?php

$this->arrMeta = array
(
	'engine' => 'MyISAM',
	'charset' => 'UTF8',
);

$this->arrFields = array
(
	'id' => "int(10) unsigned NOT NULL auto_increment",
	'pid' => "int(10) unsigned NOT NULL default '0'",
	'sorting' => "int(10) unsigned NOT NULL default '0'",
	'tstamp' => "int(10) unsigned NOT NULL default '0'",
	'question' => "varchar(255) NOT NULL default ''",
	'alias' => "varchar(128) COLLATE utf8_bin NOT NULL default ''",
	'author' => "int(10) unsigned NOT NULL default '0'",
	'answer' => "text NULL",
	'addImage' => "char(1) NOT NULL default ''",
	'singleSRC' => "binary(16) NULL",
	'alt' => "varchar(255) NOT NULL default ''",
	'size' => "varchar(64) NOT NULL default ''",
	'imagemargin' => "varchar(128) NOT NULL default ''",
	'imageUrl' => "varchar(255) NOT NULL default ''",
	'fullsize' => "char(1) NOT NULL default ''",
	'caption' => "varchar(255) NOT NULL default ''",
	'floating' => "varchar(12) NOT NULL default ''",
	'addEnclosure' => "char(1) NOT NULL default ''",
	'enclosure' => "blob NULL",
	'noComments' => "char(1) NOT NULL default ''",
	'published' => "char(1) NOT NULL default ''",
	'addRating' => "char(1) NOT NULL default ''",
	'rateit_position' => "varchar(6) NOT NULL default ''",
);

$this->arrOrderFields = array
(
);

$this->arrKeys = array
(
	'id' => 'primary',
	'pid' => 'index',
);

$this->arrRelations = array
(
	'pid' => array
	(
		'table' => 'tl_faq_category',
		'field' => 'id',
		'type' => 'belongsTo',
		'load' => 'eager',
	),
	'author' => array
	(
		'table' => 'tl_user',
		'field' => 'id',
		'type' => 'belongsTo',
		'load' => 'eager',
	),
);

$this->blnIsDbTable = true;
