--
-- Host: localhost    Database: calvarymc_db
-- ------------------------------------------------------


--
-- Table structure for table `adminlogs`
--

CREATE TABLE `adminlogs` (
  `alog_id` int(11) NOT NULL AUTO_INCREMENT,
  `admin_id` int(11) NOT NULL,
  `log` varchar(100) DEFAULT NULL,
  `explanation` tinytext DEFAULT NULL,
  `link` varchar(56) DEFAULT NULL,
  `created` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`alog_id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `adminlogs`
--

INSERT INTO `adminlogs` VALUES (21,3,'New web content has been added','Sewalu Mukasa Steven added Our Services article','/content','2019-07-02 14:25:48'),(22,3,'New web content has been added','Sewalu Mukasa Steven added Medical Camps/ Our Reach Clinics article','/content','2019-07-02 14:28:02'),(23,3,'New web content has been added','Sewalu Mukasa Steven added Clean Water Services article','/content','2019-07-02 14:29:11'),(24,3,'New web content has been added','Sewalu Mukasa Steven added Core Values article','/content','2019-07-02 14:30:02'),(25,3,'New web content has been added','Sewalu Mukasa Steven added About Us article','/content','2019-07-02 14:30:31'),(26,3,'New web content has been added','Sewalu Mukasa Steven added Vision and Mission article','/content','2019-07-02 14:31:36'),(27,3,'New web content has been added','Sewalu Mukasa Steven added Background article','/content','2019-07-02 18:48:40'),(28,3,'Web content has been updated','Sewalu Mukasa Steven just updated Our Services article','/content','2019-07-02 22:01:34'),(29,3,'New web content has been added','Sewalu Mukasa Steven added Full Background article','/content','2019-07-02 22:25:28'),(30,3,'New web content has been added','Sewalu Mukasa Steven added Full About Us article','/content','2019-07-02 22:30:04'),(31,3,'Web content has been updated','Sewalu Mukasa Steven just updated Core Values article','/content','2019-07-02 22:47:10');

--
-- Table structure for table `blogs`
--

CREATE TABLE `blogs` (
  `blog_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(600) NOT NULL,
  `details` text NOT NULL,
  `tmp_name` varchar(500) NOT NULL,
  `author` varchar(56) NOT NULL,
  `created` timestamp NOT NULL DEFAULT current_timestamp(),
  `category` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`blog_id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `blogs`
--

INSERT INTO `blogs` VALUES (6,'Medical Camps/Outreach Clinics','<p>For almost 2 years Calvary Medical Clinic and Clavary Safaris has been organizing medical safaris. We organize these together with medical partners, and with the authorization and support of the government and major Ugandan medical Centers. The safaris are outreaches to some of the remote villages, refugee camps and areas where there is no medical care available. Our medical partners take care of the medical work and care giving, Calvary Medical Centre together with her sister agency Calvary Safaris helps to overcome the geographical boundaries by delivering the medical team to the remote village, were they setup mobile clinic camps offering services ranging from dental to health education to the locals and there after collecting them after all planned outreach activities are complete</p><p>During a normal medical safari/camp the team spend between 2 and 5 days in an area. In this time the medical team will see hundreds of patients, perform several smaller surgeries and often a few major surgeries. More than once lifesaving surgeries have taken place during these safaris and medical camps<br>This work would not have been possible without the help of those that fund these outreaches, our medical partners and many other volunteers. </p><p>A big thank you to all involved.</p><p>Calvary Medical Centre is has since evolved into a Center of Excellence for small communities and continues to contribute significantly towards improving their access to medical care. We continue to work with and support health facilities in targeted districts to improve availability of essential medicines, trained personnel and education.<br></p>','0b6e5a59c303d326539468522977d173.jpg','Sandra Awilo','2019-07-02 20:12:18','work'),(7,'Clean Water Services','<p>About 75% of all diseases in Uganda are a direct result of lack of clean water and proper sanitation. The most common water-borne diseases are diarrhea, dysentery, typhoid, Bilharzia and cholera.</p><p>While statistics and pictures can crystalize the dilemma and lack of clean water in Uganda, the real experience is un manageable for most of us. Can you imagine life without access to clean water watching your children succumb to Dysentry and other water borne diseases?</p><p>Water is essential for life, for health, for agriculture and therefore for empowerment and prosperity. In Uganda, lack of access to clean water subjects “especially” children to preventable deaths and or severe illness of different types. One of the major childhood killers in Uganda is Dysentry and study shows it claims at least 33 lives a day. </p><p>This early childhood diarrhea is not only deadly but also causes stunted growth hence affecting cognitive development and performance in education. On a daily basis in both rural and poor urban areas in Uganda, thousand of people suffer from lack of access to clean and safe water. Children in school going age, their mothers and fathers bear a burden of walking several miles most of the times to access water from Ponds, Polluted Rivers and Lakes that are filled with disease causing organisms that make them and their entire families sick.</p><p>The diseases resulting from lack of clean water and time wasted in search for dirty water steals from the community their futures and it costs us money as a medical centre to treat them during our Free Medical Camps. At times, its too late that we are un able to save lives!</p><p>To address this challenge, Calvary Medical Center started Clean Water Projects in vulnerable regions of Uganda to provide safe and cleanwater and therefore reduce morbidity.</p><p>We decided to help and we know you can Join Us.<br></p>','845cdc94edd113d600072b22d37c9f0a.jpg','Sandra Awilo','2019-07-02 20:16:12','work'),(8,'Our Water Project','<p>We build new wells, rehab neglected Water points, protect springs and install sand dams where appropriate. We empower our communities themselves to determine what makes sense for them with the help of experts.We\'ve learned over the past 2 years that each community we serve is different in terms of geology, climate and culture, many factors determine the most sustainable means to provide access to clean and safe water.Your gifts enable robust community mobilization, careful project construction and rigorous long-term follow up and evaluation. </p><h4>THE COST</h4><p>Our Commitment is to implementing the most appropriate, efficient and sustainable solutions available. Sometimes it involves catching rain, protecting a spring or repairing a neglected pump might be less expensive and just as valuable as digging a new well.<br>We ensure our teams are holistic in approach and accountable over time. Every gift is applied to a specific project that you\'ll see. If you\'re interested in sponsoring an entire project, we\'d love to chat.</p><h4>YOUR DONATIONS</h4><p>When you give, you\'ll get stories, GPS coordinates, photos and other information about who and how you’ve helped. You’ll know exactly how your giving makes a difference.</p><p>Communities are waiting for water. Our teams are ready to respond.&nbsp; </p><p>You make it possible.<br></p>','f4ec630c47e95d24998e27fe97a01246.jpg','Sandra Awilo','2019-07-02 20:25:20','projects'),(9,'Our Medical Camps','<p>NUMBER OF MEDICAL CAMPS HELD: N/A <br>Number of patients helped: N/A<br>Calvary Medical Center has been providing free medical care to impoverished communities in Uganda. <br>The first free medical clinic was held on N/A .</p><p>Calvary Medical Centre is determined to provide the best quality health care of services that can be attainable with the available resources to all people in communities in need.<br><br>We are proud to say that our Medical/Dental camps greatly contribute to the improving access to health care of the community especially those in need.<br></p>','f6f732081b0a909f72c26947febe6bfd.jpg','Sandra Awilo','2019-07-02 20:30:03','projects'),(10,'Why Water','<span>Every day in rural communities throughout Uganda, millions of people suffer from a lack of access to clean, safe water. For school-aged children it\'s a burden that traps them in poverty. According to WHO findings, it has been established that about 75% of all diseases in Uganda are a direct result of lack of clean water and proper sanitation. The most common water-borne diseases affecting the people in the areas we serve are diarrhea, dysentery, typhoid, Bilharzia and cholera.<br><br>While statistics and pictures can crystalize the dilemma and lack of clean water in Uganda, the real experience is a manageable for most of us. Can you imagine life without access to clean water watching your children succumb to Dysentery and other water borne diseases?<br>Water is essential for life, for health, for agriculture and therefore for empowerment and prosperity. In Uganda, lack of access to clean water subjects “especially” children to preventable deaths and or severe illness of different types. One of the major childhood killers in Uganda is Dysentery and study shows it claims at least 33 lives a day. This early childhood diarrhea is not only deadly but also causes stunted growth hence affecting cognitive development and performance in education.<br><br>1 in 9 people still have no access to clean water. But in the communities we serve, it\'s 9 out of 9. Water is a daily and crippling challenge. Without water you can\'t grow food, you can\'t build housing, you can\'t stay healthy, you can\'t stay in school and you can\'t keep working.<br>Today, hope is on hold in over half of the developing world\'s primary schools without access to water and sanitation.</span><span>On a daily basis in both rural and poor urban areas in Uganda, thousands of people suffer from lack of access to clean and safe water.<br>&nbsp;<br>Children in school going age, their mothers and fathers bear a burden of walking several miles most of the times to access water from Ponds, Polluted Rivers and Lakes that are filled with disease causing organisms that make them and their entire families sick.<br>&nbsp;<br>The diseases resulting from lack of clean water and time wasted in search for dirty water steals from the community their futures and it costs us money as a medical Centre to treat them during our Free Medical Camps. At times, its too late that we are unable to save lives!<br><br>But the water crisis can be solved. As part of our outreach projects to address this challenge, Calvary Medical Center started Clean Water Projects in vulnerable regions of Uganda to provide safe and clean water and therefore reduce morbidity.<br>&nbsp;<br>We decided to help and we know you can Join Us.<br></span>','202ea935b211ed9d29c8051b18cdfc73.jpg','Sandra Awilli','2019-07-03 07:36:21','blogs');

--
-- Table structure for table `contacts`
--

CREATE TABLE `contacts` (
  `contact_id` int(11) NOT NULL AUTO_INCREMENT,
  `category` varchar(45) DEFAULT NULL,
  `contact` varchar(445) DEFAULT NULL,
  PRIMARY KEY (`contact_id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `contacts`
--

INSERT INTO `contacts` VALUES (10,'facebook','https://www.facebook.com/CalvaryMedical'),(11,'email','info@calvarymc.com'),(12,'phone','0754 564 854'),(13,'Address','Kavule, off semuto road');

--
-- Table structure for table `content`
--

CREATE TABLE `content` (
  `content_id` int(11) NOT NULL AUTO_INCREMENT,
  `admin_id` int(11) DEFAULT NULL,
  `ctype_id` int(11) DEFAULT NULL,
  `title` varchar(45) DEFAULT NULL,
  `details` text DEFAULT NULL,
  `created` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`content_id`),
  KEY `fk_content_administrators_idx` (`admin_id`),
  KEY `fk_content_content_type1_idx` (`ctype_id`),
  CONSTRAINT `fk_content_administrators` FOREIGN KEY (`admin_id`) REFERENCES `administrators` (`admin_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_content_content_type1` FOREIGN KEY (`ctype_id`) REFERENCES `content_type` (`ctype_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `content`
--

INSERT INTO `content` VALUES (14,3,5,'Our Services','<p>We are a multi-disciplinary non-profit outreach Hospital  that offers the following</p>\r\n<ul>\r\n<li>Dental services</li>\r\n<li>pediatrics</li>\r\n<li>Free Medical Camp Organization/Safari medical services/Mobile Outreach Clinics</li>\r\n<li>Minor Medical Services</li>\r\n<li>Sexual Reproductive Health services</li>\r\n<li>Laboratory Services</li>\r\n<li>Specialist Medical Services (Theatre &amp; Surgeries,&nbsp;Antenatal, post natal services,Admission/in-patient facilities)</li>\r\n<li>On-site and Remote Site Medical Services</li>\r\n<li>HIV testing and counselling</li>\r\n<li>Travel Medicine &amp; Vaccination Services</li>\r\n<li>Clean water community services</li>\r\n</ul>\r\n<p>Visit us today: we are located in Kavule, off semuto road about 35km away from Kampala.</p>','2019-07-02 14:25:48',NULL),(15,3,6,'Medical Camps/ Our Reach Clinics','<p>For almost 2 years Calvary Medical Clinic and Calvary Safaris has been \r\norganizing medical safaris. We organize these together with medical \r\npartners, and with the authorization and support of the government and \r\nmajor Ugandan medical Centers. The safaris are outreaches to some of the\r\n remote villages, refugee camps, and areas where there is no medical \r\ncare available. Our medical partners take care of the medical work and \r\ncaregiving, Calvary Medical Centre together with her sister agency \r\nCalvary Safaris helps to overcome the geographical boundaries by \r\ndelivering the medical team to the remote village, were they set up \r\nmobile clinic camps offering services ranging from dental to health \r\neducation to the locals and thereafter collecting them after all planned\r\n outreach activities are complete</p><p>During a normal medical safari/camp the team\r\nspend between 2 and 5 days in an area. In this time the medical team will see\r\nhundreds of patients, perform several smaller surgeries and often a few major\r\nsurgeries. More than once lifesaving surgeries have taken place during these\r\nsafaris and medical camps</p><p>This work would not have been possible\r\nwithout the help of those that fund these outreaches, our medical partners and\r\nmany other volunteers. </p><p>\r\n\r\n\r\n\r\nA big thank you to all involved.</p><p>Calvary Medical Centre is has since evolved into a Center of\r\nExcellence for small communities and continues to contribute significantly\r\ntowards improving their access to medical care. We continue to work with and\r\nsupport health facilities in targeted districts to improve availability of\r\nessential medicines, trained personnel and education.</p><p><br></p>','2019-07-02 14:28:02',NULL),(16,3,6,'Clean Water Services','<p>inding\r\nclean water is a daily challenge for young girls, moms and sons – at Calvary\r\nMedical Centre we understand that providing a reliable\r\nand safe water source will unlock potential by returning time for study, work,\r\nand imagination for the less fortunate in the communities we serve. \r\n\r\n\r\n\r\n</p><p>Restore hope that ripples out for years to come.</p><p>Your giving provides access to safe\r\nand reliable water projects across Uganda.</p><p>Our teams build water wells, sand\r\ndams, spring protections, and other water solutions. Then, we make sure they\r\nkeep working through regular follow-up and maintenance.</p>','2019-07-02 14:29:11',NULL),(17,3,4,'Core Values','<p>We are a growing Non-Profit medical organization that identifies with these values:</p>\r\n<ul>\r\n<li>Integrity: We do the right thing focusing on stewardship, professionalism, honesty,\r\nfairness, Respect for the Vulnerable and accountability.</li>\r\n<li>Customer Centricity: We put our target community at the center of what we do.</li>\r\n<li>Innovation: We are a flexible entity that thinks ahead and adapts to change.</li>\r\n<li>People Development: Our environment is setup to nurture people who wish to work with\r\nus towards their full potential.</li>\r\n<li>Open Communication: We listen and provide appropriate information to our\r\nstakeholders.</li>\r\n</ul>','2019-07-02 14:30:02',NULL),(18,3,4,'About Us','<p><br></p><div class=\"entry-content\">\r\n		\r\n<p>Calvary medical Centre is a nonprofit\r\nmedical Centre located in Kavule, off semuto road about 35km away from Kampala\r\noffering free and affordable medical services to the vulnerable groups in the areas\r\nof Kavule, throughout East Africa esp. in villages, refugee camps, slums and\r\nsimilar areas. We organize medical camps providing free medical services such\r\nas dental checks and treatments, minor surgeries, antenatal checks, HIV\r\ntesting, circumcision etc.</p>\r\n\r\n\r\n\r\n<p>Our Medical Safaris are part of the centers’ ongoing\r\nefforts to improve access to health care in the rural areas of Uganda. &nbsp;This\r\nis an attempt to address the detrimental health challenge that the people of\r\nKavule face due to inaccessibility of quality Medical services.</p>\r\n\r\n\r\n\r\n<p>Communities like Kavule and rural-urban\r\nslams remain wanting in terms of access to Hospitals and\r\nmedical services and as the locals are forced to travel for at least 2 hours in\r\nsearch for medical/surgical help, causing arise in the number of preventable\r\ndeaths in similar areas.</p>\r\n\r\n\r\n\r\n<p>Calvary Medical Center (CMC) was founded in October 2016\r\nand has been established as a 24-hour medical facility with the best amenities\r\nin Kavule offering a wide range of services including dental care, Maternity\r\nservices, sonography, immunization, lab and Minor surgeries.</p>\r\n\r\n\r\n\r\n<p>In the rural-urban areas like Kavure and the equivalent the\r\nsituation is even more challenging. In many places the health Centers are\r\nunstaffed by medical practitioners, due to the poverty and geographical\r\ninaccessibility of these areas. In some remote places there isn’t even a health\r\nCentre and in these areas the villagers have to travel for days to be able to\r\nget a consultation. In these areas many people die from diseases and incidents\r\nthat could have been treated if medical care was available.</p>\r\n\r\n\r\n\r\n<p>We pride ourselves serving and showing compassion towards\r\nthe less fortunate by providing affordable and/or Free Medical care to the\r\nvulnerable groups with high regards to giving them access to medical attention\r\nthrough our Safari community medical camp initiatives.</p>\r\n\r\n\r\n\r\n<p>Regular patients may pay a small fee to facilitate the\r\nfacility’s sustainability and vulnerable groups get free Medical care through\r\nFree Medical Camps that are often times donor funded.</p>\r\n			</div><p>\r\n	<footer class=\"page-entry-footer\">\r\n			</footer><br></p>','2019-07-02 14:30:31',NULL),(19,3,4,'Vision and Mission','<p><strong>VISION<br></strong>See struggling communities transformed through compassion and\r\naccess to Free and/or affordable healthcare for Sustainable health.</p><div class=\"entry-content\"><strong>MISSION</strong>\r\n\r\n\r\n\r\n<p>We are Empowering communities for health and sustainable\r\nlivelihoods by providing quality healthcare, developing human resources for\r\nhealth through our partnerships.</p><p><strong>AND<br></strong>We are also creating a difference in access to Health care\r\nservices to vulnerable groups and communities by offering Patient Centered,\r\nholistic and compassionate health services</p></div>','2019-07-02 14:31:36',NULL),(20,3,4,'Background','<p>As part of its ongoing efforts to improve access to health care in rural areas of Uganda, Calvary Medical Centre was established. This was an attempt to address the detrimental health challenge that the people of Kavule face due to lack of quality Medical services.</p>\r\n                    <p>The lack of a Hospital in Kavule causes people to travel for at least 2 hours in search for medical/surgical help. As a result, the millions of People that the hospital serves even from other soundings areas are not receiving proper treatment ; if any hence causing preventable deaths.</p>\r\n                    <p>Calvary Medical Center (CMC) 24-hour facility opened up in October 2016 with the best amenities in Kavule offering a wide range of services including dental services, Maternity services, sonography, immunization, laboratory, and Minor surgeries</p>\r\n                    <p>CMC provides affordable Medical care and or Free Medical care to the vulnerable groups with high regards in quality of service and compassion</p>','2019-07-02 18:48:40',NULL),(21,3,4,'Full Background','<p>As part of its ongoing efforts to improve access to health care in rural areas of Uganda, Calvary Medical Centre was established. This was an attempt to address the detrimental health challenge that the people of Kavule face due to lack of quality Medical services.<br>The lack of a Hospital in Kavule causes people to travel for at least 2 hours in search for medical/surgical help. As a result, the millions of People that the hospital serves even from other soundings areas are not receiving proper treatment ; if any hence causing preventable deaths.</p><p>Calvary Medical Center (CMC) 24-hour facility opened up in October 2016 with the best amenities in Kavule offering a wide range of services including dental services, Maternity services, sonography, immunization, laboratory, and Minor surgeries. &nbsp;<br>CMC provides affordable Medical care and or Free Medical care to the vulnerable groups with high regards in quality of service and compassion. </p><p>Regular patients pay a small fee to facilitate self sustainability and vulnerable groups get free Medical care through Free Medical Camps that are often times donor funded.</p><p>CMC Vision is to create a difference in Health care of Kavule and Uganda at large by offering Patient Centered, holistic and compassionateate health services to this community and others though mobile Medical Camps. <br><br><br></p>','2019-07-02 22:25:28',NULL),(22,3,4,'Full About Us','<p>Clavary medical Centre is a nonprofit medical Centre located in Kavule, off semuto road about 35km away from Kampala offering free and affordable medical services to the vulnerable groups in the areas of Kavule, throughout East Africa esp. in villages, refugee camps, slums and similar areas. We organize medical camps providing free medical services such as dental checks and treatments, minor surgeries, antenatal checks, HIV testing, circumcision etc.</p><p>Our Medical Safaris are part of the centers’ ongoing efforts to improve access to health care in the rural areas of Uganda.&nbsp; This is an attempt to address the detrimental health challenge that the people of Kavule face due to inaccessibility of quality Medical services.<br>Communities like Kavule and rural-urban slams remain wanting in terms of access to Hospitals and medical services and as the locals are forced to travel for at least 2 hours in search for medical/surgical help, causing arise in the number of preventable deaths in similar areas.</p><p>Calvary Medical Center (CMC) was founded in October 2016 and has been established as a 24-hour medical facility with the best amenities in Kavule offering a wide range of services including dental care, Maternity services, sonography, immunization, lab and Minor surgeries.<br></p><blockquote>In the rural-urban areas like Kavure and the equivalent the situation is even more challenging. In many places the health Centers are unstaffed by medical practitioners, due to the poverty and geographical inaccessibility of these areas. In some remote places there isn’t even a health Centre and in these areas the villagers have to travel for days to be able to get a consultation. In these areas many people die from diseases and incidents that could have been treated if medical care was available.<br></blockquote><p><br></p><p>We pride ourselves serving and showing compassion towards the less fortunate by providing affordable and/or Free Medical care to the vulnerable groups with high regards to giving them access to medical attention through our Safari community medical camp initiatives.<br>Regular patients may pay a small fee to facilitate the facility’s sustainability and vulnerable groups get free Medical care through Free Medical Camps that are often times donor funded.<br></p>','2019-07-02 22:30:04',NULL);

--
-- Table structure for table `content_type`
--

CREATE TABLE `content_type` (
  `ctype_id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`ctype_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `content_type`
--

INSERT INTO `content_type` VALUES (4,'Home Content'),(5,'Services Content'),(6,'Our Work');

--
-- Table structure for table `cpartners`
--

CREATE TABLE `cpartners` (
  `cpartner_id` int(11) NOT NULL AUTO_INCREMENT,
  `partner` tinytext DEFAULT NULL,
  `explanation` text DEFAULT NULL,
  `created` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`cpartner_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cpartners`
--


--
-- Table structure for table `events`
--

CREATE TABLE `events` (
  `event_id` int(11) NOT NULL AUTO_INCREMENT,
  `admin_id` int(11) DEFAULT NULL,
  `name` tinytext NOT NULL,
  `start` datetime NOT NULL,
  `end` datetime NOT NULL,
  `location` tinytext DEFAULT NULL,
  `description` text DEFAULT NULL,
  `tmp_name` varchar(500) DEFAULT NULL,
  `isactive` tinyint(4) NOT NULL DEFAULT 1,
  `slug` varchar(600) DEFAULT NULL,
  `created` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`event_id`),
  KEY `events_administrators_admin_id_fk` (`admin_id`),
  CONSTRAINT `events_administrators_admin_id_fk` FOREIGN KEY (`admin_id`) REFERENCES `administrators` (`admin_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `events`
--


--
-- Table structure for table `partners`
--

CREATE TABLE `partners` (
  `partner_id` int(11) NOT NULL AUTO_INCREMENT,
  `partner` tinytext NOT NULL,
  `url` text DEFAULT NULL,
  `tmp_name` tinytext DEFAULT NULL,
  `created` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`partner_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `partners`
--


--
-- Table structure for table `services`
--

CREATE TABLE `services` (
  `service_id` int(11) NOT NULL AUTO_INCREMENT,
  `service` tinytext DEFAULT NULL,
  `description` mediumtext DEFAULT NULL,
  `tmp_name` varchar(245) DEFAULT NULL,
  `created` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`service_id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `services`
--

INSERT INTO `services` VALUES (6,'Dental Services','<p>Calling nothing end fertile for \r\nventure way boy. Esteem spirit temper too say adieus who direct esteem. \r\nIt esteems luckily mr or picture placing drawing no. Apartments \r\nfrequently or motionless on reasonable projecting expression. Way mrs \r\nend gave tall walk fact bed.</p><p>Placing assured be if removed it besides on. Far shed each high read are men over day.</p>','ce7352399f41e0cf5132eb51c90ef8b6.jpg','2019-07-03 07:06:52'),(7,'Laboratory Services','<p>Calling nothing end fertile for \r\nventure way boy. Esteem spirit temper too say adieus who direct esteem. \r\nIt esteems luckily mr or picture placing drawing no. Apartments \r\nfrequently or motionless on reasonable projecting expression. Way mrs \r\nend gave tall walk fact bed.</p><p>Placing assured be if removed it besides on. Far shed each high read are men over day.\r\n                                    </p><p><br></p>','b6ac0adca52aad6d525905b2dbe7cae9.jpg','2019-07-03 07:08:01'),(8,'HIV Testing & Counselling','<p>Calling nothing end fertile for \r\nventure way boy. Esteem spirit temper too say adieus who direct esteem. \r\nIt esteems luckily mr or picture placing drawing no. Apartments \r\nfrequently or motionless on reasonable projecting expression. Way mrs \r\nend gave tall walk fact bed.</p><p>Placing assured be if removed it besides on. Far shed each high read are men over day.\r\n                                    </p><p><br></p>','73fd2fa4b78ea45f9e38919d1288bf98.jpg','2019-07-03 07:08:38'),(9,'Special Medical Services','<p>Calling nothing end fertile for \r\nventure way boy. Esteem spirit temper too say adieus who direct esteem. \r\nIt esteems luckily mr or picture placing drawing no. Apartments \r\nfrequently or motionless on reasonable projecting expression. Way mrs \r\nend gave tall walk fact bed.</p><p>Placing assured be if removed it besides on. Far shed each high read are men over day.\r\n                                    </p><p><br></p>','fef410abd07e3ba6794ae19eef5744e2.jpg','2019-07-03 07:09:08'),(10,'Sexual Reproductive Services','<p>Calling nothing end fertile for \r\nventure way boy. Esteem spirit temper too say adieus who direct esteem. \r\nIt esteems luckily mr or picture placing drawing no. Apartments \r\nfrequently or motionless on reasonable projecting expression. Way mrs \r\nend gave tall walk fact bed.</p><p>Placing assured be if removed it besides on. Far shed each high read are men over day.\r\n                                    </p>','574c536fcf81204ea02f6e335aafa61f.jpg','2019-07-03 07:10:05');

--
-- Table structure for table `slides`
--

CREATE TABLE `slides` (
  `slide_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(500) DEFAULT NULL,
  `caption` tinytext DEFAULT NULL,
  `link_text` varchar(45) DEFAULT NULL,
  `tmp_name` tinytext DEFAULT NULL,
  `url` varchar(345) DEFAULT NULL,
  `created` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`slide_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `slides`
--

INSERT INTO `slides` VALUES (5,'<span>Community Centered Approach</span> to care','We offer a comprehensive Dental and HIV package of prevention, care and treatment services free to people in need','View details','993637422a624e8fff45d4653372a933.jpg','http://calvarymc.com','2019-07-02 14:13:08','2019-07-02 18:16:27'),(6,'A Center of <span>excellence</span> for small communities','We continue to work with and support health facilities in targeted districts to improve availability of essential medicines, trained personnel and education.','View details','57a2ed4f0599a5859d1683bc73296c2f.jpg','http://calvarymc.com','2019-07-02 14:15:31','2019-07-02 18:16:01'),(7,'Improving <span>access</span> to medical care','We are Empowering communities for health and sustainable livelihoods by providing quality healthcare, developing human resources for health through our partnerships.','View details','62701dc49318f5a0c44d46e95d30e7d3.jpg','http://calvarymc.com','2019-07-02 14:17:27','2019-07-02 18:16:48');

--
-- Table structure for table `tags`
--

CREATE TABLE `tags` (
  `tag_id` int(11) NOT NULL AUTO_INCREMENT,
  `blog_id` int(11) NOT NULL,
  `tag` text NOT NULL,
  PRIMARY KEY (`tag_id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tags`
--

INSERT INTO `tags` VALUES (19,6,'clinics'),(20,6,'camps'),(21,6,'outreach'),(22,7,'water'),(23,7,'clean'),(24,8,'funding'),(25,8,'water project'),(26,9,'camps'),(27,9,'medical'),(28,10,'water'),(29,10,'blog');


