diff options
Diffstat (limited to 'create/data/recreate.sh')
| -rwxr-xr-x | create/data/recreate.sh | 46 |
1 files changed, 23 insertions, 23 deletions
diff --git a/create/data/recreate.sh b/create/data/recreate.sh index 25a8f940..e3b60a77 100755 --- a/create/data/recreate.sh +++ b/create/data/recreate.sh @@ -16,29 +16,29 @@ done cat nodes.sql|mysql -uroot for i in 1 2 3 4 5 6 7; do - echo "update config set configid=100*configid+$i"|mysql -uroot node$i - echo "update media_type set mediatypeid=100*mediatypeid+$i"|mysql -uroot node$i - echo "update users set userid=100*userid+$i"|mysql -uroot node$i - echo "update usrgrp set usrgrpid=100*usrgrpid+$i"|mysql -uroot node$i - echo "update rights set rightid=100*rightid+$i"|mysql -uroot node$i - echo "update rights set userid=100*userid+$i"|mysql -uroot node$i - echo "update hosts set hostid=100*hostid+$i"|mysql -uroot node$i - echo "update groups set groupid=100*groupid+$i"|mysql -uroot node$i - echo "update hosts_groups set hostgroupid=100*hostgroupid+$i"|mysql -uroot node$i - echo "update hosts_groups set hostid=100*hostid+$i"|mysql -uroot node$i - echo "update hosts_groups set groupid=100*groupid+$i"|mysql -uroot node$i - echo "update items set itemid=100*itemid+$i"|mysql -uroot node$i - echo "update items set hostid=100*hostid+$i"|mysql -uroot node$i - echo "update functions set functionid=100*functionid+$i"|mysql -uroot node$i - echo "update functions set itemid=100*itemid+$i"|mysql -uroot node$i - echo "update functions set triggerid=100*triggerid+$i"|mysql -uroot node$i - echo "update triggers set triggerid=100*triggerid+$i"|mysql -uroot node$i - echo "update actions set actionid=100*actionid+$i"|mysql -uroot node$i - echo "update actions set userid=100*userid+$i"|mysql -uroot node$i - echo "update media set mediaid=100*mediaid+$i"|mysql -uroot node$i - echo "update media set userid=100*userid+$i"|mysql -uroot node$i - echo "update media set mediatypeid=100*mediatypeid+$i"|mysql -uroot node$i - echo "update images set imageid=100*imageid+$i"|mysql -uroot node$i + echo "update config set configid=configid+0000100000000000000*$i"|mysql -uroot node$i + echo "update media_type set mediatypeid=mediatypeid+0000100000000000000*$i"|mysql -uroot node$i + echo "update users set userid=userid+0000100000000000000*$i"|mysql -uroot node$i + echo "update usrgrp set usrgrpid=usrgrpid+0000100000000000000*$i"|mysql -uroot node$i + echo "update rights set rightid=rightid+0000100000000000000*$i"|mysql -uroot node$i + echo "update rights set userid=userid+0000100000000000000*$i"|mysql -uroot node$i + echo "update hosts set hostid=hostid+0000100000000000000*$i"|mysql -uroot node$i + echo "update groups set groupid=groupid+0000100000000000000*$i"|mysql -uroot node$i + echo "update hosts_groups set hostgroupid=hostgroupid+0000100000000000000*$i"|mysql -uroot node$i + echo "update hosts_groups set hostid=hostid+0000100000000000000*$i"|mysql -uroot node$i + echo "update hosts_groups set groupid=groupid+0000100000000000000*$i"|mysql -uroot node$i + echo "update items set itemid=itemid+0000100000000000000*$i"|mysql -uroot node$i + echo "update items set hostid=hostid+0000100000000000000*$i"|mysql -uroot node$i + echo "update functions set functionid=functionid+0000100000000000000*$i"|mysql -uroot node$i + echo "update functions set itemid=itemid+0000100000000000000*$i"|mysql -uroot node$i + echo "update functions set triggerid=triggerid+0000100000000000000*$i"|mysql -uroot node$i + echo "update triggers set triggerid=triggerid+0000100000000000000*$i"|mysql -uroot node$i + echo "update actions set actionid=actionid+0000100000000000000*$i"|mysql -uroot node$i + echo "update actions set userid=userid+0000100000000000000*$i"|mysql -uroot node$i + echo "update media set mediaid=mediaid+0000100000000000000*$i"|mysql -uroot node$i + echo "update media set userid=userid+0000100000000000000*$i"|mysql -uroot node$i + echo "update media set mediatypeid=mediatypeid+0000100000000000000*$i"|mysql -uroot node$i + echo "update images set imageid=imageid+0000100000000000000*$i"|mysql -uroot node$i done echo Making MySQL server |