-- phpMyAdmin SQL Dump
-- version 2.8.0.3
-- http://www.phpmyadmin.net
-- 
-- Počítač: 127.0.0.1:3306
-- Vygenerováno: Středa 03. ledna 2007, 00:14
-- Verze MySQL: 5.0.18
-- Verze PHP: 5.1.2

SET FOREIGN_KEY_CHECKS=0;
-- 
-- Databáze: `terorist_cell`
-- 

-- 
-- Vypisuji data pro tabulku `agent`
-- 

INSERT INTO `agent` (`id`, `cell_id`, `human_id`, `codename`, `compromited`, `level`) VALUES (1, 1, 1, 'JakaNe', 0, 3),
(2, 1, 2, 'Bulb', 1, 4),
(3, 8, 2, 'Dioda', 0, 4),
(4, 1, 3, 'Kolumbus', 0, 7),
(5, 2, 4, 'Prezident', 0, 2),
(6, 2, 6, 'Disease', 0, 4),
(7, 2, 7, 'Pregnant', 1, 7),
(8, 13, 7, 'Seno', 1, 7),
(9, 13, 8, 'Sci-Fi', 0, 9),
(10, 10, 10, 'Down-Hiller', 0, 7),
(11, 14, 10, 'Skier', 0, 5),
(12, 4, 10, 'RaceMan', 0, 5),
(13, 4, 11, 'Prime Minister', 0, 2),
(14, 3, 15, 'Sergejevic', 0, 1),
(15, 9, 15, 'Puskin', 0, 1),
(16, 6, 16, 'Golden Hand', 1, 6),
(17, 12, 16, 'Gold', 1, 6),
(18, 7, 17, 'Snake', 0, 3),
(19, 8, 17, 'Venom', 0, 3),
(20, 5, 18, 'Bump', 0, 9),
(21, 11, 19, 'Spindler Muhle', 0, 7),
(22, 12, 20, 'Chapadylko', 0, 6),
(23, 12, 21, 'Hepcik', 0, 5),
(24, 9, 22, 'Spenat', 0, 8),
(25, 7, 22, 'Muscle', 0, 8),
(26, 14, 22, 'Ganja', 0, 8),
(27, 13, 23, 'Bomba', 0, 9),
(28, 6, 24, 'Bandaska', 0, 8);

-- 
-- Vypisuji data pro tabulku `agent_has_function`
-- 

INSERT INTO `agent_has_function` (`agent_id`, `specification_id`) VALUES (1, 1),
(3, 1),
(5, 1),
(8, 1),
(10, 1),
(11, 1),
(12, 1),
(14, 1),
(15, 1),
(16, 1),
(17, 1),
(18, 1),
(20, 1),
(21, 1),
(1, 2),
(6, 2),
(13, 2),
(14, 2),
(16, 2),
(22, 2),
(4, 3),
(9, 3),
(14, 3),
(15, 3),
(20, 3),
(23, 3),
(24, 3),
(25, 3),
(26, 3),
(27, 3),
(28, 3),
(2, 4),
(7, 4),
(14, 4),
(17, 4),
(19, 4),
(27, 4);

-- 
-- Vypisuji data pro tabulku `cell`
-- 

INSERT INTO `cell` (`id`, `country_id`, `organization_id`, `superior_cell`) VALUES (1, 4, 1, 1),
(2, 4, 1, 1),
(3, 3, 1, 2),
(4, 3, 1, 2),
(5, 2, 1, 2),
(6, 9, 1, 1),
(7, 8, 1, 4),
(8, 1, 2, 8),
(9, 5, 2, 8),
(10, 4, 2, 9),
(11, 7, 2, 9),
(12, 5, 2, 9),
(13, 3, 3, 13),
(14, 3, 3, 13);

-- 
-- Vypisuji data pro tabulku `country`
-- 

INSERT INTO `country` (`id`, `name`) VALUES (1, 'Oz'),
(2, 'Kalifornie'),
(3, 'Nevada'),
(4, 'Zemeplocha'),
(5, 'Kazachstan'),
(6, 'Namibie'),
(7, 'Kokosove ostrovy'),
(8, 'Oregano'),
(9, 'Decapodie');

-- 
-- Vypisuji data pro tabulku `human`
-- 

