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

START TRANSACTION;



--
-- Database: `loginsample`
--

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

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

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `phone` bigint(50) NOT NULL,
  `dob` date NOT NULL,
  `username` varchar(100) NOT NULL,
  `role` varchar(100) NOT NULL,
  `password` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `users` (`id`, `name`, `email`, `phone`, `dob`, `username`, `role`, `password`) VALUES
(1, 'Kuntal Roy    ', '1985kuntal.roy@gmail.com', 9123398989, '1985-02-02', 'kuntal85    ', 'Admin', 'kuntal1985'),
(2, 'Edrish Ali', 'ali@gmail.com', 1234567, '0000-00-00', 'ali', 'student', '12345'),
(0, 'Suvodeep Chatterjee', 'chatterjee.suvodeep@gmail.com', 8976789067, '1980-12-03', 'chatterjee67', 'instructor', 'suvodeep1980'),
(0, 'Debopriya Roy ', 'debopriya.roy1989@gmail.com', 9062178022, '1989-09-26', 'debopriya89 ', 'Admin', 'uuumin1989'),
(0, 'James Toppo', 'james@yahoo.com', 75664455, '0000-00-00', 'james', 'instructor', '12345'),
(0, 'Kunal Roy', 'kunal.roy6015@gmail.com', 8918783185, '1995-12-09', 'kunal6015', 'Admin', 'kunal1995'),
(0, 'Rafael Ahmed', 'monica@gmail.com', 766554455, '0000-00-00', 'rafael', 'student', '12345'),
(0, 'Sourav Roy ', 'roy.sourav@gmail.com', 7001330767, '1995-06-05', 'munna67 ', 'Admin', '6munna7');

--
-- Indexes for dumped tables
--

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

