/* Navicat Premium Data Transfer Source Server : 192.168.3.110-宝塔 Source Server Type : MySQL Source Server Version : 50650 Source Host : 127.0.0.1:3306 Source Schema : sange_bridge Target Server Type : MySQL Target Server Version : 50650 File Encoding : 65001 Date: 12/08/2021 23:24:35 */ 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(20) UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `type` tinyint(4) 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 NULL, `created_at` timestamp(0) NULL DEFAULT NULL, `updated_at` timestamp(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, INDEX `admin_extension_histories_name_index`(`name`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for admin_extensions -- ---------------------------- DROP TABLE IF EXISTS `admin_extensions`; CREATE TABLE `admin_extensions` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, `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(4) NOT NULL DEFAULT 0, `options` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL, `created_at` timestamp(0) NULL DEFAULT NULL, `updated_at` timestamp(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `admin_extensions_name_unique`(`name`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for admin_menu -- ---------------------------- DROP TABLE IF EXISTS `admin_menu`; CREATE TABLE `admin_menu` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `parent_id` bigint(20) NOT NULL DEFAULT 0, `order` int(11) 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 NULL DEFAULT NULL, `uri` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `extension` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `show` tinyint(4) NOT NULL DEFAULT 1, `created_at` timestamp(0) NULL DEFAULT NULL, `updated_at` timestamp(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of admin_menu -- ---------------------------- INSERT INTO `admin_menu` VALUES (1, 0, 1, 'Index', 'feather icon-bar-chart-2', '/', '', 0, '2021-08-08 05:47:29', '2021-08-12 14:48:44'); INSERT INTO `admin_menu` VALUES (2, 0, 2, 'Admin', 'feather icon-settings', '', '', 1, '2021-08-08 05:47:29', '2021-08-12 14:46:01'); INSERT INTO `admin_menu` VALUES (3, 2, 3, 'Users', '', 'auth/users', '', 1, '2021-08-08 05:47:29', NULL); INSERT INTO `admin_menu` VALUES (4, 2, 4, 'Roles', '', 'auth/roles', '', 1, '2021-08-08 05:47:29', NULL); INSERT INTO `admin_menu` VALUES (5, 2, 5, 'Permission', '', 'auth/permissions', '', 1, '2021-08-08 05:47:29', NULL); INSERT INTO `admin_menu` VALUES (6, 2, 6, 'Menu', '', 'auth/menu', '', 1, '2021-08-08 05:47:29', NULL); INSERT INTO `admin_menu` VALUES (7, 2, 7, 'Extensions', '', 'auth/extensions', '', 1, '2021-08-08 05:47:29', NULL); INSERT INTO `admin_menu` VALUES (8, 0, 8, '用户管理', 'fa-users', NULL, '', 1, '2021-08-12 14:47:10', '2021-08-12 14:48:13'); INSERT INTO `admin_menu` VALUES (9, 8, 9, '用户列表', NULL, '/users', '', 1, '2021-08-12 14:48:31', '2021-08-12 14:48:31'); INSERT INTO `admin_menu` VALUES (10, 0, 10, '会员管理', 'fa-user-secret', '/member', '', 1, '2021-08-12 14:58:18', '2021-08-12 14:58:18'); INSERT INTO `admin_menu` VALUES (11, 0, 11, '分销管理', 'fa-share-alt', NULL, '', 1, '2021-08-12 14:59:47', '2021-08-12 14:59:47'); INSERT INTO `admin_menu` VALUES (12, 11, 12, '分销设置', NULL, '/ShareSetting', '', 1, '2021-08-12 15:00:49', '2021-08-12 15:00:49'); INSERT INTO `admin_menu` VALUES (13, 11, 13, '提现设置', NULL, '/WithdrawSetting', '', 1, '2021-08-12 15:01:33', '2021-08-12 15:01:33'); INSERT INTO `admin_menu` VALUES (14, 11, 14, '收益记录', NULL, '/IncomeRecord', '', 1, '2021-08-12 15:02:01', '2021-08-12 15:02:26'); INSERT INTO `admin_menu` VALUES (15, 11, 15, '提现管理', NULL, 'Withdraw', '', 1, '2021-08-12 15:02:17', '2021-08-12 15:02:34'); INSERT INTO `admin_menu` VALUES (16, 0, 16, '系统设置', NULL, 'SystemSetting', '', 1, '2021-08-12 15:03:20', '2021-08-12 15:03:20'); -- ---------------------------- -- Table structure for admin_permission_menu -- ---------------------------- DROP TABLE IF EXISTS `admin_permission_menu`; CREATE TABLE `admin_permission_menu` ( `permission_id` bigint(20) NOT NULL, `menu_id` bigint(20) NOT NULL, `created_at` timestamp(0) NULL DEFAULT NULL, `updated_at` timestamp(0) NULL 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 = Compact; -- ---------------------------- -- Records of admin_permission_menu -- ---------------------------- INSERT INTO `admin_permission_menu` VALUES (8, 9, '2021-08-12 14:55:50', '2021-08-12 14:55:50'); -- ---------------------------- -- Table structure for admin_permissions -- ---------------------------- DROP TABLE IF EXISTS `admin_permissions`; CREATE TABLE `admin_permissions` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `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(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `http_path` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL, `order` int(11) NOT NULL DEFAULT 0, `parent_id` bigint(20) NOT NULL DEFAULT 0, `created_at` timestamp(0) NULL DEFAULT NULL, `updated_at` timestamp(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `admin_permissions_slug_unique`(`slug`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of admin_permissions -- ---------------------------- INSERT INTO `admin_permissions` VALUES (1, 'Auth management', 'auth-management', '', '', 1, 0, '2021-08-08 05:47:29', NULL); INSERT INTO `admin_permissions` VALUES (2, 'Users', 'users', '', '/auth/users*', 2, 1, '2021-08-08 05:47:29', NULL); INSERT INTO `admin_permissions` VALUES (3, 'Roles', 'roles', '', '/auth/roles*', 3, 1, '2021-08-08 05:47:29', NULL); INSERT INTO `admin_permissions` VALUES (4, 'Permissions', 'permissions', '', '/auth/permissions*', 4, 1, '2021-08-08 05:47:29', NULL); INSERT INTO `admin_permissions` VALUES (5, 'Menu', 'menu', '', '/auth/menu*', 5, 1, '2021-08-08 05:47:29', NULL); INSERT INTO `admin_permissions` VALUES (6, 'Extension', 'extension', '', '/auth/extensions*', 6, 1, '2021-08-08 05:47:29', NULL); INSERT INTO `admin_permissions` VALUES (7, '用户管理', 'user', '', '', 7, 0, '2021-08-12 14:55:15', '2021-08-12 14:55:15'); INSERT INTO `admin_permissions` VALUES (8, '员工列表', '员工列表', '', '/users*', 8, 7, '2021-08-12 14:55:50', '2021-08-12 14:55:50'); -- ---------------------------- -- Table structure for admin_role_menu -- ---------------------------- DROP TABLE IF EXISTS `admin_role_menu`; CREATE TABLE `admin_role_menu` ( `role_id` bigint(20) NOT NULL, `menu_id` bigint(20) NOT NULL, `created_at` timestamp(0) NULL DEFAULT NULL, `updated_at` timestamp(0) NULL 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 = Compact; -- ---------------------------- -- Records of admin_role_menu -- ---------------------------- INSERT INTO `admin_role_menu` VALUES (2, 8, '2021-08-12 14:51:26', '2021-08-12 14:51:26'); INSERT INTO `admin_role_menu` VALUES (2, 9, '2021-08-12 14:51:26', '2021-08-12 14:51:26'); INSERT INTO `admin_role_menu` VALUES (2, 10, '2021-08-12 14:58:18', '2021-08-12 14:58:18'); INSERT INTO `admin_role_menu` VALUES (2, 11, '2021-08-12 14:59:47', '2021-08-12 14:59:47'); INSERT INTO `admin_role_menu` VALUES (2, 12, '2021-08-12 15:00:49', '2021-08-12 15:00:49'); INSERT INTO `admin_role_menu` VALUES (2, 13, '2021-08-12 15:01:33', '2021-08-12 15:01:33'); INSERT INTO `admin_role_menu` VALUES (2, 14, '2021-08-12 15:02:01', '2021-08-12 15:02:01'); INSERT INTO `admin_role_menu` VALUES (2, 16, '2021-08-12 15:03:20', '2021-08-12 15:03:20'); -- ---------------------------- -- Table structure for admin_role_permissions -- ---------------------------- DROP TABLE IF EXISTS `admin_role_permissions`; CREATE TABLE `admin_role_permissions` ( `role_id` bigint(20) NOT NULL, `permission_id` bigint(20) NOT NULL, `created_at` timestamp(0) NULL DEFAULT NULL, `updated_at` timestamp(0) NULL 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 = Compact; -- ---------------------------- -- Records of admin_role_permissions -- ---------------------------- INSERT INTO `admin_role_permissions` VALUES (2, 8, '2021-08-12 14:56:05', '2021-08-12 14:56:05'); -- ---------------------------- -- Table structure for admin_role_users -- ---------------------------- DROP TABLE IF EXISTS `admin_role_users`; CREATE TABLE `admin_role_users` ( `role_id` bigint(20) NOT NULL, `user_id` bigint(20) NOT NULL, `created_at` timestamp(0) NULL DEFAULT NULL, `updated_at` timestamp(0) NULL 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 = Compact; -- ---------------------------- -- Records of admin_role_users -- ---------------------------- INSERT INTO `admin_role_users` VALUES (1, 1, '2021-08-08 05:47:29', '2021-08-08 05:47:29'); INSERT INTO `admin_role_users` VALUES (2, 2, '2021-08-12 14:52:50', '2021-08-12 14:52:50'); -- ---------------------------- -- Table structure for admin_roles -- ---------------------------- DROP TABLE IF EXISTS `admin_roles`; CREATE TABLE `admin_roles` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `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) NULL DEFAULT NULL, `updated_at` timestamp(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `admin_roles_slug_unique`(`slug`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of admin_roles -- ---------------------------- INSERT INTO `admin_roles` VALUES (1, 'Administrator', 'administrator', '2021-08-08 05:47:29', '2021-08-08 05:47:29'); INSERT INTO `admin_roles` VALUES (2, '后台管理员', 'manager', '2021-08-12 14:51:26', '2021-08-12 14:51:26'); -- ---------------------------- -- Table structure for admin_settings -- ---------------------------- DROP TABLE IF EXISTS `admin_settings`; CREATE TABLE `admin_settings` ( `slug` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp(0) NULL DEFAULT NULL, `updated_at` timestamp(0) NULL DEFAULT NULL, PRIMARY KEY (`slug`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for admin_users -- ---------------------------- DROP TABLE IF EXISTS `admin_users`; CREATE TABLE `admin_users` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `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(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `avatar` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `remember_token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `created_at` timestamp(0) NULL DEFAULT NULL, `updated_at` timestamp(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `admin_users_username_unique`(`username`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of admin_users -- ---------------------------- INSERT INTO `admin_users` VALUES (1, 'admin', '$2y$10$ITsyB.XFc8c23gsN7rIsjOE.zpYUw5xEmBz35KxG4ERr3PZRK4ps.', 'Administrator', NULL, '5TKj6wIdBkP78dQEwCxcLQm6GKeL8EE9gJhCcU07QITOJr8S5xv9uVR9tkbO', '2021-08-08 05:47:29', '2021-08-08 05:47:29'); INSERT INTO `admin_users` VALUES (2, 'manager', '$2y$10$xiECtZCKfHCyW1.RiVcju.Uc8anUJnWVQAcF3nbxpt5EFs1ke2f6a', 'manager', NULL, 'JrTXUH5aJ7YdBaHdDKEACoog5RDZchbsl9iKsC29cznhYCeVuNyg1pGLvJTy', '2021-08-12 14:52:50', '2021-08-12 14:52:50'); -- ---------------------------- -- Table structure for failed_jobs -- ---------------------------- DROP TABLE IF EXISTS `failed_jobs`; CREATE TABLE `failed_jobs` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `uuid` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `connection` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `queue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `exception` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `failed_at` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0), PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `failed_jobs_uuid_unique`(`uuid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for migrations -- ---------------------------- DROP TABLE IF EXISTS `migrations`; CREATE TABLE `migrations` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, `migration` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `batch` int(11) NOT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of migrations -- ---------------------------- INSERT INTO `migrations` VALUES (1, '2014_10_12_000000_create_users_table', 1); INSERT INTO `migrations` VALUES (2, '2014_10_12_100000_create_password_resets_table', 1); INSERT INTO `migrations` VALUES (3, '2016_01_04_173148_create_admin_tables', 1); INSERT INTO `migrations` VALUES (4, '2019_08_19_000000_create_failed_jobs_table', 1); INSERT INTO `migrations` VALUES (5, '2020_09_07_090635_create_admin_settings_table', 1); INSERT INTO `migrations` VALUES (6, '2020_09_22_015815_create_admin_extensions_table', 1); INSERT INTO `migrations` VALUES (7, '2020_11_01_083237_update_admin_menu_table', 1); -- ---------------------------- -- Table structure for password_resets -- ---------------------------- DROP TABLE IF EXISTS `password_resets`; CREATE TABLE `password_resets` ( `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp(0) NULL DEFAULT NULL, INDEX `password_resets_email_index`(`email`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for setting -- ---------------------------- DROP TABLE IF EXISTS `setting`; CREATE TABLE `setting` ( `id` int(11) NOT NULL AUTO_INCREMENT, `service_wechat` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '客服微信号', `service_qrcode` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '客服二维码', `created_at` timestamp(0) NULL DEFAULT NULL, `updated_at` timestamp(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统设置' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for share_config -- ---------------------------- DROP TABLE IF EXISTS `share_config`; CREATE TABLE `share_config` ( `id` int(11) NOT NULL AUTO_INCREMENT, `price` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '推荐奖励', `withdraw_discount` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '提现手续费 百分比', `withdraw_desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '提现说明', `is_open` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否开启分销', `created_at` timestamp(0) NULL DEFAULT NULL, `updated_at` timestamp(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '分销设置' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for user_share -- ---------------------------- DROP TABLE IF EXISTS `user_share`; CREATE TABLE `user_share` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL DEFAULT 0 COMMENT '用户', `child_id` int(11) NOT NULL DEFAULT 0 COMMENT '分销ID', `income` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '收入', `created_at` timestamp(0) NULL DEFAULT NULL, `updated_at` timestamp(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '分销明细' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for user_vip -- ---------------------------- DROP TABLE IF EXISTS `user_vip`; CREATE TABLE `user_vip` ( `id` int(11) NOT NULL AUTO_INCREMENT, `order_id` bigint(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT '订单ID', `user_id` int(11) NOT NULL DEFAULT 0 COMMENT '用户', `prepay_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '微信支付预付单ID', `serial_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '支付流水', `order_fee` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '金额', `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '状态', `created_at` timestamp(0) NULL DEFAULT NULL, `updated_at` timestamp(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户购买VIP记录' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for user_withdraw -- ---------------------------- DROP TABLE IF EXISTS `user_withdraw`; CREATE TABLE `user_withdraw` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL DEFAULT 0 COMMENT '用户', `name` int(11) NOT NULL DEFAULT 0 COMMENT '姓名', `type` int(11) NOT NULL DEFAULT 1 COMMENT '类型 1-微信', `account` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '提现账号', `price` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '提现金额', `desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '提现备注', `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '提现状态', `created_at` timestamp(0) NULL DEFAULT NULL, `updated_at` timestamp(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户提现' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for users -- ---------------------------- DROP TABLE IF EXISTS `users`; CREATE TABLE `users` ( `id` int(11) NOT NULL AUTO_INCREMENT, `nickname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '昵称', `openid` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'openid', `head_img` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '头像', `parent_id` int(11) NOT NULL DEFAULT 0 COMMENT '上级推荐用户', `phone_num` varchar(13) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '手机号', `income` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '收入', `is_vip` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否VIP', `share_qrcode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '分享二维码', `scene_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '情景CODE', `become_vip_at` timestamp(0) NULL DEFAULT NULL COMMENT '成为VIP时间', `become_child_at` timestamp(0) NULL DEFAULT NULL COMMENT '成为下线时间', `created_at` timestamp(0) NULL DEFAULT NULL, `updated_at` timestamp(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for users_copy1 -- ---------------------------- DROP TABLE IF EXISTS `users_copy1`; CREATE TABLE `users_copy1` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `email_verified_at` timestamp(0) NULL DEFAULT NULL, `password` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `remember_token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `created_at` timestamp(0) NULL DEFAULT NULL, `updated_at` timestamp(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `users_email_unique`(`email`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of users_copy1 -- ---------------------------- INSERT INTO `users_copy1` VALUES (1, '测试', '', NULL, '', NULL, NULL, NULL); SET FOREIGN_KEY_CHECKS = 1;