promotional bannermobile promotional banner

Juke Alert

Juke Alert is an add on to Citadel that lets you create snitches.
Back to Files

JukeAlert.1_5_2_R3.v0_9_1 Beta

File nameJukeAlert.1_5_2_R3.v0_9_1.jar
Uploaded
May 24, 2013
Downloads
474
Size
63.2 KB
File ID
705695
Type
B
Beta
Supported game versions
  • CB 1.5.2-R0.1

What's new

  • 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.

This mod has no related projects