· 8 years ago · Nov 25, 2017, 02:32 AM
1--==========================================================================================================================
2-- JFD RULE WITH FAITH
3--==========================================================================================================================
4-- Civilization_Titles
5--------------------------------------------------------------------------------------------------------------------------
6CREATE TABLE IF NOT EXISTS
7 Civilization_Titles (
8 CivilizationType text default null,
9 GovernmentType text default null,
10 CivilizationTitle text default null,
11 PolicyType text default null);
12
13INSERT INTO CivilizationTitle
14 (CivilizationType, GovernmentType, PolicyType, LeaderTitle)
15VALUES ('CIVILIZATION_LIME_THULE', 'GOVERNMENT_CHIEFDOM', null, 'LOC_GOVERNMENT_JFD_CHIEFDOM_LEADER_TITLE_LIME_THULE_DAVE'), --Chiefdom
16 ('CIVILIZATION_LIME_THULE', 'GOVERNMENT_AUTOCRACY', null, 'LOC_GOVERNMENT_JFD_AUTOCRACY_LEADER_TITLE_LIME_THULE_DAVE'), --Autocracy
17 ('CIVILIZATION_LIME_THULE', 'GOVERNMENT_OLIGARCHY', null, 'LOC_GOVERNMENT_JFD_OLIGARCHY_LEADER_TITLE_LIME_THULE_DAVE'), --Oligarchy
18 ('CIVILIZATION_LIME_THULE', 'GOVERNMENT_MONARCHY', null, 'LOC_GOVERNMENT_JFD_MONARCHY_LEADER_TITLE_LIME_THULE_DAVE'), --Feudal Monarchy
19 ('CIVILIZATION_LIME_THULE', 'GOVERNMENT_CLASSICAL_REPUBLIC', null, 'LOC_GOVERNMENT_JFD_CLASSICAL_DEMOCRACY_LEADER_TITLE_LIME_THULE_DAVE'), --Classical Democracy
20 ('CIVILIZATION_LIME_THULE', 'GOVERNMENT_MERCHANT_REPUBLIC', null, 'LOC_GOVERNMENT_JFD_MERCHANT_REPUBLIC_LEADER_TITLE_LIME_THULE_DAVE'), --Merchant Republic
21 ('CIVILIZATION_LIME_THULE', 'GOVERNMENT_JFD_ABSOLUTE_MONARCHY', null, 'LOC_GOVERNMENT_JFD_MONARCHY_LEADER_TITLE_LIME_THULE_DAVE'), --Absolute Monarchy
22 ('CIVILIZATION_LIME_THULE', 'GOVERNMENT_JFD_CONSTITUTIONAL_MONARCHY', null, 'LOC_GOVERNMENT_JFD_MONARCHY_LEADER_TITLE_LIME_THULE_DAVE'), --Constitutional Monarchy
23 ('CIVILIZATION_LIME_THULE', 'GOVERNMENT_JFD_NOBLE_REPUBLIC', null, 'LOC_GOVERNMENT_JFD_NOBLE_REPUBLIC_LEADER_TITLE_LIME_THULE_DAVE'), --Noble Republic
24 ('CIVILIZATION_LIME_THULE', 'GOVERNMENT_DEMOCRACY', null, 'LOC_GOVERNMENT_JFD_LIBERAL_DEMOCRACY_LEADER_TITLE_LIME_THULE_DAVE'), --Liberal Democracy
25 ('CIVILIZATION_LIME_THULE', 'GOVERNMENT_COMMUNISM', null, 'LOC_GOVERNMENT_JFD_PEOPLES_REPUBLIC_LEADER_TITLE_LIME_THULE_DAVE'), --People's Republic
26 ('CIVILIZATION_LIME_THULE', 'GOVERNMENT_FASCISM', null, 'LOC_GOVERNMENT_JFD_MILITARY_GUARDIANSHIP_LEADER_TITLE_LIME_THULE_DAVE'), --Military Guardianship
27 ('CIVILIZATION_LIME_THULE', null, 'POLICY_JFD_EMPIRE', 'LOC_GOVERNMENT_JFD_EMPIRE_LEADER_TITLE_LIME_THULE_DAVE'), --Empire
28 ('CIVILIZATION_LIME_THULE', 'GOVERNMENT_JFD_POLIS', null, 'LOC_GOVERNMENT_JFD_POLIS_LEADER_TITLE_LIME_THULE_DAVE'), --Polis
29 ('CIVILIZATION_LIME_THULE', 'GOVERNMENT_JFD_HORDE', null, 'LOC_GOVERNMENT_JFD_HORDE_LEADER_TITLE_LIME_THULE_DAVE'); --Horde
30
31DELETE FROM CivilizationTitle WHERE CivilizationType = 'LEADER_LIME_THULE_DAVE' AND GovernmentType IS NOT null AND GovernmentType NOT IN (SELECT GovernmentType FROM Governments);
32DELETE FROM CivilizationTitle WHERE CivilizationType = 'LEADER_LIME_THULE_DAVE' AND PolicyType IS NOT null AND PolicyType NOT IN (SELECT PolicyType FROM Policies);
33--==========================================================================================================================
34--==========================================================================================================================