--
-- Host: localhost    Database: webportal_new
-- ------------------------------------------------------


--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `username` varchar(255) NOT NULL,
  `auth_key` varchar(32) NOT NULL,
  `password_hash` varchar(255) NOT NULL,
  `password_reset_token` varchar(255) DEFAULT NULL,
  `verification_token` varchar(255) DEFAULT NULL,
  `email` varchar(100) NOT NULL,
  `status` smallint(10) NOT NULL,
  `role` int(11) NOT NULL,
  `date_first_login` datetime DEFAULT NULL,
  `date_last_login` datetime DEFAULT NULL,
  `created_at` int(11) DEFAULT NULL,
  `updated_at` int(11) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user`
--

INSERT INTO `user` VALUES (1,'Liam Carter.','liamgcarter@gmail.com','etAZ9PInfbfZ9l64LnTGdv3OdlzjL0ER','$2y$13$Bmxv7uvYVClxQhzk4NHthu.DrsuGwVJ8jqEXjyU2fzexC4oxr1tCK','4gRMVHnonAZmcalgXEL_mu_ZHrl4jIuA_1586596927','r7wfaAE7Jx4yS2aIGK2_ugiI7Xh0BE8__1586346909','liamgcarter@gmail.com',10,50,'2020-04-11 08:54:02','2020-04-11 10:24:50',1586346909,1586596927,NULL,1);


