

ALTER TABLE `functions` ADD `type` ENUM( 'core', 'event' ) NOT NULL DEFAULT 'event';

INSERT INTO `functions` (`id`, `name`, `type`) VALUES
(79, 'events_edit', 'core'),
(80, 'memberlist_view', 'core'),
(81, 'user_view', 'core'),
(82, 'user_edit', 'core');

ALTER TABLE `roles` ADD `type` ENUM( 'core', 'event' ) NOT NULL DEFAULT 'event';

INSERT INTO `roles` (`id`, `name`, `type`) VALUES
(10, 'No access', 'core'),
(11, 'Administrator', 'core'),
(12, 'Network Director', 'core'); 

INSERT INTO `function_roles` (`role_id`, `function_id`) VALUES
(11, 79), (11, 80), (11, 81), (11, 82),
(12, 80);
