· 7 years ago · Jan 05, 2019, 05:22 PM
1CREATE TABLE IF NOT EXISTS `user` (
2 `id` int(11) NOT NULL AUTO_INCREMENT,
3 `username` varchar(255) NOT NULL,
4 `auth_key` varchar(32) NOT NULL,
5 `password_hash` varchar(255) NOT NULL,
6 `password_reset_token` varchar(255) NULL,
7 `email` varchar(100) NOT NULL,
8 `status` smallint(10) NOT NULL,
9 `role` int(11) NULL,
10 `created_at` int(11) NOT NULL,
11 `updated_at` int(11) NOT NULL,
12 PRIMARY KEY (`id`)
13);