The database used is MySQL.

The schema used is : 
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

/* commands for sql */
/* show tables; */
/* desc user_table_01; */
/* SELECT * FROM user_table_01; */

--
-- Database: `db_demo_tf_u1`
--

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

--
-- Table structure for table `user_table_01`
--

CREATE TABLE IF NOT EXISTS `user_table_01` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `lastip` varchar(128) NOT NULL DEFAULT '0.0.0.0',
  `mailtoken` varchar(255) NOT NULL DEFAULT 'ABC123',
  `mfasecret` varchar(255) NOT NULL DEFAULT 'ABC123',
  `mailverified` datetime NOT NULL DEFAULT '9999-12-31 23:59:59',
  `mfaactive` datetime NOT NULL DEFAULT '9999-12-31 23:59:59',
  `lastlogin` datetime NOT NULL DEFAULT '9999-12-31 23:59:59',
  PRIMARY KEY (`user_id`),
  UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

some fields are encrypted, some fields are hashed: 
mysql> SELECT * FROM user_table_01 where user_id=4;
| user_id
| email
| password
| lastip
| mailtoken
| mfasecret
| mailverified
| mfaactive
| lastlogin
=== with values
| 4 
| 185d538dc5d17aee4******************3e675b01d3ba1bb4b462aabb668f4e
| $2y$10$IHJBwS9re.Q5bG********1j9sMYYR2ueLzZp9MhMixZhOANiwU/K
| f7xytOMtqRZw2zlINKzAlKkoAY0ox********AWfomRmGykQUaepeG1+4A3tvNDxZAMBkWxNTuKknmKkg==
| XXXXX
| uDvC1WDnMVCGK0GbYwzqQivdJ9ED+xyibbtDWg5/-snip-/Qyeu2VvXyCKjPIuiO18MOhSaF1rzW4uvTFfgD
| 2017-11-13 04:48:56
| 2017-11-13 04:50:54
| 2017-11-13 12:59:47