## mark a section (Learn more)

CREATE TABLE IF NOT EXISTS `acos` ( `id` int(10) NOT NULL AUTO_INCREMENT, `parent_id` int(10) DEFAULT NULL, `model` varchar(255) DEFAULT NULL, `foreign_key` int(10) DEFAULT NULL, `alias` varchar(255) DEFAULT NULL, `lft` int(10) DEFAULT NULL, `rght` int(10) DEFAULT NULL, PRIMARY KEY (`id`), KEY `acos_idx1` (`lft`,`rght`), KEY `acos_idx2` (`alias`), KEY `acos_idx3` (`model`,`foreign_key`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; -- -------------------------------------------------------- CREATE TABLE IF NOT EXISTS `aros` ( `id` int(10) NOT NULL AUTO_INCREMENT, `parent_id` int(10) DEFAULT NULL, `model` varchar(255) DEFAULT NULL, `foreign_key` int(10) DEFAULT NULL, `alias` varchar(255) DEFAULT NULL, `lft` int(10) DEFAULT NULL, `rght` int(10) DEFAULT NULL, PRIMARY KEY (`id`), KEY `aros_idx1` (`lft`,`rght`), KEY `aros_idx2` (`alias`), KEY `aros_idx3` (`model`,`foreign_key`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; -- -------------------------------------------------------- CREATE TABLE IF NOT EXISTS `aros_acos` ( `id` int(10) NOT NULL AUTO_INCREMENT, `aro_id` int(10) NOT NULL, `aco_id` int(10) NOT NULL, `_add` varchar(2) NOT NULL DEFAULT '0', `_view` varchar(2) NOT NULL DEFAULT '0', `_edit` varchar(2) NOT NULL DEFAULT '0', `_delete` varchar(2) NOT NULL DEFAULT '0', `_index` varchar(2) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `ARO_ACO_KEY` (`aro_id`,`aco_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;

This paste will be private.