NcXfeL04

1--==========================================================================================================================
2-- JFD CULTURAL DIVERSITY
3--==========================================================================================================================
4-- Civilization_JFD_CultureTypes
5------------------------------	
6CREATE TABLE IF NOT EXISTS 
7Civilization_JFD_CultureTypes(
8	CivilizationType 							text 	REFERENCES Civilizations(Type) 			default null,
9	CultureType 								text											default null,
10	ArtDefineTag								text											default	null,
11	DefeatScreenEarlyTag						text											default	null,
12	DefeatScreenMidTag							text											default	null,
13	DefeatScreenLateTag							text											default	null,
14	IdealsTag									text											default	null,
15	SplashScreenTag								text											default	null,
16	SoundtrackTag								text											default	null,
17	UnitDialogueTag								text											default null);
18
19INSERT INTO Civilization_JFD_CultureTypes
20		(CivilizationType,				ArtDefineTag, CultureType,	DefeatScreenEarlyTag,			  DefeatScreenMidTag,				DefeatScreenLateTag,				IdealsTag, SplashScreenTag, SoundtrackTag, UnitDialogueTag)
21SELECT	'CIVILIZATION_UC_BEST_KOREA',	'JFD_Totalitarian', 'JFD_Totalitarian',	DefeatScreenEarlyTag, DefeatScreenMidTag,	DefeatScreenLateTag,	'JFD_Totalitarian', 'JFD_Totalitarian', 'JFD_Totalitarian', 'AS2D_SOUND_JFD_KOREAN';
22------------------------------	
23-- Civilizations
24------------------------------	
25UPDATE Civilizations 
26SET SoundtrackTag = 'JFD_Totalitarian'
27WHERE Type = 'CIVILIZATION_UC_BEST_KOREA'
28AND EXISTS (SELECT * FROM Civilization_JFD_CultureTypes WHERE SoundtrackTag = 'JFD_Totalitarian')
29AND EXISTS (SELECT * FROM JFD_GlobalUserSettings WHERE Type = 'JFD_CULDIV_SOUNDTRACK_ADDON' AND Value = 1);