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
- 0 ms for computations
- 2 ms for system calls
- 5.0108432769775 ms for other/combined spent