INSERT OR IGNORE INTO TechnologyPrereqs
(Technology, PrereqTech)
VALUES ('TECH_SHIPBUILDING','TECH_CELESTIAL_NAVIGATION'),
('TECH_CARTOGRAPHY','TECH_MILITARY_TACTICS'),
('TECH_STIRRUPS','TECH_CASTLES'),
('TECH_MILITARY_ENGINEERING','TECH_CASTLES'),
('TECH_PRINTING','TECH_CASTLES'),
('TECH_MASS_PRODUCTION','TECH_CARTOGRAPHY');
UPDATE Technologies SET EraType='ERA_MEDIEVAL', Cost='390' WHERE TechnologyType='TECH_CARTOGRAPHY' ;
UPDATE Technologies SET EraType='ERA_MEDIEVAL', Cost='300', UITreeRow=2 WHERE TechnologyType='TECH_CASTLES' ;
--UPDATE Technologies SET EraType='ERA_MEDIEVAL', Cost='300', UITreeRow=3 WHERE TechnologyType='TECH_MILITARY_ENGINEERING' ;
DELETE FROM TechnologyPrereqs WHERE Technology='TECH_MILITARY_ENGINEERING' AND PrereqTech='TECH_CONSTRUCTION' ;
DELETE FROM TechnologyPrereqs WHERE Technology='TECH_MASS_PRODUCTION' AND PrereqTech='TECH_SHIPBUILDING' ;
-- Civics stuff. Delete some existing prereqs and move stuff around to make the tree flow better
-- Swap prereqs of divine right and reformed church
DELETE FROM CivicPrereqs WHERE Civic='CIVIC_REFORMED_CHURCH' ;
DELETE FROM CivicPrereqs WHERE Civic='CIVIC_DIVINE_RIGHT' ;
INSERT OR IGNORE INTO CivicPrereqs
(Civic, PrereqCivic)
VALUES ('CIVIC_DIVINE_RIGHT','CIVIC_FEUDALISM'),
('CIVIC_REFORMED_CHURCH','CIVIC_CIVIL_SERVICE'),
('CIVIC_REFORMED_CHURCH','CIVIC_THEOLOGY');
-- Update civic costs
-- Swap cost of divine right and reformed church
CREATE TEMPORARY TABLE tblQuoCivicCost
(
QuoCivicType text,
QuoCost text
);
INSERT INTO tblQuoCivicCost
(QuoCivicType, QuoCost)
VALUES ('CIVIC_DIVINE_RIGHT', (SELECT Cost from Civics WHERE CivicType='CIVIC_DIVINE_RIGHT') ) ,
('CIVIC_REFORMED_CHURCH', (SELECT Cost from Civics WHERE CivicType='CIVIC_REFORMED_CHURCH') ) ;
/* UPDATE Civics SET Cost=(SELECT tblQuoCivicCost.QuoCost FROM tblQuoCivicCost WHERE tblQuoCivicCost.QuoCivicType='CIVIC_REFORMED_CHURCH'),
EraType='ERA_RENAISSANCE'
WHERE CivicType='CIVIC_DIVINE_RIGHT' ;
*/
UPDATE Civics SET UITreeRow=0
WHERE CivicType='CIVIC_DIVINE_RIGHT' ;
UPDATE Civics SET Cost=(SELECT tblQuoCivicCost.QuoCost FROM tblQuoCivicCost WHERE tblQuoCivicCost.QuoCivicType='CIVIC_DIVINE_RIGHT'),
EraType='ERA_MEDIEVAL'
WHERE CivicType='CIVIC_REFORMED_CHURCH' ;