X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=sql%2Falter2.2.php;h=72a26840713d4475567153e67b46748fbd84c976;hb=45b596b6da2f5c23dff0e97f82d1f2af70242017;hp=3f557aae94edebca3bcfc1b8b41977e773535352;hpb=d163db3bace889f0aef85fe1f43562d82c62d783;p=fa-stable.git

diff --git a/sql/alter2.2.php b/sql/alter2.2.php
index 3f557aae..72a26840 100644
--- a/sql/alter2.2.php
+++ b/sql/alter2.2.php
@@ -28,8 +28,20 @@ class fa2_2 {
 			."dflt_inventory_act = '" . $prefs['default_inventory_act'] . "',"
 			."dflt_adjustment_act = '" . $prefs['default_adj_act'] . "',"
 			."dflt_assembly_act = '" . $prefs['default_assembly_act']."'";
-		$ret = db_query($sql, "Cannot update category default GL accounts");
-		return $ret;
+		if (db_query($sql)==false) {
+			display_error("Cannot update category default GL accounts"
+			.':<br>'. db_error_msg($db));
+			return false;
+		}
+/*	FIX
+		// add audit_trail data for all transactions
+		$datatbl = array ("gl_trans", "purch_orders", "sales_orders",
+			"workorders");
+		$sql = "INSERT INTO ".$pref."audit_trail"
+		." (type, trans_no, user, fiscal_year, gl_date) VALUES ("
+		. "$type,$trans_no,$user,$year,$date)";
+*/
+		return true;
 	}
 	//
 	//	Checking before install
@@ -44,7 +56,9 @@ class fa2_2 {
 	function installed($pref) {
 		if (check_table($pref, 'company', 'default_delivery_required')) return false;
 		if (check_table($pref, 'stock_category', 'dflt_dim2')) return false;
-		return true;
+		if (check_table($pref, 'users', 'sticky_doc_date')) return false;
+		if (check_table($pref, 'audit_trail')) return false;
+			return true;
 	}
 };