core/model/modx/sqlsrv/modresource.map.inc.php
<?php
/**
* @package modx
* @subpackage sqlsrv
*/
$xpdo_meta_map['modResource']= array (
'package' => 'modx',
'version' => '1.1',
'table' => 'site_content',
'extends' => 'modAccessibleSimpleObject',
'inherit' => 'single',
'fields' =>
array (
'type' => 'document',
'contentType' => 'text/html',
'pagetitle' => '',
'longtitle' => '',
'description' => '',
'alias' => '',
'alias_visible' => 1,
'link_attributes' => '',
'published' => 0,
'pub_date' => 0,
'unpub_date' => 0,
'parent' => 0,
'isfolder' => 0,
'introtext' => NULL,
'content' => NULL,
'richtext' => 1,
'template' => 0,
'menuindex' => 0,
'searchable' => 1,
'cacheable' => 1,
'createdby' => 0,
'createdon' => 0,
'editedby' => 0,
'editedon' => 0,
'deleted' => 0,
'deletedon' => 0,
'deletedby' => 0,
'publishedon' => 0,
'publishedby' => 0,
'menutitle' => '',
'donthit' => 0,
'privateweb' => 0,
'privatemgr' => 0,
'content_dispo' => 0,
'hidemenu' => 0,
'class_key' => 'modDocument',
'context_key' => 'web',
'content_type' => 1,
'uri' => '',
'uri_override' => 0,
'hide_children_in_tree' => 0,
'show_in_tree' => 1,
'properties' => NULL,
),
'fieldMeta' =>
array (
'type' =>
array (
'dbtype' => 'nvarchar',
'precision' => '20',
'phptype' => 'string',
'null' => false,
'default' => 'document',
),
'contentType' =>
array (
'dbtype' => 'nvarchar',
'precision' => '50',
'phptype' => 'string',
'null' => false,
'default' => 'text/html',
),
'pagetitle' =>
array (
'dbtype' => 'nvarchar',
'precision' => '255',
'phptype' => 'string',
'null' => false,
'default' => '',
'index' => 'fulltext',
'indexgrp' => 'content_ft_idx',
),
'longtitle' =>
array (
'dbtype' => 'nvarchar',
'precision' => '255',
'phptype' => 'string',
'null' => false,
'default' => '',
'index' => 'fulltext',
'indexgrp' => 'content_ft_idx',
),
'description' =>
array (
'dbtype' => 'nvarchar',
'precision' => 'max',
'phptype' => 'string',
'null' => false,
'default' => '',
'index' => 'fulltext',
'indexgrp' => 'content_ft_idx',
),
'alias' =>
array (
'dbtype' => 'nvarchar',
'precision' => '255',
'phptype' => 'string',
'null' => true,
'default' => '',
'index' => 'index',
),
'alias_visible' =>
array (
'dbtype' => 'bit',
'phptype' => 'boolean',
'null' => false,
'default' => 1,
),
'link_attributes' =>
array (
'dbtype' => 'nvarchar',
'precision' => '255',
'phptype' => 'string',
'null' => false,
'default' => '',
),
'published' =>
array (
'dbtype' => 'bit',
'phptype' => 'boolean',
'null' => false,
'default' => 0,
'index' => 'index',
),
'pub_date' =>
array (
'dbtype' => 'bigint',
'phptype' => 'timestamp',
'null' => false,
'default' => 0,
'index' => 'index',
),
'unpub_date' =>
array (
'dbtype' => 'bigint',
'phptype' => 'timestamp',
'null' => false,
'default' => 0,
'index' => 'index',
),
'parent' =>
array (
'dbtype' => 'int',
'phptype' => 'integer',
'null' => false,
'default' => 0,
'index' => 'index',
),
'isfolder' =>
array (
'dbtype' => 'bit',
'phptype' => 'boolean',
'null' => false,
'default' => 0,
'index' => 'index',
),
'introtext' =>
array (
'dbtype' => 'nvarchar',
'precision' => 'max',
'phptype' => 'string',
'index' => 'fulltext',
'indexgrp' => 'content_ft_idx',
),
'content' =>
array (
'dbtype' => 'nvarchar',
'precision' => 'max',
'phptype' => 'string',
'index' => 'fulltext',
'indexgrp' => 'content_ft_idx',
),
'richtext' =>
array (
'dbtype' => 'bit',
'phptype' => 'boolean',
'null' => false,
'default' => 1,
),
'template' =>
array (
'dbtype' => 'int',
'phptype' => 'integer',
'null' => false,
'default' => 0,
'index' => 'index',
),
'menuindex' =>
array (
'dbtype' => 'int',
'phptype' => 'integer',
'null' => false,
'default' => 0,
'index' => 'index',
),
'searchable' =>
array (
'dbtype' => 'bit',
'phptype' => 'boolean',
'null' => false,
'default' => 1,
'index' => 'index',
),
'cacheable' =>
array (
'dbtype' => 'bit',
'phptype' => 'boolean',
'null' => false,
'default' => 1,
'index' => 'index',
),
'createdby' =>
array (
'dbtype' => 'int',
'phptype' => 'integer',
'null' => false,
'default' => 0,
),
'createdon' =>
array (
'dbtype' => 'bigint',
'phptype' => 'timestamp',
'null' => false,
'default' => 0,
),
'editedby' =>
array (
'dbtype' => 'int',
'phptype' => 'integer',
'null' => false,
'default' => 0,
),
'editedon' =>
array (
'dbtype' => 'bigint',
'phptype' => 'timestamp',
'null' => false,
'default' => 0,
),
'deleted' =>
array (
'dbtype' => 'bit',
'phptype' => 'boolean',
'null' => false,
'default' => 0,
),
'deletedon' =>
array (
'dbtype' => 'bigint',
'phptype' => 'timestamp',
'null' => false,
'default' => 0,
),
'deletedby' =>
array (
'dbtype' => 'int',
'phptype' => 'integer',
'null' => false,
'default' => 0,
),
'publishedon' =>
array (
'dbtype' => 'bigint',
'phptype' => 'timestamp',
'null' => false,
'default' => 0,
),
'publishedby' =>
array (
'dbtype' => 'int',
'phptype' => 'integer',
'null' => false,
'default' => 0,
),
'menutitle' =>
array (
'dbtype' => 'nvarchar',
'precision' => '255',
'phptype' => 'string',
'null' => false,
'default' => '',
),
'donthit' =>
array (
'dbtype' => 'bit',
'phptype' => 'boolean',
'null' => false,
'default' => 0,
),
'privateweb' =>
array (
'dbtype' => 'bit',
'phptype' => 'boolean',
'null' => false,
'default' => 0,
),
'privatemgr' =>
array (
'dbtype' => 'bit',
'phptype' => 'boolean',
'null' => false,
'default' => 0,
),
'content_dispo' =>
array (
'dbtype' => 'tinyint',
'precision' => '1',
'phptype' => 'integer',
'null' => false,
'default' => 0,
),
'hidemenu' =>
array (
'dbtype' => 'bit',
'phptype' => 'boolean',
'null' => false,
'default' => 0,
'index' => 'index',
),
'class_key' =>
array (
'dbtype' => 'nvarchar',
'precision' => '100',
'phptype' => 'string',
'null' => false,
'default' => 'modDocument',
'index' => 'index',
),
'context_key' =>
array (
'dbtype' => 'nvarchar',
'precision' => '100',
'phptype' => 'string',
'null' => false,
'default' => 'web',
'index' => 'index',
),
'content_type' =>
array (
'dbtype' => 'int',
'phptype' => 'integer',
'null' => false,
'default' => 1,
),
'uri' =>
array (
'dbtype' => 'nvarchar',
'precision' => '1000',
'phptype' => 'string',
'null' => false,
'default' => '',
'index' => 'index',
),
'uri_override' =>
array (
'dbtype' => 'bit',
'phptype' => 'boolean',
'null' => false,
'default' => 0,
'index' => 'index',
),
'hide_children_in_tree' =>
array (
'dbtype' => 'bit',
'phptype' => 'boolean',
'null' => false,
'default' => 0,
'index' => 'index',
),
'show_in_tree' =>
array (
'dbtype' => 'bit',
'phptype' => 'boolean',
'null' => false,
'default' => 1,
'index' => 'index',
),
'properties' =>
array (
'dbtype' => 'nvarchar',
'precision' => 'max',
'phptype' => 'json',
'null' => true,
),
),
'indexes' =>
array (
'alias' =>
array (
'alias' => 'alias',
'primary' => false,
'unique' => false,
'type' => 'BTREE',
'columns' =>
array (
'alias' =>
array (
'length' => '',
'collation' => 'A',
'null' => true,
),
),
),
'published' =>
array (
'alias' => 'published',
'primary' => false,
'unique' => false,
'type' => 'BTREE',
'columns' =>
array (
'published' =>
array (
'length' => '',
'collation' => 'A',
'null' => false,
),
),
),
'pub_date' =>
array (
'alias' => 'pub_date',
'primary' => false,
'unique' => false,
'type' => 'BTREE',
'columns' =>
array (
'pub_date' =>
array (
'length' => '',
'collation' => 'A',
'null' => false,
),
),
),
'unpub_date' =>
array (
'alias' => 'unpub_date',
'primary' => false,
'unique' => false,
'type' => 'BTREE',
'columns' =>
array (
'unpub_date' =>
array (
'length' => '',
'collation' => 'A',
'null' => false,
),
),
),
'parent' =>
array (
'alias' => 'parent',
'primary' => false,
'unique' => false,
'type' => 'BTREE',
'columns' =>
array (
'parent' =>
array (
'length' => '',
'collation' => 'A',
'null' => false,
),
),
),
'isfolder' =>
array (
'alias' => 'isfolder',
'primary' => false,
'unique' => false,
'type' => 'BTREE',
'columns' =>
array (
'isfolder' =>
array (
'length' => '',
'collation' => 'A',
'null' => false,
),
),
),
'template' =>
array (
'alias' => 'template',
'primary' => false,
'unique' => false,
'type' => 'BTREE',
'columns' =>
array (
'template' =>
array (
'length' => '',
'collation' => 'A',
'null' => false,
),
),
),
'menuindex' =>
array (
'alias' => 'menuindex',
'primary' => false,
'unique' => false,
'type' => 'BTREE',
'columns' =>
array (
'menuindex' =>
array (
'length' => '',
'collation' => 'A',
'null' => false,
),
),
),
'searchable' =>
array (
'alias' => 'searchable',
'primary' => false,
'unique' => false,
'type' => 'BTREE',
'columns' =>
array (
'searchable' =>
array (
'length' => '',
'collation' => 'A',
'null' => false,
),
),
),
'cacheable' =>
array (
'alias' => 'cacheable',
'primary' => false,
'unique' => false,
'type' => 'BTREE',
'columns' =>
array (
'cacheable' =>
array (
'length' => '',
'collation' => 'A',
'null' => false,
),
),
),
'hidemenu' =>
array (
'alias' => 'hidemenu',
'primary' => false,
'unique' => false,
'type' => 'BTREE',
'columns' =>
array (
'hidemenu' =>
array (
'length' => '',
'collation' => 'A',
'null' => false,
),
),
),
'class_key' =>
array (
'alias' => 'class_key',
'primary' => false,
'unique' => false,
'type' => 'BTREE',
'columns' =>
array (
'class_key' =>
array (
'length' => '',
'collation' => 'A',
'null' => false,
),
),
),
'context_key' =>
array (
'alias' => 'context_key',
'primary' => false,
'unique' => false,
'type' => 'BTREE',
'columns' =>
array (
'context_key' =>
array (
'length' => '',
'collation' => 'A',
'null' => false,
),
),
),
'uri' =>
array (
'alias' => 'uri',
'primary' => false,
'unique' => false,
'type' => 'BTREE',
'columns' =>
array (
'uri' =>
array (
'length' => '1000',
'collation' => 'A',
'null' => false,
),
),
),
'uri_override' =>
array (
'alias' => 'uri_override',
'primary' => false,
'unique' => false,
'type' => 'BTREE',
'columns' =>
array (
'uri_override' =>
array (
'length' => '',
'collation' => 'A',
'null' => false,
),
),
),
'hide_children_in_tree' =>
array (
'alias' => 'hide_children_in_tree',
'primary' => false,
'unique' => false,
'type' => 'BTREE',
'columns' =>
array (
'hide_children_in_tree' =>
array (
'length' => '',
'collation' => 'A',
'null' => false,
),
),
),
'show_in_tree' =>
array (
'alias' => 'show_in_tree',
'primary' => false,
'unique' => false,
'type' => 'BTREE',
'columns' =>
array (
'show_in_tree' =>
array (
'length' => '',
'collation' => 'A',
'null' => false,
),
),
),
'content_ft_idx' =>
array (
'alias' => 'content_ft_idx',
'primary' => false,
'unique' => false,
'type' => 'FULLTEXT',
'columns' =>
array (
'pagetitle' =>
array (
'length' => '',
'collation' => 'A',
'null' => false,
),
'longtitle' =>
array (
'length' => '',
'collation' => 'A',
'null' => false,
),
'description' =>
array (
'length' => '',
'collation' => 'A',
'null' => false,
),
'introtext' =>
array (
'length' => '',
'collation' => 'A',
'null' => true,
),
'content' =>
array (
'length' => '',
'collation' => 'A',
'null' => true,
),
),
),
),
'composites' =>
array (
'Children' =>
array (
'class' => 'modResource',
'local' => 'id',
'foreign' => 'parent',
'cardinality' => 'many',
'owner' => 'local',
),
'TemplateVarResources' =>
array (
'class' => 'modTemplateVarResource',
'local' => 'id',
'foreign' => 'contentid',
'cardinality' => 'many',
'owner' => 'local',
),
'ResourceGroupResources' =>
array (
'class' => 'modResourceGroupResource',
'local' => 'id',
'foreign' => 'document',
'cardinality' => 'many',
'owner' => 'local',
),
'Acls' =>
array (
'class' => 'modAccessResource',
'local' => 'id',
'foreign' => 'target',
'owner' => 'local',
'cardinality' => 'many',
),
'ContextResources' =>
array (
'class' => 'modContextResource',
'local' => 'id',
'foreign' => 'resource',
'cardinality' => 'many',
'owner' => 'local',
),
),
'aggregates' =>
array (
'Parent' =>
array (
'class' => 'modResource',
'local' => 'parent',
'foreign' => 'id',
'cardinality' => 'one',
'owner' => 'foreign',
),
'CreatedBy' =>
array (
'class' => 'modUser',
'local' => 'createdby',
'foreign' => 'id',
'cardinality' => 'one',
'owner' => 'foreign',
),
'EditedBy' =>
array (
'class' => 'modUser',
'local' => 'editedby',
'foreign' => 'id',
'cardinality' => 'one',
'owner' => 'foreign',
),
'DeletedBy' =>
array (
'class' => 'modUser',
'local' => 'deletedby',
'foreign' => 'id',
'cardinality' => 'one',
'owner' => 'foreign',
),
'PublishedBy' =>
array (
'class' => 'modUser',
'local' => 'publishedby',
'foreign' => 'id',
'cardinality' => 'one',
'owner' => 'foreign',
),
'Template' =>
array (
'class' => 'modTemplate',
'local' => 'template',
'foreign' => 'id',
'cardinality' => 'one',
'owner' => 'foreign',
),
'TemplateVars' =>
array (
'class' => 'modTemplateVar',
'local' => 'id:template',
'foreign' => 'contentid:templateid',
'cardinality' => 'many',
'owner' => 'local',
),
'TemplateVarTemplates' =>
array (
'class' => 'modTemplateVarTemplate',
'local' => 'template',
'foreign' => 'templateid',
'cardinality' => 'many',
'owner' => 'local',
),
'ContentType' =>
array (
'class' => 'modContentType',
'local' => 'content_type',
'foreign' => 'id',
'owner' => 'foreign',
'cardinality' => 'one',
),
'Context' =>
array (
'class' => 'modContext',
'local' => 'context_key',
'foreign' => 'key',
'owner' => 'foreign',
'cardinality' => 'one',
),
),
);