#!/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"