From 2c67bde193d6bf7029dae184938f143a5970b50e Mon Sep 17 00:00:00 2001 From: Steve Sutton Date: Thu, 14 Dec 2017 06:29:45 -0500 Subject: [PATCH] Updating the db scripts Correcting: need to add field to transactions: account --- classes/billingSupport.php | 8 +++++++- setup/databaseScripts/update_database_V0.0.2.sql | 5 +++++ 2 files changed, 12 insertions(+), 1 deletion(-) diff --git a/classes/billingSupport.php b/classes/billingSupport.php index f78da34..a81a8d4 100644 --- a/classes/billingSupport.php +++ b/classes/billingSupport.php @@ -191,7 +191,13 @@ class GlmBillingSupport 'current_invoice_total' => $current_invoice_total, 'current_payment_total' => $current_payment_total, ), - array() + array( + '%d', + '%d', + '%s', + '%s', + '%s' + ) ); } diff --git a/setup/databaseScripts/update_database_V0.0.2.sql b/setup/databaseScripts/update_database_V0.0.2.sql index 3447a7e..e74e9d9 100644 --- a/setup/databaseScripts/update_database_V0.0.2.sql +++ b/setup/databaseScripts/update_database_V0.0.2.sql @@ -13,3 +13,8 @@ CREATE TABLE {prefix}pdfs ( pdf MEDIUMTEXT NOT NULL, -- saved pdf PRIMARY KEY (id) ); + +---- + +-- Add account field to the transaction table +ALTER TABLE {prefix}transactions ADD account INT NOT NULL; -- reference to account id -- 2.17.1