INSERT INTO `human` (`id`, `country_id`, `name`, `surename`) VALUES (1, 7, 'Jakazan', 'Nemeklan'),
(2, 1, 'Thomas A.', 'Edison'),
(3, 4, 'Peter', 'Falk'),
(4, 4, 'Thomas', 'Jefferson'),
(5, 3, 'Carl', 'Lindt'),
(6, 7, 'Lepron', 'Kortel'),
(7, 7, 'Onehda', 'Nasene'),
(8, 6, 'Bratri', 'Strugacti'),
(9, 7, 'Filip', 'Trejbal'),
(10, 4, 'Ondrej', 'Bank'),
(11, 2, 'Ehud', 'Olmert'),
(12, 7, 'Rastafaran', 'Chomelan'),
(13, 7, 'Kiglijev', 'Kalenda'),
(14, 3, 'Opteron', 'Chocholojev'),
(15, 4, 'Evzen', 'Onegin'),
(16, 5, 'Agamemnon', 'Zlaty'),
(17, 1, 'Uzovka', 'Obecna'),
(18, 1, 'Sarka', 'Zahrobska'),
(19, 2, 'Bohumil', 'Zeman'),
(20, 3, 'Obri', 'Olihen'),
(21, 3, 'Thomas', 'Pepermann'),
(22, 2, 'Pepek', 'Namornik'),
(23, 4, 'Alberto', 'Tomba'),
(24, 7, 'Ivica', 'Kostelic');

-- 
-- Vypisuji data pro tabulku `human_has_weapon`
-- 

INSERT INTO `human_has_weapon` (`human_id`, `weapon_id`, `since`, `onto`) VALUES (1, 1, '2006-12-31', NULL),
(2, 1, '2006-12-28', '2006-12-31'),
(2, 2, '2006-12-28', NULL),
(2, 3, '2006-12-28', NULL),
(2, 4, '2006-12-28', '2006-12-29'),
(2, 5, '2006-12-28', NULL),
(2, 6, '2006-12-28', '2006-12-28'),
(4, 7, '2006-12-28', '2007-01-03'),
(4, 8, '2006-12-28', '2007-01-03'),
(4, 9, '2006-12-28', NULL),
(5, 4, '2006-12-29', '2007-03-08'),
(5, 20, '2007-01-02', NULL),
(6, 6, '2006-12-28', NULL),
(7, 12, '2007-05-13', '2007-06-21'),
(8, 7, '2007-01-03', '2007-06-25'),
(9, 10, '2006-12-28', '2007-01-08'),
(9, 11, '2006-12-28', NULL),
(9, 21, '2007-01-05', '2007-01-07'),
(10, 12, '2007-06-21', NULL),
(11, 7, '2007-06-25', NULL),
(12, 10, '2007-01-08', NULL),
(12, 12, '2006-12-28', '2006-12-29'),
(12, 13, '2006-12-28', NULL),
(12, 14, '2006-12-28', NULL),
(12, 15, '2006-12-28', '2006-12-28'),
(13, 4, '2007-03-08', '2007-05-12'),
(13, 16, '2006-12-28', NULL),
(15, 17, '2006-12-28', NULL),
(15, 18, '2006-12-28', NULL),
(15, 19, '2006-12-28', NULL),
(15, 20, '2006-12-28', '2007-01-02'),
(15, 21, '2006-12-28', '2007-01-05'),
(15, 22, '2006-12-28', NULL),
(15, 23, '2006-12-28', NULL),
(17, 21, '2007-01-07', NULL),
(18, 15, '2006-12-28', NULL),
(19, 4, '2007-05-12', NULL),
(21, 12, '2006-12-29', '2007-02-08'),
(23, 12, '2007-02-08', '2007-05-13'),
(24, 8, '2007-01-03', NULL);

-- 
-- Vypisuji data pro tabulku `human_knows_human`
-- 

