-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Feb 06, 2026 at 07:58 AM -- Server version: 10.4.32-MariaDB -- PHP Version: 8.2.12 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; 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: `new_admin` -- -- -------------------------------------------------------- -- -- Table structure for table `admin_tbl` -- CREATE TABLE `admin_tbl` ( `slno` int(5) NOT NULL, `contact_name` varchar(100) DEFAULT NULL, `username` varchar(100) DEFAULT NULL, `password` varchar(50) DEFAULT NULL, `status` char(1) NOT NULL DEFAULT 'N', `mobile_phone` varchar(12) DEFAULT NULL, `email_address` varchar(150) DEFAULT NULL, `designation` varchar(100) DEFAULT NULL, `created` varchar(10) DEFAULT '0000-00-00', `role` enum('superadmin','admin') DEFAULT 'admin', `permissions` text DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `admin_tbl` -- INSERT INTO `admin_tbl` (`slno`, `contact_name`, `username`, `password`, `status`, `mobile_phone`, `email_address`, `designation`, `created`, `role`, `permissions`) VALUES (1, 'superadmin', 'superadmin', 'superadmin', 'Y', NULL, NULL, NULL, '0000-00-00', 'superadmin', ''), (12, NULL, 'admin', 'qwwwqqqwqqw', 'Y', NULL, NULL, NULL, '0000-00-00', 'admin', 'testimonial,query,seo'), (13, NULL, 'mainadmin', 'traert', 'Y', NULL, NULL, NULL, '0000-00-00', 'admin', 'dashboard,home_banner,Other_home_banner,services'); -- -------------------------------------------------------- -- -- Table structure for table `general_inq` -- CREATE TABLE `general_inq` ( `slno` int(5) NOT NULL, `contact_name` varchar(30) DEFAULT NULL, `email` varchar(50) DEFAULT NULL, `mobile_phone` varchar(30) DEFAULT NULL, `state` varchar(10) DEFAULT NULL, `city` varchar(50) DEFAULT NULL, `address` text DEFAULT NULL, `country` varchar(50) DEFAULT NULL, `inquiry_for` varchar(50) NOT NULL, `your_query` text DEFAULT NULL, `ipaddress` varchar(50) DEFAULT NULL, `status` char(1) NOT NULL DEFAULT 'N', `recv_date_time` varchar(30) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `genral_details` -- CREATE TABLE `genral_details` ( `slno` int(11) NOT NULL, `mobile_number` varchar(50) NOT NULL, `emailid` varchar(255) NOT NULL, `address` text NOT NULL, `alternate_mobile_number` varchar(50) NOT NULL, `alternate_emailid` varchar(255) NOT NULL, `secondary_address` text NOT NULL, `footer_short_desc` text NOT NULL, `display_status` char(1) NOT NULL DEFAULT 'N', `he-logoImg` varchar(255) DEFAULT NULL, `foo-logoImg` varchar(255) DEFAULT NULL, `recv_date` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `genral_details` -- INSERT INTO `genral_details` (`slno`, `mobile_number`, `emailid`, `address`, `alternate_mobile_number`, `alternate_emailid`, `secondary_address`, `footer_short_desc`, `display_status`, `he-logoImg`, `foo-logoImg`, `recv_date`) VALUES (1, '6756565675', 'fgbcvbdfg@gmail.com', 'fggdg4fv rtertggere34gdfg eeg46', '6776756543', 'fgbcvbdfg@gmail.com', 'fggdg4fv rtertggere34gdfg eeg46', 'ttrvnj jhdguyd jhduyafsdvu hgadfytdfhsd dh fu', 'Y', 'header_1.jpg', 'footer_1.jpg', '2026-01-27 13:05:07'); -- -------------------------------------------------------- -- -- Table structure for table `homepage_banner` -- CREATE TABLE `homepage_banner` ( `slno` int(8) NOT NULL, `heading` varchar(255) DEFAULT NULL, `banner_type` int(5) DEFAULT NULL, `homepage_img` varchar(100) DEFAULT NULL, `display_position` char(3) NOT NULL DEFAULT '0', `updatedby` varchar(100) DEFAULT NULL, `status` char(1) NOT NULL DEFAULT 'N', `position` int(5) NOT NULL DEFAULT 0, `rdate` varchar(50) NOT NULL DEFAULT '0000-00-00', `description` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `homepage_banner` -- INSERT INTO `homepage_banner` (`slno`, `heading`, `banner_type`, `homepage_img`, `display_position`, `updatedby`, `status`, `position`, `rdate`, `description`) VALUES (17, 'Experience true energy transformational with spiritual & traditional healing therapies', 2, '17.jpg', '3', 'superadmin', 'Y', 0, '2026-01-09', ' Reiki, Crystal & Past Life Therapy'), (18, 'Decode Your Destiny through Scientific Astrology & Advanced Numerology & Vastu', 2, '18.jpg', '1', 'superadmin', 'Y', 0, '2026-01-24', 'Astrology, Numerology & Vastu'), (19, 'Where Ancient Wisdom Meets Modern Wellness', 2, '19.jpg', '2', 'superadmin', 'Y', 0, '2026-01-24', 'Nutrition, Naturopathy & Traditional Science'); -- -------------------------------------------------------- -- -- Table structure for table `manage_seo` -- CREATE TABLE `manage_seo` ( `slno` int(11) NOT NULL, `favicon` varchar(255) DEFAULT NULL, `sitemap` varchar(255) DEFAULT NULL, `robot` varchar(255) DEFAULT NULL, `display_status` varchar(50) DEFAULT NULL, `recv_date` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `manage_seo` -- INSERT INTO `manage_seo` (`slno`, `favicon`, `sitemap`, `robot`, `display_status`, `recv_date`) VALUES (1, 'favicon_1.png', 'sitemap.xml', 'robots.txt', 'Y', '2026-02-03 10:06:43'); -- -------------------------------------------------------- -- -- Table structure for table `our_blogs` -- CREATE TABLE `our_blogs` ( `slno` int(5) NOT NULL, `blog_title` varchar(200) DEFAULT NULL, `filename` varchar(200) NOT NULL, `posted_by` varchar(50) DEFAULT NULL, `posted_date` varchar(10) NOT NULL DEFAULT '0000-00-00', `display_status` char(1) NOT NULL DEFAULT 'N', `blog_short_desc` text DEFAULT NULL, `blog_desc` longtext DEFAULT NULL, `meta_title` varchar(200) NOT NULL, `meta_keyword` text NOT NULL, `meta_desc` text NOT NULL, `recv_date` varchar(30) DEFAULT NULL, `parent_id` int(11) NOT NULL, `blog_img` longtext NOT NULL, `blog_header` longtext NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `our_blogs` -- INSERT INTO `our_blogs` (`slno`, `blog_title`, `filename`, `posted_by`, `posted_date`, `display_status`, `blog_short_desc`, `blog_desc`, `meta_title`, `meta_keyword`, `meta_desc`, `recv_date`, `parent_id`, `blog_img`, `blog_header`) VALUES (16, 'The Power of Numerology in Career & Relationships', 'the-power-of-numerology-in-career-relationships', 'Admin', '2025-11-21', 'Y', 'The Power of Numerology in Career & Relationships', '

You can quickly set up or delete access for employees, get access-triggered alerts when certain doors are opened, and quickly find video clips of access events. You can also lock and unlock any door remotely, and even have your business lock itself automatically at closing time. Smart fire alarm systems assist in providing vital protection to businesses, landlords and public sector buildings by enhancing traditional fire detection equipment. Find out how smart fire alarm systems work and what t...

\r\n\r\n

Reliable, professional monitoring ensures your business, inventory and equipment are always protected. Combined with Security systems, you have security that goes the extra mile.

\r\n\r\n

We pride ourselves on going above and beyond for the customer on every project we take on. Whether you’re looking for a surveillance camera installation or an access control system installation, it’s important that the security system installer you choose has the experience and vision to help you achieve your security goals. Our commercial security services are about more than surveillance system installation or alarm system installation. It’s our commitment to customer success before and after the project that sets us apart from our competitors. When we tackle a project that integrates a security system, we take a wholistic approach to installing business security cameras, Access Control Systems, commercial alarm systems, or cctv cameras.

', 'The Power of Numerology in Career & Relationships', 'The Power of Numerology in Career & Relationships', 'The Power of Numerology in Career & Relationships', '2025-11-22 12:12:41', 0, '16_main.jpg', ''), (17, 'How Reiki Healing Works: A Beginner’s Guide', 'how-reiki-healing-works-a-beginner-s-guide', 'Admin', '2025-11-18', 'Y', 'How Reiki Healing Works: A Beginner’s Guide', '

You can quickly set up or delete access for employees, get access-triggered alerts when certain doors are opened, and quickly find video clips of access events. You can also lock and unlock any door remotely, and even have your business lock itself automatically at closing time. Smart fire alarm systems assist in providing vital protection to businesses, landlords and public sector buildings by enhancing traditional fire detection equipment. Find out how smart fire alarm systems work and what t...

\r\n\r\n

Reliable, professional monitoring ensures your business, inventory and equipment are always protected. Combined with Security systems, you have security that goes the extra mile.

\r\n\r\n

We pride ourselves on going above and beyond for the customer on every project we take on. Whether you’re looking for a surveillance camera installation or an access control system installation, it’s important that the security system installer you choose has the experience and vision to help you achieve your security goals. Our commercial security services are about more than surveillance system installation or alarm system installation. It’s our commitment to customer success before and after the project that sets us apart from our competitors. When we tackle a project that integrates a security system, we take a wholistic approach to installing business security cameras, Access Control Systems, commercial alarm systems, or cctv cameras.

', 'How Reiki Healing Works: A Beginner’s Guide', 'How Reiki Healing Works: A Beginner’s Guide', 'How Reiki Healing Works: A Beginner’s Guide', '2025-11-22 12:32:12', 0, '17_main.jpg', ''), (18, 'Angel Therapy: How Angels Guide Your Life', 'angel-therapy-how-angels-guide-your-life', 'Admin', '2025-12-12', 'Y', 'Angel Therapy: How Angels Guide Your Life', '

Angel Therapy: How Angels Guide Your Life

', 'Angel Therapy: How Angels Guide Your Life', 'Angel Therapy: How Angels Guide Your Life', 'Angel Therapy: How Angels Guide Your Life', '2025-12-18 02:30:09', 0, '18_main.jpg', ''); -- -------------------------------------------------------- -- -- Table structure for table `product_category` -- CREATE TABLE `product_category` ( `cid` int(8) NOT NULL, `product_catg` varchar(200) DEFAULT NULL, `catg_img` varchar(50) DEFAULT NULL, `ref_id` int(5) NOT NULL, `filename` varchar(200) DEFAULT NULL, `status` char(1) NOT NULL DEFAULT 'N', `is_category` char(1) NOT NULL DEFAULT 'N', `header_title` varchar(255) NOT NULL, `header_desc` varchar(255) NOT NULL, `prodImg` varchar(100) DEFAULT NULL, `position` int(5) NOT NULL, `content_add_status` char(1) NOT NULL DEFAULT 'N', `short_desc` text DEFAULT NULL, `product_material` text DEFAULT NULL, `meta_title` varchar(200) DEFAULT NULL, `meta_desc` text DEFAULT NULL, `meta_keyword` varchar(200) DEFAULT NULL, `bottom_short_desc` text NOT NULL, `rdate` varchar(20) DEFAULT '0000-00-00', `upd_date` varchar(20) DEFAULT '0000-00-00', `iconImg` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `product_category` -- INSERT INTO `product_category` (`cid`, `product_catg`, `catg_img`, `ref_id`, `filename`, `status`, `is_category`, `header_title`, `header_desc`, `prodImg`, `position`, `content_add_status`, `short_desc`, `product_material`, `meta_title`, `meta_desc`, `meta_keyword`, `bottom_short_desc`, `rdate`, `upd_date`, `iconImg`) VALUES (1, 'Free Services For Our Students', '', 0, 'free-services-for-our-students', 'Y', 'Y', '', '', NULL, 0, 'N', '', NULL, 'Free Services For Our Students', 'Free Services For Our Students', 'Free Services For Our Students', '', '2026-01-08', '2026-01-08', ''), (2, 'Free Services For Our Patients', NULL, 0, 'free-services-for-our-patients', 'Y', 'Y', '', '', NULL, 0, 'N', '', NULL, 'Free Services For Our Patients', 'Free Services For Our Patients', 'Free Services For Our Patients', '', '2026-01-08', '0000-00-00', ''), (3, 'Paid Consulting Services', NULL, 0, 'paid-consulting-services', 'Y', 'Y', '', '', NULL, 0, 'N', '', NULL, 'Paid Consulting Services', 'Paid Consulting Services', 'Paid Consulting Services', '', '2026-01-08', '0000-00-00', ''), (5, ' Repeat Classes & Re-attunement', NULL, 1, 'repeat-classes-and-re-attunement', 'Y', 'N', '', '', '5.jpg', 0, 'N', '

Refresh skills anytime with unlimited class revisions attunements.

\r\n', NULL, ' Repeat Classes & Re-Attunement', '', '', '', '2026-01-08', '2026-01-10', ''), (75, ' Repeat Aura & Chakra Analysis', NULL, 2, 'repeat-aura', 'Y', 'N', '', '', '75.jpg', 0, 'N', '

Regular energy checkups to track healing progress and balance.

\r\n', NULL, ' Repeat Aura & Chakra Analysis', '', '', '', '2026-01-10', '0000-00-00', ''), (76, 'Practical Sessions With Real Patients', NULL, 1, 'practical-sessions-with-real-patients', 'Y', 'N', '', '', '76.jpg', 0, 'N', 'Hands-on training to build confidence through real patients.', NULL, 'Practical Sessions with Real Patients', 'Practical Sessions with Real Patients', 'Practical Sessions with Real Patients', '', '2026-01-14', '0000-00-00', ''), (77, 'Lifetime Hand-holding Support', NULL, 1, 'lifetime-hand-holding-support', 'Y', 'N', '', '', '77.jpg', 0, 'N', 'Ongoing guidance and help whenever students need expert support.', NULL, 'Lifetime Hand-Holding Support', '', '', '', '2026-01-14', '0000-00-00', ''), (78, 'Nutrition & Food Combination Counselling', NULL, 2, 'nutrition-and-food-combination-counselling', 'Y', 'N', '', '', '78.jpg', 0, 'N', 'Guidance on healthy eating patterns to support overall wellness.', NULL, 'Nutrition & Food Combination Counselling', '', '', '', '2026-01-14', '0000-00-00', ''), (79, 'Happy Learning Sessions & Vastu Tips', NULL, 2, 'happy-learning-sessions-and-vastu-tips', 'Y', 'N', '', '', '79.jpg', 0, 'N', 'Simple learning sessions with practical Vastu advice for daily harmony.\r\n\r\n', NULL, 'Happy Learning Sessions and Vastu Tips', '', '', '', '2026-01-14', '0000-00-00', ''), (80, 'All Energies Diagnosis Session', NULL, 3, 'all-energies-diagnosis-session', 'Y', 'N', '', '', '80.jpg', 0, 'N', 'Detects negative influences and energy imbalances for quick clarity and protection.', NULL, 'All Energies Diagnosis Session', '', '', '', '2026-01-14', '0000-00-00', ''), (81, 'Parenting & Relationship Counselling', NULL, 3, 'parenting-and-relationship-counselling', 'Y', 'N', '', '', '81.jpg', 0, 'N', 'Guidance to improve communication, emotional balance, and healthy family relationships.', NULL, 'Parenting and Relationship Counselling', '', '', '', '2026-01-14', '0000-00-00', ''), (82, 'Reiki / Crystal / Sound Healing', NULL, 3, 'reiki-crystal-sound-healing', 'Y', 'N', '', '', '82.jpg', 0, 'N', 'Energy-based therapies to relax, realign, and rejuvenate mind and body.', NULL, 'Reiki / Crystal / Sound Healing', '', '', '', '2026-01-14', '0000-00-00', ''), (83, 'Psychic / Dna / Karmic Healing', NULL, 3, 'psychic-dna-karmic-healing', 'Y', 'N', '', '', '83.jpg', 0, 'N', 'Removes deep-rooted energetic blocks for emotional, ancestral, and spiritual healing.', NULL, 'Psychic / DNA / Karmic Healing', '', '', '', '2026-01-14', '0000-00-00', ''), (84, 'Acupressure & Acupuncture Sessions', NULL, 3, 'acupressure-and-acupuncture-sessions', 'Y', 'N', '', '', '84.jpg', 0, 'N', 'Stimulates body points to relieve pain and restore natural energy flow.', NULL, 'Acupressure and Acupuncture Sessions', '', '', '', '2026-01-14', '0000-00-00', ''), (85, 'Astrology / Numerology / Palmistry', NULL, 3, 'astrology-numerology-palmistry', 'Y', 'N', '', '', '85.jpg', 0, 'N', 'Get personalized life insights through accurate astrological and numerological readings.', NULL, 'Astrology / Numerology / Palmistry', '', '', '', '2026-01-14', '0000-00-00', ''), (86, 'Dowsing / Pendulum / Tarot Reading', NULL, 3, 'dowsing-pendulum-tarot-reading', 'Y', 'N', '', '', '86.jpg', 0, 'N', 'Intuitive guidance for decisions, clarity, and future direction.', NULL, 'Dowsing / Pendulum / Tarot Reading', '', '', '', '2026-01-14', '0000-00-00', ''), (87, 'Dream Analysis & Remedies', NULL, 3, 'dream-analysis-and-remedies', 'Y', 'N', '', '', '87.jpg', 0, 'N', 'Interpret dreams to understand subconscious messages and receive practical solutions.', NULL, 'Dream Analysis and Remedies', '', '', '', '2026-01-14', '0000-00-00', ''), (88, 'Past Life Regression', NULL, 3, 'past-life-regression', 'Y', 'N', '', '', '88.jpg', 0, 'N', 'Explore past lives and future progression for healing and self-discovery.', NULL, 'Past Life Regression', '', '', '', '2026-01-14', '0000-00-00', ''), (89, 'Clinical Hypnotherapy Session', NULL, 3, 'clinical-hypnotherapy-session', 'Y', 'N', '', '', '89.jpg', 0, 'N', 'Reprogram subconscious patterns to overcome stress, fears, and emotional blocks.', NULL, ' Clinical Hypnotherapy Session', '', '', '', '2026-01-14', '0000-00-00', ''), (90, 'Online Vastu Consultation', NULL, 3, 'online-vastu-consultation', 'Y', 'N', '', '', '90.jpg', 0, 'N', 'Accurate Vastu guidance using maps for harmony and balanced spaces.', NULL, 'Online Vastu Consultation', '', '', '', '2026-01-14', '0000-00-00', ''), (91, 'Vastu Field Visit', NULL, 3, 'vastu-field-visit', 'Y', 'N', '', '', '91.jpg', 0, 'N', 'On-site Vastu assessment for homes or offices with modern and Vedic methods.', NULL, 'Vastu Field Visit', '', '', '', '2026-01-14', '0000-00-00', ''); -- -------------------------------------------------------- -- -- Table structure for table `site_testimonials` -- CREATE TABLE `site_testimonials` ( `slno` int(5) NOT NULL, `reviewer_name` varchar(50) DEFAULT NULL, `reviewer_email` varchar(50) DEFAULT NULL, `review_text` text DEFAULT NULL, `rating` int(5) NOT NULL, `pre_img` text DEFAULT NULL, `display_status` char(1) NOT NULL DEFAULT 'N', `recv_date_time` varchar(30) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `site_testimonials` -- INSERT INTO `site_testimonials` (`slno`, `reviewer_name`, `reviewer_email`, `review_text`, `rating`, `pre_img`, `display_status`, `recv_date_time`) VALUES (8, 'Ashu Mishra', 'ashumishra@gmail.com', 'I had pain in my left hip for which I went to Dr Umakant for psychic surgery.\r\n During the surgery, I could also visualise a swollen portion in my left hip.\r\n After 1session, I felt complete relief from pain. I am fully satisfied by\r\n the services of Dr. Umakant Sharma Ji and I recommend the RAHI to all.', 5, '8.jpg', 'Y', '2025-12-18 02:18:53'), (9, 'Madhu Parihar', 'madhuparihar@gmail.com', 'The reiki session was outstanding. I brushed up my knowledge about reiki and\r\n felt motivated to continue practicing it for the healing of others and self.\r\n The practical session was really a booster for me, which lead to deep\r\n understanding of healing modalities and inculcated more confidence in me.', 5, '9.jpg', 'Y', '2025-12-18 02:19:56'), (10, 'Aneeket Yadav', 'aneeketyadav@gmail.com', 'Reiki treatment has been extremely useful.it helps to clean the body aura and\r\n brings about a sense of positivity and confidence and re-enforces your\r\n belief in life. The mind now seems less cluttered. Deeply grateful to Dr.\r\n Umakant Sharma for his contribution. My son has benefitted immensely from\r\n it, this helped him reduced his tensions and focus on shortcomings because\r\n of which he was able to clear JEE advanced and get into IIT Delhi.', 3, '10.jpg', 'Y', '2025-12-18 02:21:02'), (11, 'Purnima Misra', 'purnimamisra@gmail.com', 'One of the best Institute for Occult Science and Astro/Vastu consultancy. The\r\n courses are taught in very subtle way and lifetime guidance support is also\r\n provided for all the courses. That\'s the Uniqueness of this institute. Proud\r\n to b part of it.', 4, '11.jpg', 'Y', '2025-12-18 02:22:01'), (12, 'Pooja Sinoria', 'poojasinoria@gmail.com', 'Guruji gave divine reiki energy to my son who born preterm 32 weeks. He was\r\n very week at the time of birth with 1.7 kg and spent 2 weeks in NICU baby\r\n unit in the hospital. Later at the time of discharge, doctor told us that\r\n his retina is not develop and take almost one year to complete but there is\r\n also high risk of losing vision or other issues too with his eyes. We were\r\n very afraid and told this to Guru ji. Within a period of two months of\r\n continuous distance & direct healing my son recover fully from the retina\r\n problem. Dhanywad Guruji.', 5, '12.jpg', 'Y', '2025-12-18 02:23:47'), (14, 'Dr. Deepika Jain', 'sdsadsa@gmail.com', 'When I get in touch with Reiki & Astro Healing Institute, all seems to be energetic and when I started practicing Reiki, I observed a new and positive change within myself as well as near my surroundings. I could feel the divine & psychic energies when I see myself spiritually, socially, physically, emotionally, more stable and happy. I am very thankful to my Traditional Reiki Master Dr. Umakant Sharma Guru Ji for believe in me and made me capable for others to bring overall happiness & success in their lives through Reiki Energy.', 5, '14.png', 'Y', '2025-12-24 03:11:22'); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` int(10) UNSIGNED NOT NULL, `full_name` varchar(100) NOT NULL, `email` varchar(100) NOT NULL, `phone_number` varchar(10) DEFAULT NULL, `gender` enum('Male','Female','Other') DEFAULT NULL, `dob` date DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp(), `password` varchar(50) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Indexes for dumped tables -- -- -- Indexes for table `admin_tbl` -- ALTER TABLE `admin_tbl` ADD PRIMARY KEY (`slno`), ADD UNIQUE KEY `username` (`username`); -- -- Indexes for table `general_inq` -- ALTER TABLE `general_inq` ADD PRIMARY KEY (`slno`); -- -- Indexes for table `genral_details` -- ALTER TABLE `genral_details` ADD PRIMARY KEY (`slno`); -- -- Indexes for table `homepage_banner` -- ALTER TABLE `homepage_banner` ADD PRIMARY KEY (`slno`), ADD KEY `status` (`status`), ADD KEY `position` (`position`); -- -- Indexes for table `manage_seo` -- ALTER TABLE `manage_seo` ADD PRIMARY KEY (`slno`); -- -- Indexes for table `our_blogs` -- ALTER TABLE `our_blogs` ADD PRIMARY KEY (`slno`); -- -- Indexes for table `product_category` -- ALTER TABLE `product_category` ADD PRIMARY KEY (`cid`); -- -- Indexes for table `site_testimonials` -- ALTER TABLE `site_testimonials` ADD PRIMARY KEY (`slno`), ADD KEY `display_status` (`display_status`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `email` (`email`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `admin_tbl` -- ALTER TABLE `admin_tbl` MODIFY `slno` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15; -- -- AUTO_INCREMENT for table `general_inq` -- ALTER TABLE `general_inq` MODIFY `slno` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32; -- -- AUTO_INCREMENT for table `genral_details` -- ALTER TABLE `genral_details` MODIFY `slno` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `homepage_banner` -- ALTER TABLE `homepage_banner` MODIFY `slno` int(8) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28; -- -- AUTO_INCREMENT for table `manage_seo` -- ALTER TABLE `manage_seo` MODIFY `slno` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `our_blogs` -- ALTER TABLE `our_blogs` MODIFY `slno` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20; -- -- AUTO_INCREMENT for table `product_category` -- ALTER TABLE `product_category` MODIFY `cid` int(8) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=101; -- -- AUTO_INCREMENT for table `site_testimonials` -- ALTER TABLE `site_testimonials` MODIFY `slno` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; 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 */;