/*
    Dragon data for dragons from "How to Train Your Dragon"

    originally compiled from web site:
    https://www.howtotrainyourdragon.com/explore/dragons
    in November 2015,

    updated (a little) based on what appears to be version of that site 
    in November 2021:
    https://www.dreamworks.com/how-to-train-your-dragon/explore

    (left the values from November 2015 site, but did update each dragon's
    URL to one that worked 2021-11-24)

    last modified: 2021-11-24
*/

drop table dragon;

create table dragon
(dragon_id           char(3),
 dragon_name         varchar2(30),
 dragon_species      varchar2(30),
 dragon_class        varchar2(30),
 dragon_attack       integer,
 dragon_speed        integer,
 dragon_armor        integer,
 dragon_firepower    integer,
 dragon_shot_limit   integer,
 dragon_venom        integer,
 dragon_jaw_strength integer,
 dragon_stealth      integer,
 dragon_src_url      varchar2(100),
 primary key (dragon_id)
);

grant select
on dragon
to java;

insert into dragon
values
('001', 'Toothless', 'Night Fury', 'Strike', 
 15, 20, 18, 14, 6, 0, 6, 18,
 'https://www.dreamworks.com/how-to-train-your-dragon/explore/toothless');

insert into dragon(dragon_id, dragon_name, dragon_species, dragon_class,
                   dragon_attack, dragon_speed, dragon_firepower,
                   dragon_shot_limit, dragon_venom, dragon_jaw_strength,
                   dragon_stealth, dragon_src_url)
values
('002', 'Baby Nightmare', 'Monstrous Nightmare', 'Stoker',
 13, 9, 13, 7, 3, 3, 7,
 'https://www.dreamworks.com/how-to-train-your-dragon/explore/baby-nightmare');

insert into dragon
values
('003', 'Hookfang', 'Monstrous Nightmare', 'Stoker', 
 15, 16, 12, 15, 10, 0, 6, 9,
 'https://www.dreamworks.com/how-to-train-your-dragon/explore/hookfang');

/*
insert into dragon
values
('004', 'Windshear', 'Razorwhip', 'Sharp',
 18, 18, 32, 12, 10, 8, 7, 5,
 'https://www.dreamworks.com/how-to-train-your-dragon/explore/windshear');


insert into dragon
values
('005', 'Catastrophic Quaken', 'Catastrophic Quaken', 'Boulder',
 12, 14, 35, 10, 6, 0, 20, 3,
 'https://www.dreamworks.com/how-to-train-your-dragon/explore/catastrophic-quaken');
*/


insert into dragon
values
('006', 'Stormfly', 'Deadly Nadder', 'Tracker',
 10, 8, 16, 18, 6, 16, 5, 10,
 'https://www.dreamworks.com/how-to-train-your-dragon/explore/stormfly');

/*
insert into dragon
values
('007', 'Seashocker', 'Seashocker', 'Tidal',
 18, 16, 20, 7, 12, 14, 8, 10,
 'https://www.dreamworks.com/how-to-train-your-dragon/explore/sea-shocker');
*/

insert into dragon
values
('008', 'Baby Zippleback', 'Hideous Zippleback', 'Mystery',
 6, 5, 7, 4, 0, 4, 10, 5,
 'https://www.dreamworks.com/how-to-train-your-dragon/explore/baby-zippleback');

insert into dragon
values
('009', 'Skrill', 'Skrill', 'Strike',
 14, 11, 10, 12, 4, 0, 5, 18,
 'https://www.dreamworks.com/how-to-train-your-dragon/explore/skrill');

/*
insert into dragon
values
('010', 'Snow Wraith', 'Snow Wraith', 'Strike',
 18, 18, 22, 24, 10, 0, 8, 30,
 'https://www.dreamworks.com/how-to-train-your-dragon/explore/snow-wraith');
*/

insert into dragon
values
('011', 'Baby Nadder', 'Deadly Nadder', 'Tracker',
 4, 4, 4, 6, 6, 4, 3, 5,
 'https://www.dreamworks.com/how-to-train-your-dragon/explore/baby-nadder');

/*
insert into dragon
values
('012', 'Speed Stinger', 'Speed Stinger', 'Sharp',
 12, 30, 10, 0, 0, 15, 5, 30, 
 'https://www.dreamworks.com/how-to-train-your-dragon/explore/speed-stinger');
*/


insert into dragon(dragon_id, dragon_name, dragon_species, dragon_class,
                   dragon_attack, dragon_speed, dragon_armor,
                   dragon_firepower, dragon_shot_limit, dragon_venom, 
                   dragon_jaw_strength,
                   dragon_src_url)
values
('013', 'Skullcrusher', 'Rumblehorn', 'Tracker',
 11, 7, 12, 11, 4, 0, 5,
 'https://www.dreamworks.com/how-to-train-your-dragon/explore/skullcrusher');

insert into dragon(dragon_id, dragon_name, dragon_species, dragon_class,
                   dragon_attack, dragon_speed, dragon_armor,
                   dragon_shot_limit, dragon_venom, 
                   dragon_src_url)
values
('014', 'Cloudjumper', 'Stormcutter', 'Sharp',
 6, 8, 4, 8, 0, 
 'https://www.dreamworks.com/how-to-train-your-dragon/explore/cloudjumper'); 

insert into dragon
values
('015', 'Timberjack', 'Timberjack', 'Sharp',
 10, 12, 8, 10, 8, 0, 3, 13, 
 'https://www.dreamworks.com/how-to-train-your-dragon/explore/timberjack');

insert into dragon
values
('016', 'Baby Gronckle', 'Gronckle', 'Boulder',
 5, 2, 16, 10, 4, 0, 6, 2,
 'https://www.dreamworks.com/how-to-train-your-dragon/explore/baby-gronckle');

insert into dragon
values
('017', 'Grump', 'Hotburple', 'Boulder',
 8, 4, 20, 14, 6, 0, 8, 5, 
 'https://www.dreamworks.com/how-to-train-your-dragon/explore/grump');

insert into dragon
values
('018', 'Meatlug', 'Gronckle', 'Boulder',
 8, 4, 20, 14, 6, 0, 8, 5, 
 'https://www.dreamworks.com/how-to-train-your-dragon/explore/meatlug');

insert into dragon
values
('019', 'Light Fury', 'Light Fury', 'Strike',
 12, 20, 12, 10, 14, 20, 8, 18,
'https://www.dreamworks.com/how-to-train-your-dragon/explore/light-fury');

insert into dragon
values
('020', 'Valka''s Bewilderbeast', 'Bewilderbeast', 'Tidal', 
20, 6, 16, 20, 6, 20, 19, 20,
'https://www.dreamworks.com/how-to-train-your-dragon/explore/valkas-bewilderbeast');