Delete Civilizations Utility

[FramedArchitect]

This is a small SQL Utility that simplifies the process of removing civilizations.

Enter any civilization you want to delete just once. Replaces unwieldy XML deletes.

--Delete unused Civilizations

CREATE TABLE DeleteCivilizations ( id INTEGER PRIMARY KEY AUTOINCREMENT, Civ TEXT );

---------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------
--Any Civilization in this list will be deleted

INSERT INTO DeleteCivilizations (Civ) VALUES ( 'CIVILIZATION_ENGLAND' );
INSERT INTO DeleteCivilizations (Civ) VALUES ( 'CIVILIZATION_FRANCE' );

---------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------

DELETE FROM Civilizations
WHERE Type IN (SELECT Civ FROM DeleteCivilizations);

DELETE FROM Civilization_CityNames
WHERE CivilizationType IN (SELECT Civ FROM DeleteCivilizations);

DELETE FROM Civilization_BuildingClassOverrides
WHERE CivilizationType IN (SELECT Civ FROM DeleteCivilizations);

DELETE FROM Civilization_UnitClassOverrides
WHERE CivilizationType IN (SELECT Civ FROM DeleteCivilizations);

DELETE FROM Civilization_FreeBuildingClasses
WHERE CivilizationType IN (SELECT Civ FROM DeleteCivilizations);

DELETE FROM Civilization_FreeTechs
WHERE CivilizationType IN (SELECT Civ FROM DeleteCivilizations);

DELETE FROM Civilization_FreeUnits
WHERE CivilizationType IN (SELECT Civ FROM DeleteCivilizations);

DELETE FROM Civilization_Leaders
WHERE CivilizationType IN (SELECT Civ FROM DeleteCivilizations);

DELETE FROM Civilization_Start_Along_Ocean
WHERE CivilizationType IN (SELECT Civ FROM DeleteCivilizations);

DELETE FROM Civilization_Start_Along_River
WHERE CivilizationType IN (SELECT Civ FROM DeleteCivilizations);

DELETE FROM Civilization_Start_Region_Priority
WHERE CivilizationType IN (SELECT Civ FROM DeleteCivilizations);

DELETE FROM Civilization_Start_Region_Avoid
WHERE CivilizationType IN (SELECT Civ FROM DeleteCivilizations);

DROP TABLE DeleteCivilizations;

 

[isnorden]

Thank you for saving players a lot of trouble; there are civs I don't even use as AI players unless I'm testing a mod that would affect them. Making the scroll list shorter this way is a big help!

 

[primordial stew]

Great code

Even better is that this method should be expandable for other things we want to get rid of (eg buildings, units, leaders..) which will result in much cleaner database.logs!