Code:
-- City-States: Type, StartYear, UnitType1, UnitType2, UnitType3, UnitType4, UnitType5, UnitType6
SELECT 'MINOR_CIV_BUDAPEST', 0 , 0, 'UNIT_SPEARMAN', 'UNIT_WORKER', 'UNIT_SPEARMAN', 'UNIT_SPEARMAN', NULL, NULL UNION ALL
SELECT 'MINOR_CIV_UR', -3800, 0, 'UNIT_WARRIOR', 'UNIT_WARRIOR', NULL, NULL, NULL, NULL UNION ALL
SELECT 'MINOR_CIV_BELGRADE', -279, 0, 'UNIT_SPEARMAN', 'UNIT_WORKER', 'UNIT_SPEARMAN', 'UNIT_SPEARMAN', NULL, NULL UNION ALL
SELECT 'MINOR_CIV_KATHMANDU', -167, 0, 'UNIT_SPEARMAN', 'UNIT_WORKER', 'UNIT_SPEARMAN', 'UNIT_SPEARMAN', NULL, NULL UNION ALL
SELECT 'MINOR_CIV_ALMATY', -900, 0, 'UNIT_SPEARMAN', 'UNIT_WORKER', 'UNIT_SPEARMAN', 'UNIT_SPEARMAN', NULL, NULL UNION ALL
SELECT 'MINOR_CIV_KUALA_LUMPUR', 1857, 0, 'UNIT_MUSKETMAN', 'UNIT_WORKER', 'UNIT_PIKEMAN', 'UNIT_PIKEMAN', 'UNIT_MUSKETMAN', NULL UNION ALL
SELECT 'MINOR_CIV_SINGAPORE', 200 , 0, 'UNIT_SPEARMAN', 'UNIT_WORKER', 'UNIT_SPEARMAN', 'UNIT_SPEARMAN', 'UNIT_COMPOSITE_BOWMAN',NULL UNION ALL
SELECT 'MINOR_SIDON', -4000, 0, 'UNIT_WARRIOR', 'UNIT_WARRIOR', NULL, NULL, NULL, NULL UNION ALL
SELECT 'MINOR_CIV_JERUSALEM', -4000, 0, 'UNIT_WARRIOR', 'UNIT_WARRIOR', NULL, NULL, NULL, NULL UNION ALL
SELECT 'MINOR_CIV_MANILA', 900 , 0, 'UNIT_SPEARMAN', 'UNIT_WORKER', 'UNIT_SPEARMAN', 'UNIT_SPEARMAN', 'UNIT_COMPOSITE_BOWMAN',NULL UNION ALL
SELECT 'MINOR_CIV_MOMBASA', 900 , 0, 'UNIT_SPEARMAN', 'UNIT_WORKER', 'UNIT_SPEARMAN', 'UNIT_SPEARMAN', 'UNIT_COMPOSITE_BOWMAN',NULL UNION ALL
SELECT 'MINOR_CIV_PRAGUE', 860 , 0, 'UNIT_SPEARMAN', 'UNIT_WORKER', 'UNIT_SPEARMAN', 'UNIT_SPEARMAN', 'UNIT_COMPOSITE_BOWMAN',NULL UNION ALL
SELECT 'MINOR_CIV_YEREVAN', -4000, 0, 'UNIT_WARRIOR', 'UNIT_WARRIOR', NULL, NULL, NULL, NULL UNION ALL
SELECT 'MINOR_CIV_MBANZA_KONGO', 1400, 0, 'UNIT_PIKEMAN', 'UNIT_WORKER', 'UNIT_PIKEMAN', 'UNIT_PIKEMAN', 'UNIT_CROSSBOWMAN', NULL UNION ALL
SELECT 'MINOR_CIV_IFE', -400, 0, 'UNIT_SPEARMAN', 'UNIT_WORKER', 'UNIT_SPEARMAN', 'UNIT_SPEARMAN', NULL, NULL UNION ALL
SELECT 'MINOR_CIV_KIEV', 500 , 0, 'UNIT_SPEARMAN', 'UNIT_WORKER', 'UNIT_SPEARMAN', 'UNIT_SPEARMAN', 'UNIT_COMPOSITE_BOWMAN',NULL UNION ALL
SELECT 'MINOR_CIV_KABUL', -600, 0, 'UNIT_SPEARMAN', 'UNIT_WORKER', 'UNIT_SPEARMAN', 'UNIT_SPEARMAN', NULL, NULL UNION ALL
SELECT 'MINOR_CIV_BUENOS_AIRES', 1536, 0, 'UNIT_PIKEMAN', 'UNIT_WORKER', 'UNIT_PIKEMAN', 'UNIT_MUSKETMAN', 'UNIT_CROSSBOWMAN', NULL UNION ALL
SELECT 'MINOR_CIV_ANTANANARIVO', 1625, 0, 'UNIT_PIKEMAN', 'UNIT_WORKER', 'UNIT_PIKEMAN', 'UNIT_PIKEMAN', 'UNIT_CROSSBOWMAN', NULL UNION ALL
SELECT 'MINOR_CIV_SAMARKAND', -700, 0, 'UNIT_SPEARMAN', 'UNIT_WORKER', 'UNIT_SPEARMAN', 'UNIT_SPEARMAN', NULL, NULL UNION ALL