master

分支 (4)

管理

管理

master

tuiguangpingtai

note

score

EasyJavaTemplate
/
sql
/
test.sql


-- ----------------------------
-- Table structure for app_swiper
-- ----------------------------
DROP TABLE IF EXISTS `app_swiper`;
CREATE TABLE `app_swiper`  (
                               `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
                               `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
                               `bus_type` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '轮播图业务类型',
                               `xuhao` int(11) NULL DEFAULT NULL COMMENT '序号',
                               `img_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '轮播图地址',
                               `img_desc` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '轮播图描述',
                               PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '轮播图表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of app_swiper
-- ----------------------------
INSERT INTO `app_swiper` VALUES (1, '2024-12-02 20:11:03', '首页轮播图', 1, 'https://20241202oss.oss-cn-beijing.aliyuncs.com/202412/EasyJavaTemplateTest/tuiguang/ic_banner04_20241202201310.png', '首页轮播图');
INSERT INTO `app_swiper` VALUES (2, '2024-12-02 20:12:40', '首页轮播图', 2, 'https://20241202oss.oss-cn-beijing.aliyuncs.com/202412/EasyJavaTemplateTest/tuiguang/ic_banner_20241202201239.png', '首页轮播图');
INSERT INTO `app_swiper` VALUES (3, '2024-12-02 20:12:52', '首页轮播图', 3, 'https://20241202oss.oss-cn-beijing.aliyuncs.com/202412/EasyJavaTemplateTest/tuiguang/ic_banner02_20241202201250.png', '首页轮播图');
INSERT INTO `app_swiper` VALUES (4, '2024-12-02 20:13:04', '首页轮播图', 4, 'https://20241202oss.oss-cn-beijing.aliyuncs.com/202412/EasyJavaTemplateTest/tuiguang/ic_banner03_20241202201303.png', '首页轮播图');

-- ----------------------------
-- Table structure for app_user
-- ----------------------------
DROP TABLE IF EXISTS `app_user`;
CREATE TABLE `app_user`  (
                             `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
                             `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
                             `login_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登录账号',
                             `login_pass` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登录密码',
                             `nick_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '昵称',
                             `user_img` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '用户头像',
                             `user_sex` int(1) NULL DEFAULT 0 COMMENT '用户性别（0：男；1：女）',
                             `user_phone` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户手机号',
                             `user_status` int(1) NULL DEFAULT NULL COMMENT '用户状态（1：正常；2：限制登录）',
                             `user_error` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '限制登录原因',
                             `user_brief` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户个人简介',
                             `last_login_time` datetime(0) NULL DEFAULT NULL COMMENT '最后一次登录时间',
                             `register_time` datetime(0) NULL DEFAULT NULL COMMENT '注册时间',
                             `user_school` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '毕业院校',
                             `user_major` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '专业名称',
                             `user_money` decimal(11, 2) NULL DEFAULT NULL COMMENT '账户余额',
                             `admin_flag` int(1) NULL DEFAULT 2 COMMENT '是否是管理员（1：是；2：否）',
                             `user_score` int(11) NULL DEFAULT NULL COMMENT '分数',
                             PRIMARY KEY (`id`) USING BTREE,
                             UNIQUE INDEX `uni_login_name`(`login_name`) USING BTREE,
                             UNIQUE INDEX `uni_nick_name`(`nick_name`) USING BTREE,
                             UNIQUE INDEX `uni_user_phone`(`user_phone`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 33 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'APP用户信息表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of app_user
-- ----------------------------
INSERT INTO `app_user` VALUES (2, '2024-05-12 18:39:17', '18088888881', '123456', '管理员', 'https://img0.baidu.com/it/u=3361482875,3939563024&fm=253&fmt=auto&app=138&f=JPEG', 1, '18088888881', 1, '', '', '2024-12-02 19:01:17', '2024-05-12 14:40:00', '', '', 0.00, 1, 155);
INSERT INTO `app_user` VALUES (3, '2024-04-17 15:44:33', '18088888882', '123456', '王天霸', 'https://img0.baidu.com/it/u=3361482875,3939563024&fm=253&fmt=auto&app=138&f=JPEG', 0, '18088888882', 1, NULL, NULL, NULL, '2024-05-12 14:40:00', NULL, NULL, 6000.00, 2, 80);

-- ----------------------------
-- Table structure for demo
-- ----------------------------
DROP TABLE IF EXISTS `demo`;
CREATE TABLE `demo`  (
                         `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
                         `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
                         PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'Demo表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of demo
-- ----------------------------

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user`  (
                             `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '用户ID',
                             `user_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '登录账号',
                             `real_name` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '真实姓名',
                             `email` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '用户邮箱',
                             `phonenumber` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '手机号码',
                             `avatar` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '头像地址',
                             `password` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '密码',
                             `remark` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
                             `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
                             `create_user_id` bigint(20) NULL DEFAULT NULL COMMENT '创建人',
                             `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
                             `update_user_id` bigint(20) NULL DEFAULT NULL COMMENT '更新人',
                             PRIMARY KEY (`id`) USING BTREE,
                             UNIQUE INDEX `un_user_name`(`user_name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 111 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户信息表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of sys_user
-- ----------------------------
INSERT INTO `sys_user` VALUES (109, 'admin', '波波老师', '1134135987@qq.com', '18086290000', 'https://img0.baidu.com/it/u=3361482875,3939563024&fm=253&fmt=auto&app=138&f=JPEG', 'e10adc3949ba59abbe56e057f20f883e', '管理员账号', '2023-05-01 18:47:50', 109, '2023-05-14 18:13:04', 109);
INSERT INTO `sys_user` VALUES (110, 'test', '王天霸', '1134135987@qq.com', '18088888888', 'https://img0.baidu.com/it/u=3361482875,3939563024&fm=253&fmt=auto&app=138&f=JPEG', 'e10adc3949ba59abbe56e057f20f883e', '123456', '2023-05-01 18:47:50', 109, '2023-05-14 18:14:39', 109);

SET FOREIGN_KEY_CHECKS = 1;