--==========================================================================================================================
-- GEDEMON YNAEMP (36e88483-48fe-4545-b85f-bafc50dde315)
--==========================================================================================================================
-- StartPosition 
------------------------------------------------------------	
CREATE TABLE IF NOT EXISTS StartPosition (MapName TEXT, Civilization TEXT, Leader TEXT, X INT default 0, Y INT default 0);
INSERT INTO StartPosition
		(Civilization,				Leader,						MapName,			X,	Y)
VALUES	('CIVILIZATION_CHINA',		'LEADER_ANT_WU_ZETIAN',		'GiantEarth',		81,	59),
		('CIVILIZATION_CHINA',		'LEADER_ANT_WU_ZETIAN',		'GreatestEarthMap',	85,	51),
		('CIVILIZATION_CHINA',		'LEADER_ANT_WU_ZETIAN',		'LargestEarth',		107,	74);
--==========================================================================================================================
-- GEDEMON CORDIFORM EARTH FOR YNAEMP (514aaa88-ffd2-475f-ace6-ea49b34a100a)
--==========================================================================================================================
-- StartPosition 
------------------------------------------------------------	
CREATE TABLE IF NOT EXISTS StartPosition (MapName TEXT, Civilization TEXT, Leader TEXT, X INT default 0, Y INT default 0);
INSERT INTO StartPosition
		(Civilization,				Leader,						MapName,			X,	Y)
VALUES	('CIVILIZATION_CHINA',		'LEADER_ANT_WU_ZETIAN',		'CordiformEarth',	61,	34);
--==========================================================================================================================
-- JFD RULE WITH FAITH (650ff782-47b4-4b46-93fb-00bef8da8b8e)
--==========================================================================================================================
-- Leader_Titles 
------------------------------------------------------------	
CREATE TABLE IF NOT EXISTS 
	Leader_Titles (
	LeaderType  											text 		 		default null,
	GovernmentType											text 	 			default null,
	LeaderTitle												text				default null,
	PolicyType  											text 		 		default null,
	UseFeminine												boolean				default 0,
	TitleIsFullName											boolean				default 0);	
	
INSERT INTO Leader_Titles
		(LeaderType, 				GovernmentType, 							PolicyType,				LeaderTitle)
VALUES	('LEADER_ANT_WU_ZETIAN',	'GOVERNMENT_CHIEFDOM',						null,					'LOC_GOVERNMENT_JFD_CHIEFDOM_LEADER_TITLE_ANT_WU_ZETIAN'), --Chiefdom
		('LEADER_ANT_WU_ZETIAN',	'GOVERNMENT_AUTOCRACY',						null,					'LOC_GOVERNMENT_JFD_AUTOCRACY_LEADER_TITLE_ANT_WU_ZETIAN'), --Autocracy
		('LEADER_ANT_WU_ZETIAN',	'GOVERNMENT_OLIGARCHY',						null,					'LOC_GOVERNMENT_JFD_OLIGARCHY_LEADER_TITLE_ANT_WU_ZETIAN'), --Oligarchy
		('LEADER_ANT_WU_ZETIAN',	'GOVERNMENT_MERCHANT_REPUBLIC',				null,					'LOC_GOVERNMENT_JFD_MERCHANT_REPUBLIC_LEADER_TITLE_ANT_WU_ZETIAN'), --Merchant Republic
		('LEADER_ANT_WU_ZETIAN',	'GOVERNMENT_MONARCHY',						null,					'LOC_GOVERNMENT_JFD_FEUDAL_MONARCHY_LEADER_TITLE_ANT_WU_ZETIAN'), --Feudal Monarchy
		('LEADER_ANT_WU_ZETIAN',	'GOVERNMENT_JFD_ABSOLUTE_MONARCHY',			null,					'LOC_GOVERNMENT_JFD_ABSOLUTE_MONARCHY_LEADER_TITLE_ANT_WU_ZETIAN'), --Absolute Monarchy
		('LEADER_ANT_WU_ZETIAN',	'GOVERNMENT_JFD_CONSTITUTIONAL_MONARCHY',	null,					'LOC_GOVERNMENT_JFD_CONSTITUTIONAL_MONARCHY_LEADER_TITLE_ANT_WU_ZETIAN'), --Constitutional Monarchy
		('LEADER_ANT_WU_ZETIAN',	'GOVERNMENT_JFD_NOBLE_REPUBLIC',			null,					'LOC_GOVERNMENT_JFD_NOBLE_REPUBLIC_LEADER_TITLE_ANT_WU_ZETIAN'), --Noble Republic
		('LEADER_ANT_WU_ZETIAN',	'GOVERNMENT_DEMOCRACY',						null,					'LOC_GOVERNMENT_JFD_LIBERAL_DEMOCRACY_LEADER_TITLE_ANT_WU_ZETIAN'), --Liberal Democracy
		('LEADER_ANT_WU_ZETIAN',	'GOVERNMENT_FASCISM',						null,					'LOC_GOVERNMENT_JFD_MILITARY_GUARDIANSHIP_LEADER_TITLE_ANT_WU_ZETIAN'), --Military Guardianship
		('LEADER_ANT_WU_ZETIAN',	null,										'POLICY_JFD_EMPIRE',	'LOC_GOVERNMENT_JFD_EMPIRE_LEADER_TITLE_ANT_WU_ZETIAN'); --Empire

DELETE FROM Leader_Titles 
WHERE LeaderType = 'LEADER_LEADER_ANT_WU_ZETIAN' AND GovernmentType IS NOT null
AND GovernmentType NOT IN (SELECT GovernmentType FROM Governments);

DELETE FROM Leader_Titles 
WHERE LeaderType = 'LEADER_LEADER_ANT_WU_ZETIAN' AND PolicyType IS NOT null
AND PolicyType NOT IN (SELECT PolicyType FROM Policies);
--==========================================================================================================================
--==========================================================================================================================