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

    compiled from web site:
    https://www.howtotrainyourdragon.com/explore/dragons

    last modified: 2015-11-18
*/

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)
);

insert into dragon
values
('001', 'Toothless', 'Night Fury', 'Strike', 
 15, 20, 18, 14, 6, 0, 6, 18,
 'https://www.howtotrainyourdragon.com/explore/dragons/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.howtotrainyourdragon.com/explore/dragons/baby-nightmare');

insert into dragon
values
('003', 'Hookfang', 'Monstrous Nightmare', 'Stoker', 
 15, 16, 12, 15, 10, 0, 6, 9,
 'https://www.howtotrainyourdragon.com/explore/dragons/hookfang');

insert into dragon
values
('004', 'Windshear', 'Razorwhip', 'Sharp',
 18, 18, 32, 12, 10, 8, 7, 5,
 'https://www.howtotrainyourdragon.com/explore/dragons/windshear');

insert into dragon
values
('005', 'Catastrophic Quaken', 'Catastrophic Quaken', 'Boulder',
 12, 14, 35, 10, 6, 0, 20, 3,
 'https://www.howtotrainyourdragon.com/explore/dragons/catastrophic-quaken');

insert into dragon
values
('006', 'Stormfly', 'Deadly Nadder', 'Tracker',
 10, 8, 16, 18, 6, 16, 5, 10,
 'https://www.howtotrainyourdragon.com/explore/dragons/stormfly');

insert into dragon
values
('007', 'Seashocker', 'Seashocker', 'Tidal',
 18, 16, 20, 7, 12, 14, 8, 10,
 'https://www.howtotrainyourdragon.com/explore/dragons/sea-shocker');

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

insert into dragon
values
('009', 'Skrill', 'Skrill', 'Strike',
 14, 11, 10, 12, 4, 0, 5, 18,
 'https://www.howtotrainyourdragon.com/explore/dragons/skrill');

insert into dragon
values
('010', 'Snow Wraith', 'Snow Wraith', 'Strike',
 18, 18, 22, 24, 10, 0, 8, 30,
 'https://www.howtotrainyourdragon.com/explore/dragons/snow-wraith');

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

insert into dragon
values
('012', 'Speed Stinger', 'Speed Stinger', 'Sharp',
 12, 30, 10, 0, 0, 15, 5, 30, 
 'https://www.howtotrainyourdragon.com/explore/dragons/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.howtotrainyourdragon.com/explore/dragons/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.howtotrainyourdragon.com/explore/dragons/cloudjumper'); 

insert into dragon
values
('015', 'Timberjack', 'Timberjack', 'Sharp',
 10, 12, 8, 10, 8, 0, 3, 13, 
 'https://www.howtotrainyourdragon.com/explore/dragons/timberjack');

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

insert into dragon
values
('017', 'Grump', 'Hotburple', 'Boulder',
 8, 4, 20, 14, 6, 0, 8, 5, 
 'https://www.howtotrainyourdragon.com/explore/dragons/grump');

insert into dragon
values
('018', 'Meatlug', 'Gronckle', 'Boulder',
 8, 4, 20, 14, 6, 0, 8, 5, 
 'https://www.howtotrainyourdragon.com/explore/dragons/meatlug');