Continuing where we left off yesterday it’s time to define some requirements.

A high level view of what I want to capture on an informational basis:

• Original URL
• Shortened URL
• User
• # of clicks for short URL
• IP address of clicker
• Location of IP of clicker
• referrer of short url

With that I generated this DB scheme: MySQL InnoDB

I’m considering creating another table and splitting out the IP address and the geolocation from the clicks table. Those items could be duplicated quite a bit if I generate enough traffic. What do you think? Should I? What would I gain other than DB size?