$oid = addChild($rootId, "religion", "Religion", "en", 1);
$oid = addChild($rootId, "Social sciences", "Social sciences", "en", 1);
$oid = addChild($rootId, "Language", "Language", "en", 1);
$oid = addChild($rootId, "Natural sciences and mathematics", "Natural sciences and mathematics", "en", 1);
$oid = addChild($rootId, "Technology", "Technology", "en", 1);
$oid = addChild($rootId, "Arts", "Arts", "en", 1);
$oid = addChild($rootId, "Literature and rhetoric", "Literature and rhetoric", "en", 1);
$oid = addChild($rootId, "Geography and history", "Geography and history", "en", 1);
$o1 =& new sotf_NodeObject("sotf_topic_trees");
$o1->set('tree_id', 2);
$o1->set('name', 'SOMA Metadata version 1');
$o1->set('url', 'http://soma-dev.sourceforge.net/');
$o1->set('languages', 'en');
$o1->create();
$oid = $o1->getID();
$rootId = addParent("SOMA", "SOMA topics", 'en', 2, "StreamOnTheFly project worked with SOMA in the preparation of their metadata set, but this topic tree is too specific for our use, and will be offered as an alternative for a more general one.");
$oid = addChild($rootId, "development", "Development");
addChild($oid, "agriculture", "Agriculture");
addChild($oid, "aid", "Aid");
addChild($oid, "capacity building", "Capacity Building");
addChild($oid, "children", "Children");
addChild($oid, "cities", "Cities");
addChild($oid, "education", "Education");
addChild($oid, "emergency relief", "Emergency Relief");
addChild($oid, "energy", "Energy");
addChild($oid, "fisheries", "Fisheries");
addChild($oid, "food", "Food");
addChild($oid, "gender", "Gender");
addChild($oid, "intermediate technology", "Intermediate Technology");
addChild($oid, "international cooperation", "International Cooperation");
addChild($oid, "labour/work", "Labour/Work");
addChild($id, "sport", "Sport");
$id = addParent("politics", "Politics");
addChild($id, "activism", "Activism");
addChild($id, "civil society", "Civil Society");
addChild($id, "codes of conduct", "Codes Of Conduct");
addChild($id, "democracy", "Democracy");
addChild($id, "ethics/value systems", "Ethics/Value Systems");
addChild($id, "geopolitics", "Geopolitics");
addChild($id, "globalisation", "Globalisation");
addChild($id, "governance", "Governance");
addChild($id, "justice/crime", "Justice/Crime");
addChild($id, "law", "Law");
addChild($id, "transparency/corruption", "Transparency/Corruption");
addChild($id, "United Nations", "United Nations");
addChild($id, "class issues", "Class Issues");
$id = addParent("war & peace", "War & Peace");
addChild($id, "arms/military", "Arms/Military");
addChild($id, "conflict", "Conflict");
addChild($id, "conflict resolution", "Conflict Resolution");
addChild($id, "landmines", "Landmines");
addChild($id, "nuclear issues", "Nuclear Issues");
addChild($id, "peace", "Peace");
addChild($id, "security", "Security");
addChild($id, "terrorism", "Terrorism");
}
if (isset($install_delete_topic)) {
$conn = @pg_connect("host={$install_node_host} port={$install_node_port} dbname={$install_node_db_name} user={$install_node_user} password={$install_node_pass}");
$sql = "DELETE FROM sotf_topic_tree_defs";
$result = @pg_query($conn, $sql);
$sql = "DELETE FROM sotf_topic_trees";
$result = @pg_query($conn, $sql);