1) Add a unique building chain.
- Open the DB table building_chain.
- Click the "Add record" button to add a new row.
- Copy and paste an existing record into the new record which is the same type as your new building chain.
- In the "key" column enter your new building chain. In this example it's "SHO_Region_Specialty_Silver_Mining".
When finished click the Apply button.
2) Add a unique building chain to a slot.
- Open the DB table building_chain_to_slots.
- Click the "Add record" button to add a new row.
- In the "chain" column select your new building chain.
- In the "slot" column select which building slot it uses. In this example it's "SHO_region_specialty_silver_mining".
When finished click the Apply button.
3) Assign an building levels to this building chain.
- Open the DB table building_levels.
- Click the "Add record" button to add a new row.
- Copy and paste an existing record into the new record which is the same type as your new building chain.
- In the "level_name" column enter the name of the your new building level. In this example it's "SHO_Region_Specialty_Silver_Mining_1_Surface_Minin".
- In the "chain" column select the your new building chain. In this example it's "SHO_Region_Specialty_Silver_Mining".
- Set the "create_time" to how many turns you want the building to take to build.
- Set the "create_cost" to how much you want the building to cost to build.
- Set the "destruction_terminator" to true if you want the building to be indestructable.
- Set the "faction_unique" to true if you want only certain factions to have this building.
- In the "religion_requirement" column you can limit this building to a specific religion.
- In the "first_in_world_bundle" column you can have an event play when this building is built.
- In the "resource requirements" column you can prevent a faction constructing this building if they don't have this resource.
- In the "working model" column you can change the model used on the campaign map.
- Repeat for all the building levels you want to add.
When finished click the Apply button.
4) Add upgrades to this building.
- Open the DB table building_upgrades_junction.
- Click the "Add record" button to add a new row.
- In the "from" column select a building. In this example it's "SHO_Region_Specialty_Silver_Mining_1_Surface_Minin".
- In the "to" column select the building's upgrade.
When finished click the Apply button.
5) Add a unique description to this building.
- Open the DB table building_description_texts.
- Click the "Add record" button to add a new row.
- In the "key" column enter your new building's description. In this example it's "SHO_Region_Specialty_Silver_Mining_1_Description".
- In the "short_description" column enter a short description of this building.
- In the "long_description" column enter a long description of this building.
When finished click the Apply button.
6) Add this building to a culture.
- Open the DB table building_culture_variants.
- Click the "Add record" button to add a new row.
- Copy and paste an existing record into the new record which is the same type as your new building's culture.
- In the "building" column select your building. In this example it's "SHO_Region_Specialty_Silver_Mining_1_Surface_Minin".
- In the "culture" column select the building's culture.
- In the "artpiece" column select the building's artpiece.
- In the "description" column selectr your building's description.
- In the "icon" column select the building's icon.
When finished click the Apply button.
7) Require a technology to this building.
- Open the DB table building_level_required_technology_junctions.
- Click the "Add record" button to add a new row.
- Copy and paste an existing record into the new record which is the same type as your new building's culture.
- In the "building_level" column select your building level. In this example it's "SHO_Region_Specialty_Silver_Mining_1_Surface_Minin".
- In the "technology_key" column select the technology that the player must research before they can build this building. In this example it's "shogun_civil_core_tax_reform".
When finished click the Apply button.
8) Add an effect to this building.
- Open the DB table building_effects_junction.
- Click the "Add record" button to add a new row.
- Copy and paste an existing record into the new record which is the same type as your new building's culture.
- In the "building" column select your building level. In this example it's "SHO_Region_Specialty_Silver_Mining_1_Surface_Minin".
- In the "effect" column select the effect. In this example, it's "gdp_mine".
- In the "value" column select the level of the effect.
When finished click the Apply button.
9) Add a factionwide effect to this building.
- Open the DB table building_factionwide_effects_junctions.
- Click the "Add record" button to add a new row.
- Copy and paste an existing record into the new record which is the same type as your new building's culture.
- In the "building" column select your building level. In this example it's "SHO_Region_Specialty_Silver_Mining_3_Mining_Comple".
- In the "effect" column select the effect. In this example, it's "gdp_mine".
- In the "effect_value" column select the level of the effect.
When finished click the Apply button.
10) Add an armed citizenry to this building.
- Open the DB table building_level_armed_citizenry_junctions.
- Click the "Add record" button to add a new row.
- Copy and paste an existing record into the new record which is the same type as your new building's culture.
- In the "building_level" column select your building level. In this example it's "SHO_Region_Specialty_Silver_Mining_3_Mining_Comple".
- In the "unit" column select the effect. In this example, it's "Inf_Spear_Yari_Ashigaru_new_Citizenry".
- In the "priority" column select how important this unit is. The less important units won't appear if there would be more than 20 units in this settlement.
When finished click the Apply button.
11) Add a recruitable unit to this building.
- Open the DB table building_units_allowed.
- Click the "Add record" button to add a new row.
- Copy and paste an existing record into the new record which is the same type as your new building's culture.
- In the "building" column select your building level. In this example it's "SHO_Region_Specialty_Silver_Mining_3_Mining_Comple".
- In the "unit" column select the effect. In this example, it's "Inf_Missile_Bow_Ashigaru".
- In the "XP" column select the level of XP the unit starts with.
When finished click the Apply button.