From b02a8aaa8da0165f355e05b85942104ae550186e Mon Sep 17 00:00:00 2001 From: Anthony Talarico Date: Thu, 4 Jan 2018 13:47:04 -0500 Subject: [PATCH] fixing database update script update script was missing a column, fixed the job titles addition on a new job post --- models/admin/jobs/index.php | 3 ++- setup/databaseScripts/create_database_V0.0.3.sql | 2 +- setup/databaseScripts/update_database_V0.0.3.sql | 1 + 3 files changed, 4 insertions(+), 2 deletions(-) diff --git a/models/admin/jobs/index.php b/models/admin/jobs/index.php index 15a77dc..326fe89 100644 --- a/models/admin/jobs/index.php +++ b/models/admin/jobs/index.php @@ -212,9 +212,10 @@ class GlmMembersAdmin_jobs_index extends GlmDataJobs break; case 'insert': - $this->checkNewJobTitles(); + $job = $this->insertEntry(); $this->job_id = $job['fieldData']['id']; + $this->checkNewJobTitles(); $updated = $this->getUpdatedTime($this->job_id); if ($job['status']) { diff --git a/setup/databaseScripts/create_database_V0.0.3.sql b/setup/databaseScripts/create_database_V0.0.3.sql index 767f74f..fae5e98 100644 --- a/setup/databaseScripts/create_database_V0.0.3.sql +++ b/setup/databaseScripts/create_database_V0.0.3.sql @@ -1,6 +1,6 @@ -- Gaslight Media Members Database - Job Postings -- File Created: 11/20/17 15:27:15 --- Database Version: 0.0.2 +-- Database Version: 0.0.3 -- Database Creation Script -- -- This file is called to create a new set of tables for this diff --git a/setup/databaseScripts/update_database_V0.0.3.sql b/setup/databaseScripts/update_database_V0.0.3.sql index 0fe4b78..95ffbb1 100644 --- a/setup/databaseScripts/update_database_V0.0.3.sql +++ b/setup/databaseScripts/update_database_V0.0.3.sql @@ -13,6 +13,7 @@ CREATE TABLE {prefix}email_notifications ( job_approved_message TEXT NULL, -- Event approved message job_to_email TINYTEXT NULL, -- To Email Address job_from_email TINYTEXT NULL, -- From Email Address + job_email_notification TEXT NULL, -- Email notification message PRIMARY KEY (id) ); -- 2.17.1