--RELIGION GROUP
START TRANSACTION;
INSERT INTO religion_group (id_religion_group, name) VALUES (1, 'Christianity');
INSERT INTO religion_group (id_religion_group, name) VALUES (2, 'Islam');
INSERT INTO religion_group (id_religion_group, name) VALUES (3, 'Buddhism');
INSERT INTO religion_group (id_religion_group, name) VALUES (4, 'Judaism');
INSERT INTO religion_group (id_religion_group, name) VALUES (5, 'Other');
COMMIT;

--RELIGION
START TRANSACTION;
INSERT INTO religion (id_religion, name, religion_group) VALUES (1, 'Roman Catholic', 1);
INSERT INTO religion (id_religion, name, religion_group) VALUES (2, 'Sunni Islam', 2);
INSERT INTO religion (id_religion, name, religion_group) VALUES (3, 'Shia Islam', 2);
INSERT INTO religion (id_religion, name, religion_group) VALUES (4, 'Sufism', 2);
INSERT INTO religion (id_religion, name, religion_group) VALUES (5, 'Orthodox Judaism', 4);
INSERT INTO religion (id_religion, name, religion_group) VALUES (6, 'Conservative Judaism', 4);
INSERT INTO religion (id_religion, name, religion_group) VALUES (7, 'Protestantism', 1);
INSERT INTO religion (id_religion, name, religion_group) VALUES (8, 'Orthodox Catholic Church', 1);
INSERT INTO religion (id_religion, name, religion_group) VALUES (9, 'Mahayana', 3);
INSERT INTO religion (id_religion, name, religion_group) VALUES (10, 'Druidry', 5);
INSERT INTO religion (id_religion, name, religion_group) VALUES (11, 'Atheism', 5);
INSERT INTO religion (id_religion, name, religion_group) VALUES (12, 'Unknown', 5);
COMMIT;

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

--TERRORISTS GROUPS
START TRANSACTION;
INSERT INTO ter_group (id_group, name, abbr, country, religion, leader, dangerous, status) VALUES (1, 'Al-Qaeda', NULL, 2, 3, 1, '9', 'active');
INSERT INTO ter_group (id_group, name, abbr, country, religion, leader, dangerous, status) VALUES (2, 'Black Star', NULL, 8, 11, 0, '6', 'active');
INSERT INTO ter_group (id_group, name, abbr, country, religion, leader, dangerous, status) VALUES (3, 'Japanese Red Army', 'jra', 5, 12, 5, '7', 'active');
INSERT INTO ter_group (id_group, name, abbr, country, religion, leader, dangerous, status) VALUES (4, 'Continuity Irish Republican Army', 'cira', 3, 10, 2, '3', 'active');
INSERT INTO ter_group (id_group, name, abbr, country, religion, leader, dangerous, status) VALUES (5, 'Jayshullah', NULL, 4, 4, 4, '4', 'destroyed');
INSERT INTO ter_group (id_group, name, abbr, country, religion, leader, dangerous, status) VALUES (6, 'Jerusalem Warriors', NULL, 6, 5, 3, '8', 'active');
INSERT INTO ter_group (id_group, name, abbr, country, religion, leader, dangerous, status) VALUES (7, 'Red Brigades-Combatant Communist Party', 'br-pcc', 9, 11, 0, '7', 'asleep');
INSERT INTO ter_group (id_group, name, abbr, country, religion, leader, dangerous, status) VALUES (8, 'Red Hand Defenders', 'rhd', 9, 12, 0, '4', 'asleep');
COMMIT;

--PEOPLE
START TRANSACTION;
INSERT INTO people (id_people, high, eyes_color, id_group) VALUES (1, '171', 'brown', NULL);
INSERT INTO people (id_people, high, eyes_color, id_group) VALUES (2, '184', 'green', NULL);
INSERT INTO people (id_people, high, eyes_color, id_group) VALUES (3, '169', 'brown', NULL);
INSERT INTO people (id_people, high, eyes_color, id_group) VALUES (4, '193', 'blue', NULL);
INSERT INTO people (id_people, high, eyes_color, id_group) VALUES (5, '162', 'dark brown', NULL);
INSERT INTO people (id_people, high, eyes_color, id_group) VALUES (6, '164', 'blue', NULL);
INSERT INTO people (id_people, high, eyes_color, id_group) VALUES (7, '171', 'green yellow', NULL);
INSERT INTO people (id_people, high, eyes_color, id_group) VALUES (8, '179', 'dark brown', NULL);
COMMIT;

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

--TARGETS
START TRANSACTION;
INSERT INTO target (id_target, id_country, name_target, gps_x, gps_y, existing) VALUES (1, 1, 'White House', 38.897701, 77.036527, 1);
INSERT INTO target (id_target, id_country, name_target, gps_x, gps_y, existing) VALUES (2, 1, 'Pentagon', 38.87132, 77.05607, 1);
INSERT INTO target (id_target, id_country, name_target, gps_x, gps_y, existing) VALUES (3, 1, 'World Trade Center', 40.711526, 74.012328, 0);
INSERT INTO target (id_target, id_country, name_target, gps_x, gps_y, existing) VALUES (4, 1, 'United States Capitol', 49.767493, 13.372512, 1);
INSERT INTO target (id_target, id_country, name_target, gps_x, gps_y, existing) VALUES (5, 8, 'Buckingham Palace', 51.501395,  -0.141924, 1);
COMMIT;

