-- https://www.phpmyadmin.net/
--

START TRANSACTION;



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

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

CREATE TABLE IF NOT EXISTS `blogs` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `blog_title` longtext NOT NULL,
  `blog_category_id` varchar(5) NOT NULL,
  `image_url` varchar(500) NOT NULL,
  `short_desc` longtext NOT NULL,
  `blog_body` longtext NOT NULL,
  `tags` varchar(1000) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `added_on` varchar(25) NOT NULL,
  `updated_on` varchar(25) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

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

INSERT INTO `blogs` (`id`, `blog_title`, `blog_category_id`, `image_url`, `short_desc`, `blog_body`, `tags`, `status`, `added_on`, `updated_on`) VALUES
(1, 'VGhpcyBvbmVzIGlzIHJlYWwgb25lLg==', '6', '1625570561_blog.jpeg', 'ICAgRXZlcnl0aGluZyBpcyBmaW5lIGhlcmUuLi4uICAg', 'PHA+bnRlciB0b29rIGEgZ2FsbGV5IG9mIHR5cGUgYW5kIHNjcmFtYmxlZCBpdCB0byBtYWtlIGEgdHlwZSBzcGVjaW1lbiBib29rLiBJdCBoYXMgc3Vydml2ZWQgbm90IG9ubHkgZml2ZSBjZW50dXJpZXMsIGJ1dCBhbHNvIHRoZSBsZWFwIGludG8gZWxlY3Ryb25pYyB0eXBlc2V0dGluZywgcmVtYWluaW5nIGVzc2VudGlhbGx5IHVuY2hhbmdlZC4gSXQgd2FzIHBvcHVsYXJpc2VkIGluIHRoZSAxOTYwcyB3aXRoIHRoZSByZWxlYXNlIG9mIExldHJhc2V0IHNoZWV0cyBjb250YWluaW5nIExvcmVtIElwc3VtIHBhc3NhZ2VzLCBhbmQgbW9yZSByZWNlbnRseSB3aXRoIGRlc2t0b3AgcHVibGlzaGluZyBzb2Z0d2FyZSBsaWtlIEFsZHVzIFBhZ2VNYWtlciBpbmNsdWRpbmcgdmVyc2lvbnMgb2YgTG9yZW0gSXBzdW0uPC9wPg==', 'new, Test', 1, '06/07/21 04:08:40 pm', '06/07/21 06:21:29 pm');

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

--
-- Table structure for table `blog_category`
--

CREATE TABLE IF NOT EXISTS `blog_category` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `category_name` varchar(400) NOT NULL,
  `added_on` varchar(25) NOT NULL,
  `updated_on` varchar(25) NOT NULL,
  `status` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `blog_category`
--

INSERT INTO `blog_category` (`id`, `category_name`, `added_on`, `updated_on`, `status`) VALUES
(6, 'Child Labour', '06/07/21 03:13:27 PM', '06/07/21 03:13:54 PM', 0),
(5, 'Women Empowerment', '06/07/21 03:12:49 PM', '06/07/21 03:13:59 PM', 1);

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

--
-- Table structure for table `donation`
--

CREATE TABLE IF NOT EXISTS `donation` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `mobile` varchar(10) NOT NULL,
  `email` varchar(200) NOT NULL,
  `comment` varchar(200) NOT NULL,
  `payment_amount` varchar(200) NOT NULL,
  `payment_for` varchar(300) NOT NULL,
  `order_id` varchar(300) NOT NULL,
  `payment_id` varchar(300) NOT NULL,
  `signature` varchar(300) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `paid_on` varchar(25) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `enquiry`
--

CREATE TABLE IF NOT EXISTS `enquiry` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `name` varchar(250) NOT NULL,
  `email` varchar(250) NOT NULL,
  `subject` varchar(250) NOT NULL,
  `mobile` varchar(10) NOT NULL,
  `location` varchar(200) NOT NULL,
  `message` varchar(250) NOT NULL,
  `added_on` varchar(25) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `enquiry`
--

INSERT INTO `enquiry` (`id`, `name`, `email`, `subject`, `mobile`, `location`, `message`, `added_on`) VALUES
(1, 'dhdbh', 'jnjnjN@JNj.com', 'subject', '15151515', 'jnrjnjrnj', 'fnjnrfj', '626/');

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

