Web

-- phpMyAdmin SQL Dump -- version 4.8.5 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Nov 28, 2019 at 04:12 PM -- Server version: 10.0.38-MariaDB-cll-lve -- PHP Version: 7.2.7 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: `rbasnetx_drugstore` -- -- -------------------------------------------------------- -- -- Table structure for table `medicine` -- CREATE TABLE `medicine` ( `medicine id` int(20) NOT NULL, `medicine name` char(50) NOT NULL, `manufacturing country` char(50) NOT NULL, `manufacturing date` int(20) NOT NULL, `type` char(20) NOT NULL, `patient id` int(50) NOT NULL, `doctor id` int(50) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `medicine` -- INSERT INTO `medicine` (`medicine id`, `medicine name`, `manufacturing country`, `manufacturing date`, `type`, `patient id`, `doctor id`) VALUES (6969, 'Pepto bismol', 'US', 2016, 'stomach pain', 619619, 56789), (8989, 'Advil', 'US', 2017, 'headache', 619620, 56790); -- -------------------------------------------------------- -- -- Table structure for table `Patient` -- CREATE TABLE `Patient` ( `patient id` int(20) NOT NULL, `patient's first name` char(50) NOT NULL, `patient's last name` char(50) NOT NULL, `patient's middle name` char(50) NOT NULL, `gender` char(20) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `Patient` -- INSERT INTO `Patient` (`patient id`, `patient's first name`, `patient's last name`, `patient's middle name`, `gender`) VALUES (619619, 'Ram', 'Limbu', 'bahadur', 'Male'), (619620, 'Prakash', 'Thapa', 'kesh', 'Male'); -- -- Indexes for dumped tables -- -- -- Indexes for table `medicine` -- ALTER TABLE `medicine` ADD PRIMARY KEY (`medicine id`); -- -- Indexes for table `Patient` -- ALTER TABLE `Patient` ADD PRIMARY KEY (`patient id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `medicine` -- ALTER TABLE `medicine` MODIFY `medicine id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8990; -- -- AUTO_INCREMENT for table `Patient` -- ALTER TABLE `Patient` MODIFY `patient id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=619621; 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 */;