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.
 */
/* this table should never get created, it should only be used as a template for the acutal audit tables
 * for each moudule.
 */
$dictionary['audit'] = 
		array ( 'table' => 'audit',
              	'fields' => array (
              	      'id'=> array('name' =>'id', 'type' =>'id', 'len'=>'36','required'=>true), 
                      'parent_id'=>array('name' =>'parent_id', 'type' =>'id', 'len'=>'36','required'=>true),
                      'event_id'=>array('name' =>'event_id', 'type' =>'id', 'required'=>true),
                      'date_created'=>array('name' =>'date_created','type' => 'datetime'),
                      'created_by'=>array('name' =>'created_by','type' => 'id','len' => 36),
                      'date_updated'=>array('name' =>'date_updated','type' => 'datetime'),
                      'field_name'=>array('name' =>'field_name','type' => 'varchar','len' => 100),
					  'data_type'=>array('name' =>'data_type','type' => 'varchar','len' => 100),
					  'before_value_string'=>array('name' =>'before_value_string','type' => 'varchar'),
					  'after_value_string'=>array('name' =>'after_value_string','type' => 'varchar'),
					  'before_value_text'=>array('name' =>'before_value_text','type' => 'text'),
					  'after_value_text'=>array('name' =>'after_value_text','type' => 'text'),
				),
				'indices' => array (
				      //name will be re-constructed adding idx_ and table name as the prefix like 'idx_accounts_'
				      array ('name' => 'pk', 'type' => 'primary', 'fields' => array('id')),
                      array ('name' => 'event_id', 'type' => 'index', 'fields' => array('event_id')),
                      array ('name' => 'pa_ev_id', 'type' => 'index', 'fields' => array('parent_id', 'event_id')),
                      array ('name' => 'after_value', 'type' => 'index', 'fields' => array('after_value_string')),
				)
        );