Syntactic Confectionery Delight | |
PerlMonks |
Re^3: IRC log searchby FitTrend (Pilgrim) |
on Feb 22, 2005 at 13:59 UTC ( [id://433331]=note: print w/replies, xml ) | Need Help?? |
Based on what I know, I would say the schema should be minimally: id, int(11) auto_increment Some would argue that you don't need 2 timestamp fields. However in my experience, I sometimes have the need to search base on an EPOCH time range (timestamp) or to use MySQLs date system to search between certain dates. My logic for this database is:
I've included an ID field. This field exists based on common database practices and for future growth. I feel that you may need to code a sub or script to parse a raw log to insert it into the database properly. It may get tricky depending on how the IRC formats the time stamp in the logs. Hope this helps
In Section
Seekers of Perl Wisdom
|
|