utm5_database:account_ipgroups [UTM5 WIKI]

#!/bin/sh
 
. /netup/utm5/utm5.cfg
req='UPDATE ip_groups ig, service_links sl, iptraffic_service_links isl SET ig.account_id_ipg=sl.account_id WHERE sl.id=isl.i
d AND ig.ip_group_id=isl.ip_group_id AND ig.is_deleted = 0 AND sl.is_deleted = 0 AND isl.is_deleted = 0;'
mysql -h $database_host -u $database_login -p$database_password $database -e"$req"
date_end=`date`
echo "update accounts-ipgroups ended at $date_end"