19 lines
1.1 KiB
SQL
19 lines
1.1 KiB
SQL
CREATE TABLE IF NOT EXISTS `stochastic_events` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`event_name` varchar(255) NOT NULL,
|
|
`probability` float NOT NULL,
|
|
`track_data` json NOT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
|
|
|
|
-- Clear existing data to prevent duplicates on re-run
|
|
TRUNCATE TABLE `stochastic_events`;
|
|
|
|
-- Sample Stochastic Events (variations of Irma)
|
|
INSERT INTO `stochastic_events` (`event_name`, `probability`, `track_data`) VALUES
|
|
('Irma-Track-01-SlightlyWest', 0.05, '[[-55.5,16.1,175],[-63.5,18.2,185],[-75.5,22,160],[-82,23.5,130],[-82.2,25.9,115],[-82.9,28.9,75]]'),
|
|
('Irma-Track-02-Standard', 0.10, '[[-55,16.1,175],[-63,18.2,185],[-75,22,160],[-81.5,23.5,130],[-81.7,25.9,115],[-82.4,28.9,75]]'),
|
|
('Irma-Track-03-SlightlyEast', 0.05, '[[-54.5,16.1,175],[-62.5,18.2,185],[-74.5,22,160],[-81,23.5,130],[-81.2,25.9,115],[-81.9,28.9,75]]'),
|
|
('Irma-Track-04-Weaker', 0.15, '[[-55,16.1,140],[-63,18.2,148],[-75,22,128],[-81.5,23.5,104],[-81.7,25.9,92],[-82.4,28.9,60]]'),
|
|
('Irma-Track-05-Stronger', 0.02, '[[-55,16.1,193],[-63,18.2,204],[-75,22,176],[-81.5,23.5,143],[-81.7,25.9,127],[-82.4,28.9,83]]');
|