-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `holozoo_db`
--

-- --------------------------------------------------------

--
-- Table structure for table `animal`
--

CREATE TABLE IF NOT EXISTS `animal` (
  `id_animal` int(11) NOT NULL AUTO_INCREMENT,
  `id_area` int(11) NOT NULL,
  `level` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `url_model` varchar(255) NOT NULL,
  `url_slika` varchar(255) NOT NULL,
  `endangerment_status` varchar(255) NOT NULL,
  `habitat` varchar(255) NOT NULL,
  `weight` varchar(255) NOT NULL,
  `diet` varchar(255) NOT NULL,
  `population` int(11) NOT NULL,
  `whole_world` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_animal`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `animal`
--

INSERT INTO `animal` (`id_animal`, `id_area`, `level`, `name`, `url_model`, `url_slika`, `endangerment_status`, `habitat`, `weight`, `diet`, `population`, `whole_world`) VALUES
(1, 1, 1, 'African elephant', 'ANIMALS FULL PACK/African Animals Pack/Elephant/Prefabs/Elephant_Legacy', 'img/elephant.png ', 'Critically endangered', 'Savanah', '6000.00', 'Herbivore', 415000, 0),
(2, 1, 1, 'Nile crocodile', 'ANIMALS FULL PACK/African Animals Pack/Crocodile/Prefabs/Crocodile_Legacy', 'img/krokodil.png ', 'Least concern', 'Nile river', 'Female: 40-250kg, Male: 220-750kg', 'Carnivore', 60000, 0),
(3, 1, 1, 'Hippopotamus', 'ANIMALS FULL PACK/African Animals Pack/Hippopotamus/Prefabs/Hippopotamus_PBR', 'img/hippo.png ', 'Vulnerable', 'Rivers, lakes, and other water bodies', '1,500 kg to 3,200 kg ', 'Herbivore', 125, 0),
(4, 1, 2, 'Lion ', 'ANIMALS FULL PACK/African Animals Pack/Lion and Lioness/Prefabs/Lion_Legacy', '', 'Vulnerable', 'Grassland, savanna, dense scrub, and open woodland', '190 kg', 'Carnivore', 20000, 0),
(5, 1, 2, 'Lioness', 'ANIMALS FULL PACK/African Animals Pack/Lion and Lioness/Prefabs/Lioness_Legacy', '', 'Vulnerable', 'Grassland, savanna, dense scrub, and open woodland', '130 kg', 'Carnivore', 20000, 0);

-- --------------------------------------------------------

--
-- Table structure for table `area`
--

CREATE TABLE IF NOT EXISTS `area` (
  `id_area` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id_area`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `area`
--

INSERT INTO `area` (`id_area`, `name`) VALUES
(1, 'Africa'),
(2, 'Europe'),
(3, 'Asia'),
(4, 'Australia'),
(5, 'New Zeland'),
(6, 'Antartica'),
(7, 'South America'),
(8, 'North America');

-- --------------------------------------------------------

--
-- Table structure for table `question`
--

CREATE TABLE IF NOT EXISTS `question` (
  `id_question` int(11) NOT NULL AUTO_INCREMENT,
  `id_animal` int(11) NOT NULL,
  `question_text` text NOT NULL,
  `correct_answer` int(1) NOT NULL,
  `answer_one` varchar(255) NOT NULL,
  `answer_two` varchar(255) NOT NULL,
  `answer_three` varchar(255) NOT NULL,
  PRIMARY KEY (`id_question`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `question`
--

INSERT INTO `question` (`id_question`, `id_animal`, `question_text`, `correct_answer`, `answer_one`, `answer_two`, `answer_three`) VALUES
(1, 1, 'Where does a whale live?', 2, 'African Savannah', 'Ocean', 'European jungles'),
(2, 2, 'What does a crocodile eat?', 1, 'Fish', 'Flowers', 'Coconut'),
(3, 1, 'What is african elephant\'s endangerment status?', 1, 'Critically endangered', 'Vulnerable', 'Not endangered'),
(4, 2, 'What is lion\'s diet?', 2, 'Herbivore', 'Carnivore', 'Least concern'),
(5, 1, 'What is african elephant\'s habitat?', 2, 'Jungle', 'Savannah', 'Steppe'),
(6, 3, 'What is hippopotamus weight? ', 3, '100', '200', '1,500'),
(7, 4, 'What is the main difference between lion and lioness?', 3, 'Tail', 'Claws', 'Mane'),
(8, 3, 'Where does a hippopotamus live?', 1, 'Rivers and lakes', 'Tundra', 'Desert');
COMMIT;

