@ElCid0204 You won't see anything useful in SQL files because the game uses numeric IDs for boosts and another table to match them with techs and civs. I use an Excel file that has definitions of triggers and their relation to techs and civs. It's almost 1100 rows.
To give you some idea below is a list of Boost Classes. It basically shows what the original game is capable of. Usually there's a subject given also (like a building type, unit type, etc.) X means that numeric value can be given. Thus with OWN_X_UNITS_OF_TYPE you can create many boosts for various amounts of different units. The number shows how many times a given class is used in current version of the mod (it totals to 585 as there are 117 techs and civs and each has assigned 5 different boosts to choose from).
I also know how to add new custom boosts, however this requires first some programming in Lua. Anyway, I've already added a few and created a framework.
To give you some idea below is a list of Boost Classes. It basically shows what the original game is capable of. Usually there's a subject given also (like a building type, unit type, etc.) X means that numeric value can be given. Thus with OWN_X_UNITS_OF_TYPE you can create many boosts for various amounts of different units. The number shows how many times a given class is used in current version of the mod (it totals to 585 as there are 117 techs and civs and each has assigned 5 different boosts to choose from).
I also know how to add new custom boosts, however this requires first some programming in Lua. Anyway, I've already added a few and created a framework.
AIRBASE_FOREIGN_CONTINENT 2
ARTIFACT_EXTRACTED 2
CITY_POPULATION 13
CLEAR_CAMP 5
CONSTRUCT_BUILDING 25
CREATE_PANTHEON 4
CREATED_NATIONAL_PARK 3
CULTURVATE_CIVIC 20
DISCOVER_CONTINENT 2
DISTRICT_APPEAL_LEVEL_MINIMUM_X 3
DOW_CASUS_BELLI 7
EMPIRE_POPULATION 19
FIND_NATURAL_WONDER 5
FOUND_RELIGION 4
HAVE_AN_ALLIANCE 5
HAVE_BUILDING_MOUNTAIN 3
HAVE_RESEARCH_AGREEMENT 6
HAVE_WONDER_PAST_X_ERA 8
HAVE_X_BUILDINGS 75
HAVE_X_CITIES_FOLLOWING_YOUR_RELIGION 4
HAVE_X_CORPS 5
HAVE_X_DISTRICTS 42
HAVE_X_GREAT_PEOPLE 8
HAVE_X_IMPROVEMENTS 44
HAVE_X_LAND_UNITS 7
HAVE_X_POLICY_SLOTS 6
HAVE_X_THEMED_BUILDINGS 2
HAVE_X_UNIQUE_SPECIALTY_DISTRICTS 13
HAVE_X_WONDERS 3
IMPROVE_SPECIFIC_RESOURCE 43
KILL_SPECIFIC_UNIT 6
KILL_WITH 17
MAINTAIN_X_TRADE_ROUTES 9
MEET_CIV 6
MEET_X_CITY_STATES 8
NONE_LATE_GAME_CRITICAL_TECH 26
NUM_BARBS_KILLED 12
NUM_IMPROVED_TILES 10
OWN_X_UNITS_OF_TYPE 43
RECEIVE_DOW 4
RESEARCH_TECH 15
SETTLE_COAST 4
TRAIN_UNIT 37
Last edited: