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




--
-- Database: `passcode`
--

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

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

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `names` varchar(100) NOT NULL,
  `password` varchar(512) NOT NULL,
  `email` varchar(1024) NOT NULL,
  `mobile` varchar(55) NOT NULL,
  `pin` int(4) NOT NULL,
  `time` int(11) NOT NULL,
  `confirmed` int(11) NOT NULL,
  `otp` int(25) NOT NULL,
  `otp_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `ip` varchar(32) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

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

INSERT INTO `users` (`id`, `names`, `password`, `email`, `mobile`, `pin`, `time`, `confirmed`, `otp`, `otp_time`, `ip`) VALUES
(1, 'Hussaini Ibrahim Aliyu', 'f1c083e61b32d3a9be76bc21266b0648', 'hussainidotnet@gmail.com', '08035776396', 1111, 0, 1, 214407, '2016-07-23 08:39:03', ''),
(3, 'Jemilat Yahaya', '887ce9bb95cfea2366f98e678382136c', 'jemilatshuaib@gmail.com', '0816549875', 0, 1469306526, 1, 0, '2016-07-23 20:42:06', '::1');

