[phpOpenTracker-User] pot_accesslog db table question

Sebastian, is the accesslog_id field of the pot_accesslog table a 
primary key? i.e. is it unique? From what I can tell in the source code 
it should be unique since you use the process id in calculating it.

I don't know about MySQL but postgres has a special data type for 
generating unique keys called a serial. If MySQL has something similar 
why not use that?

It would lessen the load on the web server (don't have check if 
posix_getpid functionality exists and no need to calculate a CRC) and 
also insures data integrity b/c the database generate a unique key for 
you (in postgres it's simply an integer. The DB adds 1 to it every time 
make an insert).

Just a suggestion :)

Jc



-------------------------------------------------------
This SF.Net email sponsored by: Free pre-built ASP.NET sites including
Data Reports, E-commerce, Portals, and Forums are available now.
Download today and enter to win an XBOX or Visual Studio .NET.
http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01