Elep

<?php
/*
 * Your installation or use of this SugarCRM file is subject to the applicable
 * terms available at
 * http://support.sugarcrm.com/Resources/Master_Subscription_Agreements/.
 * If you do not agree to all of the applicable terms or do not have the
 * authority to bind the entity as an authorized representative, then do not
 * install or use this SugarCRM file.
 *
 * Copyright (C) SugarCRM Inc. All rights reserved.
 */

$dictionary['tracker_queries'] = [
    'table' => 'tracker_queries',
    'fields' => [
        'id' => [
            'name' => 'id',
            'vname' => 'LBL_ID',
            'type' => 'int',
            'len' => '11',
            'reportable' => true,
            'isnull' => 'false',
            'auto_increment' => true,
        ],
        'query_id' => [
            'name' => 'query_id',
            'vname' => 'LBL_QUERY_ID',
            'type' => 'id',
            'required' => true,
            'reportable' => false,
        ],
        'text' => [
            'name' => 'text',
            'vname' => 'LBL_SQL_TEXT',
            'type' => 'text',
            'isnull' => 'false',
        ],
        'query_hash' => [
            'name' => 'query_hash',
            'vname' => 'LBL_QUERY_HASH',
            'type' => 'varchar',
            'len' => '36',
            'reportable' => false,
            'isnull' => 'false',
        ],
        'sec_total' => [
            'name' => 'sec_total',
            'vname' => 'LBL_SEC_TOTAL',
            'type' => 'float',
            'dbType' => 'double',
            'isnull' => 'false',
        ],
        'sec_avg' => [
            'name' => 'sec_avg',
            'vname' => 'LBL_SEC_AVG',
            'type' => 'float',
            'dbType' => 'double',
            'isnull' => 'false',
        ],
        'run_count' => [
            'name' => 'run_count',
            'vname' => 'LBL_RUN_COUNT',
            'type' => 'int',
            'len' => '6',
            'isnull' => 'false',
        ],
        'deleted' => [
            'name' => 'deleted',
            'vname' => 'LBL_DELETED',
            'type' => 'bool',
            'default' => '0',
            'reportable' => false,
            'comment' => 'Record deletion indicator',
        ],
        'date_modified' => [
            'name' => 'date_modified',
            'vname' => 'LBL_DATE_MODIFIED',
            'type' => 'datetime',
            'isnull' => 'false',
        ],
    ],
    'indices' => [
        [
            'name' => 'tracker_queries_pk',
            'type' => 'primary',
            'fields' => [
                'id',
            ],
        ],

[
            'name' => 'idx_tracker_queries_query_hash',
            'type' => 'index',
            'fields' => [
                'query_hash',
            ],
        ],
        [
            'name' => 'idx_tracker_queries_query_id',
            'type' => 'index',
            'fields' => [
                'query_id',
            ],
        ],
    ],
    'acls' => ['SugarACLStatic' => true],
];