SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';

CREATE SCHEMA IF NOT EXISTS `BigEyeStream` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;
USE `BigEyeStream` ;

-- -----------------------------------------------------
-- Table `BigEyeStream`.`people`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `BigEyeStream`.`people` (
  `id_people` INT NOT NULL AUTO_INCREMENT,
  `high` VARCHAR(45) NULL,
  `eyes_color` VARCHAR(45) NULL,
  PRIMARY KEY (`id_people`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `BigEyeStream`.`religion_group`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `BigEyeStream`.`religion_group` (
  `id_religion_group` INT NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(45) NULL,
  PRIMARY KEY (`id_religion_group`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `BigEyeStream`.`religion`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `BigEyeStream`.`religion` (
  `id_religion` INT NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(45) NULL,
  `religion_group` INT NULL,
  PRIMARY KEY (`id_religion`),
  INDEX `fk_religion_group_idx` (`religion_group` ASC))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `BigEyeStream`.`country`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `BigEyeStream`.`country` (
  `id_country` INT NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(45) NULL,
  `iso` VARCHAR(45) NULL,
  `phone_prefix` VARCHAR(45) NULL,
  PRIMARY KEY (`id_country`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `BigEyeStream`.`group`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `BigEyeStream`.`group` (
  `id_group` INT NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(45) NOT NULL,
  `abbr` VARCHAR(15) NULL,
  `country` INT NULL,
  `religion` INT NULL,
  `leader` INT NULL,
  `dangerous` VARCHAR(45) NULL,
  `status` VARCHAR(45) NULL,
  PRIMARY KEY (`id_group`),
  INDEX `fk_group_religion1_idx` (`religion` ASC),
  INDEX `fk_country_idx` (`country` ASC),
  INDEX `fk_peole_idx` (`leader` ASC))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `BigEyeStream`.`weapon`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `BigEyeStream`.`weapon` (
  `id_weapon` INT NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(45) NOT NULL,
  `power` INT NULL COMMENT 'In megatons',
  `range` INT NULL COMMENT 'In kilometers',
  `accuracy` INT NULL COMMENT 'Circular Error Probable',
  PRIMARY KEY (`id_weapon`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `BigEyeStream`.`target`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `BigEyeStream`.`target` (
  `id_target` INT NOT NULL AUTO_INCREMENT,
  `id_country` INT NULL,
  `name` VARCHAR(45) NULL,
  `gps_x` DOUBLE NULL,
  `gps_y` DOUBLE NULL,
  `exists` TINYINT(1) NULL,
  PRIMARY KEY (`id_target`),
  INDEX `fk_country_idx` (`id_country` ASC))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `BigEyeStream`.`attack`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `BigEyeStream`.`attack` (
  `id_people` INT NULL,
  `id_group` INT NULL,
  `id_target` INT NULL,
  `id_weapon` INT NULL,
  `status` VARCHAR(45) NULL,
  INDEX `people_idx` (`id_people` ASC),
  INDEX `group_idx` (`id_group` ASC),
  INDEX `target_idx` (`id_target` ASC),
  INDEX `weapon_idx` (`id_weapon` ASC))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `BigEyeStream`.`identity`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `BigEyeStream`.`identity` (
  `id_identity` INT NOT NULL AUTO_INCREMENT,
  `id_people` INT NULL,
  `name` VARCHAR(45) NULL,
  `surname` VARCHAR(45) NULL,
  `country` INT NULL,
  `description` VARCHAR(45) NULL,
  `main` TINYINT(1) NULL DEFAULT FALSE,
  INDEX `fk_people_idx` (`id_people` ASC),
  INDEX `fk_country_idx` (`country` ASC),
  PRIMARY KEY (`id_identity`))
ENGINE = InnoDB
COMMENT = '	';


-- -----------------------------------------------------
-- Table `BigEyeStream`.`email`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `BigEyeStream`.`email` (
  `id_identity` INT NULL,
  `email` VARCHAR(45) NULL,
  INDEX `fk_identity_idx` (`id_identity` ASC))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `BigEyeStream`.`phone`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `BigEyeStream`.`phone` (
  `id_identity` INT NULL,
  `number` VARCHAR(45) NULL,
  INDEX `fk_identity_idx` (`id_identity` ASC))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `BigEyeStream`.`group_has_weapon`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `BigEyeStream`.`group_has_weapon` (
  `group_id_group` INT NOT NULL,
  `weapon_id_weapon` INT NOT NULL,
  `expected_quantity` INT NULL,
  PRIMARY KEY (`group_id_group`, `weapon_id_weapon`),
  INDEX `fk_group_has_weapon_weapon1_idx` (`weapon_id_weapon` ASC),
  INDEX `fk_group_has_weapon_group_idx` (`group_id_group` ASC))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `BigEyeStream`.`people_has_group`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `BigEyeStream`.`people_has_group` (
  `people_id_people` INT NOT NULL,
  `group_id_group` INT NOT NULL,
  PRIMARY KEY (`people_id_people`, `group_id_group`),
  INDEX `fk_people_has_group_group1_idx` (`group_id_group` ASC),
  INDEX `fk_people_has_group_people1_idx` (`people_id_people` ASC))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `BigEyeStream`.`enemy`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `BigEyeStream`.`enemy` (
  `id_group` INT NOT NULL,
  `id_country` INT NOT NULL,
  PRIMARY KEY (`id_group`, `id_country`),
  INDEX `fk_group_has_country_country1_idx` (`id_country` ASC),
  INDEX `fk_group_has_country_group1_idx` (`id_group` ASC))
ENGINE = InnoDB;

USE `BigEyeStream` ;

-- -----------------------------------------------------
-- Placeholder table for view `BigEyeStream`.`leaders`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `BigEyeStream`.`leaders` (`leader` INT, `name` INT, `surname` INT);

-- -----------------------------------------------------
-- Placeholder table for view `BigEyeStream`.`whereis`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `BigEyeStream`.`whereis` (`gps_x` INT, `gps_y` INT);

-- -----------------------------------------------------
-- View `BigEyeStream`.`leaders`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `BigEyeStream`.`leaders`;
USE `BigEyeStream`;
CREATE  OR REPLACE VIEW `leaders` AS 
SELECT `leader`, `identity`.`name`, `identity`.`surname` FROM `group` 
LEFT JOIN `identity` ON `id_people`=`leader`; 
;

-- -----------------------------------------------------
-- View `BigEyeStream`.`whereis`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `BigEyeStream`.`whereis`;
USE `BigEyeStream`;
CREATE  OR REPLACE VIEW `whereis` AS
SELECT gps_x, gps_y FROM target WHERE name LIKE 'capitol';

-- -----------------------------------------------------
-- Data for table `BigEyeStream`.`people`
-- -----------------------------------------------------
START TRANSACTION;
USE `BigEyeStream`;
INSERT INTO `BigEyeStream`.`people` (`id_people`, `high`, `eyes_color`) VALUES (1, '171', 'brown');
INSERT INTO `BigEyeStream`.`people` (`id_people`, `high`, `eyes_color`) VALUES (2, '184', 'green');
INSERT INTO `BigEyeStream`.`people` (`id_people`, `high`, `eyes_color`) VALUES (3, '169', 'brown');
INSERT INTO `BigEyeStream`.`people` (`id_people`, `high`, `eyes_color`) VALUES (4, '193', 'blue');
INSERT INTO `BigEyeStream`.`people` (`id_people`, `high`, `eyes_color`) VALUES (5, '162', 'dark brown');

COMMIT;


-- -----------------------------------------------------
-- Data for table `BigEyeStream`.`religion_group`
-- -----------------------------------------------------
START TRANSACTION;
USE `BigEyeStream`;
INSERT INTO `BigEyeStream`.`religion_group` (`id_religion_group`, `name`) VALUES (1, 'Christianity');
INSERT INTO `BigEyeStream`.`religion_group` (`id_religion_group`, `name`) VALUES (2, 'Islam');
INSERT INTO `BigEyeStream`.`religion_group` (`id_religion_group`, `name`) VALUES (3, 'Buddhism');
INSERT INTO `BigEyeStream`.`religion_group` (`id_religion_group`, `name`) VALUES (4, 'Judaism');
INSERT INTO `BigEyeStream`.`religion_group` (`id_religion_group`, `name`) VALUES (5, 'Other');

COMMIT;


-- -----------------------------------------------------
-- Data for table `BigEyeStream`.`religion`
-- -----------------------------------------------------
START TRANSACTION;
USE `BigEyeStream`;
INSERT INTO `BigEyeStream`.`religion` (`id_religion`, `name`, `religion_group`) VALUES (1, 'Roman Catholic', 1);
INSERT INTO `BigEyeStream`.`religion` (`id_religion`, `name`, `religion_group`) VALUES (2, 'Sunni Islam', 2);
INSERT INTO `BigEyeStream`.`religion` (`id_religion`, `name`, `religion_group`) VALUES (3, 'Shia Islam', 2);
INSERT INTO `BigEyeStream`.`religion` (`id_religion`, `name`, `religion_group`) VALUES (4, 'Sufism', 2);
INSERT INTO `BigEyeStream`.`religion` (`id_religion`, `name`, `religion_group`) VALUES (5, 'Orthodox Judaism', 3);
INSERT INTO `BigEyeStream`.`religion` (`id_religion`, `name`, `religion_group`) VALUES (6, 'Conservative Judaism', 3);
INSERT INTO `BigEyeStream`.`religion` (`id_religion`, `name`, `religion_group`) VALUES (7, 'Protestantism', 1);
INSERT INTO `BigEyeStream`.`religion` (`id_religion`, `name`, `religion_group`) VALUES (8, 'Orthodox Catholic Church', 1);
INSERT INTO `BigEyeStream`.`religion` (`id_religion`, `name`, `religion_group`) VALUES (9, 'Mahayana', 4);
INSERT INTO `BigEyeStream`.`religion` (`id_religion`, `name`, `religion_group`) VALUES (10, 'Druidry', 5);

COMMIT;


-- -----------------------------------------------------
-- Data for table `BigEyeStream`.`country`
-- -----------------------------------------------------
START TRANSACTION;
USE `BigEyeStream`;
INSERT INTO `BigEyeStream`.`country` (`id_country`, `name`, `iso`, `phone_prefix`) VALUES (1, 'United States of America', 'usa', '1');
INSERT INTO `BigEyeStream`.`country` (`id_country`, `name`, `iso`, `phone_prefix`) VALUES (2, 'Iraq', 'irq', '964');
INSERT INTO `BigEyeStream`.`country` (`id_country`, `name`, `iso`, `phone_prefix`) VALUES (3, 'Ireland', 'irl', '353');
INSERT INTO `BigEyeStream`.`country` (`id_country`, `name`, `iso`, `phone_prefix`) VALUES (4, 'Iran', 'irn', '98');
INSERT INTO `BigEyeStream`.`country` (`id_country`, `name`, `iso`, `phone_prefix`) VALUES (5, 'Japan', 'jpn', '81');
INSERT INTO `BigEyeStream`.`country` (`id_country`, `name`, `iso`, `phone_prefix`) VALUES (6, 'Israel', 'isr', '972');
INSERT INTO `BigEyeStream`.`country` (`id_country`, `name`, `iso`, `phone_prefix`) VALUES (7, 'Canada', 'can', '1');
INSERT INTO `BigEyeStream`.`country` (`id_country`, `name`, `iso`, `phone_prefix`) VALUES (8, 'United Kingdom', 'gbr', '44');
INSERT INTO `BigEyeStream`.`country` (`id_country`, `name`, `iso`, `phone_prefix`) VALUES (9, 'Russia', 'rus', '7');

COMMIT;


-- -----------------------------------------------------
-- Data for table `BigEyeStream`.`group`
-- -----------------------------------------------------
START TRANSACTION;
USE `BigEyeStream`;
INSERT INTO `BigEyeStream`.`group` (`id_group`, `name`, `abbr`, `country`, `religion`, `leader`, `dangerous`, `status`) VALUES (1, 'Al-Qaeda', NULL, 2, 3, 1, '7', 'active');
INSERT INTO `BigEyeStream`.`group` (`id_group`, `name`, `abbr`, `country`, `religion`, `leader`, `dangerous`, `status`) VALUES (2, 'Black Star', NULL, 8, NULL, NULL, NULL, 'active');
INSERT INTO `BigEyeStream`.`group` (`id_group`, `name`, `abbr`, `country`, `religion`, `leader`, `dangerous`, `status`) VALUES (3, 'Japanese Red Army', 'jra', 5, NULL, NULL, NULL, 'active');
INSERT INTO `BigEyeStream`.`group` (`id_group`, `name`, `abbr`, `country`, `religion`, `leader`, `dangerous`, `status`) VALUES (4, 'Continuity Irish Republican Army', 'cira', 3, NULL, NULL, NULL, 'active');
INSERT INTO `BigEyeStream`.`group` (`id_group`, `name`, `abbr`, `country`, `religion`, `leader`, `dangerous`, `status`) VALUES (5, 'Jayshullah', NULL, 4, NULL, NULL, NULL, 'destroyed');
INSERT INTO `BigEyeStream`.`group` (`id_group`, `name`, `abbr`, `country`, `religion`, `leader`, `dangerous`, `status`) VALUES (6, 'Jerusalem Warriors', NULL, 6, NULL, NULL, NULL, 'active');
INSERT INTO `BigEyeStream`.`group` (`id_group`, `name`, `abbr`, `country`, `religion`, `leader`, `dangerous`, `status`) VALUES (7, 'Red Brigades-Combatant Communist Party', 'br-pcc', 9, NULL, NULL, NULL, 'asleep');
INSERT INTO `BigEyeStream`.`group` (`id_group`, `name`, `abbr`, `country`, `religion`, `leader`, `dangerous`, `status`) VALUES (8, 'Red Hand Defenders', 'rhd', 9, NULL, NULL, NULL, 'asleep');

COMMIT;


-- -----------------------------------------------------
-- Data for table `BigEyeStream`.`weapon`
-- -----------------------------------------------------
START TRANSACTION;
USE `BigEyeStream`;
INSERT INTO `BigEyeStream`.`weapon` (`id_weapon`, `name`, `power`, `range`, `accuracy`) VALUES (1, 'Scud-A', NULL, 180, 3000);
INSERT INTO `BigEyeStream`.`weapon` (`id_weapon`, `name`, `power`, `range`, `accuracy`) VALUES (2, 'Scud-B', NULL, 300, 450);
INSERT INTO `BigEyeStream`.`weapon` (`id_weapon`, `name`, `power`, `range`, `accuracy`) VALUES (3, 'Scud-C', NULL, 550, 700);
INSERT INTO `BigEyeStream`.`weapon` (`id_weapon`, `name`, `power`, `range`, `accuracy`) VALUES (4, 'Scud-D', NULL, 300, 50);
INSERT INTO `BigEyeStream`.`weapon` (`id_weapon`, `name`, `power`, `range`, `accuracy`) VALUES (5, 'MGM-140A', NULL, 128, 50);
INSERT INTO `BigEyeStream`.`weapon` (`id_weapon`, `name`, `power`, `range`, `accuracy`) VALUES (6, 'MGM-140B', NULL, 165, 50);
INSERT INTO `BigEyeStream`.`weapon` (`id_weapon`, `name`, `power`, `range`, `accuracy`) VALUES (7, 'MGM-168 ATacMS', NULL, 300, 50);
INSERT INTO `BigEyeStream`.`weapon` (`id_weapon`, `name`, `power`, `range`, `accuracy`) VALUES (8, 'LGM-118 Peacekeeper', 4750, 14000, 40);
INSERT INTO `BigEyeStream`.`weapon` (`id_weapon`, `name`, `power`, `range`, `accuracy`) VALUES (9, ' R-36M SS-18 Satan', 20000000, 16000, 220);

COMMIT;


-- -----------------------------------------------------
-- Data for table `BigEyeStream`.`target`
-- -----------------------------------------------------
START TRANSACTION;
USE `BigEyeStream`;
INSERT INTO `BigEyeStream`.`target` (`id_target`, `id_country`, `name`, `gps_x`, `gps_y`, `exists`) VALUES (1, 1, 'White House', 38.897701, 77.036527, true);
INSERT INTO `BigEyeStream`.`target` (`id_target`, `id_country`, `name`, `gps_x`, `gps_y`, `exists`) VALUES (2, 1, 'Pentagon', 38.87132, 77.05607, true);
INSERT INTO `BigEyeStream`.`target` (`id_target`, `id_country`, `name`, `gps_x`, `gps_y`, `exists`) VALUES (3, 1, 'World Trade Center', 40.711526, 74.012328, false);
INSERT INTO `BigEyeStream`.`target` (`id_target`, `id_country`, `name`, `gps_x`, `gps_y`, `exists`) VALUES (4, 1, 'United States Capitol', 49.767493, 13.372512, true);
INSERT INTO `BigEyeStream`.`target` (`id_target`, `id_country`, `name`, `gps_x`, `gps_y`, `exists`) VALUES (5, 8, 'Buckingham Palace', 51.501395,  -0.141924, true);

COMMIT;


-- -----------------------------------------------------
-- Data for table `BigEyeStream`.`identity`
-- -----------------------------------------------------
START TRANSACTION;
USE `BigEyeStream`;
INSERT INTO `BigEyeStream`.`identity` (`id_identity`, `id_people`, `name`, `surname`, `country`, `description`, `main`) VALUES (1, 1, 'Alhabar', 'Mumbarack', 2, NULL, 1);
INSERT INTO `BigEyeStream`.`identity` (`id_identity`, `id_people`, `name`, `surname`, `country`, `description`, `main`) VALUES (2, 1, 'Abd-Al-Malik', 'Ladin', 2, NULL, 0);
INSERT INTO `BigEyeStream`.`identity` (`id_identity`, `id_people`, `name`, `surname`, `country`, `description`, `main`) VALUES (3, 2, 'Reilly', 'O\'Sullivan', 3, NULL, 1);
INSERT INTO `BigEyeStream`.`identity` (`id_identity`, `id_people`, `name`, `surname`, `country`, `description`, `main`) VALUES (4, 2, 'Raul', 'Sullivan', 1, NULL, 0);
INSERT INTO `BigEyeStream`.`identity` (`id_identity`, `id_people`, `name`, `surname`, `country`, `description`, `main`) VALUES (5, 3, 'Maysarah', 'Ishmael', 4, NULL, 1);
INSERT INTO `BigEyeStream`.`identity` (`id_identity`, `id_people`, `name`, `surname`, `country`, `description`, `main`) VALUES (6, 3, 'Rahamim', 'Jerayesh', 6, NULL, 0);
INSERT INTO `BigEyeStream`.`identity` (`id_identity`, `id_people`, `name`, `surname`, `country`, `description`, `main`) VALUES (7, 4, 'Abdur Rashid', 'Hassan', 2, NULL, 1);
INSERT INTO `BigEyeStream`.`identity` (`id_identity`, `id_people`, `name`, `surname`, `country`, `description`, `main`) VALUES (8, 4, 'Sikandar', 'Jabbar', 4, NULL, 0);
INSERT INTO `BigEyeStream`.`identity` (`id_identity`, `id_people`, `name`, `surname`, `country`, `description`, `main`) VALUES (9, 4, 'Issahar', 'Hadar', 6, NULL, 0);
INSERT INTO `BigEyeStream`.`identity` (`id_identity`, `id_people`, `name`, `surname`, `country`, `description`, `main`) VALUES (10, 5, 'Sadaharu', 'Hashimoto', 5, NULL, 0);

COMMIT;


-- -----------------------------------------------------
-- Data for table `BigEyeStream`.`email`
-- -----------------------------------------------------
START TRANSACTION;
USE `BigEyeStream`;
INSERT INTO `BigEyeStream`.`email` (`id_identity`, `email`) VALUES (1, 'alhabar.mumbarack@mail.com');
INSERT INTO `BigEyeStream`.`email` (`id_identity`, `email`) VALUES (3, 'r.osullivan@mail.ie');
INSERT INTO `BigEyeStream`.`email` (`id_identity`, `email`) VALUES (2, 'Abd-Al-Malik1973@uymail.com');
INSERT INTO `BigEyeStream`.`email` (`id_identity`, `email`) VALUES (4, 'r.sullivan@usa.com');
INSERT INTO `BigEyeStream`.`email` (`id_identity`, `email`) VALUES (5, 'ishmael@mail.com');
INSERT INTO `BigEyeStream`.`email` (`id_identity`, `email`) VALUES (5, 'maysarah729@gmail.com');
INSERT INTO `BigEyeStream`.`email` (`id_identity`, `email`) VALUES (6, 'rjerayesh@mail.com');
INSERT INTO `BigEyeStream`.`email` (`id_identity`, `email`) VALUES (8, 'JabbarSikandar@gmail.com');
INSERT INTO `BigEyeStream`.`email` (`id_identity`, `email`) VALUES (8, 'warrior543@mail.com');
INSERT INTO `BigEyeStream`.`email` (`id_identity`, `email`) VALUES (9, 'hadarI@yahoo.com');
INSERT INTO `BigEyeStream`.`email` (`id_identity`, `email`) VALUES (10, 'hashimoto7@mail.yahoo.co.jp');

COMMIT;


-- -----------------------------------------------------
-- Data for table `BigEyeStream`.`phone`
-- -----------------------------------------------------
START TRANSACTION;
USE `BigEyeStream`;
INSERT INTO `BigEyeStream`.`phone` (`id_identity`, `number`) VALUES (1, '603568965');
INSERT INTO `BigEyeStream`.`phone` (`id_identity`, `number`) VALUES (3, '802456326');
INSERT INTO `BigEyeStream`.`phone` (`id_identity`, `number`) VALUES (6, '546329815');
INSERT INTO `BigEyeStream`.`phone` (`id_identity`, `number`) VALUES (7, '525235665');
INSERT INTO `BigEyeStream`.`phone` (`id_identity`, `number`) VALUES (7, '569245879');
INSERT INTO `BigEyeStream`.`phone` (`id_identity`, `number`) VALUES (9, '236589422');

COMMIT;


-- -----------------------------------------------------
-- Data for table `BigEyeStream`.`people_has_group`
-- -----------------------------------------------------
START TRANSACTION;
USE `BigEyeStream`;
INSERT INTO `BigEyeStream`.`people_has_group` (`people_id_people`, `group_id_group`) VALUES (1, 1);
INSERT INTO `BigEyeStream`.`people_has_group` (`people_id_people`, `group_id_group`) VALUES (1, 2);
INSERT INTO `BigEyeStream`.`people_has_group` (`people_id_people`, `group_id_group`) VALUES (2, 4);
INSERT INTO `BigEyeStream`.`people_has_group` (`people_id_people`, `group_id_group`) VALUES (3, 6);
INSERT INTO `BigEyeStream`.`people_has_group` (`people_id_people`, `group_id_group`) VALUES (4, 1);
INSERT INTO `BigEyeStream`.`people_has_group` (`people_id_people`, `group_id_group`) VALUES (4, 5);
INSERT INTO `BigEyeStream`.`people_has_group` (`people_id_people`, `group_id_group`) VALUES (5, 6);

COMMIT;


-- -----------------------------------------------------
-- Data for table `BigEyeStream`.`enemy`
-- -----------------------------------------------------
START TRANSACTION;
USE `BigEyeStream`;
INSERT INTO `BigEyeStream`.`enemy` (`id_group`, `id_country`) VALUES (1, 1);
INSERT INTO `BigEyeStream`.`enemy` (`id_group`, `id_country`) VALUES (2, 3);
INSERT INTO `BigEyeStream`.`enemy` (`id_group`, `id_country`) VALUES (4, 7);
INSERT INTO `BigEyeStream`.`enemy` (`id_group`, `id_country`) VALUES (4, 8);
INSERT INTO `BigEyeStream`.`enemy` (`id_group`, `id_country`) VALUES (5, 1);
INSERT INTO `BigEyeStream`.`enemy` (`id_group`, `id_country`) VALUES (5, 8);
INSERT INTO `BigEyeStream`.`enemy` (`id_group`, `id_country`) VALUES (6, 2);
INSERT INTO `BigEyeStream`.`enemy` (`id_group`, `id_country`) VALUES (6, 4);
INSERT INTO `BigEyeStream`.`enemy` (`id_group`, `id_country`) VALUES (7, 1);
INSERT INTO `BigEyeStream`.`enemy` (`id_group`, `id_country`) VALUES (8, 5);

COMMIT;


SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