INSERT INTO `human_knows_human` (`who`, `whom`) VALUES (2, 1),
(3, 1),
(1, 2),
(2, 2),
(3, 2),
(5, 2),
(6, 2),
(17, 2),
(1, 3),
(2, 3),
(1, 4),
(6, 4),
(7, 4),
(8, 4),
(24, 4),
(2, 5),
(13, 5),
(15, 5),
(2, 6),
(4, 6),
(7, 6),
(4, 7),
(6, 7),
(8, 7),
(10, 7),
(23, 7),
(4, 8),
(7, 8),
(11, 8),
(23, 8),
(15, 9),
(17, 9),
(4, 10),
(7, 10),
(11, 10),
(15, 10),
(22, 10),
(8, 11),
(10, 11),
(12, 12),
(18, 12),
(21, 12),
(5, 13),
(19, 13),
(2, 15),
(4, 15),
(5, 15),
(9, 15),
(22, 15),
(1, 16),
(15, 16),
(20, 16),
(21, 16),
(24, 16),
(2, 17),
(9, 17),
(10, 17),
(22, 17),
(4, 18),
(12, 18),
(13, 19),
(15, 19),
(16, 20),
(21, 20),
(12, 21),
(16, 21),
(20, 21),
(23, 21),
(10, 22),
(15, 22),
(17, 22),
(7, 23),
(8, 23),
(21, 23),
(4, 24),
(16, 24);

-- 
-- Vypisuji data pro tabulku `ideology`
-- 

INSERT INTO `ideology` (`id`, `name`, `description`) VALUES (1, 'komunizmus', 'Komunisticka ideologie\0'),
(2, 'islamismus', 'Fundamentalni islamiste\0'),
(3, 'demokracie', 'Tajne sluzby demokratickych zemi\0'),
(4, 'nacizmus', 'Nacisticke organizace\0'),
(5, 'teletubbies', 'Podzemni hnuti teletubbies\0');

-- 
-- Vypisuji data pro tabulku `murders`
-- 

INSERT INTO `murders` (`victim_id`, `occurs`, `weapon_id`) VALUES (1, '2007-01-05', 17),
(3, '2007-02-01', 4),
(5, '2007-02-02', 10),
(22, '2006-12-31', 11),
(24, '2007-05-07', 22);

-- 
-- Vypisuji data pro tabulku `organization`
-- 

INSERT INTO `organization` (`id`, `work_for`, `ideology_id`, `name`, `danger`) VALUES (1, 1, 5, 'Oz-tubbies', 9),
(2, 3, 2, 'K.L.M.N.', 6),
(3, 7, 1, 'QWERTZ rulezz', 9);

-- 
-- Vypisuji data pro tabulku `specification`
-- 

INSERT INTO `specification` (`id`, `name`, `definition`) VALUES (1, 'Boss', 'Sefuje  dane bunce a zarizuje v ni vse potrebne\0'),
(2, 'BomberMan', 'Rozumi vybusninam a vyhazovani veci do povetri...\0'),
(3, 'Vojak', 'Pesak, radovy clen bunky\0'),
(4, 'Speh', 'Infilltruje se do jinych organizaci a zjistuje co a jak\0');

-- 
-- Vypisuji data pro tabulku `trader`
-- 

INSERT INTO `trader` (`human_id`, `mobile`) VALUES (2, 777987234),
(4, 602343299),
(9, 605776390),
(12, 608776897),
(13, 908733453),
(15, 609870908);

-- 
-- Vypisuji data pro tabulku `weapon`
-- 

INSERT INTO `weapon` (`id`, `trader_id`, `type_id`) VALUES (1, 2, 1),
(2, 2, 1),
(3, 2, 4),
(4, 2, 5),
(5, 2, 5),
(6, 2, 5),
(7, 4, 2),
(8, 4, 7),
(9, 4, 7),
(10, 9, 6),
(11, 9, 6),
(12, 12, 2),
(13, 12, 2),
(14, 12, 2),
(15, 12, 2),
(16, 13, 3),
(17, 15, 1),
(18, 15, 1),
(19, 15, 4),
(20, 15, 4),
(21, 15, 7),
(22, 15, 2),
(23, 15, 7);

-- 
-- Vypisuji data pro tabulku `weapon_types`
-- 

INSERT INTO `weapon_types` (`id`, `name`, `effect`, `danger_degree`, `range`) VALUES (1, 'nuz', 'Porezani\0', 2, 1),
(2, 'AK47', 'Zalezi na munici, vetsinou vrazda smrt zabiti\0', 5, 500),
(3, 'Little john', 'Mensi atomovy hribek\0', 10, 10000),
(4, 'luk', 'Strili sipy - muzou vas propichnout\0', 3, 100),
(5, 'boxer', 'Vyrazene zuby, zlamana celist a kosti.\0', 1, 1),
(6, 'prachovka', 'Pri trose stesti vypichnute oko.\0', 0, 2),
(7, 'glock', 'Kulky, vrazda smrt zabiti.\0', 4, 100);

SET FOREIGN_KEY_CHECKS=1;