ALTER TABLE `persons` ADD `CommentBoard` TEXT NOT NULL AFTER `Remarks` ,
ADD `CommentNetcom` TEXT NOT NULL AFTER `CommentBoard`;

INSERT INTO `functions` (`id`, `name`) VALUES (79, 'applicationfield_commboardedit');
INSERT INTO `functions` (`id`, `name`) VALUES (80, 'applicationfield_commboardview');
INSERT INTO `functions` (`id`, `name`) VALUES (81, 'applicationfield_commnetcomedit');
INSERT INTO `functions` (`id`, `name`) VALUES (82, 'applicationfield_commnetcomview');

INSERT INTO `function_roles` (`role_id`, `function_id`)
VALUES (1, 79), (1, 80), (2, 80), (1, 81), (7, 81), (1, 82), (2, 82), (7, 17), (7, 82), (7, 16);

INSERT INTO `setup` (`id`, `category`, `Name`, `Value`, `RegEx`, `Explanation`, `ac_view`, `ac_edit`, `ac_audit`, `ac_jc`, `ac_registration`, `ac_localorg`, `ac_chair`, `default`, `empty`)
VALUES (239, 'admin', 'ApplShowCommentBoard', '', '[bool]', 'Should the board comment field be displayed for applications?', 'no', 'no', 'no', 'no', 'no', 'no', 'view', '', 'no'),
(240, 'admin', 'ApplShowCommentNetcom', '', '[bool]', 'Should the NetCom comment field be displayed for applications?', 'no', 'no', 'no', 'no', 'no', 'no', 'view', '', 'no');
