Bukkit

• Some DB optimizations
• Fixes a rare NPE

Indexes were added to the tables as they are created, but this will not add them to pre-existing tables. To manually add them, use the following statements.

DELETE FROM snitch_details WHERE snitch_id NOT IN (SELECT snitchs.snitch_id FROM snitchs);

ALTER TABLE `snitchs` ADD INDEX `idx_y` (`snitch_y` ASC);

ALTER TABLE `snitch_details` ADD INDEX `idx_snitch_id` (`snitch_id` ASC);

ALTER TABLE `snitch_details` ADD CONSTRAINT `fk_snitchs_snitch_id` FOREIGN KEY (`snitch_id`) REFERENCES `snitchs` (`snitch_id` ) ON DELETE CASCADE ON UPDATE CASCADE;

Doesn't have full SQL optimization. Snitches and Alerts are both jukeboxes, for now... Databases might need to be deleted later on when real update comes out, this is just a start.