Not run INSERT INTO `#__ja_email` (`id`, `subscription_id`, `name`, `title`, `subject`, `content`, `EmailFromAddress`, `EmailFromName`, `published`, `checked_out`, `checked_out_time`, `system`, `group`, `language`) VALUES (188, 0, 'SendMailToJobSeekerAboutJob', 'New jobs that fits to some one''s resume', 'New jobs matching your ''{JA_JOBALERTS.TITLE}''', 'Hi {USERS.NAME},\r\n\r\nYour {JA_JOBALERTS.SENDMAIL_DURATION} day(s) update for the {JA_JOBALERTS.TITLE} saved search at {CONFIG.SITE_TITLE} site has returned following jobs\r\n\r\nYour search critical are:\r\n\r\nKeyword: {JA_JOBALERTS.KEYWORD}\r\nLocation: {JA_JOBALERTS.LOCATION}\r\nCategories: {JA_JOBALERTS.CATEGORY}\r\n\r\n{JA_JOBS.JOBLIST.TITLE}\r\n\r\nYou receive this email because you have subscribe to our Job Alert, too many emails?, update your {JA_JOBALERTS.ITEMLINK.TITLE}', '{CONFIG.ADMIN_EMAIL}', '{CONFIG.SITE_TITLE}', 1, 0, '0000-00-00 00:00:00', NULL, '5', 'en-GB')
Not run ALTER TABLE `#__ja_jobs` ADD `feed_id` INT(11) NULL DEFAULT '0', ADD `import_date` DATETIME NULL, ADD `feed_guid` VARCHAR( 525 ) NULL;