--==========================================================================================================================
-- GEDEMON YNAEMP
--==========================================================================================================================
-- 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_EGYPT',	'LEADER_JFD_PTOLEMY',	'GiantEarth',		29,	49),
		('CIVILIZATION_EGYPT',	'LEADER_JFD_PTOLEMY',	'GreatestEarthMap', 59,	36),
		('CIVILIZATION_EGYPT',	'LEADER_JFD_PTOLEMY',	'PlayEuropeAgain',	48,	69),
		('CIVILIZATION_EGYPT',	'LEADER_JFD_PTOLEMY',	'LargestEarth',		73,	11),
		('CIVILIZATION_EGYPT',	'LEADER_JFD_PTOLEMY',	'CordiformEarth',	44,	19);
--==========================================================================================================================
-- JFD RULE WITH FAITH
--==========================================================================================================================
-- 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_JFD_PTOLEMY',	'GOVERNMENT_CHIEFDOM',						null,					'LOC_GOVERNMENT_JFD_CHIEFDOM_LEADER_TITLE_JFD_PTOLEMY'),				--Chiefdom
		('LEADER_JFD_PTOLEMY',	'GOVERNMENT_JFD_HORDE',						null,					'LOC_GOVERNMENT_JFD_HORDE_LEADER_TITLE_JFD_PTOLEMY'),					--Horde
		('LEADER_JFD_PTOLEMY',	'GOVERNMENT_JFD_POLIS',						null,					'LOC_GOVERNMENT_JFD_POLIS_LEADER_TITLE_JFD_PTOLEMY'),					--Polis
		('LEADER_JFD_PTOLEMY',	'GOVERNMENT_AUTOCRACY',						null,					'LOC_GOVERNMENT_JFD_AUTOCRACY_LEADER_TITLE_JFD_PTOLEMY'),				--Autocracy
		('LEADER_JFD_PTOLEMY',	'GOVERNMENT_OLIGARCHY',						null,					'LOC_GOVERNMENT_JFD_OLIGARCHY_LEADER_TITLE_JFD_PTOLEMY'),				--Oligarchy
		('LEADER_JFD_PTOLEMY',	'GOVERNMENT_CLASSICAL_REPUBLIC',			null,					'LOC_GOVERNMENT_JFD_CLASSICAL_DEMOCRACY_LEADER_TITLE_JFD_PTOLEMY'),		--Classical Democracy
		('LEADER_JFD_PTOLEMY',	'GOVERNMENT_MERCHANT_REPUBLIC',				null,					'LOC_GOVERNMENT_JFD_MERCHANT_REPUBLIC_LEADER_TITLE_JFD_PTOLEMY'),		--Merchant Republic
		('LEADER_JFD_PTOLEMY',	'GOVERNMENT_MONARCHY',						null,					'LOC_GOVERNMENT_JFD_MONARCHY_LEADER_TITLE_JFD_PTOLEMY'),				--Feudal Monarchy
		('LEADER_JFD_PTOLEMY',	'GOVERNMENT_JFD_ABSOLUTE_MONARCHY',			null,					'LOC_GOVERNMENT_JFD_MONARCHY_LEADER_TITLE_JFD_PTOLEMY'),				--Absolute Monarchy
		('LEADER_JFD_PTOLEMY',	'GOVERNMENT_JFD_CONSTITUTIONAL_MONARCHY',	null,					'LOC_GOVERNMENT_JFD_MONARCHY_LEADER_TITLE_JFD_PTOLEMY'),				--Constitutional Monarchy
		('LEADER_JFD_PTOLEMY',	'GOVERNMENT_JFD_NOBLE_REPUBLIC',			null,					'LOC_GOVERNMENT_JFD_NOBLE_REPUBLIC_LEADER_TITLE_JFD_PTOLEMY'),			--Noble Republic
		('LEADER_JFD_PTOLEMY',	'GOVERNMENT_DEMOCRACY',						null,					'LOC_GOVERNMENT_JFD_LIBERAL_DEMOCRACY_LEADER_TITLE_JFD_PTOLEMY'),		--People's Republic
		('LEADER_JFD_PTOLEMY',	'GOVERNMENT_COMMUNISM',						null,					'LOC_GOVERNMENT_JFD_PEOPLES_REPUBLIC_LEADER_TITLE_JFD_PTOLEMY'),		--People's Republic
		('LEADER_JFD_PTOLEMY',	'GOVERNMENT_FASCISM',						null,					'LOC_GOVERNMENT_JFD_MILITARY_GUARDIANSHIP_LEADER_TITLE_JFD_PTOLEMY'),	--Military Guardianship
		('LEADER_JFD_PTOLEMY',	null,										'POLICY_JFD_EMPIRE',	'LOC_GOVERNMENT_JFD_EMPIRE_LEADER_TITLE_JFD_PTOLEMY');					--Empire
DELETE FROM Leader_Titles WHERE LeaderType = 'LEADER_JFD_PTOLEMY' AND GovernmentType IS NOT null AND GovernmentType NOT IN (SELECT GovernmentType FROM Governments);
DELETE FROM Leader_Titles WHERE LeaderType = 'LEADER_JFD_PTOLEMY' AND PolicyType IS NOT null AND PolicyType NOT IN (SELECT PolicyType FROM Policies);
--==========================================================================================================================
--==========================================================================================================================