FrankProjects/UltimateWarfare

View on GitHub
migrations/Version20180412202011/1-Research.sql

Summary

Maintainability
Test Coverage
INSERT INTO `research` (`id`, `name`, `image`, `cost`, `timestamp`, `description`, `active`) VALUES
(1, 'Research', 'research.gif', 2500, 180, 'Research new technological advancements', 1),
(2, 'Research Level 2', 'research.gif', 15000, 7200, 'Research new technological advancements', 1),
(3, 'Research Level 3', 'research.gif', 200000, 36000, 'Research new technological advancements', 1),
(4, 'Research Level 4', 'research.gif', 900000, 72000, 'Research new technological advancements', 1),
(5, 'Research Level 5', 'research.gif', 4000000, 160000, 'Research new technological advancements', 1),
(6, 'Research Level 6', 'research.gif', 35000000, 320000, 'Research new technological advancements', 1),
(7, 'Research Level 7', 'research.gif', 95000000, 700000, 'Research new technological advancements', 1),
(8, 'Research Level 8', 'research.gif', 125000000, 1500000, 'Research new technological advancements', 1),
(9, 'Research Level 9', 'research.gif', 185000000, 4000000, 'Research new technological advancements', 1),
(10, 'Research Level 10', 'research.gif', 325000000, 12000000, 'Research new technological advancements', 1),
(100, 'Special Operations', 'tech_special_operations.gif', 5000, 3600, 'Unlock the ability of special operations', 1),
(101, 'Special Operations 2', 'tech_special_operations.gif', 25000, 7200, 'Unlock the ability of more advanced special operations', 1),
(102, 'Special Operations 3', 'tech_special_operations.gif', 100000, 15000, 'Unlock the ability of more advanced special operations', 1),
(103, 'Special Operations 4', 'tech_special_operations.gif', 2500000, 45000, 'Unlock the ability of more advanced special operations', 1),
(104, 'Spy Technology', 'spy.gif', 20000, 7200, 'Spy technology can be used to spy on enemy countries', 1),
(105, 'Advanced Spy Technology', 'spy2.gif', 5000000, 150000, 'Advanced Spy Technology allows you to get more information about an enemy country', 1),
(110, 'Nuclear Technology', 'tech_nuclear.gif', 500000000, 604800, 'Unlocks the ability of Nuclear weapons', 1),
(200, 'Defensive operations network', 'op_protection.gif', 5000, 3600, 'The higher your protection level against special operations, the more chance your enemy fails.', 0),
(201, 'Defensive operations network 2', 'op_protection.gif', 25000, 7200, 'The higher your protection level against special operations, the more chance your enemy fails.', 0),
(202, 'Defensive operations network 3', 'op_protection.gif', 100000, 15000, 'The higher your protection level against special operations, the more chance your enemy fails.', 0),
(203, 'Defensive operations network 4', 'op_protection.gif', 750000, 35000, 'The higher your protection level against special operations, the more chance your enemy fails.', 0),
(204, 'Defensive operations network 5', 'op_protection.gif', 2500000, 80000, 'The higher your protection level against special operations, the more chance your enemy fails.', 0),
(205, 'Defensive operations network 6', 'op_protection.gif', 10000000, 200000, 'The higher your protection level against special operations, the more chance your enemy fails.', 0),
(206, 'Defensive operations network 7', 'op_protection.gif', 25000000, 500000, 'The higher your protection level against special operations, the more chance your enemy fails.', 0),
(207, 'Defensive operations network 8', 'op_protection.gif', 75000000, 1500000, 'The higher your protection level against special operations, the more chance your enemy fails.', 0),
(208, 'Defensive operations network 9', 'op_protection.gif', 250000000, 5000000, 'The higher your protection level against special operations, the more chance your enemy fails.', 0),
(209, 'Defensive operations network 10', 'op_protection.gif', 800000000, 19000000, 'The higher your protection level against special operations, the more chance your enemy fails.', 0),
(500, 'Overbuilding: Sub-level Terrain', 'overbuilding1.gif', 25000, 7200, 'Increases your buildingspace by 100% on all countries, but your construction costs will also increase by 100% when you go over your basic building space.', 0),
(501, 'Overbuilding: Sub-level Terrain 2', 'overbuilding2.gif', 100000, 12000, 'Increases your buildingspace by 200% on all countries, but your construction costs will also increase by 200% when you go over your basic building space.', 0),
(502, 'Overbuilding: Sub-level Terrain 3', 'overbuilding3.gif', 250000, 25000, 'Increases your buildingspace by 300% on all countries, but your construction costs will also increase by 300% when you go over your basic building space.', 0),
(503, 'Overbuilding: Sub-level Terrain 4', 'overbuilding4.gif', 750000, 35000, 'Increases your buildingspace by 400% on all countries, but your construction costs will also increase by 400% when you go over your basic building space.', 0),
(504, 'Overbuilding: Sub-level Terrain 5', 'overbuilding5.gif', 2500000, 55000, 'Increases your buildingspace by 500% on all countries, but your construction costs will also increase by 500% when you go over your basic building space.', 0),
(505, 'Overbuilding: Underground Contruction', 'overbuilding6.gif', 9000000, 75000, 'Increases your buildingspace by 600% on all countries, but your construction costs will also increase by 600% when you go over your basic building space.', 0),
(506, 'Overbuilding: Underground Contruction 2', 'overbuilding7.gif', 25000000, 100000, 'Increases your buildingspace by 700% on all countries, but your construction costs will also increase by 700% when you go over your basic building space.', 0),
(507, 'Overbuilding: Underground Contruction 3', 'overbuilding8.gif', 75000000, 230000, 'Increases your buildingspace by 800% on all countries, but your construction costs will also increase by 800% when you go over your basic building space.', 0),
(508, 'Overbuilding: Underground Contruction 4', 'overbuilding9.gif', 250000000, 500000, 'Increases your buildingspace by 900% on all countries, but your construction costs will also increase by 900% when you go over your basic building space.', 0),
(509, 'Overbuilding: Underground Contruction 5', 'overbuilding10.gif', 800000000, 1400000, 'Increases your buildingspace by 1000% on all countries, but your construction costs will also increase by 1000% when you go over your basic building space.', 0),
(600, 'Destroy Cash 1', 'destroy_cash.gif', 15000, 3600, 'Destroy 0 - 2% of your enemies cash reserves', 1),
(601, 'Destroy  Cash 2', 'destroy_cash.gif', 50000, 7200, 'Destroy 0 - 4% of your enemies cash reserves', 1),
(602, 'Destroy Cash 3', 'destroy_cash.gif', 200000, 15000, 'Destroy 0 - 6% of your enemies cash reserves', 1),
(603, 'Destroy Cash 4', 'destroy_cash.gif', 750000, 37000, 'Destroy 0 - 8% of your enemies cash reserves', 1),
(604, 'Destroy Cash 5', 'destroy_cash.gif', 2500000, 80000, 'Destroy 0 - 10% of your enemies cash reserves', 1),
(605, 'Destroy Food', 'destroy_food.gif', 15000, 3600, 'Destroy 0 - 5% of your enemies food reserves.', 1),
(606, 'Destroy Food 2', 'destroy_food.gif', 50000, 7200, 'Destroy 0 - 10% of your enemies food reserves.', 1),
(607, 'Destroy Food 3', 'destroy_food.gif', 150000, 15000, 'Destroy 0 - 15% of your enemies food reserves.', 1),
(608, 'Destroy Food 4', 'destroy_food.gif', 750000, 35000, 'Destroy 0 - 20% of your enemies food reserves.', 1),
(609, 'Destroy Food 5', 'destroy_food.gif', 2500000, 80000, 'Destroy 0 - 25% of your enemies food reserves.', 1),
(650, 'Chemical Warfare', 'chemical_warfare.gif', 15000, 3600, 'Destroy your enemies population by bombing their countries with chemical warheads', 1),
(651, 'Chemical Warfare 2', 'chemical_warfare.gif', 50000, 7200, 'Destroy 0 - 10% of your enemies population by bombing their countries with chemical warheads', 0),
(652, 'Chemical Warfare 3', 'chemical_warfare.gif', 150000, 15000, 'Destroy 0 - 15% of your enemies population by bombing their countries with chemical warheads', 0),
(653, 'Chemical Warfare 4', 'chemical_warfare.gif', 750000, 35000, 'Destroy 0 - 20% of your enemies population by bombing their countries with chemical warheads', 0),
(654, 'Chemical Warfare 5', 'chemical_warfare.gif', 2500000, 80000, 'Destroy 0 - 25% of your enemies population by bombing their countries with chemical warheads', 0);