/* Navicat Premium Data Transfer Source Server : localhost Source Server Type : MySQL Source Server Version : 80019 Source Host : 127.0.0.1:3306 Source Schema : zhaosheng Target Server Type : MySQL Target Server Version : 80019 File Encoding : 65001 Date: 07/04/2022 18:25:26 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for admin_extension_histories -- ---------------------------- DROP TABLE IF EXISTS `admin_extension_histories`; CREATE TABLE `admin_extension_histories` ( `id` bigint unsigned NOT NULL, `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `type` tinyint(0) NOT NULL DEFAULT 1, `version` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', `detail` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `created_at` timestamp(0) DEFAULT NULL, `updated_at` timestamp(0) DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, INDEX `admin_extension_histories_name_index`(`name`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '后台扩展历史' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for admin_extensions -- ---------------------------- DROP TABLE IF EXISTS `admin_extensions`; CREATE TABLE `admin_extensions` ( `id` int unsigned NOT NULL, `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `version` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `is_enabled` tinyint(0) NOT NULL DEFAULT 0, `options` json, `created_at` timestamp(0) DEFAULT NULL, `updated_at` timestamp(0) DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `admin_extensions_name_unique`(`name`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '后台扩展' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for admin_menu -- ---------------------------- DROP TABLE IF EXISTS `admin_menu`; CREATE TABLE `admin_menu` ( `id` bigint unsigned NOT NULL, `parent_id` bigint(0) NOT NULL DEFAULT 0, `order` int(0) NOT NULL DEFAULT 0, `title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `icon` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `uri` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `extension` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `show` tinyint(0) NOT NULL DEFAULT 1, `created_at` timestamp(0) DEFAULT NULL, `updated_at` timestamp(0) DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 26 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '后台菜单' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of admin_menu -- ---------------------------- INSERT INTO `admin_menu` VALUES (1, 0, 1, '首页', 'feather icon-bar-chart-2', '/', '', 1, '2020-12-29 14:56:41', '2021-02-04 18:29:10'); INSERT INTO `admin_menu` VALUES (2, 0, 20, '后台管理', 'feather icon-settings', NULL, '', 1, '2020-12-29 14:56:41', '2021-07-06 15:24:48'); INSERT INTO `admin_menu` VALUES (3, 2, 21, '用户', NULL, 'auth/users', '', 1, '2020-12-29 14:56:41', '2021-07-06 15:24:48'); INSERT INTO `admin_menu` VALUES (4, 2, 22, '角色', NULL, 'auth/roles', '', 1, '2020-12-29 14:56:41', '2021-07-06 15:24:48'); INSERT INTO `admin_menu` VALUES (5, 2, 23, '权限', NULL, 'auth/permissions', '', 1, '2020-12-29 14:56:41', '2021-07-06 15:24:48'); INSERT INTO `admin_menu` VALUES (6, 2, 24, '菜单', NULL, 'auth/menu', '', 1, '2020-12-29 14:56:41', '2021-07-06 15:24:48'); INSERT INTO `admin_menu` VALUES (7, 2, 25, 'Extensions', '', 'auth/extensions', '', 0, '2020-12-29 14:56:41', '2021-07-06 15:24:48'); INSERT INTO `admin_menu` VALUES (8, 0, 2, '商户管理', 'fa-handshake-o', '/merchant', '', 1, '2021-06-29 09:49:53', '2022-04-07 17:20:07'); -- ---------------------------- -- Table structure for admin_permission_menu -- ---------------------------- DROP TABLE IF EXISTS `admin_permission_menu`; CREATE TABLE `admin_permission_menu` ( `permission_id` bigint(0) NOT NULL, `menu_id` bigint(0) NOT NULL, `created_at` timestamp(0) DEFAULT NULL, `updated_at` timestamp(0) DEFAULT NULL, UNIQUE INDEX `admin_permission_menu_permission_id_menu_id_unique`(`permission_id`, `menu_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '后台权限菜单关联表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of admin_permission_menu -- ---------------------------- INSERT INTO `admin_permission_menu` VALUES (1, 9, '2021-07-01 15:23:52', '2021-07-01 15:23:52'); INSERT INTO `admin_permission_menu` VALUES (2, 9, '2021-07-01 15:23:52', '2021-07-01 15:23:52'); INSERT INTO `admin_permission_menu` VALUES (3, 9, '2021-07-01 15:23:52', '2021-07-01 15:23:52'); INSERT INTO `admin_permission_menu` VALUES (4, 9, '2021-07-01 15:23:53', '2021-07-01 15:23:53'); INSERT INTO `admin_permission_menu` VALUES (5, 9, '2021-07-01 15:23:53', '2021-07-01 15:23:53'); INSERT INTO `admin_permission_menu` VALUES (6, 9, '2021-07-01 15:23:53', '2021-07-01 15:23:53'); -- ---------------------------- -- Table structure for admin_permissions -- ---------------------------- DROP TABLE IF EXISTS `admin_permissions`; CREATE TABLE `admin_permissions` ( `id` bigint unsigned NOT NULL, `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `http_method` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `http_path` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `order` int(0) NOT NULL DEFAULT 0, `parent_id` bigint(0) NOT NULL DEFAULT 0, `created_at` timestamp(0) DEFAULT NULL, `updated_at` timestamp(0) DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `admin_permissions_slug_unique`(`slug`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '后台权限表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of admin_permissions -- ---------------------------- INSERT INTO `admin_permissions` VALUES (1, 'Auth management', 'auth-management', '', '', 1, 0, '2020-12-29 14:56:41', NULL); INSERT INTO `admin_permissions` VALUES (2, 'Users', 'users', '', '/auth/users*', 2, 1, '2020-12-29 14:56:41', NULL); INSERT INTO `admin_permissions` VALUES (3, 'Roles', 'roles', '', '/auth/roles*', 3, 1, '2020-12-29 14:56:41', NULL); INSERT INTO `admin_permissions` VALUES (4, 'Permissions', 'permissions', '', '/auth/permissions*', 4, 1, '2020-12-29 14:56:41', NULL); INSERT INTO `admin_permissions` VALUES (5, 'Menu', 'menu', '', '/auth/menu*', 5, 1, '2020-12-29 14:56:41', NULL); INSERT INTO `admin_permissions` VALUES (6, 'Extension', 'extension', '', '/auth/extensions*', 6, 1, '2020-12-29 14:56:41', NULL); -- ---------------------------- -- Table structure for admin_role_menu -- ---------------------------- DROP TABLE IF EXISTS `admin_role_menu`; CREATE TABLE `admin_role_menu` ( `role_id` bigint(0) NOT NULL, `menu_id` bigint(0) NOT NULL, `created_at` timestamp(0) DEFAULT NULL, `updated_at` timestamp(0) DEFAULT NULL, UNIQUE INDEX `admin_role_menu_role_id_menu_id_unique`(`role_id`, `menu_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '后台角色菜单表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for admin_role_permissions -- ---------------------------- DROP TABLE IF EXISTS `admin_role_permissions`; CREATE TABLE `admin_role_permissions` ( `role_id` bigint(0) NOT NULL, `permission_id` bigint(0) NOT NULL, `created_at` timestamp(0) DEFAULT NULL, `updated_at` timestamp(0) DEFAULT NULL, UNIQUE INDEX `admin_role_permissions_role_id_permission_id_unique`(`role_id`, `permission_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '后台角色权限表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for admin_role_users -- ---------------------------- DROP TABLE IF EXISTS `admin_role_users`; CREATE TABLE `admin_role_users` ( `role_id` bigint(0) NOT NULL, `user_id` bigint(0) NOT NULL, `created_at` timestamp(0) DEFAULT NULL, `updated_at` timestamp(0) DEFAULT NULL, UNIQUE INDEX `admin_role_users_role_id_user_id_unique`(`role_id`, `user_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '后台用户角色关联表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of admin_role_users -- ---------------------------- INSERT INTO `admin_role_users` VALUES (1, 1, '2020-12-29 14:56:41', '2020-12-29 14:56:41'); -- ---------------------------- -- Table structure for admin_roles -- ---------------------------- DROP TABLE IF EXISTS `admin_roles`; CREATE TABLE `admin_roles` ( `id` bigint unsigned NOT NULL, `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp(0) DEFAULT NULL, `updated_at` timestamp(0) DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `admin_roles_slug_unique`(`slug`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '后台角色表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of admin_roles -- ---------------------------- INSERT INTO `admin_roles` VALUES (1, 'Administrator', 'administrator', '2020-12-29 14:56:41', '2020-12-29 14:56:41'); -- ---------------------------- -- Table structure for admin_settings -- ---------------------------- DROP TABLE IF EXISTS `admin_settings`; CREATE TABLE `admin_settings` ( `id` int unsigned NOT NULL, `slug` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '类型', `des` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '描述', `created_at` int(0) DEFAULT NULL, `updated_at` int(0) DEFAULT NULL, `deleted_at` int(0) DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '后台设置表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of admin_settings -- ---------------------------- INSERT INTO `admin_settings` VALUES (1, 'company_name', '', 'input', NULL, NULL, NULL, NULL); INSERT INTO `admin_settings` VALUES (2, 'company_address', '', 'input', NULL, NULL, NULL, NULL); INSERT INTO `admin_settings` VALUES (3, 'company_tel', '', 'input', NULL, NULL, NULL, NULL); INSERT INTO `admin_settings` VALUES (4, 'company_wechat', '', 'input', NULL, NULL, NULL, NULL); INSERT INTO `admin_settings` VALUES (5, 'company_record', '', 'image', '网站备案号', NULL, NULL, NULL); INSERT INTO `admin_settings` VALUES (6, 'member_time', '', 'input', '付费会员时效，默认为365天，单位为天', NULL, NULL, NULL); INSERT INTO `admin_settings` VALUES (7, 'company_name 11', '', '发放日', NULL, 1611829713, 1611830452, 1611830452); -- ---------------------------- -- Table structure for admin_users -- ---------------------------- DROP TABLE IF EXISTS `admin_users`; CREATE TABLE `admin_users` ( `id` bigint unsigned NOT NULL, `username` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `password` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `remember_token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp(0) DEFAULT NULL, `updated_at` timestamp(0) DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `admin_users_username_unique`(`username`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '后台用户表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of admin_users -- ---------------------------- INSERT INTO `admin_users` VALUES (1, 'admin', '$2y$10$9cFhLisfHAItbQIbAiRrPOnhcRkuVpc/eWtJD8pmC62eYKGH2Mkf2', 'Administrator', NULL, 'b5UqxPxXnNqarfoTAyNGN08AuDjVKwJ1VAE72FIfqS1rc4rzULc8n3ZlicVB', '2020-12-29 14:56:41', '2020-12-29 16:19:53'); -- ---------------------------- -- Table structure for merchant_menu -- ---------------------------- DROP TABLE IF EXISTS `merchant_menu`; CREATE TABLE `merchant_menu` ( `id` bigint unsigned NOT NULL, `parent_id` bigint(0) NOT NULL DEFAULT 0, `order` int(0) NOT NULL DEFAULT 0, `title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `icon` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `show` tinyint(0) NOT NULL DEFAULT 1, `uri` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp(0) DEFAULT NULL, `updated_at` timestamp(0) DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 19 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '商户菜单' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for merchant_operation_log -- ---------------------------- DROP TABLE IF EXISTS `merchant_operation_log`; CREATE TABLE `merchant_operation_log` ( `id` bigint unsigned NOT NULL, `user_id` bigint(0) NOT NULL, `path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `method` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `input` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp(0) DEFAULT NULL, `updated_at` timestamp(0) DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, INDEX `admin_operation_log_user_id_index`(`user_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for merchant_permission_menu -- ---------------------------- DROP TABLE IF EXISTS `merchant_permission_menu`; CREATE TABLE `merchant_permission_menu` ( `permission_id` bigint(0) NOT NULL, `menu_id` bigint(0) NOT NULL, `created_at` timestamp(0) DEFAULT NULL, `updated_at` timestamp(0) DEFAULT NULL, UNIQUE INDEX `admin_permission_menu_permission_id_menu_id_unique`(`permission_id`, `menu_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for merchant_permissions -- ---------------------------- DROP TABLE IF EXISTS `merchant_permissions`; CREATE TABLE `merchant_permissions` ( `id` bigint unsigned NOT NULL, `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `http_method` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `http_path` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `order` int(0) NOT NULL DEFAULT 0, `parent_id` bigint(0) NOT NULL DEFAULT 0, `created_at` timestamp(0) DEFAULT NULL, `updated_at` timestamp(0) DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `admin_permissions_slug_unique`(`slug`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 23 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for merchant_role_menu -- ---------------------------- DROP TABLE IF EXISTS `merchant_role_menu`; CREATE TABLE `merchant_role_menu` ( `role_id` bigint(0) NOT NULL, `menu_id` bigint(0) NOT NULL, `created_at` timestamp(0) DEFAULT NULL, `updated_at` timestamp(0) DEFAULT NULL, UNIQUE INDEX `admin_role_menu_role_id_menu_id_unique`(`role_id`, `menu_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for merchant_role_permissions -- ---------------------------- DROP TABLE IF EXISTS `merchant_role_permissions`; CREATE TABLE `merchant_role_permissions` ( `role_id` bigint(0) NOT NULL, `permission_id` bigint(0) NOT NULL, `created_at` timestamp(0) DEFAULT NULL, `updated_at` timestamp(0) DEFAULT NULL, UNIQUE INDEX `admin_role_permissions_role_id_permission_id_unique`(`role_id`, `permission_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for merchant_role_users -- ---------------------------- DROP TABLE IF EXISTS `merchant_role_users`; CREATE TABLE `merchant_role_users` ( `role_id` bigint(0) NOT NULL, `user_id` bigint(0) NOT NULL, `created_at` timestamp(0) DEFAULT NULL, `updated_at` timestamp(0) DEFAULT NULL, UNIQUE INDEX `admin_role_users_role_id_user_id_unique`(`role_id`, `user_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for merchant_roles -- ---------------------------- DROP TABLE IF EXISTS `merchant_roles`; CREATE TABLE `merchant_roles` ( `id` bigint unsigned NOT NULL, `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp(0) DEFAULT NULL, `updated_at` timestamp(0) DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `admin_roles_slug_unique`(`slug`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for merchant_users -- ---------------------------- DROP TABLE IF EXISTS `merchant_users`; CREATE TABLE `merchant_users` ( `id` bigint unsigned NOT NULL, `username` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `password` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `remember_token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp(0) DEFAULT NULL, `updated_at` timestamp(0) DEFAULT NULL, `deleted_at` timestamp(0) DEFAULT NULL, `mid` int unsigned NOT NULL, `shop_id` int unsigned NOT NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `idx_username_unique`(`username`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 59 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '商户管理员' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of merchant_users -- ---------------------------- INSERT INTO `merchant_users` VALUES (1, 'admin', '$2y$10$TaWurVZspri13sMm1zkvuOvV2Myev4baTkmOQgKPrhE3D67/Au9Xa', 'merchant', NULL, NULL, '2022-04-07 15:23:46', '2022-04-07 18:21:15', NULL, 1, 0); INSERT INTO `merchant_users` VALUES (2, 'xiaoming', '$2y$10$RM.ZlhBoi3VrB52oaVh/Fec.xx4K5WKROdyRvlqc8Xzz95IAJy8R.', '小明', NULL, NULL, '2022-04-07 18:00:48', '2022-04-07 18:21:41', NULL, 1, 0); -- ---------------------------- -- Table structure for merchants -- ---------------------------- DROP TABLE IF EXISTS `merchants`; CREATE TABLE `merchants` ( `id` bigint unsigned NOT NULL COMMENT 'id', `logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'LOGO', `name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '商户名称', `contact` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '联系人', `tel` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '联系电话', `max_shop_num` int unsigned NOT NULL COMMENT '可创建的店铺数 0代表可以无限创建 ', `status` tinyint unsigned NOT NULL COMMENT '状态 0=禁用,1=正常', `created_at` datetime(0) NOT NULL COMMENT '创建时间', `updated_at` datetime(0) NOT NULL COMMENT '更新时间', `deleted_at` datetime(0) DEFAULT NULL COMMENT '删除时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 28 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '商户' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of merchants -- ---------------------------- INSERT INTO `merchants` VALUES (1, 'ceshi.png', '初始化测试商铺', '初始化测试商铺', '12345678910', 0, 1, '2022-04-07 17:27:50', '2022-04-07 17:27:50', NULL); -- ---------------------------- -- Table structure for users -- ---------------------------- DROP TABLE IF EXISTS `users`; CREATE TABLE `users` ( `id` int unsigned NOT NULL, `nickname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '昵称', `mobile` char(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '手机号码', `password` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '密码', `avatar` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '头像', `sex` tinyint(1) NOT NULL DEFAULT 0 COMMENT '性别\r\n0：未知\r\n1：男\r\n2：女', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态 1:正常使用 0禁用', `isteacher` tinyint unsigned NOT NULL COMMENT '是否是老师 0代表不是老师 1代表是老师', `ismanage` tinyint unsigned NOT NULL COMMENT '是否是官方管理员 0代表是不是管理员 1代表是官方管理员', `attentionnum` int unsigned NOT NULL COMMENT '关注人数', `fansnum` int unsigned NOT NULL COMMENT '粉丝人数', `des` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '简介', `created_at` bigint(0) NOT NULL COMMENT '创建时间', `updated_at` bigint(0) NOT NULL COMMENT '修改时间', `deleted_at` bigint(0) DEFAULT NULL COMMENT '删除时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户信息表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of users -- ---------------------------- INSERT INTO `users` VALUES (1, '咩咩1', '13886128089', '', 'c.jpg', 1, 1, 0, 0, 0, 0, '', 1625207741, 1628740252, NULL); INSERT INTO `users` VALUES (2, '用户5103', '13886128081', '', 'avatar.png', 0, 1, 0, 0, 0, 0, '', 1625207777, 1625207777, NULL); INSERT INTO `users` VALUES (3, '用户274621', '13886128082', '', 'avatar.png', 0, 1, 0, 0, 0, 0, '', 1625207781, 1625207781, NULL); INSERT INTO `users` VALUES (4, '用户502377', '13886128083', '', 'avatar.png', 0, 1, 0, 0, 0, 0, '', 1625207785, 1625207785, NULL); INSERT INTO `users` VALUES (5, '用户665832', '13886128084', '', 'avatar.png', 0, 1, 0, 0, 0, 0, '', 1625207789, 1625207789, NULL); INSERT INTO `users` VALUES (6, '用户557779', '13886128085', '', 'avatar.png', 0, 1, 0, 0, 0, 0, '', 1625207793, 1625207793, NULL); INSERT INTO `users` VALUES (7, '用户105385', '13886128086', '', 'avatar.png', 0, 1, 0, 0, 0, 0, '', 1625207846, 1625207846, NULL); INSERT INTO `users` VALUES (8, '用户430785', '13886128087', '', 'avatar.png', 0, 0, 0, 0, 0, 0, '', 1625207900, 1625542331, NULL); SET FOREIGN_KEY_CHECKS = 1;