'versions' ,'fields' => array ( 'id' => array ( 'name' => 'id', 'vname' => 'LBL_ID', 'type' => 'id', 'required'=>true, 'reportable'=>false, ), 'deleted' => array ( 'name' => 'deleted', 'vname' => 'LBL_DELETED', 'type' => 'bool', 'required'=>false, 'reportable'=>false, ), 'date_entered' => array ( 'name' => 'date_entered', 'vname' => 'LBL_DATE_ENTERED', 'type' => 'datetime', 'required'=>true, ), 'date_modified' => array ( 'name' => 'date_modified', 'vname' => 'LBL_DATE_MODIFIED', 'type' => 'datetime', 'required'=>true, ), 'modified_user_id' => array ( 'name' => 'modified_user_id', 'rname' => 'user_name', 'id_name' => 'modified_user_id', 'vname' => 'LBL_ASSIGNED_TO', 'type' => 'assigned_user_name', 'table' => 'users', 'isnull' => 'false', 'dbType' => 'id', 'required'=>false, 'reportable'=>true, ), 'created_by' => array ( 'name' => 'created_by', 'rname' => 'user_name', 'id_name' => 'modified_user_id', 'vname' => 'LBL_ASSIGNED_TO', 'type' => 'assigned_user_name', 'table' => 'users', 'isnull' => 'false', 'dbType' => 'id', 'reportable'=>true, ), 'name' => array ( 'name' => 'name', 'vname' => 'LBL_NAME', 'type' => 'varchar', 'len' => '255', 'required'=>true, ), 'file_version' => array ( 'name' => 'file_version', 'vname' => 'LBL_FILE_VERSION', 'type' => 'varchar', 'len' => '255', 'required'=>true, ), 'db_version' => array ( 'name' => 'db_version', 'vname' => 'LBL_DB_VERSION', 'type' => 'varchar', 'len' => '255', 'required'=>true, ), ) , 'indices' => array ( array('name' =>'versionspk', 'type' =>'primary', 'fields'=>array('id')), array('name' =>'idx_version', 'type'=>'index', 'fields'=>array('name','deleted')), ) ); ?>