1revivelf_db.sql
-- phpMyAdmin SQL Dump -- version 4.9.5 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Jun 26, 2020 at 08:39 AM -- Server version: 5.7.30 -- PHP Version: 7.3.6 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `revivelf_db` -- -- -------------------------------------------------------- -- -- Table structure for table `tbl_admin` -- CREATE TABLE `tbl_admin` ( `admin_id` int(11) NOT NULL, `email_id` varchar(255) NOT NULL, `pwd` varchar(255) NOT NULL, `date_time_added` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_admin` -- INSERT INTO `tbl_admin` (`admin_id`, `email_id`, `pwd`, `date_time_added`) VALUES (1, 'minalnpanchal@gmail.com', 'E6E061838856BF47E1DE730719FB2609', '14-11-2018'); -- -------------------------------------------------------- -- -- Table structure for table `tbl_blog` -- CREATE TABLE `tbl_blog` ( `blog_id` int(11) NOT NULL, `title` varchar(255) NOT NULL, `description` varchar(1000) NOT NULL, `blog_image` varchar(500) NOT NULL, `date_time_added` varchar(255) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_blog` -- INSERT INTO `tbl_blog` (`blog_id`, `title`, `description`, `blog_image`, `date_time_added`) VALUES (5, 'Don\'t wait to repair your body only after it breaks down', '<p>Restore your body's natural balance by treating the body as a whole -- mind, body, and spirit. After all, good health is much more than the absence of disease.</p>\r\n\r\n<p>Diet therapy takes into account many factors that influence the current state of health. These include diet, activity levels, medical history, stress level, environment, and family history. A suitable dietary program is then recommended to attain good health.</p>\r\n\r\n<p>Call For Free Advice - 92272 56328</p>\r\n\r\n<p>Dt. MINAL N. PANCHAL<br />\r\nM.Sc. (DFSM), MYASc. (Yoga), PGDPNCE<br />\r\nConsultant Dietitian, Yoga Therapist<br />\r\nand Garbhsanskar #Specialist<br />\r\nLife Member of Indian Dietetic Association</p>\r\n', 'uploads/blog/blog_image306891-14-02-2020-blog1.jpg', '14-02-2020'), (6, 'Garbh Sanskar', '<h6><strong>Benefits of Garbh Sanskar during Pregnancy</strong></h6>\r\n\r\n<p> </p>\r\n\r\n<p style=\"margin-left:40px\"><strong> </strong>Hepls The Mother To Shape Up Her First Impression Of The Baby </p>\r\n\r\n<p style=\"margin-left:40px\"><strong> </strong>Possitive Thinking And Possitive Attitude Goes a Long Way In Ensuring The Mental And Physical Well-Being of the mother, Which Result To The Well-Being Of The Baby Inside Her Womb As Well </p>\r\n\r\n<h6><strong>Call For Free Advice - 92272 56328 </strong></h6>\r\n\r\n<div> </div>\r\n\r\n<h6>Dt. MINAL N. PANCHAL<br />\r\nM.Sc. (DFSM), MYASc. (Yoga), <br />\r\nPGDPNCE Consultant Dietitian, <br />\r\nYoga Therapist and Garbhsanskar Specialist<br />\r\nLife Member of Indian Dietetic Association</h6>\r\n', 'uploads/blog/blog_image590756-14-02-2020-blog2.jpg', '14-02-2020'); -- -------------------------------------------------------- -- -- Table structure for table `tbl_blog_image` -- CREATE TABLE `tbl_blog_image` ( `blog_image_id` int(11) NOT NULL, `blog_id` int(11) NOT NULL, `blog_sub_image` varchar(500) NOT NULL, `date_time_added` varchar(255) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_blog_image` -- INSERT INTO `tbl_blog_image` (`blog_image_id`, `blog_id`, `blog_sub_image`, `date_time_added`) VALUES (8, 2, 'uploads/blog_sub/blog_sub_image327525-08-01-2019-DSCN9844.jpg', '08-01-2019'), (9, 2, 'uploads/blog_sub/blog_sub_image906062-08-01-2019-DSCN9845.jpg', '08-01-2019'), (4, 1, 'uploads/blog_sub/blog_sub_image478915-08-01-2019-DSCN9846.jpg', '08-01-2019'), (7, 1, 'uploads/blog_sub/blog_sub_image617859-08-01-2019-MINAL in Vidhyanagar Lab.jpg', '08-01-2019'), (6, 1, 'uploads/blog_sub/blog_sub_image108755-08-01-2019-DSCN9850.jpg', '08-01-2019'), (10, 2, 'uploads/blog_sub/blog_sub_image491918-08-01-2019-DSCN9846.jpg', '08-01-2019'), (11, 3, 'uploads/blog_sub/blog_sub_image131901-08-01-2019-DSCN9847.jpg', '08-01-2019'), (12, 3, 'uploads/blog_sub/blog_sub_image831980-08-01-2019-DSCN9848.jpg', '08-01-2019'), (13, 3, 'uploads/blog_sub/blog_sub_image400728-08-01-2019-DSCN9849.jpg', '08-01-2019'); -- -------------------------------------------------------- -- -- Table structure for table `tbl_certificate` -- CREATE TABLE `tbl_certificate` ( `certificate_id` int(11) NOT NULL, `title` varchar(255) NOT NULL, `sub_title` varchar(255) NOT NULL, `image` varchar(255) NOT NULL, `description` varchar(1000) NOT NULL, `date_time_added` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_certificate` -- INSERT INTO `tbl_certificate` (`certificate_id`, `title`, `sub_title`, `image`, `description`, `date_time_added`) VALUES (22, 'Indian Dietetic Asociation', 'Gujarat Chapter since november 6 , 2012', 'uploads/certificate/certificate_image318594-06-02-2020-ci16.jpg', 'Indian Dietetic Asociation Gujarat Chapter since november 6 , 2012.', '20-02-2019'), (23, '2nd International workshop on Micronutrients and Child health', 'All India Institute of Madical Science', 'uploads/certificate/certificate_image143400-06-02-2020-ci13.jpg', '2nd International workshop on Micronutrients and Child health ,All India Institute of Madical Science', '20-02-2019'), (24, '1st rank on Master of yogic arts & science ', 'Gujarat Vidhyapith', 'uploads/certificate/certificate_image290758-05-02-2020-pramanpatr.jpg', '1st rank on Master of yogic arts & science from Gujarat Vidhyapith', '20-02-2019'), (25, 'Master of yogic arts & science', 'April 2018', 'uploads/certificate/certificate_image141822-05-02-2020-ci1.jpg', 'Master of yogic arts & science, April 2018', '20-02-2019'), (26, 'Master of yogic arts & science', 'April 2018', 'uploads/certificate/certificate_image786132-05-02-2020-ms of yo art and sci.jpg', 'Master of yogic arts & science ,Master of yogic arts & science', '20-02-2019'), (27, 'Yoga Teature\'s Training course June-2016.', 'Shree Divya Jivan Sanskruti Sangh Sivananda Ashram', 'uploads/certificate/certificate_image443768-05-02-2020-ci4.jpg', 'At Shree Divya Jivan Sanskruti Sangh Sivananda Ashram', '20-02-2019'), (28, 'Master of science in Dieteties and Food Services Management', 'Indira Gandhi National Open University', 'uploads/certificate/certificate_image393648-06-02-2020-certificate_image472203-20-02-2019-5.jpg', '1st Class in Master of science in Dieteties and Food Services Management , Indira Gandhi National Open University', '20-02-2019'), (29, 'Diploma in yogic', 'October 2013', 'uploads/certificate/certificate_image172619-06-02-2020-ci8.jpg', 'Diploma in yogic, October 2013', '20-02-2019'), (30, 'Appeciation cum Intership Completed letter', 'at Apollo Hospital International Ltd.', 'uploads/certificate/certificate_image842526-06-02-2020-apollo.jpg', 'Appeciation cum Intership Completed letter, at Apollo Hospital International Ltd.', '20-02-2019'), (31, 'Trainee Dietician', 'at BAPS Yogiji Maharaj Hospital', 'uploads/certificate/certificate_image114997-06-02-2020-certificate_image983696-20-02-2019-8.jpg', 'Trainee Dietician, at BAPS Yogiji Maharaj Hospital - March-2012 ', '20-02-2019'), (32, 'Diploma in Nutrition & Heath Education ', 'June 2010', 'uploads/certificate/certificate_image413556-06-02-2020-ci7.jpg', 'Passed Diploma in Nutrition & Heath Education on June 2010', '20-02-2019'), (33, 'Food & Nutrition ', 'Indira Gandhi National Open University', 'uploads/certificate/certificate_image845503-06-02-2020-ci6.jpg', 'Food & Nutrition , Indira Gandhi National Open University on Dec-2008', '20-02-2019'), (34, 'Nutrition & Child Care', 'Indira Gandhi National Open University', 'uploads/certificate/certificate_image776755-06-02-2020-ci10.jpg', 'Nutrition & Child Care from Indira Gandhi National Open University - June 2005', '20-02-2019'), (35, '2nd Class in BSC ', 'Maharaja Sayagirao University Of Baroda', 'uploads/certificate/certificate_image140124-06-02-2020-certificate_image850075-20-02-2019-12.jpg', 'Maharaja Sayagirao University Of Baroda', '20-02-2019'), (36, 'National Conference on Yog : An Integrative Life-Style ', 'Department of Yoga, Gujarat Vidyapith, Ahmedabad', 'uploads/certificate/certificate_image550809-06-02-2020-ci12.jpg', 'National Conference on Yog : An Integrative Life-Style ,Department of Yoga, Gujarat Vidyapith, Ahmedabad - June 2015', '20-02-2019'), (37, 'Participate Diabetes, Cordiovascular diesases and Smoke prevention, Care and Control WorkShop', 'Diabetes, Cordiovascular diesases and Smoke prevention, Care and Control', 'uploads/certificate/certificate_image528251-06-02-2020-ci14.jpg', 'Participate Diabetes, Cordiovascular diesases and Smoke prevention, Care and Control WorkShop on Jan 2011', '20-02-2019'), (38, 'Participate Diabetes, Cordiovascular diesases and Smoke prevention, Care and Control WorkShop', 'Diabetes, Cordiovascular diesases and Smoke prevention, Care and Control', 'uploads/certificate/certificate_image945102-06-02-2020-ci15.jpg', 'Participate Diabetes, Cordiovascular diesases and Smoke prevention, Care and Control WorkShop on Nov 2010', '20-02-2019'), (39, 'National Seminar , Nutrigenomics', 'Organized by P G Department Of Home Science ', 'uploads/certificate/certificate_image751944-05-02-2020-nutricgonmoric.jpg', 'National Seminar , Nutrigenomics, Organized by P G Department Of Home Science - at Sardar Patel University, Vallabh Vidyanagar', '20-02-2019'), (40, 'Regional Diabetesindia Update 2010', 'Organized by Association of Physicians of Ahmedabad', 'uploads/certificate/certificate_image290401-05-02-2020-rdu.jpg', 'Regional Diabetesindia Update 2010, Organized by Association of Physicians of Ahmedabad', '20-02-2019'); -- -------------------------------------------------------- -- -- Table structure for table `tbl_event` -- CREATE TABLE `tbl_event` ( `event_id` int(11) NOT NULL, `event_title` varchar(255) NOT NULL, `event_description` varchar(1000) NOT NULL, `event_image` varchar(500) NOT NULL, `date_time_added` varchar(255) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_event` -- INSERT INTO `tbl_event` (`event_id`, `event_title`, `event_description`, `event_image`, `date_time_added`) VALUES (6, 'Seminars and workshops', 'Seminars and workshops in Government, private schools and collages are for the teaching and training of Nutritive and healthy Food Habits, Balance diet for children & Family, healthy breakfast in kids and making parents aware about it.', 'uploads/events/events_image128549-01-03-2019-WP_20170621_14_42_35_Pro.jpg', '01-03-2019'), (7, 'Lectures and counselling', 'Taking lectures are taken for providing awareness about Premenstrual syndrome, healthy menstrual cycle and menopause, along with taking yoga sessions and also diet counseling for s school going girls.', 'uploads/events/events_image722076-01-03-2019-352.JPG', '01-03-2019'); -- -------------------------------------------------------- -- -- Table structure for table `tbl_event_image` -- CREATE TABLE `tbl_event_image` ( `event_image_id` int(11) NOT NULL, `event_id` int(11) NOT NULL, `event_sub_image` varchar(500) NOT NULL, `date_time_added` varchar(255) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_event_image` -- INSERT INTO `tbl_event_image` (`event_image_id`, `event_id`, `event_sub_image`, `date_time_added`) VALUES (1, 1, 'uploads/events_sub/events_sub_image137190-07-01-2019-DSCN9843.jpg', '07-01-2019'), (2, 1, 'uploads/events_sub/events_sub_image708037-07-01-2019-DSCN9844.jpg', '07-01-2019'), (3, 1, 'uploads/events_sub/events_sub_image398824-07-01-2019-DSCN9845.jpg', '07-01-2019'), (4, 1, 'uploads/events_sub/events_sub_image494454-07-01-2019-DSCN9846.jpg', '07-01-2019'), (5, 1, 'uploads/events_sub/events_sub_image287380-07-01-2019-IMG_20180423_184706.jpg', '07-01-2019'), (6, 3, 'uploads/events_sub/events_sub_image992352-07-01-2019-IMG_20180423_184706.jpg', '07-01-2019'), (7, 3, 'uploads/events_sub/events_sub_image248964-07-01-2019-IMG_20180423_184751.jpg', '07-01-2019'), (8, 3, 'uploads/events_sub/events_sub_image418527-07-01-2019-IMG_20180423_184955.jpg', '07-01-2019'), (9, 3, 'uploads/events_sub/events_sub_image771601-07-01-2019-IMG_20180423_185448.jpg', '07-01-2019'), (10, 5, 'uploads/events_sub/events_sub_image568910-01-03-2019-25032.jpg', '01-03-2019'), (11, 6, 'uploads/events_sub/events_sub_image819729-01-03-2019-WP_20170801_13_54_33_Pro.jpg', '01-03-2019'), (12, 7, 'uploads/events_sub/events_sub_image435368-01-03-2019-WP_20170824_17_17_16_Pro.jpg', '01-03-2019'); -- -------------------------------------------------------- -- -- Table structure for table `tbl_ips` -- CREATE TABLE `tbl_ips` ( `id` int(100) NOT NULL, `ipAddress` varchar(255) NOT NULL, `status` varchar(255) NOT NULL, `date_time_added` varchar(255) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `tbl_order` -- CREATE TABLE `tbl_order` ( `order_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `address` varchar(1000) NOT NULL, `plan_id` int(11) NOT NULL, `weekly_plan_id` int(11) NOT NULL, `plan_duration` varchar(255) NOT NULL, `payment_type` varchar(255) NOT NULL, `order_status` int(11) NOT NULL, `payment_status` int(11) NOT NULL, `delivery_status` int(11) NOT NULL, `date_time_added` varchar(255) NOT NULL, `date_time_expired` varchar(255) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_order` -- INSERT INTO `tbl_order` (`order_id`, `user_id`, `address`, `plan_id`, `weekly_plan_id`, `plan_duration`, `payment_type`, `order_status`, `payment_status`, `delivery_status`, `date_time_added`, `date_time_expired`) VALUES (3, 12, 'vastraour ', 2, 4, '14', 'COD', 1, 1, 0, '2019-01-07', '2019-01-21'), (2, 11, '261, Vishal Nagar Society, Isanpur, Ahmedabad', 2, 4, '14', 'COD', 1, 1, 1, '2019-01-07', '2019-01-21'), (4, 12, 'dfdf', 3, 7, '7', 'COD', 1, 1, 0, '2019-01-07', '2019-01-14'); -- -------------------------------------------------------- -- -- Table structure for table `tbl_plan` -- CREATE TABLE `tbl_plan` ( `plan_id` int(11) NOT NULL, `plan_name` varchar(255) NOT NULL, `title` varchar(500) NOT NULL, `description` varchar(9000) NOT NULL, `plan_image` varchar(500) NOT NULL, `date_time_added` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_plan` -- INSERT INTO `tbl_plan` (`plan_id`, `plan_name`, `title`, `description`, `plan_image`, `date_time_added`) VALUES (2, 'Yoga', 'Yoga', '<p><em><strong>Yoga is for everyone! </strong></em></p>\r\n\r\n<p><em>Relaxing yoga classes – take time to make your soul happy</em></p>\r\n\r\n<p>At Revive, amidst the welcoming surrounding of our beautiful space you will not only feel revive and rejuvenated but you will also be able to hear your inner thoughts peacefully. </p>\r\n\r\n<p>It's time you experience natural, result-oriented tried and tested yoga exercises at its best. Whatever your goals, we’ll help you get your body in the desired shape for the things you need to do! Make yoga your happy place. Revive offers a wide array of yoga styles for people of every ability and preferences: </p>\r\n\r\n<ul style=\"margin-left:40px\">\r\n <li>- Beginners Yoga</li>\r\n <li>- Power Yoga </li>\r\n <li>- Experienced Yoga</li>\r\n <li>- Restorative Yoga </li>\r\n</ul>\r\n\r\n<p> </p>\r\n\r\n<p>We also organize interactive workshops to help you deepen your knowledge. Experience our varied treatments to help you relax and realigned with life<!--</p--></p>\r\n', 'uploads/plan/plan_image360698-26-02-2019-IMG-20161218-WA0024.jpg', '15-11-2018'), (3, 'Diet & Nutrition ', 'Diet & Nutrition ', '<p><br />\r\n<strong><em>Keep your body the best it can be, with eating healthy and exercising.</em></strong></p>\r\n\r\n<p><br />\r\nAt Revive, we help you get the body you have always resented through proper nutrition. Our nutrition therapy includes personalized support towards a greater understanding of your own body’s needs around diet and exercise. Get personalized nutrition advice from our experts who helps you crack the code to keep you healthy. </p>\r\n\r\n<p><br />\r\nJoin thousands of our customers who have rediscovered themselves from our scientifically designed nutritional program. <strong>Minal Panchal</strong> is the chief nutritionist at Revive who has the required certificates to help you with the specific diet plan as your body needs. </p>\r\n\r\n<p><br />\r\nShe provides important, confidential diet advice to meet your personal goals in combination with weight loss programs, how to take care during pre or post pregnancy, how and what to feed your child, specific diet plan to manage any medical condition or any sports diet chart. </p>\r\n\r\n<p><br />\r\n<strong>The comprehensive services offered at our center are: </strong></p>\r\n\r\n<ul style=\"margin-left:40px\">\r\n <li>- Low calorie diet </li>\r\n <li>- Meal plans </li>\r\n <li>- Weight loss programs </li>\r\n <li>- Healthy eating </li>\r\n <li>- Sports</li>\r\n <li>- Mother and baby</li>\r\n <li>- Medical condition </li>\r\n</ul>\r\n', 'uploads/plan/plan_image263587-06-02-2020-plan_image617833-27-02-2019-IMG_5808.jpg', '17-11-2018'), (5, 'Prenatal Care', 'Prenatal Care', '<p><strong><em>Offering Prenatal and Postnatal Yoga classes to keep you and your baby healthy!</em></strong></p>\r\n\r\n<p>Nurture a toned, healthy body while you reduce stress and connect with your baby with our prenatal and postnatal yoga classes. Our prenatal and postpartum involves treatments and trainings to ensure a healthy pre-pregnancy, pregnancy, and labor and delivery for mom and baby.Prenatal care ideally starts at least three months before you begin trying to conceive. Some healthy habits to follow during this period include:</p>\r\n\r\n<ul style=\"margin-left:40px\">\r\n <li>- Quitting smoking and drinking alcohol</li>\r\n <li>- Taking folic acid supplements daily (400 to 800 micrograms)</li>\r\n <li>- Talking to your doctor about your medical conditions, dietary supplements, and any over-the-counter or prescription drugs that you take</li>\r\n <li>- Avoiding all contact with toxic substances and chemicals at home or work that could be harmful</li>\r\n</ul>\r\n\r\n<p> </p>\r\n\r\n<p><strong>Benefits of Prenatal care:</strong></p>\r\n\r\n<ul style=\"margin-left:40px\">\r\n <li>- Helps calm mind and reduce stress</li>\r\n <li>- Increases stamina and strength</li>\r\n <li>- Spend time connecting with your body and your baby</li>\r\n <li>- Relieves muscular tension</li>\r\n <li>- Helps you find balance both physically and emotionally</li>\r\n</ul>\r\n\r\n<p> </p>\r\n', 'uploads/plan/plan_image726109-05-02-2020-planB.jpg', '21-01-2019'), (6, 'Garbh Sankskar', 'Garbh Sanskar during Pregnancy', '<p>Don't wait to repair your body only after it breaks down. Pay attention to what it is telling you. Restore your body's natural balance by treating the body as a whole -- mind, body, and spirit. After all, good health is much more than the absence of disease. Diet therapy takes into account many factors that influence the current state of health. These include diet, activity levels, medical history, stress level, environment, and family history. A suitable dietary program is then recommended to attain good health.</p>\r\n', 'uploads/plan/plan_image534720-13-02-2020-man-woman-with-ultrasound_23-2147793273.jpg', '13-02-2020'); -- -------------------------------------------------------- -- -- Table structure for table `tbl_plan_image` -- CREATE TABLE `tbl_plan_image` ( `plan_image_id` int(11) NOT NULL, `plan_id` int(11) NOT NULL, `plan_sub_image` varchar(500) NOT NULL, `date_time_added` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_plan_image` -- INSERT INTO `tbl_plan_image` (`plan_image_id`, `plan_id`, `plan_sub_image`, `date_time_added`) VALUES (1, 1, 'uploads/plan_sub/plan_sub_image916529-14-11-2018-v1-3.jpg', '14-11-2018'), (2, 1, 'uploads/plan_sub/plan_sub_image767573-14-11-2018-v1-4.jpg', '14-11-2018'), (3, 1, 'uploads/plan_sub/plan_sub_image256141-14-11-2018-v1-5.jpg', '14-11-2018'), (4, 1, 'uploads/plan_sub/plan_sub_image499147-14-11-2018-v1-6.jpg', '14-11-2018'), (5, 1, 'uploads/plan_sub/plan_sub_image541984-14-11-2018-v1-8.jpg', '14-11-2018'), (6, 1, 'uploads/plan_sub/plan_sub_image355505-14-11-2018-v1-9.jpg', '14-11-2018'), (7, 1, 'uploads/plan_sub/plan_sub_image855416-15-11-2018-caption-img.jpg', '15-11-2018'), (8, 1, 'uploads/plan_sub/plan_sub_image868142-15-11-2018-lat-blog-1.jpg', '15-11-2018'), (9, 1, 'uploads/plan_sub/plan_sub_image286409-15-11-2018-lat-blog-2.jpg', '15-11-2018'), (10, 1, 'uploads/plan_sub/plan_sub_image252254-15-11-2018-lat-blog-3.jpg', '15-11-2018'), (25, 5, 'uploads/plan_sub/plan_sub_image995265-19-02-2019-pcare1.jpg', '19-02-2019'), (36, 3, 'uploads/plan_sub/plan_sub_image369935-27-02-2019-DSCN9824.jpg', '27-02-2019'), (38, 3, 'uploads/plan_sub/plan_sub_image996001-27-02-2019-WP_20170708_11_53_32_Pro.jpg', '27-02-2019'), (39, 3, 'uploads/plan_sub/plan_sub_image537872-27-02-2019-WP_20170824_16_41_22_Pro.jpg', '27-02-2019'), (40, 2, 'uploads/plan_sub/plan_sub_image725391-27-02-2019-Picture 112.jpg', '27-02-2019'), (41, 2, 'uploads/plan_sub/plan_sub_image749430-27-02-2019-WP_20170317_09_52_24_Pro.jpg', '27-02-2019'), (42, 2, 'uploads/plan_sub/plan_sub_image215708-27-02-2019-WP_20170525_16_33_35_Pro.jpg', '27-02-2019'), (43, 2, 'uploads/plan_sub/plan_sub_image469034-27-02-2019-WP_20170918_17_08_20_Pro.jpg', '27-02-2019'), (44, 5, 'uploads/plan_sub/plan_sub_image459324-28-02-2019-pregnantwomanatdoctor-670x377.jpg', '28-02-2019'), (45, 5, 'uploads/plan_sub/plan_sub_image938769-28-02-2019-r3m3baf8_mother-child_625x300_26_July_18.jpg', '28-02-2019'), (46, 5, 'uploads/plan_sub/plan_sub_image150053-28-02-2019-prenatal-care.jpg', '28-02-2019'), (47, 3, 'uploads/plan_sub/plan_sub_image157770-07-03-2019-IMG_5863.JPG', '07-03-2019'), (48, 2, 'uploads/plan_sub/plan_sub_image771825-07-03-2019-IMG-20190306-WA0016.jpg', '07-03-2019'), (53, 6, 'uploads/plan_sub/plan_sub_image227974-13-02-2020-cp1.jpg', '13-02-2020'), (54, 6, 'uploads/plan_sub/plan_sub_image713267-13-02-2020-cp2.jpg', '13-02-2020'), (55, 6, 'uploads/plan_sub/plan_sub_image127906-13-02-2020-cp3.jpg', '13-02-2020'), (56, 6, 'uploads/plan_sub/plan_sub_image833435-13-02-2020-cp4.jpg', '13-02-2020'); -- -------------------------------------------------------- -- -- Table structure for table `tbl_user` -- CREATE TABLE `tbl_user` ( `user_id` int(11) NOT NULL, `username` varchar(255) NOT NULL, `email_id` varchar(255) NOT NULL, `password` varchar(255) NOT NULL, `contact` varchar(255) NOT NULL, `otp` varchar(255) NOT NULL, `is_email_varified` int(11) NOT NULL, `is_contact_varified` int(11) NOT NULL, `status` varchar(255) NOT NULL, `date_time_added` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_user` -- INSERT INTO `tbl_user` (`user_id`, `username`, `email_id`, `password`, `contact`, `otp`, `is_email_varified`, `is_contact_varified`, `status`, `date_time_added`) VALUES (11, 'Chetan', 'chetan515223@gmail.com', '31cb78e4ccb828adb4f19e85b271beda', '7802957064', '607352', 1, 1, '', '03-01-2019'), (12, 'Ronak', 'ronak26361@gmail.com', 'c8837b23ff8aaa8a2dde915473ce0991', '9924426361', '525532', 1, 1, '', '07-01-2019'), (13, 'minal n panchal', 'minalnpanchal@gmail.com', 'c8837b23ff8aaa8a2dde915473ce0991', '9227256328', '477894', 0, 0, '', '07-01-2019'); -- -------------------------------------------------------- -- -- Table structure for table `tbl_weekly_plan` -- CREATE TABLE `tbl_weekly_plan` ( `weekly_plan_id` int(11) NOT NULL, `plan_id` int(11) NOT NULL, `weekly_plan_name` varchar(255) NOT NULL, `weekly_plan_description` varchar(500) NOT NULL, `weekly_price` varchar(255) NOT NULL, `plan_duration` int(11) NOT NULL, `date_time_added` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_weekly_plan` -- INSERT INTO `tbl_weekly_plan` (`weekly_plan_id`, `plan_id`, `weekly_plan_name`, `weekly_plan_description`, `weekly_price`, `plan_duration`, `date_time_added`) VALUES (3, 2, '1 Week Plan', 'Lorem text', '500', 7, '16-11-2018'), (4, 2, '2 Week Plan', 'Lorem Text', '800', 14, '17-11-2018'), (5, 2, '3 Week Plan', 'Lorem Text', '1200', 21, '17-11-2018'), (6, 2, '4 Week Plan', 'Lorem Text', '1600', 28, '17-11-2018'), (7, 3, '1 Week Plan', 'Lorem Text', '600', 7, '17-11-2018'), (8, 3, '2 Week Plan', 'Lorem Text', '1100', 14, '17-11-2018'), (9, 3, '3 Week Plan', 'Lorem Text', '1600', 21, '17-11-2018'), (10, 3, '4 Week Plan', 'Lorem Text', '2100', 28, '17-11-2018'), (13, 2, '10', 'eurgfuegruyseg', '3500', 15, '07-01-2019'), (14, 4, '1', 'rthrthrt', '25000', 7, '17-01-2019'); -- -- Indexes for dumped tables -- -- -- Indexes for table `tbl_admin` -- ALTER TABLE `tbl_admin` ADD PRIMARY KEY (`admin_id`); -- -- Indexes for table `tbl_blog` -- ALTER TABLE `tbl_blog` ADD PRIMARY KEY (`blog_id`); -- -- Indexes for table `tbl_blog_image` -- ALTER TABLE `tbl_blog_image` ADD PRIMARY KEY (`blog_image_id`); -- -- Indexes for table `tbl_certificate` -- ALTER TABLE `tbl_certificate` ADD PRIMARY KEY (`certificate_id`); -- -- Indexes for table `tbl_event` -- ALTER TABLE `tbl_event` ADD PRIMARY KEY (`event_id`); -- -- Indexes for table `tbl_event_image` -- ALTER TABLE `tbl_event_image` ADD PRIMARY KEY (`event_image_id`); -- -- Indexes for table `tbl_ips` -- ALTER TABLE `tbl_ips` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tbl_order` -- ALTER TABLE `tbl_order` ADD PRIMARY KEY (`order_id`); -- -- Indexes for table `tbl_plan` -- ALTER TABLE `tbl_plan` ADD PRIMARY KEY (`plan_id`); -- -- Indexes for table `tbl_plan_image` -- ALTER TABLE `tbl_plan_image` ADD PRIMARY KEY (`plan_image_id`); -- -- Indexes for table `tbl_user` -- ALTER TABLE `tbl_user` ADD PRIMARY KEY (`user_id`); -- -- Indexes for table `tbl_weekly_plan` -- ALTER TABLE `tbl_weekly_plan` ADD PRIMARY KEY (`weekly_plan_id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `tbl_admin` -- ALTER TABLE `tbl_admin` MODIFY `admin_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `tbl_blog` -- ALTER TABLE `tbl_blog` MODIFY `blog_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- AUTO_INCREMENT for table `tbl_blog_image` -- ALTER TABLE `tbl_blog_image` MODIFY `blog_image_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14; -- -- AUTO_INCREMENT for table `tbl_certificate` -- ALTER TABLE `tbl_certificate` MODIFY `certificate_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=41; -- -- AUTO_INCREMENT for table `tbl_event` -- ALTER TABLE `tbl_event` MODIFY `event_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- AUTO_INCREMENT for table `tbl_event_image` -- ALTER TABLE `tbl_event_image` MODIFY `event_image_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13; -- -- AUTO_INCREMENT for table `tbl_ips` -- ALTER TABLE `tbl_ips` MODIFY `id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `tbl_order` -- ALTER TABLE `tbl_order` MODIFY `order_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `tbl_plan` -- ALTER TABLE `tbl_plan` MODIFY `plan_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `tbl_plan_image` -- ALTER TABLE `tbl_plan_image` MODIFY `plan_image_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=57; -- -- AUTO_INCREMENT for table `tbl_user` -- ALTER TABLE `tbl_user` MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14; -- -- AUTO_INCREMENT for table `tbl_weekly_plan` -- ALTER TABLE `tbl_weekly_plan` MODIFY `weekly_plan_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
docroot:
/home/u856302147/domains/creativegardendesign.in/public_html
curdir: /home/u856302147/domains/revivelife.in/public_html/db
.
4096
..
4096
X
revivelf_db.sql
28882