/*
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
没有合适的资源?快使用搜索试试~ 我知道了~
登录专栏 004 验证码注册
共1044个文件
js:476个
css:192个
vue:116个
0 下载量 149 浏览量
2024-05-05
22:06:18
上传
评论
收藏 2.46MB RAR 举报
温馨提示
登录专栏 004 验证码注册
资源推荐
资源详情
资源评论
收起资源包目录
登录专栏 004 验证码注册 (1044个子文件)
mvnw.cmd 8KB
index.css 234KB
index.css 234KB
cascader.css 29KB
cascader.css 29KB
date-picker.css 28KB
date-picker.css 28KB
transfer.css 27KB
transfer.css 27KB
col.css 25KB
col.css 25KB
pagination.css 23KB
pagination.css 23KB
table.css 23KB
table.css 23KB
time-picker.css 21KB
time-picker.css 21KB
message-box.css 21KB
message-box.css 21KB
select.css 19KB
select.css 19KB
slider.css 18KB
slider.css 18KB
tabs.css 16KB
tabs.css 16KB
base.css 16KB
base.css 16KB
dropdown.css 14KB
dropdown.css 14KB
time-select.css 13KB
time-select.css 13KB
table-column.css 13KB
table-column.css 13KB
cascader-panel.css 13KB
cascader-panel.css 13KB
tree.css 13KB
tree.css 13KB
upload.css 13KB
upload.css 13KB
icon.css 12KB
icon.css 12KB
calendar.css 11KB
calendar.css 11KB
autocomplete.css 10KB
autocomplete.css 10KB
input-number.css 10KB
input-number.css 10KB
button.css 10KB
button.css 10KB
menu.css 9KB
menu.css 9KB
color-picker.css 7KB
color-picker.css 7KB
checkbox.css 7KB
checkbox.css 7KB
input.css 7KB
input.css 7KB
step.css 5KB
step.css 5KB
collapse.css 5KB
collapse.css 5KB
drawer.css 5KB
drawer.css 5KB
tag.css 5KB
tag.css 5KB
image.css 3KB
image.css 3KB
radio.css 3KB
radio.css 3KB
select-dropdown.css 3KB
select-dropdown.css 3KB
descriptions.css 3KB
descriptions.css 3KB
form.css 3KB
form.css 3KB
dialog.css 3KB
dialog.css 3KB
tooltip.css 3KB
tooltip.css 3KB
carousel.css 2KB
carousel.css 2KB
radio-button.css 2KB
radio-button.css 2KB
progress.css 2KB
progress.css 2KB
popover.css 2KB
popover.css 2KB
link.css 2KB
link.css 2KB
message.css 2KB
message.css 2KB
alert.css 2KB
alert.css 2KB
switch.css 2KB
switch.css 2KB
notification.css 2KB
notification.css 2KB
loading.css 2KB
loading.css 2KB
skeleton.css 2KB
共 1044 条
- 1
- 2
- 3
- 4
- 5
- 6
- 11
资源评论
简洁冬冬
- 粉丝: 1670
- 资源: 46
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功