File Details
JukeAlert.1_5_2_R3.v0_9_1 Beta
- B
- May 24, 2013
- 63.21 KB
- 434
- CB 1.5.2-R0.1
File Name
JukeAlert.1_5_2_R3.v0_9_1.jar
Supported Versions
- CB 1.5.2-R0.1
- 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.

