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
(246, 'jc', 'CandidatePhotoMaxHeight', '500', '[int]', 'The maximum height of the saved photo in pixels. Photo''s are resized proportionally.', 'view', 'view', 'view', 'edit', 'view', 'view', 'view', '500', 'no'),
(247, 'jc', 'CandidatePhotoMaxWidth', '500', '[int]', 'The maximum width of the saved photo in pixels. Photo''s are resized proportionally.', 'view', 'view', 'view', 'edit', 'view', 'view', 'view', '500', 'no'),
(248, 'jc', 'CandidatePhotoMaxUploadSize', '2048', '[int]', 'The maximum size an uploaded photo is allowed to be (in KB)', 'view', 'view', 'view', 'view', 'view', 'view', 'view', '2048', 'no');

ALTER TABLE `candidates` ADD `Photo` MEDIUMBLOB NOT NULL AFTER `Nationality`;
