CREATE TABLE acos (
	id 			integer NOT NULL AUTO_INCREMENT,
	object_id 	integer DEFAULT NULL,
	alias	  	varchar(255) NOT NULL DEFAULT '',
	lft			integer DEFAULT NULL,
	rght		integer DEFAULT NULL,
	PRIMARY KEY(id)
);

CREATE TABLE aros (
	id integer NOT NULL AUTO_INCREMENT,
	foreign_key integer DEFAULT NULL,
	alias	  varchar(255) NOT NULL DEFAULT '',
	lft		integer DEFAULT NULL,
	rght	integer DEFAULT NULL,
	PRIMARY KEY(id)
);

CREATE TABLE aros_acos (
	id integer NOT NULL AUTO_INCREMENT,
	aro_id integer DEFAULT NULL,
	aco_id	integer DEFAULT NULL,
	_create	integer NOT NULL DEFAULT 0,
	_read	integer NOT NULL DEFAULT 0,
	_update	integer NOT NULL DEFAULT 0,
	_delete	integer NOT NULL DEFAULT 0,
	PRIMARY KEY(id)
);