RUOYI-YD 商城模块sql文件

/* Navicat Premium Data Transfer Source Server : 127.0.0.1 MySQL Source Server Type : MySQL Source Server Version : 80200 (8.2.0) Source Host : 127.0.0.1:3306 Source Schema : ruoyi-vue-pro Target Server Type : MySQL Target Server Version : 80200 (8.2.0) File Encoding : 65001 Date: 03/05/2024 10:54:41 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for product_brand -- ---------------------------- DROP TABLE IF EXISTS `product_brand`; CREATE TABLE `product_brand` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '品牌编号', `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '品牌名称', `pic_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '品牌图片', `sort` int NULL DEFAULT 0 COMMENT '品牌排序', `description` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '品牌描述', `status` tinyint NOT NULL COMMENT '状态', `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除', `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '商品品牌'; -- ---------------------------- -- Records of product_brand -- ---------------------------- BEGIN; INSERT INTO `product_brand` (`id`, `name`, `pic_url`, `sort`, `description`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (1, '苹果', 'http://127.0.0.1:48080/admin-api/infra/file/4/get/047b5ef63a1b72ff5bfff423e4973c6a4821c8bf56dac6b0aa5972f50c2645d4.png', 1, '是上市', 0, '1', '2022-07-30 22:12:18', '1', '2023-08-31 14:26:05', b'0', 1), (2, '华为', 'http://127.0.0.1:48080/admin-api/infra/file/4/get/6a14445c06448a4133b74d5e67bbe32dfc4d0022cbef44e3d0669407bf18db15.png', 0, '遥遥领先', 0, '1', '2023-08-31 14:26:00', '1', '2023-08-31 14:26:00', b'0', 1), (3, '索尼', 'http://127.0.0.1:48080/admin-api/infra/file/4/get/f5b7a536306cd1180a42a2211a8212dc23de6b949d30c30d036caa063042f928.png', 2, '', 0, '1', '2023-08-31 14:39:58', '1', '2023-08-31 14:39:58', b'0', 1); COMMIT; -- ---------------------------- -- Table structure for product_browse_history -- ---------------------------- DROP TABLE IF EXISTS `product_browse_history`; CREATE TABLE `product_browse_history` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '记录编号', `user_id` bigint NOT NULL COMMENT '用户编号', `spu_id` bigint NOT NULL COMMENT '商品 SPU 编号', `user_deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '用户是否删除', `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除', `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_spuId`(`spu_id` ASC) USING BTREE, INDEX `idx_userId`(`user_id` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 140 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '商品浏览记录表'; -- ---------------------------- -- Records of product_browse_history -- ---------------------------- BEGIN; INSERT INTO `product_browse_history` (`id`, `user_id`, `spu_id`, `user_deleted`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (1, 247, 634, b'0', NULL, '2024-01-13 16:33:49', NULL, '2024-01-13 16:33:49', b'1', 1), (2, 247, 634, b'0', NULL, '2024-01-13 16:45:21', NULL, '2024-01-13 16:45:21', b'1', 1), (3, 247, 634, b'0', NULL, '2024-01-13 16:46:54', NULL, '2024-01-13 16:46:54', b'1', 1), (4, 247, 634, b'0', NULL, '2024-01-13 16:47:38', NULL, '2024-01-13 16:47:38', b'1', 1), (5, 247, 634, b'0', NULL, '2024-01-13 16:48:08', NULL, '2024-01-13 16:48:08', b'1', 1), (6, 247, 634, b'0', NULL, '2024-01-13 16:48:13', NULL, '2024-01-13 16:48:13', b'1', 1), (7, 247, 634, b'0', NULL, '2024-01-13 16:48:49', NULL, '2024-01-13 16:48:49', b'1', 1), (8, 247, 634, b'0', NULL, '2024-01-13 16:49:34', NULL, '2024-01-13 16:49:34', b'1', 1), (9, 247, 634, b'0', NULL, '2024-01-13 16:49:49', NULL, '2024-01-13 16:49:49', b'1', 1), (10, 247, 634, b'0', NULL, '2024-01-13 16:52:03', NULL, '2024-01-13 16:52:03', b'1', 1), (11, 247, 634, b'0', NULL, '2024-01-13 16:54:11', NULL, '2024-01-13 16:54:11', b'1', 1), (12, 247, 634, b'0', NULL, '2024-01-13 16:59:01', NULL, '2024-01-13 16:59:01', b'1', 1), (13, 247, 634, b'0', NULL, '2024-01-13 16:59:32', NULL, '2024-01-13 16:59:32', b'1', 1), (14, 247, 634, b'0', NULL, '2024-01-13 17:04:31', NULL, '2024-01-13 17:04:31', b'1', 1), (15, 247, 634, b'0', NULL, '2024-01-13 17:06:39', NULL, '2024-01-13 17:06:39', b'1', 1), (16, 247, 634, b'0', NULL, '2024-01-13 17:06:57', NULL, '2024-01-13 17:06:57', b'1', 1), (17, 247, 634, b'0', NULL, '2024-01-13 17:08:32', NULL, '2024-01-13 17:08:32', b'1', 1), (18, 247, 633, b'0', NULL, '2024-01-13 17:10:26', NULL, '2024-01-13 17:10:26', b'1', 1), (19, 247, 633, b'0', NULL, '2024-01-13 17:13:35', NULL, '2024-01-13 17:13:35', b'1', 1), (20, 247, 633, b'0', NULL, '2024-01-13 17:13:36', NULL, '2024-01-13 17:13:36', b'1', 1), (21, 247, 633, b'0', NULL, '2024-01-13 17:14:17', NULL, '2024-01-13 17:14:17', b'1', 1), (22, 247, 633, b'0', NULL, '2024-01-13 17:14:30', NULL, '2024-01-13 17:14:30', b'1', 1), (23, 247, 633, b'0', NULL, '2024-01-13 17:14:58', NULL, '2024-01-13 17:14:58', b'1', 1), (24, 247, 633, b'0', NULL, '2024-01-13 17:15:24', NULL, '2024-01-13 17:15:24', b'1', 1), (25, 247, 633, b'0', NULL, '2024-01-13 19:16:32', NULL, '2024-01-13 19:16:32', b'1', 1), (26, 247, 634, b'0', NULL, '2024-01-13 19:52:12', NULL, '2024-01-13 19:52:12', b'1', 1), (27, 247, 634, b'0', NULL, '2024-01-13 19:52:19', NULL, '2024-01-13 19:52:19', b'1', 1), (28, 247, 634, b'0', NULL, '2024-01-13 20:21:49', NULL, '2024-01-13 20:21:49', b'1', 1), (29, 247, 634, b'0', NULL, '2024-01-13 20:22:03', NULL, '2024-01-13 20:22:03', b'1', 1), (30, 247, 634, b'0', NULL, '2024-01-13 20:22:31', NULL, '2024-01-13 20:22:31', b'1', 1), (31, 247, 638, b'0', NULL, '2024-01-14 11:16:18', NULL, '2024-01-14 11:16:18', b'1', 1), (32, 247, 633, b'0', NULL, '2024-01-14 11:16:30', NULL, '2024-01-14 11:16:30', b'1', 1), (33, 247, 633, b'0', NULL, '2024-01-15 08:17:54', NULL, '2024-01-15 08:17:54', b'1', 1), (34, 247, 633, b'0', NULL, '2024-01-15 21:53:44', NULL, '2024-01-15 21:53:44', b'1', 1), (35, 247, 634, b'0', NULL, '2024-01-15 21:56:22', NULL, '2024-01-15 21:56:22', b'1', 1), (36, 247, 633, b'0', NULL, '2024-01-15 23:10:56', NULL, '2024-01-15 23:10:56', b'1', 1), (37, 247, 633, b'0', NULL, '2024-01-15 23:11:10', NULL, '2024-01-15 23:11:10', b'1', 1), (38, 247, 633, b'0', NULL, '2024-01-17 12:51:01', NULL, '2024-01-17 12:51:01', b'1', 1), (39, 247, 633, b'0', NULL, '2024-01-17 14:39:50', '247', '2024-01-17 14:39:50', b'1', 1), (40, 283, 634, b'0', NULL, '2024-01-17 14:40:52', NULL, '2024-01-17 14:40:52', b'1', 1), (41, 283, 634, b'0', NULL, '2024-01-17 14:41:03', NULL, '2024-01-17 14:41:03', b'0', 1), (42, 283, 633, b'0', NULL, '2024-01-17 14:41:04', NULL, '2024-01-17 14:41:04', b'1', 1), (43, 283, 633, b'0', NULL, '2024-01-17 14:42:07', NUL