--IDENTITIES
START TRANSACTION;
INSERT INTO people_identity (id_identity, id_people, firstname, surname, country, description, prime) VALUES (1, 1, 'Alhabar', 'Mumbarack', 2, NULL, 1);
INSERT INTO people_identity (id_identity, id_people, firstname, surname, country, description, prime) VALUES (2, 1, 'Abd-Al-Malik', 'Ladin', 2, NULL, 0);
INSERT INTO people_identity (id_identity, id_people, firstname, surname, country, description, prime) VALUES (3, 2, 'Reilly', 'OSullivan', 3, NULL, 1);
INSERT INTO people_identity (id_identity, id_people, firstname, surname, country, description, prime) VALUES (4, 2, 'Raul', 'Sullivan', 1, NULL, 0);
INSERT INTO people_identity (id_identity, id_people, firstname, surname, country, description, prime) VALUES (5, 3, 'Maysarah', 'Ishmael', 4, NULL, 1);
INSERT INTO people_identity (id_identity, id_people, firstname, surname, country, description, prime) VALUES (6, 3, 'Rahamim', 'Jerayesh', 6, NULL, 0);
INSERT INTO people_identity (id_identity, id_people, firstname, surname, country, description, prime) VALUES (7, 4, 'Abdur Rashid', 'Hassan', 2, NULL, 1);
INSERT INTO people_identity (id_identity, id_people, firstname, surname, country, description, prime) VALUES (8, 4, 'Sikandar', 'Jabbar', 4, NULL, 0);
INSERT INTO people_identity (id_identity, id_people, firstname, surname, country, description, prime) VALUES (9, 4, 'Issahar', 'Hadar', 6, NULL, 0);
INSERT INTO people_identity (id_identity, id_people, firstname, surname, country, description, prime) VALUES (10, 5, 'Sadaharu', 'Hashimoto', 5, NULL, 0);
INSERT INTO people_identity (id_identity, id_people, firstname, surname, country, description, prime) VALUES (11, 6, 'Masum', 'Amin', 2, NULL, 1);
INSERT INTO people_identity (id_identity, id_people, firstname, surname, country, description, prime) VALUES (12, 7, 'Jaraah', 'Faraq', 4, NULL, 1);
INSERT INTO people_identity (id_identity, id_people, firstname, surname, country, description, prime) VALUES (13, 8, 'Shazeb', 'Rashid', 2, NULL, 1);
INSERT INTO people_identity (id_identity, id_people, firstname, surname, country, description, prime) VALUES (0, 0, NULL, NULL, NULL, NULL, 1);
COMMIT;

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

--PHONES
START TRANSACTION;
INSERT INTO phone (id_identity, phone_number) VALUES (1, '603568965');
INSERT INTO phone (id_identity, phone_number) VALUES (3, '802456326');
INSERT INTO phone (id_identity, phone_number) VALUES (6, '546329815');
INSERT INTO phone (id_identity, phone_number) VALUES (7, '525235665');
INSERT INTO phone (id_identity, phone_number) VALUES (7, '569245879');
INSERT INTO phone (id_identity, phone_number) VALUES (9, '236589422');
COMMIT;

--GROUPS HAS WEAPONS
START TRANSACTION;
INSERT INTO group_has_weapon (group_id_group, weapon_id_weapon, expected_quantity) VALUES (1, 1, 7);
INSERT INTO group_has_weapon (group_id_group, weapon_id_weapon, expected_quantity) VALUES (2, 1, 12);
INSERT INTO group_has_weapon (group_id_group, weapon_id_weapon, expected_quantity) VALUES (3, 2, 2);
INSERT INTO group_has_weapon (group_id_group, weapon_id_weapon, expected_quantity) VALUES (4, 5, 6);
INSERT INTO group_has_weapon (group_id_group, weapon_id_weapon, expected_quantity) VALUES (5, 9, 17);
INSERT INTO group_has_weapon (group_id_group, weapon_id_weapon, expected_quantity) VALUES (6, 6, 3);
INSERT INTO group_has_weapon (group_id_group, weapon_id_weapon, expected_quantity) VALUES (7, 9, 5);
INSERT INTO group_has_weapon (group_id_group, weapon_id_weapon, expected_quantity) VALUES (8, 5, 8);
INSERT INTO group_has_weapon (group_id_group, weapon_id_weapon, expected_quantity) VALUES (1, 5, 1);
INSERT INTO group_has_weapon (group_id_group, weapon_id_weapon, expected_quantity) VALUES (3, 6, 6);
INSERT INTO group_has_weapon (group_id_group, weapon_id_weapon, expected_quantity) VALUES (7, 3, 18);
INSERT INTO group_has_weapon (group_id_group, weapon_id_weapon, expected_quantity) VALUES (2, 4, 7);
INSERT INTO group_has_weapon (group_id_group, weapon_id_weapon, expected_quantity) VALUES (5, 3, 4);
INSERT INTO group_has_weapon (group_id_group, weapon_id_weapon, expected_quantity) VALUES (3, 8, 2);
COMMIT;


--Group has enemy country

START TRANSACTION;
INSERT INTO group_has_enemy (id_group, id_country) VALUES (1, 1);
INSERT INTO group_has_enemy (id_group, id_country) VALUES (2, 3);
INSERT INTO group_has_enemy (id_group, id_country) VALUES (4, 7);
INSERT INTO group_has_enemy (id_group, id_country) VALUES (4, 8);
INSERT INTO group_has_enemy (id_group, id_country) VALUES (5, 1);
INSERT INTO group_has_enemy (id_group, id_country) VALUES (5, 8);
INSERT INTO group_has_enemy (id_group, id_country) VALUES (6, 2);
INSERT INTO group_has_enemy (id_group, id_country) VALUES (6, 4);
INSERT INTO group_has_enemy (id_group, id_country) VALUES (7, 1);
INSERT INTO group_has_enemy (id_group, id_country) VALUES (8, 5);

COMMIT;