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

START TRANSACTION;



--
-- Database: `reactdb`
--

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

--
-- Table structure for table `books`
--

CREATE TABLE `books` (
  `id` int(11) NOT NULL,
  `bookname` varchar(100) NOT NULL,
  `authorname` varchar(100) NOT NULL,
  `publication` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `books`
--

INSERT INTO `books` (`id`, `bookname`, `authorname`, `publication`) VALUES
(1, 'HTML & CSS: Design and Build Web Sites', 'Jon Duckett', 'Apress'),
(2, 'JavaScript and JQuery: Interactive Front-End Web Development', 'David McFarland', 'dsd'),
(3, 'CSS Pocket Reference: Visual Presentation for the Web', 'Eric A. Meyer', 'xgg'),
(4, 'PHP Advanced and Object-Oriented Programming: Visual QuickPro Guide', 'Larry Ullman', 'fghgjhgj'),
(5, 'Pro Angular 6', 'Adam Freeman', 'cvbcvb'),
(6, 'Beginning Laravel: A Beginner\'s Guide to Application Development with Laravel 5.3', 'Sanjib Sinha', 'hghjgj');

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `user_id` int(11) NOT NULL,
  `username` varchar(50) DEFAULT NULL,
  `password` varchar(300) DEFAULT NULL,
  `name` varchar(200) DEFAULT NULL,
  `email` varchar(300) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`user_id`, `username`, `password`, `name`, `email`) VALUES
(1, 'farhan', '123456', 'Farhan Akter', 'farhan@gmail.com'),
(2, 'admin', '123456', 'Administrator', 'admin@online-book.com'),
(3, 'fahmida', '123456', 'Fahmida Yesmin', 'fahmida@gmail.com');

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`user_id`);

--
-- AUTO_INCREMENT for dumped tables
--

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

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
COMMIT;

