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

START TRANSACTION;



--
-- Database: `shims`
--

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

--
-- Table structure for table `blog_categories`
--

CREATE TABLE `blog_categories` (
  `id` int(11) NOT NULL,
  `cat_name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `blog_categories`
--

INSERT INTO `blog_categories` (`id`, `cat_name`, `slug`, `created_at`, `updated_at`) VALUES
(6, 'Wordpress', 'wordpress', '2018-06-12 10:00:20', '0000-00-00 00:00:00'),
(7, 'Web Design', 'web-design', '2018-06-21 10:02:16', '0000-00-00 00:00:00'),
(8, 'PhotoShop', 'photoshop', '2018-06-23 09:14:19', '0000-00-00 00:00:00'),
(9, 'Sports', 'sports', '2018-06-23 09:14:37', '0000-00-00 00:00:00'),
(10, 'Programming', 'programming', '2018-06-23 09:16:35', '0000-00-00 00:00:00'),
(11, 'News', 'news', '2018-07-16 08:36:58', '2018-07-16 05:36:58');

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

--
-- Table structure for table `blog_post`
--

CREATE TABLE `blog_post` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `category_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `meta_desc` text NOT NULL,
  `meta_keywords` text NOT NULL,
  `featured_img` varchar(255) NOT NULL,
  `status` tinyint(4) NOT NULL,
  `content` text NOT NULL,
  `deleted_at` varchar(50) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `allow_comments` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `blog_post`
--

INSERT INTO `blog_post` (`id`, `title`, `category_id`, `user_id`, `slug`, `meta_desc`, `meta_keywords`, `featured_img`, `status`, `content`, `deleted_at`, `created_at`, `updated_at`, `allow_comments`) VALUES
(3, 'Our Security Policy has been Update', 7, 1, 'our-security-policy-has-been-update', 'dummy description', 'one,two', 'http://localhost/login/uploads/blog_images/ps4.jpg', 1, '<p>some content</p>', 'Null', '2018-06-23 02:52:59', '2018-06-23 06:12:56', 1),
(4, 'Laravel and Vue.js in action', 10, 1, 'laravel-and-vuejs-in-action', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry.', 'Laravel, Php, Vue.js', 'http://localhost/login/uploads/blog_images/vue-spa-with-laravel.png', 1, '<p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; font-family: &quot;Open Sans&quot;, Arial, sans-serif;\"><span style=\"font-family: Helvetica;\">L</span><span style=\"font-family: Helvetica;\">?</span><span style=\"font-family: Helvetica;\">orem ipsum dolor sit amet, consectetur adipiscing elit. Phasellus non sapien vulputate, convallis lectus et, commodo libero. Mauris varius nisl bibendum porta tincidunt. Suspendisse vitae dui efficitur, ullamcorper ligula eu, sagittis arcu. Curabitur euismod neque nec suscipit consectetur. Donec rutrum nec magna vel auctor. Duis sapien velit, pharetra sit amet urna et, consequat elementum velit. Integer eros eros, condimentum eget enim vel, consectetur euismod est. Nam sodales congue convallis. Donec nunc magna, suscipit eget posuere in, viverra a lorem.</span></p><p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; font-family: &quot;Open Sans&quot;, Arial, sans-serif;\"><span style=\"font-family: Helvetica;\">Donec vel placerat massa. Integer nisi libero, venenatis vitae vulputate in, cursus ut magna. Suspendisse potenti. Sed sit amet venenatis turpis, vitae consequat est. Mauris vitae sem id erat gravida vestibulum. Nullam venenatis at quam eget pharetra. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Nunc sit amet eleifend metus, non elementum enim. Nulla rhoncus, orci in commodo hendrerit, ipsum massa vulputate tellus, vitae tempor nibh nunc nec velit. Nullam viverra, turpis eu gravida rutrum, mi orci viverra lorem, id facilisis est turpis varius diam. Nunc sed tincidunt ligula, quis convallis lacus. Fusce facilisis faucibus lectus, a laoreet nunc facilisis eu. Mauris faucibus, purus ut facilisis ultrices, nibh diam luctus ex, et interdum eros mauris eget nulla. Mauris volutpat nibh at lectus ullamcorper aliquet. Fusce consectetur commodo eros, ut fringilla dolor tempor non. Etiam ac libero vel turpis commodo aliquet a quis est.</span></p><p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; font-family: &quot;Open Sans&quot;, Arial, sans-serif;\"><span style=\"font-family: Helvetica;\">Donec ut odio pharetra, ullamcorper tellus non, luctus mi. Nulla imperdiet lorem tellus, vitae scelerisque lacus porta eget. Mauris vel odio dolor. Quisque fringilla at nulla id auctor. Nam molestie finibus tortor, ut dapibus nisi feugiat sed. Vestibulum gravida eros sed arcu consectetur, dictum interdum tortor condimentum. Aliquam consectetur elit a mi faucibus, a consectetur arcu vestibulum. Cras vel dui et mi pretium condimentum sed nec sapien. Vestibulum finibus volutpat massa.</span></p><p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; font-family: &quot;Open Sans&quot;, Arial, sans-serif;\"><span style=\"font-family: Helvetica;\">Quisque porta massa id elementum facilisis. Vestibulum a imperdiet orci. Proin gravida odio a maximus fermentum. Mauris molestie eget nisl in ultrices. Phasellus quis risus velit. Donec finibus mi gravida mi gravida sagittis. Duis nec ullamcorper felis, eu posuere lectus. Ut tincidunt, quam eget aliquet egestas, erat enim pulvinar nisi, ac ultrices tellus nunc nec tellus. Sed vitae lacus vitae dui facilisis volutpat. Ut congue ex vitae purus dictum, nec elementum mi aliquam. Mauris elit diam, tempus quis feugiat sit amet, mattis et sapien. Sed eu dolor commodo, volutpat odio ac, viverra odio.</span></p><p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; font-family: &quot;Open Sans&quot;, Arial, sans-serif;\"><span style=\"font-family: Helvetica;\">Integer mauris dolor, scelerisque quis lorem vitae, euismod convallis massa. Nulla consequat ligula at justo efficitur, in porta massa porta. Vivamus interdum sagittis diam, vitae ultricies diam sagittis ut. Quisque fringilla nunc id libero mollis facilisis. Nam eu scelerisque sapien, sed varius velit. Curabitur purus magna, finibus vitae suscipit eu, bibendum nec mi. Quisque neque neque, pulvinar at ullamcorper in, aliquet eu libero. Maecenas sed dapibus diam. Phasellus pretium scelerisque lectus, a molestie erat sodales in. Suspendisse euismod mollis neque, non lacinia eros viverra sit amet. Ut venenatis diam mollis sem interdum, id luctus dui pretium.</span></p>', 'Null', '2018-06-23 06:20:42', '2018-06-23 06:20:42', 1),
(5, 'Create Restfull API with Laravel 5.3', 7, 1, 'create-restfull-api-with-laravel-53', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Phasellus non sapien vulputate, convallis lectus et,', 'Restful API, Laravel, Larave 5.3,API', 'http://localhost/login/uploads/blog_images/Laravel-51.png', 1, '<hr style=\"margin: 0px; padding: 0px; border-top: 0px; clear: both; height: 1px; background-image: linear-gradient(to right, rgba(0, 0, 0, 0), rgba(0, 0, 0, 0.75), rgba(0, 0, 0, 0)); font-family: \" open=\"\" sans\",=\"\" arial,=\"\" sans-serif;=\"\" text-align:=\"\" center;\"=\"\"><div id=\"Content\" style=\"margin: 0px; padding: 0px; position: relative; font-family: \" open=\"\" sans\",=\"\" arial,=\"\" sans-serif;=\"\" text-align:=\"\" center;\"=\"\"><div class=\"boxed\" style=\"margin: 10px 28.7969px; padding: 0px; clear: both;\"><div id=\"lipsum\" style=\"margin: 0px; padding: 0px; text-align: justify;\"><p style=\"margin-bottom: 15px; padding: 0px;\">Lorem ipsum dolor sit amet, consectetur adipiscing elit. Phasellus non sapien vulputate, convallis lectus et, commodo libero. Mauris varius nisl bibendum porta tincidunt. Suspendisse vitae dui efficitur, ullamcorper ligula eu, sagittis arcu. Curabitur euismod neque nec suscipit consectetur. Donec rutrum nec magna vel auctor. Duis sapien velit, pharetra sit amet urna et, consequat elementum velit. Integer eros eros, condimentum eget enim vel, consectetur euismod est. Nam sodales congue convallis. Donec nunc magna, suscipit eget posuere in, viverra a lorem.</p><p style=\"margin-bottom: 15px; padding: 0px;\"><br></p></div></div></div>', 'Null', '2018-06-23 06:24:44', '2018-08-04 02:34:18', 1),
(6, 'laravel vs codeigniter', 10, 1, 'laravel-vs-codeigniter', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Phasellus non sapien vulputate, convallis lectus et, commodo libero.', 'Laravel, Codeigniter', 'http://localhost/login/uploads/blog_images/laravel-vs-codeigniter-2.jpg', 1, '<div id=\"Content\" style=\"margin: 0px; padding: 0px; position: relative; font-family: &quot;Open Sans&quot;, Arial, sans-serif; text-align: center;\"><div class=\"boxed\" style=\"margin: 10px 28.7969px; padding: 0px; clear: both;\"><div id=\"lipsum\" style=\"margin: 0px; padding: 0px; text-align: justify;\"><p style=\"margin-bottom: 15px; padding: 0px;\">Lorem ipsum dolor sit amet, consectetur adipiscing elit. Phasellus non sapien vulputate, convallis lectus et, commodo libero. Mauris varius nisl bibendum porta tincidunt. Suspendisse vitae dui efficitur, ullamcorper ligula eu, sagittis arcu. Curabitur euismod neque nec suscipit consectetur. Donec rutrum nec magna vel auctor. Duis sapien velit, pharetra sit amet urna et, consequat elementum velit. Integer eros eros, condimentum eget enim vel, consectetur euismod est. Nam sodales congue convallis. Donec nunc magna, suscipit eget posuere in, viverra a lorem.</p><p style=\"margin-bottom: 15px; padding: 0px;\">Donec vel placerat massa. Integer nisi libero, venenatis vitae vulputate in, cursus ut magna. Suspendisse potenti. Sed sit amet venenatis turpis, vitae consequat est. Mauris vitae sem id erat gravida vestibulum. Nullam venenatis at quam eget pharetra. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Nunc sit amet eleifend metus, non elementum enim. Nulla rhoncus, orci in commodo hendrerit, ipsum massa vulputate tellus, vitae tempor nibh nunc nec velit. Nullam viverra, turpis eu gravida rutrum, mi orci viverra lorem, id facilisis est turpis varius diam. Nunc sed tincidunt ligula, quis convallis lacus. Fusce facilisis faucibus lectus, a laoreet nunc facilisis eu. Mauris faucibus, purus ut facilisis ultrices, nibh diam luctus ex, et interdum eros mauris eget nulla. Mauris volutpat nibh at lectus ullamcorper aliquet. Fusce consectetur commodo eros, ut fringilla dolor tempor non. Etiam ac libero vel turpis commodo aliquet a quis est.</p><p style=\"margin-bottom: 15px; padding: 0px;\">Donec ut odio pharetra, ullamcorper tellus non, luctus mi. Nulla imperdiet lorem tellus, vitae scelerisque lacus porta eget. Mauris vel odio dolor. Quisque fringilla at nulla id auctor. Nam molestie finibus tortor, ut dapibus nisi feugiat sed. Vestibulum gravida eros sed arcu consectetur, dictum interdum tortor condimentum. Aliquam consectetur elit a mi faucibus, a consectetur arcu vestibulum. Cras vel dui et mi pretium condimentum sed nec sapien. Vestibulum finibus volutpat massa.</p><p style=\"margin-bottom: 15px; padding: 0px;\">Quisque porta massa id elementum facilisis. Vestibulum a imperdiet orci. Proin gravida odio a maximus fermentum. Mauris molestie eget nisl in ultrices. Phasellus quis risus velit. Donec finibus mi gravida mi gravida sagittis. Duis nec ullamcorper felis, eu posuere lectus. Ut tincidunt, quam eget aliquet egestas, erat enim pulvinar nisi, ac ultrices tellus nunc nec tellus. Sed vitae lacus vitae dui facilisis volutpat. Ut congue ex vitae purus dictum, nec elementum mi aliquam. Mauris elit diam, tempus quis feugiat sit amet, mattis et sapien. Sed eu dolor commodo, volutpat odio ac, viverra odio.</p><p style=\"margin-bottom: 15px; padding: 0px;\">Integer mauris dolor, scelerisque quis lorem vitae, euismod convallis massa. Nulla consequat ligula at justo efficitur, in porta massa porta. Vivamus interdum sagittis diam, vitae ultricies diam sagittis ut. Quisque fringilla nunc id libero mollis facilisis. Nam eu scelerisque sapien, sed varius velit. Curabitur purus magna, finibus vitae suscipit eu, bibendum nec mi. Quisque neque neque, pulvinar at ullamcorper in, aliquet eu libero. Maecenas sed dapibus diam. Phasellus pretium scelerisque lectus, a molestie erat sodales in. Suspendisse euismod mollis neque, non lacinia eros viverra sit amet. Ut venenatis diam mollis sem interdum, id luctus dui pretium.</p></div></div></div>', 'Null', '2018-06-23 06:27:28', '2018-06-23 06:27:28', 1),
(7, 'Photoshop new version', 8, 1, 'photoshop-new-version', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Phasellus non sapien vulputate, convallis lectus et, commodo libero.', 'photoshop, new-version,designing', 'http://localhost/login/uploads/blog_images/Photoshop.jpg', 1, '<p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; font-family: &quot;Open Sans&quot;, Arial, sans-serif;\">Lorem ipsum dolor sit amet, consectetur adipiscing elit. Phasellus non sapien vulputate, convallis lectus et, commodo libero. Mauris varius nisl bibendum porta tincidunt. Suspendisse vitae dui efficitur, ullamcorper ligula eu, sagittis arcu. Curabitur euismod neque nec suscipit consectetur. Donec rutrum nec magna vel auctor. Duis sapien velit, pharetra sit amet urna et, consequat elementum velit. Integer eros eros, condimentum eget enim vel, consectetur euismod est. Nam sodales congue convallis. Donec nunc magna, suscipit eget posuere in, viverra a lorem.</p><p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; font-family: &quot;Open Sans&quot;, Arial, sans-serif;\">Donec vel placerat massa. Integer nisi libero, venenatis vitae vulputate in, cursus ut magna. Suspendisse potenti. Sed sit amet venenatis turpis, vitae consequat est. Mauris vitae sem id erat gravida vestibulum. Nullam venenatis at quam eget pharetra. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Nunc sit amet eleifend metus, non elementum enim. Nulla rhoncus, orci in commodo hendrerit, ipsum massa vulputate tellus, vitae tempor nibh nunc nec velit. Nullam viverra, turpis eu gravida rutrum, mi orci viverra lorem, id facilisis est turpis varius diam. Nunc sed tincidunt ligula, quis convallis lacus. Fusce facilisis faucibus lectus, a laoreet nunc facilisis eu. Mauris faucibus, purus ut facilisis ultrices, nibh diam luctus ex, et interdum eros mauris eget nulla. Mauris volutpat nibh at lectus ullamcorper aliquet. Fusce consectetur commodo eros, ut fringilla dolor tempor non. Etiam ac libero vel turpis commodo aliquet a quis est.</p><p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; font-family: &quot;Open Sans&quot;, Arial, sans-serif;\">Donec ut odio pharetra, ullamcorper tellus non, luctus mi. Nulla imperdiet lorem tellus, vitae scelerisque lacus porta eget. Mauris vel odio dolor. Quisque fringilla at nulla id auctor. Nam molestie finibus tortor, ut dapibus nisi feugiat sed. Vestibulum gravida eros sed arcu consectetur, dictum interdum tortor condimentum. Aliquam consectetur elit a mi faucibus, a consectetur arcu vestibulum. Cras vel dui et mi pretium condimentum sed nec sapien. Vestibulum finibus volutpat massa.</p><p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; font-family: &quot;Open Sans&quot;, Arial, sans-serif;\">Quisque porta massa id elementum facilisis. Vestibulum a imperdiet orci. Proin gravida odio a maximus fermentum. Mauris molestie eget nisl in ultrices. Phasellus quis risus velit. Donec finibus mi gravida mi gravida sagittis. Duis nec ullamcorper felis, eu posuere lectus. Ut tincidunt, quam eget aliquet egestas, erat enim pulvinar nisi, ac ultrices tellus nunc nec tellus. Sed vitae lacus vitae dui facilisis volutpat. Ut congue ex vitae purus dictum, nec elementum mi aliquam. Mauris elit diam, tempus quis feugiat sit amet, mattis et sapien. Sed eu dolor commodo, volutpat odio ac, viverra odio.</p><p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; font-family: &quot;Open Sans&quot;, Arial, sans-serif;\">Integer mauris dolor, scelerisque quis lorem vitae, euismod convallis massa. Nulla consequat ligula at justo efficitur, in porta massa porta. Vivamus interdum sagittis diam, vitae ultricies diam sagittis ut. Quisque fringilla nunc id libero mollis facilisis. Nam eu scelerisque sapien, sed varius velit. Curabitur purus magna, finibus vitae suscipit eu, bibendum nec mi. Quisque neque neque, pulvinar at ullamcorper in, aliquet eu libero. Maecenas sed dapibus diam. Phasellus pretium scelerisque lectus, a molestie erat sodales in. Suspendisse euismod mollis neque, non lacinia eros viverra sit amet. Ut venenatis diam mollis sem interdum, id luctus dui pretium.</p>', 'Null', '2018-06-23 06:30:29', '2018-06-23 06:30:29', 1),
(8, 'England made highest runs score in world cricket', 9, 1, 'england-made-highest-runs-score-in-world-cricket', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Phasellus non sapien vulputate, convallis lectus et, commodo libero. Mauris varius nisl bibendum porta tincidunt.', 'england, cricket, sports,England -cricket', 'http://localhost/login/uploads/blog_images/skysports-jason-roy-roy-england_4340099.jpg', 1, '<p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; font-family: &quot;Open Sans&quot;, Arial, sans-serif;\">Lorem ipsum dolor sit amet, consectetur adipiscing elit. Phasellus non sapien vulputate, convallis lectus et, commodo libero. Mauris varius nisl bibendum porta tincidunt. Suspendisse vitae dui efficitur, ullamcorper ligula eu, sagittis arcu. Curabitur euismod neque nec suscipit consectetur. Donec rutrum nec magna vel auctor. Duis sapien velit, pharetra sit amet urna et, consequat elementum velit. Integer eros eros, condimentum eget enim vel, consectetur euismod est. Nam sodales congue convallis. Donec nunc magna, suscipit eget posuere in, viverra a lorem.</p><p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; font-family: &quot;Open Sans&quot;, Arial, sans-serif;\">Donec vel placerat massa. Integer nisi libero, venenatis vitae vulputate in, cursus ut magna. Suspendisse potenti. Sed sit amet venenatis turpis, vitae consequat est. Mauris vitae sem id erat gravida vestibulum. Nullam venenatis at quam eget pharetra. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Nunc sit amet eleifend metus, non elementum enim. Nulla rhoncus, orci in commodo hendrerit, ipsum massa vulputate tellus, vitae tempor nibh nunc nec velit. Nullam viverra, turpis eu gravida rutrum, mi orci viverra lorem, id facilisis est turpis varius diam. Nunc sed tincidunt ligula, quis convallis lacus. Fusce facilisis faucibus lectus, a laoreet nunc facilisis eu. Mauris faucibus, purus ut facilisis ultrices, nibh diam luctus ex, et interdum eros mauris eget nulla. Mauris volutpat nibh at lectus ullamcorper aliquet. Fusce consectetur commodo eros, ut fringilla dolor tempor non. Etiam ac libero vel turpis commodo aliquet a quis est.</p><p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; font-family: &quot;Open Sans&quot;, Arial, sans-serif;\">Donec ut odio pharetra, ullamcorper tellus non, luctus mi. Nulla imperdiet lorem tellus, vitae scelerisque lacus porta eget. Mauris vel odio dolor. Quisque fringilla at nulla id auctor. Nam molestie finibus tortor, ut dapibus nisi feugiat sed. Vestibulum gravida eros sed arcu consectetur, dictum interdum tortor condimentum. Aliquam consectetur elit a mi faucibus, a consectetur arcu vestibulum. Cras vel dui et mi pretium condimentum sed nec sapien. Vestibulum finibus volutpat massa.</p><p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; font-family: &quot;Open Sans&quot;, Arial, sans-serif;\">Quisque porta massa id elementum facilisis. Vestibulum a imperdiet orci. Proin gravida odio a maximus fermentum. Mauris molestie eget nisl in ultrices. Phasellus quis risus velit. Donec finibus mi gravida mi gravida sagittis. Duis nec ullamcorper felis, eu posuere lectus. Ut tincidunt, quam eget aliquet egestas, erat enim pulvinar nisi, ac ultrices tellus nunc nec tellus. Sed vitae lacus vitae dui facilisis volutpat. Ut congue ex vitae purus dictum, nec elementum mi aliquam. Mauris elit diam, tempus quis feugiat sit amet, mattis et sapien. Sed eu dolor commodo, volutpat odio ac, viverra odio.</p><p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; font-family: &quot;Open Sans&quot;, Arial, sans-serif;\">Integer mauris dolor, scelerisque quis lorem vitae, euismod convallis massa. Nulla consequat ligula at justo efficitur, in porta massa porta. Vivamus interdum sagittis diam, vitae ultricies diam sagittis ut. Quisque fringilla nunc id libero mollis facilisis. Nam eu scelerisque sapien, sed varius velit. Curabitur purus magna, finibus vitae suscipit eu, bibendum nec mi. Quisque neque neque, pulvinar at ullamcorper in, aliquet eu libero. Maecenas sed dapibus diam. Phasellus pretium scelerisque lectus, a molestie erat sodales in. Suspendisse euismod mollis neque, non lacinia eros viverra sit amet. Ut venenatis diam mollis sem interdum, id luctus dui pretium.</p>', 'Null', '2018-06-23 06:35:36', '2018-06-23 06:35:36', 1),
(10, 'Ronalod Best Goals', 9, 1, 'ronalod-best-goals', 'Ronaldo Best Goals', 'football, Ronaldo,cr7', 'http://localhost/login/uploads/blog_images/skynews-ronaldo-portugal-football_4338029.jpg', 1, '<p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; font-family: &quot;Open Sans&quot;, Arial, sans-serif;\">Lorem ipsum dolor sit amet, consectetur adipiscing elit. Phasellus non sapien vulputate, convallis lectus et, commodo libero. Mauris varius nisl bibendum porta tincidunt. Suspendisse vitae dui efficitur, ullamcorper ligula eu, sagittis arcu. Curabitur euismod neque nec suscipit consectetur. Donec rutrum nec magna vel auctor. Duis sapien velit, pharetra sit amet urna et, consequat elementum velit. Integer eros eros, condimentum eget enim vel, consectetur euismod est. Nam sodales congue convallis. Donec nunc magna, suscipit eget posuere in, viverra a lorem.</p><p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; font-family: &quot;Open Sans&quot;, Arial, sans-serif;\">Donec vel placerat massa. Integer nisi libero, venenatis vitae vulputate in, cursus ut magna. Suspendisse potenti. Sed sit amet venenatis turpis, vitae consequat est. Mauris vitae sem id erat gravida vestibulum. Nullam venenatis at quam eget pharetra. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Nunc sit amet eleifend metus, non elementum enim. Nulla rhoncus, orci in commodo hendrerit, ipsum massa vulputate tellus, vitae tempor nibh nunc nec velit. Nullam viverra, turpis eu gravida rutrum, mi orci viverra lorem, id facilisis est turpis varius diam. Nunc sed tincidunt ligula, quis convallis lacus. Fusce facilisis faucibus lectus, a laoreet nunc facilisis eu. Mauris faucibus, purus ut facilisis ultrices, nibh diam luctus ex, et interdum eros mauris eget nulla. Mauris volutpat nibh at lectus ullamcorper aliquet. Fusce consectetur commodo eros, ut fringilla dolor tempor non. Etiam ac libero vel turpis commodo aliquet a quis est.</p><p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; font-family: &quot;Open Sans&quot;, Arial, sans-serif;\">Donec ut odio pharetra, ullamcorper tellus non, luctus mi. Nulla imperdiet lorem tellus, vitae scelerisque lacus porta eget. Mauris vel odio dolor. Quisque fringilla at nulla id auctor. Nam molestie finibus tortor, ut dapibus nisi feugiat sed. Vestibulum gravida eros sed arcu consectetur, dictum interdum tortor condimentum. Aliquam consectetur elit a mi faucibus, a consectetur arcu vestibulum. Cras vel dui et mi pretium condimentum sed nec sapien. Vestibulum finibus volutpat massa.</p><p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; font-family: &quot;Open Sans&quot;, Arial, sans-serif;\">Quisque porta massa id elementum facilisis. Vestibulum a imperdiet orci. Proin gravida odio a maximus fermentum. Mauris molestie eget nisl in ultrices. Phasellus quis risus velit. Donec finibus mi gravida mi gravida sagittis. Duis nec ullamcorper felis, eu posuere lectus. Ut tincidunt, quam eget aliquet egestas, erat enim pulvinar nisi, ac ultrices tellus nunc nec tellus. Sed vitae lacus vitae dui facilisis volutpat. Ut congue ex vitae purus dictum, nec elementum mi aliquam. Mauris elit diam, tempus quis feugiat sit amet, mattis et sapien. Sed eu dolor commodo, volutpat odio ac, viverra odio.</p><p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; font-family: &quot;Open Sans&quot;, Arial, sans-serif;\">Integer mauris dolor, scelerisque quis lorem vitae, euismod convallis massa. Nulla consequat ligula at justo efficitur, in porta massa porta. Vivamus interdum sagittis diam, vitae ultricies diam sagittis ut. Quisque fringilla nunc id libero mollis facilisis. Nam eu scelerisque sapien, sed varius velit. Curabitur purus magna, finibus vitae suscipit eu, bibendum nec mi. Quisque neque neque, pulvinar at ullamcorper in, aliquet eu libero. Maecenas sed dapibus diam. Phasellus pretium scelerisque lectus, a molestie erat sodales in. Suspendisse euismod mollis neque, non lacinia eros viverra sit amet. Ut venenatis diam mollis sem interdum, id luctus dui pretium.</p>', 'Null', '2018-06-23 07:09:52', '2018-06-23 07:09:52', 1),
(11, 'About President of pakistan', 9, 1, 'about-president-of-pakistan', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry.', 'kjhk,khkjh', 'http://localhost/login/uploads/blog_images/33868369_190291285125095_8752566590974722048_n_(1).jpg', 0, '<p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; font-family: \"Open Sans\", Arial, sans-serif;\"><b><u>Lorem ipsum dolor sit amet, consectetur adipiscing elit:</u></b></p><p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; font-family: \"Open Sans\", Arial, sans-serif;\">Praesent porta est at sapien ultrices, sit amet semper justo tempus. Nam convallis sapien nec tortor dignissim fermentum. Nunc dignissim tempor tortor, nec porttitor risus volutpat sit amet. Suspendisse luctus ullamcorper mi. Maecenas ultrices mi a ex congue, at dictum leo eleifend. In nisl nisl, ultricies ut metus a, ornare scelerisque nisl. Quisque dolor dui, suscipit sed rhoncus nec, accumsan et lorem. Donec eu bibendum nibh. Sed id elit urna. Curabitur pulvinar tristique lacus vel molestie. Praesent sit amet erat sed diam imperdiet lacinia ut ac magna. Aliquam ultricies, sem semper dictum placerat, nisl nunc iaculis felis, vel tincidunt tortor massa quis est. Integer finibus at risus id feugiat.</p><p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; font-family: \"Open Sans\", Arial, sans-serif;\"><b><u>Curabitur in velit vitae eros rutrum vulputate id quis velit:</u></b></p><p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; font-family: \"Open Sans\", Arial, sans-serif;\">Proin nunc massa, commodo vitae nisi eget, egestas efficitur mi. Morbi sit amet imperdiet sem. Suspendisse fermentum sem non nunc mattis, hendrerit convallis orci pellentesque. Integer tempus vel est sit amet rhoncus. Integer sed pretium libero, sed posuere elit. Donec vel varius mauris, ut sollicitudin dolor. Maecenas bibendum elit sit amet blandit scelerisque.</p><p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; font-family: \"Open Sans\", Arial, sans-serif;\"><b><u>Quisque nec nunc quam:</u></b></p><p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; font-family: \"Open Sans\", Arial, sans-serif;\">Cras condimentum pharetra mi et imperdiet. Duis consectetur mi sit amet ex sodales, ut interdum orci ornare. Mauris venenatis erat et nisl tincidunt dignissim. In hac habitasse platea dictumst. Nam suscipit nisi interdum faucibus dignissim. Aliquam porttitor lectus sit amet libero posuere finibus quis sit amet sapien. Nullam varius neque lectus, in aliquam neque sodales eleifend.</p><p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; font-family: \"Open Sans\", Arial, sans-serif;\"><b><u>Proin id justo eget justo venenatis tempus a sed leo.</u></b></p><p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; font-family: \"Open Sans\", Arial, sans-serif;\">Nam ut congue lorem. Vivamus enim justo, congue nec justo et, maximus elementum eros. Sed et tincidunt tellus. Nunc ultrices maximus massa sed ultricies. Donec faucibus hendrerit nulla. Mauris gravida orci eget nisi sodales, nec elementum libero dapibus. Cras lacus ante, ullamcorper eu tempor ut, dictum at mi. Aenean id vehicula tellus, sed varius diam. Etiam egestas convallis vulputate. Nullam nisi tellus, blandit ut nisl in, tincidunt placerat arcu. Morbi sed ultrices justo, eget mollis magna.</p>', '2018-08-04 07:30:49', '2018-07-14 12:37:37', '2018-07-30 12:09:25', 0),
(12, 'Nawaz Sharif\'s audio message from Adiala jail', 11, 1, 'nawaz-sharifs-audio-message-from-adiala-jail', 'LAHORE: Ousted prime minister Nawaz Sharif and Pakistan Muslim League-N (PML-N) Quaid Nawaz Sharif and his daughter Maryam Nawaz', 'nawaz,Maryam,maryam-nawaz', 'http://localhost/login/uploads/blog_images/l_342150_102047_updates.jpg', 1, '<p class=\"\" style=\"margin-top: 20px; margin-bottom: 20px; font-size: 18px; line-height: 27px; font-family: Merriweather;\">LAHORE: Ousted prime minister Nawaz Sharif and Pakistan Muslim League-N (PML-N) Quaid Nawaz Sharif and his daughter Maryam Nawaz, currently lodged in Rawalpindi\'s Adiala jail in a corruption case, have issued audio messages for the people of Pakistan.<br></p><p style=\"margin-top: 20px; margin-bottom: 20px; font-size: 18px; line-height: 27px; font-family: Merriweather;\">Addressing his party workers and leaders in his recorded message, Nawaz said he had been put in jail to keep him away from them. “My daughter, who’s a daughter of the nation, has also been lodged in jail,” he said adding that the opponents did not know that the prison and imprisonment could not sever his relationship with his people.</p><p style=\"margin-top: 20px; margin-bottom: 20px; font-size: 18px; line-height: 27px; font-family: Merriweather;\">“Neither any dictator could break off that relationship in the past nor those pulling the strings would be able to do so today,” asserted Nawaz Sharif. He requested the people to pray for recovery of his critically ill wife, whom he left behind, in a London hospital, to return to his country. He said the entire country had been turned into a jail. He said now was the time to stand up and break all shackles. He said the time had reached that people would have to free themselves from the (illegal) restrictions and to do away with the games being played with them for the last 70 years.</p><p style=\"margin-top: 20px; margin-bottom: 20px; font-size: 18px; line-height: 27px; font-family: Merriweather;\">He said such games with masses have turned the Quaid-e-Azam’s Pakistan into a laughing stock. “That’s why I have raised the slogan of ‘Vote Ko Izzat Do’ (Give Respect to Vote. Now it’s your turn to carry this flag (movement) forward.</p>', 'Null', '2018-07-16 05:44:44', '2018-07-16 05:44:44', 1),
(13, 'we are adding some new post', 6, 1, 'we-are-adding-some-new-post', 'i am adding new post', 'keyword1, keyword2', 'http://localhost/login/uploads/blog_images/Photoshop1.jpg', 1, '<p open=\"\" sans\",=\"\" arial,=\"\" sans-serif;\"=\"\" style=\"margin-bottom: 15px; padding: 0px; border: 0px; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; font-size: 15px; line-height: inherit; font-family: &quot;Open Sans&quot;; vertical-align: baseline; color: rgb(50, 50, 50); text-align: justify;\"><span style=\"margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline;\"><u style=\"margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline;\">Lorem ipsum dolor sit amet, consectetur adipiscing elit:</u></span></p><p open=\"\" sans\",=\"\" arial,=\"\" sans-serif;\"=\"\" style=\"margin-bottom: 15px; padding: 0px; border: 0px; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; font-size: 15px; line-height: inherit; font-family: &quot;Open Sans&quot;; vertical-align: baseline; color: rgb(50, 50, 50); text-align: justify;\">Praesent porta est at sapien ultrices, sit amet semper justo tempus. Nam convallis sapien nec tortor dignissim fermentum. Nunc dignissim tempor tortor, nec porttitor risus volutpat sit amet. Suspendisse luctus ullamcorper mi. Maecenas ultrices mi a ex congue, at dictum leo eleifend. In nisl nisl, ultricies ut metus a, ornare scelerisque nisl. Quisque dolor dui, suscipit sed rhoncus nec, accumsan et lorem. Donec eu bibendum nibh. Sed id elit urna. Curabitur pulvinar tristique lacus vel molestie. Praesent sit amet erat sed diam imperdiet lacinia ut ac magna. Aliquam ultricies, sem semper dictum placerat, nisl nunc iaculis felis, vel tincidunt tortor massa quis est. Integer finibus at risus id feugiat.</p><p open=\"\" sans\",=\"\" arial,=\"\" sans-serif;\"=\"\" style=\"margin-bottom: 15px; padding: 0px; border: 0px; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; font-size: 15px; line-height: inherit; font-family: &quot;Open Sans&quot;; vertical-align: baseline; color: rgb(50, 50, 50); text-align: justify;\"><span style=\"margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline;\"><u style=\"margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline;\">Curabitur in velit vitae eros rutrum vulputate id quis velit:</u></span></p><p open=\"\" sans\",=\"\" arial,=\"\" sans-serif;\"=\"\" style=\"margin-bottom: 15px; padding: 0px; border: 0px; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; font-size: 15px; line-height: inherit; font-family: &quot;Open Sans&quot;; vertical-align: baseline; color: rgb(50, 50, 50); text-align: justify;\">Proin nunc massa, commodo vitae nisi eget, egestas efficitur mi. Morbi sit amet imperdiet sem. Suspendisse fermentum sem non nunc mattis, hendrerit convallis orci pellentesque. Integer tempus vel est sit amet rhoncus. Integer sed pretium libero, sed posuere elit. Donec vel varius mauris, ut sollicitudin dolor. Maecenas bibendum elit sit amet blandit scelerisque.</p><p open=\"\" sans\",=\"\" arial,=\"\" sans-serif;\"=\"\" style=\"margin-bottom: 15px; padding: 0px; border: 0px; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; font-size: 15px; line-height: inherit; font-family: &quot;Open Sans&quot;; vertical-align: baseline; color: rgb(50, 50, 50); text-align: justify;\"><span style=\"margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline;\"><u style=\"margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline;\">Quisque nec nunc quam:</u></span></p><p open=\"\" sans\",=\"\" arial,=\"\" sans-serif;\"=\"\" style=\"margin-bottom: 15px; padding: 0px; border: 0px; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; font-size: 15px; line-height: inherit; font-family: &quot;Open Sans&quot;; vertical-align: baseline; color: rgb(50, 50, 50); text-align: justify;\">Cras condimentum pharetra mi et imperdiet. Duis consectetur mi sit amet ex sodales, ut interdum orci ornare. Mauris venenatis erat et nisl tincidunt dignissim. In hac habitasse platea dictumst. Nam suscipit nisi interdum faucibus dignissim. Aliquam porttitor lectus sit amet libero posuere finibus quis sit amet sapien. Nullam varius neque lectus, in aliquam neque sodales eleifend.</p>', 'Null', '2018-07-23 19:14:06', '2018-07-23 19:14:06', 1);

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

--
-- Table structure for table `blog_post_tags`
--

CREATE TABLE `blog_post_tags` (
  `id` int(11) NOT NULL,
  `post_id` int(11) NOT NULL,
  `tag_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `blog_post_tags`
--

INSERT INTO `blog_post_tags` (`id`, `post_id`, `tag_id`) VALUES
(10, 1, 1),
(11, 1, 4),
(12, 1, 5),
(13, 2, 2),
(14, 2, 4),
(15, 2, 6),
(18, 3, 1),
(19, 3, 2),
(20, 4, 10),
(21, 4, 11),
(24, 6, 12),
(25, 6, 14),
(26, 7, 10),
(27, 7, 11),
(28, 8, 8),
(29, 9, 14),
(30, 10, 4),
(31, 10, 7),
(35, 12, 11),
(36, 12, 12),
(37, 12, 13),
(44, 13, 4),
(45, 13, 7),
(46, 13, 8),
(47, 11, 4),
(48, 11, 7),
(49, 11, 8),
(53, 5, 12),
(54, 5, 13),
(55, 5, 14);

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

--
-- Table structure for table `blog_settings`
--

CREATE TABLE `blog_settings` (
  `id` int(11) NOT NULL,
  `enable_comments` tinyint(4) NOT NULL,
  `meta_description` text NOT NULL,
  `meta_kewords` text NOT NULL,
  `per_page_posts` int(10) NOT NULL,
  `default_img` text NOT NULL,
  `enable_category_posts` tinyint(4) NOT NULL,
  `enable_recent_post` tinyint(4) NOT NULL,
  `youtube` varchar(255) NOT NULL,
  `Linkedin` varchar(255) NOT NULL,
  `facebook` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `blog_settings`
--

INSERT INTO `blog_settings` (`id`, `enable_comments`, `meta_description`, `meta_kewords`, `per_page_posts`, `default_img`, `enable_category_posts`, `enable_recent_post`, `youtube`, `Linkedin`, `facebook`) VALUES
(1, 1, 'Lorem Ipsum is simply dummy text of the printing and typesetting industry.', 'sports,news,cricket,football', 8, 'http://localhost/login/uploads/blogging-SMB2.png', 1, 1, 'http://youtube.com/', 'https://linkedin.com/', 'http://facebook.com/');

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

--
-- Table structure for table `blog_tags`
--

CREATE TABLE `blog_tags` (
  `id` int(11) NOT NULL,
  `tag` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `blog_tags`
--

INSERT INTO `blog_tags` (`id`, `tag`, `slug`, `created_at`, `updated_at`) VALUES
(1, 'Articles', 'articles', '2018-06-12 09:59:38', '0000-00-00 00:00:00'),
(4, 'ronaldo', 'ronaldo', '2018-06-12 10:28:48', '0000-00-00 00:00:00'),
(7, 'football', 'football', '2018-06-23 09:15:15', '0000-00-00 00:00:00'),
(8, 'cricket', 'cricket', '2018-06-23 09:15:21', '0000-00-00 00:00:00'),
(9, 'messi', 'messi', '2018-06-23 09:15:25', '0000-00-00 00:00:00'),
(10, 'css', 'css', '2018-06-23 09:15:48', '0000-00-00 00:00:00'),
(11, 'bootstrap', 'bootstrap', '2018-06-23 09:15:54', '0000-00-00 00:00:00'),
(12, 'laravel', 'laravel', '2018-06-23 09:22:18', '0000-00-00 00:00:00'),
(13, 'laravel restfull api\'s', 'laravel-restfull-apis', '2018-06-23 09:22:34', '0000-00-00 00:00:00'),
(14, 'codeigniter', 'codeigniter', '2018-06-23 09:22:41', '0000-00-00 00:00:00');

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

--
-- Table structure for table `captcha`
--

CREATE TABLE `captcha` (
  `captcha_id` bigint(13) UNSIGNED NOT NULL,
  `captcha_time` int(10) UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `word` varchar(20) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `captcha`
--

INSERT INTO `captcha` (`captcha_id`, `captcha_time`, `ip_address`, `word`) VALUES
(95, NULL, '::1', NULL),
(94, NULL, '::1', NULL),
(93, NULL, '::1', NULL),
(92, NULL, '::1', NULL),
(91, NULL, '::1', NULL),
(90, NULL, '::1', NULL),
(89, NULL, '::1', NULL),
(88, NULL, '::1', NULL),
(155, 1506493472, '::1', 'LZCV6ISP'),
(143, 1506492915, '::1', '7WxjqlFC'),
(144, 1506492932, '::1', 'Mr2fRDem'),
(145, 1506492959, '::1', 'lZdK1Yzg'),
(146, 1506492988, '::1', 'm8ezTko7'),
(147, 1506492992, '::1', 'fcJsHOil'),
(148, 1506493027, '::1', '9W1qhZzr'),
(149, 1506493090, '::1', 'oCm3xKTp'),
(150, 1506493112, '::1', 'ast0VMcS'),
(151, 1506493175, '::1', 'QT7vqdVC'),
(152, 1506493194, '::1', 'OPyn5qkH'),
(153, 1506493353, '::1', 'mc2WCAs3'),
(154, 1506493370, '::1', 'IJzTfuqg');

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

--
-- Table structure for table `dynamic_field_group_items`
--

CREATE TABLE `dynamic_field_group_items` (
  `id` int(11) NOT NULL,
  `fld_grp_name` varchar(255) DEFAULT NULL,
  `field_grp_functionality` varchar(255) DEFAULT NULL,
  `fld_grp_code` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `modified_at` datetime DEFAULT NULL,
  `is_system` enum('0','1') DEFAULT '0',
  `is_deleted` enum('0','1') DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `dynamic_field_group_items`
--

INSERT INTO `dynamic_field_group_items` (`id`, `fld_grp_name`, `field_grp_functionality`, `fld_grp_code`, `description`, `created_at`, `modified_at`, `is_system`, `is_deleted`) VALUES
(1, 'dd', 'None', 'ff', '', '2021-09-23 01:45:02', NULL, '0', '0'),
(2, 'nw fld grp', 'None', 'nfg', '', '2021-09-23 02:06:49', NULL, '0', '0'),
(3, 'ww', 'None', 'rr', '', '2021-09-23 02:26:52', NULL, '0', '0'),
(4, 'wrsxfd', 'None', 'hchf', '', '2021-09-23 02:29:40', NULL, '0', '0'),
(5, 'dvsdbrb', 'None', 'dvrfberfb', 'sfbtbetn', '2021-09-23 02:30:09', NULL, '0', '0'),
(6, 'sf vsrv', 'None', 'sdvsedvs', '', '2021-09-23 02:30:47', NULL, '0', '0'),
(7, 'everv', 'None', 'rvevrr', 'efvef', '2021-09-23 02:31:49', NULL, '0', '0');

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

--
-- Table structure for table `dynamic_field_grp_mapping`
--

CREATE TABLE `dynamic_field_grp_mapping` (
  `id` int(11) NOT NULL,
  `fld_grp_id` int(11) DEFAULT NULL,
  `fld_id` int(11) DEFAULT NULL,
  `serial` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `dynamic_field_grp_mapping`
--

INSERT INTO `dynamic_field_grp_mapping` (`id`, `fld_grp_id`, `fld_id`, `serial`) VALUES
(1, 2, 1, 1),
(2, 2, 2, 2),
(3, 2, 14, 3),
(4, 2, 15, 4),
(5, 2, 16, 5),
(6, 2, 13, 6),
(7, 2, 3, 7),
(8, 3, 1, 1),
(9, 3, 2, 2),
(10, 3, 14, 3),
(11, 3, 15, 4),
(12, 3, 16, 5),
(13, 3, 13, 6),
(14, 4, 32, 1),
(15, 4, 35, 2),
(16, 4, 28, 3),
(17, 4, 22, 4),
(18, 4, 20, 5),
(19, 4, 31, 6),
(20, 4, 1, 7),
(21, 4, 2, 8),
(22, 4, 14, 9),
(23, 4, 15, 10),
(24, 5, 29, 1),
(25, 5, 31, 2),
(26, 5, 1, 3),
(27, 5, 2, 4),
(28, 5, 14, 5),
(29, 5, 15, 6),
(30, 5, 16, 7),
(31, 5, 13, 8),
(32, 6, 35, 1),
(33, 6, 1, 2),
(34, 6, 2, 3),
(35, 6, 14, 4),
(36, 6, 20, 5),
(37, 6, 22, 6),
(38, 6, 31, 7),
(39, 6, 25, 8),
(40, 7, 28, 1),
(41, 7, 22, 2),
(42, 7, 20, 3),
(43, 7, 31, 4),
(44, 7, 1, 5),
(45, 7, 2, 6),
(46, 7, 14, 7),
(47, 7, 15, 8),
(48, 7, 16, 9),
(49, 7, 13, 10),
(50, 7, 3, 11),
(51, 7, 17, 12),
(52, 7, 18, 13),
(53, 8, 20, 1),
(54, 8, 5, 2),
(55, 8, 7, 3),
(56, 8, 31, 4),
(57, 9, 5, 1),
(58, 9, 7, 2),
(59, 9, 31, 3),
(60, 9, 2, 4),
(61, 9, 1, 5),
(62, 9, 8, 6),
(63, 9, 14, 7),
(64, 9, 15, 8),
(65, 9, 16, 9),
(66, 9, 13, 10),
(67, 9, 3, 11),
(68, 9, 17, 12),
(69, 9, 18, 13),
(70, 9, 19, 14),
(71, 9, 36, 15),
(72, 9, 23, 16),
(73, 9, 30, 17),
(74, 9, 21, 18),
(75, 9, 24, 19),
(76, 9, 33, 20),
(77, 9, 37, 21);

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

--
-- Table structure for table `dynamic_field_items`
--

CREATE TABLE `dynamic_field_items` (
  `id` int(11) NOT NULL,
  `field_name` varchar(255) NOT NULL,
  `field_code` varchar(255) NOT NULL,
  `filed_description` varchar(255) NOT NULL,
  `field_type` int(11) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `modified_at` datetime DEFAULT NULL,
  `is_system` enum('0','1') DEFAULT '0',
  `is_deleted` enum('0','1') DEFAULT '0',
  `filed_size` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `dynamic_field_items`
--

INSERT INTO `dynamic_field_items` (`id`, `field_name`, `field_code`, `filed_description`, `field_type`, `created_at`, `modified_at`, `is_system`, `is_deleted`, `filed_size`) VALUES
(1, 'fieldDemo', 'Fd', 'description', 4, '2021-09-14 02:03:56', NULL, '0', '0', 3),
(2, 'fieldDemoE', 'FdE', 'description', 6, '2021-09-14 02:03:56', NULL, '0', '0', 3),
(3, 'fld Test', 'fT', 'fT description', 20, '2021-09-10 19:30:03', NULL, '0', '0', 3),
(4, 'tessting', 't', 'des', 2, '2021-09-14 01:32:17', NULL, '0', '0', 3),
(5, 'tst agn', 'ta', 'des', 4, '2021-09-14 01:33:24', NULL, '0', '0', 3),
(6, 'tfsr asd', 'awasdw', 'desdesdes', 4, '2021-09-14 01:33:49', NULL, '0', '0', 3),
(7, 'selectTst', 'st', 'des', 16, '2021-09-14 01:58:05', NULL, '0', '0', 3),
(8, 'selectTst', 'st', 'des', 16, '2021-09-14 02:03:32', NULL, '0', '0', 3),
(9, 'selectTst', 'st', 'des', 16, '2021-09-14 02:03:56', NULL, '0', '0', 3),
(10, 'selectTst', 'st', 'des', 16, '2021-09-14 02:05:21', NULL, '0', '0', 3),
(11, 'selectTst', 'st', 'des', 16, '2021-09-14 02:09:54', NULL, '0', '0', 3),
(12, 'selectTst', 'st', 'des', 16, '2021-09-14 02:11:38', NULL, '0', '0', 3),
(13, 'fld_nm', 'da_da', '', 16, '2021-09-14 13:06:16', NULL, '0', '0', 3),
(14, 'fld', 'fld', 'des', 16, '2021-09-14 13:06:52', NULL, '0', '0', 3),
(15, 'fld', 'fld', 'des', 16, '2021-09-14 13:13:24', NULL, '0', '0', 3),
(16, 'fld', 'fld', '', 16, '2021-09-14 13:36:30', NULL, '0', '0', 3),
(17, 'gender', 'gen', '', 16, '2021-09-22 09:23:53', NULL, '0', '0', 2),
(18, 'gender', 'gen', '', 16, '2021-09-22 09:25:22', NULL, '0', '0', 2),
(19, 'gender', 'gen', '', 16, '2021-09-22 09:25:54', NULL, '0', '0', 2),
(20, 'dvbajvh', 'aksbjhd', '', 20, '2021-09-22 12:09:04', NULL, '0', '0', 5),
(21, 'jjj', '555', '', 20, '2021-09-22 12:10:32', NULL, '0', '0', 0),
(22, 'djnvdk', 'kdbvkdh', '', 20, '2021-09-22 12:22:39', NULL, '0', '0', 5),
(23, 'gggg', 'ggggg', '', 20, '2021-09-22 12:23:45', NULL, '0', '0', 5),
(24, 'jjjj', 'jjjj', '', 20, '2021-09-22 12:25:15', NULL, '0', '0', 3),
(25, 'test', 'test', '', 20, '2021-09-22 12:25:42', NULL, '0', '0', 5),
(26, 'testing', 'testing', '', 20, '2021-09-22 12:26:27', NULL, '0', '0', 1),
(27, 'utest', 'utest', '', 20, '2021-09-22 12:31:23', NULL, '0', '0', 3),
(28, 'dhur dhur', 'dhur', '', 20, '2021-09-22 12:34:05', NULL, '0', '0', 5),
(29, 'tttt', 'ttttt', '', 20, '2021-09-22 12:34:52', NULL, '0', '0', 8),
(30, 'gggg', 'kkkk', '', 20, '2021-09-22 12:39:11', NULL, '0', '0', 7),
(31, 'fflll', 'code', '', 20, '2021-09-22 13:00:35', NULL, '0', '0', 8),
(32, '555', '444', '5', 4, '2021-09-22 13:14:18', NULL, '0', '0', 4),
(33, 'last test', 'lt', '', 20, '2021-09-22 13:16:20', NULL, '0', '0', 5),
(34, 'test2', 't2', '', 10, '2021-09-22 14:17:22', NULL, '0', '0', 6),
(35, 'checking', 'checking', '', 20, '2021-09-22 14:43:48', NULL, '0', '0', 4),
(36, 'ggg', 'ggg', '', 20, '2021-09-22 14:47:57', NULL, '0', '0', 4),
(37, 'new1', 'n1', '', 6, '2021-09-23 01:28:21', NULL, '0', '0', 4),
(38, 'new2', 'n2', '', 11, '2021-09-23 01:28:40', NULL, '0', '0', 3),
(39, 'nw fld', 'NF', '', 16, '2021-09-27 13:57:47', NULL, '0', '0', 5);

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

--
-- Table structure for table `dynamic_field_item_attr`
--

CREATE TABLE `dynamic_field_item_attr` (
  `id` int(11) NOT NULL,
  `fld_id` int(11) DEFAULT NULL,
  `attr_type` varchar(255) DEFAULT NULL,
  `attr_val` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `serial` int(11) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `dynamic_field_item_attr`
--

INSERT INTO `dynamic_field_item_attr` (`id`, `fld_id`, `attr_type`, `attr_val`, `created_at`, `serial`) VALUES
(1, 4, 'default_val', 'checked', '2021-09-14 01:32:17', 0),
(2, 5, 'default_val', '2021-09-14', '2021-09-14 01:33:24', 0),
(3, 6, 'default_val', 'current', '2021-09-14 01:33:49', 0),
(4, 11, 'option', 'optVal1', '2021-09-14 02:09:54', 1),
(5, 11, 'option', 'optVal2', '2021-09-14 02:09:54', 2),
(6, 11, 'option', 'optVal3', '2021-09-14 02:09:54', 4),
(7, 11, 'option', 'optVal4', '2021-09-14 02:09:54', 3),
(8, 11, 'option', 'optVal5', '2021-09-14 02:09:54', 5),
(9, 12, 'option', 'optVal1', '2021-09-14 02:11:38', 1),
(10, 12, 'option', 'optVal2', '2021-09-14 02:11:38', 2),
(11, 12, 'option', 'optVal3', '2021-09-14 02:11:38', 4),
(12, 12, 'option', 'optVal4', '2021-09-14 02:11:38', 3),
(13, 12, 'default_val', 'optVal4', '2021-09-14 02:11:38', 0),
(14, 12, 'option', 'optVal5', '2021-09-14 02:11:38', 5),
(15, 15, 'option', NULL, '2021-09-14 13:13:24', NULL),
(16, 16, 'option', '', '2021-09-14 13:36:30', 1),
(17, 16, 'option', '', '2021-09-14 13:36:30', 2),
(18, 18, 'option', 'Male', '2021-09-22 09:25:22', 1),
(19, 18, 'option', 'Female', '2021-09-22 09:25:22', 2),
(20, 18, 'option', 'Other', '2021-09-22 09:25:22', 3),
(21, 19, 'option', 'Male', '2021-09-22 09:25:54', 1),
(22, 19, 'option', 'Female', '2021-09-22 09:25:54', 2),
(23, 19, 'option', 'Other', '2021-09-22 09:25:54', 3),
(24, 39, 'option', 'ml', '2021-09-27 13:57:47', 1),
(25, 39, 'default_val', 'ml', '2021-09-27 13:57:47', 0),
(26, 39, 'option', 'l', '2021-09-27 13:57:47', 2);

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

--
-- Table structure for table `dynamic_forms`
--

CREATE TABLE `dynamic_forms` (
  `id` int(11) NOT NULL,
  `form_name` varchar(255) DEFAULT NULL,
  `form_code` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `form_html` longtext DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `modified_at` datetime DEFAULT NULL,
  `is_system` enum('0','1') DEFAULT '0',
  `is_deleted` enum('0','1') DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `dynamic_panels`
--

CREATE TABLE `dynamic_panels` (
  `id` int(11) NOT NULL,
  `panel_name` varchar(255) DEFAULT NULL,
  `panel_code` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `modified_at` datetime DEFAULT NULL,
  `is_system` enum('0','1') DEFAULT '0',
  `is_deleted` enum('0','1') DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `dynamic_panels`
--

INSERT INTO `dynamic_panels` (`id`, `panel_name`, `panel_code`, `description`, `created_at`, `modified_at`, `is_system`, `is_deleted`) VALUES
(1, 'panel nm', 'panelCd', 'despo', '2021-09-23 12:04:02', NULL, '0', '0'),
(2, 'panel nm', 'panelCd', 'despo', '2021-09-23 12:04:26', NULL, '0', '0'),
(3, 'panel Test', 'PT', 'des', '2021-09-23 12:10:35', NULL, '0', '0'),
(4, 'panelTest', 'tp', 'des', '2021-09-23 12:25:59', NULL, '0', '0'),
(5, 'Testing Panel', 'tingP', 'descri', '2021-09-23 12:29:28', NULL, '0', '0'),
(6, 'dhvfbj', 'lsrfigjo', 'BLF', '2021-09-24 09:08:24', NULL, '0', '0'),
(7, 'DLVCFNALS', 'SGJSJG', 'LFDGL', '2021-09-24 09:08:52', NULL, '0', '0'),
(8, 'dlknhvolas', 'DLNVLDNvlfbnvldnf', 'fclbnflnn', '2021-09-24 09:23:18', NULL, '0', '0');

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

--
-- Table structure for table `dynamic_panel_mapping`
--

CREATE TABLE `dynamic_panel_mapping` (
  `id` int(11) NOT NULL,
  `panel_id` int(11) DEFAULT NULL,
  `child_id` int(11) DEFAULT NULL,
  `child_type` varchar(255) DEFAULT NULL,
  `serial` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `dynamic_panel_mapping`
--

INSERT INTO `dynamic_panel_mapping` (`id`, `panel_id`, `child_id`, `child_type`, `serial`) VALUES
(1, 3, 32, 'fld', 1),
(2, 3, 35, 'fld', 2),
(3, 3, 1, 'fldGrp', 3),
(4, 3, 28, 'fld', 4),
(5, 3, 22, 'fld', 5),
(6, 3, 20, 'fld', 6),
(7, 3, 5, 'fldGrp', 7),
(8, 3, 7, 'fldGrp', 8),
(9, 3, 31, 'fld', 9),
(10, 3, 2, 'fld', 10),
(11, 3, 1, 'fld', 11),
(12, 3, 8, 'fldGrp', 12),
(13, 3, 9, 'fldGrp', 13),
(14, 3, 14, 'fld', 14),
(15, 3, 15, 'fld', 15),
(16, 3, 16, 'fld', 16),
(17, 3, 13, 'fld', 17),
(18, 3, 3, 'fld', 18),
(19, 3, 17, 'fld', 19),
(20, 3, 18, 'fld', 20),
(21, 3, 19, 'fld', 21),
(22, 3, 36, 'fld', 22),
(23, 3, 23, 'fld', 23),
(24, 4, 5, 'fldGrp', 1),
(25, 4, 7, 'fldGrp', 2),
(26, 4, 31, 'fld', 3),
(27, 4, 2, 'fld', 4),
(28, 4, 1, 'fld', 17),
(29, 4, 8, 'fldGrp', 6),
(30, 4, 9, 'fldGrp', 7),
(31, 4, 14, 'fld', 8),
(32, 4, 15, 'fld', 9),
(33, 4, 16, 'fld', 10),
(34, 4, 13, 'fld', 11),
(35, 4, 3, 'fld', 12),
(36, 4, 17, 'fld', 13),
(37, 4, 18, 'fld', 14),
(38, 4, 19, 'fld', 15),
(39, 4, 36, 'fld', 16),
(40, 4, 23, 'fld', 5),
(41, 4, 30, 'fld', 18),
(42, 4, 21, 'fld', 19),
(43, 4, 24, 'fld', 20),
(44, 4, 33, 'fld', 21),
(45, 4, 37, 'fld', 22),
(46, 4, 38, 'fld', 23),
(47, 4, 2, 'fldGrp', 24),
(48, 4, 7, 'fld', 25),
(49, 4, 8, 'fld', 26),
(50, 4, 9, 'fld', 27),
(51, 4, 10, 'fld', 28),
(52, 4, 11, 'fld', 29),
(53, 4, 12, 'fld', 30),
(54, 4, 6, 'fldGrp', 31),
(55, 4, 4, 'fld', 32),
(56, 5, 5, 'fldGrp', 1),
(57, 5, 7, 'fldGrp', 2),
(58, 5, 31, 'fld', 3),
(59, 5, 2, 'fld', 4),
(60, 5, 1, 'fld', 5),
(61, 5, 8, 'fldGrp', 6),
(62, 5, 9, 'fldGrp', 7),
(63, 5, 14, 'fld', 8),
(64, 5, 15, 'fld', 9),
(65, 5, 16, 'fld', 10),
(66, 5, 13, 'fld', 11),
(67, 5, 3, 'fld', 12),
(68, 5, 17, 'fld', 13),
(69, 5, 18, 'fld', 14),
(70, 5, 19, 'fld', 15),
(71, 5, 36, 'fld', 16),
(72, 5, 23, 'fld', 17),
(73, 5, 30, 'fld', 18),
(74, 6, 32, 'fld', 1),
(75, 6, 35, 'fld', 2),
(76, 6, 1, 'fldGrp', 3),
(77, 6, 28, 'fld', 4),
(78, 6, 22, 'fld', 5),
(79, 6, 20, 'fld', 6),
(80, 6, 5, 'fldGrp', 7),
(81, 6, 7, 'fldGrp', 8),
(82, 7, 32, 'undefined', 1),
(83, 7, 32, 'undefined', 2),
(84, 7, 35, 'undefined', 3),
(85, 7, 35, 'undefined', 4),
(86, 7, 28, 'undefined', 5),
(87, 7, 28, 'undefined', 6),
(88, 8, 32, 'fld', 1),
(89, 8, 35, 'fld', 2),
(90, 8, 1, 'fldGrp', 3),
(91, 8, 28, 'fld', 4),
(92, 8, 22, 'fld', 5),
(93, 8, 20, 'fld', 6),
(94, 9, 6, NULL, 1),
(95, 9, 8, NULL, 2),
(96, 9, 7, NULL, 3),
(97, 9, 1, NULL, 4),
(98, 9, 2, NULL, 5),
(99, 10, 6, NULL, 1),
(100, 10, 8, NULL, 2),
(101, 10, 7, NULL, 3),
(102, 10, 1, NULL, 4),
(103, 10, 2, NULL, 5),
(104, 11, 9, NULL, 1),
(105, 11, 10, NULL, 2),
(106, 11, 6, NULL, 3),
(107, 11, 8, NULL, 4),
(108, 11, 7, NULL, 5);

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

--
-- Table structure for table `dynamic_tabs`
--

CREATE TABLE `dynamic_tabs` (
  `id` int(11) NOT NULL,
  `tab_name` varchar(255) DEFAULT NULL,
  `tab_code` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `modified_at` datetime DEFAULT NULL,
  `is_system` enum('0','1') DEFAULT '0',
  `is_deleted` enum('0','1') DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `dynamic_tabs`
--

INSERT INTO `dynamic_tabs` (`id`, `tab_name`, `tab_code`, `description`, `created_at`, `modified_at`, `is_system`, `is_deleted`) VALUES
(1, 'hoga kuch', 'kuchVi', NULL, '2021-09-24 10:30:16', NULL, '0', '0'),
(2, 'asdkjufuhbk', 'kdbfkdjb', 'ldfdjn', '2021-09-24 10:32:19', NULL, '0', '0'),
(3, 'aflbcjadskuvcfhb', 'ljdflksnvl', 'lkjbgfkjngvl;', '2021-09-24 10:33:17', NULL, '0', '0'),
(4, 'admhvb', 'sflvn', 'fslgvn', '2021-09-24 11:51:39', NULL, '0', '0');

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

--
-- Table structure for table `dynamic_tab_mapping`
--

CREATE TABLE `dynamic_tab_mapping` (
  `id` int(11) NOT NULL,
  `tab_id` int(11) DEFAULT NULL,
  `child_id` int(11) DEFAULT NULL,
  `serial` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `dynamic_tab_mapping`
--

INSERT INTO `dynamic_tab_mapping` (`id`, `tab_id`, `child_id`, `serial`) VALUES
(1, 1, 9, 3),
(2, 1, 10, 2),
(3, 1, 11, 5),
(4, 1, 6, 4),
(5, 1, 8, 1),
(6, 1, 7, 6),
(7, 2, 9, 1),
(8, 2, 10, 2),
(9, 2, 11, 3),
(10, 2, 6, 4),
(11, 2, 8, 5),
(12, 3, 9, 1),
(13, 3, 10, 2),
(14, 3, 11, 3),
(15, 3, 6, 4),
(16, 3, 8, 5),
(17, 3, 7, 6),
(18, 3, 1, 7),
(19, 3, 2, 8),
(20, 4, 9, 1),
(21, 4, 10, 2),
(22, 4, 11, 3),
(23, 4, 6, 4),
(24, 4, 8, 5),
(25, 4, 7, 6);

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

--
-- Table structure for table `groups`
--

CREATE TABLE `groups` (
  `id` mediumint(8) UNSIGNED NOT NULL,
  `name` varchar(20) NOT NULL,
  `description` varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `groups`
--

INSERT INTO `groups` (`id`, `name`, `description`) VALUES
(1, 'admin', 'Administrator'),
(2, 'Member', 'genrale user');

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

--
-- Table structure for table `group_perm`
--

CREATE TABLE `group_perm` (
  `id` int(10) NOT NULL,
  `group_id` int(10) NOT NULL,
  `perm_id` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `group_perm`
--

INSERT INTO `group_perm` (`id`, `group_id`, `perm_id`) VALUES
(1, 1, 1),
(2, 1, 2),
(3, 1, 3),
(4, 1, 4),
(5, 1, 5);

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

--
-- Table structure for table `login_attempts`
--

CREATE TABLE `login_attempts` (
  `id` int(11) UNSIGNED NOT NULL,
  `ip_address` varchar(15) NOT NULL,
  `login` varchar(100) NOT NULL,
  `time` int(11) UNSIGNED DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `lookups`
--

CREATE TABLE `lookups` (
  `id` int(11) NOT NULL,
  `lookup_code` varchar(50) NOT NULL,
  `description` varchar(500) DEFAULT NULL,
  `is_shortcode_value_required` varchar(1) DEFAULT 'Y',
  `is_dependent` varchar(1) DEFAULT 'Y',
  `dep_parent_lookups_id` int(11) NOT NULL,
  `is_active` varchar(1) DEFAULT 'Y',
  `created_at` datetime NOT NULL,
  `created_by` varchar(50) NOT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `lookups`
--

INSERT INTO `lookups` (`id`, `lookup_code`, `description`, `is_shortcode_value_required`, `is_dependent`, `dep_parent_lookups_id`, `is_active`, `created_at`, `created_by`, `updated_at`, `updated_by`) VALUES
(1, 'APP_PARAM', 'Application Parameters', 'Y', 'N', 0, 'Y', '0000-00-00 00:00:00', '2021-09-09 16:05:04', NULL, NULL),
(2, 'PATIENT_TYPE', 'Type of Patient', 'Y', 'N', 0, 'Y', '0000-00-00 00:00:00', '2021-09-09 16:07:49', NULL, NULL),
(3, 'TITLE_TYPE', 'Type of Titles', 'Y', 'N', 0, 'Y', '0000-00-00 00:00:00', '2021-09-09 16:07:49', NULL, NULL),
(4, 'GENDER_TYPE', 'Types of Gender', 'Y', 'N', 0, 'Y', '0000-00-00 00:00:00', '2021-09-09 16:08:37', NULL, NULL),
(5, 'CONTACT_TYPE', 'Type of contact', 'Y', 'N', 0, 'Y', '0000-00-00 00:00:00', '2021-09-09 16:12:17', NULL, NULL),
(6, 'MAST_DOC_ID_TYPE', 'Type of Master Document and IDs', 'Y', 'N', 0, 'Y', '0000-00-00 00:00:00', '2021-09-09 16:17:15', NULL, NULL),
(7, 'DOC_ID_TYPE', 'Type of Document and IDs', 'Y', 'Y', 6, 'Y', '0000-00-00 00:00:00', '2021-09-09 16:18:07', NULL, NULL),
(8, 'RELATION_TYPE', 'Type of relation', 'Y', 'N', 0, 'Y', '0000-00-00 00:00:00', '2021-09-09 16:20:51', NULL, NULL),
(9, 'MARITAL_STATUS', 'Type of Marital Status', 'Y', 'N', 0, 'Y', '0000-00-00 00:00:00', '2021-09-09 18:29:17', NULL, NULL),
(10, 'ADDRESS_TYPE', 'Type of addresses', 'Y', 'N', 0, 'Y', '0000-00-00 00:00:00', '2021-09-09 18:32:00', NULL, NULL);

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

--
-- Table structure for table `lookup_values`
--

CREATE TABLE `lookup_values` (
  `id` int(11) NOT NULL,
  `lookup_id` int(11) NOT NULL,
  `short_code` varchar(50) NOT NULL,
  `description` varchar(500) NOT NULL,
  `dep_parent_lookup_value_id` int(11) DEFAULT NULL,
  `is_active` varchar(1) DEFAULT 'Y',
  `created_at` datetime NOT NULL,
  `created_by` varchar(50) NOT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `lookup_values`
--

INSERT INTO `lookup_values` (`id`, `lookup_id`, `short_code`, `description`, `dep_parent_lookup_value_id`, `is_active`, `created_at`, `created_by`, `updated_at`, `updated_by`) VALUES
(1, 2, 'GP', 'General Patient', NULL, 'Y', '2021-09-09 18:06:24', '', NULL, NULL),
(2, 2, 'FP', 'Foreign Patient', NULL, 'Y', '2021-09-09 18:06:24', '', NULL, NULL),
(3, 2, 'EP', 'Employee As Patient', NULL, 'Y', '2021-09-09 18:06:24', '', NULL, NULL),
(4, 2, 'ED', 'Employee As Dependent', NULL, 'Y', '2021-09-09 18:06:24', '', NULL, NULL),
(5, 2, 'CP', 'Corporate Patient', NULL, 'Y', '2021-09-09 18:06:24', '', NULL, NULL),
(6, 4, 'Mr', 'Mr.', NULL, 'Y', '2021-09-09 18:23:44', '', NULL, NULL),
(7, 4, 'Mrs', 'Mrs.', NULL, 'Y', '2021-09-09 18:23:44', '', NULL, NULL),
(8, 4, 'Miss', 'Miss.', NULL, 'Y', '2021-09-09 18:23:44', '', NULL, NULL),
(9, 4, 'Master', 'Master.', NULL, 'Y', '2021-09-09 18:23:45', '', NULL, NULL),
(10, 4, 'Baby', 'Baby', NULL, 'Y', '2021-09-09 18:23:45', '', NULL, NULL),
(11, 3, 'M', 'Male', NULL, 'Y', '2021-09-09 18:23:53', '', NULL, NULL),
(12, 3, 'F', 'Female', NULL, 'Y', '2021-09-09 18:23:53', '', NULL, NULL),
(13, 3, 'S', 'Single', NULL, 'Y', '2021-09-09 18:24:00', '', NULL, NULL),
(16, 10, 'P', 'Present Address', NULL, 'Y', '2021-09-09 18:32:41', '', NULL, NULL),
(22, 8, 'F', 'Father', NULL, 'Y', '2021-09-09 18:45:09', '', NULL, NULL),
(23, 8, 'M', 'Mother', NULL, 'Y', '2021-09-09 18:45:09', '', NULL, NULL),
(24, 8, 'W', 'Wife', NULL, 'Y', '2021-09-09 18:45:09', '', NULL, NULL),
(25, 8, 'S', 'Son', NULL, 'Y', '2021-09-09 18:45:09', '', NULL, NULL),
(26, 8, 'D', 'Daughter', NULL, 'Y', '2021-09-09 18:45:09', '', NULL, NULL),
(27, 8, 'R', 'Friend', NULL, 'Y', '2021-09-09 18:45:09', '', NULL, NULL),
(28, 8, 'O', 'Other', NULL, 'Y', '2021-09-09 18:45:09', '', NULL, NULL),
(29, 10, 'M', 'Parmanent Address', NULL, 'Y', '2021-09-09 18:45:35', '', NULL, NULL),
(30, 5, 'M', 'Mobile', NULL, 'Y', '2021-09-09 18:47:37', '', NULL, NULL),
(31, 5, 'MO', 'Mobile 2', NULL, 'Y', '2021-09-09 18:47:37', '', NULL, NULL),
(32, 5, 'LP', 'Land Phone', NULL, 'Y', '2021-09-09 18:47:37', '', NULL, NULL),
(33, 5, 'OP', 'Office Phone', NULL, 'Y', '2021-09-09 18:47:38', '', NULL, NULL),
(34, 5, 'E', 'EMail', NULL, 'Y', '2021-09-09 18:47:38', '', NULL, NULL),
(35, 6, 'ID', 'ID Proof', NULL, 'Y', '2021-09-10 11:29:46', '', NULL, NULL),
(36, 6, 'DOC', 'Other Document', NULL, 'Y', '2021-09-10 11:29:46', '', NULL, NULL),
(37, 6, 'IMG', 'IMAGE', NULL, 'Y', '2021-09-10 11:29:46', '', NULL, NULL),
(38, 7, 'ID_VC', 'Voter Card', 35, 'Y', '2021-09-10 12:44:59', '', NULL, NULL),
(39, 7, 'ID_PAN', 'PAN CARD', 35, 'Y', '2021-09-10 12:44:59', '', NULL, NULL),
(40, 7, 'ID_AADHAR', 'AADHAR', 35, 'Y', '2021-09-10 12:44:59', '', NULL, NULL),
(41, 7, 'ID_PASSPORT', 'PASSPORT', 35, 'Y', '2021-09-10 12:44:59', '', NULL, NULL),
(42, 7, 'ID_DVL', 'DRIVING LICENCE', 35, 'Y', '2021-09-10 12:44:59', '', NULL, NULL),
(43, 7, 'ID_DOC_PRES', 'Prescription', 36, 'Y', '2021-09-10 13:10:04', '', NULL, NULL),
(44, 7, 'ID_DOC_CH', 'Case History', 36, 'Y', '2021-09-10 13:10:04', '', NULL, NULL),
(45, 7, 'ID_DOC_OD', 'Other Docs', 36, 'Y', '2021-09-10 13:10:04', '', NULL, NULL),
(46, 7, 'ID_DOC_PH', 'User Picture', 37, 'Y', '2021-09-10 13:10:04', '', NULL, NULL),
(47, 7, 'ID_DOC_OI', 'Other Images', 37, 'Y', '2021-09-10 13:10:04', '', NULL, NULL);

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

--
-- Table structure for table `mm_field_types`
--

CREATE TABLE `mm_field_types` (
  `id` int(11) NOT NULL,
  `field` varchar(255) DEFAULT NULL,
  `status` enum('Y','N') DEFAULT NULL,
  `is_filterable` enum('Y','N') DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



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

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `perm_id` int(10) UNSIGNED NOT NULL,
  `perm_name` varchar(255) NOT NULL,
  `perm_icon` text DEFAULT NULL,
  `perm_link` text DEFAULT NULL,
  `perm_sort` int(10) DEFAULT 1,
  `dynamic_form_enabled` enum('0','1') DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` (`perm_id`, `perm_name`, `perm_icon`, `perm_link`, `perm_sort`, `dynamic_form_enabled`) VALUES
(1, 'Configaration', NULL, NULL, 1, '0'),
(2, 'Human Resource', NULL, NULL, 2, '0'),
(3, 'OPD', NULL, NULL, 4, '1'),
(4, 'IPD', NULL, NULL, 3, '1'),
(5, 'Ragistration', NULL, NULL, 5, '1');

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

--
-- Table structure for table `permission_components`
--

CREATE TABLE `permission_components` (
  `perm_comp_id` int(10) NOT NULL,
  `perm_sub_id` int(10) DEFAULT NULL,
  `perm_comp_name` varchar(100) DEFAULT NULL,
  `perm_comp_view` enum('0','1') DEFAULT '1',
  `perm_comp_add` enum('0','1') DEFAULT '1',
  `perm_comp_edit` enum('0','1') DEFAULT '1',
  `perm_comp_delete` enum('0','1') DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `permission_submodules`
--

CREATE TABLE `permission_submodules` (
  `perm_sub_id` int(10) NOT NULL,
  `perm_id` int(10) DEFAULT NULL,
  `perm_sub_name` varchar(100) DEFAULT '',
  `perm_sub_icon` text DEFAULT NULL,
  `perm_sub_link` text DEFAULT NULL,
  `perm_sub_sort` int(10) DEFAULT NULL,
  `parent` int(10) DEFAULT 0,
  `show_in_menu` enum('0','1') NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `permission_submodules`
--

INSERT INTO `permission_submodules` (`perm_sub_id`, `perm_id`, `perm_sub_name`, `perm_sub_icon`, `perm_sub_link`, `perm_sub_sort`, `parent`, `show_in_menu`) VALUES
(1, 1, 'settings', NULL, NULL, 1, 0, '0'),
(2, 1, 'genaral settings', NULL, NULL, 1, 1, '0'),
(3, 1, 'roles permission', NULL, 'users/User_groups', 2, 1, '0'),
(4, 2, 'staff', NULL, 'human_resource/staff', NULL, 0, '0'),
(5, 3, 'OPD Visit', NULL, 'opd/opd_visit', NULL, 0, '0'),
(6, 1, 'Dynamic Form Settings', NULL, NULL, 1, 0, '0'),
(7, 1, 'Dynamic Field', NULL, 'common/configuration/dynamic_form', 1, 6, '0'),
(8, 1, 'Dynamic Field Group', NULL, 'common/configuration/dynamic_form/dynamicFieldGroup', 1, 6, '0'),
(9, 1, 'Dynamic Panel', NULL, 'common/configuration/dynamic_form/dynamicPanel', 1, 6, '0'),
(10, 1, 'Dynamic Tab', NULL, 'common/configuration/dynamic_form/dynamicTab', 1, 6, '0'),
(11, 1, 'Dynamic Form', NULL, 'common/configuration/dynamic_form/dynamicForm', 1, 6, '0');

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` int(11) NOT NULL,
  `registration_status` tinyint(4) NOT NULL,
  `forgot_pass_status` tinyint(4) NOT NULL,
  `socail_login_status` tinyint(4) NOT NULL,
  `two_factor_auth` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `registration_status`, `forgot_pass_status`, `socail_login_status`, `two_factor_auth`) VALUES
(1, 1, 1, 1, 0);

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

--
-- Table structure for table `users_groups`
--

CREATE TABLE `users_groups` (
  `id` int(11) UNSIGNED NOT NULL,
  `user_id` int(11) UNSIGNED NOT NULL,
  `group_id` mediumint(8) UNSIGNED NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `users_groups`
--

INSERT INTO `users_groups` (`id`, `user_id`, `group_id`) VALUES
(351, 1, 1);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `blog_categories`
--
ALTER TABLE `blog_categories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `blog_post`
--
ALTER TABLE `blog_post`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `blog_post_tags`
--
ALTER TABLE `blog_post_tags`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `blog_settings`
--
ALTER TABLE `blog_settings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `blog_tags`
--
ALTER TABLE `blog_tags`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `captcha`
--
ALTER TABLE `captcha`
  ADD PRIMARY KEY (`captcha_id`),
  ADD KEY `word` (`word`);

--
-- Indexes for table `dynamic_field_group_items`
--
ALTER TABLE `dynamic_field_group_items`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `dynamic_field_grp_mapping`
--
ALTER TABLE `dynamic_field_grp_mapping`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `dynamic_field_items`
--
ALTER TABLE `dynamic_field_items`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `dynamic_field_item_attr`
--
ALTER TABLE `dynamic_field_item_attr`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `dynamic_forms`
--
ALTER TABLE `dynamic_forms`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `dynamic_panels`
--
ALTER TABLE `dynamic_panels`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `dynamic_panel_mapping`
--
ALTER TABLE `dynamic_panel_mapping`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `dynamic_tabs`
--
ALTER TABLE `dynamic_tabs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `dynamic_tab_mapping`
--
ALTER TABLE `dynamic_tab_mapping`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `groups`
--
ALTER TABLE `groups`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `group_perm`
--
ALTER TABLE `group_perm`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `login_attempts`
--
ALTER TABLE `login_attempts`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `lookups`
--
ALTER TABLE `lookups`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD UNIQUE KEY `lookup_code` (`lookup_code`) USING BTREE;

--
-- Indexes for table `lookup_values`
--
ALTER TABLE `lookup_values`
  ADD PRIMARY KEY (`id`) USING BTREE;

--
-- Indexes for table `mm_field_types`
--
ALTER TABLE `mm_field_types`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `permissions`
--
ALTER TABLE `permissions`
  ADD PRIMARY KEY (`perm_id`);

--
-- Indexes for table `permission_components`
--
ALTER TABLE `permission_components`
  ADD PRIMARY KEY (`perm_comp_id`);

--
-- Indexes for table `permission_submodules`
--
ALTER TABLE `permission_submodules`
  ADD PRIMARY KEY (`perm_sub_id`);

--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `users_groups`
--
ALTER TABLE `users_groups`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uc_users_groups` (`user_id`,`group_id`),
  ADD KEY `fk_users_groups_users1_idx` (`user_id`),
  ADD KEY `fk_users_groups_groups1_idx` (`group_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `blog_categories`
--
ALTER TABLE `blog_categories`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `blog_post`
--
ALTER TABLE `blog_post`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `blog_post_tags`
--
ALTER TABLE `blog_post_tags`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=56;

--
-- AUTO_INCREMENT for table `blog_settings`
--
ALTER TABLE `blog_settings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `blog_tags`
--
ALTER TABLE `blog_tags`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `captcha`
--
ALTER TABLE `captcha`
  MODIFY `captcha_id` bigint(13) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=156;

--
-- AUTO_INCREMENT for table `dynamic_field_group_items`
--
ALTER TABLE `dynamic_field_group_items`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `dynamic_field_grp_mapping`
--
ALTER TABLE `dynamic_field_grp_mapping`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=78;

--
-- AUTO_INCREMENT for table `dynamic_field_items`
--
ALTER TABLE `dynamic_field_items`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=40;

--
-- AUTO_INCREMENT for table `dynamic_field_item_attr`
--
ALTER TABLE `dynamic_field_item_attr`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;

--
-- AUTO_INCREMENT for table `dynamic_forms`
--
ALTER TABLE `dynamic_forms`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `dynamic_panels`
--
ALTER TABLE `dynamic_panels`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `dynamic_panel_mapping`
--
ALTER TABLE `dynamic_panel_mapping`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=109;

--
-- AUTO_INCREMENT for table `dynamic_tabs`
--
ALTER TABLE `dynamic_tabs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `dynamic_tab_mapping`
--
ALTER TABLE `dynamic_tab_mapping`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;

--
-- AUTO_INCREMENT for table `groups`
--
ALTER TABLE `groups`
  MODIFY `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=56;

--
-- AUTO_INCREMENT for table `group_perm`
--
ALTER TABLE `group_perm`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `login_attempts`
--
ALTER TABLE `login_attempts`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `lookups`
--
ALTER TABLE `lookups`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `lookup_values`
--
ALTER TABLE `lookup_values`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=48;

--
-- AUTO_INCREMENT for table `mm_field_types`
--
ALTER TABLE `mm_field_types`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT for table `permissions`
--
ALTER TABLE `permissions`
  MODIFY `perm_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `permission_components`
--
ALTER TABLE `permission_components`
  MODIFY `perm_comp_id` int(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `permission_submodules`
--
ALTER TABLE `permission_submodules`
  MODIFY `perm_sub_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `users_groups`
--
ALTER TABLE `users_groups`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=352;
COMMIT;

