When creating a mod for the new Polish leader, I ran into the problem of incorporating Polish subculture. I tested three possible options.
1)
CREATE TABLE IF NOT EXISTS Civilization_JFD_CultureTypes(CivilizationType, CultureType, SubCultureType, ArtDefineTag, DecisionsTag, DefeatScreenEarlyTag, DefeatScreenMidTag, DefeatScreenLateTag, IdealsTag, SplashScreenTag, SoundtrackTag, UnitDialogueTag);
INSERT INTO Civilization_JFD_CultureTypes
(CivilizationType, ArtDefineTag, CultureType, DefeatScreenEarlyTag, DefeatScreenMidTag, DefeatScreenLateTag, IdealsTag, SplashScreenTag, SoundtrackTag, UnitDialogueTag)
SELECT 'CIVILIZATION_ZRQ_POLAND_JADWIGA', ArtDefineTag, CultureType, DefeatScreenEarlyTag, DefeatScreenMidTag, DefeatScreenLateTag, IdealsTag, SplashScreenTag, SoundtrackTag, UnitDialogueTag
FROM Civilization_JFD_CultureTypes WHERE CivilizationType = 'CIVILIZATION_POLAND';
If so, then Poland is given unique components of Central Europe.
2)
CREATE TABLE IF NOT EXISTS Civilization_JFD_CultureTypes(CivilizationType, CultureType, SubCultureType, ArtDefineTag, DecisionsTag, DefeatScreenEarlyTag, DefeatScreenMidTag, DefeatScreenLateTag, IdealsTag, SplashScreenTag, SoundtrackTag, UnitDialogueTag);
INSERT INTO Civilization_JFD_CultureTypes
(CivilizationType, ArtDefineTag, CultureType, SubCultureType, DefeatScreenEarlyTag, DefeatScreenMidTag, DefeatScreenLateTag, IdealsTag, SplashScreenTag, SoundtrackTag, UnitDialogueTag)
SELECT 'CIVILIZATION_ZRQ_POLAND_JADWIGA', ArtDefineTag, CultureType, SubCultureType, DefeatScreenEarlyTag, DefeatScreenMidTag, DefeatScreenLateTag, IdealsTag, SplashScreenTag, SoundtrackTag, UnitDialogueTag
FROM Civilization_JFD_CultureTypes WHERE CivilizationType = 'CIVILIZATION_POLAND';
If so, then Poland is given unique components of Central Europe (as in the first option).
3)
CREATE TABLE IF NOT EXISTS Civilization_JFD_CultureTypes(CivilizationType, CultureType, SubCultureType, ArtDefineTag, DecisionsTag, DefeatScreenEarlyTag, DefeatScreenMidTag, DefeatScreenLateTag, IdealsTag, SplashScreenTag, SoundtrackTag, UnitDialogueTag);
INSERT INTO Civilization_JFD_CultureTypes
(CivilizationType, ArtDefineTag, SubCultureType, DefeatScreenEarlyTag, DefeatScreenMidTag, DefeatScreenLateTag, IdealsTag, SplashScreenTag, SoundtrackTag, UnitDialogueTag)
SELECT 'CIVILIZATION_ZRQ_POLAND_JADWIGA', ArtDefineTag, SubCultureType, DefeatScreenEarlyTag, DefeatScreenMidTag, DefeatScreenLateTag, IdealsTag, SplashScreenTag, SoundtrackTag, UnitDialogueTag
FROM Civilization_JFD_CultureTypes WHERE CivilizationType = 'CIVILIZATION_POLAND';
If so, then Poland doesn't recognize any components from the 5/6 UC mod. However, before the latest update, this variant recognized the correct West Slavic components!
And this problem only arises for subcultures. Cultures are fine, as confirmed by several mods I've already made. In general, is it possible to simply make all subcultures separate cultures? After all, subcultures are no different in meaning from cultures anyway (they have the same number of unique components, which are no stronger or weaker than those of cultures). I don't think subcultures make any sense. At the same time, there seem to be certain problems with their recognition. Just in case, I'm attaching my mod. It's possible there were some mistakes on my part, although this isn't the first mod. I do roughly the same thing in every mod.