# $Id: db_acl.sql 7118 2008-06-04 20:49:29Z gwoo $## Copyright 2005-2008,	Cake Software Foundation, Inc.#								1785 E. Sahara Avenue, Suite 490-204#								Las Vegas, Nevada 89104## Licensed under The MIT License# Redistributions of files must retain the above copyright notice.# http://www.opensource.org/licenses/mit-license.php The MIT LicenseCREATE 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));