[Web-erp-svn] SF.net SVN: web-erp:[7402] trunk/WWW_Users.php

[<te...@us...>]

Revision: 7402
          http://sourceforge.net/p/web-erp/reponame/7402
Author:   tehonu
Date:     2015-11-27 00:26:56 +0000 (Fri, 27 Nov 2015)
Log Message:
-----------
cascade deletion of bankaccountusers to aviod orphaned records in bankaccountusers table

Modified Paths:
--------------
    trunk/WWW_Users.php

Modified: trunk/WWW_Users.php
===================================================================
--- trunk/WWW_Users.php	2015-11-26 07:14:50 UTC (rev 7401)
+++ trunk/WWW_Users.php	2015-11-27 00:26:56 UTC (rev 7402)
@@ -280,6 +280,10 @@
 			$ErrMsg = _('The GL Account - User could not be deleted because');;
 			$result = DB_query($sql,$ErrMsg);
 
+			$sql="DELETE FROM bankaccountusers WHERE userid='" . $SelectedUser . "'";
+			$ErrMsg = _('The Bank Accounts - User could not be deleted because');;
+			$result = DB_query($sql,$ErrMsg);
+
 			$sql="DELETE FROM www_users WHERE userid='" . $SelectedUser . "'";
 			$ErrMsg = _('The User could not be deleted because');;
 			$result = DB_query($sql,$ErrMsg);