From 5ca8d869cbe3d475c14653c26dd0d39861bc67ae Mon Sep 17 00:00:00 2001 From: Steve Sutton Date: Thu, 7 Jun 2018 15:48:35 -0400 Subject: [PATCH] Fix sql errors erros in table name and update --- setup/databaseScripts/create_database_V0.0.3.sql | 2 +- setup/databaseScripts/update_database_V0.0.4.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/setup/databaseScripts/create_database_V0.0.3.sql b/setup/databaseScripts/create_database_V0.0.3.sql index ac3c647..a4d075e 100644 --- a/setup/databaseScripts/create_database_V0.0.3.sql +++ b/setup/databaseScripts/create_database_V0.0.3.sql @@ -79,7 +79,7 @@ CREATE TABLE {prefix}lead_contacts ( id INT NOT NULL AUTO_INCREMENT, lead INT NOT NULL, -- Reference to lead table updated DATETIME NOT NULL, -- Updated Timestamp - title TINYTEXT NULL, -- Title of Contact + title TINYTEXT NULL, -- Title of Contact name TINYTEXT, -- Name of Contact email TINYTEXT, -- Email of Contact phone TINYTEXT, -- Phone of Contact diff --git a/setup/databaseScripts/update_database_V0.0.4.sql b/setup/databaseScripts/update_database_V0.0.4.sql index 90e837b..01d7d66 100644 --- a/setup/databaseScripts/update_database_V0.0.4.sql +++ b/setup/databaseScripts/update_database_V0.0.4.sql @@ -12,4 +12,4 @@ ALTER TABLE {prefix}leads ADD title TEXT NULL; -- Title for lead ---- -- Add Title to lead_contacts -ALTER TABLE {prefix}leads_contacts ADD TINYTEXT NULL; -- Title for Contact +ALTER TABLE {prefix}lead_contacts ADD title TINYTEXT NULL; -- Title for Contact -- 2.17.1