登录专栏 004 验证码注册

/* Navicat Premium Data Transfer Source Server : 123.60.82.22 Source Server Type : MySQL Source Server Version : 80036 Source Host : 123.60.82.22:3306 Source Schema : fshop_app Target Server Type : MySQL Target Server Version : 80036 File Encoding : 65001 Date: 05/05/2024 21:03:38 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for user -- ---------------------------- DROP TABLE IF EXISTS `user`; CREATE TABLE `user` ( `user_id` int(0) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '用户ID', `user_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '用户名', `user_password_hash` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '用户密码，加密', `user_avatar_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '头像URL', `user_phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '手机号码', `user_status` tinyint(0) NOT NULL COMMENT '用户状态：已注销0、已冻结1、已激活2', `version` int(0) UNSIGNED NOT NULL DEFAULT 1 COMMENT '版本', `user_create_time` datetime(0) NOT NULL COMMENT '创建（注册）时间', `update_time` datetime(0) NOT NULL COMMENT '最近更新时间', `other1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `other2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, PRIMARY KEY (`user_id`) USING BTREE, UNIQUE INDEX `user_name`(`user_name`) USING BTREE, UNIQUE INDEX `user_phone`(`user_phone`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '用户表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of user -- ---------------------------- INSERT INTO `user` VALUES (1, 'root', '123456', 'user_avatar/root.png', '17800000000', 1, 1, '2022-01-05 15:22:21', '2024-05-05 15:22:33', NULL, NULL); INSERT INTO `user` VALUES (2, 'cSLgm5N8tSsQusSB3QNQ', 'c7DWhhNR1dHerLu8M9Z7YK2auozAt6ki', 'user_avatar/default.png', '13293610316', 0, 1, '2022-02-21 05:43:10', '2024-05-05 15:31:55', NULL, NULL); INSERT INTO `user` VALUES (3, 'ipP7kqPDvmHjZo1fmJhg', 'NKWbsH0Y8TpkTseLCMHfCSa0EWCVWQGw', 'user_avatar/default.png', '15180347606', 0, 1, '2022-12-27 03:13:38', '2024-05-05 10:26:09', NULL, NULL); INSERT INTO `user` VALUES (4, 'xO5j7NmWK0vMfBg3UCii', 'E8YPfUyOtB1blJoaKNHrRh8bwgslQQYv', 'user_avatar/default.png', '17057495348', 2, 1, '2022-10-23 05:41:58', '2024-05-05 15:42:22', NULL, NULL); INSERT INTO `user` VALUES (5, 'ZNag5yBnToMtszucfKCn', 'waDggxIfwvD6mpmYq26r86lZIDjzQAoh', 'user_avatar/default.png', '17266480845', 2, 1, '2022-03-23 02:57:55', '2024-05-05 13:45:39', NULL, NULL); INSERT INTO `user` VALUES (6, 'iWRul7496REWcZt3ZgUn', 'TdkQEW5X9OU7odOZlvYZwYkJ4YDGKJi3', 'user_avatar/default.png', '15273481813', 1, 1, '2023-12-05 07:01:01', '2024-05-05 15:14:49', NULL, NULL); INSERT INTO `user` VALUES (7, 'X41eghbgPBtPamsoq9jH', 'RLfisIER5hZCEKkKelAhW23kVh1C0fCc', 'user_avatar/default.png', '13932243843', 1, 1, '2024-04-09 23:26:26', '2024-05-05 04:29:36', NULL, NULL); INSERT INTO `user` VALUES (8, 'fjIKwOHqlfGpHvVEDFpY', '9G7s8eeB2SpZsTNTqlH66WqWAk1cMWeQ', 'user_avatar/default.png', '13398931648', 2, 1, '2024-04-15 10:32:17', '2024-05-05 12:46:44', NULL, NULL); INSERT INTO `user` VALUES (9, 'lJXRBH8WvvjePh5xcPT6', 'qF1CxpSioZ2Wtp7HqHLgUmoEPeJ2TNGK', 'user_avatar/default.png', '13284682634', 0, 1, '2023-06-14 19:14:50', '2024-05-05 13:51:18', NULL, NULL); INSERT INTO `user` VALUES (10, 'C7mr8JjcCGHysUeiLBzX', 'pr86BZQmVdwHGK4vB5x5ThpVVCzTkGeq', 'user_avatar/default.png', '17035291348', 2, 1, '2024-03-10 17:02:26', '2024-05-05 07:31:54', NULL, NULL); INSERT INTO `user` VALUES (11, 'wtnDkIR07FeUS1jbd4Mq', 'wqH1COg0gtRdmlBNrOGtXArkCGH2jbxR', 'user_avatar/default.png', '17961376078', 1, 1, '2022-04-19 05:55:32', '2024-05-05 05:13:21', NULL, NULL); INSERT INTO `user` VALUES (12, 'VT08lQz59e9R7JMq5V39', 'piwwkyty0MPEJoBJV3pFhAdgphlzWfo0', 'user_avatar/default.png', '17827542894', 0, 1, '2022-08-02 18:28:34', '2024-05-05 23:43:03', NULL, NULL); INSERT INTO `user` VALUES (13, 'MxbDDZKKDX9sRy7ihVMI', '6jB0TS8VJTQKiTuEa2Umzzq1cebjC3Mm', 'user_avatar/default.png', '13657651459', 1, 1, '2023-04-21 21:18:35', '2024-05-05 08:38:19', NULL, NULL); INSERT INTO `user` VALUES (14, 'bimNFMeTXK3RR0ydL6nl', 'WnxO6pUMDDiEf3CPB5aBawaCPrBgWqOO', 'user_avatar/default.png', '13680296704', 1, 1, '2022-07-03 19:17:00', '2024-05-05 23:52:31', NULL, NULL); INSERT INTO `user` VALUES (15, 'o1qUgo1lClEHHVKZoy5I', 'qVEbgknJHB5FU5aoRDPVRDPmTV2pTcJn', 'user_avatar/default.png', '17562468401', 0, 1, '2023-06-27 21:37:23', '2024-05-05 17:49:13', NULL, NULL); INSERT INTO `user` VALUES (16, 'WFXR8EEAsXhzvVfZ24Fs', 'VmgwDQgMzQyVUoKzCddM695Dob7amQf5', 'user_avatar/default.png', '13709789242', 0, 1, '2022-05-20 20:51:42', '2024-05-05 05:06:26', NULL, NULL); INSERT INTO `user` VALUES (17, 'RGTKQmZ2TevvPaP6xsVT', 't9P0BJZMWFRlYcpMNHg60vOovaHG68aL', 'user_avatar/default.png', '15530651667', 2, 1, '2022-02-19 11:39:28', '2024-05-05 09:45:52', NULL, NULL); INSERT INTO `user` VALUES (18, 'Vh5Q4kQ7vzqFFTJZP3ir', 'bHK0TSkHM7eZc8GKlUyxtLXcjdyNp2sl', 'user_avatar/default.png', '13973342369', 0, 1, '2022-08-09 14:07:15', '2024-05-05 12:16:38', NULL, NULL); INSERT INTO `user` VALUES (19, 'vGt40zkGfqfqlpBlwx7c', 'zeg7SVfGkPNt2HnJEtgeIPRzlZTbUV66', 'user_avatar/default.png', '13206216614', 0, 1, '2022-03-15 15:09:27', '2024-05-05 11:14:44', NULL, NULL); INSERT INTO `user` VALUES (20, 'uRG9PZvughxEU2cpxLrK', 'npr01A6dVs73PFserQqSyXMObEBkK6oX', 'user_avatar/default.png', '17646487407', 1, 1, '2023-05-18 17:19:00', '2024-05-05 21:06:30', NULL, NULL); INSERT INTO `user` VALUES (21, 'AAmVJwahzPs3nrl4EZG0', 'i3Hj1m2xO2LHrPGOdOGrOvz09BlCOvpK', 'user_avatar/default.png', '13597709896', 1, 1, '2024-03-18 18:13:08', '2024-05-05 13:15:40', NULL, NULL); INSERT INTO `user` VALUES (22, 'HHg467AUgGk8vKrL6Ti6', 'auDXz5iNajqknVjMv5Dqib2Vnrsz7Vtw', 'user_avatar/default.png', '13153987153', 1, 1, '2022-08-05 12:45:08', '2024-05-05 09:26:58', NULL, NULL); INSERT INTO `user` VALUES (23, 'QG50jg7imRFYX5Ac5boq', 'zC6gz3KMazxdVqhSF2fJQPg6vIkMw9i7', 'user_avatar/default.png', '17430359100', 1, 1, '2022-02-27 15:47:28', '2024-05-05 08:28:11', NULL, NULL); INSERT INTO `user` VALUES (24, 'bfALYc9Wrl7fciCaRHg2', 'SlT02zLafbLTBBzAkevJR7hEAwigeTnJ', 'user_avatar/default.png', '15749907921', 0, 1, '2022-11-01 06:10:20', '2024-05-05 01:29:59', NULL, NULL); INSERT INTO `user` VALUES (25, 'fKxyrPHOgSLpmtGxIL0F', 'rYVAHDmfdX9zpafqb2LVZ17Dx8C7MIvI', 'user_avatar/default.png', '15624704433', 2, 1, '2024-04-02 19:49:04', '2024-05-05 06:48:01', NULL, NULL); INSERT INTO `user` VALUES (26, 'lBJFcAYaD8taC4F5T1AE', '5zylKrNHtDEpPNsgn6FtDlnIdxpumaP0', 'user_avatar/default.png', '13121558454', 1, 1, '2023-07-22 19:35:48', '2024-05-05 14:45:36', NULL, NULL); INSERT INTO `user` VALUES (27, 'xVwUC6CC215ul8fNDQWI', '49Xnh0KAWvXO5ZpJFH5Lsgqa4FjdkVP0', 'user_avatar/default.png', '15971256772', 0, 1, '2024-02-13 10:11:33', '2024-05-05 03:30:02', NULL, NULL); INSERT INTO `user` VALUES (28, 'eE764k22O1eRu51NVNmz', 'NC3JMRiuuIzWDe37Xyb9QG4SjeLDSOT1', 'user_avatar/default.png', '17641616561', 2, 1, '2022-04-10 22:19:41', '2024-05-05 20:57:02', NULL, NULL); INSERT INTO `user` VALUES (29, 'ZdBU7o33I9PP2HMZAbEq', 'LSH7aR9iGMBhOaxlzMdsnyc6Rr0kdaj2', 'user_avatar/default.png', '15392850100', 1, 1, '2023-09-01 22:49:34', '2024-05-05 10:01:43', NULL, NULL); INSERT INTO `user` VALUES (30, 'hqtGnTv5UEIzC0ehatL2', '1aLZryPouHwACxQvmizYROygHBm0SJrh', 'user_avatar/default.png', '17161667824', 0, 1, '2022-09-10 01:08:02', '2024-05-05 14:07:42', NULL, NULL); INSERT INTO `user` VALUES (31, 'gG9HWaVBggn9gc9XStJs', '0msmOCdWh0mkhB62hWQd6KxjsjuxnPtW', 'user_avatar/default.png', '13367345568', 1, 1, '202