src/articles/classes/Entity/Table/Article.php
protected function setTableDefinition()
    {
        $this->setTableName('articles');
        $this->hasColumns(array(
            'id' => array(
                'type' => 'integer',
                'unsigned' => true,
                'autoincrement' => true,
            ),
            'section' => array(
                'type' => 'integer',
                'unsigned' => true,
            ),
            'active' => array(
                'type' => 'boolean',
            ),
            'position' => array(
                'type' => 'integer',
                'unsigned' => true,
            ),
            'posted' => array(
                'type' => 'datetime',
            ),
            'block' => array(
                'type' => 'boolean',
                'default' => false,
            ),
            'caption' => array(
                'type' => 'string',
                'length' => 255,
            ),
            'preview' => array(
                'type' => 'string',
            ),
            'text' => array(
                'type' => 'string',
            )
        ));
        $this->setOrdering($this->getPlugin()->settings['listSortMode'],
            $this->getPlugin()->settings['listSortDesc']
                ? ezcQuerySelect::DESC
                : ezcQuerySelect::ASC);
        $this->index('admin_idx', array('fields' => array('section', 'position')));
        $this->index('cl_position_idx', array('fields' => array('section', 'active', 'position')));
        $this->index('cl_date_idx', array('fields' => array('section', 'active', 'posted')));
        $this->index('cl_block_idx', array('fields' => array('block', 'active')));
    }
protected function setTableDefinition()
    {
        $this->setTableName('articles');
        $this->hasColumns(array(
            'id' => array(
                'type' => 'integer',
                'unsigned' => true,
                'autoincrement' => true,
            ),
            'section' => array(
                'type' => 'integer',
                'unsigned' => true,
            ),
            'active' => array(
                'type' => 'boolean',
            ),
            'position' => array(
                'type' => 'integer',
                'unsigned' => true,
            ),
            'posted' => array(
                'type' => 'datetime',
            ),
            'block' => array(
                'type' => 'boolean',
                'default' => false,
            ),
            'caption' => array(
                'type' => 'string',
                'length' => 255,
            ),
            'preview' => array(
                'type' => 'string',
            ),
            'text' => array(
                'type' => 'string',
            )
        ));
        $this->setOrdering($this->getPlugin()->settings['listSortMode'],
            $this->getPlugin()->settings['listSortDesc']
                ? ezcQuerySelect::DESC
                : ezcQuerySelect::ASC);
        $this->index('admin_idx', array('fields' => array('section', 'position')));
        $this->index('cl_position_idx', array('fields' => array('section', 'active', 'position')));
        $this->index('cl_date_idx', array('fields' => array('section', 'active', 'posted')));
        $this->index('cl_block_idx', array('fields' => array('block', 'active')));
    }
Описание таблицы
@since 3.01