--
-- Table structure for table `gallery_images`
--

CREATE TABLE IF NOT EXISTS `gallery_images` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `image_url` varchar(300) NOT NULL,
  `category` varchar(50) NOT NULL,
  `image_title` varchar(200) NOT NULL,
  `added_on` varchar(25) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `gallery_images`
--

INSERT INTO `gallery_images` (`id`, `image_url`, `category`, `image_title`, `added_on`) VALUES
(1, '1625559707_image_3.jpg', '3', 'This is text', '06/07/21 01:51:47 PM'),
(2, '1625559721_image_3.jpeg', '3', 'This is text', '06/07/21 01:52:01 PM');

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

--
-- Table structure for table `gallery_img_category`
--

CREATE TABLE IF NOT EXISTS `gallery_img_category` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `category_name` varchar(200) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `gallery_img_category`
--

INSERT INTO `gallery_img_category` (`id`, `category_name`) VALUES
(1, 'Thumbnail'),
(2, 'Thumbnail+'),
(3, 'Full Screen'),
(4, 'News Article'),
(5, 'Press Release'),
(6, 'Volunteers');

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

--
-- Table structure for table `notifications`
--

CREATE TABLE IF NOT EXISTS `notifications` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `notification_desc` varchar(500) CHARACTER SET utf32 NOT NULL,
  `status` tinyint(1) NOT NULL,
  `added_on` varchar(25) CHARACTER SET utf32 NOT NULL,
  `updated_on` varchar(25) CHARACTER SET utf32 COLLATE utf32_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `notifications`
--

INSERT INTO `notifications` (`id`, `notification_desc`, `status`, `added_on`, `updated_on`) VALUES
(7, '<p><font face=\"Helvetica\">﻿Humanify Foundation (India) is a registered NGO in India working for the most marginalised, underprivileged, exploited &amp; deprived segments of society.</font><br></p>', 0, '06/07/21 11:51:17 AM', '06/07/21 11:58:30 AM');

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

--
-- Table structure for table `organizer`
--

CREATE TABLE IF NOT EXISTS `organizer` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `email` varchar(500) NOT NULL,
  `mobile` varchar(10) NOT NULL,
  `state` varchar(200) NOT NULL,
  `city` varchar(200) NOT NULL,
  `area_of_interest` varchar(200) NOT NULL,
  `availablity` varchar(200) NOT NULL,
  `skill_set` varchar(200) NOT NULL,
  `added_on` varchar(25) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `sliders`
--

CREATE TABLE IF NOT EXISTS `sliders` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `slider_url` varchar(200) CHARACTER SET utf32 NOT NULL,
  `title` varchar(500) CHARACTER SET utf32 NOT NULL,
  `added_on` varchar(25) CHARACTER SET utf32 NOT NULL,
  `postion` varchar(25) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sliders`
--

INSERT INTO `sliders` (`id`, `slider_url`, `title`, `added_on`, `postion`) VALUES
(7, '1625552606_slider.jpg', 'Welcome to Humanify Foundation', '06/07/21 11:53:26 AM', ''),
(8, '1625552615_slider.jpg', 'Welcome to Humanify Foundation', '06/07/21 11:53:35 AM', ''),
(9, '1625552785_slider.jpg', 'Welcome to Humanify Foundation', '06/07/21 11:56:25 AM', ''),
(11, '1625552836_slider.jpg', 'Welcome to Humanify Foundation', '06/07/21 11:57:16 AM', ''),
(12, '1625552848_slider.jpg', 'Welcome to Humanify Foundation', '06/07/21 11:57:28 AM', '');

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

--
-- Table structure for table `volunteer`
--

CREATE TABLE IF NOT EXISTS `volunteer` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `email` varchar(500) NOT NULL,
  `mobile` varchar(10) NOT NULL,
  `state` varchar(200) NOT NULL,
  `city` varchar(200) NOT NULL,
  `area_of_interest` varchar(200) NOT NULL,
  `availablity` varchar(200) NOT NULL,
  `skill_set` varchar(200) NOT NULL,
  `added_on` varchar(25) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
COMMIT;

