...
Making "packet_size" a joint Primary Key should work. Latest schema here.
What is left to be done
1.Getdata.pl is currently saving raw pings after every hour rather than after every half an hour. Modification is required to store data for every half an hour means every ping(total 48 for one pair per day)
...