Location: PHPKode > projects > Volunteer Management OpenSource Software > vmoss_alpha02/inst/cs_setup.inc
<?php
/**Setup - Create Default data
*
* PHP version 4 and 5
*
* LICENSE: This source file is subject to LGPL license
* that is available through the world-wide-web at the following URI:
* http://www.gnu.org/copyleft/lesser.html
*
* @author     Sanjeewa Jayasinghe <hide@address.com>
* @copyright  Lanka Software Foundation - http://www.opensource.lk
* @package    sahana
* @subpackage cs
*/

function shn_cs_datacreate()
{
	global $global;
	include_once $global['approot'].'inst/cs_lib.inc';

	$db=$global["db"];

	// INSERT UNIT TYPES AND UNITS UNDER THEM
	//unit type - mass
	$mass = shn_create_uuid("unit_type");
	$q="insert into ct_unit_type (unit_type_uuid,name,description) values('$mass','Mass','Mass')";
	$res=$db->Execute($q);

		$kg=shn_create_uuid("unit");
		$query="insert into ct_unit(unit_type_uuid,unit_uuid,name,base_flag,multiplier) values('$mass','$kg','Kg','1',0)";
		$res=$db->Execute($query);

		$g=shn_create_uuid("unit");
		$query="insert into ct_unit(unit_type_uuid,unit_uuid,name,base_flag,multiplier) values('$mass','$g','g','0',0.001)";
		$res=$db->Execute($query);

		$mg=shn_create_uuid("unit");
		$query="insert into ct_unit(unit_type_uuid,unit_uuid,name,base_flag,multiplier) values('$mass','$mg','mg','0',0.000001)";
		$res=$db->Execute($query);

		$microgram=shn_create_uuid("unit");
		$query="insert into ct_unit(unit_type_uuid,unit_uuid,name,base_flag,multiplier) values('$mass','$microgram','microgram','0',0.00000001)";
		$res=$db->Execute($query);

	//unit type - length
	$length = shn_create_uuid("unit_type");
	$q="insert into ct_unit_type (unit_type_uuid,name,description) values('$length','Length','Length')";
	$res=$db->Execute($q);

		$m=shn_create_uuid("unit");
		$query="insert into ct_unit(unit_type_uuid,unit_uuid,name,base_flag,multiplier) values('$length','$m','m','1',0)";
		$res=$db->Execute($query);

		$km=shn_create_uuid("unit");
		$query="insert into ct_unit(unit_type_uuid,unit_uuid,name,base_flag,multiplier) values('$length','$km','km','0',1000)";
		$res=$db->Execute($query);

		$cm=shn_create_uuid("unit");
		$query="insert into ct_unit(unit_type_uuid,unit_uuid,name,base_flag,multiplier) values('$length','$cm','cm','0',0.001)";
		$res=$db->Execute($query);


	//unit type - volume
	$volume = shn_create_uuid("unit_type");
	$q="insert into ct_unit_type (unit_type_uuid,name,description) values('$volume','Volume','Volume')";
	$res=$db->Execute($q);

		$l=shn_create_uuid("unit");
		$query="insert into ct_unit(unit_type_uuid,unit_uuid,name,base_flag,multiplier) values('$volume','$l','l','1',0)";
		$res=$db->Execute($query);

		$ml=shn_create_uuid("unit");
		$query="insert into ct_unit(unit_type_uuid,unit_uuid,name,base_flag,multiplier) values('$volume','$ml','ml','0',0.001)";
		$res=$db->Execute($query);

		$kl=shn_create_uuid("unit");
		$query="insert into ct_unit(unit_type_uuid,unit_uuid,name,base_flag,multiplier) values('$volume','$kl','kl','0',1000)";
		$res=$db->Execute($query);

		$microl=shn_create_uuid("unit");
		$query="insert into ct_unit(unit_type_uuid,unit_uuid,name,base_flag,multiplier) values('$volume','$microl','microlitre','0',0.000001)";
		$res=$db->Execute($query);

		$gal=shn_create_uuid("unit");
		$query="insert into ct_unit(unit_type_uuid,unit_uuid,name,base_flag,multiplier) values('$volume','$gal','gal','0',1)";
		$res=$db->Execute($query);

	//unit type - miscellaneous
	$miscellaneous = shn_create_uuid("unit_type");
	$q="insert into ct_unit_type (unit_type_uuid,name,description) values('$miscellaneous','Miscellaneous','Miscellaneous')";
	$res=$db->Execute($q);

		$truck=shn_create_uuid("unit");
		$query="insert into ct_unit(unit_type_uuid,unit_uuid,name,base_flag,multiplier) values('$miscellaneous','$truck','Truck','0',1)";
		$res=$db->Execute($query);

		$box=shn_create_uuid("unit");
		$query="insert into ct_unit(unit_type_uuid,unit_uuid,name,base_flag,multiplier) values('$miscellaneous','$box','Box','0',1)";
		$res=$db->Execute($query);

		$bottle=shn_create_uuid("unit");
		$query="insert into ct_unit(unit_type_uuid,unit_uuid,name,base_flag,multiplier) values('$miscellaneous','$bottle','Bottle','0',1)";
		$res=$db->Execute($query);

		$bag=shn_create_uuid("unit");
		$query="insert into ct_unit(unit_type_uuid,unit_uuid,name,base_flag,multiplier) values('$miscellaneous','$bag','Bag','0',1)";
		$res=$db->Execute($query);

		$piece=shn_create_uuid("unit");
		$query="insert into ct_unit(unit_type_uuid,unit_uuid,name,base_flag,multiplier) values('$miscellaneous','$piece','Piece','0',1)";
		$res=$db->Execute($query);

		$kit=shn_create_uuid("unit");
		$query="insert into ct_unit(unit_type_uuid,unit_uuid,name,base_flag,multiplier) values('$miscellaneous','$kit','Kit','0',1)";
		$res=$db->Execute($query);

		$ration=shn_create_uuid("unit");
		$query="insert into ct_unit(unit_type_uuid,unit_uuid,name,base_flag,multiplier) values('$miscellaneous','$ration','Ration','0',1)";
		$res=$db->Execute($query);

		$packet=shn_create_uuid("unit");
		$query="insert into ct_unit(unit_type_uuid,unit_uuid,name,base_flag,multiplier) values('$miscellaneous','$packet','Packet','0',1)";
		$res=$db->Execute($query);

		$units=shn_create_uuid("unit");
		$query="insert into ct_unit(unit_type_uuid,unit_uuid,name,base_flag,multiplier) values('$miscellaneous','$units','Units','0',1)";
		$res=$db->Execute($query);

	//unit type - medical
	$medical = shn_create_uuid("unit_type");
	$q="insert into ct_unit_type (unit_type_uuid,name,description) values('$medical','Medical','Medical')";
	$res=$db->Execute($q);

		$tab=shn_create_uuid("unit");
		$query="insert into ct_unit(unit_type_uuid,unit_uuid,name,base_flag,multiplier) values('$medical','$tab','Tablet','0',1)";
		$res=$db->Execute($query);

		$cap=shn_create_uuid("unit");
		$query="insert into ct_unit(unit_type_uuid,unit_uuid,name,base_flag,multiplier) values('$medical','$cap','Capsule','0',1)";
		$res=$db->Execute($query);

		$vial=shn_create_uuid("unit");
		$query="insert into ct_unit(unit_type_uuid,unit_uuid,name,base_flag,multiplier) values('$medical','$vial','Vial','0',1)";
		$res=$db->Execute($query);

		$ampoule=shn_create_uuid("unit");
		$query="insert into ct_unit(unit_type_uuid,unit_uuid,name,base_flag,multiplier) values('$medical','$ampoule','Ampoule','0',1)";
		$res=$db->Execute($query);

		$suspension=shn_create_uuid("unit");
		$query="insert into ct_unit(unit_type_uuid,unit_uuid,name,base_flag,multiplier) values('$medical','$suspension','Suspension','0',1)";
		$res=$db->Execute($query);

	// INSERT MAIN CATALOGUES & SUB CATALOGUE TO THE DATABASE
	//data 1
		// -food - main catalogue-1
	$food = "ct_default-1";
	$food_serial = shn_cs_generate_maincat_serial();
	$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('0','$food','Food and Nutrition','Food','food','$food_serial')";
	$res=$db->Execute($q);
			// -sub catalogue-1.1

		$dryfood = "ct_default-2";
		$dryfood_serial = shn_cs_generate_subcat_item_serial($food);
		$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$food','$dryfood','Dry Food','Dry Food','food','$dryfood_serial')";
		$res=$db->Execute($q);

			// -item1.1.1
			$rice = "ct_default-3";
			$rice_serial = shn_cs_generate_subcat_item_serial($dryfood);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,final_flag,keyword,serial) values('$dryfood','$rice','Rice','Rice','1','food','$rice_serial')";
			$res=$db->Execute($q);
						// -unit/units that item use -(kg)
					$q="insert into ct_cat_unit (ct_uuid,unit_uuid) values('$rice','$kg')";
					$res=$db->Execute($q);

			// -item1.1.2
			$sugar = "ct_default-4";
			$sugar_serial = shn_cs_generate_subcat_item_serial($dryfood);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,final_flag,keyword,serial) values('$dryfood','$sugar','Sugar','Sugar','1','food','$sugar_serial')";
			$res=$db->Execute($q);
						// -unit/units that item use -(kg)
					$q="insert into ct_cat_unit (ct_uuid,unit_uuid) values('$sugar','$kg')";
					$res=$db->Execute($q);

			// -item1.1.3
			$milk_powder = "ct_default-5";
			$milk_powder_serial = shn_cs_generate_subcat_item_serial($dryfood);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,final_flag,keyword,serial) values('$dryfood','$milk_powder','Milk Powder','Milk Powder','1','food','$milk_powder_serial')";
			$res=$db->Execute($q);
						// -unit/units that item use -(packet)
					$q="insert into ct_cat_unit (ct_uuid,unit_uuid) values('$milk_powder','$packet')";
					$res=$db->Execute($q);

        // -Item Under Food (main category)-1.2
		$pre_cooked_food = "ct_default-6";
		$pre_cooked_food_serial = shn_cs_generate_subcat_item_serial($food);
		$q="insert into ct_catalogue (parentid,ct_uuid,name,description,final_flag,keyword,serial) values('$food','$pre_cooked_food','Pre-cooked Food','Pre-cooked Food',1,'food','$pre_cooked_food_serial')";
		$res=$db->Execute($q);
		    // -unit/units that item use -(ration)
					$q="insert into ct_cat_unit (ct_uuid,unit_uuid) values('$pre_cooked_food','$ration')";
					$res=$db->Execute($q);

	//data
	// -non food items - main catalogue-2
	$nonfood = "ct_default-7";
	$nonfood_serial = shn_cs_generate_maincat_serial();
	$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('0','$nonfood','Non Food Items','Non Food Items','non food','$nonfood_serial')";
	$res=$db->Execute($q);

		// - clothing - item-2.1
		$clothing = "ct_default-8";
		$clothing_serial = shn_cs_generate_subcat_item_serial($nonfood);
		$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$nonfood','$clothing','Clothing','Clothing','clothing','$clothing_serial')";
		$res=$db->Execute($q);

		    /// -blanket - item-2.1.1
			$blanket = "ct_default-9";
			$blanket_serial = shn_cs_generate_subcat_item_serial($clothing);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,final_flag,keyword,serial) values('$clothing','$blanket','Blankets','Blankets','1','blankets','$blanket_serial')";
			$res=$db->Execute($q);
					// -unit/units that blanket uses -(piece)
				$q="insert into ct_cat_unit (ct_uuid,unit_uuid) values('$blanket','$piece')";
				$res=$db->Execute($q);

		// - Cooking Supplies - sub catalogue-2.2
		$cooking_equipments = "ct_default-10";
		$cooking_equipments_serial = shn_cs_generate_subcat_item_serial($nonfood);
		$q="insert into ct_catalogue (parentid,ct_uuid,name,description,final_flag,keyword,serial) values('$nonfood','$cooking_equipments','Cooking Equipments','Cooking Equipments',1,'Cooking','$cooking_equipments_serial')";
		$res=$db->Execute($q);
            // -unit/units for cooking Equipments -(piece)
				$q="insert into ct_cat_unit (ct_uuid,unit_uuid) values('$cooking_equipments','$piece')";
				$res=$db->Execute($q);



    //------Shelter & Housing -main category-3------------------------------------------------------------
    $shelter_housing = "ct_default-11";
	$shelter_housing_serial = shn_cs_generate_maincat_serial();
	$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('0','$shelter_housing','Shelter & Housing','Shelter & Housing','Shelter & Housing','$shelter_housing_serial')";
	$res=$db->Execute($q);

        // - Housing equipments - sub catalogue-3.1
        $housing_equipments = "ct_default-12";
		$housing_equipments_serial = shn_cs_generate_subcat_item_serial($shelter_housing);
		$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$shelter_housing','$housing_equipments','Housing Equipments','Housing Equipments','Housing','$housing_equipments_serial')";
		$res=$db->Execute($q);

		    /// -Tents - item-3.1.1
			$tent = "ct_default-13";
			$tent_serial = shn_cs_generate_subcat_item_serial($housing_equipments);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,final_flag,keyword,serial) values('$housing_equipments','$tent','Tents','Tents','1','tents','$tent_serial')";
			$res=$db->Execute($q);
					// -unit/units for tents -(units)
				$q="insert into ct_cat_unit (ct_uuid,unit_uuid) values('$tent','$units')";
				$res=$db->Execute($q);

		    /// -Shelter sheets - item-3.1.2
			$shelter_sheet = "ct_default-14";
			$shelter_sheet_serial = shn_cs_generate_subcat_item_serial($housing_equipments);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,final_flag,keyword,serial) values('$housing_equipments','$shelter_sheet','Shelter sheets','Shelter sheets','1','Shelter','$shelter_sheet_serial')";
			$res=$db->Execute($q);
					// -unit/units for shelter sheets -(piece)
				$q="insert into ct_cat_unit (ct_uuid,unit_uuid) values('$shelter_sheet','$piecce')";
				$res=$db->Execute($q);

			/// -Cement - item-3.1.3
			$cement = "ct_default-15";
			$cement_serial = shn_cs_generate_subcat_item_serial($housing_equipments);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,final_flag,keyword,serial) values('$housing_equipments','$cement','Cement','Cement','1','cement','$cement_serial')";
			$res=$db->Execute($q);
					// -unit/units for cement -(bags)
				$q="insert into ct_cat_unit (ct_uuid,unit_uuid) values('$cement','$bag')";
				$res=$db->Execute($q);


		// - Sanitary equipments - sub catalogue-3.2
        $sanitary_equipments = "ct_default-16";
		$sanitary_equipments_serial = shn_cs_generate_subcat_item_serial($shelter_housing);
		$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$shelter_housing','$sanitary_equipments','Sanitary Equipments','Sanitary Equipments','Sanitary','$sanitary_equipments_serial')";
		$res=$db->Execute($q);

		    //-temporary lavatory
		    $temporary_lavatory = "ct_default-17";
			$temporary_lavatory_serial = shn_cs_generate_subcat_item_serial($sanitary_equipments);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,final_flag,keyword,serial) values('$sanitary_equipments','$temporary_lavatory','Temporary Lavatory','Temporary Lavatory','1','Lavatory','$temporary_lavatory_serial')";
			$res=$db->Execute($q);
					// -unit/units for temporary_lavatory -(units)
				$q="insert into ct_cat_unit (ct_uuid,unit_uuid) values('$temporary_lavatory','$units')";
				$res=$db->Execute($q);

    //--Water--main catalog-4---------------
    $water = "ct_default-18";
	$water_serial = shn_cs_generate_maincat_serial();
	$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('0','$water','Water','Water','water','$water_serial')";
	$res=$db->Execute($q);

	    //---cooking & Drinking -item-4.1-----
	    $water_cook_drink = "ct_default-19";
		$water_cook_drink_serial = shn_cs_generate_subcat_item_serial($water);
		$q="insert into ct_catalogue (parentid,ct_uuid,name,description,final_flag,keyword,serial) values('$water','$water_cook_drink','Water for Drinking & Cooking','Water for Drinking & Cooking','1','water','$water_cook_drink_serial')";
		$res=$db->Execute($q);
			// -unit/units for temporary_lavatory -(units)
			$q="insert into ct_cat_unit (ct_uuid,unit_uuid) values('$water_cook_drink','$l')";
			$res=$db->Execute($q);
			// -unit/units for temporary_lavatory -(units)
			$q="insert into ct_cat_unit (ct_uuid,unit_uuid) values('$water_cook_drink','$gal')";
			$res=$db->Execute($q);

		//---other-item-4.2-----
	    $water_other = "ct_default-20";
		$water_other_serial = shn_cs_generate_subcat_item_serial($water);
		$q="insert into ct_catalogue (parentid,ct_uuid,name,description,final_flag,keyword,serial) values('$water','$water_other','Water for other purposes','Water for other purposes','1','water','$water_other_serial')";
		$res=$db->Execute($q);
			// -unit/units for temporary_lavatory -(units)
			$q="insert into ct_cat_unit (ct_uuid,unit_uuid) values('$water_other','$l')";
			$res=$db->Execute($q);
			// -unit/units for temporary_lavatory -(units)
			$q="insert into ct_cat_unit (ct_uuid,unit_uuid) values('$water_other','$gal')";
			$res=$db->Execute($q);

	//--fuel-main catalog-5
	$fuel = "ct_default-21";
	$fuel_serial = shn_cs_generate_maincat_serial();
	$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('0','$fuel','Fuel','Fuel','fuel','$fuel_serial')";
	$res=$db->Execute($q);

		// - fuel for cooking - sub catalogue-5.1
        $fuel_cook = "ct_default-22";
		$fuel_cook_serial = shn_cs_generate_subcat_item_serial($fuel);
		$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$fuel','$fuel_cook','Fuel for cooking','Fuel for cooking','fuel','$fuel_cook_serial')";
		$res=$db->Execute($q);

		    //---kerosine-item-5.1.1-----
	        $kerosine = "ct_default-23";
		    $kerosine_serial = shn_cs_generate_subcat_item_serial($fuel);
		    $q="insert into ct_catalogue (parentid,ct_uuid,name,description,final_flag,keyword,serial) values('$fuel','$kerosine','Kerosine','Kerosine','1','kerosine','$kerosine_serial')";
		    $res=$db->Execute($q);
			    // -unit/units for fuel -(units)
			    $q="insert into ct_cat_unit (ct_uuid,unit_uuid) values('$kerosine','$l')";
			    $res=$db->Execute($q);

		// - fuel for transport - sub catalogue-5.2
        $fuel_transport = "ct_default-24";
		$fuel_transport_serial = shn_cs_generate_subcat_item_serial($fuel);
		$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$fuel','$fuel_transport','Fuel for transporting','Fuel for transporting','fuel','$fuel_transport_serial')";
		$res=$db->Execute($q);

		    //---petrol-item-5.2.1-----
	        $petrol = "ct_default-25";
		    $petrol_serial = shn_cs_generate_subcat_item_serial($fuel);
		    $q="insert into ct_catalogue (parentid,ct_uuid,name,description,final_flag,keyword,serial) values('$fuel','$petrol','Petrol','Petrol','1','petrol','$petrol_serial')";
		    $res=$db->Execute($q);
			    // -unit/units for fuel -(units)
			    $q="insert into ct_cat_unit (ct_uuid,unit_uuid) values('$petrol','$l')";
			    $res=$db->Execute($q);

			//---diesel-item-5.2.2-----
	        $diesel = "ct_default-26";
		    $diesel_serial = shn_cs_generate_subcat_item_serial($fuel);
		    $q="insert into ct_catalogue (parentid,ct_uuid,name,description,final_flag,keyword,serial) values('$fuel','$diesel','diesel','diesel','1','diesel','$diesel_serial')";
		    $res=$db->Execute($q);
			    // -unit/units for fuel -(units)
			    $q="insert into ct_cat_unit (ct_uuid,unit_uuid) values('$diesel','$l')";
			    $res=$db->Execute($q);

	// - helth kit - main catalogue-6 ----------------------------------------------------------------------------------------------------------------------------------------
	$HealthKits = "ct_default-27";
	$HealthKits_serial = shn_cs_generate_maincat_serial();
	$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('0','$HealthKits','Health Kits','Health Kits','health kits','$HealthKits_serial')";
	$res=$db->Execute($q);

		// - Burn Dressing Kits - sub catalogue-6.1
		$BurnDressingKits = "ct_default-28";
		$BurnDressingKits_serial = shn_cs_generate_subcat_item_serial($HealthKits);
		$q="insert into ct_catalogue (parentid,ct_uuid,name,description,final_flag,keyword,serial) values('$HealthKits','$BurnDressingKits','Burn Dressing Kits','Burn Dressing Kits','1','kits','$BurnDressingKits_serial')";
		$res=$db->Execute($q);

			$q="insert into ct_cat_unit (ct_uuid,unit_uuid) values('$BurnDressingKits','$kit')";
			$res=$db->Execute($q);

		// - Clean Delivery Kits - sub catalogue-6.2
		$CleanDeliveryKits = "ct_default-29";
		$CleanDeliveryKits_serial = shn_cs_generate_subcat_item_serial($HealthKits);
		$q="insert into ct_catalogue (parentid,ct_uuid,name,description,final_flag,keyword,serial) values('$HealthKits','$CleanDeliveryKits','Clean Delivery Kits','Clean Delivery Kits','1','kits','$CleanDeliveryKits_serial')";
		$res=$db->Execute($q);

			$q="insert into ct_cat_unit (ct_uuid,unit_uuid) values('$CleanDeliveryKits','$kit')";
			$res=$db->Execute($q);

		// - Diarrhoea Kits - sub catalogue-6.3
		$DiarrhoeaKits = "ct_default-30";
		$DiarrhoeaKits_serial = shn_cs_generate_subcat_item_serial($HealthKits);
		$q="insert into ct_catalogue (parentid,ct_uuid,name,description,final_flag,keyword,serial) values('$HealthKits','$DiarrhoeaKits','Diarrhoea Kits','Diarrhoea Kits','1','kits','$DiarrhoeaKits_serial')";
		$res=$db->Execute($q);

			$q="insert into ct_cat_unit (ct_uuid,unit_uuid) values('$DiarrhoeaKits','$kit')";
			$res=$db->Execute($q);

		// - Emergency Health Kits - sub catalogue-6.4
		$EmergencyHealthKits = "ct_default-31";
		$EmergencyHealthKits_serial = shn_cs_generate_subcat_item_serial($HealthKits);
		$q="insert into ct_catalogue (parentid,ct_uuid,name,description,final_flag,keyword,serial) values('$HealthKits','$EmergencyHealthKits','Emergency Health Kits','Emergency Health Kits','1','kits','$EmergencyHealthKits_serial')";
		$res=$db->Execute($q);

			$q="insert into ct_cat_unit (ct_uuid,unit_uuid) values('$EmergencyHealthKits','$kit')";
			$res=$db->Execute($q);

		// - EMOC Kits - sub catalogue-6.5
		$EmOCKits = "ct_default-32";
		$EmOCKits_serial = shn_cs_generate_subcat_item_serial($HealthKits);
		$q="insert into ct_catalogue (parentid,ct_uuid,name,description,final_flag,keyword,serial) values('$HealthKits','$EmOCKits','EmOC Kits','EmOC Kits','1','kits','$EmOCKits_serial')";
		$res=$db->Execute($q);
		    //units
			$q="insert into ct_cat_unit (ct_uuid,unit_uuid) values('$EmOCKits','$kit')";
			$res=$db->Execute($q);

		// -Vaccines - sub catalogue-6.6
		$Vaccines = "ct_default-33";
		$Vaccines_serial = shn_cs_generate_subcat_item_serial($HealthKits);
		$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$HealthKits','$Vaccines','Vaccines','Vaccines','kits','$Vaccines_serial')";
		$res=$db->Execute($q);
		    //items-measles vaccines-6.6.1
		    $measles_vaccines = "ct_default-34";
		    $measles_vaccines_serial = shn_cs_generate_subcat_item_serial($HealthKits);
		    $q="insert into ct_catalogue (parentid,ct_uuid,name,description,final_flag,keyword,serial) values('$HealthKits','$measles_vaccines','Measles Vaccines','Measles Vaccines','1','kits','$measles_vaccines_serial')";
		    $res=$db->Execute($q);


			//polio vaccine items-6.6.2
			$polio_vaccines = "ct_default-35";
		    $polio_vaccines_serial = shn_cs_generate_subcat_item_serial($HealthKits);
		    $q="insert into ct_catalogue (parentid,ct_uuid,name,description,final_flag,keyword,serial) values('$HealthKits','$polio_vaccines','Polio Vaccines','Polio Vaccines','1','kits','$polio_vaccines_serial')";
		    $res=$db->Execute($q);


		// - Trauma Kits - sub catalogue-6.7
		$TraumaKits = "ct_default-36";
		$TraumaKits_serial = shn_cs_generate_subcat_item_serial($HealthKits);
		$q="insert into ct_catalogue (parentid,ct_uuid,name,description,final_flag,keyword,serial) values('$HealthKits','$TraumaKits','Trauma Kits','Trauma Kits','1','kits','$TraumaKits_serial')";
		$res=$db->Execute($q);

			$q="insert into ct_cat_unit (ct_uuid,unit_uuid) values('$TraumaKits','$kit')";
			$res=$db->Execute($q);
         //-------------------------------------------------------------------------------------------------------------------------------------------------------------------------

	// - Medical Equipment - main catalogue-7 --------------------------------------------------------------------------------------------------------------------
	$MedicalEquipment = "ct_default-37";
	$MedicalEquipment_serial = shn_cs_generate_maincat_serial();
	$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('0','$MedicalEquipment','Medical Equipment','Medical Equipment','medical equipment','$MedicalEquipment_serial')";
	$res=$db->Execute($q);

		// - Anaesthesia Equipment - sub catalogue-7.1
		$AnaesthesiaEquipment = "ct_default-38";
		$AnaesthesiaEquipment_serial = shn_cs_generate_subcat_item_serial($MedicalEquipment);
		$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$MedicalEquipment','$AnaesthesiaEquipment','Anaesthesia Equipment','Anaesthesia Equipment','medical equipment','$AnaesthesiaEquipment_serial')";
		$res=$db->Execute($q);

		// - Cold Chain Equipment - sub catalogue-7.2
		$ColdChainEquipment = "ct_default-39";
		$ColdChainEquipment_serial = shn_cs_generate_subcat_item_serial($MedicalEquipment);
		$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$MedicalEquipment','$ColdChainEquipment','Cold Chain Equipment','Cold Chain Equipment','medical equipment','$ColdChainEquipment_serial')";
		$res=$db->Execute($q);

		// - Diagnostic Equipment - sub catalogue-7.3
		$DiagnosticEquipment = "ct_default-40";
		$DiagnosticEquipment_serial = shn_cs_generate_subcat_item_serial($MedicalEquipment);
		$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$MedicalEquipment','$DiagnosticEquipment','Diagnostic Equipment','Diagnostic Equipment','medical equipment','$DiagnosticEquipment_serial')";
		$res=$db->Execute($q);

		// - Exercise Equipment - sub catalogue-7.4
		$ExerciseEquipment = "ct_default-41";
		$ExerciseEquipment_serial = shn_cs_generate_subcat_item_serial($MedicalEquipment);
		$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$MedicalEquipment','$ExerciseEquipment','Exercise Equipment ','Exercise Equipment','medical equipment','$ExerciseEquipment_serial')";
		$res=$db->Execute($q);

		// - Hospital Equipment - sub catalogue-7.5
		$HospitalEquipment = "ct_default-42";
		$HospitalEquipment_serial = shn_cs_generate_subcat_item_serial($MedicalEquipment);
		$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$MedicalEquipment','$HospitalEquipment','Hospital Equipment','Hospital Equipment','medical equipment','$HospitalEquipment_serial')";
		$res=$db->Execute($q);

		// - Medical Utensils - sub catalogue-7.6
		$MedicalUtensils = "ct_default-43";
		$MedicalUtensils_serial = shn_cs_generate_subcat_item_serial($MedicalEquipment);
		$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$MedicalEquipment','$MedicalUtensils','Medical Utensils','Medical Utensils','medical equipment','$MedicalUtensils_serial')";
		$res=$db->Execute($q);

		// - Resuscitation Equipment - sub catalogue-7.7
		$ResuscitationEquipment = "ct_default-44";
		$ResuscitationEquipment_serial = shn_cs_generate_subcat_item_serial($MedicalEquipment);
		$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$MedicalEquipment','$ResuscitationEquipment','Resuscitation Equipment','Resuscitation Equipment','medical equipment','$ResuscitationEquipment_serial')";
		$res=$db->Execute($q);

		// - Sterilization Equipment - sub catalogue-7.8
		$SterilizationEquipment = "ct_default-45";
		$SterilizationEquipment_serial = shn_cs_generate_subcat_item_serial($MedicalEquipment);
		$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$MedicalEquipment','$SterilizationEquipment','Sterilization Equipment','Sterilization Equipment','medical equipment','$SterilizationEquipment_serial')";
		$res=$db->Execute($q);

		// - Surgical Equipment - sub catalogue-7.9
		$SurgicalEquipment = "ct_default-46";
		$SurgicalEquipment_serial = shn_cs_generate_subcat_item_serial($MedicalEquipment);
		$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$MedicalEquipment','$SurgicalEquipment','Surgical Equipment','Surgical Equipment','medical equipment','$SurgicalEquipment_serial')";
		$res=$db->Execute($q);

	//------------------------------------------------------------------------------------------------------------------------------------------------------------------------

	// Medical drugs - main catalogue-8 ------------------------------------------------------------------------------------------------------------------------------
	$medicaldrug = "ct_default-47";
	$medicaldrug_serial = shn_cs_generate_maincat_serial();
	$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('0','$medicaldrug','Medical Drugs','Medical Drugs','medical drugs','$medicaldrug_serial')";
	$res=$db->Execute($q);
		// ANAESTHETICS- sub catalogue - level 1
		$ANAESTHETICS = "ct_default-48";
		$ANAESTHETICS_serial = shn_cs_generate_subcat_item_serial($medicaldrug);
		$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$medicaldrug','$ANAESTHETICS','ANAESTHETICS','ANAESTHETICS','medical drugs','$ANAESTHETICS_serial')";
		$res=$db->Execute($q);
			// General Anaesthetics & Oxygen- sub catalogue - level 2
			$GeneralAnaestheticsOxygen = "ct_default-49";
			$GeneralAnaestheticsOxygen_serial = shn_cs_generate_subcat_item_serial($ANAESTHETICS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$ANAESTHETICS','$GeneralAnaestheticsOxygen','General Anaesthetics & Oxygen','General Anaesthetics & Oxygen','medical drugs','$GeneralAnaestheticsOxygen_serial')";
			$res=$db->Execute($q);
			// Local Anaesthetics- sub catalogue - level 2
			$LocalAnaesthetics = "ct_default-50";
			$LocalAnaesthetics_serial = shn_cs_generate_subcat_item_serial($ANAESTHETICS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$ANAESTHETICS','$LocalAnaesthetics','Local Anaesthetics','Local Anaesthetics','medical drugs','$LocalAnaesthetics_serial')";
			$res=$db->Execute($q);
			// Preoperative medication and sedation for short-term procedures- sub catalogue - level 2
			$Preoperativemedication = "ct_default-51";
			$Preoperativemedication_serial = shn_cs_generate_subcat_item_serial($ANAESTHETICS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$ANAESTHETICS','$Preoperativemedication','Preoperative medication and sedation for short-term procedures','Preoperative medication and sedation for short-term procedures','medical drugs','$Preoperativemedication_serial')";
			$res=$db->Execute($q);

		// ANALGESICS- sub catalogue - level 1
		$ANALGESICS = "ct_default-52";
		$ANALGESICS_serial = shn_cs_generate_subcat_item_serial($medicaldrug);
		$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$medicaldrug','$ANALGESICS','ANALGESICS','ANALGESICS, ANTIPYRETICS, NON-STEROIDAL ANTI-INFLAMMATORY DRUGS (NSAIDs), DRUGS USED TO TREAT GOUT AND DISEASE MODIFYING AGENTS IN RHEUMATOID DISORDERS (DMARDs)','medical drugs','$ANALGESICS_serial')";
		$res=$db->Execute($q);
			// Non-opioids and NSAIDs- sub catalogue - level 2
			$NonopioidsandNSAIDs = "ct_default-53";
			$NonopioidsandNSAIDs_serial = shn_cs_generate_subcat_item_serial($ANALGESICS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$ANALGESICS','$NonopioidsandNSAIDs','Non-opioids and NSAIDs','Non-opioids and NSAIDs','medical drugs','$NonopioidsandNSAIDs_serial')";
			$res=$db->Execute($q);
			// Opioid Analgesics- sub catalogue - level 2
			$OpioidAnalgesics = "ct_default-54";
			$OpioidAnalgesics_serial = shn_cs_generate_subcat_item_serial($ANALGESICS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$ANALGESICS','$OpioidAnalgesics','Opioid Analgesics','Opioid Analgesics','medical drugs','$OpioidAnalgesics_serial')";
			$res=$db->Execute($q);
			// Drugs used to treat gout- sub catalogue - level 2
			$Drugsusedtotreatgout = "ct_default-55";
			$Drugsusedtotreatgout_serial = shn_cs_generate_subcat_item_serial($ANALGESICS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$ANALGESICS','$Drugsusedtotreatgout','Drugs used to treat gout','Drugs used to treat gout','medical drugs','$Drugsusedtotreatgout_serial')";
			$res=$db->Execute($q);
			// Disease modifying agents used in rheumatoid disorders (DMARDs) - sub catalogue - level 2
			$DMARDs = "ct_default-56";
			$DMARDs_serial = shn_cs_generate_subcat_item_serial($ANALGESICS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$ANALGESICS','$DMARDs','DMARD','Disease modifying agents used in rheumatoid disorders (DMARDs)','medical drugs','$DMARDs_serial')";
			$res=$db->Execute($q);

		// ANTIALLERGICS AND DRUGS USED IN ANAPHYLAXIS- sub catalogue - level 1
		$ANTIALLERGICSANAPHYLAXIS = "ct_default-57";
		$ANTIALLERGICSANAPHYLAXIS_serial = shn_cs_generate_subcat_item_serial($medicaldrug);
		$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$medicaldrug','$ANTIALLERGICSANAPHYLAXIS','ANTIALLERGICS AND ANAPHYLAXIS Treatment Agent','ANTIALLERGICS AND DRUGS USED IN ANAPHYLAXIS Treatment Agent','medical drugs','$ANTIALLERGICSANAPHYLAXIS_serial')";
		$res=$db->Execute($q);

		// ANTIDOTES AND OTHER SUBSTANCES USED IN POISONING- sub catalogue - level 1
		$ANTIDOTESUSEDINPOISONING = "ct_default-58";
		$ANTIDOTESUSEDINPOISONING_serial = shn_cs_generate_subcat_item_serial($medicaldrug);
		$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$medicaldrug','$ANTIDOTESUSEDINPOISONING','ANTIDOTES AND OTHER SUBSTANCES USED IN POISONING','ANTIDOTES AND OTHER SUBSTANCES USED IN POISONING','medical drugs','$ANTIDOTESUSEDINPOISONING_serial')";
		$res=$db->Execute($q);
			// 4.1 Non-specific- sub catalogue - level 2
			$Nonspecific = "ct_default-59";
			$Nonspecific_serial = shn_cs_generate_subcat_item_serial($ANTIDOTESUSEDINPOISONING);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$ANTIDOTESUSEDINPOISONING','$Nonspecific','Non-specific','Non-specific','medical drugs','$Nonspecific_serial')";
			$res=$db->Execute($q);
			// 4.2 Specific- sub catalogue - level 2
			$Specific = "ct_default-60";
			$Specific_serial = shn_cs_generate_subcat_item_serial($ANTIDOTESUSEDINPOISONING);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$ANTIDOTESUSEDINPOISONING','$Specific','Specific','Specific','medical drugs','$Specific_serial')";
			$res=$db->Execute($q);

		// 5. ANTICONVULSANTS/ANTIEPILEPTICS- sub catalogue - level 1
		$ANTICONVULSANTSANTIEPILEPTICS = "ct_default-61";
		$ANTICONVULSANTSANTIEPILEPTICS_serial = shn_cs_generate_subcat_item_serial($medicaldrug);
		$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$medicaldrug','$ANTICONVULSANTSANTIEPILEPTICS','ANTICONVULSANTS/ANTIEPILEPTICS','ANTICONVULSANTS/ANTIEPILEPTICS','medical drugs','$ANTICONVULSANTSANTIEPILEPTICS_serial')";
		$res=$db->Execute($q);

		// 6. ANTI-INFECTIVE DRUGS - sub catalogue - level 1
		$ANTIINFECTIVEDRUGS = "ct_default-62";
		$ANTIINFECTIVEDRUGS_serial = shn_cs_generate_subcat_item_serial($medicaldrug);
		$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$medicaldrug','$ANTIINFECTIVEDRUGS','ANTI-INFECTIVE DRUGS','ANTI-INFECTIVE DRUGS','medical drugs','$ANTIINFECTIVEDRUGS_serial')";
		$res=$db->Execute($q);
			// 6.1.1 Intestinal anthelminthics- sub catalogue - level 2
			$Intestinalanthelminthics = "ct_default-63";
			$Intestinalanthelminthics_serial = shn_cs_generate_subcat_item_serial($ANTIINFECTIVEDRUGS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$ANTIINFECTIVEDRUGS','$Intestinalanthelminthics','Intestinal anthelminthics','Intestinal anthelminthics','medical drugs','$Intestinalanthelminthics_serial')";
			$res=$db->Execute($q);
			// 6.1.2 Antifilarials- sub catalogue - level 2
			$Antifilarials = "ct_default-64";
			$Antifilarials_serial = shn_cs_generate_subcat_item_serial($ANTIINFECTIVEDRUGS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$ANTIINFECTIVEDRUGS','$Antifilarials','Antifilarials','Antifilarials','medical drugs','$Antifilarials_serial')";
			$res=$db->Execute($q);
			// 6.1.3 Antischistosomals and anti-trematode drugs- sub catalogue - level 2
			$Antischistosomalsandantitrematodedrugs = "ct_default-65";
			$Antischistosomalsandantitrematodedrugs_serial = shn_cs_generate_subcat_item_serial($ANTIINFECTIVEDRUGS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$ANTIINFECTIVEDRUGS','$Antischistosomalsandantitrematodedrugs','Antischistosomals and anti-trematode drugs','Antischistosomals and anti-trematode drugs','medical drugs','$Antischistosomalsandantitrematodedrugs_serial')";
			$res=$db->Execute($q);
			// 6.2 Antibacterials- sub catalogue - level 2
			$Antibacterials = "ct_default-66";
			$Antibacterials_serial = shn_cs_generate_subcat_item_serial($ANTIINFECTIVEDRUGS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$ANTIINFECTIVEDRUGS','$Antibacterials','Antibacterials','Antibacterials','medical drugs','$Antibacterials_serial')";
			$res=$db->Execute($q);
			// 6.2.1 Beta lactam drugs- sub catalogue - level 2
			$Betalactamdrugs = "ct_default-67";
			$Betalactamdrugs_serial = shn_cs_generate_subcat_item_serial($ANTIINFECTIVEDRUGS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$ANTIINFECTIVEDRUGS','$Betalactamdrugs','Beta lactam drugs','Beta lactam drugs','medical drugs','$Betalactamdrugs_serial')";
			$res=$db->Execute($q);
			// 6.2.2 Other antibacterials- sub catalogue - level 2
			$Otherantibacterials = "ct_default-68";
			$Otherantibacterials_serial = shn_cs_generate_subcat_item_serial($ANTIINFECTIVEDRUGS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$ANTIINFECTIVEDRUGS','$Otherantibacterials','Other antibacterials','Other antibacterials','medical drugs','$Otherantibacterials_serial')";
			$res=$db->Execute($q);
			// 6.2.3 Antileprosy drugs- sub catalogue - level 2
			$Antileprosydrugs = "ct_default-69";
			$Antileprosydrugs_serial = shn_cs_generate_subcat_item_serial($ANTIINFECTIVEDRUGS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$ANTIINFECTIVEDRUGS','$Antileprosydrugs','Antileprosy drugs','Antileprosy drugs','medical drugs','$Antileprosydrugs_serial')";
			$res=$db->Execute($q);
			// 6.2.4 Antituberculosis drugs- sub catalogue - level 2
			$Antituberculosisdrugs = "ct_default-70";
			$Antituberculosisdrugs_serial = shn_cs_generate_subcat_item_serial($ANTIINFECTIVEDRUGS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$ANTIINFECTIVEDRUGS','$Antituberculosisdrugs','Antituberculosis drugs','Antituberculosis drugs','medical drugs','$Antituberculosisdrugs_serial')";
			$res=$db->Execute($q);
			// 6.3 Antifungal drugs- sub catalogue - level 2
			$Antifungaldrugs = "ct_default-71";
			$Antifungaldrugs_serial = shn_cs_generate_subcat_item_serial($ANTIINFECTIVEDRUGS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$ANTIINFECTIVEDRUGS','$Antifungaldrugs','Antifungal drugs','Antifungal drugs','medical drugs','$Antifungaldrugs_serial')";
			$res=$db->Execute($q);
			// 6.4.1 Antiherpes- sub catalogue - level 2
			$Antiherpes = "ct_default-72";
			$Antiherpes_serial = shn_cs_generate_subcat_item_serial($ANTIINFECTIVEDRUGS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$ANTIINFECTIVEDRUGS','$Antiherpes','Antiherpes','Antiherpes','medical drugs','$Antiherpes_serial')";
			$res=$db->Execute($q);
			// 6.4.2 Antiretrovirals - sub catalogue - level 2
			$Antiretrovirals = "ct_default-73";
			$Antiretrovirals_serial = shn_cs_generate_subcat_item_serial($ANTIINFECTIVEDRUGS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$ANTIINFECTIVEDRUGS','$Antiretrovirals','Antiretrovirals','Antiretrovirals','medical drugs','$Antiretrovirals_serial')";
			$res=$db->Execute($q);
			// 6.5.1 Antiamoebic and antigiardiasis drugs - sub catalogue - level 2
			$Antiamoebicandantigiardiasisdrugs = "ct_default-74";
			$Antiamoebicandantigiardiasisdrugs_serial = shn_cs_generate_subcat_item_serial($ANTIINFECTIVEDRUGS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$ANTIINFECTIVEDRUGS','$Antiamoebicandantigiardiasisdrugs','Antiamoebic and antigiardiasis drugs','Antiamoebic and antigiardiasis drugs','medical drugs','$Antiamoebicandantigiardiasisdrugs_serial')";
			$res=$db->Execute($q);
			// 6.5.2 Antileishmaniasis drugs - sub catalogue - level 2
			$Antileishmaniasisdrugs = "ct_default-75";
			$Antileishmaniasisdrugs_serial = shn_cs_generate_subcat_item_serial($ANTIINFECTIVEDRUGS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$ANTIINFECTIVEDRUGS','$Antileishmaniasisdrugs','Antileishmaniasis drugs','Antileishmaniasis drugs','medical drugs','$Antileishmaniasisdrugs_serial')";
			$res=$db->Execute($q);
			// 6.5.3 Antimalarial drugs - sub catalogue - level 2
			$Antimalarialdrugs = "ct_default-76";
			$Antimalarialdrugs_serial = shn_cs_generate_subcat_item_serial($ANTIINFECTIVEDRUGS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$ANTIINFECTIVEDRUGS','$Antimalarialdrugs','Antimalarial drugs','Antimalarial drugs','medical drugs','$Antimalarialdrugs_serial')";
			$res=$db->Execute($q);
			// 6.5.4 Anti-pneumocystosis and anti-toxoplasmosis drugs - sub catalogue - level 2
			$Antipneumocystosisandantitoxoplasmosisdrugs = "ct_default-77";
			$Antipneumocystosisandantitoxoplasmosisdrugs_serial = shn_cs_generate_subcat_item_serial($ANTIINFECTIVEDRUGS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$ANTIINFECTIVEDRUGS','$Antipneumocystosisandantitoxoplasmosisdrugs','Anti-pneumocystosis and anti-toxoplasmosis drugs','Anti-pneumocystosis and anti-toxoplasmosis drugs','medical drugs','$Antipneumocystosisandantitoxoplasmosisdrugs_serial')";
			$res=$db->Execute($q);
			// 6.5.5 Antitrypanosomal drugs - sub catalogue - level 2
			$Antitrypanosomaldrugs = "ct_default-78";
			$Antitrypanosomaldrugs_serial = shn_cs_generate_subcat_item_serial($ANTIINFECTIVEDRUGS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$ANTIINFECTIVEDRUGS','$Antitrypanosomaldrugs','Antitrypanosomal drugs','Antitrypanosomal drugs','medical drugs','$Antitrypanosomaldrugs_serial')";
			$res=$db->Execute($q);
			// 6.6 Insect repellents - sub catalogue - level 2
			$Insectrepellents = "ct_default-79";
			$Insectrepellents_serial = shn_cs_generate_subcat_item_serial($ANTIINFECTIVEDRUGS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$ANTIINFECTIVEDRUGS','$Insectrepellents','Insect repellents','Insect repellents','medical drugs','$Insectrepellents_serial')";
			$res=$db->Execute($q);

		// 7. ANTIMIGRAINE DRUGS - sub catalogue - level 1
		$ANTIMIGRAINEDRUGS = "ct_default-80";
		$ANTIMIGRAINEDRUGS_serial = shn_cs_generate_subcat_item_serial($medicaldrug);
		$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$medicaldrug','$ANTIMIGRAINEDRUGS','ANTIMIGRAINE DRUGS','ANTIMIGRAINE DRUGS','medical drugs','$ANTIMIGRAINEDRUGS_serial')";
		$res=$db->Execute($q);
			// 7.1  For treatment of acute attack- sub catalogue - level 2
			$Fortreatmentofacuteattack = "ct_default-81";
			$Fortreatmentofacuteattack_serial = shn_cs_generate_subcat_item_serial($ANTIMIGRAINEDRUGS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$ANTIMIGRAINEDRUGS','$Fortreatmentofacuteattack',' For treatment of acute attack',' For treatment of acute attack','medical drugs','$Fortreatmentofacuteattack_serial')";
			$res=$db->Execute($q);
			// 7.2 For prophylaxis - sub catalogue - level 2
			$Forprophylaxis = "ct_default-82";
			$Forprophylaxis_serial = shn_cs_generate_subcat_item_serial($ANTIMIGRAINEDRUGS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$ANTIMIGRAINEDRUGS','$Forprophylaxis','  For prophylaxis',' For prophylaxis','medical drugs','$Forprophylaxis_serial')";
			$res=$db->Execute($q);

		// 8. ANTINEOPLASTIC, IMMUNOSUPPRESSIVES AND DRUGS USED IN PALLIATIVE CARE - sub catalogue - level 1
		$ANTINEOPLASTICIMMUNOSUPPRESSIVES = "ct_default-83";
		$ANTINEOPLASTICIMMUNOSUPPRESSIVES_serial = shn_cs_generate_subcat_item_serial($medicaldrug);
		$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$medicaldrug','$ANTINEOPLASTICIMMUNOSUPPRESSIVES','ANTINEOPLASTIC IMMUNOSUPPRESSIVES AND DRUGS USED IN PALLIATIVE CARE','ANTINEOPLASTIC IMMUNOSUPPRESSIVES AND DRUGS USED IN PALLIATIVE CARE','medical drugs','$ANTINEOPLASTICIMMUNOSUPPRESSIVES_serial')";
		$res=$db->Execute($q);
			// 8.1  Immunosuppressive drugs- sub catalogue - level 2
			$Immunosuppressivedrugs = "ct_default-84";
			$Immunosuppressivedrugs_serial = shn_cs_generate_subcat_item_serial($ANTINEOPLASTICIMMUNOSUPPRESSIVES);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$ANTINEOPLASTICIMMUNOSUPPRESSIVES','$Immunosuppressivedrugs','Immunosuppressive drugs','Immunosuppressive drugs','medical drugs','$Immunosuppressivedrugs_serial')";
			$res=$db->Execute($q);
			// 8.2  Cytotoxic drugs- sub catalogue - level 2
			$Cytotoxicdrugs = "ct_default-85";
			$Cytotoxicdrugs_serial = shn_cs_generate_subcat_item_serial($ANTINEOPLASTICIMMUNOSUPPRESSIVES);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$ANTINEOPLASTICIMMUNOSUPPRESSIVES','$Cytotoxicdrugs','Cytotoxic drugs','Cytotoxic drugs','medical drugs','$Cytotoxicdrugs_serial')";
			$res=$db->Execute($q);
			// 8.3  Hormones and antihormones- sub catalogue - level 2
			$Hormonesandantihormones = "ct_default-86";
			$Hormonesandantihormones_serial = shn_cs_generate_subcat_item_serial($ANTINEOPLASTICIMMUNOSUPPRESSIVES);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$ANTINEOPLASTICIMMUNOSUPPRESSIVES','$Hormonesandantihormones','Hormones and antihormones','Hormones and antihormones','medical drugs','$Hormonesandantihormones_serial')";
			$res=$db->Execute($q);
			// 8.4 Drugs used in palliative care - sub catalogue - level 2
			$Drugsusedinpalliativecare = "ct_default-87";
			$Drugsusedinpalliativecare_serial = shn_cs_generate_subcat_item_serial($ANTINEOPLASTICIMMUNOSUPPRESSIVES);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$ANTINEOPLASTICIMMUNOSUPPRESSIVES','$Drugsusedinpalliativecare','Drugs used in palliative care','Drugs used in palliative care','medical drugs','$Drugsusedinpalliativecare_serial')";
			$res=$db->Execute($q);

		// 9. ANTIPARKINSONIAN DRUGS - sub catalogue - level 1
		$ANTIPARKINSONIANDRUGS = "ct_default-88";
		$ANTIPARKINSONIANDRUGS_serial = shn_cs_generate_subcat_item_serial($medicaldrug);
		$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$medicaldrug','$ANTIPARKINSONIANDRUGS','ANTIPARKINSONIAN DRUGS','ANTIPARKINSONIAN DRUGS','medical drugs','$ANTIPARKINSONIANDRUGS_serial')";
		$res=$db->Execute($q);

		//10. DRUGS AFFECTING THE BLOOD - sub catalogue - level 1
		$DRUGSAFFECTINGTHEBLOOD = "ct_default-89";
		$DRUGSAFFECTINGTHEBLOOD_serial = shn_cs_generate_subcat_item_serial($medicaldrug);
		$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$medicaldrug','$DRUGSAFFECTINGTHEBLOOD','DRUGS AFFECTING THE BLOOD','DRUGS AFFECTING THE BLOOD','medical drugs','$DRUGSAFFECTINGTHEBLOOD_serial')";
		$res=$db->Execute($q);
			// 10.1 Anti-anaemia drugs - sub catalogue - level 2
			$Antianaemiadrugs = "ct_default-90";
			$Antianaemiadrugs_serial = shn_cs_generate_subcat_item_serial($DRUGSAFFECTINGTHEBLOOD);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$DRUGSAFFECTINGTHEBLOOD','$Antianaemiadrugs','Anti-anaemia drugs','Anti-anaemia drugs','medical drugs','$Antianaemiadrugs_serial')";
			$res=$db->Execute($q);
			// 10.2 Drugs affecting coagulation - sub catalogue - level 2
			$Drugsaffectingcoagulation = "ct_default-91";
			$Drugsaffectingcoagulation_serial = shn_cs_generate_subcat_item_serial($DRUGSAFFECTINGTHEBLOOD);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$DRUGSAFFECTINGTHEBLOOD','$Drugsaffectingcoagulation','Drugs affecting coagulation','Drugs affecting coagulation','medical drugs','$Drugsaffectingcoagulation_serial')";
			$res=$db->Execute($q);

		//11. BLOOD PRODUCTS AND PLASMA SUBSTITUTES - sub catalogue - level 1
		$BLOODPRODUCTSANDPLASMASUBSTITUTES = "ct_default-92";
		$BLOODPRODUCTSANDPLASMASUBSTITUTES_serial = shn_cs_generate_subcat_item_serial($medicaldrug);
		$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$medicaldrug','$BLOODPRODUCTSANDPLASMASUBSTITUTES','BLOOD PRODUCTS AND PLASMA SUBSTITUTES','BLOOD PRODUCTS AND PLASMA SUBSTITUTES','medical drugs','$BLOODPRODUCTSANDPLASMASUBSTITUTES_serial')";
		$res=$db->Execute($q);
			// 11.1 Plasma substitutes - sub catalogue - level 2
			$Plasmasubstitutes = "ct_default-93";
			$Plasmasubstitutes_serial = shn_cs_generate_subcat_item_serial($BLOODPRODUCTSANDPLASMASUBSTITUTES);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$BLOODPRODUCTSANDPLASMASUBSTITUTES','$Plasmasubstitutes','Plasma substitutes','Plasma substitutes','medical drugs','$Plasmasubstitutes_serial')";
			$res=$db->Execute($q);
			// 11.2 Plasma fractions for specific use - sub catalogue - level 2
			$Plasmafractionsforspecificuse = "ct_default-94";
			$Plasmafractionsforspecificuse_serial = shn_cs_generate_subcat_item_serial($BLOODPRODUCTSANDPLASMASUBSTITUTES);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$BLOODPRODUCTSANDPLASMASUBSTITUTES','$Plasmafractionsforspecificuse','Plasma fractions for specific use','Plasma fractions for specific use','medical drugs','$Plasmafractionsforspecificuse_serial')";
			$res=$db->Execute($q);

		//12. CARDIOVASCULAR DRUGS - sub catalogue - level 1
		$CARDIOVASCULARDRUGS = "ct_default-95";
		$CARDIOVASCULARDRUGS_serial = shn_cs_generate_subcat_item_serial($medicaldrug);
		$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$medicaldrug','$CARDIOVASCULARDRUGS','CARDIOVASCULAR DRUGS','CARDIOVASCULAR DRUGS','medical drugs','$CARDIOVASCULARDRUGS_serial')";
		$res=$db->Execute($q);
			// 12.1 Antianginal drugs - sub catalogue - level 2
			$Antianginaldrugs = "ct_default-96";
			$Antianginaldrugs_serial = shn_cs_generate_subcat_item_serial($CARDIOVASCULARDRUGS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$CARDIOVASCULARDRUGS','$Antianginaldrugs','Antianginal drugs','Antianginal drugs','medical drugs','$Antianginaldrugs_serial')";
			$res=$db->Execute($q);
			// 12.2 Antiarrhythmic drugs - sub catalogue - level 2
			$Antiarrhythmicdrugs = "ct_default-97";
			$Antiarrhythmicdrugs_serial = shn_cs_generate_subcat_item_serial($CARDIOVASCULARDRUGS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$CARDIOVASCULARDRUGS','$Antiarrhythmicdrugs','Antiarrhythmic drugs','Antiarrhythmic drugs','medical drugs','$Antiarrhythmicdrugs_serial')";
			$res=$db->Execute($q);
			// 12.3 Antihypertensive drugs - sub catalogue - level 2
			$Antihypertensivedrugs = "ct_default-98";
			$Antihypertensivedrugs_serial = shn_cs_generate_subcat_item_serial($CARDIOVASCULARDRUGS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$CARDIOVASCULARDRUGS','$Antihypertensivedrugs','Antihypertensive drugs','Antihypertensive drugs','medical drugs','$Antihypertensivedrugs_serial')";
			$res=$db->Execute($q);
			// 12.4 Drugs used in heart failure - sub catalogue - level 2
			$Drugsusedinheartfailure = "ct_default-99";
			$Drugsusedinheartfailure_serial = shn_cs_generate_subcat_item_serial($CARDIOVASCULARDRUGS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$CARDIOVASCULARDRUGS','$Drugsusedinheartfailure','Drugs used in heart failure','Drugs used in heart failure','medical drugs','$Drugsusedinheartfailure_serial')";
			$res=$db->Execute($q);
			// 12.5  Antithrombotic drugs - sub catalogue - level 2
			$Antithromboticdrugs = "ct_default-100";
			$Antithromboticdrugs_serial = shn_cs_generate_subcat_item_serial($CARDIOVASCULARDRUGS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$CARDIOVASCULARDRUGS','$Antithromboticdrugs',' Antithrombotic drugs',' Antithrombotic drugs','medical drugs','$Antithromboticdrugs_serial')";
			$res=$db->Execute($q);
			// 12.6  Lipid-lowering agents - sub catalogue - level 2
			$Lipidloweringagents = "ct_default-101";
			$Lipidloweringagents_serial = shn_cs_generate_subcat_item_serial($CARDIOVASCULARDRUGS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$CARDIOVASCULARDRUGS','$Lipidloweringagents','Lipid-lowering agents','Lipid-lowering agents','medical drugs','$Lipidloweringagents_serial')";
			$res=$db->Execute($q);

		//13. DERMATOLOGICAL DRUGS (topical)  - sub catalogue - level 1
		$DERMATOLOGICALDRUGS = "ct_default-102";
		$DERMATOLOGICALDRUGS_serial = shn_cs_generate_subcat_item_serial($medicaldrug);
		$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$medicaldrug','$DERMATOLOGICALDRUGS','DERMATOLOGICAL DRUGS (topical) ','DERMATOLOGICAL DRUGS (topical) ','medical drugs','$DERMATOLOGICALDRUGS_serial')";
		$res=$db->Execute($q);
			// 13.1 Antifungal drugs - sub catalogue - level 2
			$DERMATOAntifungaldrugs = "ct_default-103";
			$DERMATOAntifungaldrugs_serial = shn_cs_generate_subcat_item_serial($DERMATOLOGICALDRUGS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$DERMATOLOGICALDRUGS','$DERMATOAntifungaldrugs','Antifungal drugs','Antifungal drugs','medical drugs','$DERMATOAntifungaldrugs_serial')";
			$res=$db->Execute($q);
			// 13.2 Anti-infective drugs - sub catalogue - level 2
			$DERMATOAntiinfectivedrugs = "ct_default-104";
			$DERMATOAntiinfectivedrugs_serial = shn_cs_generate_subcat_item_serial($DERMATOLOGICALDRUGS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$DERMATOLOGICALDRUGS','$DERMATOAntiinfectivedrugs','Anti-infective drugs','Anti-infective drugs','medical drugs','$DERMATOAntiinfectivedrugs_serial')";
			$res=$db->Execute($q);
			// 13.3 Anti-inflammatory and antipruritic drugs - sub catalogue - level 2
			$DERMATOAntiinflammatoryandantipruriticdrugs = "ct_default-105";
			$DERMATOAntiinflammatoryandantipruriticdrugs_serial = shn_cs_generate_subcat_item_serial($DERMATOLOGICALDRUGS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$DERMATOLOGICALDRUGS','$DERMATOAntiinflammatoryandantipruriticdrugs','Anti-inflammatory and antipruritic drugs','Anti-inflammatory and antipruritic drugs','medical drugs','$DERMATOAntiinflammatoryandantipruriticdrugs_serial')";
			$res=$db->Execute($q);
			// 13.4 Astringent drugs - sub catalogue - level 2
			$DERMATOAstringentdrugs = "ct_default-106";
			$DERMATOAstringentdrugs_serial = shn_cs_generate_subcat_item_serial($DERMATOLOGICALDRUGS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$DERMATOLOGICALDRUGS','$DERMATOAstringentdrugs','Astringent drugs','Astringent drugs','medical drugs','$DERMATOAstringentdrugs_serial')";
			$res=$db->Execute($q);
			// 13.5 Drugs affecting skin differentiation and proliferation - sub catalogue - level 2
			$DERMATODrugsaffectingskindifferentiationandproliferation = "ct_default-107";
			$DERMATODrugsaffectingskindifferentiationandproliferation_serial = shn_cs_generate_subcat_item_serial($DERMATOLOGICALDRUGS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$DERMATOLOGICALDRUGS','$DERMATODrugsaffectingskindifferentiationandproliferation','Drugs affecting skin differentiation and proliferation','Drugs affecting skin differentiation and proliferation','medical drugs','$DERMATODrugsaffectingskindifferentiationandproliferation_serial')";
			$res=$db->Execute($q);
			// 13.6 Scabicides and pediculicides - sub catalogue - level 2
			$DERMATOScabicidesandpediculicides = "ct_default-108";
			$DERMATOScabicidesandpediculicides_serial = shn_cs_generate_subcat_item_serial($DERMATOLOGICALDRUGS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$DERMATOLOGICALDRUGS','$DERMATOScabicidesandpediculicides','Scabicides and pediculicides','Scabicides and pediculicides','medical drugs','$DERMATOScabicidesandpediculicides_serial')";
			$res=$db->Execute($q);
			// 13.7 Ultraviolet blocking agents - sub catalogue - level 2
			$DERMATOUltravioletblockingagents = "ct_default-109";
			$DERMATOUltravioletblockingagents_serial = shn_cs_generate_subcat_item_serial($DERMATOLOGICALDRUGS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$DERMATOLOGICALDRUGS','$DERMATOUltravioletblockingagents','Ultraviolet blocking agents','Ultraviolet blocking agents','medical drugs','$DERMATOUltravioletblockingagents_serial')";
			$res=$db->Execute($q);

		//14. DIAGNOSTIC AGENTS  - sub catalogue - level 1
		$DIAGNOSTICAGENTS = "ct_default-110";
		$DIAGNOSTICAGENTS_serial = shn_cs_generate_subcat_item_serial($medicaldrug);
		$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$medicaldrug','$DIAGNOSTICAGENTS','DIAGNOSTIC AGENTS ','DIAGNOSTIC AGENTS ','medical drugs','$DIAGNOSTICAGENTS_serial')";
		$res=$db->Execute($q);
			// 14.1 Ophthalmic drugs - sub catalogue - level 2
			$DIAGNOSTICOphthalmicdrugs = "ct_default-111";
			$DIAGNOSTICOphthalmicdrugs_serial = shn_cs_generate_subcat_item_serial($DIAGNOSTICAGENTS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$DIAGNOSTICAGENTS','$DIAGNOSTICOphthalmicdrugs','Ophthalmic drugs','Ophthalmic drugs','medical drugs','$DIAGNOSTICOphthalmicdrugs_serial')";
			$res=$db->Execute($q);
			// 14.2 Radiocontrast media - sub catalogue - level 2
			$DIAGNOSTICORadiocontrastmedia = "ct_default-112";
			$DIAGNOSTICORadiocontrastmedia_serial = shn_cs_generate_subcat_item_serial($DIAGNOSTICAGENTS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$DIAGNOSTICAGENTS','$DIAGNOSTICORadiocontrastmedia','Radiocontrast media','Radiocontrast media','medical drugs','$DIAGNOSTICORadiocontrastmedia_serial')";
			$res=$db->Execute($q);

		//15. DISINFECTANTS AND ANTISEPTICS  - sub catalogue - level 1
		$DISINFECTANTSANDANTISEPTICS = "ct_default-113";
		$DISINFECTANTSANDANTISEPTICS_serial = shn_cs_generate_subcat_item_serial($medicaldrug);
		$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$medicaldrug','$DISINFECTANTSANDANTISEPTICS','DISINFECTANTS AND ANTISEPTICS ','DISINFECTANTS AND ANTISEPTICS ','medical drugs','$DISINFECTANTSANDANTISEPTICS_serial')";
		$res=$db->Execute($q);
			// 15.1 Antiseptics - sub catalogue - level 2
			$DISINFECTAntiseptics = "ct_default-114";
			$DISINFECTAntiseptics_serial = shn_cs_generate_subcat_item_serial($DISINFECTANTSANDANTISEPTICS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$DISINFECTANTSANDANTISEPTICS','$DISINFECTAntiseptics','Ophthalmic drugs','Ophthalmic drugs','medical drugs','$DISINFECTAntiseptics_serial')";
			$res=$db->Execute($q);
			// 15.2 Disinfectants - sub catalogue - level 2
			$DISINFECTDisinfectants = "ct_default-115";
			$DISINFECTDisinfectants_serial = shn_cs_generate_subcat_item_serial($DISINFECTANTSANDANTISEPTICS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$DISINFECTANTSANDANTISEPTICS','$DISINFECTDisinfectants','Disinfectants','Disinfectants','medical drugs','$DISINFECTDisinfectants_serial')";
			$res=$db->Execute($q);

		//16. DIURETICS  - sub catalogue - level 1
		$DIURETICS = "ct_default-116";
		$DIURETICS_serial = shn_cs_generate_subcat_item_serial($medicaldrug);
		$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$medicaldrug','$DIURETICS','DIURETICS','DIURETICS','medical drugs','$DIURETICS_serial')";
		$res=$db->Execute($q);

		//17. GASTROINTESTINAL DRUGS  - sub catalogue - level 1
		$GASTROINTESTINALDRUGS = "ct_default-117";
		$GASTROINTESTINALDRUGS_serial = shn_cs_generate_subcat_item_serial($medicaldrug);
		$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$medicaldrug','$GASTROINTESTINALDRUGS','GASTROINTESTINAL DRUGS','GASTROINTESTINAL DRUGS','medical drugs','$GASTROINTESTINALDRUGS_serial')";
		$res=$db->Execute($q);
			// 17.1 Antacids and other antiulcer drugs- sub catalogue - level 2
			$GASTROINTESTINALAntacidsandotherantiulcerdrugs = "ct_default-118";
			$GASTROINTESTINALAntacidsandotherantiulcerdrugs_serial = shn_cs_generate_subcat_item_serial($GASTROINTESTINALDRUGS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$GASTROINTESTINALDRUGS','$GASTROINTESTINALAntacidsandotherantiulcerdrugs','Antacids and other antiulcer drugs','Antacids and other antiulcer drugs','medical drugs','$GASTROINTESTINALAntacidsandotherantiulcerdrugs_serial')";
			$res=$db->Execute($q);
			// 17.2 Antiemetic drugs- sub catalogue - level 2
			$GASTROINTESTINALAntiemeticdrugs = "ct_default-119";
			$GASTROINTESTINALAntiemeticdrugs_serial = shn_cs_generate_subcat_item_serial($GASTROINTESTINALDRUGS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$GASTROINTESTINALDRUGS','$GASTROINTESTINALAntiemeticdrugs','Antiemetic drugs','Antiemetic drugs','medical drugs','$GASTROINTESTINALAntiemeticdrugs_serial')";
			$res=$db->Execute($q);
			// 17.3 Antihaemorrhoidal drugs- sub catalogue - level 2
			$GASTROINTESTINALAntihaemorrhoidaldrugs = "ct_default-120";
			$GASTROINTESTINALAntihaemorrhoidaldrugs_serial = shn_cs_generate_subcat_item_serial($GASTROINTESTINALDRUGS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$GASTROINTESTINALDRUGS','$GASTROINTESTINALAntihaemorrhoidaldrugs','Antihaemorrhoidal drugs','Antihaemorrhoidal drugs','medical drugs','$GASTROINTESTINALAntihaemorrhoidaldrugs_serial')";
			$res=$db->Execute($q);
			// 17.4 Anti-inflammatory drugs- sub catalogue - level 2
			$GASTROINTESTINALAntiinflammatorydrugs = "ct_default-121";
			$GASTROINTESTINALAntiinflammatorydrugs_serial = shn_cs_generate_subcat_item_serial($GASTROINTESTINALDRUGS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$GASTROINTESTINALDRUGS','$GASTROINTESTINALAntiinflammatorydrugs','Anti-inflammatory drugs','Anti-inflammatory drugs','medical drugs','$GASTROINTESTINALAntiinflammatorydrugs_serial')";
			$res=$db->Execute($q);
			// 17.5 Antispasmodic drugs- sub catalogue - level 2
			$GASTROINTESTINALAntispasmodicdrugs = "ct_default-122";
			$GASTROINTESTINALAntispasmodicdrugs_serial = shn_cs_generate_subcat_item_serial($GASTROINTESTINALDRUGS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$GASTROINTESTINALDRUGS','$GASTROINTESTINALAntispasmodicdrugs','Antispasmodic drugs','Antispasmodic drugs','medical drugs','$GASTROINTESTINALAntispasmodicdrugs_serial')";
			$res=$db->Execute($q);
			// 17.6 Laxatives- sub catalogue - level 2
			$GASTROINTESTINALLaxatives = "ct_default-123";
			$GASTROINTESTINALLaxatives_serial = shn_cs_generate_subcat_item_serial($GASTROINTESTINALDRUGS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$GASTROINTESTINALDRUGS','$GASTROINTESTINALLaxatives','Laxatives','Laxatives','medical drugs','$GASTROINTESTINALLaxatives_serial')";
			$res=$db->Execute($q);
			// 17.7.1 Oral rehydration- sub catalogue - level 2
			$GASTROINTESTINALOralrehydration = "ct_default-124";
			$GASTROINTESTINALOralrehydration_serial = shn_cs_generate_subcat_item_serial($GASTROINTESTINALDRUGS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$GASTROINTESTINALDRUGS','$GASTROINTESTINALOralrehydration','Oral rehydration','Oral rehydration','medical drugs','$GASTROINTESTINALOralrehydration_serial')";
			$res=$db->Execute($q);
			// 17.7.2 Antidiarrhoeal (symptomatic) drugs- sub catalogue - level 2
			$GASTROINTESTINALAntidiarrhoealsymptomaticdrugs = "ct_default-125";
			$GASTROINTESTINALAntidiarrhoealsymptomaticdrugs_serial = shn_cs_generate_subcat_item_serial($GASTROINTESTINALDRUGS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$GASTROINTESTINALDRUGS','$GASTROINTESTINALAntidiarrhoealsymptomaticdrugs','Antidiarrhoeal (symptomatic) drugs','Antidiarrhoeal (symptomatic) drugs','medical drugs','$GASTROINTESTINALAntidiarrhoealsymptomaticdrugs_serial')";
			$res=$db->Execute($q);

		//18. HORMONES, OTHER ENDOCRINE DRUGS AND CONTRACEPTIVES  - sub catalogue - level 1
		$HORMONESOTHERENDOCRINEDRUGS = "ct_default-126";
		$HORMONESOTHERENDOCRINEDRUGS_serial = shn_cs_generate_subcat_item_serial($medicaldrug);
		$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$medicaldrug','$HORMONESOTHERENDOCRINEDRUGS','HORMONES OTHER ENDOCRINE DRUGS AND CONTRACEPTIVES','HORMONES OTHER ENDOCRINE DRUGS AND CONTRACEPTIVES','medical drugs','$HORMONESOTHERENDOCRINEDRUGS_serial')";
		$res=$db->Execute($q);
			// 18.1 Adrenal hormones and synthetic substitutes- sub catalogue - level 2
			$HORMONESAdrenalhormonesandsyntheticsubstitutes = "ct_default-127";
			$HORMONESAdrenalhormonesandsyntheticsubstitutes_serial = shn_cs_generate_subcat_item_serial($HORMONESOTHERENDOCRINEDRUGS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$HORMONESOTHERENDOCRINEDRUGS','$HORMONESAdrenalhormonesandsyntheticsubstitutes','Adrenal hormones and synthetic substitutes','Adrenal hormones and synthetic substitutes','medical drugs','$HORMONESAdrenalhormonesandsyntheticsubstitutes_serial')";
			$res=$db->Execute($q);
			// 18.2 Androgens- sub catalogue - level 2
			$HORMONESAndrogens = "ct_default-128";
			$HORMONESAndrogens_serial = shn_cs_generate_subcat_item_serial($HORMONESOTHERENDOCRINEDRUGS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$HORMONESOTHERENDOCRINEDRUGS','$HORMONESAndrogens','Androgens','Androgens','medical drugs','$HORMONESAndrogens_serial')";
			$res=$db->Execute($q);
			// 18.3.1 Hormonal contraceptives- sub catalogue - level 2
			$HORMONESHormonalcontraceptives = "ct_default-129";
			$HORMONESHormonalcontraceptives_serial = shn_cs_generate_subcat_item_serial($HORMONESOTHERENDOCRINEDRUGS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$HORMONESOTHERENDOCRINEDRUGS','$HORMONESHormonalcontraceptives','Hormonal contraceptives','Hormonal contraceptives','medical drugs','$HORMONESHormonalcontraceptives_serial')";
			$res=$db->Execute($q);
			// 18.3.2 Intrauterine devices- sub catalogue - level 2
			$HORMONESIntrauterinedevices = "ct_default-130";
			$HORMONESIntrauterinedevices_serial = shn_cs_generate_subcat_item_serial($HORMONESOTHERENDOCRINEDRUGS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$HORMONESOTHERENDOCRINEDRUGS','$HORMONESIntrauterinedevices',' Intrauterine devices',' Intrauterine devices','medical drugs','$HORMONESIntrauterinedevices_serial')";
			$res=$db->Execute($q);
			// 18.3.3 Barrier methods- sub catalogue - level 2
			$HORMONESBarriermethods = "ct_default-131";
			$HORMONESBarriermethods_serial = shn_cs_generate_subcat_item_serial($HORMONESOTHERENDOCRINEDRUGS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$HORMONESOTHERENDOCRINEDRUGS','$HORMONESBarriermethods','Barrier methods','Barrier methods','medical drugs','$HORMONESBarriermethods_serial')";
			$res=$db->Execute($q);
			// 18.4 Estrogens- sub catalogue - level 2
			$HORMONESEstrogens = "ct_default-132";
			$HORMONESEstrogens_serial = shn_cs_generate_subcat_item_serial($HORMONESOTHERENDOCRINEDRUGS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$HORMONESOTHERENDOCRINEDRUGS','$HORMONESEstrogens','Estrogens','Estrogens','medical drugs','$HORMONESEstrogens_serial')";
			$res=$db->Execute($q);
			// 18.5  Insulins and other antidiabetic agents- sub catalogue - level 2
			$HORMONESInsulinsandotherantidiabeticagents = "ct_default-133";
			$HORMONESInsulinsandotherantidiabeticagents_serial = shn_cs_generate_subcat_item_serial($HORMONESOTHERENDOCRINEDRUGS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$HORMONESOTHERENDOCRINEDRUGS','$HORMONESInsulinsandotherantidiabeticagents','Insulins and other antidiabetic agents',' Insulins and other antidiabetic agents','medical drugs','$HORMONESInsulinsandotherantidiabeticagents_serial')";
			$res=$db->Execute($q);
			// 18.6 Ovulation inducers- sub catalogue - level 2
			$HORMONESOvulationinducers = "ct_default-134";
			$HORMONESOvulationinducers_serial = shn_cs_generate_subcat_item_serial($HORMONESOTHERENDOCRINEDRUGS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$HORMONESOTHERENDOCRINEDRUGS','$HORMONESOvulationinducers','Ovulation inducers','Ovulation inducers','medical drugs','$HORMONESOvulationinducers_serial')";
			$res=$db->Execute($q);
			// 18.7 Progestogens- sub catalogue - level 2
			$HORMONESProgestogens = "ct_default-135";
			$HORMONESProgestogens_serial = shn_cs_generate_subcat_item_serial($HORMONESOTHERENDOCRINEDRUGS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$HORMONESOTHERENDOCRINEDRUGS','$HORMONESProgestogens','Progestogens','Progestogens','medical drugs','$HORMONESProgestogens_serial')";
			$res=$db->Execute($q);
			// 18.8  Thyroid hormones and antithyroid drugs- sub catalogue - level 2
			$HORMONESThyroidhormonesandantithyroiddrugs = "ct_default-136";
			$HORMONESThyroidhormonesandantithyroiddrugs_serial = shn_cs_generate_subcat_item_serial($HORMONESOTHERENDOCRINEDRUGS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$HORMONESOTHERENDOCRINEDRUGS','$HORMONESThyroidhormonesandantithyroiddrugs','Thyroid hormones and antithyroid drugs','Thyroid hormones and antithyroid drugs','medical drugs','$HORMONESThyroidhormonesandantithyroiddrugs_serial')";
			$res=$db->Execute($q);

		//19. IMMUNOLOGICALS  - sub catalogue - level 1
		$IMMUNOLOGICALS = "ct_default-137";
		$IMMUNOLOGICALS_serial = shn_cs_generate_subcat_item_serial($medicaldrug);
		$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$medicaldrug','$IMMUNOLOGICALS','IMMUNOLOGICALS','IMMUNOLOGICALS','medical drugs','$IMMUNOLOGICALS_serial')";
		$res=$db->Execute($q);
			// 19.1 Diagnostic agents- sub catalogue - level 2
			$IMMUNOLOGICALSDiagnosticagents = "ct_default-138";
			$IMMUNOLOGICALSDiagnosticagents_serial = shn_cs_generate_subcat_item_serial($IMMUNOLOGICALS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$IMMUNOLOGICALS','$IMMUNOLOGICALSDiagnosticagents','Diagnostic agents','Diagnostic agents','medical drugs','$IMMUNOLOGICALSDiagnosticagents_serial')";
			$res=$db->Execute($q);
			// 19.2 Sera and immunoglobulins- sub catalogue - level 2
			$IMMUNOLOGICALSSeraandimmunoglobulins = "ct_default-139";
			$IMMUNOLOGICALSSeraandimmunoglobulins_serial = shn_cs_generate_subcat_item_serial($IMMUNOLOGICALS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$IMMUNOLOGICALS','$IMMUNOLOGICALSSeraandimmunoglobulins','Sera and immunoglobulins','Sera and immunoglobulins','medical drugs','$IMMUNOLOGICALSSeraandimmunoglobulins_serial')";
			$res=$db->Execute($q);
			// 19.3.1  Vaccines for universal immunization- sub catalogue - level 2
			$IMMUNOLOGICALSVaccinesforuniversalimmunization = "ct_default-140";
			$IMMUNOLOGICALSVaccinesforuniversalimmunization_serial = shn_cs_generate_subcat_item_serial($IMMUNOLOGICALS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$IMMUNOLOGICALS','$IMMUNOLOGICALSVaccinesforuniversalimmunization','Vaccines for universal immunization','Vaccines for universal immunization','medical drugs','$IMMUNOLOGICALSVaccinesforuniversalimmunization_serial')";
			$res=$db->Execute($q);
			// 19.3.2 Vaccines for specific groups of individuals- sub catalogue - level 2
			$IMMUNOLOGICALSVaccinesforspecificgroupsofindividuals = "ct_default-141";
			$IMMUNOLOGICALSVaccinesforspecificgroupsofindividuals_serial = shn_cs_generate_subcat_item_serial($IMMUNOLOGICALS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$IMMUNOLOGICALS','$IMMUNOLOGICALSVaccinesforspecificgroupsofindividuals','Vaccines for specific groups of individuals','Vaccines for specific groups of individuals','medical drugs','$IMMUNOLOGICALSVaccinesforspecificgroupsofindividuals_serial')";
			$res=$db->Execute($q);

		//20. MUSCLE RELAXANTS (PERIPHERALLY ACTING) AND CHOLINESTERASE INHIBITORS  - sub catalogue - level 1
		$MUSCLERELAXANTS  = "ct_default-142";
		$MUSCLERELAXANTS_serial = shn_cs_generate_subcat_item_serial($medicaldrug);
		$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$medicaldrug','$MUSCLERELAXANTS','MUSCLE RELAXANTS PERIPHERALLY ACTING AND CHOLINESTERASE INHIBITORS','MUSCLE RELAXANTS PERIPHERALLY ACTING AND CHOLINESTERASE INHIBITORS','medical drugs','$MUSCLERELAXANTS_serial')";
		$res=$db->Execute($q);

		//21. OPHTHALMOLOGICAL PREPARATIONS  - sub catalogue - level 1
		$OPHTHALMOLOGICALPREPARATIONS = "ct_default-143";
		$OPHTHALMOLOGICALPREPARATIONS_serial = shn_cs_generate_subcat_item_serial($medicaldrug);
		$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$medicaldrug','$OPHTHALMOLOGICALPREPARATIONS','OPHTHALMOLOGICAL PREPARATIONS','OPHTHALMOLOGICAL PREPARATIONS','medical drugs','$OPHTHALMOLOGICALPREPARATIONS_serial')";
		$res=$db->Execute($q);
			// 21.1 Anti-infective agents- sub catalogue - level 2
			$OPHTHALMOLOGICALAntiinfectiveagents = "ct_default-144";
			$OPHTHALMOLOGICALAntiinfectiveagents_serial = shn_cs_generate_subcat_item_serial($OPHTHALMOLOGICALPREPARATIONS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$OPHTHALMOLOGICALPREPARATIONS','$OPHTHALMOLOGICALAntiinfectiveagents','Anti infective agents','Anti infective agents','medical drugs','$OPHTHALMOLOGICALAntiinfectiveagents_serial')";
			$res=$db->Execute($q);
			// 21.2 Anti-inflammatory agents- sub catalogue - level 2
			$OPHTHALMOLOGICALAntiinflammatoryagents = "ct_default-145";
			$OPHTHALMOLOGICALAntiinflammatoryagents_serial = shn_cs_generate_subcat_item_serial($OPHTHALMOLOGICALPREPARATIONS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$OPHTHALMOLOGICALPREPARATIONS','$OPHTHALMOLOGICALAntiinflammatoryagents','Anti inflammatory agents','Anti inflammatory agents','medical drugs','$OPHTHALMOLOGICALAntiinflammatoryagents_serial')";
			$res=$db->Execute($q);
			// 21.3 Local anaesthetics- sub catalogue - level 2
			$OPHTHALMOLOGICALLocalanaesthetics = "ct_default-146";
			$OPHTHALMOLOGICALLocalanaesthetics_serial = shn_cs_generate_subcat_item_serial($OPHTHALMOLOGICALPREPARATIONS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$OPHTHALMOLOGICALPREPARATIONS','$OPHTHALMOLOGICALLocalanaesthetics','Local anaesthetics','Local anaesthetics','medical drugs','$OPHTHALMOLOGICALLocalanaesthetics_serial')";
			$res=$db->Execute($q);
			// 21.4 Miotics and antiglaucoma drugs - sub catalogue - level 2
			$OPHTHALMOLOGICALMioticsandantiglaucomadrugs = "ct_default-147";
			$OPHTHALMOLOGICALMioticsandantiglaucomadrugs_serial = shn_cs_generate_subcat_item_serial($OPHTHALMOLOGICALPREPARATIONS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$OPHTHALMOLOGICALPREPARATIONS','$OPHTHALMOLOGICALMioticsandantiglaucomadrugs','Miotics and antiglaucoma drugs','Miotics and antiglaucoma drugs','medical drugs','$OPHTHALMOLOGICALMioticsandantiglaucomadrugs_serial')";
			$res=$db->Execute($q);
			// 21.5 Mydriatics - sub catalogue - level 2
			$OPHTHALMOLOGICALMydriatics = "ct_default-148";
			$OPHTHALMOLOGICALMydriatics_serial = shn_cs_generate_subcat_item_serial($OPHTHALMOLOGICALPREPARATIONS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$OPHTHALMOLOGICALPREPARATIONS','$OPHTHALMOLOGICALMydriatics','Mydriatics','Mydriatics','medical drugs','$OPHTHALMOLOGICALMydriatics_serial')";
			$res=$db->Execute($q);

		//22. OXYTOCICS AND ANTIOXYTOCICS  - sub catalogue - level 1
		$OXYTOCICSANDANTIOXYTOCICS = "ct_default-149";
		$OXYTOCICSANDANTIOXYTOCICS_serial = shn_cs_generate_subcat_item_serial($medicaldrug);
		$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$medicaldrug','$OXYTOCICSANDANTIOXYTOCICS','OXYTOCICS AND ANTIOXYTOCICS','OXYTOCICS AND ANTIOXYTOCICS','medical drugs','$OXYTOCICSANDANTIOXYTOCICS_serial')";
		$res=$db->Execute($q);
			// 22.1 Oxytocics - sub catalogue - level 2
			$OXYTOCICSOxytocics = "ct_default-150";
			$OXYTOCICSOxytocics_serial = shn_cs_generate_subcat_item_serial($OXYTOCICSANDANTIOXYTOCICS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$OXYTOCICSANDANTIOXYTOCICS','$OXYTOCICSOxytocics','Oxytocics','Oxytocics','medical drugs','$OXYTOCICSOxytocics_serial')";
			$res=$db->Execute($q);
			// 22.2 Antiocytocics - sub catalogue - level 2
			$OXYTOCICSAntiocytocics = "ct_default-151";
			$OXYTOCICSAntiocytocics_serial = shn_cs_generate_subcat_item_serial($OXYTOCICSANDANTIOXYTOCICS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$OXYTOCICSANDANTIOXYTOCICS','$OXYTOCICSAntiocytocics','Antiocytocics','Antiocytocics','medical drugs','$OXYTOCICSAntiocytocics_serial')";
			$res=$db->Execute($q);

		//23. PERITONEAL DIALYSIS SOLUTION  - sub catalogue - level 1
		$PERITONEALDIALYSISSOLUTION = "ct_default-152";
		$PERITONEALDIALYSISSOLUTION_serial = shn_cs_generate_subcat_item_serial($medicaldrug);
		$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$medicaldrug','$PERITONEALDIALYSISSOLUTION','PERITONEAL DIALYSIS SOLUTION','PERITONEAL DIALYSIS SOLUTION','medical drugs','$PERITONEALDIALYSISSOLUTION_serial')";
		$res=$db->Execute($q);

		//24. PSYCHOTHERAPEUTIC DRUGS  - sub catalogue - level 1
		$PSYCHOTHERAPEUTICDRUGS = "ct_default-153";
		$PSYCHOTHERAPEUTICDRUGS_serial = shn_cs_generate_subcat_item_serial($medicaldrug);
		$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$medicaldrug','$PSYCHOTHERAPEUTICDRUGS','PSYCHOTHERAPEUTIC DRUGS','PSYCHOTHERAPEUTIC DRUGS','medical drugs','$PSYCHOTHERAPEUTICDRUGS_serial')";
		$res=$db->Execute($q);

			// 24.1 Drugs used in psychotic disorders - sub catalogue - level 2
			$PSYCHODrugsusedinpsychoticdisorders = "ct_default-154";
			$PSYCHODrugsusedinpsychoticdisorders_serial = shn_cs_generate_subcat_item_serial($PSYCHOTHERAPEUTICDRUGS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$PSYCHOTHERAPEUTICDRUGS','$PSYCHODrugsusedinpsychoticdisorders','Drugs used in psychotic disorders','Drugs used in psychotic disorders','medical drugs','$PSYCHODrugsusedinpsychoticdisorders_serial')";
			$res=$db->Execute($q);

			// 24.2.1 Drugs used in depressive disorders - sub catalogue - level 2
			$PSYCHODrugsusedindepressivedisorders = "ct_default-155";
			$PSYCHODrugsusedindepressivedisorders_serial = shn_cs_generate_subcat_item_serial($PSYCHOTHERAPEUTICDRUGS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$PSYCHOTHERAPEUTICDRUGS','$PSYCHODrugsusedindepressivedisorders','Drugs used in depressive disorders','Drugs used in depressive disorders','medical drugs','$PSYCHODrugsusedindepressivedisorders_serial')";
			$res=$db->Execute($q);

			// 24.2.2 Drugs used in bipolar disorders - sub catalogue - level 2
			$PSYCHODrugsusedinbipolardisorders = "ct_default-156";
			$PSYCHODrugsusedinbipolardisorders_serial = shn_cs_generate_subcat_item_serial($PSYCHOTHERAPEUTICDRUGS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$PSYCHOTHERAPEUTICDRUGS','$PSYCHODrugsusedinbipolardisorders','Drugs used in bipolar disorders','Drugs used in bipolar disorders','medical drugs','$PSYCHODrugsusedinbipolardisorders_serial')";
			$res=$db->Execute($q);

			// 24.3 Drugs used in generalized anxiety and sleep disorders - sub catalogue - level 2
			$PSYCHODrugsusedingeneralizedanxietyandsleepdisorders = "ct_default-157";
			$PSYCHODrugsusedingeneralizedanxietyandsleepdisorders_serial = shn_cs_generate_subcat_item_serial($PSYCHOTHERAPEUTICDRUGS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$PSYCHOTHERAPEUTICDRUGS','$PSYCHODrugsusedingeneralizedanxietyandsleepdisorders','Drugs used in generalized anxiety and sleep disorders','Drugs used in generalized anxiety and sleep disorders','medical drugs','$PSYCHODrugsusedingeneralizedanxietyandsleepdisorders_serial')";
			$res=$db->Execute($q);
			// 24.4 Drugs used for obsessive compulsive disorders and panic attacks - sub catalogue - level 2
			$PSYCHODrugsusedforobsessivecompulsivedisordersandpanicattacks = "ct_default-158";
			$PSYCHODrugsusedforobsessivecompulsivedisordersandpanicattacks_serial = shn_cs_generate_subcat_item_serial($PSYCHOTHERAPEUTICDRUGS);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$PSYCHOTHERAPEUTICDRUGS','$PSYCHODrugsusedforobsessivecompulsivedisordersandpanicattacks','Drugs used for obsessive compulsive disorders and panic attacks','Drugs used for obsessive compulsive disorders and panic attacks','medical drugs','$PSYCHODrugsusedforobsessivecompulsivedisordersandpanicattacks_serial')";
			$res=$db->Execute($q);

		//25. DRUGS ACTING ON THE RESPIRATORY TRACT  - sub catalogue - level 1
		$DRUGSACTINGONTHERESPIRATORYTRACT = "ct_default-159";
		$DRUGSACTINGONTHERESPIRATORYTRACT_serial = shn_cs_generate_subcat_item_serial($medicaldrug);
		$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$medicaldrug','$DRUGSACTINGONTHERESPIRATORYTRACT','DRUGS ACTING ON THE RESPIRATORY TRACT','DRUGS ACTING ON THE RESPIRATORY TRACT','medical drugs','$DRUGSACTINGONTHERESPIRATORYTRACT_serial')";
		$res=$db->Execute($q);
			// 25.1 Antiasthmatic drugs - sub catalogue - level 2
			$RESPIRATORYAntiasthmaticdrugs = "ct_default-160";
			$RESPIRATORYAntiasthmaticdrugs_serial = shn_cs_generate_subcat_item_serial($DRUGSACTINGONTHERESPIRATORYTRACT);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$DRUGSACTINGONTHERESPIRATORYTRACT','$RESPIRATORYAntiasthmaticdrugs','Antiasthmatic drugs','Antiasthmatic drugs','medical drugs','$RESPIRATORYAntiasthmaticdrugs_serial')";
			// 25.2 Antitussives - sub catalogue - level 2
			$RESPIRATORYAntitussives = "ct_default-161";
			$RESPIRATORYAntitussives_serial = shn_cs_generate_subcat_item_serial($DRUGSACTINGONTHERESPIRATORYTRACT);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$DRUGSACTINGONTHERESPIRATORYTRACT','$RESPIRATORYAntitussives','Antitussives','Antitussives','medical drugs','$RESPIRATORYAntitussives_serial')";
			$res=$db->Execute($q);

		//26. SOLUTIONS CORRECTING WATER, ELECTROLYTE AND ACID-BASE DISTURBANCES  - sub catalogue - level 1
		$SOLUTIONSCORRECTINGWATERELECTROLYTE  = "ct_default-162";
		$SOLUTIONSCORRECTINGWATERELECTROLYTE_serial = shn_cs_generate_subcat_item_serial($medicaldrug);
		$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$medicaldrug','$SOLUTIONSCORRECTINGWATERELECTROLYTE','SOLUTIONS CORRECTING WATER ELECTROLYTE AND ACID-BASE DISTURBANCES','SOLUTIONS CORRECTING WATER ELECTROLYTE AND ACID BASE DISTURBANCES','medical drugs','$SOLUTIONSCORRECTINGWATERELECTROLYTE_serial')";
		$res=$db->Execute($q);
			// 26.1 Oral - sub catalogue - level 2
			$SOLUTIONSOral = "ct_default-163";
			$SOLUTIONSOral_serial = shn_cs_generate_subcat_item_serial($SOLUTIONSCORRECTINGWATERELECTROLYTE);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$SOLUTIONSCORRECTINGWATERELECTROLYTE','$SOLUTIONSOral','Oral','Oral','medical drugs','$SOLUTIONSOral_serial')";
			$res=$db->Execute($q);
			// 26.1 Parenteral - sub catalogue - level 2
			$SOLUTIONSOParenteral = "ct_default-164";
			$SOLUTIONSOParenteral_serial = shn_cs_generate_subcat_item_serial($SOLUTIONSCORRECTINGWATERELECTROLYTE);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$SOLUTIONSCORRECTINGWATERELECTROLYTE','$SOLUTIONSOParenteral','Parenteral','Parenteral','medical drugs','$SOLUTIONSOParenteral_serial')";
			$res=$db->Execute($q);
			// 26.1 Miscellaneous - sub catalogue - level 2
			$SOLUTIONSOMiscellaneous = "ct_default-165";
			$SOLUTIONSOMiscellaneous_serial = shn_cs_generate_subcat_item_serial($SOLUTIONSCORRECTINGWATERELECTROLYTE);
			$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$SOLUTIONSCORRECTINGWATERELECTROLYTE','$SOLUTIONSOMiscellaneous','Miscellaneous','Miscellaneous','medical drugs','$SOLUTIONSOMiscellaneous_serial')";
			$res=$db->Execute($q);

		//27. VITAMINS AND MINERALS  - sub catalogue - level 1
		$VITAMINSANDMINERALS  = "ct_default-166";
		$VITAMINSANDMINERALS_serial = shn_cs_generate_subcat_item_serial($medicaldrug);
		$q="insert into ct_catalogue (parentid,ct_uuid,name,description,keyword,serial) values('$medicaldrug','$VITAMINSANDMINERALS','VITAMINS AND MINERALS','VITAMINS AND MINERALS','medical drugs','$VITAMINSANDMINERALS_serial')";
		$res=$db->Execute($q);

}
?>
Return current item: Volunteer Management OpenSource Software