<?php
/* SVN FILE: $Id: db_acl.php 173 2009-01-31 12:51:40Z rajesh_04ag02 $ */
/*DbAcl schema generated on: 2007-11-24 15:11:13 : 1195945453*/
/**
 * This is Acl Schema file
 *
 * Use it to configure database for ACL
 *
 * PHP versions 4 and 5
 *
 * CakePHP(tm) :  Rapid Development Framework (http://www.cakephp.org)
 * Copyright 2005-2008, Cake Software Foundation, Inc. (http://www.cakefoundation.org)
 *
 * Licensed under The MIT License
 * Redistributions of files must retain the above copyright notice.
 *
 * @filesource
 * @copyright     Copyright 2005-2008, Cake Software Foundation, Inc. (http://www.cakefoundation.org)
 * @link          http://www.cakefoundation.org/projects/info/cakephp CakePHP(tm) Project
 * @package       cake
 * @subpackage    cake.app.config.sql
 * @since         CakePHP(tm) v 0.2.9
 * @version       $Revision: 7805 $
 * @modifiedby    $LastChangedBy: AD7six $
 * @lastmodified  $Date: 2008-10-30 23:00:26 +0530 (Thu, 30 Oct 2008) $
 * @license       http://www.opensource.org/licenses/mit-license.php The MIT License
 */
/*
*
* Using the Schema command line utility
* cake schema run create DbAcl
*
*/
class DbAclSchema extends CakeSchema
{
    var $name = 'DbAcl';
    function before($event = array()) 
    {
        return true;
    }
    function after($event = array()) 
    {
    }
    var $acos = array(
        'id' => array(
            'type' => 'integer',
            'null' => false,
            'default' => NULL,
            'length' => 10,
            'key' => 'primary'
        ) ,
        'parent_id' => array(
            'type' => 'integer',
            'null' => true,
            'default' => NULL,
            'length' => 10
        ) ,
        'model' => array(
            'type' => 'string',
            'null' => true
        ) ,
        'foreign_key' => array(
            'type' => 'integer',
            'null' => true,
            'default' => NULL,
            'length' => 10
        ) ,
        'alias' => array(
            'type' => 'string',
            'null' => true
        ) ,
        'lft' => array(
            'type' => 'integer',
            'null' => true,
            'default' => NULL,
            'length' => 10
        ) ,
        'rght' => array(
            'type' => 'integer',
            'null' => true,
            'default' => NULL,
            'length' => 10
        ) ,
        'indexes' => array(
            'PRIMARY' => array(
                'column' => 'id',
                'unique' => 1
            )
        )
    );
    var $aros = array(
        'id' => array(
            'type' => 'integer',
            'null' => false,
            'default' => NULL,
            'length' => 10,
            'key' => 'primary'
        ) ,
        'parent_id' => array(
            'type' => 'integer',
            'null' => true,
            'default' => NULL,
            'length' => 10
        ) ,
        'model' => array(
            'type' => 'string',
            'null' => true
        ) ,
        'foreign_key' => array(
            'type' => 'integer',
            'null' => true,
            'default' => NULL,
            'length' => 10
        ) ,
        'alias' => array(
            'type' => 'string',
            'null' => true
        ) ,
        'lft' => array(
            'type' => 'integer',
            'null' => true,
            'default' => NULL,
            'length' => 10
        ) ,
        'rght' => array(
            'type' => 'integer',
            'null' => true,
            'default' => NULL,
            'length' => 10
        ) ,
        'indexes' => array(
            'PRIMARY' => array(
                'column' => 'id',
                'unique' => 1
            )
        )
    );
    var $aros_acos = array(
        'id' => array(
            'type' => 'integer',
            'null' => false,
            'default' => NULL,
            'length' => 10,
            'key' => 'primary'
        ) ,
        'aro_id' => array(
            'type' => 'integer',
            'null' => false,
            'length' => 10,
            'key' => 'index'
        ) ,
        'aco_id' => array(
            'type' => 'integer',
            'null' => false,
            'length' => 10
        ) ,
        '_create' => array(
            'type' => 'string',
            'null' => false,
            'default' => '0',
            'length' => 2
        ) ,
        '_read' => array(
            'type' => 'string',
            'null' => false,
            'default' => '0',
            'length' => 2
        ) ,
        '_update' => array(
            'type' => 'string',
            'null' => false,
            'default' => '0',
            'length' => 2
        ) ,
        '_delete' => array(
            'type' => 'string',
            'null' => false,
            'default' => '0',
            'length' => 2
        ) ,
        'indexes' => array(
            'PRIMARY' => array(
                'column' => 'id',
                'unique' => 1
            ) ,
            'ARO_ACO_KEY' => array(
                'column' => array(
                    'aro_id',
                    'aco_id'
                ) ,
                'unique' => 1
            )
        )
    );
}
?>