 --
 
 INSERT INTO `institutions` (`id`, `institution_type`, `name`, `description`, `logo_id`, `contact_email`, `contact_number`, `websites`, `address1`, `city_id`, `country_id`, `zip_code`, `state`, `coordinates`, `date_modified`, `date_created`, `slug`, `signup_step_status`, `status`) VALUES
-(1, 1, 'Ahalia Eye Hospital', 'Ahalia Foundation Eye Hospital, a unit of Ahalia International Foundation which started in 2005 stands tall on a rock solid reputation of reliability, affordability, quality and innovation. Now it has added one more feather to its cap-accreditation by the prestigious Joint Commission International, USA. JCI accreditation is the ultimate recognition in the field of health care and is awarded after a strenuous quality audit conducted by a team of international healthcare experts. \r\n\r\nWith this recognition, Ahalia is proud to herald the arrival of international standard health care to Kerala with special focus on quality improvement, patient safety and infection control. \r\n\r\nEquipped with six operation theaters and state of the art equipments, AFEH has the expertise in all the areas of ophthalmology including advanced Phaco surgery for cataract, latest Lasik treatment for refractive errors and specialty services for Retina, Glaucoma, Pediatric Ophthalmology, Low Vision Aids etc - all this at very affordable rates.', NULL, 'mail@afeh.org', '{"country_code":"91","area_code":"4923","number":"225 000"}', '{"main":"http:\/\/www.ahaliafoundationeyehospital.org","facebook":"https:\/\/www.facebook.com\/pages\/Ahalia-foundation-eye-hospitals\/387889344602118","twitter":"http:\/\/"}', '{"room_number":"","building":"","street":"Kanal Pirivu"}', 107931, 6, '678001', 'Kerala', '', '2013-01-16 05:08:04', '2012-12-06 06:29:26', 'ahalia-eye-hospital', 0, 9),
+(1, 1, 'Ahalia Eye Hospital', 'Ahalia Foundation Eye Hospital, a unit of Ahalia International Foundation which started in 2005 stands tall on a rock solid reputation of reliability, affordability, quality and innovation. Now it has added one more feather to its cap-accreditation by the prestigious Joint Commission International, USA. JCI accreditation is the ultimate recognition in the field of health care and is awarded after a strenuous quality audit conducted by a team of international healthcare experts. \r\n\r\nWith this recognition, Ahalia is proud to herald the arrival of international standard health care to Kerala with special focus on quality improvement, patient safety and infection control. \r\n\r\nEquipped with six operation theaters and state of the art equipments, AFEH has the expertise in all the areas of ophthalmology including advanced Phaco surgery for cataract, latest Lasik treatment for refractive errors and specialty services for Retina, Glaucoma, Pediatric Ophthalmology, Low Vision Aids etc - all this at very affordable rates.', NULL, 'mail@afeh.org', '{"country_code":"91","area_code":"4923","number":"225 000"}', '{"main":"http:\/\/www.ahaliafoundationeyehospital.org","facebook":"https:\/\/www.facebook.com\/pages\/Ahalia-foundation-eye-hospitals\/387889344602118","twitter":"http:\/\/"}', '{"room_number":"","building":"","street":"Kanal Pirivu"}', 1, 6, '1', 'Kerala', '', '2013-01-16 05:08:04', '2012-12-06 06:29:26', 'ahalia-eye-hospital', 0, 9),
 (2, 1, 'Apollo Gleneagles Hospital, Kolkata', 'Apollo Gleneagles Hospitals Kolkata, a 510-bedded multispecialty tertiary care hospital, is a perfect blend of technological excellence, complete infrastructure, competent care and heartfelt hospitality.\r\n\r\nApollo Gleneagles Hospitals is a joint venture of Apollo Group of Hospitals, India and Parkway Health of Singapore.\r\n\r\nThe Parkway Group is a leading healthcare group in Asia. It provides more than 70% of private healthcare in Singapore. Its subsidiaries include Parkway Group Healthcare, which owns a network of regional hospitals and medical centers in Malaysia, India and Brunei; and Parkway Hospitals Singapore, which owns three hospitals in Singapore - East Shore, Gleneagles, Mount Elizabeth Hospitals and Parkway Health Day surgery Centre.', NULL, 'hospital@apollogleneagles.in', '{"country_code":"91","area_code":" 3323","number":" 203 040"}', '{"main":"http:\\/\\/kolkata.apollohospitals.com\\/","facebook":"","twitter":""}', '{"room_number":"","building":"Apollo Gleneagles Hospital","street":"No. 58, Canal Circular Road"}', 40810, 6, '700054', 'West Bengal', '', '2013-01-16 05:08:04', '2012-12-06 06:49:56', 'apollo-gleneagles-hospital-kolkata', 0, 8),
 (3, 1, 'Apollo Hospital, Bangalore', 'Apollo Hospitals, Bangalore  a world class JCI accredited super speciality hospital, a six-storied facility situated on Bannerghatta road is equipped with the latest in the medical world. \r\n\r\nApollo Hospitals, Bangalore is a tertiary care flagship unit of the Apollo Hospitals Group. The Hospital focuses on centers of excellence like Cardiac Sciences, Neuro Sciences, Orthopaedics, Cancer, Emergency Medicine and Solid Organ Transplants besides the complete range of more than 35 allied medical disciplines under the same roof.', NULL, 'customercare_bangalore@apollohospitals.com', '{"country_code":"91","area_code":"8026","number":"304 050"}', '{"main":"http:\\/\\/www.apollohospitalsbangalore.com\\/","facebook":"","twitter":""}', '{"room_number":"","building":"Apollo Hospitals - Bangalore","street":"154\\/11, Opp. IIM B, Bannerghatta Road"}', 7454, 6, '560076', 'Karnataka', '', '2013-01-16 05:08:04', '2012-12-06 07:01:40', 'apollo-hospital-bangalore', 0, 8),
 (4, 1, 'Apollo Hospital, Chennai', 'The flagship hospital of the Apollo Group, Apollo Hospitals Chennai, was established in 1983. Today it is one of the most respected hospitals in the world, and is also amongst the most preferred destinations for both patients from several parts of India, as well as for medical tourism and medical value travel. The hospital specializes in cutting-edge medical procedures. It has over 60 departments spearheaded by internationally trained doctors who are skillfully supported by dedicated patient-care personnel. It is one of the few hospitals in Chennai that have state of the art facilities for various health disorders.\r\n\r\nIt has been a pioneer among the hospitals in Chennai, and even in India, in many different treatments and procedures.', NULL, 'enquiry@apollohospitals.com', '{"country_code":"","area_code":"","number":""}', '{"main":"","facebook":"","twitter":""}', '{"room_number":"","building":"","street":"Apollo Hospitals - Chennai No. 21, Greams Lane, Off. Greams Road, Chennai 600006 India"}', 22151, 6, '600006', 'Tammil Nadu', '', '2013-01-16 05:08:04', '2012-12-06 07:46:49', 'apollo-hospital-chennai', 0, 8),

  KEY `country_id` (`country_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--

  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1;

--
-- Dumping data for table `countries`
--

INSERT INTO `fixtures_healthcareabroad`.`countries` (`id`, `name`, `abbr`, `code`, `slug`, `status`) VALUES ('1', 'test', 'test', 'test', 'test', '1');

-- --------------------------------------------------------

