-- http://www.phpmyadmin.net
--




--
-- Database: `loginsample`
--

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

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

CREATE TABLE `users` (
  `email` varchar(100) NOT NULL,
  `phone` int(11) 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` (`email`, `phone`, `username`, `role`, `password`) VALUES
('ali@gmail.com', 1234567, 'ali', 'student', '12345'),
('james@yahoo.com', 75664455, 'james', 'instructor', '12345'),
('kheri@gmail.com', 7664455, 'kheri', 'admin', '12345'),
('monica@gmail.com', 766554455, 'rafael', 'student', '12345');

--
-- Indexes for dumped tables
--

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

