pictcode

# $Id$

#

# Copyright (c) Cake Software Foundation, Inc. (http://cakefoundation.org)

#

# Licensed under The MIT License

# For full copyright and license information, please see the LICENSE.txt

# Redistributions of files must retain the above copyright notice.

# MIT License (http://www.opensource.org/licenses/mit-license.php)

CREATE TABLE acos (

  id INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT,

  parent_id INTEGER(10) DEFAULT NULL,

  model VARCHAR(255) DEFAULT '',

  foreign_key INTEGER(10) UNSIGNED DEFAULT NULL,

  alias VARCHAR(255) DEFAULT '',

  lft INTEGER(10) DEFAULT NULL,

  rght INTEGER(10) DEFAULT NULL,

  PRIMARY KEY  (id)

);

CREATE TABLE aros_acos (

  id INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT,

  aro_id INTEGER(10) UNSIGNED NOT NULL,

  aco_id INTEGER(10) UNSIGNED NOT NULL,

  _create CHAR(2) NOT NULL DEFAULT 0,

  _read CHAR(2) NOT NULL DEFAULT 0,

  _update CHAR(2) NOT NULL DEFAULT 0,

  _delete CHAR(2) NOT NULL DEFAULT 0,

  PRIMARY KEY(id)

);

CREATE TABLE aros (

  id INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT,

  parent_id INTEGER(10) DEFAULT NULL,

  model VARCHAR(255) DEFAULT '',

  foreign_key INTEGER(10) UNSIGNED DEFAULT NULL,

  alias VARCHAR(255) DEFAULT '',

  lft INTEGER(10) DEFAULT NULL,

  rght INTEGER(10) DEFAULT NULL,

  PRIMARY KEY  (id)

);

/* this indexes will improve acl perfomance */

CREATE INDEX idx_acos_lft_rght ON `acos` (`lft`, `rght`);

CREATE INDEX idx_acos_alias ON `acos` (`alias`);

CREATE INDEX idx_aros_lft_rght ON `aros` (`lft`, `rght`);

CREATE INDEX idx_aros_alias ON `aros` (`alias`);

CREATE INDEX idx_aco_id ON `aros_acos` (`aco_id`);