SET foreign_key_checks=0;

-- Session save path
UPDATE `user_acl_resource` SET resource = 'settings' WHERE resource = 'Config';
UPDATE `user_acl_resource` SET resource = 'content' WHERE resource = 'Content';
UPDATE `user_acl_resource` SET resource = 'development' WHERE resource = 'Development';
UPDATE `user_acl_resource` SET resource = 'modules' WHERE resource = 'Modules';
UPDATE `user_acl_resource` SET resource = 'stats' WHERE resource = 'Stats';

TRUNCATE `user_acl_permission`;

-- Settings
INSERT INTO user_acl_permission (`permission`, `user_acl_resource_id`) VALUES ('user/list', 1);
INSERT INTO user_acl_permission (`permission`, `user_acl_resource_id`) VALUES ('user/create', 1);
INSERT INTO user_acl_permission (`permission`, `user_acl_resource_id`) VALUES ('user/edit', 1);
INSERT INTO user_acl_permission (`permission`, `user_acl_resource_id`) VALUES ('user/delete', 1);
INSERT INTO user_acl_permission (`permission`, `user_acl_resource_id`) VALUES ('config/system', 1);
INSERT INTO user_acl_permission (`permission`, `user_acl_resource_id`) VALUES ('config/general', 1);
INSERT INTO user_acl_permission (`permission`, `user_acl_resource_id`) VALUES ('config/server', 1);
INSERT INTO user_acl_permission (`permission`, `user_acl_resource_id`) VALUES ('config/update', 1);
INSERT INTO user_acl_permission (`permission`, `user_acl_resource_id`) VALUES ('role/list', 1);
INSERT INTO user_acl_permission (`permission`, `user_acl_resource_id`) VALUES ('role/create', 1);
INSERT INTO user_acl_permission (`permission`, `user_acl_resource_id`) VALUES ('role/edit', 1);
INSERT INTO user_acl_permission (`permission`, `user_acl_resource_id`) VALUES ('role/delete', 1);
-- Content
INSERT INTO user_acl_permission (`permission`, `user_acl_resource_id`) VALUES ('media', 2);
INSERT INTO user_acl_permission (`permission`, `user_acl_resource_id`) VALUES ('document', 2);
INSERT INTO user_acl_permission (`permission`, `user_acl_resource_id`) VALUES ('translation', 2);
-- Development
INSERT INTO user_acl_permission (`permission`, `user_acl_resource_id`) VALUES ('view/list', 3);
INSERT INTO user_acl_permission (`permission`, `user_acl_resource_id`) VALUES ('view/create', 3);
INSERT INTO user_acl_permission (`permission`, `user_acl_resource_id`) VALUES ('view/edit', 3);
INSERT INTO user_acl_permission (`permission`, `user_acl_resource_id`) VALUES ('view/delete', 3);
INSERT INTO user_acl_permission (`permission`, `user_acl_resource_id`) VALUES ('layout/list', 3);
INSERT INTO user_acl_permission (`permission`, `user_acl_resource_id`) VALUES ('layout/create', 3);
INSERT INTO user_acl_permission (`permission`, `user_acl_resource_id`) VALUES ('layout/edit', 3);
INSERT INTO user_acl_permission (`permission`, `user_acl_resource_id`) VALUES ('layout/delete', 3);
INSERT INTO user_acl_permission (`permission`, `user_acl_resource_id`) VALUES ('datatype/list', 3);
INSERT INTO user_acl_permission (`permission`, `user_acl_resource_id`) VALUES ('datatype/create', 3);
INSERT INTO user_acl_permission (`permission`, `user_acl_resource_id`) VALUES ('datatype/edit', 3);
INSERT INTO user_acl_permission (`permission`, `user_acl_resource_id`) VALUES ('datatype/delete', 3);
INSERT INTO user_acl_permission (`permission`, `user_acl_resource_id`) VALUES ('document-type/list', 3);
INSERT INTO user_acl_permission (`permission`, `user_acl_resource_id`) VALUES ('document-type/create', 3);
INSERT INTO user_acl_permission (`permission`, `user_acl_resource_id`) VALUES ('document-type/edit', 3);
INSERT INTO user_acl_permission (`permission`, `user_acl_resource_id`) VALUES ('document-type/delete', 3);
INSERT INTO user_acl_permission (`permission`, `user_acl_resource_id`) VALUES ('script/list', 3);
INSERT INTO user_acl_permission (`permission`, `user_acl_resource_id`) VALUES ('script/create', 3);
INSERT INTO user_acl_permission (`permission`, `user_acl_resource_id`) VALUES ('script/edit', 3);
INSERT INTO user_acl_permission (`permission`, `user_acl_resource_id`) VALUES ('script/delete', 3);
-- Modules
INSERT INTO user_acl_permission (`permission`, `user_acl_resource_id`) VALUES ('list', 4);
INSERT INTO user_acl_permission (`permission`, `user_acl_resource_id`) VALUES ('install', 4);
INSERT INTO user_acl_permission (`permission`, `user_acl_resource_id`) VALUES ('uninstall', 4);
INSERT INTO user_acl_permission (`permission`, `user_acl_resource_id`) SELECT name, 4 FROM module;
-- Stats
INSERT INTO user_acl_permission (`permission`, `user_acl_resource_id`) VALUES ('all', 5);

SET foreign_key_checks=1;