<?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'",
	'title' => "varchar(255) NOT NULL default ''",
	'alias' => "varchar(128) COLLATE utf8_bin NOT NULL default ''",
	'author' => "int(10) unsigned NOT NULL default '0'",
	'inColumn' => "varchar(32) NOT NULL default ''",
	'keywords' => "text NULL",
	'showTeaser' => "char(1) NOT NULL default ''",
	'teaserCssID' => "varchar(255) NOT NULL default ''",
	'teaser' => "text NULL",
	'printable' => "varchar(255) NOT NULL default ''",
	'customTpl' => "varchar(64) NOT NULL default ''",
	'protected' => "char(1) NOT NULL default ''",
	'groups' => "blob NULL",
	'guests' => "char(1) NOT NULL default ''",
	'cssID' => "varchar(255) NOT NULL default ''",
	'space' => "varchar(64) NOT NULL default ''",
	'published' => "char(1) NOT NULL default ''",
	'start' => "varchar(10) NOT NULL default ''",
	'stop' => "varchar(10) NOT NULL default ''",
	'addRating' => "char(1) NOT NULL default ''",
	'rateit_position' => "varchar(6) NOT NULL default ''",
	'rateit_template' => "varchar(255) NOT NULL default ''",
	'tags' => "char(1) NOT NULL default ''",
	'tags_showtags' => "char(1) NOT NULL default ''",
	'tags_max_tags' => "smallint(5) unsigned NOT NULL default '0'",
	'tags_relevance' => "char(1) NOT NULL default ''",
	'tags_jumpto' => "smallint(5) unsigned NOT NULL default '0'",
);

$this->arrOrderFields = array
(
);

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

$this->arrRelations = array
(
	'pid' => array
	(
		'table' => 'tl_page',
		'field' => 'id',
		'type' => 'belongsTo',
		'load' => 'lazy',
	),
	'author' => array
	(
		'table' => 'tl_user',
		'field' => 'id',
		'type' => 'hasOne',
		'load' => 'eager',
	),
	'groups' => array
	(
		'table' => 'tl_member_group',
		'field' => 'id',
		'type' => 'hasMany',
		'load' => 'lazy',
	),
);

$this->blnIsDbTable = true;
