db_acl.php 3.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263
  1. <?php
  2. /*DbAcl schema generated on: 2007-11-24 15:11:13 : 1195945453*/
  3. /**
  4. * This is Acl Schema file
  5. *
  6. * Use it to configure database for ACL
  7. *
  8. * PHP 5
  9. *
  10. * CakePHP(tm) : Rapid Development Framework (http://cakephp.org)
  11. * Copyright 2005-2011, Cake Software Foundation, Inc. (http://cakefoundation.org)
  12. *
  13. * Licensed under The MIT License
  14. * Redistributions of files must retain the above copyright notice.
  15. *
  16. * @copyright Copyright 2005-2011, Cake Software Foundation, Inc. (http://cakefoundation.org)
  17. * @link http://cakephp.org CakePHP(tm) Project
  18. * @package app.config.sql
  19. * @since CakePHP(tm) v 0.2.9
  20. * @license MIT License (http://www.opensource.org/licenses/mit-license.php)
  21. */
  22. /*
  23. *
  24. * Using the Schema command line utility
  25. * cake schema run create DbAcl
  26. *
  27. */
  28. class DbAclSchema extends CakeSchema {
  29. public $acos = array(
  30. 'id' => array('type'=>'integer', 'null' => false, 'default' => NULL, 'length' => 10, 'key' => 'primary'),
  31. 'parent_id' => array('type'=>'integer', 'null' => true, 'default' => NULL, 'length' => 10),
  32. 'model' => array('type'=>'string', 'null' => true),
  33. 'foreign_key' => array('type'=>'integer', 'null' => true, 'default' => NULL, 'length' => 10),
  34. 'alias' => array('type'=>'string', 'null' => true),
  35. 'lft' => array('type'=>'integer', 'null' => true, 'default' => NULL, 'length' => 10),
  36. 'rght' => array('type'=>'integer', 'null' => true, 'default' => NULL, 'length' => 10),
  37. 'indexes' => array('PRIMARY' => array('column' => 'id', 'unique' => 1))
  38. );
  39. public $aros = array(
  40. 'id' => array('type'=>'integer', 'null' => false, 'default' => NULL, 'length' => 10, 'key' => 'primary'),
  41. 'parent_id' => array('type'=>'integer', 'null' => true, 'default' => NULL, 'length' => 10),
  42. 'model' => array('type'=>'string', 'null' => true),
  43. 'foreign_key' => array('type'=>'integer', 'null' => true, 'default' => NULL, 'length' => 10),
  44. 'alias' => array('type'=>'string', 'null' => true),
  45. 'lft' => array('type'=>'integer', 'null' => true, 'default' => NULL, 'length' => 10),
  46. 'rght' => array('type'=>'integer', 'null' => true, 'default' => NULL, 'length' => 10),
  47. 'indexes' => array('PRIMARY' => array('column' => 'id', 'unique' => 1))
  48. );
  49. public $aros_acos = array(
  50. 'id' => array('type'=>'integer', 'null' => false, 'default' => NULL, 'length' => 10, 'key' => 'primary'),
  51. 'aro_id' => array('type'=>'integer', 'null' => false, 'length' => 10, 'key' => 'index'),
  52. 'aco_id' => array('type'=>'integer', 'null' => false, 'length' => 10),
  53. '_create' => array('type'=>'string', 'null' => false, 'default' => '0', 'length' => 2),
  54. '_read' => array('type'=>'string', 'null' => false, 'default' => '0', 'length' => 2),
  55. '_update' => array('type'=>'string', 'null' => false, 'default' => '0', 'length' => 2),
  56. '_delete' => array('type'=>'string', 'null' => false, 'default' => '0', 'length' => 2),
  57. 'indexes' => array('PRIMARY' => array('column' => 'id', 'unique' => 1), 'ARO_ACO_KEY' => array('column' => array('aro_id', 'aco_id'), 'unique' => 1))
  58. );
  59. }