https://www.icyphoenix.com/viewtopic.php?f=35&t=4627&p=31245#p31245
-----------------------------------
Vortex
Sat 30 Aug, 2008 00:37

Users' Traces In Icy
-----------------------------------
Hi to you all. How long... don't worry, I have notifications active and I am always up to date on what's new in here ;)


I need some help with database structure.
When a user logs in, his ip is logged and when he posts something, too.

- the user logs in
- he reads and replys to some topic
- he logs out.

During these 3 easy steps a lot of informations about him (ip, browser and so on) are stored. Specifically, I am interested on the ip.

Let's suppose I want to log in, post and log out, erasing time by time my registered ips. Where do I have to go to find this records and delete them?

I thought about:

table_posts
table_users
table_logins

Anything else?