|
Server IP : 162.214.80.37 / Your IP : 216.73.216.68 Web Server : Apache System : Linux sh013.webhostingservices.com 4.19.286-203.ELK.el7.x86_64 #1 SMP Wed Jun 14 04:33:55 CDT 2023 x86_64 User : imyrqtmy ( 2189) PHP Version : 8.2.18 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0755) : /home2/imyrqtmy/public_html/vssvclinic/database/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
-- phpMyAdmin SQL Dump -- version 5.1.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Apr 11, 2022 at 10:10 PM -- Server version: 10.4.20-MariaDB -- PHP Version: 7.4.21 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: `vaid_new` -- -- -------------------------------------------------------- -- -- Table structure for table `tbl_admin` -- CREATE TABLE `tbl_admin` ( `id` int(11) NOT NULL, `type` varchar(255) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `mobile` varchar(255) DEFAULT NULL, `password` varchar(255) DEFAULT NULL, `fees` varchar(255) DEFAULT NULL, `degree_name` varchar(255) DEFAULT NULL, `degree_img` varchar(255) DEFAULT NULL, `app` varchar(255) NOT NULL DEFAULT '0', `start_time` varchar(255) DEFAULT NULL, `end_time` varchar(255) DEFAULT NULL, `place` varchar(255) DEFAULT NULL, `avaliblity` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `tbl_admin` -- INSERT INTO `tbl_admin` (`id`, `type`, `name`, `email`, `mobile`, `password`, `fees`, `degree_name`, `degree_img`, `app`, `start_time`, `end_time`, `place`, `avaliblity`) VALUES (1, 'Admin', 'admin', 'admin@gmail.com', '1234567890', '12345', NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL), (2, 'Docter', 'abc', 'abc@gmail.com', '8140565656', '123', '300', 'mbbs', 'disbursment.jpg', '1', NULL, NULL, 'Mangolpuri', '3,4,5'), (3, 'Docter', 'mukesh', 'mukesh@gmail.com', '1234567890', '123', '200', 'mbbbs', 'icon-1.png', '2', NULL, NULL, NULL, NULL), (4, 'Docter', 'demodoctor', 'demodoctor@gmail.com', '7897897898', '4567', '100', 'mbbs', 'icon-me.jpg', '2', NULL, NULL, NULL, NULL), (5, 'Docter', 'Rohan Gupta', 'rohan9358088469@gmail.com', '08171092800', 'Virus@25', '500', 'MBBS, BDS', '274919813_110506491577953_6114191226204447897_n.jpg', '2', NULL, NULL, NULL, NULL), (6, 'Docter', 'Rohan Gupta', 'rohan@gmail.com', '08171092800', 'Virus@25', '100', NULL, NULL, '0', NULL, NULL, NULL, NULL), (7, 'Staff', 'Staff', 'Staff@gmail.com', '1234567890', '12345', NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `tbl_gallery` -- CREATE TABLE `tbl_gallery` ( `id` int(11) NOT NULL, `img` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `tbl_gallery` -- INSERT INTO `tbl_gallery` (`id`, `img`) VALUES (9, '274919813_110506491577953_6114191226204447897_n.jpg'), (10, 'bc62dc60-5cf8-42bd-a48c-8a9c8a9f06c1.jpg'); -- -------------------------------------------------------- -- -- Table structure for table `tbl_paitant` -- CREATE TABLE `tbl_paitant` ( `id` int(11) NOT NULL, `name` varchar(255) DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `mobile` varchar(255) DEFAULT NULL, `address` varchar(255) DEFAULT NULL, `city` varchar(255) DEFAULT NULL, `country` varchar(255) DEFAULT NULL, `state` varchar(255) DEFAULT NULL, `zip_code` varchar(255) DEFAULT NULL, `img` varchar(255) DEFAULT NULL, `password` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `tbl_paitant` -- INSERT INTO `tbl_paitant` (`id`, `name`, `email`, `mobile`, `address`, `city`, `country`, `state`, `zip_code`, `img`, `password`) VALUES (2, 'user1', 'ghhs@gmail.com', '7897897896', 'pune', 'pune', 'ind', 'mh', '364001', 'promo_3.jpg', '123'), (4, 'Rohan Gupta', 'rohan9358088469@gmail.com', '08171092800', 'East sapphire', 'Noida', 'India', 'Uttar Pradesh', '201303', 'avirallogo-removebg-preview.png', 'Virus@25'), (5, 'sss', 'sss@gmail.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '123'), (6, 'demo', 'demo@gmail.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '123'); -- -------------------------------------------------------- -- -- Table structure for table `tbl_payment` -- CREATE TABLE `tbl_payment` ( `id` int(11) NOT NULL, `type` varchar(255) DEFAULT NULL, `patient_id` varchar(255) DEFAULT NULL, `docter_id` varchar(255) DEFAULT NULL, `order_id` varchar(255) DEFAULT NULL, `date` varchar(255) DEFAULT NULL, `time` varchar(255) DEFAULT NULL, `amt` varchar(255) DEFAULT NULL, `payment_id` varchar(255) DEFAULT NULL, `payment_status` varchar(255) DEFAULT NULL, `added_on` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `tbl_payment` -- INSERT INTO `tbl_payment` (`id`, `type`, `patient_id`, `docter_id`, `order_id`, `date`, `time`, `amt`, `payment_id`, `payment_status`, `added_on`) VALUES (5, NULL, '2', '3', '11', NULL, NULL, '69', 'pay_JBR7mCumflrkEH', 'complete', '2022-03-26 12:55:25'), (6, NULL, '2', '4', '93', NULL, NULL, '69', 'pay_JBlPReavgMTNla', 'complete', '2022-03-26 08:45:49'), (7, NULL, '2', '4', '36', NULL, NULL, '69', 'pay_JBlS6VrZfH1RCV', 'complete', '2022-03-26 08:48:20'), (8, 'Manually', '5', '3', '91', NULL, NULL, '69', NULL, 'complete', '2022-04-03 16:19:44'), (9, 'Manually', '6', '5', '38', NULL, NULL, '69', NULL, 'complete', '2022-04-03 23:57:59'); -- -------------------------------------------------------- -- -- Table structure for table `tbl_week` -- CREATE TABLE `tbl_week` ( `id` int(11) NOT NULL, `week_name` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `tbl_week` -- INSERT INTO `tbl_week` (`id`, `week_name`) VALUES (1, 'Sunday'), (2, 'Monday'), (3, 'Tuesday'), (4, 'Wednesday'), (5, 'Thursday'), (6, 'Friday'), (7, 'Saturday'); -- -- Indexes for dumped tables -- -- -- Indexes for table `tbl_admin` -- ALTER TABLE `tbl_admin` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tbl_gallery` -- ALTER TABLE `tbl_gallery` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tbl_paitant` -- ALTER TABLE `tbl_paitant` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tbl_payment` -- ALTER TABLE `tbl_payment` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tbl_week` -- ALTER TABLE `tbl_week` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `tbl_admin` -- ALTER TABLE `tbl_admin` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- AUTO_INCREMENT for table `tbl_gallery` -- ALTER TABLE `tbl_gallery` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `tbl_paitant` -- ALTER TABLE `tbl_paitant` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `tbl_payment` -- ALTER TABLE `tbl_payment` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10; -- -- AUTO_INCREMENT for table `tbl_week` -- ALTER TABLE `tbl_week` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; 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 */;