erocs/JukeAlert — pull request #3 by mgrandi (2013-04-25 02:03:05+00:00)
Title: SQL Schema / JukeAlertLogger work

Updated the schemas for the tables, mostly for the snitches detail table, we now store a reference to the row in the main snitches table for each event so we know what snitch it came from, and we store the individual parts of an event (player name, victim name, material, location, etc) instead of just a pre-formatted string directly into the database.

Also rewrote the getSnitchInfo() method so it first gets the snitch from the main snitch database, and then using that snitch's id we get all of the events that occurred from that snitch between OFFSET,LIMIT

There are a couple of places where I'm not sure what we should be using, like when we record a bucketFill, bucketEmpty or a general 'used' event, how do we identify those? Do we get back a Block, ItemStack, Material or something else?