1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
|
#!/bin/bash
USER_COUNT=1000
echo "use ipplan;"
echo "#delete from users;"
echo "#delete from grp;"
echo "#delete from usergrp;"
for ((m=0 ; m < $USER_COUNT ; m++))
do
USERNAME=user$m
GROUP=group$m
echo "insert into ipplan.users values('$USERNAME','$USERNAME
Description','fakepassword');"
echo "insert into ipplan.grp values('$GROUP
Description','$GROUP','Y','1');"
done
for ((m=0; m < $USER_COUNT; m++))
do
GROUP=group$m;
USERNAME=user$m;
echo "insert into ipplan.usergrp values('$USERNAME','$GROUP');"
done
|