· 8 years ago · May 09, 2018, 05:02 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) NOT NULL,
7 `email` varchar(100) NOT NULL,
8 `status` smallint(10) NOT NULL,
9 `role` int(11) NOT NULL,
10 `created_at` int(11) NOT NULL,
11 `updated_at` int(11) NOT NULL,
12 PRIMARY KEY (`id`)
13);
14# And the data.
15INSERT INTO `user` (`id`, `username`, `auth_key`, `password_hash`, `password_reset_token`, `email`, `status`, `role`, `created_at`, `updated_at`) VALUES
16(1, 'admin', '', '$2y$13$uqe3LPW9ya3RZhynJpPN5um9fvdxUmoqjOqQBJDdIDXSKxRZB5bPu', '', '', 10, 0, 0, 0);
17# Now you can login with username admin and password 123qwe